[OSM-dev] Errors with populateCurrentTables=yes on refresh based on partial dataset

[Andreas Kalsch]

Using populateCurrentTables=yes on refresh will make Osmosis stop. When 
I use populateCurrentTables=no, then all is OK, but then I don't have 
updated data in the current tables. What can I do about that?

Feb 14, 2010 4:15:28 PM org.openstreetmap.osmosis.core.Osmosis run
INFO: Osmosis Version 0.31.1
Feb 14, 2010 4:15:29 PM org.openstreetmap.osmosis.core.Osmosis run
INFO: Preparing pipeline.
Feb 14, 2010 4:15:29 PM org.openstreetmap.osmosis.core.Osmosis run
INFO: Launching pipeline execution.
Feb 14, 2010 4:15:29 PM org.openstreetmap.osmosis.core.Osmosis run
INFO: Pipeline executing, waiting for completion.
ERROR:  insert or update on table "current_way_nodes" violates foreign 
key constraint "current_way_nodes_node_id_fkey"
DETAIL:  Key (node_id)=(204308) is not present in table "current_nodes".
STATEMENT:  INSERT INTO current_way_nodes (id, node_id, sequence_id) 
VALUES ($1, $2, $3)
Feb 14, 2010 4:15:50 PM 
org.openstreetmap.osmosis.core.pipeline.common.ActiveTaskManager 
waitForCompletion
SEVERE: Thread for task 1-rxc failed
org.openstreetmap.osmosis.core.OsmosisRuntimeException: Unable to insert 
current way node with way id=722 and node id=204308.
     at 
org.openstreetmap.osmosis.core.apidb.v0_6.impl.ChangeWriter.write(ChangeWriter.java:755)
     at 
org.openstreetmap.osmosis.core.apidb.v0_6.impl.ActionChangeWriter.process(ActionChangeWriter.java:56)
     at 
org.openstreetmap.osmosis.core.container.v0_6.WayContainer.process(WayContainer.java:61)
     at 
org.openstreetmap.osmosis.core.apidb.v0_6.ApidbChangeWriter.process(ApidbChangeWriter.java:67)
     at 
org.openstreetmap.osmosis.core.xml.v0_6.impl.ChangeSourceElementProcessor$ChangeSinkAdapter.process(ChangeSourceElementProcessor.java:135)
     at 
org.openstreetmap.osmosis.core.xml.v0_6.impl.WayElementProcessor.end(WayElementProcessor.java:109)
     at 
org.openstreetmap.osmosis.core.xml.v0_6.impl.OsmChangeHandler.endElement(OsmChangeHandler.java:96)
     at 
com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.endElement(Unknown 
Source)
     at 
com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanEndElement(Unknown 
Source)
     at 
com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(Unknown 
Source)
     at 
com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(Unknown 
Source)
     at 
com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown 
Source)
     at 
com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown 
Source)
     at 
com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown 
Source)
     at 
com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown Source)
     at 
com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(Unknown 
Source)
     at 
com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown 
Source)
     at javax.xml.parsers.SAXParser.parse(Unknown Source)
     at javax.xml.parsers.SAXParser.parse(Unknown Source)
     at 
org.openstreetmap.osmosis.core.xml.v0_6.XmlChangeReader.run(XmlChangeReader.java:107)
     at java.lang.Thread.run(Unknown Source)
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)=(204308) is not present in table "current_nodes".
     at 
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
     at 
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
     at 
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
     at 
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
     at 
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
     at 
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:343)
     at 
org.openstreetmap.osmosis.core.apidb.v0_6.impl.ChangeWriter.write(ChangeWriter.java:752)
     ... 20 more
Feb 14, 2010 4:15:50 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:85)
     at org.openstreetmap.osmosis.core.Osmosis.main(Osmosis.java:30)