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

[Kirill Bestoujev]

23 days??? What kind of hardware do you use???

And yes, the database is unusable, the import did not finish.

Kirill

2010/7/21 Klemens <tourality at gmail.com>:
> 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!
>
> _______________________________________________
> osmosis-dev mailing list
> osmosis-dev at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/osmosis-dev
>