[OSM-dev] Osmosis error - node not present in table "current_nodes" - no bbox

Jeff Meyer jeff at gwhat.org
Thu Jan 3 20:02:43 GMT 2013


After executing:
$ osmosis --rb file="/home/historic/data/planet-natural.pbf" --wd
user="openstreetmap" password="openstreetmap" database="osm"
validateSchemaVersion=no

I'm running into the following error:
(full excerpt below)
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)=(25918312) is not present in table "current_nodes".

Most of what I can find about this on the intrawebs indicates that this is
typically a bbox-related issue, but I haven't used any bboxes to create my
planet-natural file. (see steps below)

Any guesses / suggestions / obvious things I'm missing?

Here's the sequence I've used to generate the planet-natural.pbf file - my
goal is to cut down the size of the file and retain only big waterways and
natural features - just ways and relations, no nodes. I believe osmfilter
should keep nodes required by ways and relations, but could be wrong there.

$ osmconvert planet-121226.osm.pbf -o=planet.o5m
$ ./osmfilter planet.o5m --drop-tags="created_by= nhd:*= yf:*= canvec:*=
gnis:*= NHD:*= KSJ2:*= massgis:*=" --drop-author --drop="natural=wood
waterway=drain or waterway=ditch or waterway=stream or leisure=park"
-o=planet-natural-temp1.o5m
$ ./osmfilter planet-natural-temp1.o5m --keep= --keep-ways="natural= or
waterway=" --keep-relations="natural= or waterway="
-o=planet-natural-temp2.o5m
$ ./osmconvert planet-natural-temp2.o5m -o=planet-natural.pbf

Thanks, Jeff



Osmosis error:

SEVERE: Thread for task 1-rb failed
org.openstreetmap.osmosis.core.OsmosisRuntimeException: Unable to load
current way nodes.
at
org.openstreetmap.osmosis.apidb.v0_6.ApidbWriter.populateCurrentWays(ApidbWriter.java:980)
at
org.openstreetmap.osmosis.apidb.v0_6.ApidbWriter.populateCurrentTables(ApidbWriter.java:1031)
at
org.openstreetmap.osmosis.apidb.v0_6.ApidbWriter.complete(ApidbWriter.java:1064)
at
crosby.binary.osmosis.OsmosisBinaryParser.complete(OsmosisBinaryParser.java:35)
at crosby.binary.file.BlockInputStream.process(BlockInputStream.java:37)
at crosby.binary.osmosis.OsmosisReader.run(OsmosisReader.java:45)
at java.lang.Thread.run(Thread.java:679)
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)=(25918312) is not present in table "current_nodes".
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:381)
at
org.openstreetmap.osmosis.apidb.v0_6.ApidbWriter.populateCurrentWays(ApidbWriter.java:977)
... 6 more
Jan 3, 2013 7:41:55 PM org.openstreetmap.osmosis.core.Osmosis main
SEVERE: Execution aborted.
org.openstreetmap.osmosis.core.OsmosisRuntimeException: One or more tasks
failed.
at
org.openstreetmap.osmosis.core.pipeline.common.Pipeline.waitForCompletion(Pipeline.java:146)
at org.openstreetmap.osmosis.core.Osmosis.run(Osmosis.java:92)
at org.openstreetmap.osmosis.core.Osmosis.main(Osmosis.java:37)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at
org.codehaus.plexus.classworlds.launcher.Launcher.launchStandard(Launcher.java:329)
at
org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:239)
at
org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:409)
at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:352)
at org.codehaus.classworlds.Launcher.main(Launcher.java:47)

-- 
Jeff Meyer
Global World History Atlas
www.gwhat.org
jeff at gwhat.org
206-676-2347
www.openstreetmap.org/user/jeffmeyer
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20130103/d9aa148a/attachment.html>


More information about the dev mailing list