2013-02-22 07:18:45.797 (3) [Thread-9]: Request added to map for customerID 8ee2247d-cacc-4283-8853-ae7ce635409e
2013-02-22 07:18:45.950 (3) [Thread-10]: HighPriorityMessageHandler handling message ID ID:JBM-ffedfae0-22ad-49f6-babb-5b4fc6916826
2013-02-22 07:18:45.950 (4) [Thread-10]: onMessage() called
2013-02-22 07:18:45.950 (4) [Thread-10]: handle() called
2013-02-22 07:18:45.950 (3) [Thread-10]: Request worker created for 8ee2247d-cacc-4283-8853-ae7ce635409e
2013-02-22 07:18:45.951 (3) [Thread-10]: Submitted executor job for 8ee2247d-cacc-4283-8853-ae7ce635409e
2013-02-22 07:18:45.951 (4) [pool-3-thread-4]: no account, or instance for databaseInstance, skipping lookup...
2013-02-22 07:18:45.952 (4) [ConnectionCloser]: Starting DatabasePool ConnectionCloserThread
2013-02-22 07:18:45.958 (3) [Thread-10]: HighPriorityMessageHandler took message ID ID:JBM-ffedfae0-22ad-49f6-babb-5b4fc6916826 out of queue
2013-02-22 07:18:45.972 (4) [pool-3-thread-4]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2013-02-22 07:18:45.972 (4) [pool-3-thread-4]: Created new Object
2013-02-22 07:18:45.972 (4) [pool-3-thread-4]: spike: SQL->[select @@version]
2013-02-22 07:18:45.974 (4) [pool-3-thread-4]: time=0.0020
2013-02-22 07:18:45.974 (4) [pool-3-thread-4]: Query executed in 0.002s
2013-02-22 07:18:45.974 (4) [pool-3-thread-4]: test query succeeded, returned "5.1.65-rel14.0"
2013-02-22 07:18:45.974 (4) [pool-3-thread-4]: DataCache: Found key global-clients
2013-02-22 07:18:45.974 (4) [pool-3-thread-4]: Took Existing Object from Pool
2013-02-22 07:18:45.975 (4) [pool-3-thread-4]: spike: SQL->[select @@version]
2013-02-22 07:18:45.979 (4) [pool-3-thread-4]: time=0.0040
2013-02-22 07:18:45.980 (4) [pool-3-thread-4]: Query executed in 0.004s
2013-02-22 07:18:45.980 (4) [pool-3-thread-4]: test query succeeded, returned "5.1.65-rel14.0"
2013-02-22 07:18:45.980 (4) [pool-3-thread-4]: spike: SQL->[SELECT GET_LOCK('com.thesearchagency.admaxlistener.dao.TSACommonDAO.8ee2247d-cacc-4283-8853-ae7ce635409e', 7200)]
2013-02-22 07:18:45.981 (4) [pool-3-thread-4]: time=0.0010
2013-02-22 07:18:45.982 (4) [pool-3-thread-4]: Query executed in 0.001s
2013-02-22 07:18:45.982 (4) [pool-3-thread-4]: spike: SQL->[select * from `tsacommon`.`accounts` where ((`description`="8ee2247d-cacc-4283-8853-ae7ce635409e")) limit 1]
2013-02-22 07:18:45.983 (4) [pool-3-thread-4]: time=0.0010
2013-02-22 07:18:45.984 (4) [pool-3-thread-4]: Query executed in 0.001s
2013-02-22 07:18:45.984 (4) [pool-3-thread-4]:   Record Loaded
2013-02-22 07:18:46.022 (4) [pool-3-thread-4]: DataCache: Found key acct-st-tracker 289
2013-02-22 07:18:46.022 (4) [pool-3-thread-4]: DataCache: Key acct-st-tracker-1 expired.
2013-02-22 07:18:46.022 (4) [pool-3-thread-4]: no account, or instance for databaseInstance, skipping lookup...
2013-02-22 07:18:46.037 (4) [pool-3-thread-4]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2013-02-22 07:18:46.037 (4) [pool-3-thread-4]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`name`="acct-st-tracker-1") and (`type`="mysql")) limit 1]
2013-02-22 07:18:46.039 (4) [pool-3-thread-4]: time=0.0020
2013-02-22 07:18:46.039 (4) [pool-3-thread-4]: Query executed in 0.002s
2013-02-22 07:18:46.039 (4) [pool-3-thread-4]:   Record Loaded
2013-02-22 07:18:46.040 (4) [pool-3-thread-4]: DataCache: put key acct-st-tracker-1
2013-02-22 07:18:46.040 (4) [pool-3-thread-4]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2013-02-22 07:18:46.060 (4) [pool-3-thread-4]: opened [jdbc:mysql://acctdb-01-write:3306/st-tracker?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2013-02-22 07:18:46.060 (4) [pool-3-thread-4]: Created new Object
2013-02-22 07:18:46.060 (4) [pool-3-thread-4]: spike: SQL->[select @@version]
2013-02-22 07:18:46.063 (4) [pool-3-thread-4]: time=0.0030
2013-02-22 07:18:46.063 (4) [pool-3-thread-4]: Query executed in 0.003s
2013-02-22 07:18:46.063 (4) [pool-3-thread-4]: test query succeeded, returned "5.1.65-rel14.0"
2013-02-22 07:18:46.063 (4) [pool-3-thread-4]: preparing SQL statement [select id from clients.externalCampaignParent where typeID = ? and accountID = ? and status != ?]
2013-02-22 07:18:46.067 (4) [pool-3-thread-4]: preparing SQL statement [select id, description, accountID, admaxCampaignID, status, typeID from clients.externalCampaignParent where accountID = ? and status != ? and typeID=1]
2013-02-22 07:18:46.069 (3) [pool-3-thread-4]: Updating deployment status to 'InProgress' for campaignID: 1225
2013-02-22 07:18:46.069 (4) [pool-3-thread-4]: preparing SQL statement [update clients.externalCampaignParentDeployStatus set status = ? where description = ?]
2013-02-22 07:18:46.071 (4) [pool-3-thread-4]: preparing SQL statement [select id, description, accountID, admaxCampaignID, status, typeID from clients.externalCampaignParent where description = ?]
2013-02-22 07:18:46.072 (4) [pool-3-thread-4]: preparing SQL statement [select c.id from clients.externalCampaignParent p join clients.externalCampaign c on(p.id = c.externalCampaignParentID) where p.description = ?]
2013-02-22 07:18:46.075 (4) [pool-3-thread-4]: preparing SQL statement [update clients.externalCampaignParent set status = ? where id = ?]
2013-02-22 07:18:46.076 (4) [pool-3-thread-4]: preparing SQL statement [update `st-tracker`.admaxCampaigns set status = ? where id = ?]
2013-02-22 07:18:46.077 (4) [pool-3-thread-4]: Returning Object to Pool
2013-02-22 07:18:46.078 (4) [pool-3-thread-4]: Returning Object to Pool
2013-02-22 07:18:46.078 (4) [pool-3-thread-4]: no account, or instance for databaseInstance, skipping lookup...
2013-02-22 07:18:46.094 (4) [pool-3-thread-4]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2013-02-22 07:18:46.094 (4) [pool-3-thread-4]: Created new Object
2013-02-22 07:18:46.095 (4) [pool-3-thread-4]: spike: SQL->[select @@version]
2013-02-22 07:18:46.096 (4) [pool-3-thread-4]: time=0.0010
2013-02-22 07:18:46.096 (4) [pool-3-thread-4]: Query executed in 0.001s
2013-02-22 07:18:46.096 (4) [pool-3-thread-4]: test query succeeded, returned "5.1.65-rel14.0"
2013-02-22 07:18:46.096 (3) [pool-3-thread-4]: Start processing UPDATE request (2addc4ed-849e-4de2-8fe6-4d59421d1df4) for account 8ee2247d-cacc-4283-8853-ae7ce635409e. 3 campaign(s).
2013-02-22 07:18:46.097 (4) [pool-3-thread-4]: Locked account: 8ee2247d-cacc-4283-8853-ae7ce635409e
2013-02-22 07:18:46.097 (3) [pool-3-thread-4]: Performing update for account: 8ee2247d-cacc-4283-8853-ae7ce635409e ID#289
2013-02-22 07:18:46.097 (4) [pool-3-thread-4]: no account, or instance for databaseInstance, skipping lookup...
2013-02-22 07:18:46.120 (4) [pool-3-thread-4]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2013-02-22 07:18:46.120 (4) [pool-3-thread-4]: Created new Object
2013-02-22 07:18:46.121 (4) [pool-3-thread-4]: spike: SQL->[select @@version]
2013-02-22 07:18:46.122 (4) [pool-3-thread-4]: time=0.0010
2013-02-22 07:18:46.122 (4) [pool-3-thread-4]: Query executed in 0.001s
2013-02-22 07:18:46.122 (4) [pool-3-thread-4]: test query succeeded, returned "5.1.65-rel14.0"
2013-02-22 07:18:46.122 (4) [pool-3-thread-4]: DataCache: Found key global-clients
2013-02-22 07:18:46.123 (4) [pool-3-thread-4]: Took Existing Object from Pool
2013-02-22 07:18:46.123 (4) [pool-3-thread-4]: spike: SQL->[select @@version]
2013-02-22 07:18:46.124 (4) [pool-3-thread-4]: time=0.0010
2013-02-22 07:18:46.124 (4) [pool-3-thread-4]: Query executed in 0.001s
2013-02-22 07:18:46.124 (4) [pool-3-thread-4]: test query succeeded, returned "5.1.65-rel14.0"
2013-02-22 07:18:46.124 (4) [pool-3-thread-4]: preparing SQL statement [select id, externalCampaignParentID, gceCampaignID, searchEngineAccountID, accountID, enabled from clients.externalCampaign where id = ?]
2013-02-22 07:18:46.126 (4) [pool-3-thread-4]: preparing SQL statement [select id, description, accountID, admaxCampaignID, status, typeID from clients.externalCampaignParent where description = ?]
2013-02-22 07:18:46.128 (4) [pool-3-thread-4]: preparing SQL statement [select description from tsacommon.searchEngineAccounts where id = ?]
2013-02-22 07:18:46.129 (4) [pool-3-thread-4]: preparing SQL statement [select id, externalCampaignParentID, gceCampaignID, searchEngineAccountID, accountID, enabled from clients.externalCampaign where id = ?]
2013-02-22 07:18:46.131 (4) [pool-3-thread-4]: preparing SQL statement [select id, description, accountID, admaxCampaignID, status, typeID from clients.externalCampaignParent where description = ?]
2013-02-22 07:18:46.133 (4) [pool-3-thread-4]: preparing SQL statement [select description from tsacommon.searchEngineAccounts where id = ?]
2013-02-22 07:18:46.134 (4) [pool-3-thread-4]: preparing SQL statement [select id, externalCampaignParentID, gceCampaignID, searchEngineAccountID, accountID, enabled from clients.externalCampaign where id = ?]
2013-02-22 07:18:46.136 (4) [pool-3-thread-4]: preparing SQL statement [select id, description, accountID, admaxCampaignID, status, typeID from clients.externalCampaignParent where description = ?]
2013-02-22 07:18:46.137 (4) [pool-3-thread-4]: preparing SQL statement [select description from tsacommon.searchEngineAccounts where id = ?]
2013-02-22 07:18:46.139 (4) [pool-3-thread-4]: Returning Object to Pool
2013-02-22 07:18:46.139 (4) [pool-3-thread-4]: Returning Object to Pool
2013-02-22 07:18:46.139 (3) [pool-3-thread-4]: 3 campaign(s) to update.
2013-02-22 07:18:46.139 (3) [pool-3-thread-4]: 0 campaign(s) to retry and update.
2013-02-22 07:18:46.139 (3) [pool-3-thread-4]: CampaignWorker initialized for account: 289
2013-02-22 07:18:46.140 (3) [pool-3-thread-4]: Updating 8ee2247d-cacc-4283-8853-ae7ce635409e_10034_4051_1225_GM Status: Paused
2013-02-22 07:18:46.140 (3) [pool-3-thread-4]: Updating 8ee2247d-cacc-4283-8853-ae7ce635409e_10034_4051_1225_GT Status: Paused
2013-02-22 07:18:46.140 (3) [pool-3-thread-4]: Updating 8ee2247d-cacc-4283-8853-ae7ce635409e_10034_4051_1225_MO Status: Paused
2013-02-22 07:18:46.140 (3) [pool-3-thread-4]: CampaignUpdateWorker started...
2013-02-22 07:18:46.140 (4) [pool-3-thread-4]: DataCache: Found key acct-content-google 289
2013-02-22 07:18:46.141 (4) [pool-3-thread-4]: DataCache: Key acct-content-google-1 expired.
2013-02-22 07:18:46.141 (4) [pool-3-thread-4]: no account, or instance for databaseInstance, skipping lookup...
2013-02-22 07:18:46.164 (4) [pool-3-thread-4]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2013-02-22 07:18:46.164 (4) [pool-3-thread-4]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`name`="acct-content-google-1") and (`type`="mysql")) limit 1]
2013-02-22 07:18:46.166 (4) [pool-3-thread-4]: time=0.0020
2013-02-22 07:18:46.167 (4) [pool-3-thread-4]: Query executed in 0.002s
2013-02-22 07:18:46.167 (4) [pool-3-thread-4]:   Record Loaded
2013-02-22 07:18:46.167 (4) [pool-3-thread-4]: DataCache: put key acct-content-google-1
2013-02-22 07:18:46.167 (4) [pool-3-thread-4]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2013-02-22 07:18:46.186 (4) [pool-3-thread-4]: opened [jdbc:mysql://acctdb-01-write:3306/content_editor_google?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2013-02-22 07:18:46.186 (4) [pool-3-thread-4]: Created new Object
2013-02-22 07:18:46.186 (4) [pool-3-thread-4]: spike: SQL->[select @@version]
2013-02-22 07:18:46.188 (4) [pool-3-thread-4]: time=0.0020
2013-02-22 07:18:46.188 (4) [pool-3-thread-4]: Query executed in 0.002s
2013-02-22 07:18:46.188 (4) [pool-3-thread-4]: test query succeeded, returned "5.1.65-rel14.0"
2013-02-22 07:18:46.189 (4) [pool-3-thread-4]: spike: SQL->[select `content_editor_google`.`gce_campaign`.*,`content_editor_google`.`gce_campaignPendingChange`.*,`content_editor_google`.`gce_campaignTargetMap`.*,`content_editor_google`.`gce_campaignBudgetOptimizerSetting`.*,`content_editor_google`.`gce_target`.`code`,`content_editor_google`.`gce_target`.`targetType`,`content_editor_google`.`gce_target`.`criterionID`,`content_editor_google`.`gce_campaignProximityTargetMap`.`criterionID`,`content_editor_google`.`gce_campaignProximityTargetMap`.`latitudeInMicroDegrees`,`content_editor_google`.`gce_campaignProximityTargetMap`.`longitudeInMicroDegrees`,`content_editor_google`.`gce_campaignProximityTargetMap`.`radius`,`content_editor_google`.`gce_campaignProximityTargetMap`.`radiusUnits`,`content_editor_google`.`gce_campaign`.`id` AS `gce_campaign_campaignID`,`gce_campaignPendingUpdate`.`name` AS `nameChange`,`gce_campaignPendingUpdate`.`budgetAmount` AS `budgetAmountChange`,`gce_campaignPendingUpdate`.`budgetPeriod` AS `budgetPeriodChange`,`gce_campaignPendingUpdate`.`contentTargeting` AS `contentTargetingChange`,`gce_campaignPendingUpdate`.`endDay` AS `endDayChange`,`gce_campaignPendingUpdate`.`status` AS `statusChange`,`gce_campaignPendingUpdate`.`budgetOptimizerBidCeiling` AS `budgetOptimizerBidCeilingChange`,`gce_campaignPendingUpdate`.`budgetOptimizerEnabled` AS `budgetOptimizerEnabledChange`,`gce_campaignPendingUpdate`.`budgetOptimizerTakeOnOptimizedBids` AS `budgetOptimizerTakeOnOptimizedBidsChange` from `content_editor_google`.`gce_campaign` left join `gce_campaignPendingChange` on ((`content_editor_google`.`gce_campaignPendingChange`.`campaignID`=`content_editor_google`.`gce_campaign`.`id`)) left join `gce_campaignPendingUpdate` on ((`gce_campaignPendingUpdate`.`campaignID`=`gce_campaign`.`id`)) left join `gce_campaignTargetMap` on ((`content_editor_google`.`gce_campaignTargetMap`.`campaignID`=`content_editor_google`.`gce_campaign`.`id`)) left join `gce_target` on ((`content_editor_google`.`gce_campaignTargetMap`.`targetID`=`content_editor_google`.`gce_target`.`id`)) left join `gce_campaignBudgetOptimizerSetting` on ((`content_editor_google`.`gce_campaignBudgetOptimizerSetting`.`campaignID`=`content_editor_google`.`gce_campaign`.`id`)) left join `content_editor_google`.`gce_campaignProximityTargetMap` on (((((`content_editor_google`.`gce_campaignProximityTargetMap`.`campaignID`=`content_editor_google`.`gce_campaignTargetMap`.`campaignID`)) and ((`content_editor_google`.`gce_campaignProximityTargetMap`.`targetID`=`content_editor_google`.`gce_campaignTargetMap`.`targetID`))))) where ((`gce_campaign`.`id` in (1631,1630,1632)))]
2013-02-22 07:18:46.192 (4) [pool-3-thread-4]: time=0.0030
2013-02-22 07:18:46.192 (4) [pool-3-thread-4]: Query executed in 0.003s
2013-02-22 07:18:46.196 (4) [pool-3-thread-4]: spike: SQL->[select `content_editor_google`.`gce_campaign`.`id`,`content_editor_google`.`gce_campaignPendingChange`.*,`content_editor_google`.`gce_campaignAdExtensionMap`.`adExtensionID`,`content_editor_google`.`gce_campaignAdExtensionMap`.`adExtensionType`,`content_editor_google`.`gce_campaignAdExtensionMap`.`searchEngineIdentifier` AS `adExtensionIdentifier`,`content_editor_google`.`gce_adSiteLink`.`id` AS `siteLinkID`,`content_editor_google`.`gce_adSiteLink`.`text`,`content_editor_google`.`gce_adSiteLink`.`destinationURL`,`content_editor_google`.`gce_campaign`.`id` AS `gce_campaign_campaignID` from `content_editor_google`.`gce_campaign` left join `gce_campaignPendingChange` on ((`content_editor_google`.`gce_campaignPendingChange`.`campaignID`=`content_editor_google`.`gce_campaign`.`id`)) left join `gce_campaignAdExtensionMap` on ((`content_editor_google`.`gce_campaignAdExtensionMap`.`campaignID`=`content_editor_google`.`gce_campaign`.`id`)) left join `gce_adSiteLink` on ((`content_editor_google`.`gce_campaignAdExtensionMap`.`adExtensionID`=`content_editor_google`.`gce_adSiteLink`.`adExtensionID`)) where ((`gce_campaign`.`id` in (1631,1630,1632)))]
2013-02-22 07:18:46.213 (4) [pool-3-thread-4]: time=0.017
2013-02-22 07:18:46.213 (4) [pool-3-thread-4]: Query executed in 0.017s
2013-02-22 07:18:46.214 (4) [pool-3-thread-4]: spike: SQL->[select * from `content_editor_google`.`gce_campaignProximityTargetMapPendingUpdate` join `content_editor_google`.`gce_target` on ((`content_editor_google`.`gce_campaignProximityTargetMapPendingUpdate`.`targetID`=`content_editor_google`.`gce_target`.`id`)) left join `content_editor_google`.`gce_campaignProximityTargetMap` on (((`content_editor_google`.`gce_campaignProximityTargetMap`.`targetID`=`content_editor_google`.`gce_target`.`id`) and (`content_editor_google`.`gce_campaignProximityTargetMap`.`campaignID`=`content_editor_google`.`gce_campaignProximityTargetMapPendingUpdate`.`campaignID`))) where (`content_editor_google`.`gce_campaignProximityTargetMapPendingUpdate`.`campaignID`=1630)]
2013-02-22 07:18:46.216 (4) [pool-3-thread-4]: time=0.0020
2013-02-22 07:18:46.216 (4) [pool-3-thread-4]: Query executed in 0.002s
2013-02-22 07:18:46.216 (4) [pool-3-thread-4]: spike: SQL->[select * from `content_editor_google`.`gce_campaignTargetMapPendingUpdate` join `content_editor_google`.`gce_target` on ((`content_editor_google`.`gce_campaignTargetMapPendingUpdate`.`targetID`=`content_editor_google`.`gce_target`.`id`)) left join `content_editor_google`.`gce_campaignProximityTargetMap` on (((`content_editor_google`.`gce_campaignProximityTargetMap`.`targetID`=`content_editor_google`.`gce_target`.`id`) and (`content_editor_google`.`gce_campaignProximityTargetMap`.`campaignID`=`content_editor_google`.`gce_campaignTargetMapPendingUpdate`.`campaignID`))) where (`content_editor_google`.`gce_campaignTargetMapPendingUpdate`.`campaignID`=1630)]
2013-02-22 07:18:46.218 (4) [pool-3-thread-4]: time=0.0020
2013-02-22 07:18:46.218 (4) [pool-3-thread-4]: Query executed in 0.002s
2013-02-22 07:18:46.218 (4) [pool-3-thread-4]: spike: SQL->[select `content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate`.*,`content_editor_google`.`gce_campaignAdExtensionMap`.`adExtensionID`,`content_editor_google`.`gce_campaignAdExtensionMap`.`adExtensionType`,`content_editor_google`.`gce_campaignAdExtensionMap`.`searchEngineIdentifier` AS `adExtensionIdentifier`,`content_editor_google`.`gce_adSiteLink`.`id` AS `siteLinkID`,`content_editor_google`.`gce_adSiteLink`.`text`,`content_editor_google`.`gce_adSiteLink`.`destinationURL`,`content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate`.`campaignID` AS `gce_campaign_campaignID` from `content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate` join `content_editor_google`.`gce_campaignAdExtensionMap` on ((`content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate`.`adExtensionID`=`content_editor_google`.`gce_campaignAdExtensionMap`.`adExtensionID`)) join `content_editor_google`.`gce_adSiteLink` on ((`content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate`.`adExtensionID`=`content_editor_google`.`gce_adSiteLink`.`adExtensionID`)) where (`content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate`.`campaignID`=1630)]
2013-02-22 07:18:46.240 (4) [pool-3-thread-4]: time=0.022
2013-02-22 07:18:46.240 (4) [pool-3-thread-4]: Query executed in 0.022s
2013-02-22 07:18:46.240 (4) [pool-3-thread-4]: spike: SQL->[select * from `content_editor_google`.`gce_campaignProximityTargetMapPendingUpdate` join `content_editor_google`.`gce_target` on ((`content_editor_google`.`gce_campaignProximityTargetMapPendingUpdate`.`targetID`=`content_editor_google`.`gce_target`.`id`)) left join `content_editor_google`.`gce_campaignProximityTargetMap` on (((`content_editor_google`.`gce_campaignProximityTargetMap`.`targetID`=`content_editor_google`.`gce_target`.`id`) and (`content_editor_google`.`gce_campaignProximityTargetMap`.`campaignID`=`content_editor_google`.`gce_campaignProximityTargetMapPendingUpdate`.`campaignID`))) where (`content_editor_google`.`gce_campaignProximityTargetMapPendingUpdate`.`campaignID`=1631)]
2013-02-22 07:18:46.242 (4) [pool-3-thread-4]: time=0.0020
2013-02-22 07:18:46.242 (4) [pool-3-thread-4]: Query executed in 0.002s
2013-02-22 07:18:46.242 (4) [pool-3-thread-4]: spike: SQL->[select * from `content_editor_google`.`gce_campaignTargetMapPendingUpdate` join `content_editor_google`.`gce_target` on ((`content_editor_google`.`gce_campaignTargetMapPendingUpdate`.`targetID`=`content_editor_google`.`gce_target`.`id`)) left join `content_editor_google`.`gce_campaignProximityTargetMap` on (((`content_editor_google`.`gce_campaignProximityTargetMap`.`targetID`=`content_editor_google`.`gce_target`.`id`) and (`content_editor_google`.`gce_campaignProximityTargetMap`.`campaignID`=`content_editor_google`.`gce_campaignTargetMapPendingUpdate`.`campaignID`))) where (`content_editor_google`.`gce_campaignTargetMapPendingUpdate`.`campaignID`=1631)]
2013-02-22 07:18:46.246 (4) [pool-3-thread-4]: time=0.0040
2013-02-22 07:18:46.246 (4) [pool-3-thread-4]: Query executed in 0.004s
2013-02-22 07:18:46.246 (4) [pool-3-thread-4]: spike: SQL->[select `content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate`.*,`content_editor_google`.`gce_campaignAdExtensionMap`.`adExtensionID`,`content_editor_google`.`gce_campaignAdExtensionMap`.`adExtensionType`,`content_editor_google`.`gce_campaignAdExtensionMap`.`searchEngineIdentifier` AS `adExtensionIdentifier`,`content_editor_google`.`gce_adSiteLink`.`id` AS `siteLinkID`,`content_editor_google`.`gce_adSiteLink`.`text`,`content_editor_google`.`gce_adSiteLink`.`destinationURL`,`content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate`.`campaignID` AS `gce_campaign_campaignID` from `content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate` join `content_editor_google`.`gce_campaignAdExtensionMap` on ((`content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate`.`adExtensionID`=`content_editor_google`.`gce_campaignAdExtensionMap`.`adExtensionID`)) join `content_editor_google`.`gce_adSiteLink` on ((`content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate`.`adExtensionID`=`content_editor_google`.`gce_adSiteLink`.`adExtensionID`)) where (`content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate`.`campaignID`=1631)]
2013-02-22 07:18:46.248 (4) [pool-3-thread-4]: time=0.0020
2013-02-22 07:18:46.248 (4) [pool-3-thread-4]: Query executed in 0.002s
2013-02-22 07:18:46.248 (4) [pool-3-thread-4]: spike: SQL->[select * from `content_editor_google`.`gce_campaignProximityTargetMapPendingUpdate` join `content_editor_google`.`gce_target` on ((`content_editor_google`.`gce_campaignProximityTargetMapPendingUpdate`.`targetID`=`content_editor_google`.`gce_target`.`id`)) left join `content_editor_google`.`gce_campaignProximityTargetMap` on (((`content_editor_google`.`gce_campaignProximityTargetMap`.`targetID`=`content_editor_google`.`gce_target`.`id`) and (`content_editor_google`.`gce_campaignProximityTargetMap`.`campaignID`=`content_editor_google`.`gce_campaignProximityTargetMapPendingUpdate`.`campaignID`))) where (`content_editor_google`.`gce_campaignProximityTargetMapPendingUpdate`.`campaignID`=1632)]
2013-02-22 07:18:46.250 (4) [pool-3-thread-4]: time=0.0020
2013-02-22 07:18:46.250 (4) [pool-3-thread-4]: Query executed in 0.002s
2013-02-22 07:18:46.250 (4) [pool-3-thread-4]: spike: SQL->[select * from `content_editor_google`.`gce_campaignTargetMapPendingUpdate` join `content_editor_google`.`gce_target` on ((`content_editor_google`.`gce_campaignTargetMapPendingUpdate`.`targetID`=`content_editor_google`.`gce_target`.`id`)) left join `content_editor_google`.`gce_campaignProximityTargetMap` on (((`content_editor_google`.`gce_campaignProximityTargetMap`.`targetID`=`content_editor_google`.`gce_target`.`id`) and (`content_editor_google`.`gce_campaignProximityTargetMap`.`campaignID`=`content_editor_google`.`gce_campaignTargetMapPendingUpdate`.`campaignID`))) where (`content_editor_google`.`gce_campaignTargetMapPendingUpdate`.`campaignID`=1632)]
2013-02-22 07:18:46.252 (4) [pool-3-thread-4]: time=0.0020
2013-02-22 07:18:46.252 (4) [pool-3-thread-4]: Query executed in 0.002s
2013-02-22 07:18:46.252 (4) [pool-3-thread-4]: spike: SQL->[select `content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate`.*,`content_editor_google`.`gce_campaignAdExtensionMap`.`adExtensionID`,`content_editor_google`.`gce_campaignAdExtensionMap`.`adExtensionType`,`content_editor_google`.`gce_campaignAdExtensionMap`.`searchEngineIdentifier` AS `adExtensionIdentifier`,`content_editor_google`.`gce_adSiteLink`.`id` AS `siteLinkID`,`content_editor_google`.`gce_adSiteLink`.`text`,`content_editor_google`.`gce_adSiteLink`.`destinationURL`,`content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate`.`campaignID` AS `gce_campaign_campaignID` from `content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate` join `content_editor_google`.`gce_campaignAdExtensionMap` on ((`content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate`.`adExtensionID`=`content_editor_google`.`gce_campaignAdExtensionMap`.`adExtensionID`)) join `content_editor_google`.`gce_adSiteLink` on ((`content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate`.`adExtensionID`=`content_editor_google`.`gce_adSiteLink`.`adExtensionID`)) where (`content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate`.`campaignID`=1632)]
2013-02-22 07:18:46.254 (4) [pool-3-thread-4]: time=0.0020
2013-02-22 07:18:46.254 (4) [pool-3-thread-4]: Query executed in 0.002s
2013-02-22 07:18:46.254 (4) [pool-3-thread-4]: spike: SQL->[select `campaignID`,`errorCode`,`errorText`,`reason`,`policyName`,`field`,`trigger`,`isExemptable` from `content_editor_google`.`gce_campaignError` where (`gce_campaignError`.`campaignID`=1630)]
2013-02-22 07:18:46.256 (4) [pool-3-thread-4]: time=0.0020
2013-02-22 07:18:46.256 (4) [pool-3-thread-4]: Query executed in 0.002s
2013-02-22 07:18:46.256 (4) [pool-3-thread-4]: spike: SQL->[select `campaignID`,`errorCode`,`errorText`,`reason`,`policyName`,`field`,`trigger`,`isExemptable` from `content_editor_google`.`gce_campaignError` where (`gce_campaignError`.`campaignID`=1631)]
2013-02-22 07:18:46.258 (4) [pool-3-thread-4]: time=0.0010
2013-02-22 07:18:46.258 (4) [pool-3-thread-4]: Query executed in 0.001s
2013-02-22 07:18:46.258 (4) [pool-3-thread-4]: spike: SQL->[select `campaignID`,`errorCode`,`errorText`,`reason`,`policyName`,`field`,`trigger`,`isExemptable` from `content_editor_google`.`gce_campaignError` where (`gce_campaignError`.`campaignID`=1632)]
2013-02-22 07:18:46.259 (4) [pool-3-thread-4]: time=0.0010
2013-02-22 07:18:46.260 (4) [pool-3-thread-4]: Query executed in 0.001s
2013-02-22 07:18:46.260 (3) [pool-3-thread-4]: 8ee2247d-cacc-4283-8853-ae7ce635409e_10034_4051_1225_GT status change (Active->Paused)
2013-02-22 07:18:46.260 (3) [pool-3-thread-4]: No budget update required
2013-02-22 07:18:46.260 (3) [pool-3-thread-4]: No update necessary: optimizer settings are the same.
2013-02-22 07:18:46.260 (3) [pool-3-thread-4]: No budget optimizer update required.
2013-02-22 07:18:46.260 (3) [pool-3-thread-4]: 8ee2247d-cacc-4283-8853-ae7ce635409e_10034_4051_1225_GT No targets in message. Skipping target sync.
2013-02-22 07:18:46.260 (3) [pool-3-thread-4]: 8ee2247d-cacc-4283-8853-ae7ce635409e_10034_4051_1225_GT No site links in message. Skipping site link sync.
2013-02-22 07:18:46.260 (3) [pool-3-thread-4]: 8ee2247d-cacc-4283-8853-ae7ce635409e_10034_4051_1225_GM status change (Active->Paused)
2013-02-22 07:18:46.261 (3) [pool-3-thread-4]: No budget update required
2013-02-22 07:18:46.261 (3) [pool-3-thread-4]: No update necessary: optimizer settings are the same.
2013-02-22 07:18:46.261 (3) [pool-3-thread-4]: No budget optimizer update required.
2013-02-22 07:18:46.261 (3) [pool-3-thread-4]: 8ee2247d-cacc-4283-8853-ae7ce635409e_10034_4051_1225_GM No targets in message. Skipping target sync.
2013-02-22 07:18:46.261 (3) [pool-3-thread-4]: 8ee2247d-cacc-4283-8853-ae7ce635409e_10034_4051_1225_GM No site links in message. Skipping site link sync.
2013-02-22 07:18:46.261 (3) [pool-3-thread-4]: 8ee2247d-cacc-4283-8853-ae7ce635409e_10034_4051_1225_MO status change (Active->Paused)
2013-02-22 07:18:46.261 (3) [pool-3-thread-4]: No budget update required
2013-02-22 07:18:46.261 (3) [pool-3-thread-4]: No update necessary: optimizer settings are the same.
2013-02-22 07:18:46.262 (3) [pool-3-thread-4]: No budget optimizer update required.
2013-02-22 07:18:46.262 (3) [pool-3-thread-4]: 8ee2247d-cacc-4283-8853-ae7ce635409e_10034_4051_1225_MO No targets in message. Skipping target sync.
2013-02-22 07:18:46.262 (3) [pool-3-thread-4]: 8ee2247d-cacc-4283-8853-ae7ce635409e_10034_4051_1225_MO No site links in message. Skipping site link sync.
2013-02-22 07:18:46.262 (4) [pool-3-thread-4]: Returning Object to Pool
2013-02-22 07:18:46.262 (4) [pool-3-thread-4]: DataCache: Found key acct-content-google 289
2013-02-22 07:18:46.262 (4) [pool-3-thread-4]: DataCache: Found key acct-content-google-1
2013-02-22 07:18:46.263 (4) [pool-3-thread-4]: Took Existing Object from Pool
2013-02-22 07:18:46.263 (4) [pool-3-thread-4]: spike: SQL->[select @@version]
2013-02-22 07:18:46.264 (4) [pool-3-thread-4]: time=0.0010
2013-02-22 07:18:46.264 (4) [pool-3-thread-4]: Query executed in 0.001s
2013-02-22 07:18:46.264 (4) [pool-3-thread-4]: test query succeeded, returned "5.1.65-rel14.0"
2013-02-22 07:18:46.265 (4) [pool-3-thread-4]: spike: SQL->[insert into `content_editor_google`.`gce_campaignPendingChange` (`isFailed`,`requestTime`,`campaignID`,`tryCount`,`type`) values ("false","2013-02-22 07:18:46",1630,0,"update") on duplicate key update `isFailed`="false",`requestTime`="2013-02-22 07:18:46",`tryCount`=0,`type`=IF((`type`="add"), "add", "update")], genflags=no
2013-02-22 07:18:46.267 (4) [pool-3-thread-4]: time=0.0020
2013-02-22 07:18:46.267 (4) [pool-3-thread-4]: Query executed in 0.002s, 1 row(s) affected
2013-02-22 07:18:46.267 (4) [pool-3-thread-4]: Inserted a new pending change
2013-02-22 07:18:46.268 (4) [pool-3-thread-4]: spike: SQL->[delete from `content_editor_google`.`gce_campaignPendingUpdate` where (`campaignID`=1630)], genflags=no
2013-02-22 07:18:46.269 (4) [pool-3-thread-4]: time=0.0010
2013-02-22 07:18:46.269 (4) [pool-3-thread-4]: Query executed in 0.001s, 0 row(s) affected
2013-02-22 07:18:46.269 (4) [pool-3-thread-4]: spike: SQL->[insert into `content_editor_google`.`gce_campaignPendingUpdate` (`campaignID`,`status`) values (1630,"Paused")], genflags=no
2013-02-22 07:18:46.271 (4) [pool-3-thread-4]: time=0.0010
2013-02-22 07:18:46.271 (4) [pool-3-thread-4]: Query executed in 0.001s, 1 row(s) affected
2013-02-22 07:18:46.271 (4) [pool-3-thread-4]: spike: SQL->[insert into `content_editor_google`.`gce_campaignPendingChange` (`isFailed`,`requestTime`,`campaignID`,`tryCount`,`type`) values ("false","2013-02-22 07:18:46",1631,0,"update") on duplicate key update `isFailed`="false",`requestTime`="2013-02-22 07:18:46",`tryCount`=0,`type`=IF((`type`="add"), "add", "update")], genflags=no
2013-02-22 07:18:46.323 (4) [pool-3-thread-4]: time=0.052
2013-02-22 07:18:46.323 (4) [pool-3-thread-4]: Query executed in 0.052s, 1 row(s) affected
2013-02-22 07:18:46.323 (4) [pool-3-thread-4]: Inserted a new pending change
2013-02-22 07:18:46.323 (4) [pool-3-thread-4]: spike: SQL->[delete from `content_editor_google`.`gce_campaignPendingUpdate` where (`campaignID`=1631)], genflags=no
2013-02-22 07:18:46.325 (4) [pool-3-thread-4]: time=0.0020
2013-02-22 07:18:46.325 (4) [pool-3-thread-4]: Query executed in 0.002s, 0 row(s) affected
2013-02-22 07:18:46.325 (4) [pool-3-thread-4]: spike: SQL->[insert into `content_editor_google`.`gce_campaignPendingUpdate` (`campaignID`,`status`) values (1631,"Paused")], genflags=no
2013-02-22 07:18:46.327 (4) [pool-3-thread-4]: time=0.0020
2013-02-22 07:18:46.327 (4) [pool-3-thread-4]: Query executed in 0.002s, 1 row(s) affected
2013-02-22 07:18:46.327 (4) [pool-3-thread-4]: spike: SQL->[insert into `content_editor_google`.`gce_campaignPendingChange` (`isFailed`,`requestTime`,`campaignID`,`tryCount`,`type`) values ("false","2013-02-22 07:18:46",1632,0,"update") on duplicate key update `isFailed`="false",`requestTime`="2013-02-22 07:18:46",`tryCount`=0,`type`=IF((`type`="add"), "add", "update")], genflags=no
2013-02-22 07:18:46.329 (4) [pool-3-thread-4]: time=0.0020
2013-02-22 07:18:46.329 (4) [pool-3-thread-4]: Query executed in 0.002s, 1 row(s) affected
2013-02-22 07:18:46.329 (4) [pool-3-thread-4]: Inserted a new pending change
2013-02-22 07:18:46.329 (4) [pool-3-thread-4]: spike: SQL->[delete from `content_editor_google`.`gce_campaignPendingUpdate` where (`campaignID`=1632)], genflags=no
2013-02-22 07:18:46.330 (4) [pool-3-thread-4]: time=0.0010
2013-02-22 07:18:46.330 (4) [pool-3-thread-4]: Query executed in 0.001s, 0 row(s) affected
2013-02-22 07:18:46.331 (4) [pool-3-thread-4]: spike: SQL->[insert into `content_editor_google`.`gce_campaignPendingUpdate` (`campaignID`,`status`) values (1632,"Paused")], genflags=no
2013-02-22 07:18:46.332 (4) [pool-3-thread-4]: time=0.0010
2013-02-22 07:18:46.332 (4) [pool-3-thread-4]: Query executed in 0.001s, 1 row(s) affected
2013-02-22 07:18:46.332 (4) [pool-3-thread-4]: Returning Object to Pool
2013-02-22 07:18:46.332 (3) [pool-3-thread-4]: ----------------Google Content Editor starting
2013-02-22 07:18:46.332 (4) [pool-3-thread-4]: no account, or instance for databaseInstance, skipping lookup...
2013-02-22 07:18:46.401 (4) [pool-3-thread-4]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2013-02-22 07:18:46.401 (4) [pool-3-thread-4]: 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`.`distributionID`="3") and (`tsacommon`.`searchEngineUsers`.`accountID` in (289))) order by `tsacommon`.`accounts`.`tier` asc,`tsacommon`.`accounts`.`priority` asc,`tsacommon`.`accounts`.`id` desc]
2013-02-22 07:18:46.407 (4) [pool-3-thread-4]: time=0.0050
2013-02-22 07:18:46.407 (4) [pool-3-thread-4]: Query executed in 0.005s
2013-02-22 07:18:46.408 (4) [P6T1]: User  in TSA MCC, connecting using master username/password
2013-02-22 07:18:46.408 (4) [P6T1]: client customer id = 2620813338
2013-02-22 07:18:46.408 (4) [P6T1]: seuserid[284] username[null] password[null] customerID[2620813338]
2013-02-22 07:18:46.412 (3) [P6T1]: secureProxy : null:null
2013-02-22 07:18:46.412 (3) [P6T1]: normalProxy : null:null
2013-02-22 07:18:46.413 (4) [P6T1]: No secure proxy configuration detected.
2013-02-22 07:18:46.413 (4) [P6T1]: No proxy configuration detected.
2013-02-22 07:18:46.413 (4) [P6T1]: ClearConnections called at: Fri Feb 22 07:18:46 UTC 2013      Timer: 1361517489805
2013-02-22 07:18:46.413 (4) [P6T1]: sesystem: SQL->[select 1]
2013-02-22 07:18:46.419 (4) [P6T1]: time=0.0060
2013-02-22 07:18:46.419 (4) [P6T1]: Query executed in 0.006s
2013-02-22 07:18:46.419 (4) [P6T1]: sesystem: SQL->[update `sesystem`.`searchEngineConnections` set `holder`="",`inUse`="false",`holderIdentifier`="",`timeStamp`="2013-02-22 07:18:46" where ((`sesystem`.`searchEngineConnections`.`distributionID`=3) and (`sesystem`.`searchEngineConnections`.`inUse`="true") and (`sesystem`.`searchEngineConnections`.`timeStamp`<="2013-02-22 07:13:46")) limit 1], genflags=no
2013-02-22 07:18:46.422 (4) [P6T1]: time=0.0030
2013-02-22 07:18:46.422 (4) [P6T1]: Query executed in 0.003s, 0 row(s) affected
2013-02-22 07:18:46.422 (4) [P6T1]: Setting AuthToken [DQAAALcAAAC_OpV1_u646EzIbreILQsDulIty5N9zJ-pGS0uKF55_OAGR5tanPsZoemrJo9XnDO5fOqRgqX-CsqlvZM6AgmjVMHwIkhTn3n5_HYrWbEL5u-LWWZNiK_nGHyfWOuHfbxwsmpwmDLG9QsHpXGbWN6YN3Wi_nmBDvHOdnmBCbHrVqODhJlFocGYjkYZWmhiPQUghwXZhBtmdVW1ODUY65KCtKns3CXoZ9VXUrldWoNvOZeNF6KJQORtdB6QUJserUI] to AdWordsSession object for username[ffejsmb@gmail.com]
2013-02-22 07:18:46.423 (4) [P6T1]: User  in TSA MCC, connecting using master username/password
2013-02-22 07:18:46.423 (4) [P6T1]: client customer id = 2620813338
2013-02-22 07:18:46.423 (4) [P6T1]: seuserid[284] username[null] password[null] customerID[2620813338]
2013-02-22 07:18:46.424 (3) [P6T1]: secureProxy : null:null
2013-02-22 07:18:46.425 (3) [P6T1]: normalProxy : null:null
2013-02-22 07:18:46.425 (4) [P6T1]: No secure proxy configuration detected.
2013-02-22 07:18:46.425 (4) [P6T1]: No proxy configuration detected.
2013-02-22 07:18:46.425 (4) [P6T1]: Setting AuthToken [DQAAALcAAAC_OpV1_u646EzIbreILQsDulIty5N9zJ-pGS0uKF55_OAGR5tanPsZoemrJo9XnDO5fOqRgqX-CsqlvZM6AgmjVMHwIkhTn3n5_HYrWbEL5u-LWWZNiK_nGHyfWOuHfbxwsmpwmDLG9QsHpXGbWN6YN3Wi_nmBDvHOdnmBCbHrVqODhJlFocGYjkYZWmhiPQUghwXZhBtmdVW1ODUY65KCtKns3CXoZ9VXUrldWoNvOZeNF6KJQORtdB6QUJserUI] to AdWordsSession object for username[ffejsmb@gmail.com]
2013-02-22 07:18:46.425 (4) [P6T1]: User  in TSA MCC, connecting using master username/password
2013-02-22 07:18:46.426 (4) [P6T1]: client customer id = 2620813338
2013-02-22 07:18:46.426 (4) [P6T1]: seuserid[284] username[null] password[null] customerID[2620813338]
2013-02-22 07:18:46.428 (3) [P6T1]: secureProxy : null:null
2013-02-22 07:18:46.428 (3) [P6T1]: normalProxy : null:null
2013-02-22 07:18:46.428 (4) [P6T1]: No secure proxy configuration detected.
2013-02-22 07:18:46.428 (4) [P6T1]: No proxy configuration detected.
2013-02-22 07:18:46.428 (4) [P6T1]: Setting AuthToken [DQAAALcAAAC_OpV1_u646EzIbreILQsDulIty5N9zJ-pGS0uKF55_OAGR5tanPsZoemrJo9XnDO5fOqRgqX-CsqlvZM6AgmjVMHwIkhTn3n5_HYrWbEL5u-LWWZNiK_nGHyfWOuHfbxwsmpwmDLG9QsHpXGbWN6YN3Wi_nmBDvHOdnmBCbHrVqODhJlFocGYjkYZWmhiPQUghwXZhBtmdVW1ODUY65KCtKns3CXoZ9VXUrldWoNvOZeNF6KJQORtdB6QUJserUI] to AdWordsSession object for username[ffejsmb@gmail.com]
2013-02-22 07:18:46.429 (4) [P6T1]: DataCache: Found key acct-content-google 289
2013-02-22 07:18:46.429 (4) [P6T1]: DataCache: Found key acct-content-google-1
2013-02-22 07:18:46.429 (4) [P6T1]: Took Existing Object from Pool
2013-02-22 07:18:46.429 (4) [P6T1]: spike: SQL->[select @@version]
2013-02-22 07:18:46.433 (4) [P6T1]: time=0.0040
2013-02-22 07:18:46.433 (4) [P6T1]: Query executed in 0.004s
2013-02-22 07:18:46.433 (4) [P6T1]: test query succeeded, returned "5.1.65-rel14.0"
2013-02-22 07:18:46.434 (4) [P6T1]: spike: SQL->[select `content_editor_google`.`gce_campaign`.*,`content_editor_google`.`gce_campaignPendingChange`.*,`content_editor_google`.`gce_campaignTargetMap`.*,`content_editor_google`.`gce_campaignBudgetOptimizerSetting`.*,`content_editor_google`.`gce_target`.`code`,`content_editor_google`.`gce_target`.`targetType`,`content_editor_google`.`gce_target`.`criterionID`,`content_editor_google`.`gce_campaignProximityTargetMap`.`criterionID`,`content_editor_google`.`gce_campaignProximityTargetMap`.`latitudeInMicroDegrees`,`content_editor_google`.`gce_campaignProximityTargetMap`.`longitudeInMicroDegrees`,`content_editor_google`.`gce_campaignProximityTargetMap`.`radius`,`content_editor_google`.`gce_campaignProximityTargetMap`.`radiusUnits`,`content_editor_google`.`gce_campaign`.`id` AS `gce_campaign_campaignID` from `content_editor_google`.`gce_campaign` inner join `gce_campaignPendingChange` on ((`content_editor_google`.`gce_campaignPendingChange`.`campaignID`=`content_editor_google`.`gce_campaign`.`id`)) left join `gce_campaignTargetMap` on ((`content_editor_google`.`gce_campaignTargetMap`.`campaignID`=`content_editor_google`.`gce_campaign`.`id`)) left join `gce_target` on ((`content_editor_google`.`gce_campaignTargetMap`.`targetID`=`content_editor_google`.`gce_target`.`id`)) left join `gce_campaignBudgetOptimizerSetting` on ((`content_editor_google`.`gce_campaignBudgetOptimizerSetting`.`campaignID`=`content_editor_google`.`gce_campaign`.`id`)) left join `content_editor_google`.`gce_campaignProximityTargetMap` on (((((`content_editor_google`.`gce_campaignProximityTargetMap`.`campaignID`=`content_editor_google`.`gce_campaignTargetMap`.`campaignID`)) and ((`content_editor_google`.`gce_campaignProximityTargetMap`.`targetID`=`content_editor_google`.`gce_campaignTargetMap`.`targetID`))))) where ((`searchEngineUserID`=284) and (`gce_campaign`.`id` in (1630,1631,1632)) and (((((`isFailed`="true") and (`tryCount`<10))) or ((`isFailed`="false")))) and (`type`="add"))]
2013-02-22 07:18:46.436 (4) [P6T1]: time=0.0020
2013-02-22 07:18:46.436 (4) [P6T1]: Query executed in 0.002s
2013-02-22 07:18:46.437 (4) [P6T1]: spike: SQL->[select `content_editor_google`.`gce_campaign`.`id`,`content_editor_google`.`gce_campaignPendingChange`.*,`content_editor_google`.`gce_campaignAdExtensionMap`.`adExtensionID`,`content_editor_google`.`gce_campaignAdExtensionMap`.`adExtensionType`,`content_editor_google`.`gce_campaignAdExtensionMap`.`searchEngineIdentifier` AS `adExtensionIdentifier`,`content_editor_google`.`gce_adSiteLink`.`id` AS `siteLinkID`,`content_editor_google`.`gce_adSiteLink`.`text`,`content_editor_google`.`gce_adSiteLink`.`destinationURL`,`content_editor_google`.`gce_campaign`.`id` AS `gce_campaign_campaignID` from `content_editor_google`.`gce_campaign` inner join `gce_campaignPendingChange` on ((`content_editor_google`.`gce_campaignPendingChange`.`campaignID`=`content_editor_google`.`gce_campaign`.`id`)) left join `gce_campaignAdExtensionMap` on ((`content_editor_google`.`gce_campaignAdExtensionMap`.`campaignID`=`content_editor_google`.`gce_campaign`.`id`)) left join `gce_adSiteLink` on ((`content_editor_google`.`gce_campaignAdExtensionMap`.`adExtensionID`=`content_editor_google`.`gce_adSiteLink`.`adExtensionID`)) where ((`searchEngineUserID`=284) and (`gce_campaign`.`id` in (1630,1631,1632)) and (((((`isFailed`="true") and (`tryCount`<10))) or ((`isFailed`="false")))) and (`type`="add"))]
2013-02-22 07:18:46.441 (4) [P6T1]: time=0.0040
2013-02-22 07:18:46.441 (4) [P6T1]: Query executed in 0.004s
2013-02-22 07:18:46.441 (4) [P6T1]: CampaignChangeRequest (accountID 289): : No pending add requests
2013-02-22 07:18:46.443 (4) [P6T1]: spike: SQL->[select `content_editor_google`.`gce_campaign`.*,`content_editor_google`.`gce_campaignPendingChange`.*,`content_editor_google`.`gce_campaignTargetMap`.*,`content_editor_google`.`gce_campaignBudgetOptimizerSetting`.*,`content_editor_google`.`gce_target`.`code`,`content_editor_google`.`gce_target`.`targetType`,`content_editor_google`.`gce_target`.`criterionID`,`content_editor_google`.`gce_campaignProximityTargetMap`.`criterionID`,`content_editor_google`.`gce_campaignProximityTargetMap`.`latitudeInMicroDegrees`,`content_editor_google`.`gce_campaignProximityTargetMap`.`longitudeInMicroDegrees`,`content_editor_google`.`gce_campaignProximityTargetMap`.`radius`,`content_editor_google`.`gce_campaignProximityTargetMap`.`radiusUnits`,`content_editor_google`.`gce_campaign`.`id` AS `gce_campaign_campaignID`,`gce_campaignPendingUpdate`.`name` AS `nameChange`,`gce_campaignPendingUpdate`.`budgetAmount` AS `budgetAmountChange`,`gce_campaignPendingUpdate`.`budgetPeriod` AS `budgetPeriodChange`,`gce_campaignPendingUpdate`.`contentTargeting` AS `contentTargetingChange`,`gce_campaignPendingUpdate`.`endDay` AS `endDayChange`,`gce_campaignPendingUpdate`.`status` AS `statusChange`,`gce_campaignPendingUpdate`.`budgetOptimizerBidCeiling` AS `budgetOptimizerBidCeilingChange`,`gce_campaignPendingUpdate`.`budgetOptimizerEnabled` AS `budgetOptimizerEnabledChange`,`gce_campaignPendingUpdate`.`budgetOptimizerTakeOnOptimizedBids` AS `budgetOptimizerTakeOnOptimizedBidsChange` from `content_editor_google`.`gce_campaign` inner join `gce_campaignPendingChange` on ((`content_editor_google`.`gce_campaignPendingChange`.`campaignID`=`content_editor_google`.`gce_campaign`.`id`)) inner join `gce_campaignPendingUpdate` on ((`gce_campaignPendingUpdate`.`campaignID`=`gce_campaign`.`id`)) left join `gce_campaignTargetMap` on ((`content_editor_google`.`gce_campaignTargetMap`.`campaignID`=`content_editor_google`.`gce_campaign`.`id`)) left join `gce_target` on ((`content_editor_google`.`gce_campaignTargetMap`.`targetID`=`content_editor_google`.`gce_target`.`id`)) left join `gce_campaignBudgetOptimizerSetting` on ((`content_editor_google`.`gce_campaignBudgetOptimizerSetting`.`campaignID`=`content_editor_google`.`gce_campaign`.`id`)) left join `content_editor_google`.`gce_campaignProximityTargetMap` on (((((`content_editor_google`.`gce_campaignProximityTargetMap`.`campaignID`=`content_editor_google`.`gce_campaignTargetMap`.`campaignID`)) and ((`content_editor_google`.`gce_campaignProximityTargetMap`.`targetID`=`content_editor_google`.`gce_campaignTargetMap`.`targetID`))))) where ((`searchEngineUserID`=284) and (`gce_campaign`.`id` in (1630,1631,1632)) and (((((`isFailed`="true") and (`tryCount`<10))) or ((`isFailed`="false")))) and (`type`="update"))]
2013-02-22 07:18:46.445 (4) [P6T1]: time=0.0020
2013-02-22 07:18:46.445 (4) [P6T1]: Query executed in 0.002s
2013-02-22 07:18:46.457 (4) [P6T1]: spike: SQL->[select `content_editor_google`.`gce_campaign`.`id`,`content_editor_google`.`gce_campaignPendingChange`.*,`content_editor_google`.`gce_campaignAdExtensionMap`.`adExtensionID`,`content_editor_google`.`gce_campaignAdExtensionMap`.`adExtensionType`,`content_editor_google`.`gce_campaignAdExtensionMap`.`searchEngineIdentifier` AS `adExtensionIdentifier`,`content_editor_google`.`gce_adSiteLink`.`id` AS `siteLinkID`,`content_editor_google`.`gce_adSiteLink`.`text`,`content_editor_google`.`gce_adSiteLink`.`destinationURL`,`content_editor_google`.`gce_campaign`.`id` AS `gce_campaign_campaignID` from `content_editor_google`.`gce_campaign` inner join `gce_campaignPendingChange` on ((`content_editor_google`.`gce_campaignPendingChange`.`campaignID`=`content_editor_google`.`gce_campaign`.`id`)) left join `gce_campaignAdExtensionMap` on ((`content_editor_google`.`gce_campaignAdExtensionMap`.`campaignID`=`content_editor_google`.`gce_campaign`.`id`)) left join `gce_adSiteLink` on ((`content_editor_google`.`gce_campaignAdExtensionMap`.`adExtensionID`=`content_editor_google`.`gce_adSiteLink`.`adExtensionID`)) where ((`searchEngineUserID`=284) and (`gce_campaign`.`id` in (1630,1631,1632)) and (((((`isFailed`="true") and (`tryCount`<10))) or ((`isFailed`="false")))) and (`type`="update"))]
2013-02-22 07:18:46.462 (4) [P6T1]: time=0.0050
2013-02-22 07:18:46.462 (4) [P6T1]: Query executed in 0.005s
2013-02-22 07:18:46.462 (4) [P6T1]: spike: SQL->[select * from `content_editor_google`.`gce_campaignProximityTargetMapPendingUpdate` join `content_editor_google`.`gce_target` on ((`content_editor_google`.`gce_campaignProximityTargetMapPendingUpdate`.`targetID`=`content_editor_google`.`gce_target`.`id`)) left join `content_editor_google`.`gce_campaignProximityTargetMap` on (((`content_editor_google`.`gce_campaignProximityTargetMap`.`targetID`=`content_editor_google`.`gce_target`.`id`) and (`content_editor_google`.`gce_campaignProximityTargetMap`.`campaignID`=`content_editor_google`.`gce_campaignProximityTargetMapPendingUpdate`.`campaignID`))) where (`content_editor_google`.`gce_campaignProximityTargetMapPendingUpdate`.`campaignID`=1630)]
2013-02-22 07:18:46.464 (4) [P6T1]: time=0.0020
2013-02-22 07:18:46.464 (4) [P6T1]: Query executed in 0.002s
2013-02-22 07:18:46.464 (4) [P6T1]: spike: SQL->[select * from `content_editor_google`.`gce_campaignTargetMapPendingUpdate` join `content_editor_google`.`gce_target` on ((`content_editor_google`.`gce_campaignTargetMapPendingUpdate`.`targetID`=`content_editor_google`.`gce_target`.`id`)) left join `content_editor_google`.`gce_campaignProximityTargetMap` on (((`content_editor_google`.`gce_campaignProximityTargetMap`.`targetID`=`content_editor_google`.`gce_target`.`id`) and (`content_editor_google`.`gce_campaignProximityTargetMap`.`campaignID`=`content_editor_google`.`gce_campaignTargetMapPendingUpdate`.`campaignID`))) where (`content_editor_google`.`gce_campaignTargetMapPendingUpdate`.`campaignID`=1630)]
2013-02-22 07:18:46.466 (4) [P6T1]: time=0.0020
2013-02-22 07:18:46.466 (4) [P6T1]: Query executed in 0.002s
2013-02-22 07:18:46.466 (4) [P6T1]: spike: SQL->[select `content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate`.*,`content_editor_google`.`gce_campaignAdExtensionMap`.`adExtensionID`,`content_editor_google`.`gce_campaignAdExtensionMap`.`adExtensionType`,`content_editor_google`.`gce_campaignAdExtensionMap`.`searchEngineIdentifier` AS `adExtensionIdentifier`,`content_editor_google`.`gce_adSiteLink`.`id` AS `siteLinkID`,`content_editor_google`.`gce_adSiteLink`.`text`,`content_editor_google`.`gce_adSiteLink`.`destinationURL`,`content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate`.`campaignID` AS `gce_campaign_campaignID` from `content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate` join `content_editor_google`.`gce_campaignAdExtensionMap` on ((`content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate`.`adExtensionID`=`content_editor_google`.`gce_campaignAdExtensionMap`.`adExtensionID`)) join `content_editor_google`.`gce_adSiteLink` on ((`content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate`.`adExtensionID`=`content_editor_google`.`gce_adSiteLink`.`adExtensionID`)) where (`content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate`.`campaignID`=1630)]
2013-02-22 07:18:46.469 (4) [P6T1]: time=0.0030
2013-02-22 07:18:46.469 (4) [P6T1]: Query executed in 0.003s
2013-02-22 07:18:46.470 (4) [P6T1]: spike: SQL->[select * from `content_editor_google`.`gce_campaignProximityTargetMapPendingUpdate` join `content_editor_google`.`gce_target` on ((`content_editor_google`.`gce_campaignProximityTargetMapPendingUpdate`.`targetID`=`content_editor_google`.`gce_target`.`id`)) left join `content_editor_google`.`gce_campaignProximityTargetMap` on (((`content_editor_google`.`gce_campaignProximityTargetMap`.`targetID`=`content_editor_google`.`gce_target`.`id`) and (`content_editor_google`.`gce_campaignProximityTargetMap`.`campaignID`=`content_editor_google`.`gce_campaignProximityTargetMapPendingUpdate`.`campaignID`))) where (`content_editor_google`.`gce_campaignProximityTargetMapPendingUpdate`.`campaignID`=1631)]
2013-02-22 07:18:46.471 (4) [P6T1]: time=0.0010
2013-02-22 07:18:46.471 (4) [P6T1]: Query executed in 0.001s
2013-02-22 07:18:46.471 (4) [P6T1]: spike: SQL->[select * from `content_editor_google`.`gce_campaignTargetMapPendingUpdate` join `content_editor_google`.`gce_target` on ((`content_editor_google`.`gce_campaignTargetMapPendingUpdate`.`targetID`=`content_editor_google`.`gce_target`.`id`)) left join `content_editor_google`.`gce_campaignProximityTargetMap` on (((`content_editor_google`.`gce_campaignProximityTargetMap`.`targetID`=`content_editor_google`.`gce_target`.`id`) and (`content_editor_google`.`gce_campaignProximityTargetMap`.`campaignID`=`content_editor_google`.`gce_campaignTargetMapPendingUpdate`.`campaignID`))) where (`content_editor_google`.`gce_campaignTargetMapPendingUpdate`.`campaignID`=1631)]
2013-02-22 07:18:46.473 (4) [P6T1]: time=0.0020
2013-02-22 07:18:46.473 (4) [P6T1]: Query executed in 0.002s
2013-02-22 07:18:46.473 (4) [P6T1]: spike: SQL->[select `content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate`.*,`content_editor_google`.`gce_campaignAdExtensionMap`.`adExtensionID`,`content_editor_google`.`gce_campaignAdExtensionMap`.`adExtensionType`,`content_editor_google`.`gce_campaignAdExtensionMap`.`searchEngineIdentifier` AS `adExtensionIdentifier`,`content_editor_google`.`gce_adSiteLink`.`id` AS `siteLinkID`,`content_editor_google`.`gce_adSiteLink`.`text`,`content_editor_google`.`gce_adSiteLink`.`destinationURL`,`content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate`.`campaignID` AS `gce_campaign_campaignID` from `content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate` join `content_editor_google`.`gce_campaignAdExtensionMap` on ((`content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate`.`adExtensionID`=`content_editor_google`.`gce_campaignAdExtensionMap`.`adExtensionID`)) join `content_editor_google`.`gce_adSiteLink` on ((`content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate`.`adExtensionID`=`content_editor_google`.`gce_adSiteLink`.`adExtensionID`)) where (`content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate`.`campaignID`=1631)]
2013-02-22 07:18:46.474 (4) [P6T1]: time=0.0010
2013-02-22 07:18:46.475 (4) [P6T1]: Query executed in 0.001s
2013-02-22 07:18:46.475 (4) [P6T1]: spike: SQL->[select * from `content_editor_google`.`gce_campaignProximityTargetMapPendingUpdate` join `content_editor_google`.`gce_target` on ((`content_editor_google`.`gce_campaignProximityTargetMapPendingUpdate`.`targetID`=`content_editor_google`.`gce_target`.`id`)) left join `content_editor_google`.`gce_campaignProximityTargetMap` on (((`content_editor_google`.`gce_campaignProximityTargetMap`.`targetID`=`content_editor_google`.`gce_target`.`id`) and (`content_editor_google`.`gce_campaignProximityTargetMap`.`campaignID`=`content_editor_google`.`gce_campaignProximityTargetMapPendingUpdate`.`campaignID`))) where (`content_editor_google`.`gce_campaignProximityTargetMapPendingUpdate`.`campaignID`=1632)]
2013-02-22 07:18:46.476 (4) [P6T1]: time=0.0010
2013-02-22 07:18:46.476 (4) [P6T1]: Query executed in 0.001s
2013-02-22 07:18:46.477 (4) [P6T1]: spike: SQL->[select * from `content_editor_google`.`gce_campaignTargetMapPendingUpdate` join `content_editor_google`.`gce_target` on ((`content_editor_google`.`gce_campaignTargetMapPendingUpdate`.`targetID`=`content_editor_google`.`gce_target`.`id`)) left join `content_editor_google`.`gce_campaignProximityTargetMap` on (((`content_editor_google`.`gce_campaignProximityTargetMap`.`targetID`=`content_editor_google`.`gce_target`.`id`) and (`content_editor_google`.`gce_campaignProximityTargetMap`.`campaignID`=`content_editor_google`.`gce_campaignTargetMapPendingUpdate`.`campaignID`))) where (`content_editor_google`.`gce_campaignTargetMapPendingUpdate`.`campaignID`=1632)]
2013-02-22 07:18:46.478 (4) [P6T1]: time=0.0010
2013-02-22 07:18:46.478 (4) [P6T1]: Query executed in 0.001s
2013-02-22 07:18:46.478 (4) [P6T1]: spike: SQL->[select `content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate`.*,`content_editor_google`.`gce_campaignAdExtensionMap`.`adExtensionID`,`content_editor_google`.`gce_campaignAdExtensionMap`.`adExtensionType`,`content_editor_google`.`gce_campaignAdExtensionMap`.`searchEngineIdentifier` AS `adExtensionIdentifier`,`content_editor_google`.`gce_adSiteLink`.`id` AS `siteLinkID`,`content_editor_google`.`gce_adSiteLink`.`text`,`content_editor_google`.`gce_adSiteLink`.`destinationURL`,`content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate`.`campaignID` AS `gce_campaign_campaignID` from `content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate` join `content_editor_google`.`gce_campaignAdExtensionMap` on ((`content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate`.`adExtensionID`=`content_editor_google`.`gce_campaignAdExtensionMap`.`adExtensionID`)) join `content_editor_google`.`gce_adSiteLink` on ((`content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate`.`adExtensionID`=`content_editor_google`.`gce_adSiteLink`.`adExtensionID`)) where (`content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate`.`campaignID`=1632)]
2013-02-22 07:18:46.480 (4) [P6T1]: time=0.0020
2013-02-22 07:18:46.480 (4) [P6T1]: Query executed in 0.002s
2013-02-22 07:18:46.480 (3) [P6T1]: (handleCampaigns - original targets) Network target found: GoogleSearch
2013-02-22 07:18:46.480 (3) [P6T1]: (handleCampaigns - original targets) Network target found: SearchNetwork
2013-02-22 07:18:46.480 (3) [P6T1]: (handleCampaigns - original targets) Network target found: ContentNetwork
2013-02-22 07:18:46.481 (4) [P6T1]: DataCache: Found key acct-content-google 289
2013-02-22 07:18:46.481 (4) [P6T1]: DataCache: Found key acct-content-google-1
2013-02-22 07:18:46.496 (4) [P6T1]: opened [jdbc:mysql://acctdb-01-write:3306/content_editor_google?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2013-02-22 07:18:46.496 (4) [P6T1]: Created new Object
2013-02-22 07:18:46.496 (4) [P6T1]: spike: SQL->[select @@version]
2013-02-22 07:18:46.502 (4) [P6T1]: time=0.0060
2013-02-22 07:18:46.502 (4) [P6T1]: Query executed in 0.006s
2013-02-22 07:18:46.502 (4) [P6T1]: test query succeeded, returned "5.1.65-rel14.0"
2013-02-22 07:18:46.502 (4) [P6T1]: spike: SQL->[select * from `content_editor_google`.`gce_campaignTargetMapPendingUpdate` join `content_editor_google`.`gce_target` on ((`content_editor_google`.`gce_campaignTargetMapPendingUpdate`.`targetID`=`content_editor_google`.`gce_target`.`id`)) where ((`content_editor_google`.`gce_campaignTargetMapPendingUpdate`.`campaignID`=1630) and (`content_editor_google`.`gce_target`.`id`="network"))]
2013-02-22 07:18:46.504 (4) [P6T1]: time=0.0020
2013-02-22 07:18:46.504 (4) [P6T1]: Query executed in 0.002s
2013-02-22 07:18:46.504 (3) [P6T1]: (handleCampaigns - original targets) Network target found: GoogleSearch
2013-02-22 07:18:46.504 (3) [P6T1]: (handleCampaigns - original targets) Network target found: SearchNetwork
2013-02-22 07:18:46.505 (4) [P6T1]: spike: SQL->[select * from `content_editor_google`.`gce_campaignTargetMapPendingUpdate` join `content_editor_google`.`gce_target` on ((`content_editor_google`.`gce_campaignTargetMapPendingUpdate`.`targetID`=`content_editor_google`.`gce_target`.`id`)) where ((`content_editor_google`.`gce_campaignTargetMapPendingUpdate`.`campaignID`=1631) and (`content_editor_google`.`gce_target`.`id`="network"))]
2013-02-22 07:18:46.506 (4) [P6T1]: time=0.0010
2013-02-22 07:18:46.506 (4) [P6T1]: Query executed in 0.001s
2013-02-22 07:18:46.506 (3) [P6T1]: (handleCampaigns - original targets) Network target found: GoogleSearch
2013-02-22 07:18:46.506 (3) [P6T1]: (handleCampaigns - original targets) Network target found: SearchNetwork
2013-02-22 07:18:46.506 (3) [P6T1]: (handleCampaigns - original targets) Network target found: ContentNetwork
2013-02-22 07:18:46.507 (4) [P6T1]: spike: SQL->[select * from `content_editor_google`.`gce_campaignTargetMapPendingUpdate` join `content_editor_google`.`gce_target` on ((`content_editor_google`.`gce_campaignTargetMapPendingUpdate`.`targetID`=`content_editor_google`.`gce_target`.`id`)) where ((`content_editor_google`.`gce_campaignTargetMapPendingUpdate`.`campaignID`=1632) and (`content_editor_google`.`gce_target`.`id`="network"))]
2013-02-22 07:18:46.508 (4) [P6T1]: time=0.0010
2013-02-22 07:18:46.508 (4) [P6T1]: Query executed in 0.001s
2013-02-22 07:18:46.508 (3) [P6T1]: CampaignChangeRequest (accountID 289): Sending 3 update requests
2013-02-22 07:18:46.509 (4) [P6T1]: CampaignChangeRequest (accountID 289): : Sending 3 updates
2013-02-22 07:18:46.509 (4) [P6T1]: sesystem: SQL->[select 1]
2013-02-22 07:18:46.510 (4) [P6T1]: time=0.0010
2013-02-22 07:18:46.511 (4) [P6T1]: Query executed in 0.001s
2013-02-22 07:18:46.511 (4) [P6T1]: sesystem: SQL->[update `sesystem`.`searchEngineConnections` set `searchEngineUserID`=284,`inUse`="true",`holder`="UpdateCampaignList",`holderIdentifier`="2620813338",`timeStamp`="2013-02-22 07:18:46" where ((`sesystem`.`searchEngineConnections`.`distributionID`=3) and (`sesystem`.`searchEngineConnections`.`inUse`="false") and (`sesystem`.`searchEngineConnections`.`owner` is null) and (`sesystem`.`searchEngineConnections`.`searchEngineUserID`=284)) limit 1], genflags=no
2013-02-22 07:18:46.512 (4) [P6T1]: time=0.0010
2013-02-22 07:18:46.513 (4) [P6T1]: Query executed in 0.001s, 1 row(s) affected
2013-02-22 07:18:46.922 (4) [P6T1]: ...updated campaignName[8ee2247d-cacc-4283-8853-ae7ce635409e_10034_4051_1225_GT] campaignID[118216727]
2013-02-22 07:18:46.922 (4) [P6T1]: ...updated campaignName[8ee2247d-cacc-4283-8853-ae7ce635409e_10034_4051_1225_GM] campaignID[118216847]
2013-02-22 07:18:46.923 (4) [P6T1]: ...updated campaignName[8ee2247d-cacc-4283-8853-ae7ce635409e_10034_4051_1225_MO] campaignID[118216967]
2013-02-22 07:18:46.923 (4) [P6T1]: sesystem: SQL->[select 1]
2013-02-22 07:18:46.925 (4) [P6T1]: time=0.0020
2013-02-22 07:18:46.925 (4) [P6T1]: Query executed in 0.002s
2013-02-22 07:18:46.925 (4) [P6T1]: sesystem: SQL->[update `sesystem`.`searchEngineConnections` set `holder`="",`inUse`="false",`holderIdentifier`="",`timeStamp`="2013-02-22 07:18:46" where ((`sesystem`.`searchEngineConnections`.`distributionID`=3) and (`sesystem`.`searchEngineConnections`.`inUse`="true") and (`sesystem`.`searchEngineConnections`.`holder`="UpdateCampaignList") and (`sesystem`.`searchEngineConnections`.`holderIdentifier`="2620813338") and (`sesystem`.`searchEngineConnections`.`searchEngineUserID`=284)) limit 1], genflags=no
2013-02-22 07:18:46.927 (4) [P6T1]: time=0.0020
2013-02-22 07:18:46.927 (4) [P6T1]: Query executed in 0.002s, 1 row(s) affected
2013-02-22 07:18:46.927 (4) [P6T1]: 2620813338 released searchEngineConnection row
2013-02-22 07:18:46.927 (4) [P6T1]: sesystem: SQL->[select 1]
2013-02-22 07:18:46.929 (4) [P6T1]: time=0.0020
2013-02-22 07:18:46.929 (4) [P6T1]: Query executed in 0.002s
2013-02-22 07:18:46.929 (4) [P6T1]: sesystem: SQL->[select * from `sesystem`.`searchEngineResources` where ((`distributionID`=3) and (`operation`="UpdateCampaignList")) limit 1]
2013-02-22 07:18:46.931 (4) [P6T1]: time=0.0020
2013-02-22 07:18:46.931 (4) [P6T1]: Query executed in 0.002s
2013-02-22 07:18:46.931 (4) [P6T1]:   Record Loaded
2013-02-22 07:18:46.932 (4) [P6T1]: sesystem: SQL->[insert into `sesystem`.`searchEngineResourceUsage` (`sesystem`.`searchEngineResourceUsage`.`resourceID`,`sesystem`.`searchEngineResourceUsage`.`periodStart`,`sesystem`.`searchEngineResourceUsage`.`holderID`,`sesystem`.`searchEngineResourceUsage`.`lastUsage`,`sesystem`.`searchEngineResourceUsage`.`opCount`)  values (210,"2013-02-21 08:00:00","2620813338",NOW(),1) on duplicate key update `sesystem`.`searchEngineResourceUsage`.`opCount`=`sesystem`.`searchEngineResourceUsage`.`opCount`+1,`sesystem`.`searchEngineResourceUsage`.`lastUsage`=NOW()], genflags=no
2013-02-22 07:18:46.934 (4) [P6T1]: time=0.0020
2013-02-22 07:18:46.934 (4) [P6T1]: Query executed in 0.002s, 3 row(s) affected
2013-02-22 07:18:46.934 (4) [P6T1]: sesystem: SQL->[select 1]
2013-02-22 07:18:46.935 (4) [P6T1]: time=0.0010
2013-02-22 07:18:46.936 (4) [P6T1]: Query executed in 0.001s
2013-02-22 07:18:46.936 (4) [P6T1]: sesystem: SQL->[insert into `sesystem`.`quotaUsage` values ("284","210","2013-02-22","0","0") on duplicate key update `quotaUsed`=`quotaUsed`+0,`operations`=`operations`+0], genflags=no
2013-02-22 07:18:46.937 (4) [P6T1]: time=0.0010
2013-02-22 07:18:46.937 (4) [P6T1]: Query executed in 0.001s, 2 row(s) affected
2013-02-22 07:18:46.938 (4) [P6T1]: Quota recorded for seUser #284: 0 quota used for resource ID 210
2013-02-22 07:18:46.938 (4) [P6T1]: spike: SQL->[insert ignore into `content_editor_google`.`gce_campaignBudgetOptimizerSetting` (campaignID,bidCeiling,enabled,takeOnOptimizedBids) select `content_editor_google`.`gce_campaignPendingUpdate`.`campaignID`,IF((`content_editor_google`.`gce_campaignPendingUpdate`.`budgetOptimizerBidCeiling` is null), `content_editor_google`.`gce_campaignBudgetOptimizerSetting`.`bidCeiling`, `content_editor_google`.`gce_campaignPendingUpdate`.`budgetOptimizerBidCeiling`),IF((`content_editor_google`.`gce_campaignPendingUpdate`.`budgetOptimizerEnabled` is null), `content_editor_google`.`gce_campaignBudgetOptimizerSetting`.`enabled`, `content_editor_google`.`gce_campaignPendingUpdate`.`budgetOptimizerEnabled`),IF((`content_editor_google`.`gce_campaignPendingUpdate`.`budgetOptimizerTakeOnOptimizedBids` is null), `content_editor_google`.`gce_campaignBudgetOptimizerSetting`.`takeOnOptimizedBids`, `content_editor_google`.`gce_campaignPendingUpdate`.`budgetOptimizerTakeOnOptimizedBids`) from `content_editor_google`.`gce_campaignPendingUpdate` left join `content_editor_google`.`gce_campaignBudgetOptimizerSetting` on ((`content_editor_google`.`gce_campaignPendingUpdate`.`campaignID`=`content_editor_google`.`gce_campaignBudgetOptimizerSetting`.`campaignID`)) where (`content_editor_google`.`gce_campaignPendingUpdate`.`campaignID` in (1630,1631,1632)) on duplicate key update `content_editor_google`.`gce_campaignBudgetOptimizerSetting`.`takeOnOptimizedBids`=IF((`content_editor_google`.`gce_campaignPendingUpdate`.`budgetOptimizerTakeOnOptimizedBids` is null), `content_editor_google`.`gce_campaignBudgetOptimizerSetting`.`takeOnOptimizedBids`, `content_editor_google`.`gce_campaignPendingUpdate`.`budgetOptimizerTakeOnOptimizedBids`),`content_editor_google`.`gce_campaignBudgetOptimizerSetting`.`bidCeiling`=IF((`content_editor_google`.`gce_campaignPendingUpdate`.`budgetOptimizerBidCeiling` is null), `content_editor_google`.`gce_campaignBudgetOptimizerSetting`.`bidCeiling`, `content_editor_google`.`gce_campaignPendingUpdate`.`budgetOptimizerBidCeiling`),`content_editor_google`.`gce_campaignBudgetOptimizerSetting`.`enabled`=IF((`content_editor_google`.`gce_campaignPendingUpdate`.`budgetOptimizerEnabled` is null), `content_editor_google`.`gce_campaignBudgetOptimizerSetting`.`enabled`, `content_editor_google`.`gce_campaignPendingUpdate`.`budgetOptimizerEnabled`)], genflags=no
2013-02-22 07:18:46.940 (4) [P6T1]: time=0.0020
2013-02-22 07:18:46.940 (4) [P6T1]: Query executed in 0.002s, 6 row(s) affected
2013-02-22 07:18:46.941 (4) [P6T1]: Saving CampaignDAO changes
2013-02-22 07:18:46.941 (4) [P6T1]: spike: SQL->[update `content_editor_google`.`gce_campaign` set `status`="Paused" where ((`id`=1630))], genflags=no
2013-02-22 07:18:46.942 (4) [P6T1]: time=0.0010
2013-02-22 07:18:46.942 (4) [P6T1]: Query executed in 0.001s, 1 row(s) affected
2013-02-22 07:18:46.943 (4) [P6T1]: spike: SQL->[update `content_editor_google`.`gce_campaign` set `status`="Paused" where ((`id`=1631))], genflags=no
2013-02-22 07:18:46.944 (4) [P6T1]: time=0.0010
2013-02-22 07:18:46.944 (4) [P6T1]: Query executed in 0.001s, 1 row(s) affected
2013-02-22 07:18:46.944 (4) [P6T1]: spike: SQL->[update `content_editor_google`.`gce_campaign` set `status`="Paused" where ((`id`=1632))], genflags=no
2013-02-22 07:18:46.946 (4) [P6T1]: time=0.0020
2013-02-22 07:18:46.946 (4) [P6T1]: Query executed in 0.002s, 1 row(s) affected
2013-02-22 07:18:46.946 (4) [P6T1]: spike: SQL->[delete from `content_editor_google`.`gce_campaignPendingChange` where (`campaignID` in (1630,1631,1632))], genflags=no
2013-02-22 07:18:46.948 (4) [P6T1]: time=0.0020
2013-02-22 07:18:46.948 (4) [P6T1]: Query executed in 0.002s, 3 row(s) affected
2013-02-22 07:18:46.948 (4) [P6T1]: spike: SQL->[delete from `content_editor_google`.`gce_campaignError` where (`campaignID` in (1630,1631,1632))], genflags=no
2013-02-22 07:18:46.949 (4) [P6T1]: time=0.0010
2013-02-22 07:18:46.950 (4) [P6T1]: Query executed in 0.001s, 0 row(s) affected
2013-02-22 07:18:46.950 (4) [P6T1]: spike: SQL->[delete from `content_editor_google`.`gce_campaignPendingUpdate` where (`campaignID` in (1630,1631,1632))], genflags=no
2013-02-22 07:18:46.951 (4) [P6T1]: time=0.0010
2013-02-22 07:18:46.951 (4) [P6T1]: Query executed in 0.001s, 3 row(s) affected
2013-02-22 07:18:46.951 (3) [P6T1]: CampaignDAO(accountID 289) Request contained 0 adds, 3 updates, 0 deletes.
2013-02-22 07:18:46.952 (3) [P6T1]: CampaignDAO(accountID 289) DB updates: 3 items updated, 3 pending changes deleted, 3 pending updates deleted, 0 errors cleared
2013-02-22 07:18:46.952 (4) [P6T1]: spike: SQL->[select `content_editor_google`.`gce_campaign`.*,`content_editor_google`.`gce_campaignPendingChange`.*,`content_editor_google`.`gce_campaignTargetMap`.*,`content_editor_google`.`gce_campaignBudgetOptimizerSetting`.*,`content_editor_google`.`gce_target`.`code`,`content_editor_google`.`gce_target`.`targetType`,`content_editor_google`.`gce_target`.`criterionID`,`content_editor_google`.`gce_campaignProximityTargetMap`.`criterionID`,`content_editor_google`.`gce_campaignProximityTargetMap`.`latitudeInMicroDegrees`,`content_editor_google`.`gce_campaignProximityTargetMap`.`longitudeInMicroDegrees`,`content_editor_google`.`gce_campaignProximityTargetMap`.`radius`,`content_editor_google`.`gce_campaignProximityTargetMap`.`radiusUnits`,`content_editor_google`.`gce_campaign`.`id` AS `gce_campaign_campaignID` from `content_editor_google`.`gce_campaign` inner join `gce_campaignPendingChange` on ((`content_editor_google`.`gce_campaignPendingChange`.`campaignID`=`content_editor_google`.`gce_campaign`.`id`)) left join `gce_campaignTargetMap` on ((`content_editor_google`.`gce_campaignTargetMap`.`campaignID`=`content_editor_google`.`gce_campaign`.`id`)) left join `gce_target` on ((`content_editor_google`.`gce_campaignTargetMap`.`targetID`=`content_editor_google`.`gce_target`.`id`)) left join `gce_campaignBudgetOptimizerSetting` on ((`content_editor_google`.`gce_campaignBudgetOptimizerSetting`.`campaignID`=`content_editor_google`.`gce_campaign`.`id`)) left join `content_editor_google`.`gce_campaignProximityTargetMap` on (((((`content_editor_google`.`gce_campaignProximityTargetMap`.`campaignID`=`content_editor_google`.`gce_campaignTargetMap`.`campaignID`)) and ((`content_editor_google`.`gce_campaignProximityTargetMap`.`targetID`=`content_editor_google`.`gce_campaignTargetMap`.`targetID`))))) where ((`searchEngineUserID`=284) and (`gce_campaign`.`id` in (1630,1631,1632)) and (((((`isFailed`="true") and (`tryCount`<10))) or ((`isFailed`="false")))) and (`type`="delete"))]
2013-02-22 07:18:46.955 (4) [P6T1]: time=0.0030
2013-02-22 07:18:46.955 (4) [P6T1]: Query executed in 0.003s
2013-02-22 07:18:46.955 (4) [P6T1]: spike: SQL->[select `content_editor_google`.`gce_campaign`.`id`,`content_editor_google`.`gce_campaignPendingChange`.*,`content_editor_google`.`gce_campaignAdExtensionMap`.`adExtensionID`,`content_editor_google`.`gce_campaignAdExtensionMap`.`adExtensionType`,`content_editor_google`.`gce_campaignAdExtensionMap`.`searchEngineIdentifier` AS `adExtensionIdentifier`,`content_editor_google`.`gce_adSiteLink`.`id` AS `siteLinkID`,`content_editor_google`.`gce_adSiteLink`.`text`,`content_editor_google`.`gce_adSiteLink`.`destinationURL`,`content_editor_google`.`gce_campaign`.`id` AS `gce_campaign_campaignID` from `content_editor_google`.`gce_campaign` inner join `gce_campaignPendingChange` on ((`content_editor_google`.`gce_campaignPendingChange`.`campaignID`=`content_editor_google`.`gce_campaign`.`id`)) left join `gce_campaignAdExtensionMap` on ((`content_editor_google`.`gce_campaignAdExtensionMap`.`campaignID`=`content_editor_google`.`gce_campaign`.`id`)) left join `gce_adSiteLink` on ((`content_editor_google`.`gce_campaignAdExtensionMap`.`adExtensionID`=`content_editor_google`.`gce_adSiteLink`.`adExtensionID`)) where ((`searchEngineUserID`=284) and (`gce_campaign`.`id` in (1630,1631,1632)) and (((((`isFailed`="true") and (`tryCount`<10))) or ((`isFailed`="false")))) and (`type`="delete"))]
2013-02-22 07:18:46.957 (4) [P6T1]: time=0.0020
2013-02-22 07:18:46.958 (4) [P6T1]: Query executed in 0.002s
2013-02-22 07:18:46.958 (4) [P6T1]: CampaignChangeRequest (accountID 289): : No pending delete requests
2013-02-22 07:18:46.958 (4) [P6T1]: Returning Object to Pool
2013-02-22 07:18:46.958 (4) [P6T1]: DAO released connection to pool
2013-02-22 07:18:46.958 (4) [P6T1]: DataCache: Found key acct-content-google 289
2013-02-22 07:18:46.958 (4) [P6T1]: DataCache: Found key acct-content-google-1
2013-02-22 07:18:46.959 (4) [P6T1]: Took Existing Object from Pool
2013-02-22 07:18:46.959 (4) [P6T1]: spike: SQL->[select @@version]
2013-02-22 07:18:46.960 (4) [P6T1]: time=0.0010
2013-02-22 07:18:46.960 (4) [P6T1]: Query executed in 0.001s
2013-02-22 07:18:46.960 (4) [P6T1]: test query succeeded, returned "5.1.65-rel14.0"
2013-02-22 07:18:46.981 (2) [Finalizer]: CampaignTargetDAO calling close() in finalize: creator of DAO forgot to call close().
2013-02-22 07:18:46.981 (4) [Finalizer]: Returning Object to Pool
2013-02-22 07:18:46.981 (2) [Finalizer]: CampaignTargetDAO calling close() in finalize: creator of DAO forgot to call close().
2013-02-22 07:18:46.981 (4) [Finalizer]: Returning Object to Pool
2013-02-22 07:18:46.982 (4) [P6T1]: spike: SQL->[select `content_editor_google`.`gce_campaign`.*,`content_editor_google`.`gce_campaignTargetMapPendingChange`.*,`content_editor_google`.`gce_campaignTargetMap`.*,`content_editor_google`.`gce_campaignBudgetOptimizerSetting`.*,`content_editor_google`.`gce_target`.`code`,`content_editor_google`.`gce_target`.`targetType`,ifnull(`content_editor_google`.`gce_campaignProximityTargetMap`.`criterionID`, `content_editor_google`.`gce_target`.`criterionID`) AS `criterionID`,`content_editor_google`.`gce_campaignProximityTargetMap`.`latitudeInMicroDegrees`,`content_editor_google`.`gce_campaignProximityTargetMap`.`longitudeInMicroDegrees`,`content_editor_google`.`gce_campaignProximityTargetMap`.`radius`,`content_editor_google`.`gce_campaignProximityTargetMap`.`radiusUnits`,`content_editor_google`.`gce_campaign`.`id` AS `gce_campaign_campaignID` from `content_editor_google`.`gce_campaign` inner join `gce_campaignTargetMapPendingChange` on ((`content_editor_google`.`gce_campaignTargetMapPendingChange`.`campaignID`=`content_editor_google`.`gce_campaign`.`id`)) left join `gce_campaignTargetMap` on ((`content_editor_google`.`gce_campaignTargetMap`.`campaignID`=`content_editor_google`.`gce_campaign`.`id`)) left join `gce_target` on ((`content_editor_google`.`gce_campaignTargetMap`.`targetID`=`content_editor_google`.`gce_target`.`id`)) left join `gce_campaignBudgetOptimizerSetting` on ((`content_editor_google`.`gce_campaignBudgetOptimizerSetting`.`campaignID`=`content_editor_google`.`gce_campaign`.`id`)) left join `content_editor_google`.`gce_campaignProximityTargetMap` on (((((`content_editor_google`.`gce_campaignProximityTargetMap`.`campaignID`=`content_editor_google`.`gce_campaignTargetMap`.`campaignID`)) and ((`content_editor_google`.`gce_campaignProximityTargetMap`.`targetID`=`content_editor_google`.`gce_campaignTargetMap`.`targetID`))))) where ((`searchEngineUserID`=284) and (`gce_campaign`.`id` in (1630,1631,1632)) and (((((`isFailed`="true") and (`tryCount`<10))) or ((`isFailed`="false")))) and (`type`="add") and (`content_editor_google`.`gce_campaign`.`searchEngineIdentifier` is not null))]
2013-02-22 07:18:46.986 (4) [P6T1]: time=0.0040
2013-02-22 07:18:46.986 (4) [P6T1]: Query executed in 0.004s
2013-02-22 07:18:46.986 (4) [P6T1]: CampaignTargetChangeRequest (accountID 289): : No pending add requests
2013-02-22 07:18:46.987 (4) [P6T1]: spike: SQL->[select `content_editor_google`.`gce_campaign`.*,`content_editor_google`.`gce_campaignTargetMapPendingChange`.*,`content_editor_google`.`gce_campaignTargetMap`.*,`content_editor_google`.`gce_campaignBudgetOptimizerSetting`.*,`content_editor_google`.`gce_target`.`code`,`content_editor_google`.`gce_target`.`targetType`,ifnull(`content_editor_google`.`gce_campaignProximityTargetMap`.`criterionID`, `content_editor_google`.`gce_target`.`criterionID`) AS `criterionID`,`content_editor_google`.`gce_campaignProximityTargetMap`.`latitudeInMicroDegrees`,`content_editor_google`.`gce_campaignProximityTargetMap`.`longitudeInMicroDegrees`,`content_editor_google`.`gce_campaignProximityTargetMap`.`radius`,`content_editor_google`.`gce_campaignProximityTargetMap`.`radiusUnits`,`content_editor_google`.`gce_campaign`.`id` AS `gce_campaign_campaignID` from `content_editor_google`.`gce_campaign` inner join `gce_campaignTargetMapPendingChange` on ((`content_editor_google`.`gce_campaignTargetMapPendingChange`.`campaignID`=`content_editor_google`.`gce_campaign`.`id`)) left join `gce_campaignTargetMap` on ((`content_editor_google`.`gce_campaignTargetMap`.`campaignID`=`content_editor_google`.`gce_campaign`.`id`)) left join `gce_target` on ((`content_editor_google`.`gce_campaignTargetMap`.`targetID`=`content_editor_google`.`gce_target`.`id`)) left join `gce_campaignBudgetOptimizerSetting` on ((`content_editor_google`.`gce_campaignBudgetOptimizerSetting`.`campaignID`=`content_editor_google`.`gce_campaign`.`id`)) left join `content_editor_google`.`gce_campaignProximityTargetMap` on (((((`content_editor_google`.`gce_campaignProximityTargetMap`.`campaignID`=`content_editor_google`.`gce_campaignTargetMap`.`campaignID`)) and ((`content_editor_google`.`gce_campaignProximityTargetMap`.`targetID`=`content_editor_google`.`gce_campaignTargetMap`.`targetID`))))) where ((`searchEngineUserID`=284) and (`gce_campaign`.`id` in (1630,1631,1632)) and (((((`isFailed`="true") and (`tryCount`<10))) or ((`isFailed`="false")))) and (`type`="update"))]
2013-02-22 07:18:46.989 (4) [P6T1]: time=0.0020
2013-02-22 07:18:46.989 (4) [P6T1]: Query executed in 0.002s
2013-02-22 07:18:46.989 (4) [P6T1]: CampaignTargetChangeRequest (accountID 289): : No pending update requests
2013-02-22 07:18:46.990 (4) [P6T1]: spike: SQL->[select `content_editor_google`.`gce_campaign`.*,`content_editor_google`.`gce_campaignTargetMapPendingChange`.*,`content_editor_google`.`gce_campaignTargetMap`.*,`content_editor_google`.`gce_campaignBudgetOptimizerSetting`.*,`content_editor_google`.`gce_target`.`code`,`content_editor_google`.`gce_target`.`targetType`,ifnull(`content_editor_google`.`gce_campaignProximityTargetMap`.`criterionID`, `content_editor_google`.`gce_target`.`criterionID`) AS `criterionID`,`content_editor_google`.`gce_campaignProximityTargetMap`.`latitudeInMicroDegrees`,`content_editor_google`.`gce_campaignProximityTargetMap`.`longitudeInMicroDegrees`,`content_editor_google`.`gce_campaignProximityTargetMap`.`radius`,`content_editor_google`.`gce_campaignProximityTargetMap`.`radiusUnits`,`content_editor_google`.`gce_campaign`.`id` AS `gce_campaign_campaignID` from `content_editor_google`.`gce_campaign` inner join `gce_campaignTargetMapPendingChange` on ((`content_editor_google`.`gce_campaignTargetMapPendingChange`.`campaignID`=`content_editor_google`.`gce_campaign`.`id`)) left join `gce_campaignTargetMap` on ((`content_editor_google`.`gce_campaignTargetMap`.`campaignID`=`content_editor_google`.`gce_campaign`.`id`)) left join `gce_target` on ((`content_editor_google`.`gce_campaignTargetMap`.`targetID`=`content_editor_google`.`gce_target`.`id`)) left join `gce_campaignBudgetOptimizerSetting` on ((`content_editor_google`.`gce_campaignBudgetOptimizerSetting`.`campaignID`=`content_editor_google`.`gce_campaign`.`id`)) left join `content_editor_google`.`gce_campaignProximityTargetMap` on (((((`content_editor_google`.`gce_campaignProximityTargetMap`.`campaignID`=`content_editor_google`.`gce_campaignTargetMap`.`campaignID`)) and ((`content_editor_google`.`gce_campaignProximityTargetMap`.`targetID`=`content_editor_google`.`gce_campaignTargetMap`.`targetID`))))) where ((`searchEngineUserID`=284) and (`gce_campaign`.`id` in (1630,1631,1632)) and (((((`isFailed`="true") and (`tryCount`<10))) or ((`isFailed`="false")))) and (`type`="delete"))]
2013-02-22 07:18:46.991 (4) [P6T1]: time=0.0010
2013-02-22 07:18:46.992 (4) [P6T1]: Query executed in 0.001s
2013-02-22 07:18:46.992 (4) [P6T1]: CampaignTargetChangeRequest (accountID 289): : No pending delete requests
2013-02-22 07:18:46.992 (4) [P6T1]: Returning Object to Pool
2013-02-22 07:18:46.992 (4) [P6T1]: DAO released connection to pool
2013-02-22 07:18:46.992 (4) [P6T1]: DataCache: Found key acct-content-google 289
2013-02-22 07:18:46.992 (4) [P6T1]: DataCache: Found key acct-content-google-1
2013-02-22 07:18:46.992 (4) [P6T1]: Took Existing Object from Pool
2013-02-22 07:18:46.992 (4) [P6T1]: spike: SQL->[select @@version]
2013-02-22 07:18:46.996 (4) [P6T1]: time=0.0040
2013-02-22 07:18:46.996 (4) [P6T1]: Query executed in 0.004s
2013-02-22 07:18:46.996 (4) [P6T1]: test query succeeded, returned "5.1.65-rel14.0"
2013-02-22 07:18:46.996 (4) [P6T1]: spike: SQL->[select `content_editor_google`.`gce_campaign`.*,`content_editor_google`.`gce_campaignBudgetOptimizerSetting`.*,`content_editor_google`.`gce_campaignAdExtensionMapPendingChange`.*,`content_editor_google`.`gce_campaignAdExtensionMap`.`adExtensionID`,`content_editor_google`.`gce_campaignAdExtensionMap`.`adExtensionType`,`content_editor_google`.`gce_campaignAdExtensionMap`.`searchEngineIdentifier` AS `adExtensionIdentifier`,`content_editor_google`.`gce_adSiteLink`.`id` AS `siteLinkID`,`content_editor_google`.`gce_adSiteLink`.`text`,`content_editor_google`.`gce_adSiteLink`.`destinationURL`,`content_editor_google`.`gce_campaign`.`id` AS `gce_campaign_campaignID` from `content_editor_google`.`gce_campaign` inner join `gce_campaignAdExtensionMapPendingChange` on ((`content_editor_google`.`gce_campaignAdExtensionMapPendingChange`.`campaignID`=`content_editor_google`.`gce_campaign`.`id`)) left join `gce_campaignAdExtensionMap` on ((`content_editor_google`.`gce_campaignAdExtensionMap`.`campaignID`=`content_editor_google`.`gce_campaign`.`id`)) left join `gce_adSiteLink` on ((`content_editor_google`.`gce_campaignAdExtensionMap`.`adExtensionID`=`content_editor_google`.`gce_adSiteLink`.`adExtensionID`)) left join `gce_campaignBudgetOptimizerSetting` on ((`content_editor_google`.`gce_campaignBudgetOptimizerSetting`.`campaignID`=`content_editor_google`.`gce_campaign`.`id`)) where ((`searchEngineUserID`=284) and (`gce_campaign`.`id` in (1630,1631,1632)) and (((((`isFailed`="true") and (`tryCount`<10))) or ((`isFailed`="false")))) and (`type`="add"))]
2013-02-22 07:18:46.998 (4) [P6T1]: time=0.0020
2013-02-22 07:18:46.998 (4) [P6T1]: Query executed in 0.002s
2013-02-22 07:18:46.998 (4) [P6T1]: CampaignSiteLinkChangeRequest (accountID 289): : No pending add requests
2013-02-22 07:18:46.999 (4) [P6T1]: spike: SQL->[select `content_editor_google`.`gce_campaign`.*,`content_editor_google`.`gce_campaignBudgetOptimizerSetting`.*,`content_editor_google`.`gce_campaignAdExtensionMapPendingChange`.*,`content_editor_google`.`gce_campaignAdExtensionMap`.`adExtensionID`,`content_editor_google`.`gce_campaignAdExtensionMap`.`adExtensionType`,`content_editor_google`.`gce_campaignAdExtensionMap`.`searchEngineIdentifier` AS `adExtensionIdentifier`,`content_editor_google`.`gce_adSiteLink`.`id` AS `siteLinkID`,`content_editor_google`.`gce_adSiteLink`.`text`,`content_editor_google`.`gce_adSiteLink`.`destinationURL`,`content_editor_google`.`gce_campaign`.`id` AS `gce_campaign_campaignID` from `content_editor_google`.`gce_campaign` inner join `gce_campaignAdExtensionMapPendingChange` on ((`content_editor_google`.`gce_campaignAdExtensionMapPendingChange`.`campaignID`=`content_editor_google`.`gce_campaign`.`id`)) left join `gce_campaignAdExtensionMap` on ((`content_editor_google`.`gce_campaignAdExtensionMap`.`campaignID`=`content_editor_google`.`gce_campaign`.`id`)) left join `gce_adSiteLink` on ((`content_editor_google`.`gce_campaignAdExtensionMap`.`adExtensionID`=`content_editor_google`.`gce_adSiteLink`.`adExtensionID`)) left join `gce_campaignBudgetOptimizerSetting` on ((`content_editor_google`.`gce_campaignBudgetOptimizerSetting`.`campaignID`=`content_editor_google`.`gce_campaign`.`id`)) where ((`searchEngineUserID`=284) and (`gce_campaign`.`id` in (1630,1631,1632)) and (((((`isFailed`="true") and (`tryCount`<10))) or ((`isFailed`="false")))) and (`type`="update"))]
2013-02-22 07:18:47.000 (4) [P6T1]: time=0.0010
2013-02-22 07:18:47.000 (4) [P6T1]: Query executed in 0.001s
2013-02-22 07:18:47.000 (4) [P6T1]: CampaignSiteLinkChangeRequest (accountID 289): : No pending update requests
2013-02-22 07:18:47.001 (4) [P6T1]: spike: SQL->[select `content_editor_google`.`gce_campaign`.*,`content_editor_google`.`gce_campaignBudgetOptimizerSetting`.*,`content_editor_google`.`gce_campaignAdExtensionMapPendingChange`.*,`content_editor_google`.`gce_campaignAdExtensionMap`.`adExtensionID`,`content_editor_google`.`gce_campaignAdExtensionMap`.`adExtensionType`,`content_editor_google`.`gce_campaignAdExtensionMap`.`searchEngineIdentifier` AS `adExtensionIdentifier`,`content_editor_google`.`gce_adSiteLink`.`id` AS `siteLinkID`,`content_editor_google`.`gce_adSiteLink`.`text`,`content_editor_google`.`gce_adSiteLink`.`destinationURL`,`content_editor_google`.`gce_campaign`.`id` AS `gce_campaign_campaignID` from `content_editor_google`.`gce_campaign` inner join `gce_campaignAdExtensionMapPendingChange` on ((`content_editor_google`.`gce_campaignAdExtensionMapPendingChange`.`campaignID`=`content_editor_google`.`gce_campaign`.`id`)) left join `gce_campaignAdExtensionMap` on ((`content_editor_google`.`gce_campaignAdExtensionMap`.`campaignID`=`content_editor_google`.`gce_campaign`.`id`)) left join `gce_adSiteLink` on ((`content_editor_google`.`gce_campaignAdExtensionMap`.`adExtensionID`=`content_editor_google`.`gce_adSiteLink`.`adExtensionID`)) left join `gce_campaignBudgetOptimizerSetting` on ((`content_editor_google`.`gce_campaignBudgetOptimizerSetting`.`campaignID`=`content_editor_google`.`gce_campaign`.`id`)) where ((`searchEngineUserID`=284) and (`gce_campaign`.`id` in (1630,1631,1632)) and (((((`isFailed`="true") and (`tryCount`<10))) or ((`isFailed`="false")))) and (`type`="delete"))]
2013-02-22 07:18:47.003 (4) [P6T1]: time=0.0020
2013-02-22 07:18:47.003 (4) [P6T1]: Query executed in 0.002s
2013-02-22 07:18:47.003 (4) [P6T1]: CampaignSiteLinkChangeRequest (accountID 289): : No pending delete requests
2013-02-22 07:18:47.003 (4) [P6T1]: Returning Object to Pool
2013-02-22 07:18:47.003 (4) [P6T1]: DAO released connection to pool
2013-02-22 07:18:47.003 (4) [P6T1]: DataCache: Found key acct-content-google 289
2013-02-22 07:18:47.003 (4) [P6T1]: DataCache: Found key acct-content-google-1
2013-02-22 07:18:47.003 (4) [P6T1]: Took Existing Object from Pool
2013-02-22 07:18:47.003 (4) [P6T1]: spike: SQL->[select @@version]
2013-02-22 07:18:47.004 (4) [P6T1]: time=0.0010
2013-02-22 07:18:47.005 (4) [P6T1]: Query executed in 0.001s
2013-02-22 07:18:47.005 (4) [P6T1]: test query succeeded, returned "5.1.65-rel14.0"
2013-02-22 07:18:47.005 (4) [P6T1]: spike: SQL->[select `content_editor_google`.`gce_adGroup`.*,`content_editor_google`.`gce_adGroupPendingChange`.*,`content_editor_google`.`gce_campaign`.`searchEngineIdentifier` AS `campaignsearchEngineIdentifier`,`content_editor_google`.`gce_campaignBudgetOptimizerSetting`.`enabled` AS `bosenabled` from `content_editor_google`.`gce_adGroup` join `gce_campaign` on ((`content_editor_google`.`gce_campaign`.`id`=`content_editor_google`.`gce_adGroup`.`campaignID`)) join `gce_adGroupPendingChange` on ((`content_editor_google`.`gce_adGroupPendingChange`.`adGroupID`=`content_editor_google`.`gce_adGroup`.`id`)) left join `gce_campaignBudgetOptimizerSetting` on ((`content_editor_google`.`gce_campaign`.`id`=`content_editor_google`.`gce_campaignBudgetOptimizerSetting`.`campaignID`)) where ((`searchEngineUserID`=284) and (`gce_campaign`.`id` in (1630,1631,1632)) and (((((`isFailed`="true") and (`tryCount`<10))) or ((`isFailed`="false")))) and (`type`="add") and (`content_editor_google`.`gce_campaign`.`searchEngineIdentifier` is not null)) order by `campaignID` asc]
2013-02-22 07:18:47.027 (4) [P6T1]: time=0.022
2013-02-22 07:18:47.027 (4) [P6T1]: Query executed in 0.022s
2013-02-22 07:18:47.027 (4) [P6T1]: AdGroupChangeRequest (accountID 289): : No pending add requests
2013-02-22 07:18:47.028 (4) [P6T1]: spike: SQL->[select `content_editor_google`.`gce_adGroup`.*,`content_editor_google`.`gce_adGroupPendingChange`.*,`content_editor_google`.`gce_campaign`.`searchEngineIdentifier` AS `campaignsearchEngineIdentifier`,`content_editor_google`.`gce_campaignBudgetOptimizerSetting`.`enabled` AS `bosenabled`,`gce_adGroupPendingUpdate`.`name` AS `nameChange`,`gce_adGroupPendingUpdate`.`status` AS `statusChange` from `content_editor_google`.`gce_adGroup` join `gce_campaign` on ((`content_editor_google`.`gce_campaign`.`id`=`content_editor_google`.`gce_adGroup`.`campaignID`)) join `gce_adGroupPendingChange` on ((`content_editor_google`.`gce_adGroupPendingChange`.`adGroupID`=`content_editor_google`.`gce_adGroup`.`id`)) left join `gce_campaignBudgetOptimizerSetting` on ((`content_editor_google`.`gce_campaign`.`id`=`content_editor_google`.`gce_campaignBudgetOptimizerSetting`.`campaignID`)) inner join `gce_adGroupPendingUpdate` on ((`gce_adGroupPendingUpdate`.`adGroupID`=`gce_adGroup`.`id`)) where ((`searchEngineUserID`=284) and (`gce_campaign`.`id` in (1630,1631,1632)) and (((((`isFailed`="true") and (`tryCount`<10))) or ((`isFailed`="false")))) and (`type`="update")) order by `campaignID` asc]
2013-02-22 07:18:47.030 (4) [P6T1]: time=0.0020
2013-02-22 07:18:47.030 (4) [P6T1]: Query executed in 0.002s
2013-02-22 07:18:47.030 (4) [P6T1]: AdGroupChangeRequest (accountID 289): : No pending update requests
2013-02-22 07:18:47.030 (4) [P6T1]: spike: SQL->[select `content_editor_google`.`gce_adGroup`.*,`content_editor_google`.`gce_adGroupPendingChange`.*,`content_editor_google`.`gce_campaign`.`searchEngineIdentifier` AS `campaignsearchEngineIdentifier`,`content_editor_google`.`gce_campaignBudgetOptimizerSetting`.`enabled` AS `bosenabled` from `content_editor_google`.`gce_adGroup` join `gce_campaign` on ((`content_editor_google`.`gce_campaign`.`id`=`content_editor_google`.`gce_adGroup`.`campaignID`)) join `gce_adGroupPendingChange` on ((`content_editor_google`.`gce_adGroupPendingChange`.`adGroupID`=`content_editor_google`.`gce_adGroup`.`id`)) left join `gce_campaignBudgetOptimizerSetting` on ((`content_editor_google`.`gce_campaign`.`id`=`content_editor_google`.`gce_campaignBudgetOptimizerSetting`.`campaignID`)) where ((`searchEngineUserID`=284) and (`gce_campaign`.`id` in (1630,1631,1632)) and (((((`isFailed`="true") and (`tryCount`<10))) or ((`isFailed`="false")))) and (`type`="delete")) order by `campaignID` asc]
2013-02-22 07:18:47.032 (4) [P6T1]: time=0.0020
2013-02-22 07:18:47.032 (4) [P6T1]: Query executed in 0.002s
2013-02-22 07:18:47.032 (4) [P6T1]: AdGroupChangeRequest (accountID 289): : No pending delete requests
2013-02-22 07:18:47.032 (4) [P6T1]: Returning Object to Pool
2013-02-22 07:18:47.032 (4) [P6T1]: DAO released connection to pool
2013-02-22 07:18:47.032 (4) [P6T1]: DataCache: Found key acct-content-google 289
2013-02-22 07:18:47.032 (4) [P6T1]: DataCache: Found key acct-content-google-1
2013-02-22 07:18:47.032 (4) [P6T1]: Took Existing Object from Pool
2013-02-22 07:18:47.032 (4) [P6T1]: spike: SQL->[select @@version]
2013-02-22 07:18:47.033 (4) [P6T1]: time=0.0010
2013-02-22 07:18:47.033 (4) [P6T1]: Query executed in 0.001s
2013-02-22 07:18:47.033 (4) [P6T1]: test query succeeded, returned "5.1.65-rel14.0"
2013-02-22 07:18:47.034 (4) [P6T1]: spike: SQL->[select `content_editor_google`.`gce_textAd`.*,`content_editor_google`.`gce_textAdPendingChange`.*,`content_editor_google`.`gce_adGroup`.`searchEngineIdentifier` AS `adgroupsearchEngineIdentifier` from `gce_campaign` join `gce_adGroup` on ((`content_editor_google`.`gce_campaign`.`id`=`content_editor_google`.`gce_adGroup`.`campaignID`)) join `gce_textAd` on ((`content_editor_google`.`gce_adGroup`.`id`=`content_editor_google`.`gce_textAd`.`adGroupID`)) join `gce_textAdPendingChange` on ((`content_editor_google`.`gce_textAdPendingChange`.`textAdID`=`content_editor_google`.`gce_textAd`.`id`)) where ((`content_editor_google`.`gce_adGroup`.`status`!="Deleted") and (`searchEngineUserID`=284) and (`gce_campaign`.`id` in (1630,1631,1632)) and (((((`isFailed`="true") and (`tryCount`<10))) or ((`isFailed`="false")))) and (`type`="delete")) order by `adGroupID` asc]
2013-02-22 07:18:47.036 (4) [P6T1]: time=0.0010
2013-02-22 07:18:47.036 (4) [P6T1]: Query executed in 0.001s
2013-02-22 07:18:47.036 (4) [P6T1]: spike: SQL->[select `content_editor_google`.`gce_textAd`.*,`content_editor_google`.`gce_textAdPendingChange`.*,`content_editor_google`.`gce_adGroup`.`searchEngineIdentifier` AS `adgroupsearchEngineIdentifier` from `gce_campaign` join `gce_adGroup` on ((`content_editor_google`.`gce_campaign`.`id`=`content_editor_google`.`gce_adGroup`.`campaignID`)) join `gce_textAd` on ((`content_editor_google`.`gce_adGroup`.`id`=`content_editor_google`.`gce_textAd`.`adGroupID`)) join `gce_textAdPendingChange` on ((`content_editor_google`.`gce_textAdPendingChange`.`textAdID`=`content_editor_google`.`gce_textAd`.`id`)) where ((`content_editor_google`.`gce_adGroup`.`status`!="Deleted") and (`searchEngineUserID`=284) and (`gce_campaign`.`id` in (1630,1631,1632)) and (((((`isFailed`="true") and (`tryCount`<10))) or ((`isFailed`="false")))) and (`type`="add") and (`content_editor_google`.`gce_adGroup`.`searchEngineIdentifier` is not null)) order by `adGroupID` asc]
2013-02-22 07:18:47.038 (4) [P6T1]: time=0.0020
2013-02-22 07:18:47.038 (4) [P6T1]: Query executed in 0.002s
2013-02-22 07:18:47.038 (4) [P6T1]: spike: SQL->[select `content_editor_google`.`gce_textAd`.*,`content_editor_google`.`gce_textAdPendingChange`.*,`content_editor_google`.`gce_adGroup`.`searchEngineIdentifier` AS `adgroupsearchEngineIdentifier`,`gce_textAdPendingUpdate`.`headline` AS `headlineChange`,`gce_textAdPendingUpdate`.`description1` AS `description1Change`,`gce_textAdPendingUpdate`.`description2` AS `description2Change`,`gce_textAdPendingUpdate`.`displayURL` AS `displayURLChange`,`gce_textAdPendingUpdate`.`destinationURL` AS `destinationURLChange`,`gce_textAdPendingUpdate`.`exemptionRequest` AS `exemptionRequestChange`,`gce_textAdPendingUpdate`.`status` AS `statusChange` from `gce_campaign` join `gce_adGroup` on ((`content_editor_google`.`gce_campaign`.`id`=`content_editor_google`.`gce_adGroup`.`campaignID`)) join `gce_textAd` on ((`content_editor_google`.`gce_adGroup`.`id`=`content_editor_google`.`gce_textAd`.`adGroupID`)) join `gce_textAdPendingChange` on ((`content_editor_google`.`gce_textAdPendingChange`.`textAdID`=`content_editor_google`.`gce_textAd`.`id`)) inner join `gce_textAdPendingUpdate` on ((`gce_textAdPendingUpdate`.`textAdID`=`gce_textAd`.`id`)) where ((`content_editor_google`.`gce_adGroup`.`status`!="Deleted") and (`searchEngineUserID`=284) and (`gce_campaign`.`id` in (1630,1631,1632)) and (((((`isFailed`="true") and (`tryCount`<10))) or ((`isFailed`="false")))) and (`type`="update")) order by `adGroupID` asc]
2013-02-22 07:18:47.040 (4) [P6T1]: time=0.0020
2013-02-22 07:18:47.040 (4) [P6T1]: Query executed in 0.002s
2013-02-22 07:18:47.040 (4) [P6T1]: Shutting down
2013-02-22 07:18:47.040 (4) [P6T1]: Done shutting down
2013-02-22 07:18:47.040 (4) [P6T1]: Returning Object to Pool
2013-02-22 07:18:47.040 (4) [P6T1]: DataCache: Found key acct-content-google 289
2013-02-22 07:18:47.040 (4) [P6T1]: DataCache: Found key acct-content-google-1
2013-02-22 07:18:47.040 (4) [P6T1]: Took Existing Object from Pool
2013-02-22 07:18:47.040 (4) [P6T1]: spike: SQL->[select @@version]
2013-02-22 07:18:47.043 (4) [P6T1]: time=0.0030
2013-02-22 07:18:47.043 (4) [P6T1]: Query executed in 0.003s
2013-02-22 07:18:47.043 (4) [P6T1]: test query succeeded, returned "5.1.65-rel14.0"
2013-02-22 07:18:47.043 (4) [P6T1]: preparing SQL statement [select gce_keyword.id from gce_keyword join gce_keywordPendingChange ON (gce_keywordPendingChange.keywordID=gce_keyword.id)join gce_adGroup on (gce_adGroup.id=gce_keyword.adGroupID) where campaignID = ? and gce_keyword.isNegative = 'true' and gce_keywordPendingChange.type = 'update' ]
2013-02-22 07:18:47.045 (4) [P6T1]: preparing SQL statement [select gce_keyword.id from gce_keyword join gce_keywordPendingChange ON (gce_keywordPendingChange.keywordID=gce_keyword.id)join gce_adGroup on (gce_adGroup.id=gce_keyword.adGroupID) where campaignID = ? and gce_keyword.isNegative = 'true' and gce_keywordPendingChange.type = 'update' ]
2013-02-22 07:18:47.048 (4) [P6T1]: preparing SQL statement [select gce_keyword.id from gce_keyword join gce_keywordPendingChange ON (gce_keywordPendingChange.keywordID=gce_keyword.id)join gce_adGroup on (gce_adGroup.id=gce_keyword.adGroupID) where campaignID = ? and gce_keyword.isNegative = 'true' and gce_keywordPendingChange.type = 'update' ]
2013-02-22 07:18:47.050 (4) [P6T1]: spike: SQL->[select `content_editor_google`.`gce_keyword`.*,`content_editor_google`.`gce_keywordPendingChange`.*,`content_editor_google`.`gce_adGroup`.`searchEngineIdentifier` AS `adgroupsearchEngineIdentifier`,`content_editor_google`.`gce_campaignBudgetOptimizerSetting`.`enabled` AS `bosenabled` from `gce_campaign` join `gce_adGroup` on ((`content_editor_google`.`gce_campaign`.`id`=`content_editor_google`.`gce_adGroup`.`campaignID`)) join `gce_keyword` on ((`content_editor_google`.`gce_adGroup`.`id`=`content_editor_google`.`gce_keyword`.`adGroupID`)) join `gce_keywordPendingChange` on ((`content_editor_google`.`gce_keywordPendingChange`.`keywordID`=`content_editor_google`.`gce_keyword`.`id`)) left join `gce_campaignBudgetOptimizerSetting` on ((`content_editor_google`.`gce_campaign`.`id`=`content_editor_google`.`gce_campaignBudgetOptimizerSetting`.`campaignID`)) where ((`searchEngineUserID`=284) and (`gce_campaign`.`id` in (1630,1631,1632)) and (((((`isFailed`="true") and (`tryCount`<10))) or ((`isFailed`="false")))) and (`type`="delete")) order by `adGroupID` asc]
2013-02-22 07:18:47.058 (4) [P6T1]: time=0.0080
2013-02-22 07:18:47.058 (4) [P6T1]: Query executed in 0.008s
2013-02-22 07:18:47.058 (4) [P6T1]: preparing SQL statement [select gce_keyword.id from gce_keyword join gce_keywordPendingChange ON (gce_keywordPendingChange.keywordID=gce_keyword.id)join gce_adGroup on (gce_adGroup.id=gce_keyword.adGroupID) where campaignID = ? and gce_keyword.isNegative = 'true' and gce_keywordPendingChange.type = 'update' ]
2013-02-22 07:18:47.063 (4) [P6T1]: preparing SQL statement [select gce_keyword.id from gce_keyword join gce_keywordPendingChange ON (gce_keywordPendingChange.keywordID=gce_keyword.id)join gce_adGroup on (gce_adGroup.id=gce_keyword.adGroupID) where campaignID = ? and gce_keyword.isNegative = 'true' and gce_keywordPendingChange.type = 'update' ]
2013-02-22 07:18:47.064 (4) [P6T1]: preparing SQL statement [select gce_keyword.id from gce_keyword join gce_keywordPendingChange ON (gce_keywordPendingChange.keywordID=gce_keyword.id)join gce_adGroup on (gce_adGroup.id=gce_keyword.adGroupID) where campaignID = ? and gce_keyword.isNegative = 'true' and gce_keywordPendingChange.type = 'update' ]
2013-02-22 07:18:47.065 (4) [P6T1]: spike: SQL->[select `content_editor_google`.`gce_keyword`.*,`content_editor_google`.`gce_keywordPendingChange`.*,`content_editor_google`.`gce_adGroup`.`searchEngineIdentifier` AS `adgroupsearchEngineIdentifier`,`content_editor_google`.`gce_campaignBudgetOptimizerSetting`.`enabled` AS `bosenabled` from `gce_campaign` join `gce_adGroup` on ((`content_editor_google`.`gce_campaign`.`id`=`content_editor_google`.`gce_adGroup`.`campaignID`)) join `gce_keyword` on ((`content_editor_google`.`gce_adGroup`.`id`=`content_editor_google`.`gce_keyword`.`adGroupID`)) join `gce_keywordPendingChange` on ((`content_editor_google`.`gce_keywordPendingChange`.`keywordID`=`content_editor_google`.`gce_keyword`.`id`)) left join `gce_campaignBudgetOptimizerSetting` on ((`content_editor_google`.`gce_campaign`.`id`=`content_editor_google`.`gce_campaignBudgetOptimizerSetting`.`campaignID`)) where ((`searchEngineUserID`=284) and (`gce_campaign`.`id` in (1630,1631,1632)) and (((((`isFailed`="true") and (`tryCount`<10))) or ((`isFailed`="false")))) and (`type`="add") and (`content_editor_google`.`gce_adGroup`.`searchEngineIdentifier` is not null)) order by `adGroupID` asc]
2013-02-22 07:18:47.073 (4) [P6T1]: time=0.0080
2013-02-22 07:18:47.073 (4) [P6T1]: Query executed in 0.008s
2013-02-22 07:18:47.073 (4) [P6T1]: preparing SQL statement [select gce_keyword.id from gce_keyword join gce_keywordPendingChange ON (gce_keywordPendingChange.keywordID=gce_keyword.id)join gce_adGroup on (gce_adGroup.id=gce_keyword.adGroupID) where campaignID = ? and gce_keyword.isNegative = 'true' and gce_keywordPendingChange.type = 'update' ]
2013-02-22 07:18:47.075 (4) [P6T1]: preparing SQL statement [select gce_keyword.id from gce_keyword join gce_keywordPendingChange ON (gce_keywordPendingChange.keywordID=gce_keyword.id)join gce_adGroup on (gce_adGroup.id=gce_keyword.adGroupID) where campaignID = ? and gce_keyword.isNegative = 'true' and gce_keywordPendingChange.type = 'update' ]
2013-02-22 07:18:47.076 (4) [P6T1]: preparing SQL statement [select gce_keyword.id from gce_keyword join gce_keywordPendingChange ON (gce_keywordPendingChange.keywordID=gce_keyword.id)join gce_adGroup on (gce_adGroup.id=gce_keyword.adGroupID) where campaignID = ? and gce_keyword.isNegative = 'true' and gce_keywordPendingChange.type = 'update' ]
2013-02-22 07:18:47.078 (4) [P6T1]: spike: SQL->[select `content_editor_google`.`gce_keyword`.*,`content_editor_google`.`gce_keywordPendingChange`.*,`content_editor_google`.`gce_adGroup`.`searchEngineIdentifier` AS `adgroupsearchEngineIdentifier`,`content_editor_google`.`gce_campaignBudgetOptimizerSetting`.`enabled` AS `bosenabled`,`gce_keywordPendingUpdate`.`destinationURL` AS `destinationURLChange`,`gce_keywordPendingUpdate`.`isNegative` AS `isNegativeChange`,`gce_keywordPendingUpdate`.`isPaused` AS `isPausedChange`,`gce_keywordPendingUpdate`.`status` AS `statusChange` from `gce_campaign` join `gce_adGroup` on ((`content_editor_google`.`gce_campaign`.`id`=`content_editor_google`.`gce_adGroup`.`campaignID`)) join `gce_keyword` on ((`content_editor_google`.`gce_adGroup`.`id`=`content_editor_google`.`gce_keyword`.`adGroupID`)) join `gce_keywordPendingChange` on ((`content_editor_google`.`gce_keywordPendingChange`.`keywordID`=`content_editor_google`.`gce_keyword`.`id`)) left join `gce_campaignBudgetOptimizerSetting` on ((`content_editor_google`.`gce_campaign`.`id`=`content_editor_google`.`gce_campaignBudgetOptimizerSetting`.`campaignID`)) inner join `gce_keywordPendingUpdate` on ((`gce_keywordPendingUpdate`.`keywordID`=`gce_keyword`.`id`)) where ((`searchEngineUserID`=284) and (`gce_campaign`.`id` in (1630,1631,1632)) and (((((`isFailed`="true") and (`tryCount`<10))) or ((`isFailed`="false")))) and (`type`="update")) order by `adGroupID` asc]
2013-02-22 07:18:47.080 (4) [P6T1]: time=0.0010
2013-02-22 07:18:47.080 (4) [P6T1]: Query executed in 0.001s
2013-02-22 07:18:47.080 (4) [P6T1]: Shutting down
2013-02-22 07:18:47.080 (4) [P6T1]: Done shutting down
2013-02-22 07:18:47.080 (4) [P6T1]: Returning Object to Pool
2013-02-22 07:18:47.080 (4) [P6T1]: DataCache: Found key acct-content-google 289
2013-02-22 07:18:47.080 (4) [P6T1]: DataCache: Found key acct-content-google-1
2013-02-22 07:18:47.080 (4) [P6T1]: Took Existing Object from Pool
2013-02-22 07:18:47.080 (4) [P6T1]: spike: SQL->[select @@version]
2013-02-22 07:18:47.081 (4) [P6T1]: time=0.0010
2013-02-22 07:18:47.081 (4) [P6T1]: Query executed in 0.001s
2013-02-22 07:18:47.081 (4) [P6T1]: test query succeeded, returned "5.1.65-rel14.0"
2013-02-22 07:18:47.082 (4) [P6T1]: spike: SQL->[select `content_editor_google`.`gce_placement`.*,`content_editor_google`.`gce_placementPendingChange`.*,`content_editor_google`.`gce_adGroup`.`searchEngineIdentifier` AS `adgroupsearchEngineIdentifier`,`content_editor_google`.`gce_campaignBudgetOptimizerSetting`.`enabled` AS `bosenabled` from `gce_campaign` join `gce_adGroup` on ((`content_editor_google`.`gce_campaign`.`id`=`content_editor_google`.`gce_adGroup`.`campaignID`)) join `gce_placement` on ((`content_editor_google`.`gce_adGroup`.`id`=`content_editor_google`.`gce_placement`.`adGroupID`)) join `gce_placementPendingChange` on ((`content_editor_google`.`gce_placementPendingChange`.`placementID`=`content_editor_google`.`gce_placement`.`id`)) left join `gce_campaignBudgetOptimizerSetting` on ((`content_editor_google`.`gce_campaign`.`id`=`content_editor_google`.`gce_campaignBudgetOptimizerSetting`.`campaignID`)) where ((`searchEngineUserID`=284) and (`gce_campaign`.`id` in (1630,1631,1632)) and (((((`isFailed`="true") and (`tryCount`<10))) or ((`isFailed`="false")))) and (`type`="delete")) order by `adGroupID` asc]
2013-02-22 07:18:47.083 (4) [P6T1]: time=0.0010
2013-02-22 07:18:47.083 (4) [P6T1]: Query executed in 0.001s
2013-02-22 07:18:47.083 (3) [P6T1]: Skipping null/empty batch of deletes
2013-02-22 07:18:47.084 (4) [P6T1]: spike: SQL->[select `content_editor_google`.`gce_placement`.*,`content_editor_google`.`gce_placementPendingChange`.*,`content_editor_google`.`gce_adGroup`.`searchEngineIdentifier` AS `adgroupsearchEngineIdentifier`,`content_editor_google`.`gce_campaignBudgetOptimizerSetting`.`enabled` AS `bosenabled` from `gce_campaign` join `gce_adGroup` on ((`content_editor_google`.`gce_campaign`.`id`=`content_editor_google`.`gce_adGroup`.`campaignID`)) join `gce_placement` on ((`content_editor_google`.`gce_adGroup`.`id`=`content_editor_google`.`gce_placement`.`adGroupID`)) join `gce_placementPendingChange` on ((`content_editor_google`.`gce_placementPendingChange`.`placementID`=`content_editor_google`.`gce_placement`.`id`)) left join `gce_campaignBudgetOptimizerSetting` on ((`content_editor_google`.`gce_campaign`.`id`=`content_editor_google`.`gce_campaignBudgetOptimizerSetting`.`campaignID`)) where ((`searchEngineUserID`=284) and (`gce_campaign`.`id` in (1630,1631,1632)) and (((((`isFailed`="true") and (`tryCount`<10))) or ((`isFailed`="false")))) and (`type`="add") and (`content_editor_google`.`gce_adGroup`.`searchEngineIdentifier` is not null)) order by `adGroupID` asc]
2013-02-22 07:18:47.085 (4) [P6T1]: time=0.0010
2013-02-22 07:18:47.085 (4) [P6T1]: Query executed in 0.001s
2013-02-22 07:18:47.085 (3) [P6T1]: Skipping null/empty batch of adds
2013-02-22 07:18:47.086 (4) [P6T1]: spike: SQL->[select `content_editor_google`.`gce_placement`.*,`content_editor_google`.`gce_placementPendingChange`.*,`content_editor_google`.`gce_adGroup`.`searchEngineIdentifier` AS `adgroupsearchEngineIdentifier`,`content_editor_google`.`gce_campaignBudgetOptimizerSetting`.`enabled` AS `bosenabled`,`gce_placementPendingUpdate`.`destinationURL` AS `destinationURLChange`,`gce_placementPendingUpdate`.`isNegative` AS `isNegativeChange`,`gce_placementPendingUpdate`.`isPaused` AS `isPausedChange`,`gce_placementPendingUpdate`.`status` AS `statusChange` from `gce_campaign` join `gce_adGroup` on ((`content_editor_google`.`gce_campaign`.`id`=`content_editor_google`.`gce_adGroup`.`campaignID`)) join `gce_placement` on ((`content_editor_google`.`gce_adGroup`.`id`=`content_editor_google`.`gce_placement`.`adGroupID`)) join `gce_placementPendingChange` on ((`content_editor_google`.`gce_placementPendingChange`.`placementID`=`content_editor_google`.`gce_placement`.`id`)) left join `gce_campaignBudgetOptimizerSetting` on ((`content_editor_google`.`gce_campaign`.`id`=`content_editor_google`.`gce_campaignBudgetOptimizerSetting`.`campaignID`)) inner join `gce_placementPendingUpdate` on ((`gce_placementPendingUpdate`.`placementID`=`gce_placement`.`id`)) where ((`searchEngineUserID`=284) and (`gce_campaign`.`id` in (1630,1631,1632)) and (((((`isFailed`="true") and (`tryCount`<10))) or ((`isFailed`="false")))) and (`type`="update")) order by `adGroupID` asc]
2013-02-22 07:18:47.091 (4) [P6T1]: time=0.0050
2013-02-22 07:18:47.091 (4) [P6T1]: Query executed in 0.005s
2013-02-22 07:18:47.091 (3) [P6T1]: Skipping null/empty batch of updates
2013-02-22 07:18:47.091 (4) [P6T1]: Shutting down
2013-02-22 07:18:47.091 (4) [P6T1]: Done shutting down
2013-02-22 07:18:47.091 (4) [P6T1]: Returning Object to Pool
2013-02-22 07:18:47.091 (3) [P6T1]: ... SEUser 284 finished
2013-02-22 07:18:47.091 (4) [pool-3-thread-4]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2013-02-22 07:18:47.091 (3) [pool-3-thread-4]: ------------Google Content Editor done
2013-02-22 07:18:47.091 (4) [pool-3-thread-4]: DataCache: Found key acct-content-google 289
2013-02-22 07:18:47.092 (4) [pool-3-thread-4]: DataCache: Found key acct-content-google-1
2013-02-22 07:18:47.092 (4) [pool-3-thread-4]: Took Existing Object from Pool
2013-02-22 07:18:47.092 (4) [pool-3-thread-4]: spike: SQL->[select @@version]
2013-02-22 07:18:47.093 (4) [pool-3-thread-4]: time=0.0010
2013-02-22 07:18:47.093 (4) [pool-3-thread-4]: Query executed in 0.001s
2013-02-22 07:18:47.094 (4) [pool-3-thread-4]: test query succeeded, returned "5.1.65-rel14.0"
2013-02-22 07:18:47.094 (4) [pool-3-thread-4]: spike: SQL->[select `content_editor_google`.`gce_campaign`.*,`content_editor_google`.`gce_campaignPendingChange`.*,`content_editor_google`.`gce_campaignTargetMap`.*,`content_editor_google`.`gce_campaignBudgetOptimizerSetting`.*,`content_editor_google`.`gce_target`.`code`,`content_editor_google`.`gce_target`.`targetType`,`content_editor_google`.`gce_target`.`criterionID`,`content_editor_google`.`gce_campaignProximityTargetMap`.`criterionID`,`content_editor_google`.`gce_campaignProximityTargetMap`.`latitudeInMicroDegrees`,`content_editor_google`.`gce_campaignProximityTargetMap`.`longitudeInMicroDegrees`,`content_editor_google`.`gce_campaignProximityTargetMap`.`radius`,`content_editor_google`.`gce_campaignProximityTargetMap`.`radiusUnits`,`content_editor_google`.`gce_campaign`.`id` AS `gce_campaign_campaignID`,`gce_campaignPendingUpdate`.`name` AS `nameChange`,`gce_campaignPendingUpdate`.`budgetAmount` AS `budgetAmountChange`,`gce_campaignPendingUpdate`.`budgetPeriod` AS `budgetPeriodChange`,`gce_campaignPendingUpdate`.`contentTargeting` AS `contentTargetingChange`,`gce_campaignPendingUpdate`.`endDay` AS `endDayChange`,`gce_campaignPendingUpdate`.`status` AS `statusChange`,`gce_campaignPendingUpdate`.`budgetOptimizerBidCeiling` AS `budgetOptimizerBidCeilingChange`,`gce_campaignPendingUpdate`.`budgetOptimizerEnabled` AS `budgetOptimizerEnabledChange`,`gce_campaignPendingUpdate`.`budgetOptimizerTakeOnOptimizedBids` AS `budgetOptimizerTakeOnOptimizedBidsChange` from `content_editor_google`.`gce_campaign` left join `gce_campaignPendingChange` on ((`content_editor_google`.`gce_campaignPendingChange`.`campaignID`=`content_editor_google`.`gce_campaign`.`id`)) left join `gce_campaignPendingUpdate` on ((`gce_campaignPendingUpdate`.`campaignID`=`gce_campaign`.`id`)) left join `gce_campaignTargetMap` on ((`content_editor_google`.`gce_campaignTargetMap`.`campaignID`=`content_editor_google`.`gce_campaign`.`id`)) left join `gce_target` on ((`content_editor_google`.`gce_campaignTargetMap`.`targetID`=`content_editor_google`.`gce_target`.`id`)) left join `gce_campaignBudgetOptimizerSetting` on ((`content_editor_google`.`gce_campaignBudgetOptimizerSetting`.`campaignID`=`content_editor_google`.`gce_campaign`.`id`)) left join `content_editor_google`.`gce_campaignProximityTargetMap` on (((((`content_editor_google`.`gce_campaignProximityTargetMap`.`campaignID`=`content_editor_google`.`gce_campaignTargetMap`.`campaignID`)) and ((`content_editor_google`.`gce_campaignProximityTargetMap`.`targetID`=`content_editor_google`.`gce_campaignTargetMap`.`targetID`))))) where ((`gce_campaign`.`id` in (1630,1631,1632)))]
2013-02-22 07:18:47.097 (4) [pool-3-thread-4]: time=0.0030
2013-02-22 07:18:47.097 (4) [pool-3-thread-4]: Query executed in 0.003s
2013-02-22 07:18:47.098 (4) [pool-3-thread-4]: spike: SQL->[select `content_editor_google`.`gce_campaign`.`id`,`content_editor_google`.`gce_campaignPendingChange`.*,`content_editor_google`.`gce_campaignAdExtensionMap`.`adExtensionID`,`content_editor_google`.`gce_campaignAdExtensionMap`.`adExtensionType`,`content_editor_google`.`gce_campaignAdExtensionMap`.`searchEngineIdentifier` AS `adExtensionIdentifier`,`content_editor_google`.`gce_adSiteLink`.`id` AS `siteLinkID`,`content_editor_google`.`gce_adSiteLink`.`text`,`content_editor_google`.`gce_adSiteLink`.`destinationURL`,`content_editor_google`.`gce_campaign`.`id` AS `gce_campaign_campaignID` from `content_editor_google`.`gce_campaign` left join `gce_campaignPendingChange` on ((`content_editor_google`.`gce_campaignPendingChange`.`campaignID`=`content_editor_google`.`gce_campaign`.`id`)) left join `gce_campaignAdExtensionMap` on ((`content_editor_google`.`gce_campaignAdExtensionMap`.`campaignID`=`content_editor_google`.`gce_campaign`.`id`)) left join `gce_adSiteLink` on ((`content_editor_google`.`gce_campaignAdExtensionMap`.`adExtensionID`=`content_editor_google`.`gce_adSiteLink`.`adExtensionID`)) where ((`gce_campaign`.`id` in (1630,1631,1632)))]
2013-02-22 07:18:47.100 (4) [pool-3-thread-4]: time=0.0020
2013-02-22 07:18:47.100 (4) [pool-3-thread-4]: Query executed in 0.002s
2013-02-22 07:18:47.100 (4) [pool-3-thread-4]: spike: SQL->[select * from `content_editor_google`.`gce_campaignProximityTargetMapPendingUpdate` join `content_editor_google`.`gce_target` on ((`content_editor_google`.`gce_campaignProximityTargetMapPendingUpdate`.`targetID`=`content_editor_google`.`gce_target`.`id`)) left join `content_editor_google`.`gce_campaignProximityTargetMap` on (((`content_editor_google`.`gce_campaignProximityTargetMap`.`targetID`=`content_editor_google`.`gce_target`.`id`) and (`content_editor_google`.`gce_campaignProximityTargetMap`.`campaignID`=`content_editor_google`.`gce_campaignProximityTargetMapPendingUpdate`.`campaignID`))) where (`content_editor_google`.`gce_campaignProximityTargetMapPendingUpdate`.`campaignID`=1630)]
2013-02-22 07:18:47.102 (4) [pool-3-thread-4]: time=0.0020
2013-02-22 07:18:47.102 (4) [pool-3-thread-4]: Query executed in 0.002s
2013-02-22 07:18:47.102 (4) [pool-3-thread-4]: spike: SQL->[select * from `content_editor_google`.`gce_campaignTargetMapPendingUpdate` join `content_editor_google`.`gce_target` on ((`content_editor_google`.`gce_campaignTargetMapPendingUpdate`.`targetID`=`content_editor_google`.`gce_target`.`id`)) left join `content_editor_google`.`gce_campaignProximityTargetMap` on (((`content_editor_google`.`gce_campaignProximityTargetMap`.`targetID`=`content_editor_google`.`gce_target`.`id`) and (`content_editor_google`.`gce_campaignProximityTargetMap`.`campaignID`=`content_editor_google`.`gce_campaignTargetMapPendingUpdate`.`campaignID`))) where (`content_editor_google`.`gce_campaignTargetMapPendingUpdate`.`campaignID`=1630)]
2013-02-22 07:18:47.103 (4) [pool-3-thread-4]: time=0.0010
2013-02-22 07:18:47.103 (4) [pool-3-thread-4]: Query executed in 0.001s
2013-02-22 07:18:47.104 (4) [pool-3-thread-4]: spike: SQL->[select `content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate`.*,`content_editor_google`.`gce_campaignAdExtensionMap`.`adExtensionID`,`content_editor_google`.`gce_campaignAdExtensionMap`.`adExtensionType`,`content_editor_google`.`gce_campaignAdExtensionMap`.`searchEngineIdentifier` AS `adExtensionIdentifier`,`content_editor_google`.`gce_adSiteLink`.`id` AS `siteLinkID`,`content_editor_google`.`gce_adSiteLink`.`text`,`content_editor_google`.`gce_adSiteLink`.`destinationURL`,`content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate`.`campaignID` AS `gce_campaign_campaignID` from `content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate` join `content_editor_google`.`gce_campaignAdExtensionMap` on ((`content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate`.`adExtensionID`=`content_editor_google`.`gce_campaignAdExtensionMap`.`adExtensionID`)) join `content_editor_google`.`gce_adSiteLink` on ((`content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate`.`adExtensionID`=`content_editor_google`.`gce_adSiteLink`.`adExtensionID`)) where (`content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate`.`campaignID`=1630)]
2013-02-22 07:18:47.105 (4) [pool-3-thread-4]: time=0.0010
2013-02-22 07:18:47.105 (4) [pool-3-thread-4]: Query executed in 0.001s
2013-02-22 07:18:47.105 (4) [pool-3-thread-4]: spike: SQL->[select * from `content_editor_google`.`gce_campaignProximityTargetMapPendingUpdate` join `content_editor_google`.`gce_target` on ((`content_editor_google`.`gce_campaignProximityTargetMapPendingUpdate`.`targetID`=`content_editor_google`.`gce_target`.`id`)) left join `content_editor_google`.`gce_campaignProximityTargetMap` on (((`content_editor_google`.`gce_campaignProximityTargetMap`.`targetID`=`content_editor_google`.`gce_target`.`id`) and (`content_editor_google`.`gce_campaignProximityTargetMap`.`campaignID`=`content_editor_google`.`gce_campaignProximityTargetMapPendingUpdate`.`campaignID`))) where (`content_editor_google`.`gce_campaignProximityTargetMapPendingUpdate`.`campaignID`=1631)]
2013-02-22 07:18:47.107 (4) [pool-3-thread-4]: time=0.0020
2013-02-22 07:18:47.107 (4) [pool-3-thread-4]: Query executed in 0.002s
2013-02-22 07:18:47.107 (4) [pool-3-thread-4]: spike: SQL->[select * from `content_editor_google`.`gce_campaignTargetMapPendingUpdate` join `content_editor_google`.`gce_target` on ((`content_editor_google`.`gce_campaignTargetMapPendingUpdate`.`targetID`=`content_editor_google`.`gce_target`.`id`)) left join `content_editor_google`.`gce_campaignProximityTargetMap` on (((`content_editor_google`.`gce_campaignProximityTargetMap`.`targetID`=`content_editor_google`.`gce_target`.`id`) and (`content_editor_google`.`gce_campaignProximityTargetMap`.`campaignID`=`content_editor_google`.`gce_campaignTargetMapPendingUpdate`.`campaignID`))) where (`content_editor_google`.`gce_campaignTargetMapPendingUpdate`.`campaignID`=1631)]
2013-02-22 07:18:47.108 (4) [pool-3-thread-4]: time=0.0010
2013-02-22 07:18:47.108 (4) [pool-3-thread-4]: Query executed in 0.001s
2013-02-22 07:18:47.108 (4) [pool-3-thread-4]: spike: SQL->[select `content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate`.*,`content_editor_google`.`gce_campaignAdExtensionMap`.`adExtensionID`,`content_editor_google`.`gce_campaignAdExtensionMap`.`adExtensionType`,`content_editor_google`.`gce_campaignAdExtensionMap`.`searchEngineIdentifier` AS `adExtensionIdentifier`,`content_editor_google`.`gce_adSiteLink`.`id` AS `siteLinkID`,`content_editor_google`.`gce_adSiteLink`.`text`,`content_editor_google`.`gce_adSiteLink`.`destinationURL`,`content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate`.`campaignID` AS `gce_campaign_campaignID` from `content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate` join `content_editor_google`.`gce_campaignAdExtensionMap` on ((`content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate`.`adExtensionID`=`content_editor_google`.`gce_campaignAdExtensionMap`.`adExtensionID`)) join `content_editor_google`.`gce_adSiteLink` on ((`content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate`.`adExtensionID`=`content_editor_google`.`gce_adSiteLink`.`adExtensionID`)) where (`content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate`.`campaignID`=1631)]
2013-02-22 07:18:47.110 (4) [pool-3-thread-4]: time=0.0020
2013-02-22 07:18:47.110 (4) [pool-3-thread-4]: Query executed in 0.002s
2013-02-22 07:18:47.110 (4) [pool-3-thread-4]: spike: SQL->[select * from `content_editor_google`.`gce_campaignProximityTargetMapPendingUpdate` join `content_editor_google`.`gce_target` on ((`content_editor_google`.`gce_campaignProximityTargetMapPendingUpdate`.`targetID`=`content_editor_google`.`gce_target`.`id`)) left join `content_editor_google`.`gce_campaignProximityTargetMap` on (((`content_editor_google`.`gce_campaignProximityTargetMap`.`targetID`=`content_editor_google`.`gce_target`.`id`) and (`content_editor_google`.`gce_campaignProximityTargetMap`.`campaignID`=`content_editor_google`.`gce_campaignProximityTargetMapPendingUpdate`.`campaignID`))) where (`content_editor_google`.`gce_campaignProximityTargetMapPendingUpdate`.`campaignID`=1632)]
2013-02-22 07:18:47.112 (4) [pool-3-thread-4]: time=0.0020
2013-02-22 07:18:47.112 (4) [pool-3-thread-4]: Query executed in 0.002s
2013-02-22 07:18:47.112 (4) [pool-3-thread-4]: spike: SQL->[select * from `content_editor_google`.`gce_campaignTargetMapPendingUpdate` join `content_editor_google`.`gce_target` on ((`content_editor_google`.`gce_campaignTargetMapPendingUpdate`.`targetID`=`content_editor_google`.`gce_target`.`id`)) left join `content_editor_google`.`gce_campaignProximityTargetMap` on (((`content_editor_google`.`gce_campaignProximityTargetMap`.`targetID`=`content_editor_google`.`gce_target`.`id`) and (`content_editor_google`.`gce_campaignProximityTargetMap`.`campaignID`=`content_editor_google`.`gce_campaignTargetMapPendingUpdate`.`campaignID`))) where (`content_editor_google`.`gce_campaignTargetMapPendingUpdate`.`campaignID`=1632)]
2013-02-22 07:18:47.113 (4) [pool-3-thread-4]: time=0.0010
2013-02-22 07:18:47.113 (4) [pool-3-thread-4]: Query executed in 0.001s
2013-02-22 07:18:47.114 (4) [pool-3-thread-4]: spike: SQL->[select `content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate`.*,`content_editor_google`.`gce_campaignAdExtensionMap`.`adExtensionID`,`content_editor_google`.`gce_campaignAdExtensionMap`.`adExtensionType`,`content_editor_google`.`gce_campaignAdExtensionMap`.`searchEngineIdentifier` AS `adExtensionIdentifier`,`content_editor_google`.`gce_adSiteLink`.`id` AS `siteLinkID`,`content_editor_google`.`gce_adSiteLink`.`text`,`content_editor_google`.`gce_adSiteLink`.`destinationURL`,`content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate`.`campaignID` AS `gce_campaign_campaignID` from `content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate` join `content_editor_google`.`gce_campaignAdExtensionMap` on ((`content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate`.`adExtensionID`=`content_editor_google`.`gce_campaignAdExtensionMap`.`adExtensionID`)) join `content_editor_google`.`gce_adSiteLink` on ((`content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate`.`adExtensionID`=`content_editor_google`.`gce_adSiteLink`.`adExtensionID`)) where (`content_editor_google`.`gce_campaignAdExtensionMapPendingUpdate`.`campaignID`=1632)]
2013-02-22 07:18:47.115 (4) [pool-3-thread-4]: time=0.0010
2013-02-22 07:18:47.115 (4) [pool-3-thread-4]: Query executed in 0.001s
2013-02-22 07:18:47.115 (4) [pool-3-thread-4]: spike: SQL->[select `campaignID`,`errorCode`,`errorText`,`reason`,`policyName`,`field`,`trigger`,`isExemptable` from `content_editor_google`.`gce_campaignError` where (`gce_campaignError`.`campaignID`=1630)]
2013-02-22 07:18:47.116 (4) [pool-3-thread-4]: time=0.0010
2013-02-22 07:18:47.116 (4) [pool-3-thread-4]: Query executed in 0.001s
2013-02-22 07:18:47.116 (4) [pool-3-thread-4]: spike: SQL->[select `campaignID`,`errorCode`,`errorText`,`reason`,`policyName`,`field`,`trigger`,`isExemptable` from `content_editor_google`.`gce_campaignError` where (`gce_campaignError`.`campaignID`=1631)]
2013-02-22 07:18:47.118 (4) [pool-3-thread-4]: time=0.0020
2013-02-22 07:18:47.118 (4) [pool-3-thread-4]: Query executed in 0.002s
2013-02-22 07:18:47.118 (4) [pool-3-thread-4]: spike: SQL->[select `campaignID`,`errorCode`,`errorText`,`reason`,`policyName`,`field`,`trigger`,`isExemptable` from `content_editor_google`.`gce_campaignError` where (`gce_campaignError`.`campaignID`=1632)]
2013-02-22 07:18:47.119 (4) [pool-3-thread-4]: time=0.0010
2013-02-22 07:18:47.119 (4) [pool-3-thread-4]: Query executed in 0.001s
2013-02-22 07:18:47.119 (4) [pool-3-thread-4]: Returning Object to Pool
2013-02-22 07:18:47.119 (4) [pool-3-thread-4]: no account, or instance for databaseInstance, skipping lookup...
2013-02-22 07:18:47.119 (4) [pool-3-thread-4]: Took Existing Object from Pool
2013-02-22 07:18:47.119 (4) [pool-3-thread-4]: spike: SQL->[select @@version]
2013-02-22 07:18:47.120 (4) [pool-3-thread-4]: time=0.0010
2013-02-22 07:18:47.120 (4) [pool-3-thread-4]: Query executed in 0.001s
2013-02-22 07:18:47.120 (4) [pool-3-thread-4]: test query succeeded, returned "5.1.65-rel14.0"
2013-02-22 07:18:47.120 (4) [pool-3-thread-4]: DataCache: Found key global-clients
2013-02-22 07:18:47.121 (4) [pool-3-thread-4]: Took Existing Object from Pool
2013-02-22 07:18:47.121 (4) [pool-3-thread-4]: spike: SQL->[select @@version]
2013-02-22 07:18:47.122 (4) [pool-3-thread-4]: time=0.0010
2013-02-22 07:18:47.122 (4) [pool-3-thread-4]: Query executed in 0.001s
2013-02-22 07:18:47.122 (4) [pool-3-thread-4]: test query succeeded, returned "5.1.65-rel14.0"
2013-02-22 07:18:47.122 (4) [pool-3-thread-4]: spike: SQL->[select * from `tsacommon`.`searchEngineAccounts` where (`id`=1618) limit 1]
2013-02-22 07:18:47.124 (4) [pool-3-thread-4]: time=0.0020
2013-02-22 07:18:47.124 (4) [pool-3-thread-4]: Query executed in 0.002s
2013-02-22 07:18:47.124 (4) [pool-3-thread-4]:   Record Loaded
2013-02-22 07:18:47.124 (4) [pool-3-thread-4]: spike: SQL->[update `tsacommon`.`searchEngineAccounts` set `searchEngineStatusText`="Paused",`searchEngineStatus`="disabled" where (`id`=1618) limit 1], genflags=no
2013-02-22 07:18:47.126 (4) [pool-3-thread-4]: time=0.0020
2013-02-22 07:18:47.126 (4) [pool-3-thread-4]: Query executed in 0.002s, 1 row(s) affected
2013-02-22 07:18:47.126 (3) [pool-3-thread-4]: 8ee2247d-cacc-4283-8853-ae7ce635409e_10034_4051_1225_GT status updated to Paused
2013-02-22 07:18:47.126 (4) [pool-3-thread-4]: spike: SQL->[select * from `tsacommon`.`searchEngineAccounts` where (`id`=1619) limit 1]
2013-02-22 07:18:47.128 (4) [pool-3-thread-4]: time=0.0020
2013-02-22 07:18:47.128 (4) [pool-3-thread-4]: Query executed in 0.002s
2013-02-22 07:18:47.128 (4) [pool-3-thread-4]:   Record Loaded
2013-02-22 07:18:47.128 (4) [pool-3-thread-4]: spike: SQL->[update `tsacommon`.`searchEngineAccounts` set `searchEngineStatusText`="Paused",`searchEngineStatus`="disabled" where (`id`=1619) limit 1], genflags=no
2013-02-22 07:18:47.131 (4) [pool-3-thread-4]: time=0.0020
2013-02-22 07:18:47.131 (4) [pool-3-thread-4]: Query executed in 0.002s, 1 row(s) affected
2013-02-22 07:18:47.131 (3) [pool-3-thread-4]: 8ee2247d-cacc-4283-8853-ae7ce635409e_10034_4051_1225_GM status updated to Paused
2013-02-22 07:18:47.131 (4) [pool-3-thread-4]: spike: SQL->[select * from `tsacommon`.`searchEngineAccounts` where (`id`=1620) limit 1]
2013-02-22 07:18:47.132 (4) [pool-3-thread-4]: time=0.0010
2013-02-22 07:18:47.132 (4) [pool-3-thread-4]: Query executed in 0.001s
2013-02-22 07:18:47.133 (4) [pool-3-thread-4]:   Record Loaded
2013-02-22 07:18:47.133 (4) [pool-3-thread-4]: spike: SQL->[update `tsacommon`.`searchEngineAccounts` set `searchEngineStatusText`="Paused",`searchEngineStatus`="disabled" where (`id`=1620) limit 1], genflags=no
2013-02-22 07:18:47.134 (4) [pool-3-thread-4]: time=0.0010
2013-02-22 07:18:47.134 (4) [pool-3-thread-4]: Query executed in 0.001s, 1 row(s) affected
2013-02-22 07:18:47.134 (3) [pool-3-thread-4]: 8ee2247d-cacc-4283-8853-ae7ce635409e_10034_4051_1225_MO status updated to Paused
2013-02-22 07:18:47.135 (4) [pool-3-thread-4]: Returning Object to Pool
2013-02-22 07:18:47.135 (4) [pool-3-thread-4]: Returning Object to Pool
2013-02-22 07:18:47.135 (3) [pool-3-thread-4]: Campaign structure sync not enabled for this request.
2013-02-22 07:18:47.135 (4) [pool-3-thread-4]: DataCache: Found key global-clients
2013-02-22 07:18:47.135 (4) [pool-3-thread-4]: Took Existing Object from Pool
2013-02-22 07:18:47.135 (4) [pool-3-thread-4]: spike: SQL->[select @@version]
2013-02-22 07:18:47.136 (4) [pool-3-thread-4]: time=0.0010
2013-02-22 07:18:47.136 (4) [pool-3-thread-4]: Query executed in 0.001s
2013-02-22 07:18:47.136 (4) [pool-3-thread-4]: test query succeeded, returned "5.1.65-rel14.0"
2013-02-22 07:18:47.137 (4) [pool-3-thread-4]: DataCache: Found key acct-content-google 289
2013-02-22 07:18:47.137 (4) [pool-3-thread-4]: DataCache: Found key acct-content-google-1
2013-02-22 07:18:47.137 (4) [pool-3-thread-4]: Took Existing Object from Pool
2013-02-22 07:18:47.137 (4) [pool-3-thread-4]: spike: SQL->[select @@version]
2013-02-22 07:18:47.138 (4) [pool-3-thread-4]: time=0.0010
2013-02-22 07:18:47.138 (4) [pool-3-thread-4]: Query executed in 0.001s
2013-02-22 07:18:47.138 (4) [pool-3-thread-4]: test query succeeded, returned "5.1.65-rel14.0"
2013-02-22 07:18:47.138 (4) [pool-3-thread-4]: spike: SQL->[select `gce_campaignPendingChange`.`campaignID`,`errorCode`,`errorText`,`reason`,`policyName`,`isFailed`,`requestTime`,`tryCount`,`type`,`field`,`trigger`,`isExemptable` from `gce_campaignPendingChange` join `gce_campaignError` on ((`gce_campaignPendingChange`.`campaignID`=`gce_campaignError`.`campaignID`)) where (`gce_campaignPendingChange`.`campaignID` in (1631))]
2013-02-22 07:18:47.140 (4) [pool-3-thread-4]: time=0.0020
2013-02-22 07:18:47.140 (4) [pool-3-thread-4]: Query executed in 0.002s
2013-02-22 07:18:47.140 (4) [pool-3-thread-4]: spike: SQL->[select `gce_campaignTargetMapPendingChange`.`campaignID`,`errorCode`,`errorText`,`reason`,`policyName`,`isFailed`,`requestTime`,`tryCount`,`type`,`field`,`trigger`,`isExemptable` from `gce_campaignTargetMapPendingChange` join `gce_campaignTargetMapError` on ((`gce_campaignTargetMapPendingChange`.`campaignID`=`gce_campaignTargetMapError`.`campaignID`)) where (`gce_campaignTargetMapPendingChange`.`campaignID` in (1631))]
2013-02-22 07:18:47.141 (4) [pool-3-thread-4]: time=0.0010
2013-02-22 07:18:47.141 (4) [pool-3-thread-4]: Query executed in 0.001s
2013-02-22 07:18:47.141 (4) [pool-3-thread-4]: spike: SQL->[select id from `content_editor_google`.`gce_adGroup` where (`campaignID` in (1631))]
2013-02-22 07:18:47.143 (4) [pool-3-thread-4]: time=0.0020
2013-02-22 07:18:47.143 (4) [pool-3-thread-4]: Query executed in 0.002s
2013-02-22 07:18:47.143 (4) [pool-3-thread-4]: spike: SQL->[select `gce_adGroupPendingChange`.`adGroupID`,`errorCode`,`errorText`,`reason`,`policyName`,`isFailed`,`requestTime`,`tryCount`,`type`,`field`,`trigger`,`isExemptable` from `gce_adGroupPendingChange` join `gce_adGroupError` on ((`gce_adGroupPendingChange`.`adGroupID`=`gce_adGroupError`.`adGroupID`)) where (`gce_adGroupPendingChange`.`adGroupID` in (1629))]
2013-02-22 07:18:47.144 (4) [pool-3-thread-4]: time=0.0010
2013-02-22 07:18:47.145 (4) [pool-3-thread-4]: Query executed in 0.001s
2013-02-22 07:18:47.145 (4) [pool-3-thread-4]: spike: SQL->[select `gce_keywordPendingChange`.`keywordID`,`errorCode`,`errorText`,`reason`,`policyName`,`isFailed`,`requestTime`,`tryCount`,`type`,`field`,`trigger`,`isExemptable` from `gce_keywordPendingChange` join `gce_keywordError` on ((`gce_keywordPendingChange`.`keywordID`=`gce_keywordError`.`keywordID`)) join `gce_keyword` on ((`id`=`gce_keywordPendingChange`.`keywordID`)) where (`adGroupID` in (1629))]
2013-02-22 07:18:47.148 (4) [pool-3-thread-4]: time=0.0030
2013-02-22 07:18:47.148 (4) [pool-3-thread-4]: Query executed in 0.003s
2013-02-22 07:18:47.148 (4) [pool-3-thread-4]: spike: SQL->[select `gce_textAdPendingChange`.`textAdID`,`errorCode`,`errorText`,`reason`,`policyName`,`isFailed`,`requestTime`,`tryCount`,`type`,`field`,`trigger`,`isExemptable` from `gce_textAdPendingChange` join `gce_textAdError` on ((`gce_textAdPendingChange`.`textAdID`=`gce_textAdError`.`textAdID`)) join `gce_textAd` on ((`id`=`gce_textAdPendingChange`.`textAdID`)) where (`adGroupID` in (1629))]
2013-02-22 07:18:47.149 (4) [pool-3-thread-4]: time=0.0010
2013-02-22 07:18:47.149 (4) [pool-3-thread-4]: Query executed in 0.001s
2013-02-22 07:18:47.149 (4) [pool-3-thread-4]: Returning Object to Pool
2013-02-22 07:18:47.149 (3) [pool-3-thread-4]: Structure sync disabled, ignoring 0 structure operation errors.
2013-02-22 07:18:47.149 (3) [pool-3-thread-4]: 1225_GM has no applicable GCE errors.
2013-02-22 07:18:47.149 (4) [pool-3-thread-4]: preparing SQL statement [update clients.externalCampaign set enabled = ? where id = ?]
2013-02-22 07:18:47.151 (4) [pool-3-thread-4]: DataCache: Found key acct-content-google 289
2013-02-22 07:18:47.151 (4) [pool-3-thread-4]: DataCache: Found key acct-content-google-1
2013-02-22 07:18:47.151 (4) [pool-3-thread-4]: Took Existing Object from Pool
2013-02-22 07:18:47.151 (4) [pool-3-thread-4]: spike: SQL->[select @@version]
2013-02-22 07:18:47.153 (4) [pool-3-thread-4]: time=0.0020
2013-02-22 07:18:47.153 (4) [pool-3-thread-4]: Query executed in 0.002s
2013-02-22 07:18:47.153 (4) [pool-3-thread-4]: test query succeeded, returned "5.1.65-rel14.0"
2013-02-22 07:18:47.153 (4) [pool-3-thread-4]: spike: SQL->[select `gce_campaignPendingChange`.`campaignID`,`errorCode`,`errorText`,`reason`,`policyName`,`isFailed`,`requestTime`,`tryCount`,`type`,`field`,`trigger`,`isExemptable` from `gce_campaignPendingChange` join `gce_campaignError` on ((`gce_campaignPendingChange`.`campaignID`=`gce_campaignError`.`campaignID`)) where (`gce_campaignPendingChange`.`campaignID` in (1630))]
2013-02-22 07:18:47.155 (4) [pool-3-thread-4]: time=0.0020
2013-02-22 07:18:47.155 (4) [pool-3-thread-4]: Query executed in 0.002s
2013-02-22 07:18:47.155 (4) [pool-3-thread-4]: spike: SQL->[select `gce_campaignTargetMapPendingChange`.`campaignID`,`errorCode`,`errorText`,`reason`,`policyName`,`isFailed`,`requestTime`,`tryCount`,`type`,`field`,`trigger`,`isExemptable` from `gce_campaignTargetMapPendingChange` join `gce_campaignTargetMapError` on ((`gce_campaignTargetMapPendingChange`.`campaignID`=`gce_campaignTargetMapError`.`campaignID`)) where (`gce_campaignTargetMapPendingChange`.`campaignID` in (1630))]
2013-02-22 07:18:47.156 (4) [pool-3-thread-4]: time=0.0010
2013-02-22 07:18:47.156 (4) [pool-3-thread-4]: Query executed in 0.001s
2013-02-22 07:18:47.156 (4) [pool-3-thread-4]: spike: SQL->[select id from `content_editor_google`.`gce_adGroup` where (`campaignID` in (1630))]
2013-02-22 07:18:47.158 (4) [pool-3-thread-4]: time=0.0020
2013-02-22 07:18:47.158 (4) [pool-3-thread-4]: Query executed in 0.002s
2013-02-22 07:18:47.158 (4) [pool-3-thread-4]: spike: SQL->[select `gce_adGroupPendingChange`.`adGroupID`,`errorCode`,`errorText`,`reason`,`policyName`,`isFailed`,`requestTime`,`tryCount`,`type`,`field`,`trigger`,`isExemptable` from `gce_adGroupPendingChange` join `gce_adGroupError` on ((`gce_adGroupPendingChange`.`adGroupID`=`gce_adGroupError`.`adGroupID`)) where (`gce_adGroupPendingChange`.`adGroupID` in (1628))]
2013-02-22 07:18:47.159 (4) [pool-3-thread-4]: time=0.0010
2013-02-22 07:18:47.159 (4) [pool-3-thread-4]: Query executed in 0.001s
2013-02-22 07:18:47.159 (4) [pool-3-thread-4]: spike: SQL->[select `gce_keywordPendingChange`.`keywordID`,`errorCode`,`errorText`,`reason`,`policyName`,`isFailed`,`requestTime`,`tryCount`,`type`,`field`,`trigger`,`isExemptable` from `gce_keywordPendingChange` join `gce_keywordError` on ((`gce_keywordPendingChange`.`keywordID`=`gce_keywordError`.`keywordID`)) join `gce_keyword` on ((`id`=`gce_keywordPendingChange`.`keywordID`)) where (`adGroupID` in (1628))]
2013-02-22 07:18:47.161 (4) [pool-3-thread-4]: time=0.0020
2013-02-22 07:18:47.161 (4) [pool-3-thread-4]: Query executed in 0.002s
2013-02-22 07:18:47.161 (4) [pool-3-thread-4]: spike: SQL->[select `gce_textAdPendingChange`.`textAdID`,`errorCode`,`errorText`,`reason`,`policyName`,`isFailed`,`requestTime`,`tryCount`,`type`,`field`,`trigger`,`isExemptable` from `gce_textAdPendingChange` join `gce_textAdError` on ((`gce_textAdPendingChange`.`textAdID`=`gce_textAdError`.`textAdID`)) join `gce_textAd` on ((`id`=`gce_textAdPendingChange`.`textAdID`)) where (`adGroupID` in (1628))]
2013-02-22 07:18:47.162 (4) [pool-3-thread-4]: time=0.0010
2013-02-22 07:18:47.162 (4) [pool-3-thread-4]: Query executed in 0.001s
2013-02-22 07:18:47.162 (4) [pool-3-thread-4]: Returning Object to Pool
2013-02-22 07:18:47.162 (3) [pool-3-thread-4]: Structure sync disabled, ignoring 0 structure operation errors.
2013-02-22 07:18:47.163 (3) [pool-3-thread-4]: 1225_GT has no applicable GCE errors.
2013-02-22 07:18:47.163 (4) [pool-3-thread-4]: preparing SQL statement [update clients.externalCampaign set enabled = ? where id = ?]
2013-02-22 07:18:47.164 (4) [pool-3-thread-4]: DataCache: Found key acct-content-google 289
2013-02-22 07:18:47.164 (4) [pool-3-thread-4]: DataCache: Found key acct-content-google-1
2013-02-22 07:18:47.164 (4) [pool-3-thread-4]: Took Existing Object from Pool
2013-02-22 07:18:47.164 (4) [pool-3-thread-4]: spike: SQL->[select @@version]
2013-02-22 07:18:47.165 (4) [pool-3-thread-4]: time=0.0010
2013-02-22 07:18:47.165 (4) [pool-3-thread-4]: Query executed in 0.001s
2013-02-22 07:18:47.165 (4) [pool-3-thread-4]: test query succeeded, returned "5.1.65-rel14.0"
2013-02-22 07:18:47.165 (4) [pool-3-thread-4]: spike: SQL->[select `gce_campaignPendingChange`.`campaignID`,`errorCode`,`errorText`,`reason`,`policyName`,`isFailed`,`requestTime`,`tryCount`,`type`,`field`,`trigger`,`isExemptable` from `gce_campaignPendingChange` join `gce_campaignError` on ((`gce_campaignPendingChange`.`campaignID`=`gce_campaignError`.`campaignID`)) where (`gce_campaignPendingChange`.`campaignID` in (1632))]
2013-02-22 07:18:47.167 (4) [pool-3-thread-4]: time=0.0020
2013-02-22 07:18:47.167 (4) [pool-3-thread-4]: Query executed in 0.002s
2013-02-22 07:18:47.167 (4) [pool-3-thread-4]: spike: SQL->[select `gce_campaignTargetMapPendingChange`.`campaignID`,`errorCode`,`errorText`,`reason`,`policyName`,`isFailed`,`requestTime`,`tryCount`,`type`,`field`,`trigger`,`isExemptable` from `gce_campaignTargetMapPendingChange` join `gce_campaignTargetMapError` on ((`gce_campaignTargetMapPendingChange`.`campaignID`=`gce_campaignTargetMapError`.`campaignID`)) where (`gce_campaignTargetMapPendingChange`.`campaignID` in (1632))]
2013-02-22 07:18:47.168 (4) [pool-3-thread-4]: time=0.0010
2013-02-22 07:18:47.168 (4) [pool-3-thread-4]: Query executed in 0.001s
2013-02-22 07:18:47.169 (4) [pool-3-thread-4]: spike: SQL->[select id from `content_editor_google`.`gce_adGroup` where (`campaignID` in (1632))]
2013-02-22 07:18:47.170 (4) [pool-3-thread-4]: time=0.0010
2013-02-22 07:18:47.170 (4) [pool-3-thread-4]: Query executed in 0.001s
2013-02-22 07:18:47.170 (4) [pool-3-thread-4]: spike: SQL->[select `gce_adGroupPendingChange`.`adGroupID`,`errorCode`,`errorText`,`reason`,`policyName`,`isFailed`,`requestTime`,`tryCount`,`type`,`field`,`trigger`,`isExemptable` from `gce_adGroupPendingChange` join `gce_adGroupError` on ((`gce_adGroupPendingChange`.`adGroupID`=`gce_adGroupError`.`adGroupID`)) where (`gce_adGroupPendingChange`.`adGroupID` in (1630))]
2013-02-22 07:18:47.177 (4) [pool-3-thread-4]: time=0.0070
2013-02-22 07:18:47.177 (4) [pool-3-thread-4]: Query executed in 0.007s
2013-02-22 07:18:47.177 (4) [pool-3-thread-4]: spike: SQL->[select `gce_keywordPendingChange`.`keywordID`,`errorCode`,`errorText`,`reason`,`policyName`,`isFailed`,`requestTime`,`tryCount`,`type`,`field`,`trigger`,`isExemptable` from `gce_keywordPendingChange` join `gce_keywordError` on ((`gce_keywordPendingChange`.`keywordID`=`gce_keywordError`.`keywordID`)) join `gce_keyword` on ((`id`=`gce_keywordPendingChange`.`keywordID`)) where (`adGroupID` in (1630))]
2013-02-22 07:18:47.178 (4) [pool-3-thread-4]: time=0.0010
2013-02-22 07:18:47.178 (4) [pool-3-thread-4]: Query executed in 0.001s
2013-02-22 07:18:47.178 (4) [pool-3-thread-4]: spike: SQL->[select `gce_textAdPendingChange`.`textAdID`,`errorCode`,`errorText`,`reason`,`policyName`,`isFailed`,`requestTime`,`tryCount`,`type`,`field`,`trigger`,`isExemptable` from `gce_textAdPendingChange` join `gce_textAdError` on ((`gce_textAdPendingChange`.`textAdID`=`gce_textAdError`.`textAdID`)) join `gce_textAd` on ((`id`=`gce_textAdPendingChange`.`textAdID`)) where (`adGroupID` in (1630))]
2013-02-22 07:18:47.180 (4) [pool-3-thread-4]: time=0.0020
2013-02-22 07:18:47.181 (4) [pool-3-thread-4]: Query executed in 0.002s
2013-02-22 07:18:47.181 (4) [pool-3-thread-4]: Returning Object to Pool
2013-02-22 07:18:47.181 (3) [pool-3-thread-4]: Structure sync disabled, ignoring 0 structure operation errors.
2013-02-22 07:18:47.181 (3) [pool-3-thread-4]: 1225_MO has no applicable GCE errors.
2013-02-22 07:18:47.181 (4) [pool-3-thread-4]: preparing SQL statement [update clients.externalCampaign set enabled = ? where id = ?]
2013-02-22 07:18:47.183 (4) [pool-3-thread-4]: preparing SQL statement [select id, externalCampaignParentID, gceCampaignID, searchEngineAccountID, accountID, enabled from clients.externalCampaign where id = ?]
2013-02-22 07:18:47.184 (3) [pool-3-thread-4]: Finished UPDATE request for campaign 8ee2247d-cacc-4283-8853-ae7ce635409e_10034_4051_1225_GM: SUCCEEDED
2013-02-22 07:18:47.184 (4) [pool-3-thread-4]: preparing SQL statement [select id, externalCampaignParentID, gceCampaignID, searchEngineAccountID, accountID, enabled from clients.externalCampaign where id = ?]
2013-02-22 07:18:47.185 (3) [pool-3-thread-4]: Finished UPDATE request for campaign 8ee2247d-cacc-4283-8853-ae7ce635409e_10034_4051_1225_GT: SUCCEEDED
2013-02-22 07:18:47.185 (4) [pool-3-thread-4]: preparing SQL statement [select id, externalCampaignParentID, gceCampaignID, searchEngineAccountID, accountID, enabled from clients.externalCampaign where id = ?]
2013-02-22 07:18:47.186 (3) [pool-3-thread-4]: Finished UPDATE request for campaign 8ee2247d-cacc-4283-8853-ae7ce635409e_10034_4051_1225_MO: SUCCEEDED
2013-02-22 07:18:47.186 (3) [pool-3-thread-4]: 8ee2247d-cacc-4283-8853-ae7ce635409e has 0 campaigns for a SE Update accounts sync.
2013-02-22 07:18:47.186 (3) [pool-3-thread-4]: 8ee2247d-cacc-4283-8853-ae7ce635409e has 0 campaigns for a SE Update groups-listings sync.
2013-02-22 07:18:47.186 (3) [pool-3-thread-4]: Finished sub-campaign processing for UPDATE deploymentID (2addc4ed-849e-4de2-8fe6-4d59421d1df4). account 8ee2247d-cacc-4283-8853-ae7ce635409e. 3 submitted, 3 ok.
2013-02-22 07:18:47.186 (4) [pool-3-thread-4]: Returning Object to Pool
2013-02-22 07:18:47.186 (4) [pool-3-thread-4]: Returning Object to Pool
2013-02-22 07:18:47.186 (4) [pool-3-thread-4]: Returning results.
2013-02-22 07:18:47.186 (4) [pool-3-thread-4]: DataCache: Found key global-clients
2013-02-22 07:18:47.186 (4) [pool-3-thread-4]: Took Existing Object from Pool
2013-02-22 07:18:47.186 (4) [pool-3-thread-4]: spike: SQL->[select @@version]
2013-02-22 07:18:47.188 (4) [pool-3-thread-4]: time=0.0020
2013-02-22 07:18:47.188 (4) [pool-3-thread-4]: Query executed in 0.002s
2013-02-22 07:18:47.188 (4) [pool-3-thread-4]: test query succeeded, returned "5.1.65-rel14.0"
2013-02-22 07:18:47.188 (3) [pool-3-thread-4]: Updating deployment status to 'Success' for campaignID: 1225
2013-02-22 07:18:47.188 (4) [pool-3-thread-4]: preparing SQL statement [update clients.externalCampaignParentDeployStatus set status = ? where description = ?]
2013-02-22 07:18:47.194 (3) [pool-3-thread-4]: Finished UPDATE request for 1225: SUCCEEDED
2013-02-22 07:18:47.194 (3) [pool-3-thread-4]: Finished UPDATE request, deploymentID (2addc4ed-849e-4de2-8fe6-4d59421d1df4), account 8ee2247d-cacc-4283-8853-ae7ce635409e
2013-02-22 07:18:47.194 (3) [pool-3-thread-4]: Request removed from map for customerID 8ee2247d-cacc-4283-8853-ae7ce635409e
2013-02-22 07:18:47.194 (4) [pool-3-thread-4]: spike: SQL->[SELECT RELEASE_LOCK('com.thesearchagency.admaxlistener.dao.TSACommonDAO.8ee2247d-cacc-4283-8853-ae7ce635409e')]
2013-02-22 07:18:47.196 (4) [pool-3-thread-4]: time=0.0020
2013-02-22 07:18:47.196 (4) [pool-3-thread-4]: Query executed in 0.002s
2013-02-22 07:18:47.196 (4) [pool-3-thread-4]: Released account lock: 8ee2247d-cacc-4283-8853-ae7ce635409e
2013-02-22 07:18:47.196 (4) [pool-3-thread-4]: Returning Object to Pool
2013-02-22 07:18:47.196 (4) [pool-3-thread-4]: Returning Object to Pool
2013-02-22 07:18:48.007 (3) [AdMaxListener]: Sent message to response queue.