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