2012-02-13 22:09:34.419 (3) [Thread-11]: Submitted executor job for atultest-7
2012-02-13 22:09:34.425 (4) [pool-3-thread-1]: no account, or instance for databaseInstance, skipping lookup...
2012-02-13 22:09:34.428 (3) [pool-3-thread-1]: DatabasePool with a limit of 50 created
2012-02-13 22:09:34.451 (4) [ConnectionCloser]: Starting DatabasePool ConnectionCloserThread
2012-02-13 22:09:34.584 (4) [pool-3-thread-1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-02-13 22:09:34.584 (4) [pool-3-thread-1]: Created new Object
2012-02-13 22:09:34.587 (4) [pool-3-thread-1]: spike: SQL->[select @@version]
2012-02-13 22:09:34.612 (4) [pool-3-thread-1]: time=0.025
2012-02-13 22:09:34.612 (4) [pool-3-thread-1]: Query executed in 0.025s
2012-02-13 22:09:34.613 (4) [pool-3-thread-1]: test query succeeded, returned "5.1.60-rel13.1-log"
2012-02-13 22:09:34.613 (4) [pool-3-thread-1]: no account, or instance for databaseInstance, skipping lookup...
2012-02-13 22:09:34.639 (4) [pool-3-thread-1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-02-13 22:09:34.652 (4) [pool-3-thread-1]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`name`="global-clients") and (`type`="mysql")) limit 1]
2012-02-13 22:09:34.655 (4) [pool-3-thread-1]: time=0.0030
2012-02-13 22:09:34.655 (4) [pool-3-thread-1]: Query executed in 0.003s
2012-02-13 22:09:34.657 (4) [pool-3-thread-1]:   Record Loaded
2012-02-13 22:09:34.657 (4) [pool-3-thread-1]: DataCache: put key global-clients
2012-02-13 22:09:34.658 (4) [pool-3-thread-1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-02-13 22:09:34.658 (3) [pool-3-thread-1]: DatabasePool with a limit of 50 created
2012-02-13 22:09:34.683 (4) [pool-3-thread-1]: opened [jdbc:mysql://clients-01-write:3306/clients?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-02-13 22:09:34.683 (4) [pool-3-thread-1]: Created new Object
2012-02-13 22:09:34.683 (4) [pool-3-thread-1]: spike: SQL->[select @@version]
2012-02-13 22:09:34.684 (4) [pool-3-thread-1]: time=0.0010
2012-02-13 22:09:34.684 (4) [pool-3-thread-1]: Query executed in 0.001s
2012-02-13 22:09:34.684 (4) [pool-3-thread-1]: test query succeeded, returned "5.1.60-rel13.1-log"
2012-02-13 22:09:34.692 (4) [pool-3-thread-1]: spike: SQL->[SELECT GET_LOCK('com.thesearchagency.admaxlistener.dao.TSACommonDAO.atultest-7', 7200)]
2012-02-13 22:09:34.694 (4) [pool-3-thread-1]: time=0.0020
2012-02-13 22:09:34.694 (4) [pool-3-thread-1]: Query executed in 0.002s
2012-02-13 22:09:34.695 (4) [pool-3-thread-1]: spike: SQL->[select * from `tsacommon`.`accounts` where ((`description`="atultest-7")) limit 1]
2012-02-13 22:09:34.697 (4) [pool-3-thread-1]: time=0.0020
2012-02-13 22:09:34.697 (4) [pool-3-thread-1]: Query executed in 0.002s
2012-02-13 22:09:34.697 (4) [pool-3-thread-1]:   Record Not Found
2012-02-13 22:09:34.697 (3) [pool-3-thread-1]: atultest-7 is a new account.
2012-02-13 22:09:34.697 (3) [pool-3-thread-1]: Creating new (enhanced) tsa account: atultest-7
2012-02-13 22:09:35.171 (3) [pool-3-thread-1]: atultest-7 has been assigned accountID 5850
2012-02-13 22:09:35.282 (4) [pool-3-thread-1]: no account, or instance for databaseInstance, skipping lookup...
2012-02-13 22:09:35.305 (4) [pool-3-thread-1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-02-13 22:09:35.305 (4) [pool-3-thread-1]: spike: SQL->[select * from `tsacommon`.`accounts` where (`id`=5850) limit 1]
2012-02-13 22:09:35.306 (4) [pool-3-thread-1]: time=0.0010
2012-02-13 22:09:35.307 (4) [pool-3-thread-1]: Query executed in 0.001s
2012-02-13 22:09:35.309 (4) [pool-3-thread-1]:   Record Loaded
2012-02-13 22:09:35.309 (4) [pool-3-thread-1]: DataCache: put key acct-st-tracker 5850
2012-02-13 22:09:35.310 (4) [pool-3-thread-1]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`name`="acct-st-tracker-1") and (`type`="mysql")) limit 1]
2012-02-13 22:09:35.311 (4) [pool-3-thread-1]: time=0.0010
2012-02-13 22:09:35.311 (4) [pool-3-thread-1]: Query executed in 0.001s
2012-02-13 22:09:35.312 (4) [pool-3-thread-1]:   Record Loaded
2012-02-13 22:09:35.312 (4) [pool-3-thread-1]: DataCache: put key acct-st-tracker-1
2012-02-13 22:09:35.312 (4) [pool-3-thread-1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-02-13 22:09:35.312 (3) [pool-3-thread-1]: DatabasePool with a limit of 50 created
2012-02-13 22:09:35.340 (4) [pool-3-thread-1]: opened [jdbc:mysql://acctdb-01-write:3307/st-tracker?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-02-13 22:09:35.340 (4) [pool-3-thread-1]: Created new Object
2012-02-13 22:09:35.340 (4) [pool-3-thread-1]: spike: SQL->[select @@version]
2012-02-13 22:09:35.341 (4) [pool-3-thread-1]: time=0.0010
2012-02-13 22:09:35.341 (4) [pool-3-thread-1]: Query executed in 0.001s
2012-02-13 22:09:35.341 (4) [pool-3-thread-1]: test query succeeded, returned "5.1.60-rel13.1"
2012-02-13 22:09:35.341 (3) [pool-3-thread-1]: Using enhanced campaigns for account atultest-7
2012-02-13 22:09:35.341 (4) [pool-3-thread-1]: preparing SQL statement [select id, description, accountID, admaxCampaignID, status from clients.externalCampaignParent where description = ?]
2012-02-13 22:09:35.355 (3) [pool-3-thread-1]: 19690706001 has no parent. Creating...
2012-02-13 22:09:35.360 (4) [pool-3-thread-1]: preparing SQL statement [insert into `st-tracker`.admaxCampaigns (identifier, description, accountID, campaignGroupingID, status) values (?,?,?,?,?)], genflags=yes
2012-02-13 22:09:35.364 (4) [pool-3-thread-1]: preparing SQL statement [insert into `st-tracker`.admaxCampaignBudgetAccrualStatus(admaxCampaignID,startDate,status) values(?,?,?)]
2012-02-13 22:09:35.368 (4) [pool-3-thread-1]: preparing SQL statement [insert into clients.externalCampaignParent (description, accountID, admaxCampaignID, status) values (?, ?, ?, ?)], genflags=yes
2012-02-13 22:09:35.370 (4) [pool-3-thread-1]: preparing SQL statement [update clients.externalCampaignParent set status = ? where id = ?]
2012-02-13 22:09:35.371 (4) [pool-3-thread-1]: preparing SQL statement [update `st-tracker`.admaxCampaigns set status = ? where id = ?]
2012-02-13 22:09:35.372 (3) [pool-3-thread-1]: Updating advert budget for atultest-7_2000062_22770_19690706001
2012-02-13 22:09:35.373 (4) [pool-3-thread-1]: preparing SQL statement [select ID,admaxCampaignID,startDate,endDate,budget from `st-tracker`.admaxNominalMonthlyBudgets where admaxCampaignID=? and startDate<=? and (endDate is null or endDate>=?)]
2012-02-13 22:09:35.376 (4) [pool-3-thread-1]: preparing SQL statement [insert into `st-tracker`.admaxNominalMonthlyBudgets (admaxCampaignID, startDate, endDate, budget) values (?,?,?,?) on duplicate key update endDate=?, budget=?]
2012-02-13 22:09:35.378 (4) [pool-3-thread-1]: preparing SQL statement [select id, description, accountID, admaxCampaignID, status from clients.externalCampaignParent where description = ?]
2012-02-13 22:09:35.379 (3) [pool-3-thread-1]: 19690706002 has no parent. Creating...
2012-02-13 22:09:35.379 (4) [pool-3-thread-1]: preparing SQL statement [insert into `st-tracker`.admaxCampaigns (identifier, description, accountID, campaignGroupingID, status) values (?,?,?,?,?)], genflags=yes
2012-02-13 22:09:35.380 (4) [pool-3-thread-1]: preparing SQL statement [insert into `st-tracker`.admaxCampaignBudgetAccrualStatus(admaxCampaignID,startDate,status) values(?,?,?)]
2012-02-13 22:09:35.381 (4) [pool-3-thread-1]: preparing SQL statement [insert into clients.externalCampaignParent (description, accountID, admaxCampaignID, status) values (?, ?, ?, ?)], genflags=yes
2012-02-13 22:09:35.384 (4) [pool-3-thread-1]: preparing SQL statement [update clients.externalCampaignParent set status = ? where id = ?]
2012-02-13 22:09:35.385 (4) [pool-3-thread-1]: preparing SQL statement [update `st-tracker`.admaxCampaigns set status = ? where id = ?]
2012-02-13 22:09:35.386 (3) [pool-3-thread-1]: Updating advert budget for atultest-7_2000062_22771_19690706002
2012-02-13 22:09:35.386 (4) [pool-3-thread-1]: preparing SQL statement [select ID,admaxCampaignID,startDate,endDate,budget from `st-tracker`.admaxNominalMonthlyBudgets where admaxCampaignID=? and startDate<=? and (endDate is null or endDate>=?)]
2012-02-13 22:09:35.387 (4) [pool-3-thread-1]: preparing SQL statement [insert into `st-tracker`.admaxNominalMonthlyBudgets (admaxCampaignID, startDate, endDate, budget) values (?,?,?,?) on duplicate key update endDate=?, budget=?]
2012-02-13 22:09:35.389 (4) [pool-3-thread-1]: preparing SQL statement [select id, description, accountID, admaxCampaignID, status from clients.externalCampaignParent where description = ?]
2012-02-13 22:09:35.390 (3) [pool-3-thread-1]: 19690706003 has no parent. Creating...
2012-02-13 22:09:35.390 (4) [pool-3-thread-1]: preparing SQL statement [insert into `st-tracker`.admaxCampaigns (identifier, description, accountID, campaignGroupingID, status) values (?,?,?,?,?)], genflags=yes
2012-02-13 22:09:35.391 (4) [pool-3-thread-1]: preparing SQL statement [insert into `st-tracker`.admaxCampaignBudgetAccrualStatus(admaxCampaignID,startDate,status) values(?,?,?)]
2012-02-13 22:09:35.392 (4) [pool-3-thread-1]: preparing SQL statement [insert into clients.externalCampaignParent (description, accountID, admaxCampaignID, status) values (?, ?, ?, ?)], genflags=yes
2012-02-13 22:09:35.395 (4) [pool-3-thread-1]: preparing SQL statement [update clients.externalCampaignParent set status = ? where id = ?]
2012-02-13 22:09:35.397 (4) [pool-3-thread-1]: preparing SQL statement [update `st-tracker`.admaxCampaigns set status = ? where id = ?]
2012-02-13 22:09:35.398 (3) [pool-3-thread-1]: Updating advert budget for atultest-7_2000062_22772_19690706003
2012-02-13 22:09:35.398 (4) [pool-3-thread-1]: preparing SQL statement [select ID,admaxCampaignID,startDate,endDate,budget from `st-tracker`.admaxNominalMonthlyBudgets where admaxCampaignID=? and startDate<=? and (endDate is null or endDate>=?)]
2012-02-13 22:09:35.400 (4) [pool-3-thread-1]: preparing SQL statement [insert into `st-tracker`.admaxNominalMonthlyBudgets (admaxCampaignID, startDate, endDate, budget) values (?,?,?,?) on duplicate key update endDate=?, budget=?]
2012-02-13 22:09:35.401 (4) [pool-3-thread-1]: Returning Object to Pool
2012-02-13 22:09:35.401 (4) [pool-3-thread-1]: Returning Object to Pool
2012-02-13 22:09:35.408 (4) [pool-3-thread-1]: no account, or instance for databaseInstance, skipping lookup...
2012-02-13 22:09:35.432 (4) [pool-3-thread-1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-02-13 22:09:35.432 (4) [pool-3-thread-1]: Created new Object
2012-02-13 22:09:35.432 (4) [pool-3-thread-1]: spike: SQL->[select @@version]
2012-02-13 22:09:35.433 (4) [pool-3-thread-1]: time=0.0010
2012-02-13 22:09:35.433 (4) [pool-3-thread-1]: Query executed in 0.001s
2012-02-13 22:09:35.433 (4) [pool-3-thread-1]: test query succeeded, returned "5.1.60-rel13.1-log"
2012-02-13 22:09:35.434 (3) [pool-3-thread-1]: Start processing DEPLOY request (null) for account atultest-7. 6 campaign(s).
2012-02-13 22:09:35.434 (4) [pool-3-thread-1]: Locked account: atultest-7
2012-02-13 22:09:35.461 (3) [pool-3-thread-1]: LicensingFileRefresher: modification detected on 1326374164000 for licensing.properties
2012-02-13 22:09:35.461 (3) [pool-3-thread-1]: Licensing environment detected, loading configuration.
2012-02-13 22:09:35.463 (3) [pool-3-thread-1]: Loaded property: tsa.google.mcc.email=tsaoptapi@gmail.com
2012-02-13 22:09:35.463 (3) [pool-3-thread-1]: Loaded property: tsa.google.mcc.password=brothereclipsewinning
2012-02-13 22:09:35.463 (3) [pool-3-thread-1]: Loaded property: tsa.google.mcc.developerToken=tsaoptapi@gmail.com++AUD
2012-02-13 22:09:35.463 (3) [pool-3-thread-1]: Loaded property: tsa.google.mcc.applicationToken=none
2012-02-13 22:09:35.463 (3) [pool-3-thread-1]: Loaded property: tsa.google.mcc.isReseller=true
2012-02-13 22:09:35.463 (3) [pool-3-thread-1]: Loaded property: tsa.google.mcc.userAgent=Optus AdWords Software
2012-02-13 22:09:35.463 (3) [pool-3-thread-1]: Loaded property: tsa.google.isSandbox=true
2012-02-13 22:09:35.463 (3) [pool-3-thread-1]: Loaded property: tsa.google.sandbox.currency=AUD
2012-02-13 22:09:35.466 (3) [pool-3-thread-1]: Performing sync for account: atultest-7 ID#5850
2012-02-13 22:09:35.466 (4) [pool-3-thread-1]: no account, or instance for databaseInstance, skipping lookup...
2012-02-13 22:09:35.488 (4) [pool-3-thread-1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-02-13 22:09:35.488 (4) [pool-3-thread-1]: Created new Object
2012-02-13 22:09:35.488 (4) [pool-3-thread-1]: spike: SQL->[select @@version]
2012-02-13 22:09:35.489 (4) [pool-3-thread-1]: time=0.0010
2012-02-13 22:09:35.489 (4) [pool-3-thread-1]: Query executed in 0.001s
2012-02-13 22:09:35.489 (4) [pool-3-thread-1]: test query succeeded, returned "5.1.60-rel13.1-log"
2012-02-13 22:09:35.489 (4) [pool-3-thread-1]: DataCache: Found key global-clients
2012-02-13 22:09:35.490 (4) [pool-3-thread-1]: Took Existing Object from Pool
2012-02-13 22:09:35.490 (4) [pool-3-thread-1]: spike: SQL->[select @@version]
2012-02-13 22:09:35.491 (4) [pool-3-thread-1]: time=0.0010
2012-02-13 22:09:35.491 (4) [pool-3-thread-1]: Query executed in 0.001s
2012-02-13 22:09:35.491 (4) [pool-3-thread-1]: test query succeeded, returned "5.1.60-rel13.1-log"
2012-02-13 22:09:35.491 (4) [pool-3-thread-1]: preparing SQL statement [select id, externalCampaignParentID, gceCampaignID, searchEngineAccountID, accountID, enabled from clients.externalCampaign where id = ?]
2012-02-13 22:09:35.492 (4) [pool-3-thread-1]: preparing SQL statement [select id, description, accountID, admaxCampaignID, status from clients.externalCampaignParent where description = ?]
2012-02-13 22:09:35.540 (4) [pool-3-thread-1]: preparing SQL statement [select id, externalCampaignParentID, gceCampaignID, searchEngineAccountID, accountID, enabled from clients.externalCampaign where id = ?]
2012-02-13 22:09:35.541 (4) [pool-3-thread-1]: preparing SQL statement [select id, description, accountID, admaxCampaignID, status from clients.externalCampaignParent where description = ?]
2012-02-13 22:09:35.543 (4) [pool-3-thread-1]: preparing SQL statement [select id, externalCampaignParentID, gceCampaignID, searchEngineAccountID, accountID, enabled from clients.externalCampaign where id = ?]
2012-02-13 22:09:35.573 (4) [pool-3-thread-1]: preparing SQL statement [select id, description, accountID, admaxCampaignID, status from clients.externalCampaignParent where description = ?]
2012-02-13 22:09:35.575 (4) [pool-3-thread-1]: preparing SQL statement [select id, externalCampaignParentID, gceCampaignID, searchEngineAccountID, accountID, enabled from clients.externalCampaign where id = ?]
2012-02-13 22:09:35.576 (4) [pool-3-thread-1]: preparing SQL statement [select id, description, accountID, admaxCampaignID, status from clients.externalCampaignParent where description = ?]
2012-02-13 22:09:35.578 (4) [pool-3-thread-1]: preparing SQL statement [select id, externalCampaignParentID, gceCampaignID, searchEngineAccountID, accountID, enabled from clients.externalCampaign where id = ?]
2012-02-13 22:09:35.579 (4) [pool-3-thread-1]: preparing SQL statement [select id, description, accountID, admaxCampaignID, status from clients.externalCampaignParent where description = ?]
2012-02-13 22:09:35.581 (4) [pool-3-thread-1]: preparing SQL statement [select id, externalCampaignParentID, gceCampaignID, searchEngineAccountID, accountID, enabled from clients.externalCampaign where id = ?]
2012-02-13 22:09:35.582 (4) [pool-3-thread-1]: preparing SQL statement [select id, description, accountID, admaxCampaignID, status from clients.externalCampaignParent where description = ?]
2012-02-13 22:09:35.584 (4) [pool-3-thread-1]: Returning Object to Pool
2012-02-13 22:09:35.585 (4) [pool-3-thread-1]: Returning Object to Pool
2012-02-13 22:09:35.585 (3) [pool-3-thread-1]: 0 campaign(s) to update.
2012-02-13 22:09:35.585 (3) [pool-3-thread-1]: 6 campaign(s) to create.
2012-02-13 22:09:35.585 (3) [pool-3-thread-1]: 0 campaign(s) to retry and update.
2012-02-13 22:09:35.585 (4) [pool-3-thread-1]: no account, or instance for databaseInstance, skipping lookup...
2012-02-13 22:09:35.585 (4) [pool-3-thread-1]: Took Existing Object from Pool
2012-02-13 22:09:35.585 (4) [pool-3-thread-1]: spike: SQL->[select @@version]
2012-02-13 22:09:35.586 (4) [pool-3-thread-1]: time=0.0010
2012-02-13 22:09:35.586 (4) [pool-3-thread-1]: Query executed in 0.001s
2012-02-13 22:09:35.586 (4) [pool-3-thread-1]: test query succeeded, returned "5.1.60-rel13.1-log"
2012-02-13 22:09:35.586 (4) [pool-3-thread-1]: DataCache: Found key global-clients
2012-02-13 22:09:35.587 (4) [pool-3-thread-1]: Took Existing Object from Pool
2012-02-13 22:09:35.587 (4) [pool-3-thread-1]: spike: SQL->[select @@version]
2012-02-13 22:09:35.587 (4) [pool-3-thread-1]: time=0.0
2012-02-13 22:09:35.588 (4) [pool-3-thread-1]: Query executed in 0.000s
2012-02-13 22:09:35.588 (4) [pool-3-thread-1]: test query succeeded, returned "5.1.60-rel13.1-log"
2012-02-13 22:09:35.588 (4) [pool-3-thread-1]: SearchEngineUserWorker initialized for account: 5850
2012-02-13 22:09:35.588 (4) [pool-3-thread-1]: preparing SQL statement [select u.id, count(case when a.searchEngineStatus = ? then null else a.id end) from tsacommon.searchEngineUsers u left join tsacommon.searchEngineAccounts a on(u.id = a.searchEngineUserID and a.accountID = u.accountID) where u.accountID = ? and u.enabled = 'true' group by u.id order by u.id asc]
2012-02-13 22:09:35.602 (3) [pool-3-thread-1]: atultest-7 has 6 new campaign(s).
2012-02-13 22:09:35.603 (3) [pool-3-thread-1]: atultest-7 requires 1 new users.
2012-02-13 22:09:35.603 (4) [pool-3-thread-1]: preparing SQL statement [select count(1) from tsacommon.searchEngineUsers u where u.accountID = ? ]
2012-02-13 22:09:35.607 (4) [pool-3-thread-1]: spike: SQL->[insert into `tsacommon`.`searchEngineUsers` (`distributionID`,`enabled`,`accountID`,`description`,`inTsaMcc`) values (3,"false",5850,"atultest-7_1","true")], genflags=yes
2012-02-13 22:09:35.610 (4) [pool-3-thread-1]: time=0.0030
2012-02-13 22:09:35.611 (4) [pool-3-thread-1]: Query executed in 0.003s, 1 row(s) affected
2012-02-13 22:09:35.611 (3) [pool-3-thread-1]: Created 1 SE user row(s).
2012-02-13 22:09:35.621 (3) [pool-3-thread-1]: Calling GCE to create 1 SE users.
2012-02-13 22:09:35.639 (4) [pool-3-thread-1]: no account, or instance for databaseInstance, skipping lookup...
2012-02-13 22:09:35.661 (4) [pool-3-thread-1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-02-13 22:09:35.661 (4) [pool-3-thread-1]: spike: SQL->[select * from `tsacommon`.`accounts` where (`id`=5850) limit 1]
2012-02-13 22:09:35.662 (4) [pool-3-thread-1]: time=0.0010
2012-02-13 22:09:35.662 (4) [pool-3-thread-1]: Query executed in 0.001s
2012-02-13 22:09:35.663 (4) [pool-3-thread-1]:   Record Loaded
2012-02-13 22:09:35.663 (4) [pool-3-thread-1]: DataCache: put key acct-content-google 5850
2012-02-13 22:09:35.664 (4) [pool-3-thread-1]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`name`="acct-content-google-1") and (`type`="mysql")) limit 1]
2012-02-13 22:09:35.665 (4) [pool-3-thread-1]: time=0.0010
2012-02-13 22:09:35.665 (4) [pool-3-thread-1]: Query executed in 0.001s
2012-02-13 22:09:35.666 (4) [pool-3-thread-1]:   Record Loaded
2012-02-13 22:09:35.666 (4) [pool-3-thread-1]: DataCache: put key acct-content-google-1
2012-02-13 22:09:35.666 (4) [pool-3-thread-1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-02-13 22:09:35.666 (3) [pool-3-thread-1]: DatabasePool with a limit of 50 created
2012-02-13 22:09:35.687 (4) [pool-3-thread-1]: opened [jdbc:mysql://acctdb-01-write:3307/content_editor_google?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-02-13 22:09:35.688 (4) [pool-3-thread-1]: Created new Object
2012-02-13 22:09:35.688 (4) [pool-3-thread-1]: spike: SQL->[select @@version]
2012-02-13 22:09:35.689 (4) [pool-3-thread-1]: time=0.0
2012-02-13 22:09:35.689 (4) [pool-3-thread-1]: Query executed in 0.000s
2012-02-13 22:09:35.689 (4) [pool-3-thread-1]: test query succeeded, returned "5.1.60-rel13.1"
2012-02-13 22:09:35.689 (4) [pool-3-thread-1]: DB AutoCommit -> true
2012-02-13 22:09:35.693 (4) [pool-3-thread-1]: preparing SQL statement [INSERT INTO gce_googleAccount (accountID, loginEmail, password, currencyCode, descriptiveName, languagePreference, timeZoneId, addressLine1, addressLine2, city, companyName, countryCode, emailAddress, faxNumber, phoneNumber, state, postalCode, name, accountPerformanceEnabled, disapprovedAdsEnabled, marketResearchEnabled, newsletterEnabled, promotionsEnabled, parentClientCustomerID, parentClientEmail)  VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]
2012-02-13 22:09:35.696 (4) [pool-3-thread-1]: spike: SQL->[SELECT LAST_INSERT_ID()]
2012-02-13 22:09:35.697 (2) [pool-3-thread-1]: Warning(s) detected in statement [SELECT LAST_INSERT_ID()] executed by user [spike]
2012-02-13 22:09:35.697 (2) [pool-3-thread-1]: Field 'primaryBusinessCategory' doesn't have a default value (1364)
2012-02-13 22:09:35.698 (4) [pool-3-thread-1]: time=0.0020
2012-02-13 22:09:35.698 (4) [pool-3-thread-1]: Query executed in 0.002s
2012-02-13 22:09:35.700 (4) [pool-3-thread-1]: spike: SQL->[insert into `content_editor_google`.`gce_googleAccountPendingChange` (`googleAccountID`,`isFailed`,`requestTime`,`tryCount`,`type`) values (1,"false","2012-02-13 22:09:35",0,"add") on duplicate key update `isFailed`="false",`requestTime`="2012-02-13 22:09:35",`tryCount`=0,`type`=IF((`type`="add"), "add", "add")], genflags=no
2012-02-13 22:09:35.701 (4) [pool-3-thread-1]: time=0.0010
2012-02-13 22:09:35.701 (4) [pool-3-thread-1]: Query executed in 0.001s, 1 row(s) affected
2012-02-13 22:09:35.701 (4) [pool-3-thread-1]: Inserted a new pending change
2012-02-13 22:09:35.702 (4) [pool-3-thread-1]: DB AutoCommit -> true
2012-02-13 22:09:35.702 (4) [pool-3-thread-1]: Returning Object to Pool
2012-02-13 22:09:35.702 (4) [pool-3-thread-1]: no account, or instance for databaseInstance, skipping lookup...
2012-02-13 22:09:35.702 (3) [pool-3-thread-1]: ----------------Google Content Editor starting
2012-02-13 22:09:35.722 (4) [pool-3-thread-1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-02-13 22:09:35.722 (4) [pool-3-thread-1]: spike: SQL->[select * from `tsacommon`.`accounts` where ((`tsacommon`.`accounts`.`id` in (5850))) order by rand()]
2012-02-13 22:09:35.724 (4) [pool-3-thread-1]: time=0.0010
2012-02-13 22:09:35.724 (4) [pool-3-thread-1]: Query executed in 0.001s
2012-02-13 22:09:35.728 (3) [P1T1]: Creating Google accounts for accountID 5850
2012-02-13 22:09:35.997 (4) [P1T1]: seuserid[null] username[null] password[null] clientemail[null] customerID[null]
2012-02-13 22:09:36.006 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup...
2012-02-13 22:09:36.029 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-02-13 22:09:36.030 (4) [P1T1]: spike: SQL->[select `id`,`shortCode` from distribution where ((`searchEngineClass` is not null) and (`searchEngineClass`!=""))]
2012-02-13 22:09:36.032 (4) [P1T1]: time=0.0010
2012-02-13 22:09:36.032 (4) [P1T1]: Query executed in 0.001s
2012-02-13 22:09:36.033 (4) [P1T1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-02-13 22:09:36.036 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup...
2012-02-13 22:09:36.052 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-02-13 22:09:36.052 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`name`="global-sesystem") and (`type`="mysql")) limit 1]
2012-02-13 22:09:36.054 (4) [P1T1]: time=0.0010
2012-02-13 22:09:36.054 (4) [P1T1]: Query executed in 0.001s
2012-02-13 22:09:36.054 (4) [P1T1]:   Record Loaded
2012-02-13 22:09:36.054 (4) [P1T1]: DataCache: put key global-sesystem
2012-02-13 22:09:36.054 (4) [P1T1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-02-13 22:09:36.075 (4) [P1T1]: opened [jdbc:mysql://sesystem-01-write:3308/sesystem?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-02-13 22:09:36.076 (3) [P1T1]: Created shared sesystem connection rw
2012-02-13 22:09:36.076 (4) [P1T1]: sesystem: SQL->[select 1]
2012-02-13 22:09:36.077 (4) [P1T1]: time=0.0010
2012-02-13 22:09:36.077 (4) [P1T1]: Query executed in 0.001s
2012-02-13 22:09:36.077 (4) [P1T1]: sesystem: SQL->[update `sesystem`.`searchEngineConnections` set `holder`="",`inUse`="false",`holderIdentifier`="",`timeStamp`="2012-02-13 22:09:35" where ((`sesystem`.`searchEngineConnections`.`distributionID`=3) and (`sesystem`.`searchEngineConnections`.`inUse`="true") and (`sesystem`.`searchEngineConnections`.`timeStamp`<="2012-02-13 22:04:36")) limit 1], genflags=no
2012-02-13 22:09:36.188 (4) [P1T1]: time=0.11
2012-02-13 22:09:36.188 (4) [P1T1]: Query executed in 0.110s, 0 row(s) affected
2012-02-13 22:09:36.188 (4) [P1T1]: sesystem: SQL->[select 1]
2012-02-13 22:09:36.189 (4) [P1T1]: time=0.0010
2012-02-13 22:09:36.189 (4) [P1T1]: Query executed in 0.001s
2012-02-13 22:09:36.191 (4) [P1T1]: sesystem: SQL->[select `authToken`,`date` from `sesystem`.`googleAuthToken` where ((`seUserID`=0))]
2012-02-13 22:09:36.192 (4) [P1T1]: time=0.0010
2012-02-13 22:09:36.192 (4) [P1T1]: Query executed in 0.001s
2012-02-13 22:09:36.192 (4) [P1T1]: Master AuthToken retrieved from database [null] for username[tsaoptapi@gmail.com]
2012-02-13 22:09:37.222 (4) [P1T1]: Updating AuthToken [DQAAAIoAAAAI5z_Sx3kVowjbw4S5Xb2ipJVRAuseq9g47jSo004OCJAmNEjeWhk2IVjV48ZJOvCBYIfp7OPOWM32TFTQ3gz1xxOfPejOYcHXFYRNAWV2WtnFAz4XACU-0alc0yD5OxXlDSmfv7IIE-9STFh8hjT-vg6P5FGOnWtnByXeq1toMdnz1ABf1uOrjUc7k1z8yPc] for username[tsaoptapi@gmail.com]
2012-02-13 22:09:37.222 (4) [P1T1]: sesystem: SQL->[select 1]
2012-02-13 22:09:37.226 (4) [P1T1]: time=0.0040
2012-02-13 22:09:37.226 (4) [P1T1]: Query executed in 0.004s
2012-02-13 22:09:37.227 (4) [P1T1]: sesystem: SQL->[insert into `sesystem`.`googleAuthToken` (`sesystem`.`googleAuthToken`.`seUserID`,`sesystem`.`googleAuthToken`.`authToken`,`sesystem`.`googleAuthToken`.`date`)  values (0,"DQAAAIoAAAAI5z_Sx3kVowjbw4S5Xb2ipJVRAuseq9g47jSo004OCJAmNEjeWhk2IVjV48ZJOvCBYIfp7OPOWM32TFTQ3gz1xxOfPejOYcHXFYRNAWV2WtnFAz4XACU-0alc0yD5OxXlDSmfv7IIE-9STFh8hjT-vg6P5FGOnWtnByXeq1toMdnz1ABf1uOrjUc7k1z8yPc","2012-02-13") on duplicate key update `sesystem`.`googleAuthToken`.`authToken`="DQAAAIoAAAAI5z_Sx3kVowjbw4S5Xb2ipJVRAuseq9g47jSo004OCJAmNEjeWhk2IVjV48ZJOvCBYIfp7OPOWM32TFTQ3gz1xxOfPejOYcHXFYRNAWV2WtnFAz4XACU-0alc0yD5OxXlDSmfv7IIE-9STFh8hjT-vg6P5FGOnWtnByXeq1toMdnz1ABf1uOrjUc7k1z8yPc",`sesystem`.`googleAuthToken`.`date`="2012-02-13"], genflags=no
2012-02-13 22:09:37.228 (4) [P1T1]: time=0.0010
2012-02-13 22:09:37.228 (4) [P1T1]: Query executed in 0.001s, 1 row(s) affected
2012-02-13 22:09:37.228 (3) [P1T1]: Inserted/Updated 1 row(s) in `sesystem`.`googleAuthToken`
2012-02-13 22:09:37.241 (4) [P1T1]: Setting AuthToken [DQAAAIoAAAAI5z_Sx3kVowjbw4S5Xb2ipJVRAuseq9g47jSo004OCJAmNEjeWhk2IVjV48ZJOvCBYIfp7OPOWM32TFTQ3gz1xxOfPejOYcHXFYRNAWV2WtnFAz4XACU-0alc0yD5OxXlDSmfv7IIE-9STFh8hjT-vg6P5FGOnWtnByXeq1toMdnz1ABf1uOrjUc7k1z8yPc] to AdWordsUser object for username[tsaoptapi@gmail.com]
2012-02-13 22:09:37.681 (4) [P1T1]: DataCache: Found key acct-content-google 5850
2012-02-13 22:09:37.681 (4) [P1T1]: DataCache: Found key acct-content-google-1
2012-02-13 22:09:37.681 (4) [P1T1]: Took Existing Object from Pool
2012-02-13 22:09:37.681 (4) [P1T1]: spike: SQL->[select @@version]
2012-02-13 22:09:37.683 (4) [P1T1]: time=0.0020
2012-02-13 22:09:37.683 (4) [P1T1]: Query executed in 0.002s
2012-02-13 22:09:37.683 (4) [P1T1]: test query succeeded, returned "5.1.60-rel13.1"
2012-02-13 22:09:37.693 (4) [P1T1]: spike: SQL->[select `content_editor_google`.`gce_googleAccount`.*,`content_editor_google`.`gce_googleAccountPendingChange`.* from `content_editor_google`.`gce_googleAccount` join `gce_googleAccountPendingChange` on ((`content_editor_google`.`gce_googleAccountPendingChange`.`googleAccountID`=`content_editor_google`.`gce_googleAccount`.`id`)) where ((((((`isFailed`="true") and (`tryCount`<10))) or ((`isFailed`="false")))) and (`type`="add") and (`accountID`=5850))]
2012-02-13 22:09:37.695 (4) [P1T1]: time=0.0020
2012-02-13 22:09:37.695 (4) [P1T1]: Query executed in 0.002s
2012-02-13 22:09:37.698 (3) [P1T1]: Returning tsaoptapi@gmail.com, null
2012-02-13 22:09:37.707 (3) [P1T1]: GoogleAccountChangeRequest (accountID 5850): Sending 1 add requests
2012-02-13 22:09:37.707 (4) [P1T1]: GoogleAccountChangeRequest (accountID 5850): : Sending 1 adds
2012-02-13 22:09:37.707 (4) [P1T1]: DataCache: Found key global-sesystem
2012-02-13 22:09:37.707 (3) [P1T1]: DatabasePool with a limit of 50 created
2012-02-13 22:09:37.712 (2) [P1T1]: Exception [creating pooled Database]:java.sql.SQLException: Access denied for user 'spike'@'50-57-178-216.static.cloud-ips.com' (using password: YES)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812)
        at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269)
        at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182)
        at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670)
        at com.mysql.jdbc.Connection.<init>(Connection.java:1531)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
        at java.sql.DriverManager.getConnection(DriverManager.java:582)
        at java.sql.DriverManager.getConnection(DriverManager.java:185)
        at com.carldunham.jst.db.Database.init(Database.java:203)
        at com.carldunham.jst.db.Database.<init>(Database.java:188)
        at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:171)
        at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:35)
        at com.carldunham.jst.pooling.ObjectPool.get(ObjectPool.java:88)
        at com.carldunham.jst.db.DatabasePool.get(DatabasePool.java:96)
        at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:326)
        at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:308)
        at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:129)
        at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:121)
        at com.thesearchagency.searchengines.google.contenteditor.dao.account.GoogleAccountDAO.lockAccountActions(GoogleAccountDAO.java:219)
        at com.thesearchagency.searchengines.google.contenteditor.changerequest.GoogleAccountChangeRequest.sendRequest(GoogleAccountChangeRequest.java:144)
        at com.thesearchagency.searchengines.google.contenteditor.changerequest.GoogleAccountChangeRequest.sendRequest(GoogleAccountChangeRequest.java:33)
        at com.thesearchagency.searchengines.google.contenteditor.changerequest.BaseChangeRequest.makeRequest(BaseChangeRequest.java:108)
        at com.thesearchagency.searchengines.google.contenteditor.changerequest.GoogleAccountChangeRequest.makeRequest(GoogleAccountChangeRequest.java:69)
        at com.thesearchagency.searchengines.google.contenteditor.GoogleContentEditor$AccountWorker.createAccounts(GoogleContentEditor.java:802)
        at com.thesearchagency.searchengines.google.contenteditor.GoogleContentEditor$AccountWorker.run(GoogleContentEditor.java:778)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
        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)

2012-02-13 22:09:37.713 (4) [P1T1]: Created new Object
2012-02-13 22:09:37.713 (2) [P1T1]: Unable to get Database from pool!
2012-02-13 22:09:37.713 (2) [P1T1]: Null db returned for url [jdbc:mysql://sesystem-01-write:3308/sesystem?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-02-13 22:10:04.462 (4) [ConnectionCloser]: 5 DatabasePools remaining : 1 pending closure
2012-02-13 22:10:20.110 (4) [Timer-0]: ContentEditorPropertiesRefresher: contenteditor.properties last modified 1326374197000
2012-02-13 22:10:34.467 (4) [ConnectionCloser]: 5 DatabasePools remaining : 1 pending closure
2012-02-13 22:10:35.476 (4) [Timer-12]: LicensingFileRefresher: licensing.properties last modified 1326374164000
2012-02-13 22:10:35.735 (3) [pool-3-thread-1]: Waiting for tasks to be done
2012-02-13 22:11:04.470 (4) [ConnectionCloser]: closing db conn
2012-02-13 22:11:04.471 (4) [ConnectionCloser]: closed [jdbc:mysql://acctdb-01-write:3307/st-tracker?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-02-13 22:11:04.471 (4) [ConnectionCloser]: 5 DatabasePools remaining : 0 pending closure
2012-02-13 22:11:20.111 (4) [Timer-0]: ContentEditorPropertiesRefresher: contenteditor.properties last modified 1326374197000
2012-02-13 22:11:34.475 (4) [ConnectionCloser]: 5 DatabasePools remaining : 0 pending closure
2012-02-13 22:11:35.475 (4) [Timer-12]: LicensingFileRefresher: licensing.properties last modified 1326374164000
2012-02-13 22:11:37.720 (4) [P1T1]: Returning Object to Pool
2012-02-13 22:11:37.720 (4) [P1T1]: DAO released connection to pool
2012-02-13 22:11:37.720 (2) [P1T1]: Exception [afterExecute: exception thrown from thread in threadpool]:java.util.concurrent.ExecutionException: java.lang.NullPointerException
        at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:222)
        at java.util.concurrent.FutureTask.get(FutureTask.java:83)
        at com.carldunham.jst.concurrency.ThreadPool$CachedFixedThreadPool.afterExecute(ThreadPool.java:252)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:888)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
        at java.lang.Thread.run(Thread.java:662)
