<div class="postmsg">
<p>Hello,<br>I have two small areas of data (.osm files) for
Seattle, one before I made an edit and one after the edit. I downloaded an original osm file and saved it off. I then downloaded a second osm file and made edits to it with JOSM. I
posted those changes back to OSM server. I downloaded a final file
from OSM after a few minutes ( it captured my changes I see ). Now I want to create a change
set by comparing my original osm download and my final osm download.<br></p><p>When I try to create a
change set between the first osm file and the last osm file I get errors. When I
try to create a change set from PostGIS data (first osm file imported )
and last osm file I only get errors again. I've gone as far as I can
debugging this. And unfortuantely the dumps aren't very descriptive
about the problems. Any ideas?</p><p>Below are two osmosis commands and the stack dumps:</p><p># OSM FILE COMPARISON<br>1)
./osmosis --read-xml file="/WORKSPACE/osm/jsom/reup.osm" --read-xml
file="/WORKSPACE/osm/jsom/newreup.osm" --derive-change
--write-xml-change file="/WORKSPACE/osm/josm/difference.osc"<br>Feb 27, 2011 5:25:16 PM org.openstreetmap.osmosis.core.Osmosis run<br>INFO: Osmosis Version 0.38<br>Feb 27, 2011 5:25:16 PM org.openstreetmap.osmosis.core.Osmosis run<br>
INFO: Preparing pipeline.<br>Feb 27, 2011 5:25:16 PM org.openstreetmap.osmosis.core.Osmosis run<br>INFO: Launching pipeline execution.<br>Feb 27, 2011 5:25:16 PM org.openstreetmap.osmosis.core.Osmosis run<br>INFO: Pipeline executing, waiting for completion.<br>
Feb 27, 2011 5:25:16 PM org.openstreetmap.osmosis.core.pipeline.common.ActiveTaskManager waitForCompletion<br>SEVERE: Thread for task 1-read-xml failed<br>org.openstreetmap.osmosis.core.OsmosisRuntimeException: Unable to read XML file /WORKSPACE/osm/jsom/reup.osm.<br>
at org.openstreetmap.osmosis.xml.v0_6.XmlReader.run(XmlReader.java:123)<br> at java.lang.Thread.run(Thread.java:636)<br>Caused by: java.io.FileNotFoundException: /WORKSPACE/osm/jsom/reup.osm (No such file or directory)<br>
at java.io.FileInputStream.open(Native Method)<br> at java.io.FileInputStream.<init>(FileInputStream.java:137)<br> at org.openstreetmap.osmosis.xml.v0_6.XmlReader.run(XmlReader.java:98)<br> ... 1 more<br>
Feb 27, 2011 5:25:16 PM org.openstreetmap.osmosis.core.pipeline.common.ActiveTaskManager waitForCompletion<br>SEVERE: Thread for task 2-read-xml failed<br>org.openstreetmap.osmosis.core.OsmosisRuntimeException: Unable to read XML file /WORKSPACE/osm/jsom/newreup.osm.<br>
at org.openstreetmap.osmosis.xml.v0_6.XmlReader.run(XmlReader.java:123)<br> at java.lang.Thread.run(Thread.java:636)<br>Caused by: java.io.FileNotFoundException: /WORKSPACE/osm/jsom/newreup.osm (No such file or directory)<br>
at java.io.FileInputStream.open(Native Method)<br> at java.io.FileInputStream.<init>(FileInputStream.java:137)<br> at org.openstreetmap.osmosis.xml.v0_6.XmlReader.run(XmlReader.java:98)<br> ... 1 more<br>
Feb 27, 2011 5:25:16 PM org.openstreetmap.osmosis.core.pipeline.common.ActiveTaskManager waitForCompletion<br>SEVERE: Thread for task 3-derive-change failed<br>org.openstreetmap.osmosis.core.OsmosisRuntimeException: An input error has occurred, aborting.<br>
at org.openstreetmap.osmosis.core.store.DataPostbox.checkForInputErrors(DataPostbox.java:88)<br> at org.openstreetmap.osmosis.core.store.DataPostbox.consumeCentralQueue(DataPostbox.java:153)<br> at org.openstreetmap.osmosis.core.store.DataPostbox.hasNext(DataPostbox.java:235)<br>
at org.openstreetmap.osmosis.set.v0_6.ChangeDeriver.run(ChangeDeriver.java:101)<br> at java.lang.Thread.run(Thread.java:636)<br>Feb 27, 2011 5:25:16 PM org.openstreetmap.osmosis.core.Osmosis main<br>SEVERE: Execution aborted.<br>
org.openstreetmap.osmosis.core.OsmosisRuntimeException: One or more tasks failed.<br> at org.openstreetmap.osmosis.core.pipeline.common.Pipeline.waitForCompletion(Pipeline.java:146)<br> at org.openstreetmap.osmosis.core.Osmosis.run(Osmosis.java:92)<br>
at org.openstreetmap.osmosis.core.Osmosis.main(Osmosis.java:37)<br> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)<br>
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br> at java.lang.reflect.Method.invoke(Method.java:616)<br> at org.codehaus.plexus.classworlds.launcher.Launcher.launchStandard(Launcher.java:329)<br>
at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:239)<br> at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:409)<br> at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:352)<br>
at org.codehaus.classworlds.Launcher.main(Launcher.java:31)</p><br><p># OSM TO POSTGIS COMPARISON<br>2)
./osmosis --read-xml file="/WORKSPACE/osm/josm/newreup.osm"
--read-apidb host="localhost" database="seattle" user="gisuser"
password="gisuser" --derive-change --write-xml-change
file="difference.osc"<br>Feb 27, 2011 5:35:59 PM org.openstreetmap.osmosis.core.Osmosis run<br>INFO: Osmosis Version 0.38<br>Feb 27, 2011 5:35:59 PM org.openstreetmap.osmosis.core.Osmosis run<br>INFO: Preparing pipeline.<br>
Feb 27, 2011 5:35:59 PM org.openstreetmap.osmosis.core.Osmosis run<br>INFO: Launching pipeline execution.<br>Feb 27, 2011 5:35:59 PM org.openstreetmap.osmosis.core.Osmosis run<br>INFO: Pipeline executing, waiting for completion.<br>
Feb 27, 2011 5:35:59 PM org.openstreetmap.osmosis.core.pipeline.common.ActiveTaskManager waitForCompletion<br>SEVERE: Thread for task 1-read-xml failed<br>org.openstreetmap.osmosis.core.OsmosisRuntimeException: An output error has occurred, aborting.<br>
at org.openstreetmap.osmosis.core.store.DataPostbox.checkForOutputErrors(DataPostbox.java:76)<br> at org.openstreetmap.osmosis.core.store.DataPostbox.populateCentralQueue(DataPostbox.java:132)<br> at org.openstreetmap.osmosis.core.store.DataPostbox.put(DataPostbox.java:182)<br>
at org.openstreetmap.osmosis.set.v0_6.impl.DataPostboxSink.process(DataPostboxSink.java:34)<br> at org.openstreetmap.osmosis.xml.v0_6.impl.NodeElementProcessor.end(NodeElementProcessor.java:117)<br> at org.openstreetmap.osmosis.xml.v0_6.impl.OsmHandler.endElement(OsmHandler.java:107)<br>
at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)<br> at org.apache.xerces.parsers.AbstractXMLDocumentParser.emptyElement(Unknown Source)<br> at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanStartElement(Unknown Source)<br>
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)<br> at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)<br> at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)<br>
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)<br> at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)<br> at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)<br>
at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)<br> at org.apache.xerces.jaxp.SAXParserImpl.parse(Unknown Source)<br> at javax.xml.parsers.SAXParser.parse(SAXParser.java:195)<br> at org.openstreetmap.osmosis.xml.v0_6.XmlReader.run(XmlReader.java:108)<br>
at java.lang.Thread.run(Thread.java:636)<br>Feb 27, 2011 5:35:59 PM org.openstreetmap.osmosis.core.pipeline.common.ActiveTaskManager waitForCompletion<br>SEVERE: Thread for task 2-read-apidb failed<br>org.openstreetmap.osmosis.core.OsmosisRuntimeException: Unable to create resultset.<br>
at org.openstreetmap.osmosis.apidb.common.DatabaseContext.executeQuery(DatabaseContext.java:429)<br> at org.openstreetmap.osmosis.apidb.v0_6.impl.SchemaVersionValidator.validateDBVersion(SchemaVersionValidator.java:82)<br>
at org.openstreetmap.osmosis.apidb.v0_6.impl.SchemaVersionValidator.validateVersion(SchemaVersionValidator.java:55)<br> at org.openstreetmap.osmosis.apidb.v0_6.ApidbReader.runImpl(ApidbReader.java:71)<br> at org.openstreetmap.osmosis.apidb.v0_6.ApidbReader$1.doInTransactionWithoutResult(ApidbReader.java:107)<br>
at
org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33)<br> at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)<br>
at org.openstreetmap.osmosis.apidb.common.DatabaseContext2.executeWithinTransaction(DatabaseContext2.java:102)<br> at org.openstreetmap.osmosis.apidb.v0_6.ApidbReader.run(ApidbReader.java:102)<br> at java.lang.Thread.run(Thread.java:636)<br>
Caused by: org.postgresql.util.PSQLException: ERROR: relation "schema_migrations" does not exist<br> Position: 21<br> at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)<br>
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)<br> at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)<br> at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)<br>
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:353)<br> at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:252)<br> at org.openstreetmap.osmosis.apidb.common.DatabaseContext.executeQuery(DatabaseContext.java:424)<br>
... 9 more<br>Feb 27, 2011 5:35:59 PM org.openstreetmap.osmosis.core.pipeline.common.ActiveTaskManager waitForCompletion<br>SEVERE: Thread for task 3-derive-change failed<br>org.openstreetmap.osmosis.core.OsmosisRuntimeException: An input error has occurred, aborting.<br>
at org.openstreetmap.osmosis.core.store.DataPostbox.checkForInputErrors(DataPostbox.java:88)<br> at org.openstreetmap.osmosis.core.store.DataPostbox.consumeCentralQueue(DataPostbox.java:158)<br> at org.openstreetmap.osmosis.core.store.DataPostbox.hasNext(DataPostbox.java:235)<br>
at org.openstreetmap.osmosis.set.v0_6.ChangeDeriver.run(ChangeDeriver.java:101)<br> at java.lang.Thread.run(Thread.java:636)<br>Feb 27, 2011 5:35:59 PM org.openstreetmap.osmosis.core.Osmosis main<br>SEVERE: Execution aborted.<br>
org.openstreetmap.osmosis.core.OsmosisRuntimeException: One or more tasks failed.<br> at org.openstreetmap.osmosis.core.pipeline.common.Pipeline.waitForCompletion(Pipeline.java:146)<br> at org.openstreetmap.osmosis.core.Osmosis.run(Osmosis.java:92)<br>
at org.openstreetmap.osmosis.core.Osmosis.main(Osmosis.java:37)<br> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)<br>
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br> at java.lang.reflect.Method.invoke(Method.java:616)<br> at org.codehaus.plexus.classworlds.launcher.Launcher.launchStandard(Launcher.java:329)<br>
at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:239)<br> at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:409)<br> at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:352)<br>
at org.codehaus.classworlds.Launcher.main(Launcher.java:31)<br>postgres@twinkie:~/Downloads/osmosis-0.38/bin$</p>
</div><br><br>