[osmosis-dev] Osmosis crash: OsmosisRuntimeException: An output error has occurred

[Simon Nuttall]

Brett,

On 11 June 2014 04:12, Brett Henderson <brett at bretth.com> wrote:
> Is that the complete error output?  The error text you've included is the
> output from a single PBF reading thread, but there are multiple threads in
> your pipeline.  The real reason for failure should be in another stack trace
> either before or after that one.

I've looked further at the output and found this further down:

09-Jun-2014 18:10:24
org.openstreetmap.osmosis.core.pipeline.common.ActiveTaskManager
waitForCompletion
FINE: Waiting for task 84-buffer to complete.
09-Jun-2014 18:10:24
org.openstreetmap.osmosis.core.pipeline.common.ActiveTaskManager
waitForCompletion
SEVERE: Thread for task 84-buffer failed
org.openstreetmap.osmosis.core.OsmosisRuntimeException: Unable to
insert user with id 2092144 into the database.
        at org.openstreetmap.osmosis.apidb.v0_6.impl.UserManager.insertUser(UserManager.java:143)
        at org.openstreetmap.osmosis.apidb.v0_6.impl.UserManager.addOrUpdateUser(UserManager.java:191)
        at org.openstreetmap.osmosis.apidb.v0_6.ApidbWriter.process(ApidbWriter.java:1092)
        at org.openstreetmap.osmosis.core.buffer.v0_6.EntityBuffer.run(EntityBuffer.java:84)
        at java.lang.Thread.run(Thread.java:701)
Caused by: java.sql.SQLException: Incorrect string value:
'\xF0\x9F\x9A\x81\xF0\x9F...' for column 'display_name' at row 1
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2719)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2450)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2371)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2355)
        at org.openstreetmap.osmosis.apidb.v0_6.impl.UserManager.insertUser(UserManager.java:140)
        ... 4 more


By the way I'm using the latest version 0.44.

So perhaps it is a character set issue?

When I hit this error before an upgrade of MySQL fixed it, but now
we're on: MySQL server 5.5.29-0ubuntu0.12.04.2-log

Simon