2007-03-03T14:38:46.222Z Information Starting JDBC connection pool.
2007-03-03T19:01:52.878Z Error SQL: CALL dc_varchar_insert(?,?,?)
PARAMS: (Integer): '7150' (String): 'true' (Timestamp): '2007-03-03 20:02:05.332'
ErrorCode: 0
com.mysql.util.jdbctemplate.SQLRuntimeException: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.net.SocketException
MESSAGE: Software caused connection abort: recv failed
STACKTRACE:
java.net.SocketException: Software caused connection abort: recv failed
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:129)
at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:113)
at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:160)
at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:188)
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1910)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2304)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2803)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3176)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1153)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1404)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1318)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1303)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
at com.mysql.util.jdbctemplate.JDBCTemplate.executeUpdate(JDBCTemplate.java:124)
at com.mysql.merlin.server.collect.dao.ItemsOperations.writeDataCollection(ItemsOperations.java:919)
at com.mysql.merlin.server.collect.dao.SingleThreadedDelayedWriter.writeDcAndPost(SingleThreadedDelayedWriter.java:137)
at com.mysql.merlin.server.collect.dao.SingleThreadedDelayedWriter.access$100(SingleThreadedDelayedWriter.java:13)
at com.mysql.merlin.server.collect.dao.SingleThreadedDelayedWriter$2.exec(SingleThreadedDelayedWriter.java:131)
at com.mysql.merlin.server.db.VoidDatabaseAction.execute(VoidDatabaseAction.java:11)
at com.mysql.util.jdbctemplate.ActionExecutor.execute(ActionExecutor.java:57)
at com.mysql.merlin.server.db.GeneralOperations.execute(GeneralOperations.java:95)
at com.mysql.merlin.server.collect.dao.SingleThreadedDelayedWriter.writeDcTransaction(SingleThreadedDelayedWriter.java:129)
at com.mysql.merlin.server.collect.dao.SingleThreadedDelayedWriter.writeDc(SingleThreadedDelayedWriter.java:119)
at com.mysql.merlin.server.collect.dao.SingleThreadedDelayedWriter.writeLoop(SingleThreadedDelayedWriter.java:70)
at com.mysql.merlin.server.collect.dao.SingleThreadedDelayedWriter.access$000(SingleThreadedDelayedWriter.java:13)
at com.mysql.merlin.server.collect.dao.SingleThreadedDelayedWriter$1.run(SingleThreadedDelayedWriter.java:38)
** END NESTED EXCEPTION **
Last packet sent to the server was 0 ms ago.
at com.mysql.util.jdbctemplate.JDBCTemplate.executeUpdate(JDBCTemplate.java:126)
at com.mysql.merlin.server.collect.dao.ItemsOperations.writeDataCollection(ItemsOperations.java:919)
at com.mysql.merlin.server.collect.dao.SingleThreadedDelayedWriter.writeDcAndPost(SingleThreadedDelayedWriter.java:137)
at com.mysql.merlin.server.collect.dao.SingleThreadedDelayedWriter.access$100(SingleThreadedDelayedWriter.java:13)
at com.mysql.merlin.server.collect.dao.SingleThreadedDelayedWriter$2.exec(SingleThreadedDelayedWriter.java:131)
at com.mysql.merlin.server.db.VoidDatabaseAction.execute(VoidDatabaseAction.java:11)
at com.mysql.util.jdbctemplate.ActionExecutor.execute(ActionExecutor.java:57)
at com.mysql.merlin.server.db.GeneralOperations.execute(GeneralOperations.java:95)
at com.mysql.merlin.server.collect.dao.SingleThreadedDelayedWriter.writeDcTransaction(SingleThreadedDelayedWriter.java:129)
at com.mysql.merlin.server.collect.dao.SingleThreadedDelayedWriter.writeDc(SingleThreadedDelayedWriter.java:119)
at com.mysql.merlin.server.collect.dao.SingleThreadedDelayedWriter.writeLoop(SingleThreadedDelayedWriter.java:70)
at com.mysql.merlin.server.collect.dao.SingleThreadedDelayedWriter.access$000(SingleThreadedDelayedWriter.java:13)
at com.mysql.merlin.server.collect.dao.SingleThreadedDelayedWriter$1.run(SingleThreadedDelayedWriter.java:38)
Caused by: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.net.SocketException
MESSAGE: Software caused connection abort: recv failed
STACKTRACE:
java.net.SocketException: Software caused connection abort: recv failed
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:129)
at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:113)
at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:160)
at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:188)
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1910)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2304)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2803)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3176)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1153)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1404)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1318)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1303)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
at com.mysql.util.jdbctemplate.JDBCTemplate.executeUpdate(JDBCTemplate.java:124)
at com.mysql.merlin.server.collect.dao.ItemsOperations.writeDataCollection(ItemsOperations.java:919)
at com.mysql.merlin.server.collect.dao.SingleThreadedDelayedWriter.writeDcAndPost(SingleThreadedDelayedWriter.java:137)
at com.mysql.merlin.server.collect.dao.SingleThreadedDelayedWriter.access$100(SingleThreadedDelayedWriter.java:13)
at com.mysql.merlin.server.collect.dao.SingleThreadedDelayedWriter$2.exec(SingleThreadedDelayedWriter.java:131)
at com.mysql.merlin.server.db.VoidDatabaseAction.execute(VoidDatabaseAction.java:11)
at com.mysql.util.jdbctemplate.ActionExecutor.execute(ActionExecutor.java:57)
at com.mysql.merlin.server.db.GeneralOperations.execute(GeneralOperations.java:95)
at com.mysql.merlin.server.collect.dao.SingleThreadedDelayedWriter.writeDcTransaction(SingleThreadedDelayedWriter.java:129)
at com.mysql.merlin.server.collect.dao.SingleThreadedDelayedWriter.writeDc(SingleThreadedDelayedWriter.java:119)
at com.mysql.merlin.server.collect.dao.SingleThreadedDelayedWriter.writeLoop(SingleThreadedDelayedWriter.java:70)
at com.mysql.merlin.server.collect.dao.SingleThreadedDelayedWriter.access$000(SingleThreadedDelayedWriter.java:13)
at com.mysql.merlin.server.collect.dao.SingleThreadedDelayedWriter$1.run(SingleThreadedDelayedWriter.java:38)
** END NESTED EXCEPTION **
Last packet sent to the server was 0 ms ago.
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2803)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3176)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1153)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1404)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1318)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1303)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
at com.mysql.util.jdbctemplate.JDBCTemplate.executeUpdate(JDBCTemplate.java:124)
... 12 more
2007-03-03T19:01:52.894Z Information ROLLBACK:
SQL: CALL dc_varchar_insert(?,?,?)
PARAMS: (class java.lang.Integer): '7150' (class java.lang.String): 'true' (class java.sql.Timestamp): '2007-03-03 20:02:05.332'
2007-03-03T19:01:52.894Z Error SQL: CALL dc_varchar_insert(?,?,?)
PARAMS: (Integer): '7150' (String): 'true' (Timestamp): '2007-03-03 20:02:05.332'
ErrorCode: 0
com.mysql.util.jdbctemplate.SQLRuntimeException: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.net.SocketException
MESSAGE: Software caused connection abort: recv failed
STACKTRACE:
java.net.SocketException: Software caused connection abort: recv failed
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:129)
at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:113)
at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:160)
at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:188)
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1910)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2304)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2803)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3176)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1153)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1404)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1318)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1303)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
at com.mysql.util.jdbctemplate.JDBCTemplate.executeUpdate(JDBCTemplate.java:124)
at com.mysql.merlin.server.collect.dao.ItemsOperations.writeDataCollection(ItemsOperations.java:919)
at com.mysql.merlin.server.collect.dao.SingleThreadedDelayedWriter.writeDcAndPost(SingleThreadedDelayedWriter.java:137)
at com.mysql.merlin.server.collect.dao.SingleThreadedDelayedWriter.access$100(SingleThreadedDelayedWriter.java:13)
at com.mysql.merlin.server.collect.dao.SingleThreadedDelayedWriter$2.exec(SingleThreadedDelayedWriter.java:131)
at com.mysql.merlin.server.db.VoidDatabaseAction.execute(VoidDatabaseAction.java:11)
at com.mysql.util.jdbctemplate.ActionExecutor.execute(ActionExecutor.java:57)
at com.mysql.merlin.server.db.GeneralOperations.execute(GeneralOperations.java:95)
at com.mysql.merlin.server.collect.dao.SingleThreadedDelayedWriter.writeDcTransaction(SingleThreadedDelayedWriter.java:129)
at com.mysql.merlin.server.collect.dao.SingleThreadedDelayedWriter.writeDc(SingleThreadedDelayedWriter.java:119)
at com.mysql.merlin.server.collect.dao.SingleThreadedDelayedWriter.writeLoop(SingleThreadedDelayedWriter.java:70)
at com.mysql.merlin.server.collect.dao.SingleThreadedDelayedWriter.access$000(SingleThreadedDelayedWriter.java:13)
at com.mysql.merlin.server.collect.dao.SingleThreadedDelayedWriter$1.run(SingleThreadedDelayedWriter.java:38)
** END NESTED EXCEPTION **
Last packet sent to the server was 0 ms ago.
at com.mysql.util.jdbctemplate.JDBCTemplate.executeUpdate(JDBCTemplate.java:126)
at com.mysql.merlin.server.collect.dao.ItemsOperations.writeDataCollection(ItemsOperations.java:919)
at com.mysql.merlin.server.collect.dao.SingleThreadedDelayedWriter.writeDcAndPost(SingleThreadedDelayedWriter.java:137)
at com.mysql.merlin.server.collect.dao.SingleThreadedDelayedWriter.access$100(SingleThreadedDelayedWriter.java:13)
at com.mysql.merlin.server.collect.dao.SingleThreadedDelayedWriter$2.exec(SingleThreadedDelayedWriter.java:131)
at com.mysql.merlin.server.db.VoidDatabaseAction.execute(VoidDatabaseAction.java:11)
at com.mysql.util.jdbctemplate.ActionExecutor.execute(ActionExecutor.java:57)
at com.mysql.merlin.server.db.GeneralOperations.execute(GeneralOperations.java:95)
at com.mysql.merlin.server.collect.dao.SingleThreadedDelayedWriter.writeDcTransaction(SingleThreadedDelayedWriter.java:129)
at com.mysql.merlin.server.collect.dao.SingleThreadedDelayedWriter.writeDc(SingleThreadedDelayedWriter.java:119)
at com.mysql.merlin.server.collect.dao.SingleThreadedDelayedWriter.writeLoop(SingleThreadedDelayedWriter.java:70)
at com.mysql.merlin.server.collect.dao.SingleThreadedDelayedWriter.access$000(SingleThreadedDelayedWriter.java:13)
at com.mysql.merlin.server.collect.dao.SingleThreadedDelayedWriter$1.run(SingleThreadedDelayedWriter.java:38)
Caused by: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.net.SocketException
MESSAGE: Software caused connection abort: recv failed
STACKTRACE:
java.net.SocketException: Software caused connection abort: recv failed
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:129)
at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:113)
at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:160)
at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:188)
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1910)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2304)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2803)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3176)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1153)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1404)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1318)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1303)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
at com.mysql.util.jdbctemplate.JDBCTemplate.executeUpdate(JDBCTemplate.java:124)
at com.mysql.merlin.server.collect.dao.ItemsOperations.writeDataCollection(ItemsOperations.java:919)
at com.mysql.merlin.server.collect.dao.SingleThreadedDelayedWriter.writeDcAndPost(SingleThreadedDelayedWriter.java:137)
at com.mysql.merlin.server.collect.dao.SingleThreadedDelayedWriter.access$100(SingleThreadedDelayedWriter.java:13)
at com.mysql.merlin.server.collect.dao.SingleThreadedDelayedWriter$2.exec(SingleThreadedDelayedWriter.java:131)
at com.mysql.merlin.server.db.VoidDatabaseAction.execute(VoidDatabaseAction.java:11)
at com.mysql.util.jdbctemplate.ActionExecutor.execute(ActionExecutor.java:57)
at com.mysql.merlin.server.db.GeneralOperations.execute(GeneralOperations.java:95)
at com.mysql.merlin.server.collect.dao.SingleThreadedDelayedWriter.writeDcTransaction(SingleThreadedDelayedWriter.java:129)
at com.mysql.merlin.server.collect.dao.SingleThreadedDelayedWriter.writeDc(SingleThreadedDelayedWriter.java:119)
at com.mysql.merlin.server.collect.dao.SingleThreadedDelayedWriter.writeLoop(SingleThreadedDelayedWriter.java:70)
at com.mysql.merlin.server.collect.dao.SingleThreadedDelayedWriter.access$000(SingleThreadedDelayedWriter.java:13)
at com.mysql.merlin.server.collect.dao.SingleThreadedDelayedWriter$1.run(SingleThreadedDelayedWriter.java:38)
** END NESTED EXCEPTION **
Last packet sent to the server was 0 ms ago.
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2803)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3176)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1153)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1404)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1318)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1303)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
at com.mysql.util.jdbctemplate.JDBCTemplate.executeUpdate(JDBCTemplate.java:124)
... 12 more