Uploaded image for project: 'AdMax'
  1. AdMax
  2. ADMAX-2998

`tsacommon`.searchEngineTimeZones ran out of IDs

    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

        Attachments

          Activity

            People

            • Assignee:
              caitlyn Caitlyn Duggan (Inactive)
              Reporter:
              caitlyn Caitlyn Duggan (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: