search

dos-group / vs.msc.ws13

Verteilte System Master Project WS13/14
0 stars 1 forks source link

MySQL logging error #34

Open kfleischmann opened 10 years ago

kfleischmann commented 10 years ago

2014-03-24 13:21:59,410 ERROR Unable to write to database [jdbcManager{ description=databaseAppender, bufferSize=0, connectionSource=factory{ public static java.sql.Connection de.tu_berlin.citlab.logging.ConnectionFactory.getConnectionStatic() }, tableName=citstorm.log4j2, columns=[ { name=datetime, layout=%d{yyy-MM-dd HH:mm:ss}, literal=null, timestamp=false }, { name=milliseconds, layout=%d{SSS}, literal=null, timestamp=false }, { name=logger, layout=%logger, literal=null, timestamp=false }, { name=level, layout=%level, literal=null, timestamp=false }, { name=message, layout=%message, literal=null, timestamp=false }, { name=exception, layout=%exception, literal=null, timestamp=false }, { name=thread, layout=%thread, literal=null, timestamp=false }, { name=marker, layout=%marker, literal=null, timestamp=false }, { name=session, layout=096c4173-9a51-449a-a7c4-a975f043029f, literal=null, timestamp=false } ] }] for appender [databaseAppender]. org.apache.logging.log4j.core.appender.AppenderLoggingException: Failed to insert record for log event in JDBC manager: Incorrect string value: '\xF0\x9F\x92\x99\xF0\x9F...' for column 'message' at row 1 at org.apache.logging.log4j.core.appender.db.jdbc.JDBCDatabaseManager.writeInternal(JDBCDatabaseManager.java:117) at org.apache.logging.log4j.core.appender.db.AbstractDatabaseManager.write(AbstractDatabaseManager.java:159) at org.apache.logging.log4j.core.appender.db.AbstractDatabaseAppender.append(AbstractDatabaseAppender.java:103) at org.apache.logging.log4j.core.config.AppenderControl.callAppender(AppenderControl.java:97) at org.apache.logging.log4j.core.config.LoggerConfig.callAppenders(LoggerConfig.java:425) at org.apache.logging.log4j.core.config.LoggerConfig.log(LoggerConfig.java:406) at org.apache.logging.log4j.core.config.LoggerConfig.log(LoggerConfig.java:367) at org.apache.logging.log4j.core.Logger.log(Logger.java:112) at org.apache.logging.log4j.spi.AbstractLogger.info(AbstractLogger.java:1046) at de.tu_berlin.citlab.storm.spouts.TwitterSpout.nextTuple(TwitterSpout.java:105) at backtype.storm.daemon.executor$fn3985$fn3997$fn__4026.invoke(executor.clj:502) at backtype.storm.util$async_loop$fn__465.invoke(util.clj:377) at clojure.lang.AFn.run(AFn.java:24) at java.lang.Thread.run(Thread.java:744) Caused by: java.sql.SQLException: Incorrect string value: '\xF0\x9F\x92\x99\xF0\x9F...' for column 'message' at row 1 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2019) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1937) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1922) at com.jolbox.bonecp.PreparedStatementHandle.executeUpdate(PreparedStatementHandle.java:205) at org.apache.logging.log4j.core.appender.db.jdbc.JDBCDatabaseManager.writeInternal(JDBCDatabaseManager.java:112) ... 13 more

f-sander commented 10 years ago

Das sind die vier-Byte UTF8 Zeichen. Dafür existiert bereits der Branch: twitter_refactoring

f-sander commented 10 years ago

Branch ist gemergt. Mach ein pull und teste nochmal