[OSM-dev] Osmosis error, duplicate

[Ed Loach]

Jeff:

> OK, that makes sense. But then what is the error:
> 
>   Detail: Key (node_id)=(395051992) is not present in 
> table "current_nodes".
> 
> from? That's what crashed my import. I'm trying to find where
Osmosis 
> requests a node_id from current_nodes; or am I misreading the
error?

The foreign key constraint will check as each way is imported that
the nodes that form the way are already in the nodes table. If they
don't then the import will not allow that way to be imported, due to
an error like that quoted. I'm assuming that under normal
circumstances the import imports all the nodes first, then all the
ways, so this should be OK I would have thought.

The node
http://www.openstreetmap.org/browse/node/395051992
seems fairly new, and is part of one way
http://www.openstreetmap.org/browse/way/3454211
Both look OK there, but if for whatever reason you have the way to
import but not the node then you will get the foreign key violation
error.

Ed