2011-06-27 03:43:55.686 (3) [main]: Debug Level set to 3 2011-06-27 03:43:55.698 (3) [main]: =============== Starting Old Search Engine Data Checker ================ 2011-06-27 03:43:55.706 (3) [main]: ----------------Old Search Engine Data Checker starting 2011-06-27 03:43:57.112 (3) [main]: Passed null searchEngineUser, connecting user TSA master username/password 2011-06-27 03:43:57.956 (3) [main]: Created shared sesystem connection rw log4j:WARN No appenders could be found for logger (org.apache.axis.AxisEngine). log4j:WARN Please initialize the log4j system properly. 2011-06-27 03:44:02.182 (3) [P1T1]: Starting Distribution 3 2011-06-27 03:44:02.186 (3) [P1T1]: ----------------Search Engine Data Checker starting 2011-06-27 03:44:02.454 (3) [P2T1]: Starting User (739) "LegalZoom" 2011-06-27 03:44:03.309 (3) [P2T1]: Downloading check report... 2011-06-27 03:44:03.328 (3) [P2T1]: Scheduling report attempt 1: name=tsadc_2011-05-15_daily_scottm@legalzoom.com_31 with id=null 2011-06-27 03:44:03.328 (3) [P2T1]: validating report job... 2011-06-27 03:44:11.945 (3) [P2T1]: ...success 2011-06-27 03:44:16.792 (3) [P2T1]: Scheduled report. Report Job ID = 1336283287 2011-06-27 03:44:55.725 (3) [P2T1]: Downloading report attempt 1: name=/var/local/tsa/sedata/google/tsa-check-report-daily-2011-05-15-U739.xml.gz with id=1336283287 from url https://adwords.google.com/api/adwords/ReportDownload?t=AAAAAE-mEJcAAAEw9X9_oAEAAAAAYYez8FG7SJfahWNkOBx2KYrrQeDLzmcJ 2011-06-27 03:44:56.285 (3) [P2T1]: Connected to URL "https://adwords.google.com/api/adwords/ReportDownload?t=AAAAAE-mEJcAAAEw9X9_oAEAAAAAYYez8FG7SJfahWNkOBx2KYrrQeDLzmcJ" 2011-06-27 03:44:58.608 (3) [P2T1]: check report download (Sun May 15 00:00:00 PDT 2011, "/var/local/tsa/sedata/google/tsa-check-report-daily-2011-05-15-U739.xml.gz") -> success:true 2011-06-27 03:44:58.608 (3) [P2T1]: Parsing check report into staging database... 2011-06-27 03:44:59.692 (3) [P2T1]: DatabasePool with a limit of 80 created 2011-06-27 03:44:59.951 (3) [P2T1]: Finding column names... 2011-06-27 03:44:59.952 (3) [P2T1]: Report saving to /tmp/go2011-05-1548344.tmp 2011-06-27 03:44:59.956 (2) [P2T1]: date 2011-06-27 03:44:59.956 (2) [P2T1]: account 2011-06-27 03:44:59.956 (2) [P2T1]: campaignid 2011-06-27 03:44:59.956 (2) [P2T1]: campaign 2011-06-27 03:44:59.959 (2) [P2T1]: imps 2011-06-27 03:44:59.959 (2) [P2T1]: clicks 2011-06-27 03:44:59.959 (2) [P2T1]: cost 2011-06-27 03:44:59.959 (2) [P2T1]: conv 2011-06-27 03:45:00.343 (3) [P2T1]: Writing temp infile... 2011-06-27 03:45:00.615 (3) [P2T1]: Deleting existing records where ((`date`="2011-05-15 00:00:00")) 2011-06-27 03:45:00.727 (3) [P2T1]: Loading data infile into temp table... 2011-06-27 03:45:00.971 (2) [P2T1]: account 2011-06-27 03:45:00.975 (2) [P2T1]: campaign 2011-06-27 03:45:00.979 (2) [P2T1]: clicks 2011-06-27 03:45:00.979 (2) [P2T1]: cost 2011-06-27 03:45:00.983 (2) [P2T1]: acctname 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) 2011-06-27 03:45:01.423 (3) [P2T1]: ...done 2011-06-27 03:45:01.427 (3) [P2T1]: Finished User (739) "LegalZoom" 2011-06-27 03:45:03.392 (3) [P1T1]: ------------Search Engine Data Checker done 2011-06-27 03:45:03.396 (3) [main]: ------------Old Search Engine Data Checker done 2011-06-27 03:45:03.396 (3) [main]: =============== Completed Old Search Engine Data Checker ================ 2011-06-27 03:45:03.436 (3) [main]: Old Search Engine Data Checker: 1m 7.710s 2011-06-27 03:45:03.439 (3) [main]: by key: 2011-06-27 03:45:03.440 (3) [main]: google: 21.033s 2011-06-27 03:45:03.440 (3) [main]: db: 2.177s 2011-06-27 03:45:03.440 (3) [main]: by thread: 2011-06-27 03:45:03.440 (3) [main]: P2T1: 1.880s 2011-06-27 03:45:03.440 (3) [main]: main: 0.284s 2011-06-27 03:45:03.443 (3) [main]: P1T1: 0.013s 2011-06-27 03:45:03.443 (3) [main]: other: 44.500s