[atul.sanagar@optus-qa-agency1 tsa-admax-jmslistener]$ tail -f tsa-admax-jmslistener.log 2013-01-31 23:20:10.438 (4) [Timer-0]: ContentEditorPropertiesRefresher: contenteditor.properties last modified 1337941320000 2013-01-31 23:20:15.448 (4) [Thread-9]: Found heartbeat message, adding to low priority message handler 2013-01-31 23:20:15.613 (4) [Thread-11]: LowPriorityMessageHandler handling message ID ID:JBM-b408ecab-e5f7-4e77-90b9-6266ef780d3c 2013-01-31 23:20:15.614 (4) [Thread-11]: onMessage() called 2013-01-31 23:20:15.614 (4) [Thread-11]: handle() called 2013-01-31 23:20:15.614 (4) [Thread-11]: time=0.184 2013-01-31 23:20:15.614 (3) [Thread-11]: Heartbeat #109 (1359634815430) received in 0.184s 2013-01-31 23:20:15.622 (4) [Thread-11]: LowPriorityMessageHandler took message ID ID:JBM-b408ecab-e5f7-4e77-90b9-6266ef780d3c out of queue 2013-01-31 23:20:38.177 (4) [Timer-12]: LicensingFileRefresher: licensing.properties last modified 1337940573000 2013-01-31 23:21:10.441 (4) [Timer-0]: ContentEditorPropertiesRefresher: contenteditor.properties last modified 1337941320000 2013-01-31 23:21:38.179 (4) [Timer-12]: LicensingFileRefresher: licensing.properties last modified 1337940573000 2013-01-31 23:22:10.443 (4) [Timer-0]: ContentEditorPropertiesRefresher: contenteditor.properties last modified 1337941320000 2013-01-31 23:22:15.438 (4) [pool-4-thread-2]: Start managing jobs... 2013-01-31 23:22:15.439 (4) [pool-4-thread-2]: DataCache: Key global-clients expired. 2013-01-31 23:22:15.439 (4) [pool-4-thread-2]: no account, or instance for databaseInstance, skipping lookup... 2013-01-31 23:22:15.450 (4) [pool-4-thread-2]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2013-01-31 23:22:15.450 (4) [pool-4-thread-2]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`name`="global-clients") and (`type`="mysql")) limit 1] 2013-01-31 23:22:15.452 (4) [Thread-9]: Found heartbeat message, adding to low priority message handler 2013-01-31 23:22:15.453 (4) [pool-4-thread-2]: time=0.0020 2013-01-31 23:22:15.453 (4) [pool-4-thread-2]: Query executed in 0.002s 2013-01-31 23:22:15.453 (4) [pool-4-thread-2]: Record Loaded 2013-01-31 23:22:15.453 (4) [pool-4-thread-2]: DataCache: put key global-clients 2013-01-31 23:22:15.453 (4) [pool-4-thread-2]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2013-01-31 23:22:15.454 (4) [ConnectionCloser]: Starting DatabasePool ConnectionCloserThread 2013-01-31 23:22:15.463 (4) [pool-4-thread-2]: opened [jdbc:mysql://clients-01-write:3306/clients?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2013-01-31 23:22:15.463 (4) [pool-4-thread-2]: Created new Object 2013-01-31 23:22:15.463 (4) [pool-4-thread-2]: spike: SQL->[select @@version] 2013-01-31 23:22:15.464 (4) [pool-4-thread-2]: time=0.0010 2013-01-31 23:22:15.465 (4) [pool-4-thread-2]: Query executed in 0.001s 2013-01-31 23:22:15.465 (4) [pool-4-thread-2]: test query succeeded, returned "5.1.60-rel13.1-log" 2013-01-31 23:22:15.465 (4) [pool-4-thread-2]: spike: SQL->[select id, externalCampaignJobTypeID, tryCount, isFailed, isFinished from externalCampaignJob where isFinished=0 and externalCampaignJobTypeID in (1,2) order by id asc limit 1] 2013-01-31 23:22:15.466 (4) [pool-4-thread-2]: time=0.0010 2013-01-31 23:22:15.466 (4) [pool-4-thread-2]: Query executed in 0.001s 2013-01-31 23:22:15.466 (4) [pool-4-thread-2]: spike: SQL->[select id, externalCampaignJobTypeID, tryCount, isFailed, isFinished from externalCampaignJob where isFinished=0 and externalCampaignJobTypeID in (1,2) order by id asc limit 1] 2013-01-31 23:22:15.467 (4) [pool-4-thread-2]: time=0.0010 2013-01-31 23:22:15.467 (4) [pool-4-thread-2]: Query executed in 0.001s 2013-01-31 23:22:15.467 (4) [pool-4-thread-2]: spike: SQL->[select t.id, t.description, t.maxJobSize from externalCampaignJobItem i join externalCampaignJobType t on (t.id = i.externalCampaignJobTypeID) where i.externalCampaignJobID is null and t.id in(1,2) and (unix_timestamp() - unix_timestamp(i.createTime)) > t.initialDelaySec order by i.id asc limit 1] 2013-01-31 23:22:15.468 (4) [pool-4-thread-2]: time=0.0010 2013-01-31 23:22:15.468 (4) [pool-4-thread-2]: Query executed in 0.001s 2013-01-31 23:22:15.468 (3) [pool-4-thread-2]: No new jobs to execute for type: [1,2] 2013-01-31 23:22:15.468 (4) [pool-4-thread-2]: Finished managing jobs. 2013-01-31 23:22:15.468 (4) [pool-4-thread-2]: Returning Object to Pool 2013-01-31 23:22:15.566 (4) [Thread-11]: LowPriorityMessageHandler handling message ID ID:JBM-f6da0261-769f-49be-a24a-5773ab07fc0c 2013-01-31 23:22:15.567 (4) [Thread-11]: onMessage() called 2013-01-31 23:22:15.567 (4) [Thread-11]: handle() called 2013-01-31 23:22:15.567 (4) [Thread-11]: time=0.128 2013-01-31 23:22:15.567 (3) [Thread-11]: Heartbeat #110 (1359634935439) received in 0.128s 2013-01-31 23:22:15.575 (4) [Thread-11]: LowPriorityMessageHandler took message ID ID:JBM-f6da0261-769f-49be-a24a-5773ab07fc0c out of queue 2013-01-31 23:22:17.438 (4) [pool-4-thread-2]: Start managing jobs... 2013-01-31 23:22:17.438 (4) [pool-4-thread-2]: DataCache: Found key global-clients 2013-01-31 23:22:17.438 (4) [pool-4-thread-2]: Took Existing Object from Pool 2013-01-31 23:22:17.438 (4) [pool-4-thread-2]: spike: SQL->[select @@version] 2013-01-31 23:22:17.440 (4) [pool-4-thread-2]: time=0.0020 2013-01-31 23:22:17.440 (4) [pool-4-thread-2]: Query executed in 0.002s 2013-01-31 23:22:17.440 (4) [pool-4-thread-2]: test query succeeded, returned "5.1.60-rel13.1-log" 2013-01-31 23:22:17.440 (4) [pool-4-thread-2]: spike: SQL->[select id, externalCampaignJobTypeID, tryCount, isFailed, isFinished from externalCampaignJob where isFinished=0 and externalCampaignJobTypeID in (4) order by id asc limit 1] 2013-01-31 23:22:17.441 (4) [pool-4-thread-2]: time=0.0010 2013-01-31 23:22:17.441 (4) [pool-4-thread-2]: Query executed in 0.001s 2013-01-31 23:22:17.441 (4) [pool-4-thread-2]: spike: SQL->[select id, externalCampaignJobTypeID, tryCount, isFailed, isFinished from externalCampaignJob where isFinished=0 and externalCampaignJobTypeID in (4) order by id asc limit 1] 2013-01-31 23:22:17.442 (4) [pool-4-thread-2]: time=0.0010 2013-01-31 23:22:17.442 (4) [pool-4-thread-2]: Query executed in 0.001s 2013-01-31 23:22:17.442 (4) [pool-4-thread-2]: spike: SQL->[select t.id, t.description, t.maxJobSize from externalCampaignJobItem i join externalCampaignJobType t on (t.id = i.externalCampaignJobTypeID) where i.externalCampaignJobID is null and t.id in(4) and (unix_timestamp() - unix_timestamp(i.createTime)) > t.initialDelaySec order by i.id asc limit 1] 2013-01-31 23:22:17.443 (4) [pool-4-thread-2]: time=0.0010 2013-01-31 23:22:17.443 (4) [pool-4-thread-2]: Query executed in 0.001s 2013-01-31 23:22:17.443 (3) [pool-4-thread-2]: No new jobs to execute for type: [4] 2013-01-31 23:22:17.443 (4) [pool-4-thread-2]: Finished managing jobs. 2013-01-31 23:22:17.443 (4) [pool-4-thread-2]: Returning Object to Pool 2013-01-31 23:22:19.438 (4) [pool-4-thread-2]: Start managing jobs... 2013-01-31 23:22:19.438 (4) [pool-4-thread-2]: DataCache: Found key global-clients 2013-01-31 23:22:19.438 (4) [pool-4-thread-2]: Took Existing Object from Pool 2013-01-31 23:22:19.438 (4) [pool-4-thread-2]: spike: SQL->[select @@version] 2013-01-31 23:22:19.440 (4) [pool-4-thread-2]: time=0.0020 2013-01-31 23:22:19.440 (4) [pool-4-thread-2]: Query executed in 0.002s 2013-01-31 23:22:19.440 (4) [pool-4-thread-2]: test query succeeded, returned "5.1.60-rel13.1-log" 2013-01-31 23:22:19.440 (4) [pool-4-thread-2]: spike: SQL->[select id, externalCampaignJobTypeID, tryCount, isFailed, isFinished from externalCampaignJob where isFinished=0 and externalCampaignJobTypeID in (6) order by id asc limit 1] 2013-01-31 23:22:19.441 (4) [pool-4-thread-2]: time=0.0010 2013-01-31 23:22:19.441 (4) [pool-4-thread-2]: Query executed in 0.001s 2013-01-31 23:22:19.441 (3) [pool-4-thread-2]: Failed job reached retry limit: ID: 30 jobTypeID 6 tryCount: 8 isFailed: true isFinished: true 2013-01-31 23:22:19.441 (4) [pool-4-thread-2]: preparing SQL statement [update externalCampaignJob set trycount=?, isFailed=?, isFinished=? where id=?] 2013-01-31 23:22:19.443 (4) [pool-4-thread-2]: preparing SQL statement [update externalCampaignJob set endTime=now() where id=?] 2013-01-31 23:22:19.458 (4) [pool-4-thread-2]: spike: SQL->[select id, externalCampaignJobTypeID, tryCount, isFailed, isFinished from externalCampaignJob where isFinished=0 and externalCampaignJobTypeID in (6) order by id asc limit 1] 2013-01-31 23:22:19.460 (4) [pool-4-thread-2]: time=0.0020 2013-01-31 23:22:19.460 (4) [pool-4-thread-2]: Query executed in 0.002s 2013-01-31 23:22:19.460 (4) [pool-4-thread-2]: spike: SQL->[select t.id, t.description, t.maxJobSize from externalCampaignJobItem i join externalCampaignJobType t on (t.id = i.externalCampaignJobTypeID) where i.externalCampaignJobID is null and t.id in(6) and (unix_timestamp() - unix_timestamp(i.createTime)) > t.initialDelaySec order by i.id asc limit 1] 2013-01-31 23:22:19.461 (4) [pool-4-thread-2]: time=0.0010 2013-01-31 23:22:19.461 (4) [pool-4-thread-2]: Query executed in 0.001s 2013-01-31 23:22:19.461 (3) [pool-4-thread-2]: No new jobs to execute for type: [6] 2013-01-31 23:22:19.461 (4) [pool-4-thread-2]: Finished managing jobs. 2013-01-31 23:22:19.461 (4) [pool-4-thread-2]: Returning Object to Pool 2013-01-31 23:22:38.182 (4) [Timer-12]: LicensingFileRefresher: licensing.properties last modified 1337940573000 2013-01-31 23:22:45.461 (4) [ConnectionCloser]: 1 DatabasePools remaining : 1 pending closure 2013-01-31 23:23:10.446 (4) [Timer-0]: ContentEditorPropertiesRefresher: contenteditor.properties last modified 1337941320000 2013-01-31 23:23:15.461 (4) [ConnectionCloser]: 1 DatabasePools remaining : 1 pending closure 2013-01-31 23:23:38.184 (4) [Timer-12]: LicensingFileRefresher: licensing.properties last modified 1337940573000 2013-01-31 23:23:45.467 (4) [ConnectionCloser]: closing db conn 2013-01-31 23:23:45.469 (4) [ConnectionCloser]: closed [jdbc:mysql://clients-01-write:3306/clients?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2013-01-31 23:23:45.469 (4) [ConnectionCloser]: 1 DatabasePools remaining : 0 pending closure 2013-01-31 23:24:10.452 (4) [Timer-0]: ContentEditorPropertiesRefresher: contenteditor.properties last modified 1337941320000 2013-01-31 23:24:15.467 (4) [ConnectionCloser]: 1 DatabasePools remaining : 0 pending closure 2013-01-31 23:24:15.469 (4) [Thread-9]: Found heartbeat message, adding to low priority message handler 2013-01-31 23:24:15.523 (4) [Thread-11]: LowPriorityMessageHandler handling message ID ID:JBM-49f9d8c3-2645-4eb7-83c4-da25059a7e49 2013-01-31 23:24:15.524 (4) [Thread-11]: onMessage() called 2013-01-31 23:24:15.524 (4) [Thread-11]: handle() called 2013-01-31 23:24:15.524 (4) [Thread-11]: time=0.069 2013-01-31 23:24:15.524 (3) [Thread-11]: Heartbeat #111 (1359635055455) received in 0.069s 2013-01-31 23:24:15.532 (4) [Thread-11]: LowPriorityMessageHandler took message ID ID:JBM-49f9d8c3-2645-4eb7-83c4-da25059a7e49 out of queue 2013-01-31 23:24:38.187 (4) [Timer-12]: LicensingFileRefresher: licensing.properties last modified 1337940573000 2013-01-31 23:24:45.474 (4) [ConnectionCloser]: 0 DatabasePools remaining : 0 pending closure 2013-01-31 23:24:45.474 (4) [ConnectionCloser]: Stopping DatabasePool ConnectionCloserThread 2013-01-31 23:25:10.455 (4) [Timer-0]: ContentEditorPropertiesRefresher: contenteditor.properties last modified 1337941320000 2013-01-31 23:25:38.193 (4) [Timer-12]: LicensingFileRefresher: licensing.properties last modified 1337940573000 2013-01-31 23:26:10.461 (4) [Timer-0]: ContentEditorPropertiesRefresher: contenteditor.properties last modified 1337941320000 2013-01-31 23:26:15.494 (4) [Thread-9]: Found heartbeat message, adding to low priority message handler 2013-01-31 23:26:15.508 (4) [Thread-11]: LowPriorityMessageHandler handling message ID ID:JBM-e83d0386-793c-423f-bea2-9963a9a2b421 2013-01-31 23:26:15.508 (4) [Thread-11]: onMessage() called 2013-01-31 23:26:15.508 (4) [Thread-11]: handle() called 2013-01-31 23:26:15.509 (4) [Thread-11]: time=0.044 2013-01-31 23:26:15.509 (3) [Thread-11]: Heartbeat #112 (1359635175464) received in 0.044s 2013-01-31 23:26:15.517 (4) [Thread-11]: LowPriorityMessageHandler took message ID ID:JBM-e83d0386-793c-423f-bea2-9963a9a2b421 out of queue 2013-01-31 23:26:38.196 (4) [Timer-12]: LicensingFileRefresher: licensing.properties last modified 1337940573000 2013-01-31 23:27:10.463 (4) [Timer-0]: ContentEditorPropertiesRefresher: contenteditor.properties last modified 1337941320000 2013-01-31 23:27:38.202 (4) [Timer-12]: LicensingFileRefresher: licensing.properties last modified 1337940573000 2013-01-31 23:28:10.470 (4) [Timer-0]: ContentEditorPropertiesRefresher: contenteditor.properties last modified 1337941320000 2013-01-31 23:28:15.487 (4) [Thread-9]: Found heartbeat message, adding to low priority message handler 2013-01-31 23:28:15.989 (4) [Thread-11]: LowPriorityMessageHandler handling message ID ID:JBM-ec8d82d2-0c88-437d-b88c-0d1c52f16212 2013-01-31 23:28:15.989 (4) [Thread-11]: onMessage() called 2013-01-31 23:28:15.989 (4) [Thread-11]: handle() called 2013-01-31 23:28:15.989 (4) [Thread-11]: time=0.512 2013-01-31 23:28:15.989 (3) [Thread-11]: Heartbeat #113 (1359635295477) received in 0.512s 2013-01-31 23:28:16.006 (4) [Thread-11]: LowPriorityMessageHandler took message ID ID:JBM-ec8d82d2-0c88-437d-b88c-0d1c52f16212 out of queue 2013-01-31 23:28:38.416 (4) [Timer-12]: LicensingFileRefresher: licensing.properties last modified 1337940573000 2013-01-31 23:29:10.473 (4) [Timer-0]: ContentEditorPropertiesRefresher: contenteditor.properties last modified 1337941320000 2013-01-31 23:29:38.423 (4) [Timer-12]: LicensingFileRefresher: licensing.properties last modified 1337940573000 2013-01-31 23:30:10.479 (4) [Timer-0]: ContentEditorPropertiesRefresher: contenteditor.properties last modified 1337941320000 2013-01-31 23:30:15.558 (4) [Thread-9]: Found heartbeat message, adding to low priority message handler 2013-01-31 23:30:16.002 (4) [Thread-11]: LowPriorityMessageHandler handling message ID ID:JBM-e7ba2437-8957-41c2-979e-11249a894263 2013-01-31 23:30:16.002 (4) [Thread-11]: onMessage() called 2013-01-31 23:30:16.002 (4) [Thread-11]: handle() called 2013-01-31 23:30:16.002 (4) [Thread-11]: time=0.456 2013-01-31 23:30:16.002 (3) [Thread-11]: Heartbeat #114 (1359635415546) received in 0.456s 2013-01-31 23:30:16.012 (4) [Thread-11]: LowPriorityMessageHandler took message ID ID:JBM-e7ba2437-8957-41c2-979e-11249a894263 out of queue 2013-01-31 23:30:38.425 (4) [Timer-12]: LicensingFileRefresher: licensing.properties last modified 1337940573000 2013-01-31 23:31:10.481 (4) [Timer-0]: ContentEditorPropertiesRefresher: contenteditor.properties last modified 1337941320000 2013-01-31 23:31:38.432 (4) [Timer-12]: LicensingFileRefresher: licensing.properties last modified 1337940573000 2013-01-31 23:32:10.488 (4) [Timer-0]: ContentEditorPropertiesRefresher: contenteditor.properties last modified 1337941320000 2013-01-31 23:32:15.508 (4) [pool-4-thread-2]: Start managing jobs... 2013-01-31 23:32:15.508 (4) [pool-4-thread-2]: DataCache: Key global-clients expired. 2013-01-31 23:32:15.508 (4) [pool-4-thread-2]: no account, or instance for databaseInstance, skipping lookup... 2013-01-31 23:32:15.541 (4) [Thread-9]: Found heartbeat message, adding to low priority message handler 2013-01-31 23:32:15.547 (4) [pool-4-thread-2]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2013-01-31 23:32:15.547 (4) [pool-4-thread-2]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`name`="global-clients") and (`type`="mysql")) limit 1] 2013-01-31 23:32:15.548 (4) [pool-4-thread-2]: time=0.0010 2013-01-31 23:32:15.548 (4) [pool-4-thread-2]: Query executed in 0.001s 2013-01-31 23:32:15.548 (4) [pool-4-thread-2]: Record Loaded 2013-01-31 23:32:15.548 (4) [pool-4-thread-2]: DataCache: put key global-clients 2013-01-31 23:32:15.549 (4) [pool-4-thread-2]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2013-01-31 23:32:15.549 (4) [ConnectionCloser]: Starting DatabasePool ConnectionCloserThread 2013-01-31 23:32:15.576 (4) [pool-4-thread-2]: opened [jdbc:mysql://clients-01-write:3306/clients?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2013-01-31 23:32:15.576 (4) [pool-4-thread-2]: Created new Object 2013-01-31 23:32:15.576 (4) [pool-4-thread-2]: spike: SQL->[select @@version] 2013-01-31 23:32:15.577 (4) [pool-4-thread-2]: time=0.0010 2013-01-31 23:32:15.577 (4) [pool-4-thread-2]: Query executed in 0.001s 2013-01-31 23:32:15.577 (4) [pool-4-thread-2]: test query succeeded, returned "5.1.60-rel13.1-log" 2013-01-31 23:32:15.577 (4) [pool-4-thread-2]: spike: SQL->[select id, externalCampaignJobTypeID, tryCount, isFailed, isFinished from externalCampaignJob where isFinished=0 and externalCampaignJobTypeID in (1,2) order by id asc limit 1] 2013-01-31 23:32:15.579 (4) [pool-4-thread-2]: time=0.0020 2013-01-31 23:32:15.579 (4) [pool-4-thread-2]: Query executed in 0.002s 2013-01-31 23:32:15.579 (4) [pool-4-thread-2]: spike: SQL->[select id, externalCampaignJobTypeID, tryCount, isFailed, isFinished from externalCampaignJob where isFinished=0 and externalCampaignJobTypeID in (1,2) order by id asc limit 1] 2013-01-31 23:32:15.580 (4) [pool-4-thread-2]: time=0.0010 2013-01-31 23:32:15.580 (4) [pool-4-thread-2]: Query executed in 0.001s 2013-01-31 23:32:15.580 (4) [pool-4-thread-2]: spike: SQL->[select t.id, t.description, t.maxJobSize from externalCampaignJobItem i join externalCampaignJobType t on (t.id = i.externalCampaignJobTypeID) where i.externalCampaignJobID is null and t.id in(1,2) and (unix_timestamp() - unix_timestamp(i.createTime)) > t.initialDelaySec order by i.id asc limit 1] 2013-01-31 23:32:15.581 (4) [pool-4-thread-2]: time=0.0010 2013-01-31 23:32:15.581 (4) [pool-4-thread-2]: Query executed in 0.001s 2013-01-31 23:32:15.581 (3) [pool-4-thread-2]: No new jobs to execute for type: [1,2] 2013-01-31 23:32:15.581 (4) [pool-4-thread-2]: Finished managing jobs. 2013-01-31 23:32:15.581 (4) [pool-4-thread-2]: Returning Object to Pool 2013-01-31 23:32:15.987 (4) [Thread-11]: LowPriorityMessageHandler handling message ID ID:JBM-7c415b99-901f-41f6-8579-8b077e317063 2013-01-31 23:32:15.987 (4) [Thread-11]: onMessage() called 2013-01-31 23:32:15.987 (4) [Thread-11]: handle() called 2013-01-31 23:32:15.987 (4) [Thread-11]: time=0.478 2013-01-31 23:32:15.987 (3) [Thread-11]: Heartbeat #115 (1359635535509) received in 0.478s 2013-01-31 23:32:16.007 (4) [Thread-11]: LowPriorityMessageHandler took message ID ID:JBM-7c415b99-901f-41f6-8579-8b077e317063 out of queue 2013-01-31 23:32:17.499 (4) [pool-4-thread-2]: Start managing jobs... 2013-01-31 23:32:17.499 (4) [pool-4-thread-2]: DataCache: Found key global-clients 2013-01-31 23:32:17.499 (4) [pool-4-thread-2]: Took Existing Object from Pool 2013-01-31 23:32:17.499 (4) [pool-4-thread-2]: spike: SQL->[select @@version] 2013-01-31 23:32:17.501 (4) [pool-4-thread-2]: time=0.0020 2013-01-31 23:32:17.501 (4) [pool-4-thread-2]: Query executed in 0.002s 2013-01-31 23:32:17.501 (4) [pool-4-thread-2]: test query succeeded, returned "5.1.60-rel13.1-log" 2013-01-31 23:32:17.501 (4) [pool-4-thread-2]: spike: SQL->[select id, externalCampaignJobTypeID, tryCount, isFailed, isFinished from externalCampaignJob where isFinished=0 and externalCampaignJobTypeID in (4) order by id asc limit 1] 2013-01-31 23:32:17.502 (4) [pool-4-thread-2]: time=0.0010 2013-01-31 23:32:17.502 (4) [pool-4-thread-2]: Query executed in 0.001s 2013-01-31 23:32:17.502 (4) [pool-4-thread-2]: spike: SQL->[select id, externalCampaignJobTypeID, tryCount, isFailed, isFinished from externalCampaignJob where isFinished=0 and externalCampaignJobTypeID in (4) order by id asc limit 1] 2013-01-31 23:32:17.503 (4) [pool-4-thread-2]: time=0.0010 2013-01-31 23:32:17.503 (4) [pool-4-thread-2]: Query executed in 0.001s 2013-01-31 23:32:17.503 (4) [pool-4-thread-2]: spike: SQL->[select t.id, t.description, t.maxJobSize from externalCampaignJobItem i join externalCampaignJobType t on (t.id = i.externalCampaignJobTypeID) where i.externalCampaignJobID is null and t.id in(4) and (unix_timestamp() - unix_timestamp(i.createTime)) > t.initialDelaySec order by i.id asc limit 1] 2013-01-31 23:32:17.504 (4) [pool-4-thread-2]: time=0.0010 2013-01-31 23:32:17.504 (4) [pool-4-thread-2]: Query executed in 0.001s 2013-01-31 23:32:17.504 (3) [pool-4-thread-2]: No new jobs to execute for type: [4] 2013-01-31 23:32:17.504 (4) [pool-4-thread-2]: Finished managing jobs. 2013-01-31 23:32:17.504 (4) [pool-4-thread-2]: Returning Object to Pool 2013-01-31 23:32:19.503 (4) [pool-4-thread-1]: Start managing jobs... 2013-01-31 23:32:19.503 (4) [pool-4-thread-1]: DataCache: Found key global-clients 2013-01-31 23:32:19.503 (4) [pool-4-thread-1]: Took Existing Object from Pool 2013-01-31 23:32:19.503 (4) [pool-4-thread-1]: spike: SQL->[select @@version] 2013-01-31 23:32:19.506 (4) [pool-4-thread-1]: time=0.0030 2013-01-31 23:32:19.506 (4) [pool-4-thread-1]: Query executed in 0.003s 2013-01-31 23:32:19.506 (4) [pool-4-thread-1]: test query succeeded, returned "5.1.60-rel13.1-log" 2013-01-31 23:32:19.506 (4) [pool-4-thread-1]: spike: SQL->[select id, externalCampaignJobTypeID, tryCount, isFailed, isFinished from externalCampaignJob where isFinished=0 and externalCampaignJobTypeID in (6) order by id asc limit 1] 2013-01-31 23:32:19.507 (4) [pool-4-thread-1]: time=0.0010 2013-01-31 23:32:19.507 (4) [pool-4-thread-1]: Query executed in 0.001s 2013-01-31 23:32:19.507 (4) [pool-4-thread-1]: spike: SQL->[select id, externalCampaignJobTypeID, tryCount, isFailed, isFinished from externalCampaignJob where isFinished=0 and externalCampaignJobTypeID in (6) order by id asc limit 1] 2013-01-31 23:32:19.507 (4) [pool-4-thread-1]: time=0.0 2013-01-31 23:32:19.507 (4) [pool-4-thread-1]: Query executed in 0.000s 2013-01-31 23:32:19.508 (4) [pool-4-thread-1]: spike: SQL->[select t.id, t.description, t.maxJobSize from externalCampaignJobItem i join externalCampaignJobType t on (t.id = i.externalCampaignJobTypeID) where i.externalCampaignJobID is null and t.id in(6) and (unix_timestamp() - unix_timestamp(i.createTime)) > t.initialDelaySec order by i.id asc limit 1] 2013-01-31 23:32:19.509 (4) [pool-4-thread-1]: time=0.0020 2013-01-31 23:32:19.509 (4) [pool-4-thread-1]: Query executed in 0.002s 2013-01-31 23:32:19.509 (4) [pool-4-thread-1]: preparing SQL statement [insert into externalCampaignJob (externalCampaignJobTypeID, tryCount, isFailed, isFinished, startTime) values(?,?,?,?, now())], genflags=yes 2013-01-31 23:32:19.511 (4) [pool-4-thread-1]: preparing SQL statement [update externalCampaignJobItem i set i.externalCampaignJobID = ? where i.externalCampaignJobTypeID=? and i.externalCampaignJobID is null and (select case when (unix_timestamp() - unix_timestamp(i.createTime)) > t.initialDelaySec then 1 else 0 end from externalCampaignJobType t where t.id = i.externalCampaignJobTypeID) = 1 order by i.id asc limit ?] 2013-01-31 23:32:19.514 (3) [pool-4-thread-1]: Created new job: ID: 31 jobTypeID 6 tryCount: 1 isFailed: false isFinished: false 2013-01-31 23:32:19.514 (3) [pool-4-thread-1]: Executing job: ID: 31 jobTypeID 6 tryCount: 1 isFailed: false isFinished: false 2013-01-31 23:32:19.514 (4) [pool-4-thread-1]: no account, or instance for databaseInstance, skipping lookup... 2013-01-31 23:32:19.524 (4) [pool-4-thread-1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2013-01-31 23:32:19.524 (4) [pool-4-thread-1]: Created new Object 2013-01-31 23:32:19.524 (4) [pool-4-thread-1]: spike: SQL->[select @@version] 2013-01-31 23:32:19.525 (4) [pool-4-thread-1]: time=0.0010 2013-01-31 23:32:19.525 (4) [pool-4-thread-1]: Query executed in 0.001s 2013-01-31 23:32:19.525 (4) [pool-4-thread-1]: test query succeeded, returned "5.1.60-rel13.1-log" 2013-01-31 23:32:19.525 (4) [pool-4-thread-1]: preparing SQL statement [select c.id, c.externalCampaignParentID, c.gceCampaignID, c.searchEngineAccountID, c.accountID, c.enabled from externalCampaign c join externalCampaignJobItem j on (c.id = j.externalCampaignID) where j.externalCampaignJobTypeID =? and j.externalCampaignJobID = ? ] 2013-01-31 23:32:19.527 (3) [pool-4-thread-1]: 3 campaigns for job externalCampaignJob-6-31 2013-01-31 23:32:19.527 (4) [pool-4-thread-1]: preparing SQL statement [select id, description, accountID, admaxCampaignID, status, typeID from clients.externalCampaignParent where id = ?] 2013-01-31 23:32:19.528 (3) [pool-4-thread-1]: Using parent in job...[15site-1_GM->15site-1] 2013-01-31 23:32:19.528 (4) [pool-4-thread-1]: preparing SQL statement [select id, description, accountID, admaxCampaignID, status, typeID from clients.externalCampaignParent where id = ?] 2013-01-31 23:32:19.529 (3) [pool-4-thread-1]: Using parent in job...[15site-1_GT->15site-1] 2013-01-31 23:32:19.529 (4) [pool-4-thread-1]: preparing SQL statement [select id, description, accountID, admaxCampaignID, status, typeID from clients.externalCampaignParent where id = ?] 2013-01-31 23:32:19.530 (3) [pool-4-thread-1]: Using parent in job...[15site-1_MO->15site-1] 2013-01-31 23:32:19.531 (4) [pool-4-thread-1]: spike: SQL->[select * from `tsacommon`.`accounts` where (`id`=6313) limit 1] 2013-01-31 23:32:19.532 (4) [pool-4-thread-1]: time=0.0010 2013-01-31 23:32:19.532 (4) [pool-4-thread-1]: Query executed in 0.001s 2013-01-31 23:32:19.532 (4) [pool-4-thread-1]: Record Loaded 2013-01-31 23:32:19.532 (3) [pool-4-thread-1]: -------- Updating account 99999999-959595959 (6313) 2013-01-31 23:32:19.532 (3) [pool-4-thread-1]: Fetching data from SMB Callback Service for account 99999999-959595959 2013-01-31 23:32:19.532 (3) [pool-4-thread-1]: Fetching account info for 6313 2013-01-31 23:32:19.532 (4) [pool-4-thread-1]: DataCache: Found key global-clients 2013-01-31 23:32:19.541 (4) [pool-4-thread-1]: opened [jdbc:mysql://clients-01-write:3306/clients?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2013-01-31 23:32:19.541 (4) [pool-4-thread-1]: Created new Object 2013-01-31 23:32:19.541 (4) [pool-4-thread-1]: spike: SQL->[select @@version] 2013-01-31 23:32:19.543 (4) [pool-4-thread-1]: time=0.0020 2013-01-31 23:32:19.543 (4) [pool-4-thread-1]: Query executed in 0.002s 2013-01-31 23:32:19.543 (4) [pool-4-thread-1]: test query succeeded, returned "5.1.60-rel13.1-log" 2013-01-31 23:32:19.543 (4) [pool-4-thread-1]: spike: SQL->[select * from `tsacommon`.`accounts` where (`id`=6313) limit 1] 2013-01-31 23:32:19.545 (4) [pool-4-thread-1]: time=0.0020 2013-01-31 23:32:19.545 (4) [pool-4-thread-1]: Query executed in 0.002s 2013-01-31 23:32:19.545 (4) [pool-4-thread-1]: Record Loaded 2013-01-31 23:32:19.552 (3) [pool-4-thread-1]: Queue worker session created. 2013-01-31 23:32:20.200 (4) [pool-4-thread-1]: Returning Object to Pool 2013-01-31 23:32:20.200 (4) [pool-4-thread-1]: no account, or instance for databaseInstance, skipping lookup... 2013-01-31 23:32:20.212 (4) [pool-4-thread-1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2013-01-31 23:32:20.212 (4) [pool-4-thread-1]: Created new Object 2013-01-31 23:32:20.212 (4) [pool-4-thread-1]: spike: SQL->[select @@version] 2013-01-31 23:32:20.213 (4) [pool-4-thread-1]: time=0.0010 2013-01-31 23:32:20.213 (4) [pool-4-thread-1]: Query executed in 0.001s 2013-01-31 23:32:20.213 (4) [pool-4-thread-1]: test query succeeded, returned "5.1.60-rel13.1-log" 2013-01-31 23:32:20.213 (4) [pool-4-thread-1]: DataCache: Found key global-clients 2013-01-31 23:32:20.213 (4) [pool-4-thread-1]: Took Existing Object from Pool 2013-01-31 23:32:20.213 (4) [pool-4-thread-1]: spike: SQL->[select @@version] 2013-01-31 23:32:20.214 (4) [pool-4-thread-1]: time=0.0010 2013-01-31 23:32:20.214 (4) [pool-4-thread-1]: Query executed in 0.001s 2013-01-31 23:32:20.214 (4) [pool-4-thread-1]: test query succeeded, returned "5.1.60-rel13.1-log" 2013-01-31 23:32:20.214 (4) [pool-4-thread-1]: spike: SQL->[SELECT GET_LOCK('com.thesearchagency.admaxlistener.dao.TSACommonDAO.99999999-959595959', 7200)] 2013-01-31 23:32:20.215 (4) [pool-4-thread-1]: time=0.0010 2013-01-31 23:32:20.215 (4) [pool-4-thread-1]: Query executed in 0.001s 2013-01-31 23:32:20.215 (4) [pool-4-thread-1]: spike: SQL->[select * from `tsacommon`.`accounts` where ((`description`="99999999-959595959")) limit 1] 2013-01-31 23:32:20.216 (4) [pool-4-thread-1]: time=0.0010 2013-01-31 23:32:20.216 (4) [pool-4-thread-1]: Query executed in 0.001s 2013-01-31 23:32:20.216 (4) [pool-4-thread-1]: Record Loaded 2013-01-31 23:32:20.258 (4) [pool-4-thread-1]: DataCache: Key acct-st-tracker 6313 expired. 2013-01-31 23:32:20.258 (4) [pool-4-thread-1]: no account, or instance for databaseInstance, skipping lookup... 2013-01-31 23:32:20.267 (4) [pool-4-thread-1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2013-01-31 23:32:20.267 (4) [pool-4-thread-1]: spike: SQL->[select * from `tsacommon`.`accounts` where (`id`=6313) limit 1] 2013-01-31 23:32:20.268 (4) [pool-4-thread-1]: time=0.0010 2013-01-31 23:32:20.268 (4) [pool-4-thread-1]: Query executed in 0.001s 2013-01-31 23:32:20.268 (4) [pool-4-thread-1]: Record Loaded 2013-01-31 23:32:20.268 (4) [pool-4-thread-1]: DataCache: put key acct-st-tracker 6313 2013-01-31 23:32:20.268 (4) [pool-4-thread-1]: DataCache: Key acct-st-tracker-1 expired. 2013-01-31 23:32:20.268 (4) [pool-4-thread-1]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`name`="acct-st-tracker-1") and (`type`="mysql")) limit 1] 2013-01-31 23:32:20.269 (4) [pool-4-thread-1]: time=0.0010 2013-01-31 23:32:20.269 (4) [pool-4-thread-1]: Query executed in 0.001s 2013-01-31 23:32:20.270 (4) [pool-4-thread-1]: Record Loaded 2013-01-31 23:32:20.270 (4) [pool-4-thread-1]: DataCache: put key acct-st-tracker-1 2013-01-31 23:32:20.270 (4) [pool-4-thread-1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2013-01-31 23:32:20.280 (4) [pool-4-thread-1]: opened [jdbc:mysql://acctdb-01-write:3307/st-tracker?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2013-01-31 23:32:20.280 (4) [pool-4-thread-1]: Created new Object 2013-01-31 23:32:20.280 (4) [pool-4-thread-1]: spike: SQL->[select @@version] 2013-01-31 23:32:20.281 (4) [pool-4-thread-1]: time=0.0010 2013-01-31 23:32:20.281 (4) [pool-4-thread-1]: Query executed in 0.001s 2013-01-31 23:32:20.281 (4) [pool-4-thread-1]: test query succeeded, returned "5.1.60-rel13.1" 2013-01-31 23:32:20.281 (4) [pool-4-thread-1]: preparing SQL statement [select id from clients.externalCampaignParent where typeID = ? and accountID = ? and status != ?] 2013-01-31 23:32:20.283 (4) [pool-4-thread-1]: preparing SQL statement [select admaxNominalMonthlyBudgets.ID,admaxCampaignID,startDate,endDate,budget from `st-tracker`.admaxCampaigns join `st-tracker`.admaxNominalMonthlyBudgets on admaxCampaigns.ID=admaxNominalMonthlyBudgets.admaxCampaignID where accountID=? and startDate<=? and (endDate is null or endDate>=?)] 2013-01-31 23:32:20.284 (4) [pool-4-thread-1]: No budget changes 2013-01-31 23:32:20.284 (4) [pool-4-thread-1]: preparing SQL statement [select id, description, accountID, admaxCampaignID, status, typeID from clients.externalCampaignParent where accountID = ? and typeID=1] 2013-01-31 23:32:20.286 (1) [pool-4-thread-1]: Exception [Unhandled exception, failing request]:java.lang.NullPointerException at com.thesearchagency.admaxlistener.worker.RequestWorker.preProcessCampaigns(RequestWorker.java:759) at com.thesearchagency.admaxlistener.worker.RequestWorker.processRequest(RequestWorker.java:507) at com.thesearchagency.admaxlistener.worker.RequestWorker.call(RequestWorker.java:193) at com.thesearchagency.admaxlistener.task.ExternalCampaignTaskDeploy.processAccount(ExternalCampaignTaskDeploy.java:66) at com.thesearchagency.admaxlistener.task.ExternalCampaignTaskDeploy.executeJob(ExternalCampaignTaskDeploy.java:131) at com.thesearchagency.admaxlistener.task.ExternalCampaignTask.manageJobs(ExternalCampaignTask.java:427) at com.thesearchagency.admaxlistener.task.ExternalCampaignTask.run(ExternalCampaignTask.java:217) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:317) at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:150) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:98) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:180) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:204) 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) 2013-01-31 23:32:20.287 (4) [pool-4-thread-1]: DataCache: Found key global-clients 2013-01-31 23:32:20.297 (4) [pool-4-thread-1]: opened [jdbc:mysql://clients-01-write:3306/clients?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2013-01-31 23:32:20.297 (4) [pool-4-thread-1]: Created new Object 2013-01-31 23:32:20.298 (4) [pool-4-thread-1]: spike: SQL->[select @@version] 2013-01-31 23:32:20.298 (4) [pool-4-thread-1]: time=0.0010 2013-01-31 23:32:20.299 (4) [pool-4-thread-1]: Query executed in 0.001s 2013-01-31 23:32:20.299 (4) [pool-4-thread-1]: test query succeeded, returned "5.1.60-rel13.1-log" 2013-01-31 23:32:20.299 (2) [pool-4-thread-1]: No parent result for 15site-1, using message result. 2013-01-31 23:32:20.299 (3) [pool-4-thread-1]: Updating deployment status to 'Failure' for campaignID: 15site-1 2013-01-31 23:32:20.299 (4) [pool-4-thread-1]: preparing SQL statement [update clients.externalCampaignParentDeployStatus set status = ? where description = ?] 2013-01-31 23:32:20.301 (3) [pool-4-thread-1]: Finished UPDATE request for 15site-1: FAILED 2013-01-31 23:32:20.301 (3) [pool-4-thread-1]: Finished UPDATE request, deploymentID (WLVrgbIdFCuA28C4A2VK), account 99999999-959595959 2013-01-31 23:32:20.301 (3) [pool-4-thread-1]: Request removed from map for customerID 99999999-959595959 2013-01-31 23:32:20.301 (4) [pool-4-thread-1]: spike: SQL->[SELECT RELEASE_LOCK('com.thesearchagency.admaxlistener.dao.TSACommonDAO.99999999-959595959')] 2013-01-31 23:32:20.302 (4) [pool-4-thread-1]: time=0.0010 2013-01-31 23:32:20.302 (4) [pool-4-thread-1]: Query executed in 0.001s 2013-01-31 23:32:20.302 (4) [pool-4-thread-1]: Released account lock: 99999999-959595959 2013-01-31 23:32:20.302 (4) [pool-4-thread-1]: Returning Object to Pool 2013-01-31 23:32:20.302 (4) [pool-4-thread-1]: Returning Object to Pool 2013-01-31 23:32:20.302 (4) [pool-4-thread-1]: Returning Object to Pool 2013-01-31 23:32:20.302 (4) [pool-4-thread-1]: Returning Object to Pool 2013-01-31 23:32:20.302 (3) [pool-4-thread-1]: Queue worker close() called. 2013-01-31 23:32:20.309 (3) [pool-4-thread-1]: Queue worker tmp queue deleted. 2013-01-31 23:32:20.310 (3) [pool-4-thread-1]: Queue worker session closed. 2013-01-31 23:32:20.310 (1) [pool-4-thread-1]: Error while managing jobs: ID: 31 jobTypeID 6 tryCount: 1 isFailed: false isFinished: false account 6313 failed. 2013-01-31 23:32:20.310 (4) [pool-4-thread-1]: Returning Object to Pool 2013-01-31 23:32:38.434 (4) [Timer-12]: LicensingFileRefresher: licensing.properties last modified 1337940573000 2013-01-31 23:32:45.565 (4) [ConnectionCloser]: 3 DatabasePools remaining : 5 pending closure 2013-01-31 23:33:10.490 (4) [Timer-0]: ContentEditorPropertiesRefresher: contenteditor.properties last modified 1337941320000 2013-01-31 23:33:15.566 (4) [ConnectionCloser]: 3 DatabasePools remaining : 5 pending closure 2013-01-31 23:33:38.441 (4) [Timer-12]: LicensingFileRefresher: licensing.properties last modified 1337940573000 2013-01-31 23:33:45.572 (4) [ConnectionCloser]: closing db conn 2013-01-31 23:33:45.573 (4) [ConnectionCloser]: closed [jdbc:mysql://clients-01-write:3306/clients?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2013-01-31 23:33:45.573 (4) [ConnectionCloser]: closing db conn 2013-01-31 23:33:45.573 (4) [ConnectionCloser]: closed [jdbc:mysql://clients-01-write:3306/clients?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2013-01-31 23:33:45.573 (4) [ConnectionCloser]: closing db conn 2013-01-31 23:33:45.574 (4) [ConnectionCloser]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2013-01-31 23:33:45.574 (4) [ConnectionCloser]: closing db conn 2013-01-31 23:33:45.575 (4) [ConnectionCloser]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2013-01-31 23:33:45.575 (4) [ConnectionCloser]: closing db conn 2013-01-31 23:33:45.576 (4) [ConnectionCloser]: closed [jdbc:mysql://acctdb-01-write:3307/st-tracker?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2013-01-31 23:33:45.576 (4) [ConnectionCloser]: 3 DatabasePools remaining : 0 pending closure 2013-01-31 23:34:10.493 (4) [Timer-0]: ContentEditorPropertiesRefresher: contenteditor.properties last modified 1337941320000 2013-01-31 23:34:15.525 (4) [Thread-9]: Found heartbeat message, adding to low priority message handler 2013-01-31 23:34:15.576 (4) [ConnectionCloser]: 3 DatabasePools remaining : 0 pending closure 2013-01-31 23:34:15.964 (4) [Thread-11]: LowPriorityMessageHandler handling message ID ID:JBM-83030a0e-fd25-4c19-af7c-ee308e8f0365 2013-01-31 23:34:15.964 (4) [Thread-11]: onMessage() called 2013-01-31 23:34:15.964 (4) [Thread-11]: handle() called 2013-01-31 23:34:15.964 (4) [Thread-11]: time=0.448 2013-01-31 23:34:15.964 (3) [Thread-11]: Heartbeat #116 (1359635655516) received in 0.448s 2013-01-31 23:34:15.973 (4) [Thread-11]: LowPriorityMessageHandler took message ID ID:JBM-83030a0e-fd25-4c19-af7c-ee308e8f0365 out of queue 2013-01-31 23:34:38.443 (4) [Timer-12]: LicensingFileRefresher: licensing.properties last modified 1337940573000 2013-01-31 23:34:45.594 (4) [ConnectionCloser]: 0 DatabasePools remaining : 0 pending closure 2013-01-31 23:34:45.594 (4) [ConnectionCloser]: Stopping DatabasePool ConnectionCloserThread 2013-01-31 23:35:10.495 (4) [Timer-0]: ContentEditorPropertiesRefresher: contenteditor.properties last modified 1337941320000 2013-01-31 23:35:38.446 (4) [Timer-12]: LicensingFileRefresher: licensing.properties last modified 1337940573000 2013-01-31 23:36:10.502 (4) [Timer-0]: ContentEditorPropertiesRefresher: contenteditor.properties last modified 1337941320000 2013-01-31 23:36:15.532 (4) [Thread-9]: Found heartbeat message, adding to low priority message handler 2013-01-31 23:36:15.945 (4) [Thread-11]: LowPriorityMessageHandler handling message ID ID:JBM-4e86c284-ea1d-4572-96db-e91bc5986d16 2013-01-31 23:36:15.945 (4) [Thread-11]: onMessage() called 2013-01-31 23:36:15.945 (4) [Thread-11]: handle() called 2013-01-31 23:36:15.945 (4) [Thread-11]: time=0.424 2013-01-31 23:36:15.945 (3) [Thread-11]: Heartbeat #117 (1359635775521) received in 0.424s 2013-01-31 23:36:16.043 (4) [Thread-11]: LowPriorityMessageHandler took message ID ID:JBM-4e86c284-ea1d-4572-96db-e91bc5986d16 out of queue 2013-01-31 23:36:38.448 (4) [Timer-12]: LicensingFileRefresher: licensing.properties last modified 1337940573000 2013-01-31 23:37:10.504 (4) [Timer-0]: ContentEditorPropertiesRefresher: contenteditor.properties last modified 1337941320000 2013-01-31 23:37:38.451 (4) [Timer-12]: LicensingFileRefresher: licensing.properties last modified 1337940573000 2013-01-31 23:38:10.507 (4) [Timer-0]: ContentEditorPropertiesRefresher: contenteditor.properties last modified 1337941320000 2013-01-31 23:38:15.604 (4) [Thread-9]: Found heartbeat message, adding to low priority message handler 2013-01-31 23:38:16.042 (4) [Thread-11]: LowPriorityMessageHandler handling message ID ID:JBM-c6e30173-5172-4d17-b197-468f0d7c3ee8 2013-01-31 23:38:16.042 (4) [Thread-11]: onMessage() called 2013-01-31 23:38:16.042 (4) [Thread-11]: handle() called 2013-01-31 23:38:16.042 (4) [Thread-11]: time=0.448 2013-01-31 23:38:16.042 (3) [Thread-11]: Heartbeat #118 (1359635895594) received in 0.448s 2013-01-31 23:38:16.052 (4) [Thread-11]: LowPriorityMessageHandler took message ID ID:JBM-c6e30173-5172-4d17-b197-468f0d7c3ee8 out of queue 2013-01-31 23:38:38.453 (4) [Timer-12]: LicensingFileRefresher: licensing.properties last modified 1337940573000 2013-01-31 23:39:10.513 (4) [Timer-0]: ContentEditorPropertiesRefresher: contenteditor.properties last modified 1337941320000 2013-01-31 23:39:38.456 (4) [Timer-12]: LicensingFileRefresher: licensing.properties last modified 1337940573000 2013-01-31 23:40:10.516 (4) [Timer-0]: ContentEditorPropertiesRefresher: contenteditor.properties last modified 1337941320000 2013-01-31 23:40:15.635 (4) [Thread-9]: Found heartbeat message, adding to low priority message handler 2013-01-31 23:40:16.023 (4) [Thread-11]: LowPriorityMessageHandler handling message ID ID:JBM-a351ac69-e58a-450f-be6b-0e3c34e4bb99 2013-01-31 23:40:16.023 (4) [Thread-11]: onMessage() called 2013-01-31 23:40:16.023 (4) [Thread-11]: handle() called 2013-01-31 23:40:16.023 (4) [Thread-11]: time=0.416 2013-01-31 23:40:16.023 (3) [Thread-11]: Heartbeat #119 (1359636015607) received in 0.416s 2013-01-31 23:40:16.049 (4) [Thread-11]: LowPriorityMessageHandler took message ID ID:JBM-a351ac69-e58a-450f-be6b-0e3c34e4bb99 out of queue 2013-01-31 23:40:38.462 (4) [Timer-12]: LicensingFileRefresher: licensing.properties last modified 1337940573000 2013-01-31 23:41:10.522 (4) [Timer-0]: ContentEditorPropertiesRefresher: contenteditor.properties last modified 1337941320000 2013-01-31 23:41:38.465 (4) [Timer-12]: LicensingFileRefresher: licensing.properties last modified 1337940573000 2013-01-31 23:42:10.525 (4) [Timer-0]: ContentEditorPropertiesRefresher: contenteditor.properties last modified 1337941320000 2013-01-31 23:42:15.560 (4) [pool-4-thread-1]: Start managing jobs... 2013-01-31 23:42:15.560 (4) [pool-4-thread-1]: DataCache: Key global-clients expired. 2013-01-31 23:42:15.560 (4) [pool-4-thread-1]: no account, or instance for databaseInstance, skipping lookup... 2013-01-31 23:42:15.571 (4) [pool-4-thread-1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2013-01-31 23:42:15.571 (4) [Thread-9]: Found heartbeat message, adding to low priority message handler 2013-01-31 23:42:15.571 (4) [pool-4-thread-1]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`name`="global-clients") and (`type`="mysql")) limit 1] 2013-01-31 23:42:15.572 (4) [pool-4-thread-1]: time=0.0010 2013-01-31 23:42:15.572 (4) [pool-4-thread-1]: Query executed in 0.001s 2013-01-31 23:42:15.572 (4) [pool-4-thread-1]: Record Loaded 2013-01-31 23:42:15.572 (4) [pool-4-thread-1]: DataCache: put key global-clients 2013-01-31 23:42:15.572 (4) [pool-4-thread-1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2013-01-31 23:42:15.573 (4) [ConnectionCloser]: Starting DatabasePool ConnectionCloserThread 2013-01-31 23:42:15.583 (4) [pool-4-thread-1]: opened [jdbc:mysql://clients-01-write:3306/clients?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2013-01-31 23:42:15.583 (4) [pool-4-thread-1]: Created new Object 2013-01-31 23:42:15.583 (4) [pool-4-thread-1]: spike: SQL->[select @@version] 2013-01-31 23:42:15.584 (4) [pool-4-thread-1]: time=0.0010 2013-01-31 23:42:15.584 (4) [pool-4-thread-1]: Query executed in 0.001s 2013-01-31 23:42:15.584 (4) [pool-4-thread-1]: test query succeeded, returned "5.1.60-rel13.1-log" 2013-01-31 23:42:15.584 (4) [pool-4-thread-1]: spike: SQL->[select id, externalCampaignJobTypeID, tryCount, isFailed, isFinished from externalCampaignJob where isFinished=0 and externalCampaignJobTypeID in (1,2) order by id asc limit 1] 2013-01-31 23:42:15.586 (4) [pool-4-thread-1]: time=0.0010 2013-01-31 23:42:15.586 (4) [pool-4-thread-1]: Query executed in 0.001s 2013-01-31 23:42:15.586 (4) [pool-4-thread-1]: spike: SQL->[select id, externalCampaignJobTypeID, tryCount, isFailed, isFinished from externalCampaignJob where isFinished=0 and externalCampaignJobTypeID in (1,2) order by id asc limit 1] 2013-01-31 23:42:15.586 (4) [pool-4-thread-1]: time=0.0 2013-01-31 23:42:15.586 (4) [pool-4-thread-1]: Query executed in 0.000s 2013-01-31 23:42:15.586 (4) [pool-4-thread-1]: spike: SQL->[select t.id, t.description, t.maxJobSize from externalCampaignJobItem i join externalCampaignJobType t on (t.id = i.externalCampaignJobTypeID) where i.externalCampaignJobID is null and t.id in(1,2) and (unix_timestamp() - unix_timestamp(i.createTime)) > t.initialDelaySec order by i.id asc limit 1] 2013-01-31 23:42:15.588 (4) [pool-4-thread-1]: time=0.0020 2013-01-31 23:42:15.588 (4) [pool-4-thread-1]: Query executed in 0.002s 2013-01-31 23:42:15.588 (3) [pool-4-thread-1]: No new jobs to execute for type: [1,2] 2013-01-31 23:42:15.588 (4) [pool-4-thread-1]: Finished managing jobs. 2013-01-31 23:42:15.588 (4) [pool-4-thread-1]: Returning Object to Pool 2013-01-31 23:42:16.004 (4) [Thread-11]: LowPriorityMessageHandler handling message ID ID:JBM-c0056183-c9c0-47b5-8728-cb639cb1bdae 2013-01-31 23:42:16.004 (4) [Thread-11]: onMessage() called 2013-01-31 23:42:16.004 (4) [Thread-11]: handle() called 2013-01-31 23:42:16.004 (4) [Thread-11]: time=0.444 2013-01-31 23:42:16.004 (3) [Thread-11]: Heartbeat #120 (1359636135560) received in 0.444s 2013-01-31 23:42:16.014 (4) [Thread-11]: LowPriorityMessageHandler took message ID ID:JBM-c0056183-c9c0-47b5-8728-cb639cb1bdae out of queue 2013-01-31 23:42:17.560 (4) [pool-4-thread-2]: Start managing jobs... 2013-01-31 23:42:17.560 (4) [pool-4-thread-2]: DataCache: Found key global-clients 2013-01-31 23:42:17.560 (4) [pool-4-thread-2]: Took Existing Object from Pool 2013-01-31 23:42:17.560 (4) [pool-4-thread-2]: spike: SQL->[select @@version] 2013-01-31 23:42:17.563 (4) [pool-4-thread-2]: time=0.0030 2013-01-31 23:42:17.563 (4) [pool-4-thread-2]: Query executed in 0.003s 2013-01-31 23:42:17.563 (4) [pool-4-thread-2]: test query succeeded, returned "5.1.60-rel13.1-log" 2013-01-31 23:42:17.563 (4) [pool-4-thread-2]: spike: SQL->[select id, externalCampaignJobTypeID, tryCount, isFailed, isFinished from externalCampaignJob where isFinished=0 and externalCampaignJobTypeID in (4) order by id asc limit 1] 2013-01-31 23:42:17.564 (4) [pool-4-thread-2]: time=0.0010 2013-01-31 23:42:17.564 (4) [pool-4-thread-2]: Query executed in 0.001s 2013-01-31 23:42:17.564 (4) [pool-4-thread-2]: spike: SQL->[select id, externalCampaignJobTypeID, tryCount, isFailed, isFinished from externalCampaignJob where isFinished=0 and externalCampaignJobTypeID in (4) order by id asc limit 1] 2013-01-31 23:42:17.565 (4) [pool-4-thread-2]: time=0.0010 2013-01-31 23:42:17.565 (4) [pool-4-thread-2]: Query executed in 0.001s 2013-01-31 23:42:17.565 (4) [pool-4-thread-2]: spike: SQL->[select t.id, t.description, t.maxJobSize from externalCampaignJobItem i join externalCampaignJobType t on (t.id = i.externalCampaignJobTypeID) where i.externalCampaignJobID is null and t.id in(4) and (unix_timestamp() - unix_timestamp(i.createTime)) > t.initialDelaySec order by i.id asc limit 1] 2013-01-31 23:42:17.566 (4) [pool-4-thread-2]: time=0.0010 2013-01-31 23:42:17.566 (4) [pool-4-thread-2]: Query executed in 0.001s 2013-01-31 23:42:17.566 (3) [pool-4-thread-2]: No new jobs to execute for type: [4] 2013-01-31 23:42:17.566 (4) [pool-4-thread-2]: Finished managing jobs. 2013-01-31 23:42:17.567 (4) [pool-4-thread-2]: Returning Object to Pool 2013-01-31 23:42:19.559 (4) [pool-4-thread-2]: Start managing jobs... 2013-01-31 23:42:19.559 (4) [pool-4-thread-2]: DataCache: Found key global-clients 2013-01-31 23:42:19.559 (4) [pool-4-thread-2]: Took Existing Object from Pool 2013-01-31 23:42:19.559 (4) [pool-4-thread-2]: spike: SQL->[select @@version] 2013-01-31 23:42:19.561 (4) [pool-4-thread-2]: time=0.0020 2013-01-31 23:42:19.561 (4) [pool-4-thread-2]: Query executed in 0.002s 2013-01-31 23:42:19.561 (4) [pool-4-thread-2]: test query succeeded, returned "5.1.60-rel13.1-log" 2013-01-31 23:42:19.561 (4) [pool-4-thread-2]: spike: SQL->[select id, externalCampaignJobTypeID, tryCount, isFailed, isFinished from externalCampaignJob where isFinished=0 and externalCampaignJobTypeID in (6) order by id asc limit 1] 2013-01-31 23:42:19.562 (4) [pool-4-thread-2]: time=0.0010 2013-01-31 23:42:19.562 (4) [pool-4-thread-2]: Query executed in 0.001s 2013-01-31 23:42:19.562 (3) [pool-4-thread-2]: Retrying job ID: 31 jobTypeID 6 tryCount: 2 isFailed: false isFinished: false 2013-01-31 23:42:19.562 (4) [pool-4-thread-2]: preparing SQL statement [update externalCampaignJob set trycount=?, isFailed=?, isFinished=? where id=?] 2013-01-31 23:42:19.579 (3) [pool-4-thread-2]: Executing job: ID: 31 jobTypeID 6 tryCount: 2 isFailed: false isFinished: false 2013-01-31 23:42:19.579 (4) [pool-4-thread-2]: no account, or instance for databaseInstance, skipping lookup... 2013-01-31 23:42:19.588 (4) [pool-4-thread-2]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2013-01-31 23:42:19.588 (4) [pool-4-thread-2]: Created new Object 2013-01-31 23:42:19.588 (4) [pool-4-thread-2]: spike: SQL->[select @@version] 2013-01-31 23:42:19.589 (4) [pool-4-thread-2]: time=0.0010 2013-01-31 23:42:19.589 (4) [pool-4-thread-2]: Query executed in 0.001s 2013-01-31 23:42:19.589 (4) [pool-4-thread-2]: test query succeeded, returned "5.1.60-rel13.1-log" 2013-01-31 23:42:19.589 (4) [pool-4-thread-2]: preparing SQL statement [select c.id, c.externalCampaignParentID, c.gceCampaignID, c.searchEngineAccountID, c.accountID, c.enabled from externalCampaign c join externalCampaignJobItem j on (c.id = j.externalCampaignID) where j.externalCampaignJobTypeID =? and j.externalCampaignJobID = ? ] 2013-01-31 23:42:19.590 (3) [pool-4-thread-2]: 3 campaigns for job externalCampaignJob-6-31 2013-01-31 23:42:19.590 (4) [pool-4-thread-2]: preparing SQL statement [select id, description, accountID, admaxCampaignID, status, typeID from clients.externalCampaignParent where id = ?] 2013-01-31 23:42:19.592 (3) [pool-4-thread-2]: Using parent in job...[15site-1_GM->15site-1] 2013-01-31 23:42:19.592 (4) [pool-4-thread-2]: preparing SQL statement [select id, description, accountID, admaxCampaignID, status, typeID from clients.externalCampaignParent where id = ?] 2013-01-31 23:42:19.593 (3) [pool-4-thread-2]: Using parent in job...[15site-1_GT->15site-1] 2013-01-31 23:42:19.593 (4) [pool-4-thread-2]: preparing SQL statement [select id, description, accountID, admaxCampaignID, status, typeID from clients.externalCampaignParent where id = ?] 2013-01-31 23:42:19.594 (3) [pool-4-thread-2]: Using parent in job...[15site-1_MO->15site-1] 2013-01-31 23:42:19.594 (4) [pool-4-thread-2]: spike: SQL->[select * from `tsacommon`.`accounts` where (`id`=6313) limit 1] 2013-01-31 23:42:19.595 (4) [pool-4-thread-2]: time=0.0010 2013-01-31 23:42:19.595 (4) [pool-4-thread-2]: Query executed in 0.001s 2013-01-31 23:42:19.595 (4) [pool-4-thread-2]: Record Loaded 2013-01-31 23:42:19.595 (3) [pool-4-thread-2]: -------- Updating account 99999999-959595959 (6313) 2013-01-31 23:42:19.595 (3) [pool-4-thread-2]: Fetching data from SMB Callback Service for account 99999999-959595959 2013-01-31 23:42:19.595 (3) [pool-4-thread-2]: Fetching account info for 6313 2013-01-31 23:42:19.595 (4) [pool-4-thread-2]: DataCache: Found key global-clients 2013-01-31 23:42:19.604 (4) [pool-4-thread-2]: opened [jdbc:mysql://clients-01-write:3306/clients?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2013-01-31 23:42:19.604 (4) [pool-4-thread-2]: Created new Object 2013-01-31 23:42:19.604 (4) [pool-4-thread-2]: spike: SQL->[select @@version] 2013-01-31 23:42:19.605 (4) [pool-4-thread-2]: time=0.0010 2013-01-31 23:42:19.605 (4) [pool-4-thread-2]: Query executed in 0.001s 2013-01-31 23:42:19.605 (4) [pool-4-thread-2]: test query succeeded, returned "5.1.60-rel13.1-log" 2013-01-31 23:42:19.605 (4) [pool-4-thread-2]: spike: SQL->[select * from `tsacommon`.`accounts` where (`id`=6313) limit 1] 2013-01-31 23:42:19.606 (4) [pool-4-thread-2]: time=0.0010 2013-01-31 23:42:19.606 (4) [pool-4-thread-2]: Query executed in 0.001s 2013-01-31 23:42:19.606 (4) [pool-4-thread-2]: Record Loaded 2013-01-31 23:42:19.613 (3) [pool-4-thread-2]: Queue worker session created. 2013-01-31 23:42:20.021 (4) [pool-4-thread-2]: Returning Object to Pool 2013-01-31 23:42:20.021 (4) [pool-4-thread-2]: no account, or instance for databaseInstance, skipping lookup... 2013-01-31 23:42:20.031 (4) [pool-4-thread-2]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2013-01-31 23:42:20.031 (4) [pool-4-thread-2]: Created new Object 2013-01-31 23:42:20.031 (4) [pool-4-thread-2]: spike: SQL->[select @@version] 2013-01-31 23:42:20.032 (4) [pool-4-thread-2]: time=0.0010 2013-01-31 23:42:20.032 (4) [pool-4-thread-2]: Query executed in 0.001s 2013-01-31 23:42:20.032 (4) [pool-4-thread-2]: test query succeeded, returned "5.1.60-rel13.1-log" 2013-01-31 23:42:20.032 (4) [pool-4-thread-2]: DataCache: Found key global-clients 2013-01-31 23:42:20.032 (4) [pool-4-thread-2]: Took Existing Object from Pool 2013-01-31 23:42:20.032 (4) [pool-4-thread-2]: spike: SQL->[select @@version] 2013-01-31 23:42:20.033 (4) [pool-4-thread-2]: time=0.0010 2013-01-31 23:42:20.033 (4) [pool-4-thread-2]: Query executed in 0.001s 2013-01-31 23:42:20.033 (4) [pool-4-thread-2]: test query succeeded, returned "5.1.60-rel13.1-log" 2013-01-31 23:42:20.033 (4) [pool-4-thread-2]: spike: SQL->[SELECT GET_LOCK('com.thesearchagency.admaxlistener.dao.TSACommonDAO.99999999-959595959', 7200)] 2013-01-31 23:42:20.034 (4) [pool-4-thread-2]: time=0.0010 2013-01-31 23:42:20.034 (4) [pool-4-thread-2]: Query executed in 0.001s 2013-01-31 23:42:20.034 (4) [pool-4-thread-2]: spike: SQL->[select * from `tsacommon`.`accounts` where ((`description`="99999999-959595959")) limit 1] 2013-01-31 23:42:20.035 (4) [pool-4-thread-2]: time=0.0010 2013-01-31 23:42:20.035 (4) [pool-4-thread-2]: Query executed in 0.001s 2013-01-31 23:42:20.035 (4) [pool-4-thread-2]: Record Loaded 2013-01-31 23:42:20.099 (4) [pool-4-thread-2]: DataCache: Key acct-st-tracker 6313 expired. 2013-01-31 23:42:20.099 (4) [pool-4-thread-2]: no account, or instance for databaseInstance, skipping lookup... 2013-01-31 23:42:20.109 (4) [pool-4-thread-2]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2013-01-31 23:42:20.109 (4) [pool-4-thread-2]: spike: SQL->[select * from `tsacommon`.`accounts` where (`id`=6313) limit 1] 2013-01-31 23:42:20.110 (4) [pool-4-thread-2]: time=0.0010 2013-01-31 23:42:20.110 (4) [pool-4-thread-2]: Query executed in 0.001s 2013-01-31 23:42:20.110 (4) [pool-4-thread-2]: Record Loaded 2013-01-31 23:42:20.110 (4) [pool-4-thread-2]: DataCache: put key acct-st-tracker 6313 2013-01-31 23:42:20.110 (4) [pool-4-thread-2]: DataCache: Key acct-st-tracker-1 expired. 2013-01-31 23:42:20.110 (4) [pool-4-thread-2]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`name`="acct-st-tracker-1") and (`type`="mysql")) limit 1] 2013-01-31 23:42:20.111 (4) [pool-4-thread-2]: time=0.0010 2013-01-31 23:42:20.111 (4) [pool-4-thread-2]: Query executed in 0.001s 2013-01-31 23:42:20.111 (4) [pool-4-thread-2]: Record Loaded 2013-01-31 23:42:20.111 (4) [pool-4-thread-2]: DataCache: put key acct-st-tracker-1 2013-01-31 23:42:20.111 (4) [pool-4-thread-2]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2013-01-31 23:42:20.123 (4) [pool-4-thread-2]: opened [jdbc:mysql://acctdb-01-write:3307/st-tracker?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2013-01-31 23:42:20.123 (4) [pool-4-thread-2]: Created new Object 2013-01-31 23:42:20.123 (4) [pool-4-thread-2]: spike: SQL->[select @@version] 2013-01-31 23:42:20.124 (4) [pool-4-thread-2]: time=0.0010 2013-01-31 23:42:20.124 (4) [pool-4-thread-2]: Query executed in 0.001s 2013-01-31 23:42:20.124 (4) [pool-4-thread-2]: test query succeeded, returned "5.1.60-rel13.1" 2013-01-31 23:42:20.124 (4) [pool-4-thread-2]: preparing SQL statement [select id from clients.externalCampaignParent where typeID = ? and accountID = ? and status != ?] 2013-01-31 23:42:20.125 (4) [pool-4-thread-2]: preparing SQL statement [select admaxNominalMonthlyBudgets.ID,admaxCampaignID,startDate,endDate,budget from `st-tracker`.admaxCampaigns join `st-tracker`.admaxNominalMonthlyBudgets on admaxCampaigns.ID=admaxNominalMonthlyBudgets.admaxCampaignID where accountID=? and startDate<=? and (endDate is null or endDate>=?)] 2013-01-31 23:42:20.126 (4) [pool-4-thread-2]: No budget changes 2013-01-31 23:42:20.126 (4) [pool-4-thread-2]: preparing SQL statement [select id, description, accountID, admaxCampaignID, status, typeID from clients.externalCampaignParent where accountID = ? and typeID=1] 2013-01-31 23:42:20.127 (1) [pool-4-thread-2]: Exception [Unhandled exception, failing request]:java.lang.NullPointerException at com.thesearchagency.admaxlistener.worker.RequestWorker.preProcessCampaigns(RequestWorker.java:759) at com.thesearchagency.admaxlistener.worker.RequestWorker.processRequest(RequestWorker.java:507) at com.thesearchagency.admaxlistener.worker.RequestWorker.call(RequestWorker.java:193) at com.thesearchagency.admaxlistener.task.ExternalCampaignTaskDeploy.processAccount(ExternalCampaignTaskDeploy.java:66) at com.thesearchagency.admaxlistener.task.ExternalCampaignTaskDeploy.executeJob(ExternalCampaignTaskDeploy.java:131) at com.thesearchagency.admaxlistener.task.ExternalCampaignTask.manageJobs(ExternalCampaignTask.java:427) at com.thesearchagency.admaxlistener.task.ExternalCampaignTask.run(ExternalCampaignTask.java:217) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:317) at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:150) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:98) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:180) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:204) 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) 2013-01-31 23:42:20.127 (4) [pool-4-thread-2]: DataCache: Found key global-clients 2013-01-31 23:42:20.136 (4) [pool-4-thread-2]: opened [jdbc:mysql://clients-01-write:3306/clients?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2013-01-31 23:42:20.136 (4) [pool-4-thread-2]: Created new Object 2013-01-31 23:42:20.136 (4) [pool-4-thread-2]: spike: SQL->[select @@version] 2013-01-31 23:42:20.137 (4) [pool-4-thread-2]: time=0.0010 2013-01-31 23:42:20.137 (4) [pool-4-thread-2]: Query executed in 0.001s 2013-01-31 23:42:20.137 (4) [pool-4-thread-2]: test query succeeded, returned "5.1.60-rel13.1-log" 2013-01-31 23:42:20.137 (2) [pool-4-thread-2]: No parent result for 15site-1, using message result. 2013-01-31 23:42:20.137 (3) [pool-4-thread-2]: Updating deployment status to 'Failure' for campaignID: 15site-1 2013-01-31 23:42:20.137 (4) [pool-4-thread-2]: preparing SQL statement [update clients.externalCampaignParentDeployStatus set status = ? where description = ?] 2013-01-31 23:42:20.140 (3) [pool-4-thread-2]: Finished UPDATE request for 15site-1: FAILED 2013-01-31 23:42:20.140 (3) [pool-4-thread-2]: Finished UPDATE request, deploymentID (6eW5nCJ2OhWIZoGnZFtg), account 99999999-959595959 2013-01-31 23:42:20.140 (3) [pool-4-thread-2]: Request removed from map for customerID 99999999-959595959 2013-01-31 23:42:20.140 (4) [pool-4-thread-2]: spike: SQL->[SELECT RELEASE_LOCK('com.thesearchagency.admaxlistener.dao.TSACommonDAO.99999999-959595959')] 2013-01-31 23:42:20.141 (4) [pool-4-thread-2]: time=0.0010 2013-01-31 23:42:20.141 (4) [pool-4-thread-2]: Query executed in 0.001s 2013-01-31 23:42:20.141 (4) [pool-4-thread-2]: Released account lock: 99999999-959595959 2013-01-31 23:42:20.141 (4) [pool-4-thread-2]: Returning Object to Pool 2013-01-31 23:42:20.141 (4) [pool-4-thread-2]: Returning Object to Pool 2013-01-31 23:42:20.141 (4) [pool-4-thread-2]: Returning Object to Pool 2013-01-31 23:42:20.141 (4) [pool-4-thread-2]: Returning Object to Pool 2013-01-31 23:42:20.141 (3) [pool-4-thread-2]: Queue worker close() called. 2013-01-31 23:42:20.146 (3) [pool-4-thread-2]: Queue worker tmp queue deleted. 2013-01-31 23:42:20.147 (3) [pool-4-thread-2]: Queue worker session closed. 2013-01-31 23:42:20.147 (1) [pool-4-thread-2]: Error while managing jobs: ID: 31 jobTypeID 6 tryCount: 2 isFailed: false isFinished: false account 6313 failed. 2013-01-31 23:42:20.147 (4) [pool-4-thread-2]: Returning Object to Pool 2013-01-31 23:42:38.471 (4) [Timer-12]: LicensingFileRefresher: licensing.properties last modified 1337940573000 2013-01-31 23:42:45.578 (4) [ConnectionCloser]: 3 DatabasePools remaining : 5 pending closure 2013-01-31 23:43:10.531 (4) [Timer-0]: ContentEditorPropertiesRefresher: contenteditor.properties last modified 1337941320000 2013-01-31 23:43:15.578 (4) [ConnectionCloser]: 3 DatabasePools remaining : 5 pending closure