nohup: appending output to `nohup.out' 2012-12-04 09:51:10.459 (3) [main]: Debug Level set to 4 2012-12-04 09:51:10.599 (3) [main]: Listings flag set, implying groups flag as well. 2012-12-04 09:51:10.602 (4) [main]: no account, or instance for databaseInstance, skipping lookup... 2012-12-04 09:51:10.607 (3) [main]: DatabasePool with a limit of 80 created 2012-12-04 09:51:10.610 (4) [ConnectionCloser]: Starting DatabasePool ConnectionCloserThread 2012-12-04 09:51:10.910 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-12-04 09:51:10.911 (4) [main]: Created new Object 2012-12-04 09:51:10.916 (4) [main]: spike: SQL->[select @@version] 2012-12-04 09:51:11.001 (4) [main]: time=0.085 2012-12-04 09:51:11.007 (4) [main]: Query executed in 0.085s 2012-12-04 09:51:11.008 (4) [main]: test query succeeded, returned "5.1.49-rel11.3-log" 2012-12-04 09:51:11.022 (4) [main]: spike: SQL->[select distinct searchEngineUserID from `tsacommon`.`searchEngineAccounts` where ((`accountID` in ("898")) and (`distributionID` in ("3")))] 2012-12-04 09:51:11.024 (4) [main]: time=0.0020 2012-12-04 09:51:11.024 (4) [main]: Query executed in 0.002s 2012-12-04 09:51:11.025 (3) [main]: getSEUserIDs distID=3, seUserID=null, accounts=(898) returned 3177 2012-12-04 09:51:11.029 (3) [main]: =============== Starting Search Engine Updater ================ 2012-12-04 09:51:11.031 (3) [main]: No licensing config file found, assuming TSA production environment 2012-12-04 09:51:11.032 (3) [main]: ----------------SearchEngineSyncUserWorker starting 2012-12-04 09:51:11.032 (4) [main]: no account, or instance for databaseInstance, skipping lookup... 2012-12-04 09:51:11.066 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-12-04 09:51:11.117 (4) [main]: spike: SQL->[select * from `searchEngineUsers` join `accounts` on ((`tsacommon`.`accounts`.`id`=`tsacommon`.`searchEngineUsers`.`accountID`)) where ((`enabled`="true") and (`tsacommon`.`accounts`.`isActive`="true") and (`tsacommon`.`searchEngineUsers`.`id` in ("3177")) and (`tsacommon`.`searchEngineUsers`.`distributionID`="3")) order by `tsacommon`.`accounts`.`tier` asc,`tsacommon`.`accounts`.`priority` asc,`tsacommon`.`accounts`.`id` desc] 2012-12-04 09:51:11.120 (4) [main]: time=0.0030 2012-12-04 09:51:11.121 (4) [main]: Query executed in 0.003s 2012-12-04 09:51:11.156 (3) [main]: Service URL: http://svc-useracctv2.svc.thesearchagency.com:8080/svc-useracctv2.0/UserAccountService2.0?wsdl Dec 4, 2012 9:51:12 AM org.apache.cxf.bus.spring.BusApplicationContext getConfigResources INFO: No cxf.xml configuration file detected, relying on defaults. Dec 4, 2012 9:51:16 AM org.apache.cxf.service.factory.ReflectionServiceFactoryBean buildServiceFromWSDL INFO: Creating Service {urn:v2.UserAccountService.services.thesearchagency.com}UserAccountService2.0 from WSDL: http://svc-useracctv2.svc.thesearchagency.com:8080/svc-useracctv2.0/UserAccountService2.0?wsdl 2012-12-04 09:51:20.165 (3) [main]: Got UserAccountServiceEndPoint object. 2012-12-04 09:51:20.559 (3) [main]: Instantiating a DateUtil object for time zone America/Denver 2012-12-04 09:51:20.563 (4) [main]: no account, or instance for databaseInstance, skipping lookup... 2012-12-04 09:51:20.594 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-12-04 09:51:20.594 (4) [main]: Created new Object 2012-12-04 09:51:20.594 (4) [main]: spike: SQL->[select @@version] 2012-12-04 09:51:20.596 (4) [main]: time=0.0010 2012-12-04 09:51:20.596 (4) [main]: Query executed in 0.001s 2012-12-04 09:51:20.596 (4) [main]: test query succeeded, returned "5.1.49-rel11.3-log" 2012-12-04 09:51:20.606 (4) [main]: spike: SQL->[select * from `tsacommon`.`distribution` where (`id`=3) limit 1] 2012-12-04 09:51:20.609 (4) [main]: time=0.0030 2012-12-04 09:51:20.609 (4) [main]: Query executed in 0.003s 2012-12-04 09:51:20.613 (4) [main]: Record Loaded 2012-12-04 09:51:20.697 (4) [main]: User in TSA MCC, connecting using master username/password 2012-12-04 09:51:20.699 (4) [main]: client customer id = 9001082081 2012-12-04 09:51:20.829 (4) [main]: no account, or instance for databaseInstance, skipping lookup... 2012-12-04 09:51:20.866 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-12-04 09:51:20.867 (4) [main]: spike: SQL->[select `id`,`shortCode` from distribution where ((`searchEngineClass` is not null) and (`searchEngineClass`!=""))] 2012-12-04 09:51:20.869 (4) [main]: time=0.0010 2012-12-04 09:51:20.869 (4) [main]: Query executed in 0.001s 2012-12-04 09:51:20.875 (4) [main]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-12-04 09:51:20.879 (4) [main]: no account, or instance for databaseInstance, skipping lookup... 2012-12-04 09:51:20.929 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-12-04 09:51:20.936 (4) [main]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`type`="mysql") and (`name`="global-sesystem")) limit 1] 2012-12-04 09:51:20.938 (4) [main]: time=0.0020 2012-12-04 09:51:20.939 (4) [main]: Query executed in 0.002s 2012-12-04 09:51:20.940 (4) [main]: Record Loaded 2012-12-04 09:51:20.940 (4) [main]: DataCache: put key global-sesystem 2012-12-04 09:51:20.940 (4) [main]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-12-04 09:51:21.005 (4) [main]: opened [jdbc:mysql://sesystem-01-write:3307/sesystem?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-12-04 09:51:21.006 (3) [main]: Created shared sesystem connection rw 2012-12-04 09:51:21.013 (4) [main]: sesystem: SQL->[select `authToken`,`date` from `sesystem`.`googleAuthToken` where ((`seUserID`=0))] 2012-12-04 09:51:21.015 (4) [main]: time=0.0020 2012-12-04 09:51:21.015 (4) [main]: Query executed in 0.002s 2012-12-04 09:51:21.017 (4) [main]: MasterAuthToken retrieved from database [DQAAAJUAAABblTkk4samFeeIPZeA4b44C3w9CSZUFxB_1PKkgTJgM5Lgsa8hTds5kjeMJGa6cExwQnnIDV7Ug-KEY3tqzcq509ufM18E690NozMrYI1_ThysElNbsxM95UmDsdGckBnxsx2_W0beOdRfookxPexOo_l8H3BAtqbFpIIwgTH98LxImDZ0EQfjCTiZ49NAuNh3TJ7XbYd-0CN-WJfEw85Z] for search engine user ID[0] 2012-12-04 09:51:21.019 (4) [main]: seuserid[3177] username[null] password[null] customerID[9001082081] 2012-12-04 09:51:21.024 (4) [main]: ClearConnections called at: Tue Dec 04 09:51:21 PST 2012 Timer: 0 2012-12-04 09:51:21.028 (4) [main]: sesystem: SQL->[update `sesystem`.`searchEngineConnections` set `inUse`="false",`holder`="",`timeStamp`="2012-12-04 09:51:21",`holderIdentifier`="" where ((`sesystem`.`searchEngineConnections`.`distributionID`=3) and (`sesystem`.`searchEngineConnections`.`inUse`="true") and (`sesystem`.`searchEngineConnections`.`timeStamp`<="2012-12-04 09:46:21")) limit 1], genflags=no 2012-12-04 09:51:21.031 (4) [main]: time=0.0020 2012-12-04 09:51:21.031 (4) [main]: Query executed in 0.002s, 0 row(s) affected 2012-12-04 09:51:21.087 (4) [main]: Setting AuthToken [DQAAAJUAAABblTkk4samFeeIPZeA4b44C3w9CSZUFxB_1PKkgTJgM5Lgsa8hTds5kjeMJGa6cExwQnnIDV7Ug-KEY3tqzcq509ufM18E690NozMrYI1_ThysElNbsxM95UmDsdGckBnxsx2_W0beOdRfookxPexOo_l8H3BAtqbFpIIwgTH98LxImDZ0EQfjCTiZ49NAuNh3TJ7XbYd-0CN-WJfEw85Z] to AdWordsUser object for username[google@thesearchagency.com] 2012-12-04 09:51:22.192 (4) [main]: Returning Object to Pool 2012-12-04 09:51:22.198 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup... 2012-12-04 09:51:22.231 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-12-04 09:51:22.232 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`accounts` where (`id`=898) limit 1] 2012-12-04 09:51:22.234 (4) [P1T1]: time=0.0020 2012-12-04 09:51:22.234 (4) [P1T1]: Query executed in 0.002s 2012-12-04 09:51:22.237 (4) [P1T1]: Record Loaded 2012-12-04 09:51:22.237 (4) [P1T1]: DataCache: put key acct-sync-google 898 2012-12-04 09:51:22.238 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`type`="mysql") and (`name`="acct-sync-google-5")) limit 1] 2012-12-04 09:51:22.239 (4) [P1T1]: time=0.0010 2012-12-04 09:51:22.240 (4) [P1T1]: Query executed in 0.001s 2012-12-04 09:51:22.241 (4) [P1T1]: Record Loaded 2012-12-04 09:51:22.242 (4) [P1T1]: DataCache: put key acct-sync-google-5 2012-12-04 09:51:22.242 (4) [P1T1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-12-04 09:51:22.242 (3) [P1T1]: DatabasePool with a limit of 80 created 2012-12-04 09:51:22.299 (4) [P1T1]: opened [jdbc:mysql://acctdb-05-write:3309/sync_google?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-12-04 09:51:22.299 (4) [P1T1]: Created new Object 2012-12-04 09:51:22.300 (4) [P1T1]: spike: SQL->[select @@version] 2012-12-04 09:51:22.301 (4) [P1T1]: time=0.0010 2012-12-04 09:51:22.301 (4) [P1T1]: Query executed in 0.001s 2012-12-04 09:51:22.301 (4) [P1T1]: test query succeeded, returned "5.1.61-rel13.2" 2012-12-04 09:51:22.301 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup... 2012-12-04 09:51:22.302 (4) [P1T1]: Took Existing Object from Pool 2012-12-04 09:51:22.302 (4) [P1T1]: spike: SQL->[select @@version] 2012-12-04 09:51:22.303 (4) [P1T1]: time=0.0010 2012-12-04 09:51:22.303 (4) [P1T1]: Query executed in 0.001s 2012-12-04 09:51:22.303 (4) [P1T1]: test query succeeded, returned "5.1.49-rel11.3-log" 2012-12-04 09:51:22.304 (3) [P1T1]: -- Bulk downloads supported. 2012-12-04 09:51:22.304 (3) [P1T1]: -- Begining search engine sync for user: (3177) "AT&T Pan Asian Youth Campaign" 2012-12-04 09:51:22.334 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup... 2012-12-04 09:51:22.393 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-12-04 09:51:22.394 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`type`="mysql") and (`name`="global-logging")) limit 1] 2012-12-04 09:51:22.396 (4) [P1T1]: time=0.0010 2012-12-04 09:51:22.396 (4) [P1T1]: Query executed in 0.001s 2012-12-04 09:51:22.396 (4) [P1T1]: Record Loaded 2012-12-04 09:51:22.397 (4) [P1T1]: DataCache: put key global-logging 2012-12-04 09:51:22.397 (4) [P1T1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-12-04 09:51:22.397 (3) [P1T1]: DatabasePool with a limit of 80 created 2012-12-04 09:51:22.460 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write:3306/logging?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-12-04 09:51:22.460 (4) [P1T1]: Created new Object 2012-12-04 09:51:22.461 (4) [P1T1]: spike: SQL->[select @@version] 2012-12-04 09:51:22.462 (4) [P1T1]: time=0.0010 2012-12-04 09:51:22.463 (4) [P1T1]: Query executed in 0.001s 2012-12-04 09:51:22.463 (4) [P1T1]: test query succeeded, returned "5.1.49-rel11.3-log" 2012-12-04 09:51:22.463 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup... 2012-12-04 09:51:22.496 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-12-04 09:51:22.497 (4) [P1T1]: Created new Object 2012-12-04 09:51:22.497 (4) [P1T1]: spike: SQL->[select @@version] 2012-12-04 09:51:22.498 (4) [P1T1]: time=0.0010 2012-12-04 09:51:22.498 (4) [P1T1]: Query executed in 0.001s 2012-12-04 09:51:22.499 (4) [P1T1]: test query succeeded, returned "5.1.49-rel11.3-log" 2012-12-04 09:51:22.499 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup... 2012-12-04 09:51:22.513 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-12-04 09:51:22.514 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`accounts` where (`id`=898) limit 1] 2012-12-04 09:51:22.515 (4) [P1T1]: time=0.0010 2012-12-04 09:51:22.516 (4) [P1T1]: Query executed in 0.001s 2012-12-04 09:51:22.517 (4) [P1T1]: Record Loaded 2012-12-04 09:51:22.517 (4) [P1T1]: DataCache: put key acct-st-tracker 898 2012-12-04 09:51:22.518 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`type`="mysql") and (`name`="acct-st-tracker-5")) limit 1] 2012-12-04 09:51:22.528 (4) [P1T1]: time=0.01 2012-12-04 09:51:22.529 (4) [P1T1]: Query executed in 0.010s 2012-12-04 09:51:22.529 (4) [P1T1]: Record Loaded 2012-12-04 09:51:22.529 (4) [P1T1]: DataCache: put key acct-st-tracker-5 2012-12-04 09:51:22.530 (4) [P1T1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-12-04 09:51:22.530 (3) [P1T1]: DatabasePool with a limit of 80 created 2012-12-04 09:51:22.561 (4) [P1T1]: opened [jdbc:mysql://acctdb-05-write:3309/st-tracker?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-12-04 09:51:22.562 (4) [P1T1]: Created new Object 2012-12-04 09:51:22.562 (4) [P1T1]: spike: SQL->[select @@version] 2012-12-04 09:51:22.563 (4) [P1T1]: time=0.0010 2012-12-04 09:51:22.564 (4) [P1T1]: Query executed in 0.001s 2012-12-04 09:51:22.564 (4) [P1T1]: test query succeeded, returned "5.1.61-rel13.2" 2012-12-04 09:51:22.570 (2) [P1T1]: Created KeywordStructureSyncCriterion, db is googleKeywords 2012-12-04 09:51:22.570 (2) [P1T1]: Created CreativeStructureSyncCriterion 2012-12-04 09:51:22.571 (2) [P1T1]: googleKeywords 2012-12-04 09:51:22.623 (2) [P1T1]: Added Keyword Performance Report AdGroupId to secondaryKeys 2012-12-04 09:51:22.623 (2) [P1T1]: Added Adgroup Performance Report AdGroupId to secondaryKeys 2012-12-04 09:51:22.623 (2) [P1T1]: Added Criteria Performance Report AdGroupId to secondaryKeys 2012-12-04 09:51:22.625 (2) [P1T1]: Getting columns for : Keyword Performance Report 2012-12-04 09:51:22.626 (2) [P1T1]: Got : CampaignId 2012-12-04 09:51:22.626 (2) [P1T1]: Got : AdGroupId 2012-12-04 09:51:22.626 (2) [P1T1]: Got : Id 2012-12-04 09:51:22.626 (2) [P1T1]: Got : AdGroupStatus 2012-12-04 09:51:22.626 (2) [P1T1]: Got : MaxCpc 2012-12-04 09:51:22.626 (2) [P1T1]: Got : MaxCpm 2012-12-04 09:51:22.626 (2) [P1T1]: Got : KeywordMatchType 2012-12-04 09:51:22.626 (2) [P1T1]: Got : Status 2012-12-04 09:51:22.627 (2) [P1T1]: Got : DestinationUrl 2012-12-04 09:51:22.627 (2) [P1T1]: Got : IsNegative 2012-12-04 09:51:22.627 (2) [P1T1]: Got : KeywordText 2012-12-04 09:51:22.712 (2) [P1T1]: Getting columns for : Criteria Performance Report 2012-12-04 09:51:22.712 (2) [P1T1]: Got : CampaignId 2012-12-04 09:51:22.712 (2) [P1T1]: Got : AdGroupId 2012-12-04 09:51:22.712 (2) [P1T1]: Got : Id 2012-12-04 09:51:22.712 (2) [P1T1]: Got : AdGroupStatus 2012-12-04 09:51:22.712 (2) [P1T1]: Got : MaxCpc 2012-12-04 09:51:22.713 (2) [P1T1]: Got : MaxCpm 2012-12-04 09:51:22.713 (2) [P1T1]: Got : CriteriaType 2012-12-04 09:51:22.713 (2) [P1T1]: Got : Status 2012-12-04 09:51:22.713 (2) [P1T1]: Got : CriteriaDestinationUrl 2012-12-04 09:51:22.713 (2) [P1T1]: Got : IsNegative 2012-12-04 09:51:22.713 (2) [P1T1]: Got : Criteria 2012-12-04 09:51:22.741 (2) [P1T1]: Getting columns for : Adgroup Performance Report 2012-12-04 09:51:22.741 (2) [P1T1]: Got : AdGroupName 2012-12-04 09:51:22.741 (2) [P1T1]: Got : KeywordContentMaxCpc 2012-12-04 09:51:22.741 (2) [P1T1]: Got : ProxyKeywordMaxCpc 2012-12-04 09:51:22.741 (2) [P1T1]: Got : MaxCpm 2012-12-04 09:51:22.742 (2) [P1T1]: Got : KeywordMaxCpc 2012-12-04 09:51:22.742 (2) [P1T1]: Got : AdGroupId 2012-12-04 09:51:22.783 (2) [DownloaderT3]: Downloading report : Adgroup Performance Report 2012-12-04 09:51:22.783 (2) [DownloaderT2]: Downloading report : Criteria Performance Report 2012-12-04 09:51:22.784 (2) [DownloaderT1]: Downloading report : Keyword Performance Report 2012-12-04 09:51:22.787 (3) [DownloaderT2]: Downloading report attempt 1: Customer Client ID: 9001082081 2012-12-04 09:51:22.787 (3) [DownloaderT3]: Downloading report attempt 1: Customer Client ID: 9001082081 2012-12-04 09:51:22.789 (3) [DownloaderT1]: Downloading report attempt 1: Customer Client ID: 9001082081 2012-12-04 09:51:24.990 (4) [DownloaderT3]: XML->AdGroupNameKeywordContentMaxCpcProxyKeywordMaxCpcMaxCpmKeywordMaxCpcAdGroupIdAdgroup Performance ReportADGROUP_PERFORMANCE_REPORTYESTERDAYGZIPPED_XMLtrue 2012-12-04 09:51:24.995 (4) [DownloaderT2]: XML->CampaignIdAdGroupIdIdAdGroupStatusMaxCpcMaxCpmCriteriaTypeStatusCriteriaDestinationUrlIsNegativeCriteriaCriteriaTypeINVERTICALPLACEMENTCriteria Performance ReportCRITERIA_PERFORMANCE_REPORTYESTERDAYGZIPPED_XMLtrue 2012-12-04 09:51:25.001 (4) [DownloaderT1]: XML->CampaignIdAdGroupIdIdAdGroupStatusMaxCpcMaxCpmKeywordMatchTypeStatusDestinationUrlIsNegativeKeywordTextKeyword Performance ReportKEYWORDS_PERFORMANCE_REPORTYESTERDAYGZIPPED_XMLtrue 2012-12-04 09:51:27.158 (2) [P1T1]: Downloaded and validated Keyword Performance Report 118733 bytes. 2012-12-04 09:51:27.159 (2) [P1T1]: Downloaded and validated Criteria Performance Report 79469 bytes. 2012-12-04 09:51:27.159 (2) [P1T1]: Downloaded and validated Adgroup Performance Report 10225 bytes. 2012-12-04 09:51:27.159 (2) [P1T1]: Parsing report as secondary report: Adgroup Performance Report 2012-12-04 09:51:27.162 (3) [P1T1]: parsing columns for Adgroup Performance Report 2012-12-04 09:51:27.165 (4) [P1T1]: Found column 'adGroup' 2012-12-04 09:51:27.165 (4) [P1T1]: Ignoring attribute display=Ad group 2012-12-04 09:51:27.165 (4) [P1T1]: Found column 'displayNetworkMaxCPC' 2012-12-04 09:51:27.165 (4) [P1T1]: Ignoring attribute display=Display Network max. CPC 2012-12-04 09:51:27.165 (4) [P1T1]: Found column 'defaultMaxCPC' 2012-12-04 09:51:27.165 (4) [P1T1]: Ignoring attribute display=Default max. CPC 2012-12-04 09:51:27.166 (4) [P1T1]: Found column 'maxCPM' 2012-12-04 09:51:27.166 (4) [P1T1]: Ignoring attribute display=Max. CPM 2012-12-04 09:51:27.166 (4) [P1T1]: Found column 'adGroupID' 2012-12-04 09:51:27.166 (4) [P1T1]: Ignoring attribute display=Ad group ID 2012-12-04 09:51:27.175 (3) [P1T1]: parsing rows for Adgroup Performance Report 2012-12-04 09:51:27.348 (2) [P1T1]: Finished parsing report: Adgroup Performance Report 2012-12-04 09:51:27.354 (2) [P1T1]: Parsing report as primary report: Keyword Performance Report with 248785944 bytes free 2012-12-04 09:51:27.365 (3) [P1T1]: parsing columns for Keyword Performance Report 2012-12-04 09:51:27.368 (3) [P1T1]: Columns already defined 2012-12-04 09:51:27.368 (4) [P1T1]: Found column 'campaignID' 2012-12-04 09:51:27.368 (4) [P1T1]: Ignoring attribute display=Campaign ID 2012-12-04 09:51:27.368 (4) [P1T1]: Found column 'adGroupID' 2012-12-04 09:51:27.368 (4) [P1T1]: Ignoring attribute display=Ad group ID 2012-12-04 09:51:27.368 (4) [P1T1]: Found column 'keywordID' 2012-12-04 09:51:27.369 (4) [P1T1]: Ignoring attribute display=Keyword ID 2012-12-04 09:51:27.369 (4) [P1T1]: Found column 'adGroupState' 2012-12-04 09:51:27.369 (4) [P1T1]: Ignoring attribute display=Ad group state 2012-12-04 09:51:27.369 (4) [P1T1]: Found column 'maxCPC' 2012-12-04 09:51:27.369 (4) [P1T1]: Ignoring attribute display=Max. CPC 2012-12-04 09:51:27.369 (4) [P1T1]: Found column 'maxCPM' 2012-12-04 09:51:27.369 (4) [P1T1]: Ignoring attribute display=Max. CPM 2012-12-04 09:51:27.369 (4) [P1T1]: Found column 'matchType' 2012-12-04 09:51:27.369 (4) [P1T1]: Ignoring attribute display=Match type 2012-12-04 09:51:27.370 (4) [P1T1]: Found column 'keywordState' 2012-12-04 09:51:27.370 (4) [P1T1]: Ignoring attribute display=Keyword state 2012-12-04 09:51:27.370 (4) [P1T1]: Found column 'destinationURL' 2012-12-04 09:51:27.370 (4) [P1T1]: Ignoring attribute display=Destination URL 2012-12-04 09:51:27.370 (4) [P1T1]: Found column 'isNegative' 2012-12-04 09:51:27.370 (4) [P1T1]: Ignoring attribute display=Is negative 2012-12-04 09:51:27.370 (4) [P1T1]: Found column 'keyword' 2012-12-04 09:51:27.371 (4) [P1T1]: Ignoring attribute display=Keyword 2012-12-04 09:51:27.503 (3) [P1T1]: parsing rows for Keyword Performance Report 2012-12-04 09:51:30.672 (2) [P1T1]: Finished parsing report: Keyword Performance Report 2012-12-04 09:51:30.672 (2) [P1T1]: Parsing report as primary report: Criteria Performance Report with 243171088 bytes free 2012-12-04 09:51:30.676 (3) [P1T1]: parsing columns for Criteria Performance Report 2012-12-04 09:51:30.677 (3) [P1T1]: Columns already defined 2012-12-04 09:51:30.678 (4) [P1T1]: Found column 'campaignID' 2012-12-04 09:51:30.678 (4) [P1T1]: Ignoring attribute display=Campaign ID 2012-12-04 09:51:30.678 (4) [P1T1]: Found column 'adGroupID' 2012-12-04 09:51:30.678 (4) [P1T1]: Ignoring attribute display=Ad group ID 2012-12-04 09:51:30.678 (4) [P1T1]: Found column 'keywordID' 2012-12-04 09:51:30.678 (4) [P1T1]: Ignoring attribute display=Keyword ID 2012-12-04 09:51:30.678 (4) [P1T1]: Found column 'adGroupState' 2012-12-04 09:51:30.678 (4) [P1T1]: Ignoring attribute display=Ad group state 2012-12-04 09:51:30.679 (4) [P1T1]: Found column 'maxCPC' 2012-12-04 09:51:30.679 (4) [P1T1]: Ignoring attribute display=Max. CPC 2012-12-04 09:51:30.679 (4) [P1T1]: Found column 'maxCPM' 2012-12-04 09:51:30.679 (4) [P1T1]: Ignoring attribute display=Max. CPM 2012-12-04 09:51:30.679 (4) [P1T1]: Found column 'criteriaType' 2012-12-04 09:51:30.679 (4) [P1T1]: Ignoring attribute display=Criteria Type 2012-12-04 09:51:30.679 (4) [P1T1]: Found column 'keywordPlacementState' 2012-12-04 09:51:30.679 (4) [P1T1]: Ignoring attribute display=Keyword/Placement state 2012-12-04 09:51:30.679 (4) [P1T1]: Found column 'keywordPlacementDestinationURL' 2012-12-04 09:51:30.680 (4) [P1T1]: Ignoring attribute display=Keyword/Placement destination URL 2012-12-04 09:51:30.680 (4) [P1T1]: Found column 'isNegative' 2012-12-04 09:51:30.680 (4) [P1T1]: Ignoring attribute display=Is negative 2012-12-04 09:51:30.680 (4) [P1T1]: Found column 'keywordPlacement' 2012-12-04 09:51:30.680 (4) [P1T1]: Ignoring attribute display=Keyword / Placement 2012-12-04 09:51:30.786 (3) [P1T1]: parsing rows for Criteria Performance Report 2012-12-04 09:51:32.589 (2) [P1T1]: Finished parsing report: Criteria Performance Report 2012-12-04 09:51:35.680 (2) [P1T1]: Created temp file: /var/local/tsa/google_sync_files/tsa-keyword-structure-report--3177-2012-12-04 09:51:2215929.tmp 2012-12-04 09:51:35.680 (2) [P1T1]: googleAds 2012-12-04 09:51:35.682 (2) [P1T1]: Getting columns for : Ad Performance Report 2012-12-04 09:51:35.682 (2) [P1T1]: Got : CampaignId 2012-12-04 09:51:35.682 (2) [P1T1]: Got : AdGroupId 2012-12-04 09:51:35.682 (2) [P1T1]: Got : Headline 2012-12-04 09:51:35.682 (2) [P1T1]: Got : Description1 2012-12-04 09:51:35.682 (2) [P1T1]: Got : Description2 2012-12-04 09:51:35.682 (2) [P1T1]: Got : DisplayUrl 2012-12-04 09:51:35.682 (2) [P1T1]: Got : Id 2012-12-04 09:51:35.682 (2) [P1T1]: Got : AdType 2012-12-04 09:51:35.682 (2) [P1T1]: Got : Status 2012-12-04 09:51:35.683 (2) [P1T1]: Got : CreativeDestinationUrl 2012-12-04 09:51:35.752 (2) [DownloaderT1]: Downloading report : Ad Performance Report 2012-12-04 09:51:35.753 (3) [DownloaderT1]: Downloading report attempt 1: Customer Client ID: 9001082081 2012-12-04 09:51:36.271 (4) [DownloaderT1]: XML->CampaignIdAdGroupIdHeadlineDescription1Description2DisplayUrlIdAdTypeStatusCreativeDestinationUrlAd Performance ReportAD_PERFORMANCE_REPORTYESTERDAYGZIPPED_XMLtrue 2012-12-04 09:51:40.617 (4) [ConnectionCloser]: 4 DatabasePools remaining : 0 pending closure 2012-12-04 09:51:41.388 (2) [P1T1]: Downloaded and validated Ad Performance Report 240923 bytes. 2012-12-04 09:51:41.389 (2) [P1T1]: Parsing report as primary report: Ad Performance Report with 246587088 bytes free 2012-12-04 09:51:41.393 (3) [P1T1]: parsing columns for Ad Performance Report 2012-12-04 09:51:41.415 (4) [P1T1]: Found column 'campaignID' 2012-12-04 09:51:41.416 (4) [P1T1]: Ignoring attribute display=Campaign ID 2012-12-04 09:51:41.416 (4) [P1T1]: Found column 'adGroupID' 2012-12-04 09:51:41.416 (4) [P1T1]: Ignoring attribute display=Ad group ID 2012-12-04 09:51:41.416 (4) [P1T1]: Found column 'ad' 2012-12-04 09:51:41.416 (4) [P1T1]: Ignoring attribute display=Ad 2012-12-04 09:51:41.416 (4) [P1T1]: Found column 'descriptionLine1' 2012-12-04 09:51:41.417 (4) [P1T1]: Ignoring attribute display=Description line 1 2012-12-04 09:51:41.417 (4) [P1T1]: Found column 'descriptionLine2' 2012-12-04 09:51:41.417 (4) [P1T1]: Ignoring attribute display=Description line 2 2012-12-04 09:51:41.417 (4) [P1T1]: Found column 'displayURL' 2012-12-04 09:51:41.417 (4) [P1T1]: Ignoring attribute display=Display URL 2012-12-04 09:51:41.417 (4) [P1T1]: Found column 'adID' 2012-12-04 09:51:41.417 (4) [P1T1]: Ignoring attribute display=Ad ID 2012-12-04 09:51:41.417 (4) [P1T1]: Found column 'adType' 2012-12-04 09:51:41.417 (4) [P1T1]: Ignoring attribute display=Ad type 2012-12-04 09:51:41.418 (4) [P1T1]: Found column 'adState' 2012-12-04 09:51:41.418 (4) [P1T1]: Ignoring attribute display=Ad state 2012-12-04 09:51:41.419 (4) [P1T1]: Found column 'destinationURL' 2012-12-04 09:51:41.419 (4) [P1T1]: Ignoring attribute display=Destination URL 2012-12-04 09:51:41.755 (3) [P1T1]: parsing rows for Ad Performance Report 2012-12-04 09:51:45.533 (2) [P1T1]: Finished parsing report: Ad Performance Report 2012-12-04 09:51:47.609 (2) [P1T1]: Created temp file: /var/local/tsa/google_sync_files/tsa-creative-structure-report--3177-2012-12-04 09:51:2215930.tmp 2012-12-04 09:51:47.609 (3) [P1T1]: -- Data staging complete for seuser ((3177) "AT&T Pan Asian Youth Campaign") 2012-12-04 09:51:47.612 (4) [P1T1]: spike: SQL->[select distinct `tsacommon`.`searchEngineUsers`.`accountID` AS `seUser_acctID`,`tsacommon`.`searchEngineAccounts`.`accountID` AS `seAcct_acctID` from `searchEngineAccounts` join `accounts` on ((`tsacommon`.`accounts`.`id`=`tsacommon`.`searchEngineAccounts`.`accountID`)) join `searchEngineUsers` on ((`tsacommon`.`searchEngineUsers`.`id`=`tsacommon`.`searchEngineAccounts`.`searchEngineUserID`)) where ((`tsacommon`.`searchEngineUsers`.`id`=3177) and (`tsacommon`.`accounts`.`id` in (898)) and (`tsacommon`.`searchEngineUsers`.`enabled`="true") and (`tsacommon`.`accounts`.`isActive`="true") and (`tsacommon`.`searchEngineUsers`.`distributionID`=3))] 2012-12-04 09:51:47.613 (4) [P1T1]: time=0.0010 2012-12-04 09:51:47.614 (4) [P1T1]: Query executed in 0.001s 2012-12-04 09:51:47.616 (4) [P1T1]: DataCache: Found key acct-sync-google 898 2012-12-04 09:51:47.616 (4) [P1T1]: DataCache: Found key acct-sync-google-5 2012-12-04 09:51:47.631 (4) [P1T1]: opened [jdbc:mysql://acctdb-05-write:3309/sync_google?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-12-04 09:51:47.632 (4) [P1T1]: Created new Object 2012-12-04 09:51:47.632 (4) [P1T1]: spike: SQL->[select @@version] 2012-12-04 09:51:47.633 (4) [P1T1]: time=0.0010 2012-12-04 09:51:47.633 (4) [P1T1]: Query executed in 0.001s 2012-12-04 09:51:47.634 (4) [P1T1]: test query succeeded, returned "5.1.61-rel13.2" 2012-12-04 09:51:47.634 (4) [P1T1]: spike: SQL->[SELECT GET_LOCK('com.thesearchagency.searchengines.google.GoogleStructureSync.searchEngineUserID.3177', 10800)] 2012-12-04 09:51:47.635 (4) [P1T1]: time=0.0010 2012-12-04 09:51:47.635 (4) [P1T1]: Query executed in 0.001s 2012-12-04 09:51:47.641 (4) [P1T1]: DB IsolationLevel -> 4 2012-12-04 09:51:47.642 (4) [P1T1]: DB AutoCommit -> false 2012-12-04 09:51:47.642 (4) [P1T1]: spike: SQL->[start transaction] 2012-12-04 09:51:47.643 (4) [P1T1]: time=0.0010 2012-12-04 09:51:47.644 (4) [P1T1]: Query executed in 0.001s 2012-12-04 09:51:47.644 (3) [P1T1]: Loading data infile into temp table... 2012-12-04 09:51:47.649 (4) [P1T1]: spike: SQL->[create temporary table `tmp`.`tmp1` (index(searchEngineUserID,campaignid,adgroupid,keywordid)) engine=myisam character set latin1 collate latin1_swedish_ci select * from `sync_google`.`googleKeywords` where (0)] 2012-12-04 09:51:47.651 (4) [P1T1]: time=0.0020 2012-12-04 09:51:47.652 (4) [P1T1]: Query executed in 0.002s 2012-12-04 09:51:47.652 (2) [P1T1]: Trying to load : /var/local/tsa/google_sync_files/tsa-keyword-structure-report--3177-2012-12-04 09:51:2215929.tmp into `tmp`.`tmp1` 2012-12-04 09:51:47.652 (4) [P1T1]: spike: SQL->[LOAD DATA LOCAL INFILE "/var/local/tsa/google_sync_files/tsa-keyword-structure-report--3177-2012-12-04 09:51:2215929.tmp" INTO TABLE `tmp`.`tmp1` ( campaignId, adgroupId, keywordid, adgroup, agStatus, maxCpc, maxCpm, kwType, kwStatus, kwDestUrl, kwisnegative, keyword, maxContentCpc, adGroupMaxCpc, adGroupMaxContentCpc, adGroupMaxCpm, adGroupSiteMaxCpc )] 2012-12-04 09:51:47.892 (4) [P1T1]: time=0.239 2012-12-04 09:51:47.892 (4) [P1T1]: Query executed in 0.239s 2012-12-04 09:51:47.892 (4) [P1T1]: spike: SQL->[UPDATE `tmp`.`tmp1` set searchEngineUserID= 3177] 2012-12-04 09:51:48.117 (4) [P1T1]: time=0.225 2012-12-04 09:51:48.117 (4) [P1T1]: Query executed in 0.225s 2012-12-04 09:51:48.118 (4) [P1T1]: spike: SQL->[create temporary table `tmp`.`tmp2` (index(searchEngineUserID,campaignid,creativeid,adgroupid)) engine=myisam character set latin1 collate latin1_swedish_ci select * from `sync_google`.`googleAds` where (0)] 2012-12-04 09:51:48.119 (4) [P1T1]: time=0.0010 2012-12-04 09:51:48.120 (4) [P1T1]: Query executed in 0.001s 2012-12-04 09:51:48.120 (2) [P1T1]: Trying to load : /var/local/tsa/google_sync_files/tsa-creative-structure-report--3177-2012-12-04 09:51:2215930.tmp into `tmp`.`tmp2` 2012-12-04 09:51:48.120 (4) [P1T1]: spike: SQL->[LOAD DATA LOCAL INFILE "/var/local/tsa/google_sync_files/tsa-creative-structure-report--3177-2012-12-04 09:51:2215930.tmp" INTO TABLE `tmp`.`tmp2` (`campaignid`,`adgroupid`,`headline`,`desc1`,`desc2`,`creativeVisUrl`,`creativeid`,`creativeType`,`creativeStatus`,`creativeDestUrl`)] 2012-12-04 09:51:48.446 (4) [P1T1]: time=0.325 2012-12-04 09:51:48.446 (4) [P1T1]: Query executed in 0.325s 2012-12-04 09:51:48.446 (4) [P1T1]: spike: SQL->[UPDATE `tmp`.`tmp2` set searchEngineUserID= 3177] 2012-12-04 09:51:48.996 (4) [P1T1]: time=0.55 2012-12-04 09:51:48.997 (4) [P1T1]: Query executed in 0.550s 2012-12-04 09:51:48.997 (3) [P1T1]: LOAD TEMP SYNC TABLES COMPLETED 2012-12-04 09:51:48.998 (4) [P1T1]: spike: SQL->[select distinct `tmp`.`tmp1`.campaignid from `tmp`.`tmp1` left join `sync_google`.`googleKeywords` on (((`sync_google`.`googleKeywords`.`searchEngineUserID`=`tmp`.`tmp1`.`searchEngineUserID`) and (`sync_google`.`googleKeywords`.`adgroupid`=`tmp`.`tmp1`.`adgroupid`) and (`sync_google`.`googleKeywords`.`campaignid`=`tmp`.`tmp1`.`campaignid`) and (`sync_google`.`googleKeywords`.`keywordid`=`tmp`.`tmp1`.`keywordid`))) where ((`sync_google`.`googleKeywords`.`campaignid` is null))] 2012-12-04 09:51:49.082 (4) [P1T1]: time=0.084 2012-12-04 09:51:49.082 (4) [P1T1]: Query executed in 0.084s 2012-12-04 09:51:49.083 (4) [P1T1]: spike: SQL->[select distinct `tmp`.`tmp2`.campaignid from `tmp`.`tmp2` left join `sync_google`.`googleAds` on (((`sync_google`.`googleAds`.`searchEngineUserID`=`tmp`.`tmp2`.`searchEngineUserID`) and (`sync_google`.`googleAds`.`adgroupid`=`tmp`.`tmp2`.`adgroupid`) and (`sync_google`.`googleAds`.`campaignid`=`tmp`.`tmp2`.`campaignid`) and (`sync_google`.`googleAds`.`creativeid`=`tmp`.`tmp2`.`creativeid`))) where ((`sync_google`.`googleAds`.`campaignid` is null))] 2012-12-04 09:51:49.268 (4) [P1T1]: time=0.184 2012-12-04 09:51:49.268 (4) [P1T1]: Query executed in 0.184s 2012-12-04 09:51:49.268 (3) [P1T1]: Campaigns with new items:([]) 2012-12-04 09:51:49.269 (3) [P1T1]: DETECTION OF NEW CAMPAIGN ITEMS COMPLETED 2012-12-04 09:51:49.269 (4) [P1T1]: spike: SQL->[select `sync_google`.`googleKeywords`.searchEngineUserID,`sync_google`.`googleKeywords`.campaignid,`sync_google`.`googleKeywords`.adgroupid,`sync_google`.`googleKeywords`.keywordid from `sync_google`.`googleKeywords` left join `tmp`.`tmp1` on (((`sync_google`.`googleKeywords`.`searchEngineUserID`=`tmp`.`tmp1`.`searchEngineUserID`) and (`sync_google`.`googleKeywords`.`adgroupid`=`tmp`.`tmp1`.`adgroupid`) and (`sync_google`.`googleKeywords`.`campaignid`=`tmp`.`tmp1`.`campaignid`) and (`sync_google`.`googleKeywords`.`keywordid`=`tmp`.`tmp1`.`keywordid`))) where ((`tmp`.`tmp1`.campaignid is null) and (`sync_google`.`googleKeywords`.`searchEngineUserID`=3177))] 2012-12-04 09:51:49.316 (4) [P1T1]: time=0.047 2012-12-04 09:51:49.316 (4) [P1T1]: Query executed in 0.047s 2012-12-04 09:51:49.317 (4) [P1T1]: spike: SQL->[select `sync_google`.`googleAds`.searchEngineUserID,`sync_google`.`googleAds`.campaignid,`sync_google`.`googleAds`.adgroupid,`sync_google`.`googleAds`.creativeid from `sync_google`.`googleAds` left join `tmp`.`tmp2` on (((`sync_google`.`googleAds`.`searchEngineUserID`=`tmp`.`tmp2`.`searchEngineUserID`) and (`sync_google`.`googleAds`.`adgroupid`=`tmp`.`tmp2`.`adgroupid`) and (`sync_google`.`googleAds`.`campaignid`=`tmp`.`tmp2`.`campaignid`) and (`sync_google`.`googleAds`.`creativeid`=`tmp`.`tmp2`.`creativeid`))) where ((`sync_google`.`googleAds`.`campaignid` is null) and (`sync_google`.`googleAds`.`searchEngineUserID`=3177))] 2012-12-04 09:51:49.318 (4) [P1T1]: time=0.0010 2012-12-04 09:51:49.318 (4) [P1T1]: Query executed in 0.001s 2012-12-04 09:51:49.318 (3) [P1T1]: Campaigns with deleted items:([]) 2012-12-04 09:51:49.318 (3) [P1T1]: DETECTION OF DELETED CAMPAIGN ITEMS COMPLETED 2012-12-04 09:51:49.320 (4) [P1T1]: spike: SQL->[select distinct `tmp`.`tmp1`.campaignid from `tmp`.`tmp1` inner join `sync_google`.`googleKeywords` on (((`sync_google`.`googleKeywords`.`searchEngineUserID`=`tmp`.`tmp1`.`searchEngineUserID`) and (`sync_google`.`googleKeywords`.`adgroupid`=`tmp`.`tmp1`.`adgroupid`) and (`sync_google`.`googleKeywords`.`campaignid`=`tmp`.`tmp1`.`campaignid`) and (`sync_google`.`googleKeywords`.`keywordid`=`tmp`.`tmp1`.`keywordid`))) where (((`sync_google`.`googleKeywords`.`keyword`!=`tmp`.`tmp1`.`keyword`) or (`sync_google`.`googleKeywords`.`kwType`!=`tmp`.`tmp1`.`kwType`) or (`sync_google`.`googleKeywords`.`kwStatus`!=`tmp`.`tmp1`.`kwStatus`) or (`sync_google`.`googleKeywords`.`kwDestUrl`!=`tmp`.`tmp1`.`kwDestUrl`) or (`sync_google`.`googleKeywords`.`agStatus`!=`tmp`.`tmp1`.`agStatus`) or (`sync_google`.`googleKeywords`.`kwisnegative`!=`tmp`.`tmp1`.`kwisnegative`)))] 2012-12-04 09:51:49.484 (4) [P1T1]: time=0.164 2012-12-04 09:51:49.484 (4) [P1T1]: Query executed in 0.164s 2012-12-04 09:51:49.486 (4) [P1T1]: spike: SQL->[select distinct `tmp`.`tmp2`.campaignid from `tmp`.`tmp2` inner join `sync_google`.`googleAds` on (((`sync_google`.`googleAds`.`searchEngineUserID`=`tmp`.`tmp2`.`searchEngineUserID`) and (`sync_google`.`googleAds`.`campaignid`=`tmp`.`tmp2`.`campaignid`) and (`sync_google`.`googleAds`.`adgroupid`=`tmp`.`tmp2`.`adgroupid`) and (`sync_google`.`googleAds`.`creativeid`=`tmp`.`tmp2`.`creativeid`))) where (((`sync_google`.`googleAds`.`headline`!=`tmp`.`tmp2`.`headline`) or (`sync_google`.`googleAds`.`desc1`!=`tmp`.`tmp2`.`desc1`) or (`sync_google`.`googleAds`.`desc2`!=`tmp`.`tmp2`.`desc2`) or (`sync_google`.`googleAds`.`creativeVisUrl`!=`tmp`.`tmp2`.`creativeVisUrl`) or (`sync_google`.`googleAds`.`creativeType`!=`tmp`.`tmp2`.`creativeType`) or (`sync_google`.`googleAds`.`creativeStatus`!=`tmp`.`tmp2`.`creativeStatus`) or (`sync_google`.`googleAds`.`creativeDestUrl`!=`tmp`.`tmp2`.`creativeDestUrl`)))] 2012-12-04 09:51:49.846 (4) [P1T1]: time=0.36 2012-12-04 09:51:49.847 (4) [P1T1]: Query executed in 0.360s 2012-12-04 09:51:49.847 (3) [P1T1]: Campaigns with updated items:([]) 2012-12-04 09:51:49.847 (3) [P1T1]: DETECTION OF UPDATED CAMPAIGN ITEMS COMPLETED 2012-12-04 09:51:49.848 (4) [P1T1]: spike: SQL->[delete from `sync_google`.`googleKeywords` where ((`searchEngineUserID`=3177))], genflags=no 2012-12-04 09:51:49.920 (4) [P1T1]: time=0.072 2012-12-04 09:51:49.920 (4) [P1T1]: Query executed in 0.072s, 12666 row(s) affected 2012-12-04 09:51:49.920 (3) [P1T1]: 12666 keyword records removed before re-loading staging table. 2012-12-04 09:51:49.921 (4) [P1T1]: spike: SQL->[insert into `sync_google`.`googleKeywords` (`searchEngineUserID`,`campaignid`,`adgroupid`,`keywordid`,`keyword`,`kwType`,`kwStatus`,`maxCpc`,`maxCpm`,`maxContentCpc`,`kwDestUrl`,`kwisnegative`,`agStatus`,`adGroupMaxContentCpc`,`adGroupMaxCpc`,`adGroupMaxCpm`,`adGroupSiteMaxCpc`,`adgroup`) select `searchEngineUserID`,`campaignid`,`adgroupid`,`keywordid`,`keyword`,`kwType`,`kwStatus`,`maxCpc`,`maxCpm`,`maxContentCpc`,`kwDestUrl`,`kwisnegative`,`agStatus`,`adGroupMaxContentCpc`,`adGroupMaxCpc`,`adGroupMaxCpm`,`adGroupSiteMaxCpc`,`adgroup` from `tmp`.`tmp1` where ((`searchEngineUserID`=3177))], genflags=no 2012-12-04 09:51:50.186 (4) [P1T1]: time=0.265 2012-12-04 09:51:50.186 (4) [P1T1]: Query executed in 0.265s, 12666 row(s) affected 2012-12-04 09:51:50.187 (3) [P1T1]: 12666 keyword records loaded into staging table. 2012-12-04 09:51:50.187 (4) [P1T1]: spike: SQL->[delete from `sync_google`.`googleAds` where ((`searchEngineUserID`=3177))], genflags=no 2012-12-04 09:51:50.357 (4) [P1T1]: time=0.17 2012-12-04 09:51:50.357 (4) [P1T1]: Query executed in 0.170s, 29524 row(s) affected 2012-12-04 09:51:50.357 (3) [P1T1]: 29524 creative ad records removed from staging table before re-loading. 2012-12-04 09:51:50.359 (4) [P1T1]: spike: SQL->[insert into `sync_google`.`googleAds` (`searchEngineUserID`,`campaignid`,`adgroupid`,`headline`,`desc1`,`desc2`,`creativeVisUrl`,`creativeid`,`creativeType`,`creativeStatus`,`creativeDestUrl`) select `searchEngineUserID`,`campaignid`,`adgroupid`,`headline`,`desc1`,`desc2`,`creativeVisUrl`,`creativeid`,`creativeType`,`creativeStatus`,`creativeDestUrl` from `tmp`.`tmp2` where ((`searchEngineUserID`=3177))], genflags=no 2012-12-04 09:51:50.886 (4) [P1T1]: time=0.527 2012-12-04 09:51:50.886 (4) [P1T1]: Query executed in 0.527s, 29524 row(s) affected 2012-12-04 09:51:50.886 (3) [P1T1]: 29524 creative ad records loaded into staging table. 2012-12-04 09:51:50.887 (3) [P1T1]: UPDATE OF STAGING TABLES COMPLETED 2012-12-04 09:51:50.887 (3) [P1T1]: Passing seUserAcctId: 898 and seAcctAcctId: 898 2012-12-04 09:51:50.887 (4) [P1T1]: DataCache: Found key acct-st-tracker 898 2012-12-04 09:51:50.888 (4) [P1T1]: DataCache: Found key acct-st-tracker-5 2012-12-04 09:51:50.902 (4) [P1T1]: opened [jdbc:mysql://acctdb-05-write:3309/st-tracker?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-12-04 09:51:50.902 (4) [P1T1]: Created new Object 2012-12-04 09:51:50.902 (4) [P1T1]: spike: SQL->[select @@version] 2012-12-04 09:51:50.903 (4) [P1T1]: time=0.0010 2012-12-04 09:51:50.904 (4) [P1T1]: Query executed in 0.001s 2012-12-04 09:51:50.904 (4) [P1T1]: test query succeeded, returned "5.1.61-rel13.2" 2012-12-04 09:51:50.905 (4) [P1T1]: spike: SQL->[select `searchEngineIdentifier` from `tsacommon`.`searchEngineAccounts` where ((`tsacommon`.`searchEngineAccounts`.`accountID`="898") and (`tsacommon`.`searchEngineAccounts`.`searchEngineUserID`="3177") and (`tsacommon`.`searchEngineAccounts`.`distributionID`=3))] 2012-12-04 09:51:50.906 (4) [P1T1]: time=0.0010 2012-12-04 09:51:50.906 (4) [P1T1]: Query executed in 0.001s 2012-12-04 09:51:50.911 (4) [P1T1]: spike: SQL->[select COUNT(*) from googleKeywords where ((`searchEngineUserID`="3177") and (`campaignid` in ("86452850","86453090","86453930","86454890","86452730","86453690","86453810","86453330","86455130","86453570","86454170","86454770","86454650","86452250","86454050","86453450","86452970","86454410","86452370","86454530","88317170","86452130","86455370","86455010","86453210","86452610","86454290","86452490","86455250","109102010","109102370","109102130","109562330","109562210")))] 2012-12-04 09:51:50.922 (4) [P1T1]: time=0.011 2012-12-04 09:51:50.922 (4) [P1T1]: Query executed in 0.011s 2012-12-04 09:51:50.922 (3) [P1T1]: Replicating 11370 rows... 2012-12-04 09:51:50.922 (4) [P1T1]: spike: SQL->[select * from googleKeywords where ((`searchEngineUserID`="3177") and (`campaignid` in ("86452850","86453090","86453930","86454890","86452730","86453690","86453810","86453330","86455130","86453570","86454170","86454770","86454650","86452250","86454050","86453450","86452970","86454410","86452370","86454530","88317170","86452130","86455370","86455010","86453210","86452610","86454290","86452490","86455250","109102010","109102370","109102130","109562330","109562210"))) limit 0, 10000] 2012-12-04 09:51:51.126 (4) [P1T1]: time=0.204 2012-12-04 09:51:51.127 (4) [P1T1]: Query executed in 0.204s 2012-12-04 09:51:51.127 (4) [P1T1]: spike: SQL->[show create table `sync_google`.`googleKeywords`] 2012-12-04 09:51:51.128 (4) [P1T1]: time=0.0010 2012-12-04 09:51:51.128 (4) [P1T1]: Query executed in 0.001s 2012-12-04 09:51:51.129 (4) [P1T1]: convertCreateTableToTemp: source: CREATE TABLE `googleKeywords` ( `searchEngineUserID` int(11) NOT NULL DEFAULT '0', `campaignid` bigint(20) NOT NULL DEFAULT '0', `adgroupid` bigint(20) NOT NULL DEFAULT '0', `keywordid` bigint(20) NOT NULL DEFAULT '0', `keyword` varchar(255) NOT NULL DEFAULT '', `kwType` varchar(25) NOT NULL DEFAULT 'unknown', `kwStatus` varchar(25) NOT NULL DEFAULT 'unknown', `maxCpc` double NOT NULL DEFAULT '0', `maxCpm` double NOT NULL DEFAULT '0', `maxContentCpc` double NOT NULL DEFAULT '0', `kwDestUrl` text NOT NULL, `kwisnegative` enum('false','true') NOT NULL DEFAULT 'false', `agStatus` varchar(25) NOT NULL DEFAULT 'unknown', `adGroupMaxContentCpc` double NOT NULL DEFAULT '0', `adGroupMaxCpc` double NOT NULL DEFAULT '0', `adGroupMaxCpm` double NOT NULL DEFAULT '0', `adGroupSiteMaxCpc` double NOT NULL DEFAULT '0', `adgroup` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`searchEngineUserID`,`campaignid`,`adgroupid`,`keywordid`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 2012-12-04 09:51:51.132 (4) [P1T1]: spike: SQL->[CREATE TEMPORARY TABLE `st-tracker`.`tmp3` ( `searchEngineUserID` int(11) DEFAULT '0', `campaignid` bigint(20) DEFAULT '0', `adgroupid` bigint(20) DEFAULT '0', `keywordid` bigint(20) DEFAULT '0', `keyword` varchar(255) DEFAULT '', `kwType` varchar(25) DEFAULT 'unknown', `kwStatus` varchar(25) DEFAULT 'unknown', `maxCpc` double DEFAULT '0', `maxCpm` double DEFAULT '0', `maxContentCpc` double DEFAULT '0', `kwDestUrl` text , `kwisnegative` enum('false','true') DEFAULT 'false', `agStatus` varchar(25) DEFAULT 'unknown', `adGroupMaxContentCpc` double DEFAULT '0', `adGroupMaxCpc` double DEFAULT '0', `adGroupMaxCpm` double DEFAULT '0', `adGroupSiteMaxCpc` double DEFAULT '0', `adgroup` varchar(255) DEFAULT '', PRIMARY KEY (`searchEngineUserID`,`campaignid`,`adgroupid`,`keywordid`) )] 2012-12-04 09:51:51.135 (4) [P1T1]: time=0.0030 2012-12-04 09:51:51.135 (4) [P1T1]: Query executed in 0.003s 2012-12-04 09:51:51.136 (4) [P1T1]: preparing SQL statement [insert into `st-tracker`.`tmp3` (`searchEngineUserID`, `campaignid`, `adgroupid`, `keywordid`, `keyword`, `kwType`, `kwStatus`, `maxCpc`, `maxCpm`, `maxContentCpc`, `kwDestUrl`, `kwisnegative`, `agStatus`, `adGroupMaxContentCpc`, `adGroupMaxCpc`, `adGroupMaxCpm`, `adGroupSiteMaxCpc`, `adgroup`) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)] 2012-12-04 09:51:53.944 (4) [P1T1]: replicated 10000 rows to `st-tracker`.`tmp3` 2012-12-04 09:51:53.945 (4) [P1T1]: spike: SQL->[select * from googleKeywords where ((`searchEngineUserID`="3177") and (`campaignid` in ("86452850","86453090","86453930","86454890","86452730","86453690","86453810","86453330","86455130","86453570","86454170","86454770","86454650","86452250","86454050","86453450","86452970","86454410","86452370","86454530","88317170","86452130","86455370","86455010","86453210","86452610","86454290","86452490","86455250","109102010","109102370","109102130","109562330","109562210"))) limit 10000, 10000] 2012-12-04 09:51:53.981 (4) [P1T1]: time=0.036 2012-12-04 09:51:53.982 (4) [P1T1]: Query executed in 0.036s 2012-12-04 09:51:53.999 (4) [P1T1]: preparing SQL statement [insert into `st-tracker`.`tmp3` (`searchEngineUserID`, `campaignid`, `adgroupid`, `keywordid`, `keyword`, `kwType`, `kwStatus`, `maxCpc`, `maxCpm`, `maxContentCpc`, `kwDestUrl`, `kwisnegative`, `agStatus`, `adGroupMaxContentCpc`, `adGroupMaxCpc`, `adGroupMaxCpm`, `adGroupSiteMaxCpc`, `adgroup`) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)] 2012-12-04 09:51:54.302 (4) [P1T1]: replicated 1370 rows to `st-tracker`.`tmp3` 2012-12-04 09:51:54.303 (4) [P1T1]: spike: SQL->[select COUNT(*) from `st-tracker`.`tmp3` where ((`searchEngineUserID`="3177") and (`campaignid` in ("86452850","86453090","86453930","86454890","86452730","86453690","86453810","86453330","86455130","86453570","86454170","86454770","86454650","86452250","86454050","86453450","86452970","86454410","86452370","86454530","88317170","86452130","86455370","86455010","86453210","86452610","86454290","86452490","86455250","109102010","109102370","109102130","109562330","109562210")))] 2012-12-04 09:51:54.309 (4) [P1T1]: time=0.0060 2012-12-04 09:51:54.309 (4) [P1T1]: Query executed in 0.006s 2012-12-04 09:51:54.311 (4) [P1T1]: spike: SQL->[select `tsacommon`.`searchEngineAccounts`.`id` from `tsacommon`.`searchEngineAccounts` where ((`tsacommon`.`searchEngineAccounts`.`lastChecked` is null) and (`tsacommon`.`searchEngineAccounts`.`accountID`="898") and (`tsacommon`.`searchEngineAccounts`.`distributionID`=3))] 2012-12-04 09:51:54.313 (4) [P1T1]: time=0.0020 2012-12-04 09:51:54.313 (4) [P1T1]: Query executed in 0.002s 2012-12-04 09:51:54.313 (3) [P1T1]: DETECTION OF CAMPAIGNS NEEDING FIRST SYNC COMPLETED 2012-12-04 09:51:54.316 (4) [P1T1]: spike: SQL->[select distinct `tsacommon`.`searchEngineAccounts`.`id` from `tsacommon`.`searchEngineAccounts` where ((`tsacommon`.`searchEngineAccounts`.`accountID`="898") and (`tsacommon`.`searchEngineAccounts`.`searchEngineUserID`="3177") and (`tsacommon`.`searchEngineAccounts`.`distributionID`=3))] 2012-12-04 09:51:54.318 (4) [P1T1]: time=0.0010 2012-12-04 09:51:54.318 (4) [P1T1]: Query executed in 0.001s 2012-12-04 09:51:54.324 (4) [P1T1]: spike: SQL->[select distinct `tsacommon`.`searchEngineAccounts`.`id` from `logging`.`searchEngineAccountChanges` left join `tsacommon`.`searchEngineAccounts` on ((`logging`.`searchEngineAccountChanges`.`searchEngineAccountID`=`tsacommon`.`searchEngineAccounts`.`id`)) where ((`logging`.`searchEngineAccountChanges`.`searchEngineAccountID` in ("63540","63541","63542","63543","63544","63545","63546","63547","63548","63549","63550","63551","63552","63553","63554","63555","63556","63557","63558","63559","63560","63561","63562","63563","63564","63565","63566","63567","63568","69733","69735","69737","69752","69753")) and (`logging`.`searchEngineAccountChanges`.`changeTime`>`tsacommon`.`searchEngineAccounts`.`lastChecked`) and (((`logging`.`searchEngineAccountChanges`.`column`="networkType") or (`logging`.`searchEngineAccountChanges`.`column`="contentType") or (`logging`.`searchEngineAccountChanges`.`column`="biddingStrategy"))) and (`tsacommon`.`searchEngineAccounts`.`accountID`="898") and (`tsacommon`.`searchEngineAccounts`.`enabled`="true") and (`tsacommon`.`searchEngineAccounts`.`searchEngineStatus`="ok") and (`tsacommon`.`searchEngineAccounts`.`distributionID`=3))] 2012-12-04 09:51:54.327 (4) [P1T1]: time=0.0030 2012-12-04 09:51:54.328 (4) [P1T1]: Query executed in 0.003s 2012-12-04 09:51:54.328 (3) [P1T1]: DETECTION OF CAMPAIGNS WITH CONTENT/NETWORK CHANGES COMPLETED 2012-12-04 09:51:54.328 (3) [P1T1]: -- Account-level operations complete for seuser ((3177) "AT&T Pan Asian Youth Campaign") and seAccount(898) 2012-12-04 09:51:54.336 (4) [P1T1]: spike: SQL->[create temporary table `tmp`.`tmp4` engine=myisam character set latin1 collate latin1_swedish_ci select `tsacommon`.`searchEngineAccounts`.`searchEngineUserID` AS `a_searchEngineUserID`,`tsacommon`.`searchEngineAccounts`.`searchEngineIdentifier` AS `a_campaignid`,`st-tracker`.`searchEngineGroups`.`searchEngineIdentifier` AS `a_adgroupid`,`sources`.`searchEngineIdentifier` AS `a_keywordid`,`sources`.`cost`,`sources`.`type`,`sources`.`searchEngineIdentifier`,`sources`.`searchEngineGroupIdentifier`,`sourceBidType`.`bidTypeID` from `tsacommon`.`searchEngineAccounts` join `st-tracker`.`searchEngineGroups` on ((`st-tracker`.`searchEngineGroups`.`searchEngineAccountID`=`tsacommon`.`searchEngineAccounts`.`id`)) join `st-tracker`.`sources` on (((((`st-tracker`.`searchEngineGroups`.`searchEngineAccountID`=`sources`.`searchEngineAccountID`)) and ((`sources`.`searchEngineGroupID`=`st-tracker`.`searchEngineGroups`.`id`))))) join `st-tracker`.`sourceBidType` on ((`sourceBidType`.`sourceID`=`sources`.`id`)) where ((`searchEngineUserID`=3177) and (`isBiddable`="true") and (`sources`.`searchEngineStatus` in ("ok","disabled")) and (`tsacommon`.`searchEngineAccounts`.`searchEngineStatus` in ("ok","disabled")) and (`st-tracker`.`searchEngineGroups`.`searchEngineStatus` in ("ok","disabled")) and (`type` in (1,9)))] 2012-12-04 09:52:10.624 (4) [ConnectionCloser]: 4 DatabasePools remaining : 0 pending closure 2012-12-04 09:52:22.197 (3) [main]: Waiting for tasks to be done 2012-12-04 09:52:40.628 (4) [ConnectionCloser]: 4 DatabasePools remaining : 0 pending closure 2012-12-04 09:53:10.632 (4) [ConnectionCloser]: 4 DatabasePools remaining : 0 pending closure 2012-12-04 09:53:40.636 (4) [ConnectionCloser]: 2 DatabasePools remaining : 0 pending closure 2012-12-04 09:54:10.643 (4) [ConnectionCloser]: 0 DatabasePools remaining : 0 pending closure 2012-12-04 09:54:10.644 (4) [ConnectionCloser]: Stopping DatabasePool ConnectionCloserThread 2012-12-04 09:56:33.674 (4) [P1T1]: time=279.338 2012-12-04 09:56:33.675 (4) [P1T1]: Query executed in 4m 39.338s 2012-12-04 09:56:33.675 (4) [P1T1]: spike: SQL->[ALTER TABLE `tmp`.`tmp4` modify a_searchEngineUserID int(11) NOT NULL default '0', modify a_campaignid int(11) NOT NULL default '0', modify a_adgroupid bigint(20) NOT NULL default '0', modify a_keywordid bigint(20) NOT NULL default '0', ADD INDEX joinIndex (a_searchEngineUserID, a_campaignid, a_adgroupid, a_keywordid)] 2012-12-04 09:56:33.706 (4) [P1T1]: time=0.031 2012-12-04 09:56:33.706 (4) [P1T1]: Query executed in 0.031s 2012-12-04 09:56:33.708 (4) [P1T1]: spike: SQL->[select COUNT(*) from `st-tracker`.`tmp3` where ((`searchEngineUserID`="3177") and (`campaignid` in ("86452850","86453090","86453930","86454890","86452730","86453690","86453810","86453330","86455130","86453570","86454170","86454770","86454650","86452250","86454050","86453450","86452970","86454410","86452370","86454530","88317170","86452130","86455370","86455010","86453210","86452610","86454290","86452490","86455250","109102010","109102370","109102130","109562330","109562210")))] 2012-12-04 09:56:33.715 (4) [P1T1]: time=0.0060 2012-12-04 09:56:33.715 (4) [P1T1]: Query executed in 0.006s 2012-12-04 09:56:33.715 (4) [P1T1]: spike: SQL->[select * from `st-tracker`.`tmp3` where ((`searchEngineUserID`="3177") and (`campaignid` in ("86452850","86453090","86453930","86454890","86452730","86453690","86453810","86453330","86455130","86453570","86454170","86454770","86454650","86452250","86454050","86453450","86452970","86454410","86452370","86454530","88317170","86452130","86455370","86455010","86453210","86452610","86454290","86452490","86455250","109102010","109102370","109102130","109562330","109562210"))) limit 0, 10000] 2012-12-04 09:56:33.841 (4) [P1T1]: time=0.126 2012-12-04 09:56:33.842 (4) [P1T1]: Query executed in 0.126s 2012-12-04 09:56:33.843 (4) [P1T1]: spike: SQL->[select `st-tracker`.`tmp3`.campaignid,`st-tracker`.`tmp3`.adgroupid,`st-tracker`.`tmp3`.keywordid,`st-tracker`.`tmp3`.kwType,`st-tracker`.`tmp3`.maxCpc,`st-tracker`.`tmp3`.maxCpm,`st-tracker`.`tmp3`.maxContentCpc,`tmp`.`tmp4`.cost,`tmp`.`tmp4`.type,`tmp`.`tmp4`.bidTypeID,`tmp`.`tmp4`.searchEngineIdentifier,`tmp`.`tmp4`.searchEngineGroupIdentifier from `st-tracker`.`tmp3` inner join `tmp`.`tmp4` on (((`tmp`.`tmp4`.a_searchEngineUserID=`st-tracker`.`tmp3`.`searchEngineUserID`) and (`tmp`.`tmp4`.a_campaignid=`st-tracker`.`tmp3`.`campaignid`) and (`tmp`.`tmp4`.a_adgroupid=`st-tracker`.`tmp3`.`adgroupid`) and (`tmp`.`tmp4`.a_keywordid=`st-tracker`.`tmp3`.`keywordid`))) where ((`st-tracker`.`tmp3`.`kwisnegative`="false") and (`st-tracker`.`tmp3`.`agStatus`="ENABLED"))] 2012-12-04 09:56:33.932 (4) [P1T1]: time=0.089 2012-12-04 09:56:33.933 (4) [P1T1]: Query executed in 0.089s 2012-12-04 09:56:34.715 (4) [P1T1]: spike: SQL->[delete from `st-tracker`.`tmp3` where ((`searchEngineUserID`="3177") and (`campaignid` in ("86452850","86453090","86453930","86454890","86452730","86453690","86453810","86453330","86455130","86453570","86454170","86454770","86454650","86452250","86454050","86453450","86452970","86454410","86452370","86454530","88317170","86452130","86455370","86455010","86453210","86452610","86454290","86452490","86455250","109102010","109102370","109102130","109562330","109562210")))], genflags=no 2012-12-04 09:56:34.837 (4) [P1T1]: time=0.122 2012-12-04 09:56:34.838 (4) [P1T1]: Query executed in 0.122s, 11370 row(s) affected 2012-12-04 09:56:34.838 (4) [P1T1]: spike: SQL->[select * from `st-tracker`.`tmp3` where ((`searchEngineUserID`="3177") and (`campaignid` in ("86452850","86453090","86453930","86454890","86452730","86453690","86453810","86453330","86455130","86453570","86454170","86454770","86454650","86452250","86454050","86453450","86452970","86454410","86452370","86454530","88317170","86452130","86455370","86455010","86453210","86452610","86454290","86452490","86455250","109102010","109102370","109102130","109562330","109562210"))) limit 10000, 10000] 2012-12-04 09:56:34.840 (4) [P1T1]: time=0.0010 2012-12-04 09:56:34.840 (4) [P1T1]: Query executed in 0.001s 2012-12-04 09:56:34.840 (4) [P1T1]: spike: SQL->[select `st-tracker`.`tmp3`.campaignid,`st-tracker`.`tmp3`.adgroupid,`st-tracker`.`tmp3`.keywordid,`st-tracker`.`tmp3`.kwType,`st-tracker`.`tmp3`.maxCpc,`st-tracker`.`tmp3`.maxCpm,`st-tracker`.`tmp3`.maxContentCpc,`tmp`.`tmp4`.cost,`tmp`.`tmp4`.type,`tmp`.`tmp4`.bidTypeID,`tmp`.`tmp4`.searchEngineIdentifier,`tmp`.`tmp4`.searchEngineGroupIdentifier from `st-tracker`.`tmp3` inner join `tmp`.`tmp4` on (((`tmp`.`tmp4`.a_searchEngineUserID=`st-tracker`.`tmp3`.`searchEngineUserID`) and (`tmp`.`tmp4`.a_campaignid=`st-tracker`.`tmp3`.`campaignid`) and (`tmp`.`tmp4`.a_adgroupid=`st-tracker`.`tmp3`.`adgroupid`) and (`tmp`.`tmp4`.a_keywordid=`st-tracker`.`tmp3`.`keywordid`))) where ((`st-tracker`.`tmp3`.`kwisnegative`="false") and (`st-tracker`.`tmp3`.`agStatus`="ENABLED"))] 2012-12-04 09:56:34.842 (4) [P1T1]: time=0.0020 2012-12-04 09:56:34.842 (4) [P1T1]: Query executed in 0.002s 2012-12-04 09:56:34.842 (4) [P1T1]: spike: SQL->[delete from `st-tracker`.`tmp3` where ((`searchEngineUserID`="3177") and (`campaignid` in ("86452850","86453090","86453930","86454890","86452730","86453690","86453810","86453330","86455130","86453570","86454170","86454770","86454650","86452250","86454050","86453450","86452970","86454410","86452370","86454530","88317170","86452130","86455370","86455010","86453210","86452610","86454290","86452490","86455250","109102010","109102370","109102130","109562330","109562210")))], genflags=no 2012-12-04 09:56:34.843 (4) [P1T1]: time=0.0010 2012-12-04 09:56:34.843 (4) [P1T1]: Query executed in 0.001s, 0 row(s) affected 2012-12-04 09:56:34.844 (3) [P1T1]: Keyword-level bidType changes: 0 2012-12-04 09:56:34.844 (3) [P1T1]: Keyword-level bidAmount changes: 0 2012-12-04 09:56:34.844 (3) [P1T1]: COMPLETED KEYWORD-LEVEL BID DETECTION FOR: seUser (3177) and seAccount(898) 2012-12-04 09:56:34.845 (4) [P1T1]: spike: SQL->[create temporary table `tmp`.`tmp5` engine=myisam character set latin1 collate latin1_swedish_ci select `tsacommon`.`searchEngineAccounts`.`searchEngineUserID` AS `a_searchEngineUserID`,`tsacommon`.`searchEngineAccounts`.`searchEngineIdentifier` AS `a_campaignid`,`st-tracker`.`searchEngineGroups`.`searchEngineIdentifier` AS `a_adgroupid`,`sources`.`searchEngineIdentifier` AS `a_keywordid`,`sources`.`cost`,`sources`.`type`,`sources`.`searchEngineIdentifier`,`sources`.`searchEngineGroupIdentifier`,`sourceBidType`.`bidTypeID` from `tsacommon`.`searchEngineAccounts` join `st-tracker`.`searchEngineGroups` on ((`st-tracker`.`searchEngineGroups`.`searchEngineAccountID`=`tsacommon`.`searchEngineAccounts`.`id`)) join `st-tracker`.`sources` on (((((`st-tracker`.`searchEngineGroups`.`searchEngineAccountID`=`sources`.`searchEngineAccountID`)) and ((`sources`.`searchEngineGroupID`=`st-tracker`.`searchEngineGroups`.`id`))))) join `st-tracker`.`sourceBidType` on ((`sourceBidType`.`sourceID`=`sources`.`id`)) where ((`searchEngineUserID`=3177) and (`isBiddable`="true") and (`type` in (7)))] 2012-12-04 10:01:32.115 (4) [P1T1]: time=297.27 2012-12-04 10:01:32.116 (4) [P1T1]: Query executed in 4m 57.270s 2012-12-04 10:01:32.116 (4) [P1T1]: spike: SQL->[ALTER TABLE `tmp`.`tmp5` modify a_searchEngineUserID int(11) NOT NULL default '0', modify a_campaignid int(11) NOT NULL default '0', modify a_adgroupid bigint(20) NOT NULL default '0', ADD INDEX joinIndex (a_searchEngineUserID, a_campaignid, a_adgroupid)] 2012-12-04 10:01:32.123 (4) [P1T1]: time=0.0070 2012-12-04 10:01:32.126 (4) [P1T1]: Query executed in 0.007s 2012-12-04 10:01:32.128 (4) [P1T1]: spike: SQL->[select COUNT(*) from `st-tracker`.`tmp3` where ((`searchEngineUserID`="3177") and (`campaignid` in ("86452850","86453090","86453930","86454890","86452730","86453690","86453810","86453330","86455130","86453570","86454170","86454770","86454650","86452250","86454050","86453450","86452970","86454410","86452370","86454530","88317170","86452130","86455370","86455010","86453210","86452610","86454290","86452490","86455250","109102010","109102370","109102130","109562330","109562210")))] 2012-12-04 10:01:32.134 (4) [P1T1]: time=0.0050 2012-12-04 10:01:32.136 (4) [P1T1]: Query executed in 0.005s 2012-12-04 10:01:32.137 (3) [P1T1]: Adgroup-level bidType changes: 0 2012-12-04 10:01:32.137 (3) [P1T1]: Adgroup-level bidAmount changes: 0 2012-12-04 10:01:32.138 (3) [P1T1]: COMPLETED ADGROUP-LEVEL BID DETECTION FOR: seUser (3177) and seAccount(898) 2012-12-04 10:01:32.138 (3) [P1T1]: -- Bid amount difference checks complete for seuser ((3177) "AT&T Pan Asian Youth Campaign") and seAccount(898) 2012-12-04 10:01:32.138 (3) [P1T1]: -- No out of sync seaccts found for se user: (3177) "AT&T Pan Asian Youth Campaign" 2012-12-04 10:01:32.138 (4) [P1T1]: spike: SQL->[commit] 2012-12-04 10:01:32.139 (4) [P1T1]: time=0.0010 2012-12-04 10:01:32.140 (4) [P1T1]: Query executed in 0.001s 2012-12-04 10:01:32.140 (4) [P1T1]: DB AutoCommit -> true 2012-12-04 10:01:32.140 (4) [P1T1]: DB IsolationLevel -> 4 2012-12-04 10:01:32.140 (4) [P1T1]: spike: SQL->[SELECT RELEASE_LOCK('com.thesearchagency.searchengines.google.GoogleStructureSync.searchEngineUserID.3177')] 2012-12-04 10:01:32.142 (4) [P1T1]: time=0.0010 2012-12-04 10:01:32.142 (4) [P1T1]: Query executed in 0.001s 2012-12-04 10:01:32.142 (4) [P1T1]: spike: SQL->[drop table `tmp`.`tmp1`] 2012-12-04 10:01:32.146 (4) [P1T1]: time=0.0030 2012-12-04 10:01:32.146 (4) [P1T1]: Query executed in 0.003s 2012-12-04 10:01:32.151 (4) [P1T1]: spike: SQL->[drop table `tmp`.`tmp2`] 2012-12-04 10:01:32.157 (4) [P1T1]: time=0.0060 2012-12-04 10:01:32.157 (4) [P1T1]: Query executed in 0.006s 2012-12-04 10:01:32.158 (3) [P1T1]: -- Keyword/Creative difference checks complete for seuser ((3177) "AT&T Pan Asian Youth Campaign") 2012-12-04 10:01:32.158 (3) [P1T1]: SE Acct Id Set size :: 0 2012-12-04 10:01:32.159 (4) [P1T1]: Returning Object to Pool 2012-12-04 10:01:32.159 (4) [P1T1]: Returning Object to Pool 2012-12-04 10:01:32.160 (4) [ConnectionCloser]: Starting DatabasePool ConnectionCloserThread 2012-12-04 10:01:32.160 (4) [P1T1]: Returning Object to Pool 2012-12-04 10:01:32.160 (4) [P1T1]: Returning Object to Pool 2012-12-04 10:01:46.635 (4) [main]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-12-04 10:01:46.636 (3) [main]: ------------SearchEngineSyncUserWorker done 2012-12-04 10:01:46.636 (3) [main]: No accounts to sync. 2012-12-04 10:01:46.641 (4) [main]: spike: SQL->[select * from `tsacommon`.`searchEngineAccounts` inner join `tsacommon`.`searchEngineUsers` on (((`tsacommon`.`searchEngineAccounts`.`searchEngineUserID`=`tsacommon`.`searchEngineUsers`.`id`))) inner join `tsacommon`.`accounts` on ((`tsacommon`.`accounts`.`id`=`tsacommon`.`searchEngineAccounts`.`accountID`)) where (((((`tsacommon`.`searchEngineAccounts`.`enabled`="true") and (((`tsacommon`.`searchEngineAccounts`.`searchEngineStatus`="ok") or (((`tsacommon`.`searchEngineAccounts`.`searchEngineStatus`="disabled") and (`tsacommon`.`searchEngineAccounts`.`paused`="true"))))) and (`tsacommon`.`searchEngineAccounts`.`accountID` in (898)) and (`tsacommon`.`searchEngineAccounts`.`distributionID`="3"))) and (((`tsacommon`.`searchEngineUsers`.`enabled`="true"))))) order by `tsacommon`.`accounts`.`tier` asc,`tsacommon`.`accounts`.`priority` asc,`tsacommon`.`accounts`.`id` desc,`tsacommon`.`searchEngineAccounts`.`lastChecked` asc] 2012-12-04 10:01:46.646 (4) [main]: time=0.0050 2012-12-04 10:01:46.646 (4) [main]: Query executed in 0.005s 2012-12-04 10:01:46.814 (4) [main]: no account, or instance for databaseInstance, skipping lookup... 2012-12-04 10:01:46.814 (4) [main]: Took Existing Object from Pool 2012-12-04 10:01:46.815 (4) [main]: spike: SQL->[select @@version] 2012-12-04 10:01:46.817 (4) [main]: time=0.0010 2012-12-04 10:01:46.817 (4) [main]: Query executed in 0.001s 2012-12-04 10:01:46.817 (4) [main]: test query succeeded, returned "5.1.49-rel11.3-log" 2012-12-04 10:01:46.818 (4) [main]: spike: SQL->[select * from `tsacommon`.`distribution` where (`id`=3) limit 1] 2012-12-04 10:01:46.819 (4) [main]: time=0.0010 2012-12-04 10:01:46.819 (4) [main]: Query executed in 0.001s 2012-12-04 10:01:46.821 (4) [main]: Record Loaded 2012-12-04 10:01:46.821 (4) [main]: User in TSA MCC, connecting using master username/password 2012-12-04 10:01:46.821 (4) [main]: client customer id = 9001082081 2012-12-04 10:01:46.821 (4) [main]: seuserid[3177] username[null] password[null] customerID[9001082081] 2012-12-04 10:01:46.822 (4) [main]: ClearConnections called at: Tue Dec 04 10:01:46 PST 2012 Timer: 1354643781031 2012-12-04 10:01:46.823 (4) [main]: sesystem: SQL->[update `sesystem`.`searchEngineConnections` set `inUse`="false",`holder`="",`timeStamp`="2012-12-04 10:01:46",`holderIdentifier`="" where ((`sesystem`.`searchEngineConnections`.`distributionID`=3) and (`sesystem`.`searchEngineConnections`.`inUse`="true") and (`sesystem`.`searchEngineConnections`.`timeStamp`<="2012-12-04 09:56:46")) limit 1], genflags=no 2012-12-04 10:01:46.824 (4) [main]: time=0.0010 2012-12-04 10:01:46.825 (4) [main]: Query executed in 0.001s, 0 row(s) affected 2012-12-04 10:01:46.831 (4) [main]: Setting AuthToken [DQAAAJUAAABblTkk4samFeeIPZeA4b44C3w9CSZUFxB_1PKkgTJgM5Lgsa8hTds5kjeMJGa6cExwQnnIDV7Ug-KEY3tqzcq509ufM18E690NozMrYI1_ThysElNbsxM95UmDsdGckBnxsx2_W0beOdRfookxPexOo_l8H3BAtqbFpIIwgTH98LxImDZ0EQfjCTiZ49NAuNh3TJ7XbYd-0CN-WJfEw85Z] to AdWordsUser object for username[google@thesearchagency.com] 2012-12-04 10:01:46.894 (4) [main]: Returning Object to Pool 2012-12-04 10:01:46.906 (4) [P2T1]: no account, or instance for databaseInstance, skipping lookup... 2012-12-04 10:01:46.907 (4) [P2T1]: Took Existing Object from Pool 2012-12-04 10:01:46.907 (4) [P2T1]: spike: SQL->[select @@version] 2012-12-04 10:01:46.909 (4) [P2T1]: time=0.0020 2012-12-04 10:01:46.914 (4) [main]: no account, or instance for databaseInstance, skipping lookup... 2012-12-04 10:01:46.916 (4) [P2T1]: Query executed in 0.002s 2012-12-04 10:01:46.916 (4) [P2T1]: test query succeeded, returned "5.1.49-rel11.3-log" 2012-12-04 10:01:46.917 (4) [P2T1]: spike: SQL->[select * from `tsacommon`.`accounts` where (`tsacommon`.`accounts`.`id`=898) limit 1] 2012-12-04 10:01:46.927 (4) [P2T1]: time=0.01 2012-12-04 10:01:46.928 (4) [P2T1]: Query executed in 0.010s 2012-12-04 10:01:46.932 (4) [P2T1]: Record Loaded 2012-12-04 10:01:46.935 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-12-04 10:01:46.935 (4) [main]: Created new Object 2012-12-04 10:01:46.935 (4) [main]: spike: SQL->[select @@version] 2012-12-04 10:01:46.937 (4) [main]: time=0.0010 2012-12-04 10:01:46.937 (4) [main]: Query executed in 0.001s 2012-12-04 10:01:46.937 (4) [main]: test query succeeded, returned "5.1.49-rel11.3-log" 2012-12-04 10:01:46.937 (4) [main]: spike: SQL->[select * from `tsacommon`.`distribution` where (`id`=3) limit 1] 2012-12-04 10:01:46.938 (4) [P2T1]: Returning Object to Pool 2012-12-04 10:01:46.939 (4) [main]: time=0.0020 2012-12-04 10:01:46.939 (4) [main]: Query executed in 0.002s 2012-12-04 10:01:46.940 (4) [main]: Record Loaded 2012-12-04 10:01:46.940 (4) [main]: User in TSA MCC, connecting using master username/password 2012-12-04 10:01:46.940 (4) [main]: client customer id = 9001082081 2012-12-04 10:01:46.941 (4) [main]: seuserid[3177] username[null] password[null] customerID[9001082081] 2012-12-04 10:01:46.946 (4) [main]: Setting AuthToken [DQAAAJUAAABblTkk4samFeeIPZeA4b44C3w9CSZUFxB_1PKkgTJgM5Lgsa8hTds5kjeMJGa6cExwQnnIDV7Ug-KEY3tqzcq509ufM18E690NozMrYI1_ThysElNbsxM95UmDsdGckBnxsx2_W0beOdRfookxPexOo_l8H3BAtqbFpIIwgTH98LxImDZ0EQfjCTiZ49NAuNh3TJ7XbYd-0CN-WJfEw85Z] to AdWordsUser object for username[google@thesearchagency.com] 2012-12-04 10:01:46.977 (3) [P2T1]: Starting Account (69735) "ATT-WIC|Youtube Overlay|Contextual-Desktop" for user (3177) "AT&T Pan Asian Youth Campaign" 2012-12-04 10:01:46.977 (3) [P2T1]: Sync Flag: false - syncGroups and syncListings skipped for (69735) "ATT-WIC|Youtube Overlay|Contextual-Desktop" for user (3177) "AT&T Pan Asian Youth Campaign" 2012-12-04 10:01:46.978 (3) [P2T1]: Finished Account (69735) "ATT-WIC|Youtube Overlay|Contextual-Desktop" for user (3177) "AT&T Pan Asian Youth Campaign" 2012-12-04 10:01:46.978 (4) [main]: Returning Object to Pool 2012-12-04 10:01:47.148 (4) [main]: no account, or instance for databaseInstance, skipping lookup... 2012-12-04 10:01:47.148 (4) [main]: Took Existing Object from Pool 2012-12-04 10:01:47.148 (4) [main]: spike: SQL->[select @@version] 2012-12-04 10:01:47.224 (4) [main]: time=0.076 2012-12-04 10:01:47.225 (4) [main]: Query executed in 0.076s 2012-12-04 10:01:47.226 (4) [main]: test query succeeded, returned "5.1.49-rel11.3-log" 2012-12-04 10:01:47.227 (4) [main]: spike: SQL->[select * from `tsacommon`.`distribution` where (`id`=3) limit 1] 2012-12-04 10:01:47.292 (4) [main]: time=0.064 2012-12-04 10:01:47.293 (4) [main]: Query executed in 0.064s 2012-12-04 10:01:47.294 (4) [main]: Record Loaded 2012-12-04 10:01:47.294 (4) [main]: User in TSA MCC, connecting using master username/password 2012-12-04 10:01:47.295 (4) [main]: client customer id = 9001082081 2012-12-04 10:01:47.295 (4) [main]: seuserid[3177] username[null] password[null] customerID[9001082081] 2012-12-04 10:01:47.299 (4) [main]: Setting AuthToken [DQAAAJUAAABblTkk4samFeeIPZeA4b44C3w9CSZUFxB_1PKkgTJgM5Lgsa8hTds5kjeMJGa6cExwQnnIDV7Ug-KEY3tqzcq509ufM18E690NozMrYI1_ThysElNbsxM95UmDsdGckBnxsx2_W0beOdRfookxPexOo_l8H3BAtqbFpIIwgTH98LxImDZ0EQfjCTiZ49NAuNh3TJ7XbYd-0CN-WJfEw85Z] to AdWordsUser object for username[google@thesearchagency.com] 2012-12-04 10:01:51.068 (4) [main]: Returning Object to Pool 2012-12-04 10:01:51.153 (4) [P2T2]: no account, or instance for databaseInstance, skipping lookup... 2012-12-04 10:01:51.153 (4) [P2T2]: Took Existing Object from Pool 2012-12-04 10:01:51.154 (4) [P2T2]: spike: SQL->[select @@version] 2012-12-04 10:01:51.163 (4) [P2T3]: no account, or instance for databaseInstance, skipping lookup... 2012-12-04 10:01:51.163 (4) [P2T3]: Took Existing Object from Pool 2012-12-04 10:01:51.164 (4) [P2T3]: spike: SQL->[select @@version] 2012-12-04 10:01:51.174 (4) [main]: no account, or instance for databaseInstance, skipping lookup... 2012-12-04 10:01:51.308 (4) [P2T2]: time=0.154 2012-12-04 10:01:51.310 (4) [P2T2]: Query executed in 0.154s 2012-12-04 10:01:51.310 (4) [P2T2]: test query succeeded, returned "5.1.49-rel11.3-log" 2012-12-04 10:01:51.310 (4) [P2T2]: spike: SQL->[select * from `tsacommon`.`accounts` where (`tsacommon`.`accounts`.`id`=898) limit 1] 2012-12-04 10:01:51.373 (4) [P2T2]: time=0.063 2012-12-04 10:01:51.373 (4) [P2T2]: Query executed in 0.063s 2012-12-04 10:01:51.374 (4) [P2T2]: Record Loaded 2012-12-04 10:01:51.972 (4) [P2T3]: time=0.808 2012-12-04 10:01:51.973 (4) [P2T3]: Query executed in 0.808s 2012-12-04 10:01:51.973 (4) [P2T3]: test query succeeded, returned "5.1.49-rel11.3-log" 2012-12-04 10:01:51.973 (4) [P2T3]: spike: SQL->[select * from `tsacommon`.`accounts` where (`tsacommon`.`accounts`.`id`=898) limit 1] 2012-12-04 10:01:51.984 (4) [P2T3]: time=0.011 2012-12-04 10:01:51.985 (4) [P2T3]: Query executed in 0.011s 2012-12-04 10:01:51.987 (4) [P2T3]: Record Loaded 2012-12-04 10:01:52.028 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-12-04 10:01:52.029 (4) [main]: Created new Object 2012-12-04 10:01:52.029 (4) [P2T3]: Returning Object to Pool 2012-12-04 10:01:52.030 (3) [P2T3]: Starting Account (69753) "ATT-WIC|Search-Desktop|United States-English" for user (3177) "AT&T Pan Asian Youth Campaign" 2012-12-04 10:01:52.030 (3) [P2T3]: Sync Flag: false - syncGroups and syncListings skipped for (69753) "ATT-WIC|Search-Desktop|United States-English" for user (3177) "AT&T Pan Asian Youth Campaign" 2012-12-04 10:01:52.030 (3) [P2T3]: Finished Account (69753) "ATT-WIC|Search-Desktop|United States-English" for user (3177) "AT&T Pan Asian Youth Campaign" 2012-12-04 10:01:52.030 (4) [P2T2]: Returning Object to Pool 2012-12-04 10:01:52.030 (3) [P2T2]: Starting Account (69752) "ATT-WIC|Search-Mobile-Tablet|United States-English" for user (3177) "AT&T Pan Asian Youth Campaign" 2012-12-04 10:01:52.030 (3) [P2T2]: Sync Flag: false - syncGroups and syncListings skipped for (69752) "ATT-WIC|Search-Mobile-Tablet|United States-English" for user (3177) "AT&T Pan Asian Youth Campaign" 2012-12-04 10:01:52.030 (3) [P2T2]: Finished Account (69752) "ATT-WIC|Search-Mobile-Tablet|United States-English" for user (3177) "AT&T Pan Asian Youth Campaign" 2012-12-04 10:01:52.031 (4) [main]: spike: SQL->[select @@version] 2012-12-04 10:01:52.032 (4) [main]: time=0.0010 2012-12-04 10:01:52.033 (4) [main]: Query executed in 0.001s 2012-12-04 10:01:52.033 (4) [main]: test query succeeded, returned "5.1.49-rel11.3-log" 2012-12-04 10:01:52.033 (4) [main]: spike: SQL->[select * from `tsacommon`.`distribution` where (`id`=3) limit 1] 2012-12-04 10:01:52.034 (4) [main]: time=0.0010 2012-12-04 10:01:52.034 (4) [main]: Query executed in 0.001s 2012-12-04 10:01:52.045 (4) [main]: Record Loaded 2012-12-04 10:01:52.045 (4) [main]: User in TSA MCC, connecting using master username/password 2012-12-04 10:01:52.046 (4) [main]: client customer id = 9001082081 2012-12-04 10:01:52.046 (4) [main]: seuserid[3177] username[null] password[null] customerID[9001082081] 2012-12-04 10:01:52.050 (4) [main]: Setting AuthToken [DQAAAJUAAABblTkk4samFeeIPZeA4b44C3w9CSZUFxB_1PKkgTJgM5Lgsa8hTds5kjeMJGa6cExwQnnIDV7Ug-KEY3tqzcq509ufM18E690NozMrYI1_ThysElNbsxM95UmDsdGckBnxsx2_W0beOdRfookxPexOo_l8H3BAtqbFpIIwgTH98LxImDZ0EQfjCTiZ49NAuNh3TJ7XbYd-0CN-WJfEw85Z] to AdWordsUser object for username[google@thesearchagency.com] 2012-12-04 10:01:52.087 (4) [main]: Returning Object to Pool 2012-12-04 10:01:52.096 (4) [P2T4]: no account, or instance for databaseInstance, skipping lookup... 2012-12-04 10:01:52.097 (4) [P2T4]: Took Existing Object from Pool 2012-12-04 10:01:52.097 (4) [P2T4]: spike: SQL->[select @@version] 2012-12-04 10:01:52.098 (4) [P2T4]: time=0.0010 2012-12-04 10:01:52.099 (4) [P2T4]: Query executed in 0.001s 2012-12-04 10:01:52.099 (4) [P2T4]: test query succeeded, returned "5.1.49-rel11.3-log" 2012-12-04 10:01:52.099 (4) [P2T4]: spike: SQL->[select * from `tsacommon`.`accounts` where (`tsacommon`.`accounts`.`id`=898) limit 1] 2012-12-04 10:01:52.100 (4) [P2T4]: time=0.0010 2012-12-04 10:01:52.101 (4) [P2T4]: Query executed in 0.001s 2012-12-04 10:01:52.106 (4) [main]: no account, or instance for databaseInstance, skipping lookup... 2012-12-04 10:01:52.107 (4) [main]: Took Existing Object from Pool 2012-12-04 10:01:52.107 (4) [main]: spike: SQL->[select @@version] 2012-12-04 10:01:52.109 (4) [main]: time=0.0020 2012-12-04 10:01:52.109 (4) [main]: Query executed in 0.002s 2012-12-04 10:01:52.109 (4) [main]: test query succeeded, returned "5.1.49-rel11.3-log" 2012-12-04 10:01:52.110 (4) [main]: spike: SQL->[select * from `tsacommon`.`distribution` where (`id`=3) limit 1] 2012-12-04 10:01:52.111 (4) [P2T4]: Record Loaded 2012-12-04 10:01:52.111 (4) [main]: time=0.0010 2012-12-04 10:01:52.111 (4) [main]: Query executed in 0.001s 2012-12-04 10:01:52.113 (4) [main]: Record Loaded 2012-12-04 10:01:52.113 (4) [main]: User in TSA MCC, connecting using master username/password 2012-12-04 10:01:52.113 (4) [main]: client customer id = 9001082081 2012-12-04 10:01:52.113 (4) [main]: seuserid[3177] username[null] password[null] customerID[9001082081] 2012-12-04 10:01:52.121 (4) [main]: Setting AuthToken [DQAAAJUAAABblTkk4samFeeIPZeA4b44C3w9CSZUFxB_1PKkgTJgM5Lgsa8hTds5kjeMJGa6cExwQnnIDV7Ug-KEY3tqzcq509ufM18E690NozMrYI1_ThysElNbsxM95UmDsdGckBnxsx2_W0beOdRfookxPexOo_l8H3BAtqbFpIIwgTH98LxImDZ0EQfjCTiZ49NAuNh3TJ7XbYd-0CN-WJfEw85Z] to AdWordsUser object for username[google@thesearchagency.com] 2012-12-04 10:01:52.273 (4) [main]: Returning Object to Pool 2012-12-04 10:01:54.885 (4) [P2T4]: Returning Object to Pool 2012-12-04 10:01:54.886 (3) [P2T4]: Starting Account (69737) "ATT-WIC|GDN|Contextual-Desktop" for user (3177) "AT&T Pan Asian Youth Campaign" 2012-12-04 10:01:54.886 (3) [P2T4]: Sync Flag: false - syncGroups and syncListings skipped for (69737) "ATT-WIC|GDN|Contextual-Desktop" for user (3177) "AT&T Pan Asian Youth Campaign" 2012-12-04 10:01:54.886 (3) [P2T4]: Finished Account (69737) "ATT-WIC|GDN|Contextual-Desktop" for user (3177) "AT&T Pan Asian Youth Campaign" 2012-12-04 10:01:56.598 (4) [P2T5]: no account, or instance for databaseInstance, skipping lookup... 2012-12-04 10:01:56.599 (4) [P2T5]: Took Existing Object from Pool 2012-12-04 10:01:56.599 (4) [P2T5]: spike: SQL->[select @@version] 2012-12-04 10:01:56.601 (4) [P2T5]: time=0.0020 2012-12-04 10:01:56.602 (4) [P2T5]: Query executed in 0.002s 2012-12-04 10:01:56.602 (4) [P2T5]: test query succeeded, returned "5.1.49-rel11.3-log" 2012-12-04 10:01:56.602 (4) [P2T5]: spike: SQL->[select * from `tsacommon`.`accounts` where (`tsacommon`.`accounts`.`id`=898) limit 1] 2012-12-04 10:01:56.604 (4) [P2T5]: time=0.0010 2012-12-04 10:01:56.604 (4) [P2T5]: Query executed in 0.001s 2012-12-04 10:01:56.605 (4) [P2T5]: Record Loaded 2012-12-04 10:01:56.605 (4) [P2T5]: Returning Object to Pool 2012-12-04 10:01:56.605 (3) [P2T5]: Starting Account (69733) "ATT-WIC|GDN|Contextual-Mobile" for user (3177) "AT&T Pan Asian Youth Campaign" 2012-12-04 10:01:56.605 (3) [P2T5]: Sync Flag: false - syncGroups and syncListings skipped for (69733) "ATT-WIC|GDN|Contextual-Mobile" for user (3177) "AT&T Pan Asian Youth Campaign" 2012-12-04 10:01:56.606 (3) [P2T5]: Finished Account (69733) "ATT-WIC|GDN|Contextual-Mobile" for user (3177) "AT&T Pan Asian Youth Campaign" 2012-12-04 10:01:56.606 (3) [main]: After joining threads, calling doPostJoinActions 2012-12-04 10:01:56.606 (3) [main]: =============== Completed Search Engine Updater ================ 2012-12-04 10:01:56.607 (4) [main]: time=645.577 2012-12-04 10:01:56.607 (3) [main]: Search Engine Updater: 10m 45.577s 2012-12-04 10:01:56.607 (3) [main]: by key: 2012-12-04 10:01:56.607 (4) [main]: time=9.584 2012-12-04 10:01:56.607 (3) [main]: parsing: 9.584s 2012-12-04 10:01:56.608 (4) [main]: time=10.242 2012-12-04 10:01:56.608 (3) [main]: google: 10.242s 2012-12-04 10:01:56.608 (4) [main]: time=581.741 2012-12-04 10:01:56.608 (3) [main]: db: 9m 41.741s 2012-12-04 10:01:56.608 (3) [main]: by thread: 2012-12-04 10:01:56.608 (4) [main]: time=0.012 2012-12-04 10:01:56.609 (3) [main]: P2T1: 0.012s 2012-12-04 10:01:56.609 (4) [main]: time=0.819 2012-12-04 10:01:56.609 (3) [main]: P2T3: 0.819s 2012-12-04 10:01:56.609 (4) [main]: time=0.17 2012-12-04 10:01:56.609 (3) [main]: main: 0.170s 2012-12-04 10:01:56.609 (4) [main]: time=0.0030 2012-12-04 10:01:56.609 (3) [main]: P2T5: 0.003s 2012-12-04 10:01:56.610 (4) [main]: time=0.217 2012-12-04 10:01:56.610 (3) [main]: P2T2: 0.217s 2012-12-04 10:01:56.610 (4) [main]: time=580.518 2012-12-04 10:01:56.610 (3) [main]: P1T1: 9m 40.518s 2012-12-04 10:01:56.610 (4) [main]: time=0.0020 2012-12-04 10:01:56.610 (3) [main]: P2T4: 0.002s 2012-12-04 10:01:56.611 (4) [main]: time=44.01 2012-12-04 10:01:56.611 (3) [main]: other: 44.010s