<div dir="ltr">Hi Pawel,<div><br></div><div>So my command it's looks like this:</div><div><br></div><div><div>sudo bin/osmosis --read-xml-change file="/home/adityo/osmchangeset/674.o5m" --write-pgsql-change user="osmuser" database="osm" password="osmuser"</div><div><br></div><div>but i got another new error that the osmosis is unable to parse the xml file. I download the changeset from geofabrik and using gunzip to unpack the osc.gz file. After that i'm using command:</div><div><br></div><div>osmconvert 674.osc --out-o5m > 674.o5m</div><div><br></div><div>But i notice that i got different size file between 674.osc (which is 4,434 KiB) and 674.o5m (which is only 237 KiB).</div><div><br></div><div>Is the error i got when i run osmosis is because i convert the .osc file with wrong command?</div><div><br></div><div>Regards,</div><div><br></div><div>Adityo</div><div><br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">Jan 15, 2015 5:02:15 PM org.openstreetmap.osmosis.core.Osmosis run<br>INFO: Osmosis Version 0.43.1<br>Jan 15, 2015 5:02:15 PM org.java.plugin.registry.xml.ManifestParser <init><br>INFO: got SAX parser factory - org.apache.xerces.jaxp.SAXParserFactoryImpl@42ad08de<br>Jan 15, 2015 5:02:15 PM org.java.plugin.registry.xml.PluginRegistryImpl configure<br>INFO: configured, stopOnError=false, isValidating=true<br>Jan 15, 2015 5:02:15 PM org.java.plugin.registry.xml.PluginRegistryImpl register<br>INFO: plug-in and fragment descriptors registered - 1<br>Jan 15, 2015 5:02:15 PM org.java.plugin.standard.StandardPluginManager activatePlugin<br>INFO: plug-in started - org.openstreetmap.osmosis.core.plugin.Core@0.0.0.42-6-gf39a160-dirty<br>Jan 15, 2015 5:02:15 PM org.openstreetmap.osmosis.core.Osmosis run<br>INFO: Preparing pipeline.<br>Jan 15, 2015 5:02:15 PM org.openstreetmap.osmosis.core.Osmosis run<br>INFO: Launching pipeline execution.<br>Jan 15, 2015 5:02:15 PM org.openstreetmap.osmosis.core.Osmosis run<br>INFO: Pipeline executing, waiting for completion.<br>Jan 15, 2015 5:02:15 PM org.openstreetmap.osmosis.core.pipeline.common.ActiveTaskManager waitForCompletion<br>SEVERE: Thread for task 1-read-xml-change failed<br>org.openstreetmap.osmosis.core.OsmosisRuntimeException: Unable to parse xml file /home/hotosm/osmchangeset/674.o5m. publicId=(null), systemId=(null), lineNumber=1, columnNumber=1.<br> at org.openstreetmap.osmosis.xml.v0_6.XmlChangeReader.run(XmlChangeReader.java:114)<br> at java.lang.Thread.run(Thread.java:745)<br>Caused by: org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 1; Invalid byte 1 of 1-byte UTF-8 sequence.<br> at org.apache.xerces.util.ErrorHandlerWrapper.createSAXParseException(Unknown Source)<br> at org.apache.xerces.util.ErrorHandlerWrapper.fatalError(Unknown Source)<br> at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source)<br> at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source)<br> at org.apache.xerces.impl.XMLVersionDetector.determineDocVersion(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.XmlChangeReader.run(XmlChangeReader.java:109)<br> ... 1 more<br>Caused by: org.apache.xerces.impl.io.MalformedByteSequenceException: Invalid byte 1 of 1-byte UTF-8 sequence.<br> at org.apache.xerces.impl.io.UTF8Reader.invalidByte(Unknown Source)<br> at org.apache.xerces.impl.io.UTF8Reader.read(Unknown Source)<br> at org.apache.xerces.impl.XMLEntityScanner.load(Unknown Source)<br> at org.apache.xerces.impl.XMLEntityScanner.skipString(Unknown Source)<br> ... 10 more<br>Jan 15, 2015 5:02:15 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:606)<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:47)</blockquote></div><div><br></div></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature"><div dir="ltr"><b>Adityo Dwijananto S. Si</b><div><font face="trebuchet ms, sans-serif" color="#ff0000"><b><i>Humanitarian OpenStreetMap Team</i></b></font></div><div><font color="#000000" face="trebuchet ms, sans-serif">Email<i>:</i></font></div><div><font face="trebuchet ms, sans-serif" color="#0000ff"><b><i><u><a href="mailto:adityo.dwijananto@hotosm.org" target="_blank">adityo.dwijananto@hotosm.org</a></u></i></b></font><br>Phone:</div><div>+62812 8654 7434</div></div></div></div>
<br><div class="gmail_quote">On Thu, Jan 15, 2015 at 4:04 PM, Paweł Paprota <span dir="ltr"><<a href="mailto:ppawel@fastmail.fm" target="_blank">ppawel@fastmail.fm</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">--read-xml-change produces changes so you need to use<br>
--write-pgsql-change not --write-pgsql to write them to the database.<br>
<br>
Paweł<br>
<span class=""><br>
<br>
On Thu, Jan 15, 2015, at 09:01, Adityo Dwijananto wrote:<br>
> Hi All,<br>
><br>
> i'm trying to using osmosis to update my database with osm changeset. But when i try to run this script:<br>
><br>
</span>> *~/osmosis-latest$ sudo bin/osmosis --read-xml-change file="~/osmchangeset/674.osm" --write-pgsql user="osmuser" database="osm" password="osmuser"*<br>
> **<br>
<div><div class="h5">> I got an error like this: <br>
><br>
>> Jan 15, 2015 2:44:10 PM org.openstreetmap.osmosis.core.Osmosis run<br>
>> INFO: Osmosis Version 0.43.1<br>
>> Jan 15, 2015 2:44:10 PM org.java.plugin.registry.xml.ManifestParser <init><br>
>> INFO: got SAX parser factory - org.apache.xerces.jaxp.SAXParserFactoryImpl@4b40de18<br>
>> Jan 15, 2015 2:44:10 PM org.java.plugin.registry.xml.PluginRegistryImpl configure<br>
>> INFO: configured, stopOnError=false, isValidating=true<br>
>> Jan 15, 2015 2:44:11 PM org.java.plugin.registry.xml.PluginRegistryImpl register<br>
>> INFO: plug-in and fragment descriptors registered - 1<br>
>> Jan 15, 2015 2:44:11 PM org.java.plugin.standard.StandardPluginManager activatePlugin<br>
>> INFO: plug-in started - org.openstreetmap.osmosis.core.plugin.Core@0.0.0.42-6-gf39a160-dirty<br>
>> Jan 15, 2015 2:44:11 PM org.openstreetmap.osmosis.core.Osmosis run<br>
>> INFO: Preparing pipeline.<br>
>> Jan 15, 2015 2:44:11 PM org.openstreetmap.osmosis.core.Osmosis main<br>
>> SEVERE: Execution aborted.<br>
>> org.openstreetmap.osmosis.core.OsmosisRuntimeException: Task 2-write-pgsql does not support data provided by default pipe stored at level 1 in the default pipe stack.<br>
>> at org.openstreetmap.osmosis.core.pipeline.common.PipeTasks.retrieveTask(PipeTasks.java:157)<br>
>> at org.openstreetmap.osmosis.core.pipeline.common.TaskManager.getInputTask(TaskManager.java:165)<br>
>> at org.openstreetmap.osmosis.core.pipeline.v0_6.SinkManager.connect(SinkManager.java:50)<br>
>> at org.openstreetmap.osmosis.core.pipeline.common.Pipeline.connectTasks(Pipeline.java:74)<br>
>> at org.openstreetmap.osmosis.core.pipeline.common.Pipeline.prepare(Pipeline.java:116)<br>
>> at org.openstreetmap.osmosis.core.Osmosis.run(Osmosis.java:86)<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:606)<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:47)<br>
><br>
> I'm using Ubuntu 14.04 server with Postgres 9.3 and postgis 2.1.2. I tried to use both simple schema and snapshot schema but it's always got an error like i mention above. Can someone help me? Thanks<br>
><br>
> Regards,<br>
><br>
> Adityo<br>
</div></div>> _________________________________________________<br>
> osmosis-dev mailing list<br>
> <a href="mailto:osmosis-dev@openstreetmap.org">osmosis-dev@openstreetmap.org</a><br>
> <a href="https://lists.openstreetmap.org/listinfo/osmosis-dev" target="_blank">https://lists.openstreetmap.org/listinfo/osmosis-dev</a><br>
<br>
_______________________________________________<br>
osmosis-dev mailing list<br>
<a href="mailto:osmosis-dev@openstreetmap.org">osmosis-dev@openstreetmap.org</a><br>
<a href="https://lists.openstreetmap.org/listinfo/osmosis-dev" target="_blank">https://lists.openstreetmap.org/listinfo/osmosis-dev</a><br>
</blockquote></div><br></div>