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