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
- is duplicated by
- 
                    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 -         
- Closed
 
-