Details
-
Type: Bug
-
Status: Resolved
-
Priority: Major
-
Resolution: Fixed
-
Affects Version/s: unspecified
-
Fix Version/s: unspecified
-
Component/s: Data Summarization
-
Labels:None
-
Environment:
xml-06, dc1bos tsacommon (all slaves and master)
Description
A couple weeks ago I started noticing this error in the seupdate logs:
2012-01-25 10:58:56.597 (2) [P1T1]: Exception [Error trying to insertOrUpdate to searchEngineTimeZones values: [3, 2183, 1]]:java.sql.SQLException: Failed to read auto-incre
ment value from storage engine
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
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:3170)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1316)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1235)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1388)
at com.carldunham.jst.db.Database.executeUpdate(Database.java:401)
at com.carldunham.jst.db.BaseDatabaseTable.insertOrUpdate(BaseDatabaseTable.java:431)
at com.carldunham.jst.db.BaseDatabaseTable.insertOrUpdate(BaseDatabaseTable.java:333)
at com.thesearchagency.searchengines.SearchEngineUpdater$SearchEngineUserWorker.processGoogleTimeZones(SearchEngineUpdater.java:1595)
at com.thesearchagency.searchengines.SearchEngineUpdater$SearchEngineUserWorker.syncAccounts(SearchEngineUpdater.java:1543)
at com.thesearchagency.searchengines.SearchEngineUpdater$SearchEngineUserWorker.run(SearchEngineUpdater.java:1320)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
This happens when running with --accounts flag like /usr/local/tsa/bidmgr/seupdate.sh -d3 -a 734 --distribution 3 --accounts