Hi, Andreas Kalsch <[email protected]> writes: > 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?
> 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 I think I hit the same problem. Have you found any solution? Could I somehow remove references to nodes that are not inside the bounding box I am trying to mirror? sudo aptitude install postgresql-8.4 postgresql-client-8.4 postgresql-contrib-8.4 osmosis bzip2 wget http://download.geofabrik.de/osm/europe/finland.osm.bz2 sudo -u postgres psql -c "CREATE DATABASE osm ENCODING = 'UNICODE';" sudo -u postgres psql -c "CREATE USER osm PASSWORD 'osm';" sudo -u postgres psql osm -c "GRANT ALL ON SCHEMA PUBLIC TO osm;" zcat /usr/share/doc/osmosis/examples/contrib/apidb_0.6.sql.gz | sudo -u postgres psql osm -f - bzcat finland.osm.bz2 | osmosis --read-xml file=- --write-apidb password=osm user=osm dbType=postgresql osmosis --read-replication-interval-init wget -O state.txt http://toolserver.org/~mazder/replicate-sequences/?2010-05-30T00:00:00Z osmosis --read-replication-interval --simplify-change --write-xml-change changes.osc.gz osmosis --read-xml-change file=changes.osc.gz --write-apidb-change password=osm user=osm dbType=postgresql fails with 1.6.2010 22:30:58 org.openstreetmap.osmosis.core.Osmosis run INFO: Osmosis Version 0.34 log4j:WARN No appenders could be found for logger (org.java.plugin.ObjectFactory). log4j:WARN Please initialize the log4j system properly. 1.6.2010 22:30:59 org.openstreetmap.osmosis.core.Osmosis run INFO: Preparing pipeline. 1.6.2010 22:30:59 org.openstreetmap.osmosis.core.Osmosis run INFO: Launching pipeline execution. 1.6.2010 22:30:59 org.openstreetmap.osmosis.core.Osmosis run INFO: Pipeline executing, waiting for completion. 1.6.2010 22:31:31 org.openstreetmap.osmosis.core.pipeline.common.ActiveTaskManager waitForCompletion SEVERE: Thread for task 1-read-xml-change failed org.openstreetmap.osmosis.core.OsmosisRuntimeException: Unable to insert current way node with way id=4332984 and node id=26369792. 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:60) 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:134) at org.openstreetmap.osmosis.core.xml.v0_6.impl.WayElementProcessor.end(WayElementProcessor.java:116) at org.openstreetmap.osmosis.core.xml.v0_6.impl.OsmChangeHandler.endElement(OsmChangeHandler.java:94) at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.endElement(AbstractSAXParser.java:604) at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanEndElement(XMLDocumentFragmentScannerImpl.java:1759) at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2915) at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:625) at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:488) at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:812) at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:741) at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:123) at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1208) at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:525) at javax.xml.parsers.SAXParser.parse(SAXParser.java:392) at javax.xml.parsers.SAXParser.parse(SAXParser.java:195) at org.openstreetmap.osmosis.core.xml.v0_6.XmlChangeReader.run(XmlChangeReader.java:107) at java.lang.Thread.run(Thread.java:636) 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)=(26369792) is not present in table "current_nodes". at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:360) at org.openstreetmap.osmosis.core.apidb.v0_6.impl.ChangeWriter.write(ChangeWriter.java:752) ... 20 more 1.6.2010 22:31:31 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) 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:328) at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:238) at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:408) at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:351) at org.codehaus.classworlds.Launcher.main(Launcher.java:31) best regards, Timo Lindfors _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