Caused by: java.lang.NullPointerException
        at com.thesearchagency.searchengines.google.contenteditor.dao.account.GoogleAccountDAO.lockAccountActions(GoogleAccountDAO.java:223)
        at com.thesearchagency.searchengines.google.contenteditor.changerequest.GoogleAccountChangeRequest.sendRequest(GoogleAccountChangeRequest.java:144)
        at com.thesearchagency.searchengines.google.contenteditor.changerequest.GoogleAccountChangeRequest.sendRequest(GoogleAccountChangeRequest.java:33)
        at com.thesearchagency.searchengines.google.contenteditor.changerequest.BaseChangeRequest.makeRequest(BaseChangeRequest.java:108)
        at com.thesearchagency.searchengines.google.contenteditor.changerequest.GoogleAccountChangeRequest.makeRequest(GoogleAccountChangeRequest.java:69)
        at com.thesearchagency.searchengines.google.contenteditor.GoogleContentEditor$AccountWorker.createAccounts(GoogleContentEditor.java:802)
        at com.thesearchagency.searchengines.google.contenteditor.GoogleContentEditor$AccountWorker.run(GoogleContentEditor.java:778)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
        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)
        ... 2 more

2012-02-13 22:11:55.753 (4) [pool-3-thread-1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-02-13 22:11:55.753 (3) [pool-3-thread-1]: ------------Google Content Editor done
2012-02-13 22:11:55.753 (4) [pool-3-thread-1]: DataCache: Found key acct-content-google 5850
2012-02-13 22:11:55.753 (4) [pool-3-thread-1]: DataCache: Found key acct-content-google-1
2012-02-13 22:11:55.753 (4) [pool-3-thread-1]: Took Existing Object from Pool
2012-02-13 22:11:55.754 (4) [pool-3-thread-1]: spike: SQL->[select @@version]
2012-02-13 22:11:55.755 (4) [pool-3-thread-1]: time=0.0010
2012-02-13 22:11:55.755 (4) [pool-3-thread-1]: Query executed in 0.001s
2012-02-13 22:11:55.755 (4) [pool-3-thread-1]: test query succeeded, returned "5.1.60-rel13.1"
2012-02-13 22:11:55.760 (4) [pool-3-thread-1]: spike: SQL->[select * from `content_editor_google`.`gce_googleAccount` where ((`accountID`=5850) and (`id` in (1)))]
2012-02-13 22:11:55.761 (4) [pool-3-thread-1]: time=0.0010
2012-02-13 22:11:55.762 (4) [pool-3-thread-1]: Query executed in 0.001s
2012-02-13 22:11:55.762 (3) [pool-3-thread-1]: Returning tsaoptapi@gmail.com, null
2012-02-13 22:11:55.762 (4) [pool-3-thread-1]: Returning Object to Pool
2012-02-13 22:11:55.762 (1) [pool-3-thread-1]: Could not save new search engine user account: atultest-7_1
2012-02-13 22:11:55.762 (4) [pool-3-thread-1]: Returning Object to Pool
2012-02-13 22:11:55.763 (4) [pool-3-thread-1]: Returning Object to Pool
2012-02-13 22:11:55.763 (2) [pool-3-thread-1]: Error: CampID: 19690706001_GT Info: Error during add campaigns request.
2012-02-13 22:11:55.763 (2) [pool-3-thread-1]: Error: CampID: 19690706001_GM Info: Error during add campaigns request.
2012-02-13 22:11:55.764 (2) [pool-3-thread-1]: Error: CampID: 19690706002_GT Info: Error during add campaigns request.
2012-02-13 22:11:55.764 (2) [pool-3-thread-1]: Error: CampID: 19690706002_GM Info: Error during add campaigns request.
2012-02-13 22:11:55.764 (2) [pool-3-thread-1]: Error: CampID: 19690706003_GT Info: Error during add campaigns request.
2012-02-13 22:11:55.764 (2) [pool-3-thread-1]: Error: CampID: 19690706003_GM Info: Error during add campaigns request.
2012-02-13 22:11:55.764 (1) [pool-3-thread-1]: Exception [Error during add campaigns request. ]:com.thesearchagency.admaxlistener.exception.AdMaxException: Did not create the required number of search engine users!
        at com.thesearchagency.admaxlistener.worker.SearchEngineUserWorker.call(SearchEngineUserWorker.java:72)
        at com.thesearchagency.admaxlistener.worker.AccountWorker.createCampaigns(AccountWorker.java:421)
        at com.thesearchagency.admaxlistener.worker.AccountWorker.deploySync(AccountWorker.java:380)
        at com.thesearchagency.admaxlistener.worker.AccountWorker.call(AccountWorker.java:169)
        at com.thesearchagency.admaxlistener.worker.RequestWorker.call(RequestWorker.java:188)
        at com.thesearchagency.admaxlistener.worker.RequestWorker.call(RequestWorker.java:60)
        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)

