mrnuxi
4 post(s)
|
Right when an auction ended on which I had a multisnipe (my bid was lower than the high bid at the time of the snipe), I saw a bunch of messages streaming by in the log. It turned out to be a stack trace. jbidwatcher had no externally visible effects from this and seems unaffected.
Running jbidwatcher 2.5-0-g8f10beb on:
OS Centos 5.7 (kernel 2.6.18-308.4.1.el5)
java $ java -version
java version “1.7.0_03”
Java™ SE Runtime Environment (build 1.7.0_03-b04)
Java HotSpot™ 64-Bit Server VM (build 22.1-b02, mixed mode)
Right around the time an auction ended (multisnipe) I got the following stacktrace:
java.sql.SQLException: An attempt was made to put a data value of type ‘int’ into a data value of type ‘TIMESTAMP’.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.noStateChangeException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.setInt(Unknown Source)
at com.jbidwatcher.util.db.Table.setColumn(Table.java:507)
at com.jbidwatcher.util.db.Table.setPreparedUpdate(Table.java:463)
at com.jbidwatcher.util.db.Table.updateMap(Table.java:329)
at com.jbidwatcher.util.db.Table.insertOrUpdate(Table.java:302)
at com.jbidwatcher.util.db.ActiveRecord.saveDB(ActiveRecord.java:116)
at com.jbidwatcher.auction.AuctionEntry.saveDB(AuctionEntry.java:1550)
at com.jbidwatcher.auction.AuctionEntry.setNeedsUpdate(AuctionEntry.java:1044)
at com.jbidwatcher.auction.AuctionEntry.checkEnded(AuctionEntry.java:268)
at com.jbidwatcher.auction.AuctionEntry.setAuctionInfo(AuctionEntry.java:1361)
at com.jbidwatcher.auction.server.AuctionServer.reload(AuctionServer.java:194)
at com.jbidwatcher.auction.AuctionEntry.update(AuctionEntry.java:901)
at com.jbidwatcher.auction.Auctions.doUpdate(Auctions.java:92)
at com.jbidwatcher.ui.AuctionsManager.updateList(AuctionsManager.java:130)
at com.jbidwatcher.ui.AuctionsManager.check(AuctionsManager.java:107)
at com.jbidwatcher.util.queue.TimerHandler.run(TimerHandler.java:62)
Caused by: java.sql.SQLException: An attempt was made to put a data value of type ‘int’ into a data value of type ‘TIMESTAMP’.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
… 20 more
Caused by: ERROR XCL12: An attempt was made to put a data value of type ‘int’ into a data value of type ‘TIMESTAMP’.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.iapi.types.DataType.throwLangSetMismatch(Unknown Source)
at org.apache.derby.iapi.types.DataType.setValue(Unknown Source)
… 16 more
Sat May 12 09:08:17 MDT 2012: Error from columns: (2,category_id, INTEGER, 2)
java.sql.SQLException: An attempt was made to put a data value of type ‘short’ into a data value of type ‘TIMESTAMP’.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.noStateChangeException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.setShort(Unknown Source)
at com.jbidwatcher.util.db.Table.setColumn(Table.java:515)
at com.jbidwatcher.util.db.Table.setPreparedUpdate(Table.java:463)
at com.jbidwatcher.util.db.Table.updateMap(Table.java:329)
at com.jbidwatcher.util.db.Table.insertOrUpdate(Table.java:302)
at com.jbidwatcher.util.db.ActiveRecord.saveDB(ActiveRecord.java:116)
at com.jbidwatcher.auction.AuctionEntry.saveDB(AuctionEntry.java:1550)
at com.jbidwatcher.auction.AuctionEntry.setNeedsUpdate(AuctionEntry.java:1044)
at com.jbidwatcher.auction.AuctionEntry.checkEnded(AuctionEntry.java:268)
at com.jbidwatcher.auction.AuctionEntry.setAuctionInfo(AuctionEntry.java:1361)
at com.jbidwatcher.auction.server.AuctionServer.reload(AuctionServer.java:194)
at com.jbidwatcher.auction.AuctionEntry.update(AuctionEntry.java:901)
at com.jbidwatcher.auction.Auctions.doUpdate(Auctions.java:92)
at com.jbidwatcher.ui.AuctionsManager.updateList(AuctionsManager.java:130)
at com.jbidwatcher.ui.AuctionsManager.check(AuctionsManager.java:107)
at com.jbidwatcher.util.queue.TimerHandler.run(TimerHandler.java:62)
Caused by: java.sql.SQLException: An attempt was made to put a data value of type ‘short’ into a data value of type ‘TIMESTAMP’.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
… 20 more
Caused by: ERROR XCL12: An attempt was made to put a data value of type ‘short’ into a data value of type ‘TIMESTAMP’.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.iapi.types.DataType.throwLangSetMismatch(Unknown Source)
at org.apache.derby.iapi.types.DataType.setValue(Unknown Source)
… 16 more
Sat May 12 09:08:17 MDT 2012: Error from columns: (3,sticky, SMALLINT, 1)
Sat May 12 09:08:17 MDT 2012: Failing to insert “2012-05-12 09:08:17” into column 3 of table entries
java.sql.SQLException: An attempt was made to put a data value of type ‘java.sql.Timestamp’ into a data value of type ‘INTEGER’.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.noStateChangeException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.setTimestamp(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.setTimestamp(Unknown Source)
at com.jbidwatcher.util.db.Table.setColumn(Table.java:494)
at com.jbidwatcher.util.db.Table.setPreparedUpdate(Table.java:463)
at com.jbidwatcher.util.db.Table.updateMap(Table.java:329)
at com.jbidwatcher.util.db.Table.insertOrUpdate(Table.java:302)
at com.jbidwatcher.util.db.ActiveRecord.saveDB(ActiveRecord.java:116)
at com.jbidwatcher.auction.AuctionEntry.saveDB(AuctionEntry.java:1550)
at com.jbidwatcher.auction.AuctionEntry.setNeedsUpdate(AuctionEntry.java:1044)
at com.jbidwatcher.auction.AuctionEntry.checkEnded(AuctionEntry.java:268)
at com.jbidwatcher.auction.AuctionEntry.setAuctionInfo(AuctionEntry.java:1361)
at com.jbidwatcher.auction.server.AuctionServer.reload(AuctionServer.java:194)
at com.jbidwatcher.auction.AuctionEntry.update(AuctionEntry.java:901)
at com.jbidwatcher.auction.Auctions.doUpdate(Auctions.java:92)
at com.jbidwatcher.ui.AuctionsManager.updateList(AuctionsManager.java:130)
at com.jbidwatcher.ui.AuctionsManager.check(AuctionsManager.java:107)
at com.jbidwatcher.util.queue.TimerHandler.run(TimerHandler.java:62)
Caused by: java.sql.SQLException: An attempt was made to put a data value of type ‘java.sql.Timestamp’ into a data value of type ‘INTEGER’.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
… 21 more
Caused by: ERROR XCL12: An attempt was made to put a data value of type ‘java.sql.Timestamp’ into a data value of type ‘INTEGER’.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.iapi.types.DataType.throwLangSetMismatch(Unknown Source)
at org.apache.derby.iapi.types.DataType.setValue(Unknown Source)
… 17 more
Sat May 12 09:08:17 MDT 2012: Error from columns: (4,updated_at, TIMESTAMP, 2012-05-12 09:08:17)
java.sql.SQLException: The parameter position ‘4’ is out of range. The number of parameters for this prepared statement is ‘3’.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.newSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.getTypes(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.getParameterJDBCType(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.setNull(Unknown Source)
at com.jbidwatcher.util.db.Table.setColumn(Table.java:492)
at com.jbidwatcher.util.db.Table.setPreparedUpdate(Table.java:463)
at com.jbidwatcher.util.db.Table.updateMap(Table.java:329)
at com.jbidwatcher.util.db.Table.insertOrUpdate(Table.java:302)
at com.jbidwatcher.util.db.ActiveRecord.saveDB(ActiveRecord.java:116)
at com.jbidwatcher.auction.AuctionEntry.saveDB(AuctionEntry.java:1550)
at com.jbidwatcher.auction.AuctionEntry.setNeedsUpdate(AuctionEntry.java:1044)
at com.jbidwatcher.auction.AuctionEntry.checkEnded(AuctionEntry.java:268)
at com.jbidwatcher.auction.AuctionEntry.setAuctionInfo(AuctionEntry.java:1361)
at com.jbidwatcher.auction.server.AuctionServer.reload(AuctionServer.java:194)
at com.jbidwatcher.auction.AuctionEntry.update(AuctionEntry.java:901)
at com.jbidwatcher.auction.Auctions.doUpdate(Auctions.java:92)
at com.jbidwatcher.ui.AuctionsManager.updateList(AuctionsManager.java:130)
at com.jbidwatcher.ui.AuctionsManager.check(AuctionsManager.java:107)
at com.jbidwatcher.util.queue.TimerHandler.run(TimerHandler.java:62)
Caused by: java.sql.SQLException: The parameter position ‘4’ is out of range. The number of parameters for this prepared statement is ‘3’.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
… 24 more
Sat May 12 09:08:17 MDT 2012: Error from columns: (5,last_updated_at, TIMESTAMP, null)
|