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

GoogleV2011_API_Upgrade:Running of sedatacheck script results in throwing - MySQLIntegrityConstraintViolationException: Duplicate entry '0000-00-00' exception.

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: Google v201101
    • Fix Version/s: Google v201101
    • Component/s: Google
    • Labels:
      None
    • Environment:

      Trunk Build 474 on staging-xml1

      Description

      Running of sedatacheck script results in throwing - MySQLIntegrityConstraintViolationException: Duplicate entry '0000-00-00' exception.

      tsaapp@tvvm-staging-xml1:/usr/local/tsa/bidmgr$ ./sedatacheck.sh -d3 -T2011-05-15 -U739 --daily --force 2>&1 | tee /tmp/sedatacheck.log

      .

      .

      .

      2011-06-27 03:45:01.239 (3) [P2T1]: Inserting into staging database...

      2011-06-27 03:45:01.371 (1) [P2T1]: Exception [ Error parsing /var/local/tsa/sedata/google/tsa-check-report-daily-2011-05-15-U739.xml.gz]:com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '0000-00-00' for key 1

      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.Connection.execSQL(Connection.java:3099)

      at com.mysql.jdbc.Statement.execute(Statement.java:695)

      at com.carldunham.jst.db.Database.execute(Database.java:274)

      at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.parseReport(GoogleAPISearchEngine.java:1737)

      at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.runDataCheck(GoogleAPISearchEngine.java:1485)

      at com.thesearchagency.searchengines.SearchEngineDataChecker$DistributionWorker$SearchEngineUserWorker.run(SearchEngineDataChecker.java:421)

      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)

      I copied temporary file

      {/tmp/go2011-05-1548344.tmp}

      which was created;

      pradeep.nair@tvvm-staging-xml1:~$ cp /tmp/go2011-05-1523721.tmp /tmp/test.tmp

      Find the test.tmp as attached.

        Attachments

        1. sedatacheck1.log
          6 kB
        2. test.tmp
          2 kB
        3. sedatacheck.log
          6 kB

          Activity

            People

            • Assignee:
              jason.stedman Jason Stedman (Inactive)
              Reporter:
              atul.sanagar Atul Sanagar (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: