[osmosis-dev] read-pbf output error after upgrade from 0.39 to 0.40.1

[Brett Henderson]

Hi Simon,

The relevant error in your full log is below.  All other errors in the log
are caused by other threads failing when they can't write to their
destination (ie. the db writing thread is downstream of all other threads).

SEVERE: Thread for task 25-buffer failed
> org.openstreetmap.osmosis.
core.OsmosisRuntimeException: Unable to
> insert a new changeset for user with id -1.
>        at
org.openstreetmap.osmosis.apidb.v0_6.impl.ChangesetManager.addChangeset(ChangesetManager.java:160)
>        at
org.openstreetmap.osmosis.apidb.v0_6.impl.ChangesetManager.addChangesetIfRequired(ChangesetManager.java:175)
>        at
org.openstreetmap.osmosis.apidb.v0_6.ApidbWriter.process(ApidbWriter.java:1084)
>        at
org.openstreetmap.osmosis.core.buffer.v0_6.EntityBuffer.run(EntityBuffer.java:74)
>        at java.lang.Thread.run(Thread.java:679)
> Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
> Unknown column 'changeset_id' in 'field list'
>        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
>        at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
>        at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
>        at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
>        at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
>        at com.mysql.jdbc.Util.getInstance(Util.java:386)
>        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
>        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)
>        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
>        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)
>        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)
>        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624)
>        at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127)
>        at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2427)
>        at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2345)
>        at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2330)
>        at
org.openstreetmap.osmosis.apidb.v0_6.impl.ChangesetManager.addChangeset(ChangesetManager.java:148)
>        ... 4 more

There were some changes made to the apidb schema recently where columns
named "id" were renamed to "xxxx_id".  For example, the nodes table now
contains a node_id column instead of id column.  I'm guessing this is what
is tripping you up.

Do you have to use MySQL?  Osmosis still contains the MySQL but it is no
longer tested.  It may be necessary to update the MySQL schema to match the
PostgreSQL schema.

Brett
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/osmosis-dev/attachments/20120215/49d937b3/attachment.html>