Details
-
Type: Bug
-
Status: Closed
-
Priority: Major
-
Resolution: Not a Bug
-
Affects Version/s: 1.3.0
-
Fix Version/s: 1.3.0
-
Component/s: Data Summarization
-
Labels:None
-
Environment:
optus-qa-agency1
Description
Running sesumm without -U causes exception
I ran sepull3.sh -d4, and I get the following exception in sesumm: (full log found: /tmp/sepull.txt)
2012-06-16 04:18:22.613 (4) [P1T2]: replicated 0 rows to `st-tracker`.`tmp2`
2012-06-16 04:18:22.613 (4) [P1T11]: replicated 0 rows to `st-tracker`.`tmp1`
2012-06-16 04:18:22.617 (4) [P1T2]: spike: SQL->[select `st-tracker`.`searchEngineGroups`.`searchEngineAccountID`,`st-tracker`.`searchEngineGroups`.`id` AS `searchEngineGroupID`,`tmp2`.`creativeid`,`tmp2`.`kwType` AS `searchEngineMatchType`,`tmp2`.`keywordid` AS `searchEngineIdentifier`,SUM(`tmp2`.`imps`) AS `imps`,SUM(`tmp2`.`clicks`) AS `clicks`,SUM(`tmp2`.`cost`) AS `cost`,SUM(`tmp2`.`pos` * `tmp2`.`imps`)/SUM(`tmp2`.`imps`) AS `pos`,`tmp2`.`qualityScore` AS `qualityScore`,`tmp2`.`firstPageCPC` AS `firstPageCPC` from `st-tracker`.`tmp2` inner join `st-tracker`.`searchEngineGroups` on (((((`tmp2`.`adgroupid`=`st-tracker`.`searchEngineGroups`.`searchEngineIdentifier`)) and ((`st-tracker`.`searchEngineGroups`.`searchEngineAccountID` in (405776,405777,405775,405774)))))) where ((`tmp2`.`campaignid` in (83977714,83977954,83977834,83977594)) and (`tmp2`.`startTime`="2012-06-15 00:00:00") and (`tmp2`.`adwordsType`="Search Only") and (`tmp2`.`kwType` in ("Broad","BroadMatch","Exact","Phrase"))) group by `tmp2`.`adgroupid`,`tmp2`.`creativeid`,`keywordid`,`kwType`]
2012-06-16 04:18:22.617 (4) [P1T11]: spike: SQL->[select `st-tracker`.`searchEngineGroups`.`searchEngineAccountID`,`st-tracker`.`searchEngineGroups`.`id` AS `searchEngineGroupID`,`tmp1`.`creativeid`,`tmp1`.`kwType` AS `searchEngineMatchType`,`tmp1`.`keywordid` AS `searchEngineIdentifier`,SUM(`tmp1`.`imps`) AS `imps`,SUM(`tmp1`.`clicks`) AS `clicks`,SUM(`tmp1`.`cost`) AS `cost`,SUM(`tmp1`.`pos` * `tmp1`.`imps`)/SUM(`tmp1`.`imps`) AS `pos`,`tmp1`.`qualityScore` AS `qualityScore`,`tmp1`.`firstPageCPC` AS `firstPageCPC` from `st-tracker`.`tmp1` inner join `st-tracker`.`searchEngineGroups` on (((((`tmp1`.`adgroupid`=`st-tracker`.`searchEngineGroups`.`searchEngineIdentifier`)) and ((`st-tracker`.`searchEngineGroups`.`searchEngineAccountID` in (405747,405748)))))) where ((`tmp1`.`campaignid` in (565761,565760)) and (`tmp1`.`startTime`="2012-06-15 00:00:00") and (`tmp1`.`adwordsType`="Search Only") and (`tmp1`.`kwType` in ("Broad","BroadMatch","Exact","Phrase"))) group by `tmp1`.`adgroupid`,`tmp1`.`creativeid`,`keywordid`,`kwType`]
2012-06-16 04:18:22.620 (2) [P1T11]: Exception [pulling/processing report for account (57225) "12321669_1"]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'tmp1.qualityScore' in 'field list'
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
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.executeQuery(Statement.java:1172)
at com.carldunham.jst.db.Database.executeQuery(Database.java:364)
at com.carldunham.jst.db.Database.executeQuery(Database.java:316)
at com.carldunham.jst.db.JoinTable.select(JoinTable.java:180)
at com.carldunham.jst.db.JoinTable.select(JoinTable.java:169)
at com.carldunham.jst.db.JoinTable.select(JoinTable.java:151)
at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getCostAndClicks(GoogleAPISearchEngine.java:918)
at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineUserWorker.run(SearchEngineSummarizer.java:486)
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)
No exception when running: ./sesummarize.sh -U57229 -d4 2> /tmp/sesumm.txt