[osmosis-dev] ERROR: insert or update on table "current_way_nodes"

Klemens tourality at gmail.com
Wed Jul 21 11:48:53 BST 2010


Hi,

After 23 days of importing of planet.osm the task stopped with the
following exception:

Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on
table "current_way_nodes" violates foreign key constraint
"current_way_nodes_node_id_fkey"
  Detail: Key (node_id)=(382854907) is not present in table "current_nodes".

Here's the call I used:
bzcat planet-100623.osm.bz2 | /root/install/osmosis-0.34/bin/osmosis
--read-xml-0.6 file=- --write-apidb-0.6 populateCurrentTables=yes
host="localhost" database="..." user="..." password="..."
validateSchemaVersion=no

The size of the DB was already 500 GB. I only need to a read-only DB do
get nodes and ways using the rails_port. But probably this means that
the DB is unusable now that the task didn't finish?

Thanks!




More information about the osmosis-dev mailing list