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 ================