2015-05-29 11:36:21.383 (4) [pool-3-thread-7]: time=0.0010 2015-05-29 11:36:21.384 (4) [pool-3-thread-7]: Query executed in 0.001s 2015-05-29 11:36:21.384 (5) [pool-3-thread-7]: quoteValue(), nothing special about it=>[598], type=class java.lang.Integer 2015-05-29 11:36:21.384 (5) [pool-3-thread-7]: ProfilerRec.start("db",true) in Thread [pool-3-thread-7] 2015-05-29 11:36:21.384 (4) [pool-3-thread-7]: spike: SQL->[select `content_editor_google`.`gce_feedMapping`.*,`content_editor_google`.`gce_feedAttributeFieldMapping`.`feedAttributeID`,`content_editor_google`.`gce_feedAttributeFieldMapping`.`fieldID`,`content_editor_google`.`gce_feedAttributeFieldMapping`.`id` AS `FEED_ATT_ID_ALIAS`,`content_editor_google`.`gce_feed`.`searchEngineIdentifier` AS `FEED_ID_SEID_ALIAS`,`content_editor_google`.`gce_feedAttribute`.`searchEngineIdentifier` AS `FEED_ATT_SEID_ALIAS`,`content_editor_google`.`gce_feedMappingPendingChange`.* from `content_editor_google`.`gce_feedMapping` left join `gce_feedMappingPendingChange` on ((`content_editor_google`.`gce_feedMappingPendingChange`.`feedMappingID`=`content_editor_google`.`gce_feedMapping`.`id`)) inner join `gce_feed` on ((`content_editor_google`.`gce_feed`.`id`=`content_editor_google`.`gce_feedMapping`.`feedID`)) inner join `gce_feedAttributeFieldMapping` on ((`content_editor_google`.`gce_feedAttributeFieldMapping`.`feedMappingID`=`content_editor_google`.`gce_feedMapping`.`id`)) inner join `gce_feedAttribute` on ((`content_editor_google`.`gce_feedAttribute`.`id`=`content_editor_google`.`gce_feedAttributeFieldMapping`.`feedAttributeID`)) where ((`content_editor_google`.`gce_feed`.`searchEngineUserID`=598)) order by `content_editor_google`.`gce_feedMapping`.`id`] 2015-05-29 11:36:21.385 (5) [pool-3-thread-7]: recordAsSubs("db", 1, "pool-3-thread-7") 2015-05-29 11:36:21.385 (5) [pool-3-thread-7]: addSub("db") 2015-05-29 11:36:21.385 (5) [pool-3-thread-7]: ProfilerRec.end("db", true): ret=1 2015-05-29 11:36:21.385 (4) [pool-3-thread-7]: time=0.0010 2015-05-29 11:36:21.385 (4) [pool-3-thread-7]: Query executed in 0.001s 2015-05-29 11:36:21.386 (5) [pool-3-thread-7]: quoteValue(), nothing special about it=>[221], type=class java.lang.Integer 2015-05-29 11:36:21.386 (5) [pool-3-thread-7]: ProfilerRec.start("db",true) in Thread [pool-3-thread-7] 2015-05-29 11:36:21.386 (4) [pool-3-thread-7]: spike: SQL->[select `feedMappingID`,`errorCode`,`errorText`,`reason`,`policyName`,`field`,`trigger`,`isExemptable` from `content_editor_google`.`gce_feedMappingError` where (`gce_feedMappingError`.`feedMappingID`=221)] 2015-05-29 11:36:21.386 (5) [pool-3-thread-7]: recordAsSubs("db", 0, "pool-3-thread-7") 2015-05-29 11:36:21.387 (5) [pool-3-thread-7]: addSub("db") 2015-05-29 11:36:21.387 (5) [pool-3-thread-7]: ProfilerRec.end("db", true): ret=0 2015-05-29 11:36:21.387 (4) [pool-3-thread-7]: time=0.0 2015-05-29 11:36:21.387 (4) [pool-3-thread-7]: Query executed in 0.000s 2015-05-29 11:36:21.387 (3) [pool-3-thread-7]: The account has an existing sitelink feed. 2015-05-29 11:36:21.387 (4) [pool-3-thread-7]: Returning Object to Pool 2015-05-29 11:36:21.387 (2) [pool-3-thread-7]: Error: CampID: 4162_GT Info: Error during update request. 2015-05-29 11:36:21.387 (2) [pool-3-thread-7]: Error: CampID: 4162_GM Info: Error during update request. 2015-05-29 11:36:21.388 (1) [pool-3-thread-7]: Exception [Error during update request.]:java.lang.NullPointerException at com.thesearchagency.searchengines.google.contenteditor.RequestCreator.createSiteLinkFeedItem(RequestCreator.java:1095) at com.thesearchagency.searchengines.google.contenteditor.RequestCreator.diffSiteLinkFeed(RequestCreator.java:1490) at com.thesearchagency.searchengines.google.contenteditor.RequestCreator.diffFeeds(RequestCreator.java:260) at com.thesearchagency.searchengines.google.contenteditor.GoogleContentEditor.updateCampaigns(GoogleContentEditor.java:434) at com.thesearchagency.admaxlistener.deployer.MultiplexAccountDeployer.updateCampaigns(MultiplexAccountDeployer.java:216) at com.thesearchagency.admaxlistener.worker.CampaignUpdateWorker.call(CampaignUpdateWorker.java:103) at com.thesearchagency.admaxlistener.worker.AccountWorker.updateCampaigns(AccountWorker.java:531) at com.thesearchagency.admaxlistener.worker.AccountWorker.deploySync(AccountWorker.java:397) at com.thesearchagency.admaxlistener.worker.AccountWorker.call(AccountWorker.java:151) at com.thesearchagency.admaxlistener.worker.RequestWorker.call(RequestWorker.java:418) at com.thesearchagency.admaxlistener.worker.RequestWorker.call(RequestWorker.java:97) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) 2015-05-29 11:36:21.388 (4) [pool-3-thread-7]: DataCache: Found key global-clients 2015-05-29 11:36:21.388 (4) [pool-3-thread-7]: Took Existing Object from Pool 2015-05-29 11:36:21.388 (5) [pool-3-thread-7]: ProfilerRec.start("db",true) in Thread [pool-3-thread-7] 2015-05-29 11:36:21.388 (4) [pool-3-thread-7]: spike: SQL->[select @@version] 2015-05-29 11:36:21.389 (5) [pool-3-thread-7]: recordAsSubs("db", 1, "pool-3-thread-7") 2015-05-29 11:36:21.389 (5) [pool-3-thread-7]: addSub("db") 2015-05-29 11:36:21.389 (5) [pool-3-thread-7]: ProfilerRec.end("db", true): ret=1 2015-05-29 11:36:21.389 (4) [pool-3-thread-7]: time=0.0010 2015-05-29 11:36:21.389 (4) [pool-3-thread-7]: Query executed in 0.001s 2015-05-29 11:36:21.389 (4) [pool-3-thread-7]: test query succeeded, returned "5.5.36"