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

Data-checker_discrepancy_Resolver:(ASK) Exception [Error saving record]:com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException:

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: unspecified
    • Fix Version/s: None
    • Component/s: Data Checker
    • Labels:
      None
    • Environment:

      Operating System: Linux
      Platform: PC

    • Bugzilla Id:
      3709

      Description

      ------------------------------------------------------------------------
      Project: DataChecker_Discrepancy_Resolver
      Component Used: ./generate-discrepancies.sh and resolver
      Build: /var/local/builds/tsa-build-bidmgr-2010-04-06-p41-r25490
      -----------------------------------------------------------------------
      Its observed that after executing," ./generate-discrepancies.sh -d3 -account
      289 -distribution 147 -E2010-03-04 -T2010-003-04 -resolve" for ASK
      we are getting exception "MySQLIntegrityConstraintViolationException"

      2010-04-06 06:20:45.342 (1) [P7T1]: Exception [Error saving
      record]:com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException:
      Duplicate entry
      'ms1281879023c_legalzoom_savings-0-147-15800-content-1281879023-1' for key 2
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931)
      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.carldunham.jst.db.Database.executeUpdate(Database.java:401)
      at
      com.carldunham.jst.db.BaseDatabaseTable.update(BaseDatabaseTable.java:620)
      at
      com.carldunham.jst.db.BaseDatabaseTableRow.save(BaseDatabaseTableRow.java:501)
      at
      com.carldunham.jst.db.BaseDatabaseTableRow.save(BaseDatabaseTableRow.java:424)
      at
      com.thesearchagency.searchengines.SearchEngineUpdater$SearchEngineAccountWorker.syncListings(SearchEngineUpdater.java:1764)
      at
      com.thesearchagency.searchengines.SearchEngineUpdater$SearchEngineAccountWorker.run(SearchEngineUpdater.java:1581)
      at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)
      at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269)
      at java.util.concurrent.FutureTask.run(FutureTask.java:123)
      at
      java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
      at
      java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
      at java.lang.Thread.run(Thread.java:595)

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                rupesh.kumar Rupesh Kumar Vijay (Inactive)
                Reporter:
                atul.sanagar Atul Sanagar (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: