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

Data-checker_discrepancy_Resolver:(MSN)bc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry 'ms1281851300c_maryland_sec_of_state-0-147-15795-content-12818513' for key 2

    Details

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

      Operating System: Linux
      Platform: PC

    • Bugzilla Id:
      3682

      Description

      ------------------------------------------------------------------------
      Project: DataChecker_Discrepancy_Resolver
      Component Used: ./generate-discrepancies.sh and resolver
      Build: /var/local/builds/tsa-build-bidmgr-2010-03-26-p21-r25381
      --------------------------------------------------------------------------

      Execute ./generate-discrepancies.sh -d3 -account 289 -distribution 147 -E
      2010-03-04 -T 2010-03-04 -resolve

      .....

      2010-03-29 22:39:53.911 (1) [P6T0]: Exception [Error saving
      record]:com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException:
      Duplicate entry
      'ms1281851300c_maryland_sec_of_state-0-147-15795-content-12818513' 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:477)
      at
      com.carldunham.jst.db.BaseDatabaseTableRow.save(BaseDatabaseTableRow.java:400)
      at
      com.thesearchagency.searchengines.SearchEngineUpdater$SearchEngineAccountWorker.syncListings(SearchEngineUpdater.java:1825)
      at
      com.thesearchagency.searchengines.SearchEngineUpdater$SearchEngineAccountWorker.run(SearchEngineUpdater.java:1576)
      at
      com.carldunham.jst.concurrency.ThreadPool$WorkerThread.run(ThreadPool.java:248)

        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: