Uploaded image for project: 'AdMaxLocal'
  1. AdMaxLocal
  2. AML-916

googlemcc: duplicate entry exception

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Not a Bug
    • Affects Version/s: sprint 15: 12-12-2012
    • Fix Version/s: 2.0.0
    • Component/s: None
    • Labels:
      None
    • Environment:

      Build: tsa-build-bidmgr-2012-11-29-p734-r2803f1af60906a4cace7dfcfcdc1ecd69613e2b0
      TSAApp@aq-qa-jboss1 tsa

    • Sprint:
      Sprint 16

      Description

      1. I ran googlemcc for a date of 12/1 (all commands are listed below)
      2. I ran googlemcc without a date
      3. I ran googlemcc with the same date as step 1, and saw 2 exceptions below.

      Commands:
      [TSAApp@aq-qa-jboss1 bidmgr]$ ./googlemcc.sh -c /var/local/tsa/config/GoogleMCCReport.emails.txt --split -T2012-12-01 2> /tmp/AML595_5
      [TSAApp@aq-qa-jboss1 bidmgr]$ ./googlemcc.sh -c /var/local/tsa/config/GoogleMCCReport.emails.txt --split 2> /tmp/AML595_6
      [TSAApp@aq-qa-jboss1 bidmgr]$ ./googlemcc.sh -c /var/local/tsa/config/GoogleMCCReport.emails.txt --split -T2012-12-01 2> /tmp/AML595_7
      Service - Failed to parse report /var/local/tsa/sedata/google/tsa-mcc-report-2012-12-01_9946190553.xml.gz

      Log Exceptions:

      2012-12-06 16:44:03.452 (3) [pool-1-thread-8]: === Completed Client CustomerID: 6301868406 ===
      2012-12-06 16:44:03.452 (3) [main]: Futures result[33] is DONE
      2012-12-06 16:44:03.453 (1) [pool-1-thread-9]: Exception [ Error parsing /var/local/tsa/sedata/google/tsa-mcc-report--kwperformance-2012-12-01_2313981781.xml.gz]:com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '2012-12-01-111548659-Content Only-5685363499-18426171739-3000000' for key 'PRIMARY'
      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.mysql.jdbc.Statement.executeUpdate(Statement.java:1388)
      at com.carldunham.jst.db.Database.executeUpdate(Database.java:409)
      at com.carldunham.jst.db.BaseDatabaseTable.insert(BaseDatabaseTable.java:366)
      at com.carldunham.jst.db.BaseDatabaseTable.insert(BaseDatabaseTable.java:354)
      at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.parseKeywordPerformanceReport(GoogleAPISearchEngine.java:1985)
      at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.parseGoogleMCCReport(GoogleAPISearchEngine.java:1737)
      at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.parseGoogleMCCReport(GoogleAPISearchEngine.java:1727)
      at com.thesearchagency.searchengines.google.GoogleMCCReport$SearchEngineUserWorker.run(GoogleMCCReport.java:578)
      at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
      at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
      at java.util.concurrent.FutureTask.run(FutureTask.java:138)
      at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
      at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
      at java.util.concurrent.FutureTask.run(FutureTask.java:138)
      at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
      at java.lang.Thread.run(Thread.java:662)

      2012-12-06 16:44:03.453 (3) [pool-1-thread-9]: ...done
      2012-12-06 16:44:03.454 (3) [pool-1-thread-9]: === Completed Client CustomerID: 2313981781 ===
      2012-12-06 16:44:03.454 (3) [main]: Futures result[34] is DONE
      2012-12-06 16:44:03.509 (3) [main]: DefaultPropertyFileMonitor: modification detected on 1352138172000 for com.thesearchagency.AlertUtils.properties
      2012-12-06 16:44:03.533 (2) [main]: sendAlert: executing command: [/usr/local/tsa/send_alarm.sh, WARNING, TSAOPS, AdMax Application [GoogleMCC]: Service - Failed to parse report /var/local/tsa/sedata/google/tsa-mcc-report-2012-12-01_9946190553.xml.gz]
      2012-12-06 16:44:03.541 (1) [main]: Exception [sendAlert: Error executing [/usr/local/tsa/send_alarm.sh, WARNING, TSAOPS, AdMax Application [GoogleMCC]: Service - Failed to parse report /var/local/tsa/sedata/google/tsa-mcc-report-2012-12-01_9946190553.xml.gz]]:java.io.IOException: Cannot run program "/usr/local/tsa/send_alarm.sh": java.io.IOException: error=13, Permission denied
      at java.lang.ProcessBuilder.start(ProcessBuilder.java:460)
      at com.thesearchagency.AlertUtils.sendAlert(AlertUtils.java:94)
      at com.thesearchagency.searchengines.google.GoogleMCCReport.sendAlert(GoogleMCCReport.java:412)
      at com.thesearchagency.searchengines.google.GoogleMCCReport.run(GoogleMCCReport.java:281)
      at com.thesearchagency.searchengines.google.GoogleMCCReport.main(GoogleMCCReport.java:400)
      Caused by: java.io.IOException: java.io.IOException: error=13, Permission denied
      at java.lang.UNIXProcess.<init>(UNIXProcess.java:148)
      at java.lang.ProcessImpl.start(ProcessImpl.java:65)
      at java.lang.ProcessBuilder.start(ProcessBuilder.java:453)
      ... 4 more

      2012-12-06 16:44:03.542 (3) [main]: =============== Completed Google MCC Report ================

        Attachments

          Activity

            People

            • Assignee:
              caitlyn Caitlyn Duggan (Inactive)
              Reporter:
              jelliott Jen Clarke (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: