<div dir="ltr"><div>Hello,</div><div><br></div><div>Link to the topic on the OSM Help (questions): <a href="https://help.openstreetmap.org/questions/40180/osmosis-invalid-mysql-schema">https://help.openstreetmap.org/questions/40180/osmosis-invalid-mysql-schema</a></div><div><br></div><div><br></div><div>Problem:</div><div><br></div><div>I downloaded the latest osmosis and I have the following MySQL database schema: <a href="http://91.239.67.150/db.sql" target="_blank">http://91.239.67.150/db.sql</a>.<br></div><br>The problem lies in the fact that something this database is not compatible with my version of osmosis. With "validateSchemaVersion = yes" the program returns to me:<br>root@vz32970:~/osm# osmosis --read-xml file="liechtenstein-latest.osm.bz2" --write-apidb-0.6 host="localhost" dbType="mysql" database="liechtenstein" user="root" password="pass" validateSchemaVersion=yes<br>Jan 09, 2015 5:08:36 PM org.openstreetmap.osmosis.core.Osmosis run<br>INFO: Osmosis Version 0.40.1<br>Jan 09, 2015 5:08:36 PM org.openstreetmap.osmosis.core.Osmosis run<br>INFO: Preparing pipeline.<br>Jan 09, 2015 5:08:36 PM org.openstreetmap.osmosis.core.Osmosis run<br>INFO: Launching pipeline execution.<br>Jan 09, 2015 5:08:36 PM org.openstreetmap.osmosis.core.Osmosis run<br>INFO: Pipeline executing, waiting for completion.<br>Jan 09, 2015 5:08:37 PM org.openstreetmap.osmosis.core.pipeline.common.ActiveTaskManager waitForCompletion<br>SEVERE: Thread for task 1-read-xml failed<br>org.openstreetmap.osmosis.core.OsmosisRuntimeException: Database version mismatch. The schema is missing migrations [20110925112722, 35, 36, 33, 34, 39, 37, 38, 20100516124737, 43, 42, 41, 40, 20100910084426, 26, 27, 28, 29, 30, 32, 31, 20111116184519, 20110322001319, 20101114011429, 20100513171259, 49, 48, 45, 44, 47, 46, 51, 52, 50], may need to upgrade schema or specify validateSchemaVersion=no.<br>    at org.openstreetmap.osmosis.apidb.v0_6.impl.SchemaVersionValidator.validateDBVersion(SchemaVersionValidator.java:119)<br>    at org.openstreetmap.osmosis.apidb.v0_6.impl.SchemaVersionValidator.validateVersion(SchemaVersionValidator.java:55)<br>    at org.openstreetmap.osmosis.apidb.v0_6.ApidbWriter.initialize(ApidbWriter.java:323)<br>    at org.openstreetmap.osmosis.apidb.v0_6.ApidbWriter.process(ApidbWriter.java:1080)<br>    at org.openstreetmap.osmosis.xml.v0_6.impl.NodeElementProcessor.end(NodeElementProcessor.java:118)<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:189)<br>    at org.openstreetmap.osmosis.xml.v0_6.XmlReader.run(XmlReader.java:108)<br>    at java.lang.Thread.run(Thread.java:745)<br><br>Jan 09, 2015 5:08:37 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:328)<br>    at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:238)<br>    at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:408)<br>    at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:351)<br>    at org.codehaus.classworlds.Launcher.main(Launcher.java:31)<br><br>In contrast, when I set "validateSchemaVersion = no", I get the error:<br>root@vz32970:~/osm# osmosis --read-xml file="liechtenstein-latest.osm.bz2" --write-apidb-0.6 host="localhost" dbType="mysql" database="liechtenstein" user="root" password="PASS" validateSchemaVersion=no <br>Jan 09, 2015 5:14:31 PM org.openstreetmap.osmosis.core.Osmosis run<br>INFO: Osmosis Version 0.40.1<br>Jan 09, 2015 5:14:32 PM org.openstreetmap.osmosis.core.Osmosis run<br>INFO: Preparing pipeline.<br>Jan 09, 2015 5:14:32 PM org.openstreetmap.osmosis.core.Osmosis run<br>INFO: Launching pipeline execution.<br>Jan 09, 2015 5:14:32 PM org.openstreetmap.osmosis.core.Osmosis run<br>INFO: Pipeline executing, waiting for completion.<br>Jan 09, 2015 5:15:49 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 load current nodes.<br>    at org.openstreetmap.osmosis.apidb.v0_6.ApidbWriter.populateCurrentNodes(ApidbWriter.java:928)<br>    at org.openstreetmap.osmosis.apidb.v0_6.ApidbWriter.populateCurrentTables(ApidbWriter.java:1029)<br>    at org.openstreetmap.osmosis.apidb.v0_6.ApidbWriter.complete(ApidbWriter.java:1055)<br>    at org.openstreetmap.osmosis.xml.v0_6.XmlReader.run(XmlReader.java:110)<br>    at java.lang.Thread.run(Thread.java:745)<br>Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '26032956' for key 'PRIMARY'<br>    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)<br>    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)<br>    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)<br>    at java.lang.reflect.Constructor.newInstance(Constructor.java:526)<br>    at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)<br>    at com.mysql.jdbc.Util.getInstance(Util.java:386)<br>    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1040)<br>    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)<br>    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)<br>    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)<br>    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)<br>    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)<br>    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)<br>    at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362)<br>    at org.openstreetmap.osmosis.apidb.v0_6.ApidbWriter.populateCurrentNodes(ApidbWriter.java:925)<br>    ... 4 more<br><br>Jan 09, 2015 5:15:49 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:328)<br>    at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:238)<br>    at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:408)<br>    at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:351)<br>    at org.codehaus.classworlds.Launcher.main(Launcher.java:31)<br><br>Load about 71.3 MB database Liechtenstein but the whole thing does not want to ... What am I doing wrong? Something is incorrect in the database<br></div>