2012-02-13 22:11:55.764 (4) [pool-3-thread-1]: DataCache: Found key global-clients
2012-02-13 22:11:55.764 (4) [pool-3-thread-1]: Took Existing Object from Pool
2012-02-13 22:11:55.764 (4) [pool-3-thread-1]: spike: SQL->[select @@version]
2012-02-13 22:11:55.766 (4) [pool-3-thread-1]: time=0.0010
2012-02-13 22:11:55.766 (4) [pool-3-thread-1]: Query executed in 0.001s
2012-02-13 22:11:55.766 (4) [pool-3-thread-1]: test query succeeded, returned "5.1.60-rel13.1-log"
2012-02-13 22:11:55.767 (4) [pool-3-thread-1]: DataCache: Found key acct-st-tracker 5850
2012-02-13 22:11:55.767 (4) [pool-3-thread-1]: DataCache: Found key acct-st-tracker-1
2012-02-13 22:11:55.782 (4) [pool-3-thread-1]: opened [jdbc:mysql://acctdb-01-write:3307/st-tracker?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-02-13 22:11:55.783 (4) [pool-3-thread-1]: Created new Object
2012-02-13 22:11:55.783 (4) [pool-3-thread-1]: spike: SQL->[select @@version]
2012-02-13 22:11:55.784 (4) [pool-3-thread-1]: time=0.0010
2012-02-13 22:11:55.784 (4) [pool-3-thread-1]: Query executed in 0.001s
2012-02-13 22:11:55.784 (4) [pool-3-thread-1]: test query succeeded, returned "5.1.60-rel13.1"
2012-02-13 22:11:55.784 (3) [pool-3-thread-1]: Finished DEPLOY request for campaign atultest-7_2000062_22770_19690706001_GT: FAILED
2012-02-13 22:11:55.784 (3) [pool-3-thread-1]: Finished DEPLOY request for campaign atultest-7_2000062_22770_19690706001_GM: FAILED
2012-02-13 22:11:55.784 (3) [pool-3-thread-1]: Finished DEPLOY request for campaign atultest-7_2000062_22771_19690706002_GT: FAILED
2012-02-13 22:11:55.784 (3) [pool-3-thread-1]: Finished DEPLOY request for campaign atultest-7_2000062_22771_19690706002_GM: FAILED
2012-02-13 22:11:55.784 (3) [pool-3-thread-1]: Finished DEPLOY request for campaign atultest-7_2000062_22772_19690706003_GT: FAILED
2012-02-13 22:11:55.785 (3) [pool-3-thread-1]: Finished DEPLOY request for campaign atultest-7_2000062_22772_19690706003_GM: FAILED
2012-02-13 22:11:55.785 (3) [pool-3-thread-1]: atultest-7 has 0 campaigns for a SE Update accounts sync.
2012-02-13 22:11:55.785 (3) [pool-3-thread-1]: atultest-7 has 0 campaigns for a SE Update groups-listings sync.
2012-02-13 22:11:55.785 (3) [pool-3-thread-1]: Finished sub-campaign processing for DEPLOY deploymentID (null). account atultest-7. 6 submitted, 0 ok.
2012-02-13 22:11:55.785 (4) [pool-3-thread-1]: Returning Object to Pool
2012-02-13 22:11:55.785 (4) [pool-3-thread-1]: Returning Object to Pool
2012-02-13 22:11:55.785 (4) [pool-3-thread-1]: Returning Object to Pool
2012-02-13 22:11:55.785 (4) [pool-3-thread-1]: Returning results.
2012-02-13 22:11:55.785 (3) [pool-3-thread-1]: Finished DEPLOY request for atultest-7_2000062_22770_19690706001: FAILED
2012-02-13 22:11:55.785 (3) [pool-3-thread-1]: Finished DEPLOY request for atultest-7_2000062_22771_19690706002: FAILED
2012-02-13 22:11:55.786 (3) [pool-3-thread-1]: Finished DEPLOY request for atultest-7_2000062_22772_19690706003: FAILED
2012-02-13 22:11:55.786 (3) [pool-3-thread-1]: Finished DEPLOY request, deploymentID (null), account atultest-7
2012-02-13 22:11:55.786 (4) [pool-3-thread-1]: spike: SQL->[SELECT RELEASE_LOCK('com.thesearchagency.admaxlistener.dao.TSACommonDAO.atultest-7')]
2012-02-13 22:11:55.787 (4) [pool-3-thread-1]: time=0.0010
2012-02-13 22:11:55.787 (4) [pool-3-thread-1]: Query executed in 0.001s
2012-02-13 22:11:55.788 (4) [pool-3-thread-1]: Released account lock: atultest-7
2012-02-13 22:11:55.788 (4) [pool-3-thread-1]: Returning Object to Pool
2012-02-13 22:11:56.009 (3) [AdMaxListener]: Sent message to response queue.
2012-02-13 22:12:04.478 (4) [ConnectionCloser]: 4 DatabasePools remaining : 6 pending closure
2012-02-13 22:12:20.111 (4) [Timer-0]: ContentEditorPropertiesRefresher: contenteditor.properties last modified 1326374197000
2012-02-13 22:12:34.483 (4) [ConnectionCloser]: 4 DatabasePools remaining : 6 pending closure
2012-02-13 22:12:35.475 (4) [Timer-12]: LicensingFileRefresher: licensing.properties last modified 1326374164000
2012-02-13 22:13:04.485 (4) [ConnectionCloser]: closing db conn
2012-02-13 22:13:04.486 (4) [ConnectionCloser]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-02-13 22:13:04.486 (4) [ConnectionCloser]: closing db conn
2012-02-13 22:13:04.487 (4) [ConnectionCloser]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-02-13 22:13:04.487 (4) [ConnectionCloser]: closing db conn
2012-02-13 22:13:04.487 (4) [ConnectionCloser]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-02-13 22:13:04.487 (4) [ConnectionCloser]: closing db conn
2012-02-13 22:13:04.487 (4) [ConnectionCloser]: closed [jdbc:mysql://clients-01-write:3306/clients?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-02-13 22:13:04.487 (4) [ConnectionCloser]: closing db conn
2012-02-13 22:13:04.488 (4) [ConnectionCloser]: closed [jdbc:mysql://acctdb-01-write:3307/st-tracker?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-02-13 22:13:04.488 (4) [ConnectionCloser]: closing db conn
2012-02-13 22:13:04.488 (4) [ConnectionCloser]: closed [jdbc:mysql://acctdb-01-write:3307/content_editor_google?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-02-13 22:13:04.488 (4) [ConnectionCloser]: 4 DatabasePools remaining : 0 pending closure
2012-02-13 22:13:20.111 (4) [Timer-0]: ContentEditorPropertiesRefresher: contenteditor.properties last modified 1326374197000
2012-02-13 22:13:34.491 (4) [ConnectionCloser]: 4 DatabasePools remaining : 0 pending closure
2012-02-13 22:13:35.476 (4) [Timer-12]: LicensingFileRefresher: licensing.properties last modified 1326374164000
2012-02-13 22:14:04.484 (4) [ConnectionCloser]: 0 DatabasePools remaining : 0 pending closure
2012-02-13 22:14:04.484 (4) [ConnectionCloser]: Stopping DatabasePool ConnectionCloserThread
2012-02-13 22:14:20.116 (4) [Timer-0]: ContentEditorPropertiesRefresher: contenteditor.properties last modified 1326374197000
2012-02-13 22:14:35.482 (4) [Timer-12]: LicensingFileRefresher: licensing.properties last modified 1326374164000
2012-02-13 22:15:20.127 (4) [Timer-0]: ContentEditorPropertiesRefresher: contenteditor.properties last modified 1326374197000
2012-02-13 22:15:35.484 (4) [Timer-12]: LicensingFileRefresher: licensing.properties last modified 1326374164000