[gsingh@optus-qa-agency1 tmp]$ tail -f jmslistener.out 2012-06-27 18:34:25.633 (3) [AdMaxListener]: Queue worker init() called. 2012-06-27 18:34:25.633 (3) [AdMaxListener]: Task connection OK 2012-06-27 18:34:25.640 (4) [AdMaxListener]: Initialized synchronous listener 2012-06-27 18:34:25.640 (3) [AdMaxListener]: Refund queue OK 2012-06-27 18:34:25.641 (3) [AdMaxListener]: Connection Ready 2012-06-27 18:34:25.641 (3) [AdMaxListener]: Job timer disabled, skipping startup. 2012-06-27 18:35:20.601 (4) [Timer-0]: ContentEditorPropertiesRefresher: contenteditor.properties last modified 1337941320000 2012-06-27 18:36:20.607 (4) [Timer-0]: ContentEditorPropertiesRefresher: contenteditor.properties last modified 1337941320000 2012-06-27 18:37:20.621 (4) [Timer-0]: ContentEditorPropertiesRefresher: contenteditor.properties last modified 1337941320000 2012-06-27 18:38:20.625 (4) [Timer-0]: ContentEditorPropertiesRefresher: contenteditor.properties last modified 1337941320000 2012-06-27 18:38:59.596 (4) [Thread-11]: onMessage() called 2012-06-27 18:38:59.637 (4) [Thread-11]: handle() called 2012-06-27 18:38:59.650 (3) [Thread-11]: Request worker created for customerQA4 2012-06-27 18:38:59.650 (3) [Thread-11]: Submitted executor job for customerQA4 2012-06-27 18:38:59.659 (4) [pool-3-thread-1]: no account, or instance for databaseInstance, skipping lookup... 2012-06-27 18:38:59.664 (3) [pool-3-thread-1]: DatabasePool with a limit of 50 created 2012-06-27 18:38:59.680 (4) [ConnectionCloser]: Starting DatabasePool ConnectionCloserThread 2012-06-27 18:38:59.835 (4) [pool-3-thread-1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBeha vior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-06-27 18:38:59.835 (4) [pool-3-thread-1]: Created new Object 2012-06-27 18:38:59.835 (4) [pool-3-thread-1]: spike: SQL->[select @@version] 2012-06-27 18:38:59.866 (4) [pool-3-thread-1]: time=0.03 2012-06-27 18:38:59.866 (4) [pool-3-thread-1]: Query executed in 0.030s 2012-06-27 18:38:59.866 (4) [pool-3-thread-1]: test query succeeded, returned "5.1.60-rel13.1-log" 2012-06-27 18:38:59.867 (4) [pool-3-thread-1]: no account, or instance for databaseInstance, skipping lookup... 2012-06-27 18:38:59.889 (4) [pool-3-thread-1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBeha vior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-06-27 18:38:59.907 (4) [pool-3-thread-1]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`name`="global-clients") and (`type`=" mysql")) limit 1] 2012-06-27 18:38:59.908 (4) [pool-3-thread-1]: time=0.0010 2012-06-27 18:38:59.908 (4) [pool-3-thread-1]: Query executed in 0.001s 2012-06-27 18:38:59.911 (4) [pool-3-thread-1]: Record Loaded 2012-06-27 18:38:59.911 (4) [pool-3-thread-1]: DataCache: put key global-clients 2012-06-27 18:38:59.912 (4) [pool-3-thread-1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBeha vior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-06-27 18:38:59.912 (3) [pool-3-thread-1]: DatabasePool with a limit of 50 created 2012-06-27 18:38:59.935 (4) [pool-3-thread-1]: opened [jdbc:mysql://clients-01-write:3306/clients?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBeh avior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-06-27 18:38:59.935 (4) [pool-3-thread-1]: Created new Object 2012-06-27 18:38:59.935 (4) [pool-3-thread-1]: spike: SQL->[select @@version] 2012-06-27 18:38:59.937 (4) [pool-3-thread-1]: time=0.0010 2012-06-27 18:38:59.937 (4) [pool-3-thread-1]: Query executed in 0.001s 2012-06-27 18:38:59.937 (4) [pool-3-thread-1]: test query succeeded, returned "5.1.60-rel13.1-log" 2012-06-27 18:38:59.941 (4) [pool-3-thread-1]: spike: SQL->[SELECT GET_LOCK('com.thesearchagency.admaxlistener.dao.TSACommonDAO.customerQA4', 7200)] 2012-06-27 18:38:59.942 (4) [pool-3-thread-1]: time=0.0010 2012-06-27 18:38:59.942 (4) [pool-3-thread-1]: Query executed in 0.001s 2012-06-27 18:38:59.943 (4) [pool-3-thread-1]: spike: SQL->[select * from `tsacommon`.`accounts` where ((`description`="customerQA4")) limit 1] 2012-06-27 18:38:59.945 (4) [pool-3-thread-1]: time=0.0020 2012-06-27 18:38:59.945 (4) [pool-3-thread-1]: Query executed in 0.002s 2012-06-27 18:38:59.947 (4) [pool-3-thread-1]: Record Loaded 2012-06-27 18:39:00.122 (4) [pool-3-thread-1]: no account, or instance for databaseInstance, skipping lookup... 2012-06-27 18:39:00.146 (4) [pool-3-thread-1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBeha vior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-06-27 18:39:00.147 (4) [pool-3-thread-1]: spike: SQL->[select * from `tsacommon`.`accounts` where (`id`=5904) limit 1] 2012-06-27 18:39:00.148 (4) [pool-3-thread-1]: time=0.0010 2012-06-27 18:39:00.148 (4) [pool-3-thread-1]: Query executed in 0.001s 2012-06-27 18:39:00.149 (4) [pool-3-thread-1]: Record Loaded 2012-06-27 18:39:00.150 (4) [pool-3-thread-1]: DataCache: put key acct-st-tracker 5904 2012-06-27 18:39:00.150 (4) [pool-3-thread-1]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`name`="acct-st-tracker-1") and (`type `="mysql")) limit 1] 2012-06-27 18:39:00.151 (4) [pool-3-thread-1]: time=0.0010 2012-06-27 18:39:00.151 (4) [pool-3-thread-1]: Query executed in 0.001s 2012-06-27 18:39:00.152 (4) [pool-3-thread-1]: Record Loaded 2012-06-27 18:39:00.152 (4) [pool-3-thread-1]: DataCache: put key acct-st-tracker-1 2012-06-27 18:39:00.153 (4) [pool-3-thread-1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBeha vior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-06-27 18:39:00.153 (3) [pool-3-thread-1]: DatabasePool with a limit of 50 created 2012-06-27 18:39:00.180 (4) [pool-3-thread-1]: opened [jdbc:mysql://acctdb-01-write:3307/st-tracker?useUnicode=true&characterEncoding=UTF8&zeroDateTimeB ehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-06-27 18:39:00.180 (4) [pool-3-thread-1]: Created new Object 2012-06-27 18:39:00.181 (4) [pool-3-thread-1]: spike: SQL->[select @@version] 2012-06-27 18:39:00.182 (4) [pool-3-thread-1]: time=0.0010 2012-06-27 18:39:00.182 (4) [pool-3-thread-1]: Query executed in 0.001s 2012-06-27 18:39:00.182 (4) [pool-3-thread-1]: test query succeeded, returned "5.1.60-rel13.1" 2012-06-27 18:39:00.182 (3) [pool-3-thread-1]: Updating account tables for customerQA4 2012-06-27 18:39:00.182 (4) [pool-3-thread-1]: DataCache: Found key acct-st-tracker 5904 2012-06-27 18:39:00.182 (4) [pool-3-thread-1]: DataCache: Found key acct-st-tracker-1 2012-06-27 18:39:00.218 (4) [pool-3-thread-1]: opened [jdbc:mysql://acctdb-01-write:3307/st-tracker?useUnicode=true&characterEncoding=UTF8&zeroDateTimeB ehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-06-27 18:39:00.218 (4) [pool-3-thread-1]: Created new Object 2012-06-27 18:39:00.218 (4) [pool-3-thread-1]: spike: SQL->[select @@version] 2012-06-27 18:39:00.219 (4) [pool-3-thread-1]: time=0.0010 2012-06-27 18:39:00.220 (4) [pool-3-thread-1]: Query executed in 0.001s 2012-06-27 18:39:00.220 (4) [pool-3-thread-1]: test query succeeded, returned "5.1.60-rel13.1" 2012-06-27 18:39:00.220 (4) [pool-3-thread-1]: DB AutoCommit -> false 2012-06-27 18:39:00.223 (4) [pool-3-thread-1]: spike: SQL->[replace into `accountChannelMap` (`accountID`,`channelID`) values (5904,1)], genflags=yes 2012-06-27 18:39:00.224 (4) [pool-3-thread-1]: time=0.0020 2012-06-27 18:39:00.224 (4) [pool-3-thread-1]: Query executed in 0.002s, 1 row(s) affected 2012-06-27 18:39:00.231 (4) [pool-3-thread-1]: spike: SQL->[select * from `settings` where ((((`settings`.`scope`="accounts")) and ((`settings`.`scopeId `=5904))))] 2012-06-27 18:39:00.233 (4) [pool-3-thread-1]: time=0.0020 2012-06-27 18:39:00.233 (4) [pool-3-thread-1]: Query executed in 0.002s 2012-06-27 18:39:00.234 (4) [pool-3-thread-1]: spike: SQL->[select * from `settingDefaults` where (`settingDefaults`.`scope`="accounts")] 2012-06-27 18:39:00.236 (4) [pool-3-thread-1]: time=0.0020 2012-06-27 18:39:00.236 (4) [pool-3-thread-1]: Query executed in 0.002s 2012-06-27 18:39:00.239 (4) [pool-3-thread-1]: spike: SQL->[replace into `settings` values ("usesTSAWaypoints","accounts",5904,"false")], genflags=no 2012-06-27 18:39:00.240 (4) [pool-3-thread-1]: time=0.0010 2012-06-27 18:39:00.240 (4) [pool-3-thread-1]: Query executed in 0.001s, 2 row(s) affected 2012-06-27 18:39:00.240 (4) [pool-3-thread-1]: spike: SQL->[replace into `settings` values ("usesDatafeed","accounts",5904,"true")], genflags=no 2012-06-27 18:39:00.242 (4) [pool-3-thread-1]: time=0.0020 2012-06-27 18:39:00.242 (4) [pool-3-thread-1]: Query executed in 0.002s, 1 row(s) affected 2012-06-27 18:39:00.242 (4) [pool-3-thread-1]: DataCache: Key accounts 5904 removed. 2012-06-27 18:39:00.242 (3) [pool-3-thread-1]: Committing Account settings for 5904 2012-06-27 18:39:00.242 (4) [pool-3-thread-1]: spike: SQL->[commit] 2012-06-27 18:39:00.286 (4) [pool-3-thread-1]: time=0.044 2012-06-27 18:39:00.286 (4) [pool-3-thread-1]: Query executed in 0.044s 2012-06-27 18:39:00.286 (4) [pool-3-thread-1]: DB AutoCommit -> true 2012-06-27 18:39:00.287 (4) [pool-3-thread-1]: Returning Object to Pool 2012-06-27 18:39:00.288 (4) [pool-3-thread-1]: preparing SQL statement [select id from clients.externalCampaignParent where typeID = ? and accountID = ? and status != ?] 2012-06-27 18:39:00.308 (3) [pool-3-thread-1]: Updating deployment status to 'InProgress' for campaignID: campaign4 2012-06-27 18:39:00.309 (4) [pool-3-thread-1]: preparing SQL statement [update clients.externalCampaignParentDeployStatus set status = ? where descripti on = ?] 2012-06-27 18:39:00.312 (4) [pool-3-thread-1]: preparing SQL statement [select id, description, accountID, admaxCampaignID, status, typeID from clients. externalCampaignParent where description = ?] 2012-06-27 18:39:00.313 (3) [pool-3-thread-1]: campaign4 has no parent. Creating... 2012-06-27 18:39:00.315 (4) [pool-3-thread-1]: preparing SQL statement [insert into `st-tracker`.admaxCampaigns (identifier, description, accountID, cam paignGroupingID, status) values (?,?,?,?,?)], genflags=yes 2012-06-27 18:39:00.318 (4) [pool-3-thread-1]: preparing SQL statement [insert into `st-tracker`.admaxCampaignBudgetAccrualStatus(admaxCampaignID,startD ate,status) values(?,?,?)] 2012-06-27 18:39:00.320 (4) [pool-3-thread-1]: preparing SQL statement [insert into clients.externalCampaignParent (description, accountID, admaxCampaig nID, status, typeID) values (?, ?, ?, ?, ?)], genflags=yes 2012-06-27 18:39:00.322 (4) [pool-3-thread-1]: preparing SQL statement [update clients.externalCampaignParent set status = ? where id = ?] 2012-06-27 18:39:00.324 (4) [pool-3-thread-1]: preparing SQL statement [update `st-tracker`.admaxCampaigns set status = ? where id = ?] 2012-06-27 18:39:00.325 (3) [pool-3-thread-1]: Updating advert budget for customerQA4_2000062_10005_campaign4 2012-06-27 18:39:00.326 (4) [pool-3-thread-1]: preparing SQL statement [select ID,admaxCampaignID,startDate,endDate,budget from `st-tracker`.admaxNomina lMonthlyBudgets where admaxCampaignID=? and startDate<=? and (endDate is null or endDate>=?)] 2012-06-27 18:39:00.328 (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-06-27 18:39:00.330 (4) [pool-3-thread-1]: Returning Object to Pool 2012-06-27 18:39:00.330 (4) [pool-3-thread-1]: Returning Object to Pool 2012-06-27 18:39:00.330 (4) [pool-3-thread-1]: preparing SQL statement [select id, description, accountID, admaxCampaignID, status, typeID from clients. externalCampaignParent where accountID = ? and status != ?] 2012-06-27 18:39:00.332 (4) [pool-3-thread-1]: preparing SQL statement [select c.id from clients.externalCampaignParent p join clients.externalCampaign c on(p.id = c.externalCampaignParentID) where p.description = ?] 2012-06-27 18:39:00.337 (4) [pool-3-thread-1]: no account, or instance for databaseInstance, skipping lookup... 2012-06-27 18:39:00.360 (4) [pool-3-thread-1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBeha vior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-06-27 18:39:00.360 (4) [pool-3-thread-1]: Created new Object 2012-06-27 18:39:00.360 (4) [pool-3-thread-1]: spike: SQL->[select @@version] 2012-06-27 18:39:00.361 (4) [pool-3-thread-1]: time=0.0010 2012-06-27 18:39:00.361 (4) [pool-3-thread-1]: Query executed in 0.001s 2012-06-27 18:39:00.361 (4) [pool-3-thread-1]: test query succeeded, returned "5.1.60-rel13.1-log" 2012-06-27 18:39:00.362 (3) [pool-3-thread-1]: Start processing DEPLOY request (1) for account customerQA4. 3 campaign(s). 2012-06-27 18:39:00.362 (4) [pool-3-thread-1]: Locked account: customerQA4 2012-06-27 18:39:00.372 (3) [pool-3-thread-1]: LicensingFileRefresher: modification detected on 1337940573000 for licensing.properties 2012-06-27 18:39:00.372 (3) [pool-3-thread-1]: Licensing environment detected, loading configuration. 2012-06-27 18:39:00.411 (3) [pool-3-thread-1]: Loaded property: tsa.google.mcc.email=optusbooster@gmail.com 2012-06-27 18:39:00.411 (3) [pool-3-thread-1]: Loaded property: tsa.google.mcc.password=optus789 2012-06-27 18:39:00.411 (3) [pool-3-thread-1]: Loaded property: tsa.google.mcc.developerToken=ojCnjZaM6RD1h0yt_DOJZg 2012-06-27 18:39:00.411 (3) [pool-3-thread-1]: Loaded property: tsa.google.mcc.applicationToken=none 2012-06-27 18:39:00.411 (3) [pool-3-thread-1]: Loaded property: tsa.google.mcc.isReseller=true 2012-06-27 18:39:00.411 (3) [pool-3-thread-1]: Loaded property: tsa.google.mcc.userAgent=Optus AdWords Software 2012-06-27 18:39:00.411 (3) [pool-3-thread-1]: Loaded property: tsa.google.isSandbox=false 2012-06-27 18:39:00.411 (3) [pool-3-thread-1]: Loaded property: tsa.google.sandbox.currency=AUD 2012-06-27 18:39:00.412 (3) [pool-3-thread-1]: Loaded property: tsa.timezone=Australia/Sydney 2012-06-27 18:39:00.417 (3) [pool-3-thread-1]: Performing sync for account: customerQA4 ID#5904 2012-06-27 18:39:00.417 (4) [pool-3-thread-1]: no account, or instance for databaseInstance, skipping lookup... 2012-06-27 18:39:00.440 (4) [pool-3-thread-1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBeha vior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-06-27 18:39:00.440 (4) [pool-3-thread-1]: Created new Object 2012-06-27 18:39:00.440 (4) [pool-3-thread-1]: spike: SQL->[select @@version] 2012-06-27 18:39:00.442 (4) [pool-3-thread-1]: time=0.0020 2012-06-27 18:39:00.442 (4) [pool-3-thread-1]: Query executed in 0.002s 2012-06-27 18:39:00.442 (4) [pool-3-thread-1]: test query succeeded, returned "5.1.60-rel13.1-log" 2012-06-27 18:39:00.442 (4) [pool-3-thread-1]: DataCache: Found key global-clients 2012-06-27 18:39:00.442 (4) [pool-3-thread-1]: Took Existing Object from Pool 2012-06-27 18:39:00.442 (4) [pool-3-thread-1]: spike: SQL->[select @@version] 2012-06-27 18:39:00.443 (4) [pool-3-thread-1]: time=0.0010 2012-06-27 18:39:00.443 (4) [pool-3-thread-1]: Query executed in 0.001s 2012-06-27 18:39:00.444 (4) [pool-3-thread-1]: test query succeeded, returned "5.1.60-rel13.1-log" 2012-06-27 18:39:00.444 (4) [pool-3-thread-1]: preparing SQL statement [select id, externalCampaignParentID, gceCampaignID, searchEngineAccountID, accou ntID, enabled from clients.externalCampaign where id = ?] 2012-06-27 18:39:00.445 (4) [pool-3-thread-1]: preparing SQL statement [select id, description, accountID, admaxCampaignID, status, typeID from clients. externalCampaignParent where description = ?] 2012-06-27 18:39:00.456 (4) [pool-3-thread-1]: Converted proximity target: latitude: -33.8638 longitude: 150.985 radius: 929 Converted lat: -33863800 lon: 150985008 radius unit: meters radius: 929 2012-06-27 18:39:00.462 (4) [pool-3-thread-1]: preparing SQL statement [select id, externalCampaignParentID, gceCampaignID, searchEngineAccountID, accou ntID, enabled from clients.externalCampaign where id = ?] 2012-06-27 18:39:00.464 (4) [pool-3-thread-1]: preparing SQL statement [select id, description, accountID, admaxCampaignID, status, typeID from clients. externalCampaignParent where description = ?] 2012-06-27 18:39:00.466 (4) [pool-3-thread-1]: preparing SQL statement [select id, externalCampaignParentID, gceCampaignID, searchEngineAccountID, accou ntID, enabled from clients.externalCampaign where id = ?] 2012-06-27 18:39:00.468 (4) [pool-3-thread-1]: preparing SQL statement [select id, description, accountID, admaxCampaignID, status, typeID from clients. externalCampaignParent where description = ?] 2012-06-27 18:39:00.469 (4) [pool-3-thread-1]: Converted proximity target: latitude: -33.8638 longitude: 150.985 radius: 929 Converted lat: -33863800 lon: 150985008 radius unit: meters radius: 929 2012-06-27 18:39:00.470 (4) [pool-3-thread-1]: Returning Object to Pool 2012-06-27 18:39:00.470 (4) [pool-3-thread-1]: Returning Object to Pool 2012-06-27 18:39:00.470 (3) [pool-3-thread-1]: 0 campaign(s) to update. 2012-06-27 18:39:00.470 (3) [pool-3-thread-1]: 3 campaign(s) to create. 2012-06-27 18:39:00.470 (3) [pool-3-thread-1]: 0 campaign(s) to retry and update. 2012-06-27 18:39:00.470 (4) [pool-3-thread-1]: no account, or instance for databaseInstance, skipping lookup... 2012-06-27 18:39:00.470 (4) [pool-3-thread-1]: Took Existing Object from Pool 2012-06-27 18:39:00.470 (4) [pool-3-thread-1]: spike: SQL->[select @@version] 2012-06-27 18:39:00.473 (4) [pool-3-thread-1]: time=0.0030 2012-06-27 18:39:00.473 (4) [pool-3-thread-1]: Query executed in 0.003s 2012-06-27 18:39:00.473 (4) [pool-3-thread-1]: test query succeeded, returned "5.1.60-rel13.1-log" 2012-06-27 18:39:00.474 (4) [pool-3-thread-1]: DataCache: Found key global-clients 2012-06-27 18:39:00.474 (4) [pool-3-thread-1]: Took Existing Object from Pool 2012-06-27 18:39:00.474 (4) [pool-3-thread-1]: spike: SQL->[select @@version] 2012-06-27 18:39:00.475 (4) [pool-3-thread-1]: time=0.0010 2012-06-27 18:39:00.475 (4) [pool-3-thread-1]: Query executed in 0.001s 2012-06-27 18:39:00.475 (4) [pool-3-thread-1]: test query succeeded, returned "5.1.60-rel13.1-log" 2012-06-27 18:39:00.475 (4) [pool-3-thread-1]: SearchEngineUserWorker initialized for account: 5904 2012-06-27 18:39:00.476 (4) [pool-3-thread-1]: preparing SQL statement [select u.id, count(case when a.searchEngineStatus = ? then null else a.id end) f rom tsacommon.searchEngineUsers u left join tsacommon.searchEngineAccounts a on(u.id = a.searchEngineUserID and a.accountID = u.accountID) where u.accou ntID = ? and u.enabled = 'true' group by u.id order by u.id asc] 2012-06-27 18:39:00.478 (3) [pool-3-thread-1]: customerQA4 has 3 new campaign(s). 2012-06-27 18:39:00.478 (3) [pool-3-thread-1]: customerQA4 requires 1 new users. 2012-06-27 18:39:00.478 (4) [pool-3-thread-1]: preparing SQL statement [select count(1) from tsacommon.searchEngineUsers u where u.accountID = ? ] 2012-06-27 18:39:00.481 (4) [pool-3-thread-1]: spike: SQL->[insert into `tsacommon`.`searchEngineUsers` (`distributionID`,`enabled`,`accountID`,`descrip tion`,`inTsaMcc`) values (3,"false",5904,"customerQA4_1","true")], genflags=yes 2012-06-27 18:39:00.484 (4) [pool-3-thread-1]: time=0.0030 2012-06-27 18:39:00.484 (4) [pool-3-thread-1]: Query executed in 0.003s, 1 row(s) affected 2012-06-27 18:39:00.484 (3) [pool-3-thread-1]: Created 1 SE user row(s). 2012-06-27 18:39:00.487 (3) [pool-3-thread-1]: Calling GCE to create 1 SE users. 2012-06-27 18:39:00.497 (4) [pool-3-thread-1]: no account, or instance for databaseInstance, skipping lookup... 2012-06-27 18:39:00.524 (4) [pool-3-thread-1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBeha vior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-06-27 18:39:00.525 (4) [pool-3-thread-1]: spike: SQL->[select * from `tsacommon`.`accounts` where (`id`=5904) limit 1] 2012-06-27 18:39:00.526 (4) [pool-3-thread-1]: time=0.0010 2012-06-27 18:39:00.526 (4) [pool-3-thread-1]: Query executed in 0.001s 2012-06-27 18:39:00.527 (4) [pool-3-thread-1]: Record Loaded 2012-06-27 18:39:00.527 (4) [pool-3-thread-1]: DataCache: put key acct-content-google 5904 2012-06-27 18:39:00.528 (4) [pool-3-thread-1]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`name`="acct-content-google-1") and (` type`="mysql")) limit 1] 2012-06-27 18:39:00.529 (4) [pool-3-thread-1]: time=0.0010 2012-06-27 18:39:00.529 (4) [pool-3-thread-1]: Query executed in 0.001s 2012-06-27 18:39:00.530 (4) [pool-3-thread-1]: Record Loaded 2012-06-27 18:39:00.530 (4) [pool-3-thread-1]: DataCache: put key acct-content-google-1 2012-06-27 18:39:00.530 (4) [pool-3-thread-1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBeha vior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-06-27 18:39:00.530 (3) [pool-3-thread-1]: DatabasePool with a limit of 50 created 2012-06-27 18:39:00.564 (4) [pool-3-thread-1]: opened [jdbc:mysql://acctdb-01-write:3307/content_editor_google?useUnicode=true&characterEncoding=UTF8&ze roDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-06-27 18:39:00.564 (4) [pool-3-thread-1]: Created new Object 2012-06-27 18:39:00.564 (4) [pool-3-thread-1]: spike: SQL->[select @@version] 2012-06-27 18:39:00.565 (4) [pool-3-thread-1]: time=0.0010 2012-06-27 18:39:00.565 (4) [pool-3-thread-1]: Query executed in 0.001s 2012-06-27 18:39:00.565 (4) [pool-3-thread-1]: test query succeeded, returned "5.1.60-rel13.1" 2012-06-27 18:39:00.565 (4) [pool-3-thread-1]: DB AutoCommit -> true 2012-06-27 18:39:00.570 (4) [pool-3-thread-1]: preparing SQL statement [INSERT INTO gce_googleAccount (accountID, loginEmail, password, currencyCode, de scriptiveName, languagePreference, timeZoneId, addressLine1, addressLine2, city, companyName, countryCode, emailAddress, faxNumber, phoneNumber, state, postalCode, name, accountPerformanceEnabled, disapprovedAdsEnabled, marketResearchEnabled, newsletterEnabled, promotionsEnabled, parentClientCustomerID, parentClientEmail) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] 2012-06-27 18:39:00.574 (4) [pool-3-thread-1]: spike: SQL->[SELECT LAST_INSERT_ID()] 2012-06-27 18:39:00.576 (2) [pool-3-thread-1]: Warning(s) detected in statement [SELECT LAST_INSERT_ID()] executed by user [spike] 2012-06-27 18:39:00.576 (2) [pool-3-thread-1]: Field 'primaryBusinessCategory' doesn't have a default value (1364) 2012-06-27 18:39:00.576 (4) [pool-3-thread-1]: time=0.0020 2012-06-27 18:39:00.576 (4) [pool-3-thread-1]: Query executed in 0.002s 2012-06-27 18:39:00.578 (4) [pool-3-thread-1]: spike: SQL->[insert into `content_editor_google`.`gce_googleAccountPendingChange` (`googleAccountID`,`isF ailed`,`requestTime`,`tryCount`,`type`) values (15,"false","2012-06-27 18:39:00",0,"add") on duplicate key update `isFailed`="false",`requestTime`="2012 -06-27 18:39:00",`tryCount`=0,`type`=IF((`type`="add"), "add", "add")], genflags=no 2012-06-27 18:39:00.580 (4) [pool-3-thread-1]: time=0.0010 2012-06-27 18:39:00.580 (4) [pool-3-thread-1]: Query executed in 0.001s, 1 row(s) affected 2012-06-27 18:39:00.580 (4) [pool-3-thread-1]: Inserted a new pending change 2012-06-27 18:39:00.580 (4) [pool-3-thread-1]: DB AutoCommit -> true 2012-06-27 18:39:00.580 (4) [pool-3-thread-1]: Returning Object to Pool 2012-06-27 18:39:00.580 (4) [pool-3-thread-1]: no account, or instance for databaseInstance, skipping lookup... 2012-06-27 18:39:00.581 (3) [pool-3-thread-1]: ----------------Google Content Editor starting 2012-06-27 18:39:00.603 (4) [pool-3-thread-1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBeha vior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-06-27 18:39:00.603 (4) [pool-3-thread-1]: spike: SQL->[select * from `tsacommon`.`accounts` where ((`tsacommon`.`accounts`.`id` in (5904))) order b y rand()] 2012-06-27 18:39:00.605 (4) [pool-3-thread-1]: time=0.0020 2012-06-27 18:39:00.605 (4) [pool-3-thread-1]: Query executed in 0.002s 2012-06-27 18:39:00.609 (3) [P1T1]: Creating Google accounts for accountID 5904 2012-06-27 18:39:00.735 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup... 2012-06-27 18:39:00.757 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=conver tToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-06-27 18:39:00.757 (4) [P1T1]: spike: SQL->[select `id`,`shortCode` from distribution where ((`searchEngineClass` is not null) and (`searchEngineCl ass`!=""))] 2012-06-27 18:39:00.758 (4) [P1T1]: time=0.0010 2012-06-27 18:39:00.759 (4) [P1T1]: Query executed in 0.001s 2012-06-27 18:39:00.759 (4) [P1T1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=conver tToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-06-27 18:39:00.761 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup... 2012-06-27 18:39:00.776 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=conver tToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-06-27 18:39:00.777 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`name`="global-sesystem") and (`type`="mysql")) l imit 1] 2012-06-27 18:39:00.778 (4) [P1T1]: time=0.0010 2012-06-27 18:39:00.778 (4) [P1T1]: Query executed in 0.001s 2012-06-27 18:39:00.778 (4) [P1T1]: Record Loaded 2012-06-27 18:39:00.778 (4) [P1T1]: DataCache: put key global-sesystem 2012-06-27 18:39:00.778 (4) [P1T1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=conver tToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-06-27 18:39:00.793 (4) [P1T1]: opened [jdbc:mysql://sesystem-01-write:3308/sesystem?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=con vertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-06-27 18:39:00.793 (3) [P1T1]: Created shared sesystem connection rw 2012-06-27 18:39:00.793 (4) [P1T1]: sesystem: SQL->[select 1] 2012-06-27 18:39:00.794 (4) [P1T1]: time=0.0010 2012-06-27 18:39:00.794 (4) [P1T1]: Query executed in 0.001s 2012-06-27 18:39:00.795 (4) [P1T1]: sesystem: SQL->[select `authToken`,`date` from `sesystem`.`googleAuthToken` where ((`seUserID`=0))] 2012-06-27 18:39:00.796 (4) [P1T1]: time=0.0010 2012-06-27 18:39:00.797 (4) [P1T1]: Query executed in 0.001s 2012-06-27 18:39:00.805 (4) [P1T1]: MasterAuthToken retrieved from database [DQAAALYAAACa_J0yCMkiTucZsP1Mn9MCJ93lb3wEOELW_bceCHP5g6Uwl3Sz5IrtShhDiM74iOH muSHp-M7-E24QlxsfRBqYN0JvZ3MXCEg-VxrgVtMecamGfRGsfwgOXBT2l0lkSzMUCxLY69KbYWMI28M2oRzvyV9mkj623Ty-fkMdb54JWqSZQF4w1quellXAaHYQs5VTfFEso2lwP4FXgC4wFvlagd9 0Wq8FCSikbaLGV6PKTRJy1gM6j0To3cQt38E9kSo] for search engine user ID[0] 2012-06-27 18:39:00.805 (4) [P1T1]: seuserid[null] username[null] password[null] customerID[null] 2012-06-27 18:39:00.807 (2) [P1T1]: secureProxy : null:null 2012-06-27 18:39:00.807 (2) [P1T1]: normalProxy : null:null 2012-06-27 18:39:00.807 (2) [P1T1]: No secure proxy configuration detected. 2012-06-27 18:39:00.807 (2) [P1T1]: No proxy configuration detected. 2012-06-27 18:39:00.812 (4) [P1T1]: ClearConnections called at: Wed Jun 27 18:39:00 EST 2012 Timer: 0 2012-06-27 18:39:00.813 (4) [P1T1]: sesystem: SQL->[select 1] 2012-06-27 18:39:00.815 (4) [P1T1]: time=0.0010 2012-06-27 18:39:00.815 (4) [P1T1]: Query executed in 0.001s 2012-06-27 18:39:00.815 (4) [P1T1]: sesystem: SQL->[update `sesystem`.`searchEngineConnections` set `holder`="",`inUse`="false",`holderIdentifier`="",`t imeStamp`="2012-06-27 18:39:00" where ((`sesystem`.`searchEngineConnections`.`distributionID`=3) and (`sesystem`.`searchEngineConnections`.`inUse`="true ") and (`sesystem`.`searchEngineConnections`.`timeStamp`<="2012-06-27 18:34:00")) limit 1], genflags=no 2012-06-27 18:39:00.921 (4) [P1T1]: time=0.106 2012-06-27 18:39:00.921 (4) [P1T1]: Query executed in 0.106s, 0 row(s) affected 2012-06-27 18:39:00.926 (4) [P1T1]: Setting AuthToken [DQAAALYAAACa_J0yCMkiTucZsP1Mn9MCJ93lb3wEOELW_bceCHP5g6Uwl3Sz5IrtShhDiM74iOHmuSHp-M7-E24QlxsfRBqYN 0JvZ3MXCEg-VxrgVtMecamGfRGsfwgOXBT2l0lkSzMUCxLY69KbYWMI28M2oRzvyV9mkj623Ty-fkMdb54JWqSZQF4w1quellXAaHYQs5VTfFEso2lwP4FXgC4wFvlagd90Wq8FCSikbaLGV6PKTRJy1 gM6j0To3cQt38E9kSo] to AdWordsUser object for username[optusbooster@gmail.com] 2012-06-27 18:39:02.287 (4) [P1T1]: DataCache: Found key acct-content-google 5904 2012-06-27 18:39:02.287 (4) [P1T1]: DataCache: Found key acct-content-google-1 2012-06-27 18:39:02.304 (4) [P1T1]: Took Existing Object from Pool 2012-06-27 18:39:02.305 (4) [P1T1]: spike: SQL->[select @@version] 2012-06-27 18:39:02.317 (4) [P1T1]: time=0.012 2012-06-27 18:39:02.317 (4) [P1T1]: Query executed in 0.012s 2012-06-27 18:39:02.317 (4) [P1T1]: test query succeeded, returned "5.1.60-rel13.1" 2012-06-27 18:39:02.320 (4) [P1T1]: spike: SQL->[select `content_editor_google`.`gce_googleAccount`.*,`content_editor_google`.`gce_googleAccountPendingC hange`.* from `content_editor_google`.`gce_googleAccount` join `gce_googleAccountPendingChange` on ((`content_editor_google`.`gce_googleAccountPendingCh ange`.`googleAccountID`=`content_editor_google`.`gce_googleAccount`.`id`)) where ((((((`isFailed`="true") and (`tryCount`<10))) or ((`isFailed`="false") ))) and (`type`="add") and (`accountID`=5904))] 2012-06-27 18:39:02.323 (4) [P1T1]: time=0.0030 2012-06-27 18:39:02.323 (4) [P1T1]: Query executed in 0.003s 2012-06-27 18:39:02.325 (3) [P1T1]: Returning null, 9893992638 2012-06-27 18:39:02.326 (3) [P1T1]: GoogleAccountChangeRequest (accountID 5904): Sending 1 add requests 2012-06-27 18:39:02.326 (4) [P1T1]: GoogleAccountChangeRequest (accountID 5904): : Sending 1 adds 2012-06-27 18:39:02.326 (4) [P1T1]: DataCache: Found key global-sesystem 2012-06-27 18:39:02.326 (3) [P1T1]: DatabasePool with a limit of 10 created 2012-06-27 18:39:02.340 (4) [P1T1]: opened [jdbc:mysql://sesystem-01-write:3308/sesystem?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=con vertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-06-27 18:39:02.340 (4) [P1T1]: Created new Object 2012-06-27 18:39:02.340 (4) [P1T1]: sesystem: SQL->[select @@version] 2012-06-27 18:39:02.342 (4) [P1T1]: time=0.0020 2012-06-27 18:39:02.342 (4) [P1T1]: Query executed in 0.002s 2012-06-27 18:39:02.342 (4) [P1T1]: test query succeeded, returned "5.1.60-rel13.1" 2012-06-27 18:39:02.342 (4) [P1T1]: sesystem: SQL->[SELECT GET_LOCK('com.thesearchagency.searchengines.google.contenteditor.dao.account.createAccountsLo ck', 900)] 2012-06-27 18:39:02.344 (4) [P1T1]: time=0.0020 2012-06-27 18:39:02.344 (4) [P1T1]: Query executed in 0.002s 2012-06-27 18:39:02.344 (4) [P1T1]: Returning Object to Pool 2012-06-27 18:39:02.344 (3) [P1T1]: Creating account in 9893992638 2012-06-27 18:39:02.541 (4) [P1T1]: sesystem: SQL->[select 1] 2012-06-27 18:39:02.543 (4) [P1T1]: time=0.0020 2012-06-27 18:39:02.543 (4) [P1T1]: Query executed in 0.002s 2012-06-27 18:39:02.543 (4) [P1T1]: sesystem: SQL->[update `sesystem`.`searchEngineConnections` set `searchEngineUserID`=0,`inUse`="true",`holder`="crea teClientAccount",`holderIdentifier`="null",`timeStamp`="2012-06-27 18:39:02" where ((`sesystem`.`searchEngineConnections`.`distributionID`=3) and (`sesy stem`.`searchEngineConnections`.`inUse`="false") and (`sesystem`.`searchEngineConnections`.`owner` is null) and (`sesystem`.`searchEngineConnections`.`s earchEngineUserID`=0)) limit 1], genflags=no 2012-06-27 18:39:02.545 (4) [P1T1]: time=0.0020 2012-06-27 18:39:02.545 (4) [P1T1]: Query executed in 0.002s, 1 row(s) affected 2012-06-27 18:39:04.064 (4) [P1T1]: sesystem: SQL->[select 1] 2012-06-27 18:39:04.065 (4) [P1T1]: time=0.0010 2012-06-27 18:39:04.066 (4) [P1T1]: Query executed in 0.001s 2012-06-27 18:39:04.067 (4) [P1T1]: sesystem: SQL->[select * from `sesystem`.`searchEngineResources` where ((`distributionID`=3) and (`operation`="creat eClientAccount")) limit 1] 2012-06-27 18:39:04.068 (4) [P1T1]: time=0.0010 2012-06-27 18:39:04.069 (4) [P1T1]: Query executed in 0.001s 2012-06-27 18:39:04.069 (4) [P1T1]: Record Loaded 2012-06-27 18:39:04.070 (4) [P1T1]: sesystem: SQL->[insert into `sesystem`.`searchEngineResourceUsage` (`sesystem`.`searchEngineResourceUsage`.`resource ID`,`sesystem`.`searchEngineResourceUsage`.`periodStart`,`sesystem`.`searchEngineResourceUsage`.`holderID`,`sesystem`.`searchEngineResourceUsage`.`lastU sage`,`sesystem`.`searchEngineResourceUsage`.`opCount`) values (212,"2012-06-27 17:00:00","null",NOW(),1) on duplicate key update `sesystem`.`searchEng ineResourceUsage`.`opCount`=`sesystem`.`searchEngineResourceUsage`.`opCount`+1,`sesystem`.`searchEngineResourceUsage`.`lastUsage`=NOW()], genflags=no 2012-06-27 18:39:04.073 (4) [P1T1]: time=0.0030 2012-06-27 18:39:04.073 (4) [P1T1]: Query executed in 0.003s, 1 row(s) affected 2012-06-27 18:39:04.073 (4) [P1T1]: Operations for createClientAccount: 0 2012-06-27 18:39:04.073 (4) [P1T1]: Quota units for createClientAccount: 0 2012-06-27 18:39:04.073 (4) [P1T1]: Google Master account used 0 quota on resourceID 212(createClientAccount) 2012-06-27 18:39:04.075 (4) [P1T1]: sesystem: SQL->[select 1] 2012-06-27 18:39:04.076 (4) [P1T1]: time=0.0020 2012-06-27 18:39:04.076 (4) [P1T1]: Query executed in 0.002s 2012-06-27 18:39:04.077 (4) [P1T1]: sesystem: SQL->[insert into `sesystem`.`quotaUsage` values ("0","212","2012-06-27","0","0") on duplicate key update `quotaUsed`=`quotaUsed`+0,`operations`=`operations`+0], genflags=no 2012-06-27 18:39:04.078 (4) [P1T1]: time=0.0010 2012-06-27 18:39:04.078 (4) [P1T1]: Query executed in 0.001s, 1 row(s) affected 2012-06-27 18:39:04.078 (4) [P1T1]: Quota recorded for seUser #0: 0 quota used for resource ID 212 2012-06-27 18:39:04.080 (4) [P1T1]: sesystem: SQL->[select 1] 2012-06-27 18:39:04.081 (4) [P1T1]: time=0.0010 2012-06-27 18:39:04.081 (4) [P1T1]: Query executed in 0.001s 2012-06-27 18:39:04.081 (4) [P1T1]: sesystem: SQL->[update `sesystem`.`searchEngineConnections` set `holder`="",`inUse`="false",`holderIdentifier`="",`t imeStamp`="2012-06-27 18:39:04" where ((`sesystem`.`searchEngineConnections`.`distributionID`=3) and (`sesystem`.`searchEngineConnections`.`inUse`="true ") and (`sesystem`.`searchEngineConnections`.`holder`="createClientAccount") and (`sesystem`.`searchEngineConnections`.`holderIdentifier`="null") and (` sesystem`.`searchEngineConnections`.`searchEngineUserID`=0)) limit 1], genflags=no 2012-06-27 18:39:04.083 (4) [P1T1]: time=0.0020 2012-06-27 18:39:04.083 (4) [P1T1]: Query executed in 0.002s, 1 row(s) affected 2012-06-27 18:39:04.083 (4) [P1T1]: null released searchEngineConnection row 2012-06-27 18:39:04.083 (4) [P1T1]: DataCache: Found key global-sesystem 2012-06-27 18:39:04.083 (4) [P1T1]: Took Existing Object from Pool 2012-06-27 18:39:04.083 (4) [P1T1]: sesystem: SQL->[select @@version] 2012-06-27 18:39:04.085 (4) [P1T1]: time=0.0020 2012-06-27 18:39:04.085 (4) [P1T1]: Query executed in 0.002s 2012-06-27 18:39:04.085 (4) [P1T1]: test query succeeded, returned "5.1.60-rel13.1" 2012-06-27 18:39:04.085 (4) [P1T1]: sesystem: SQL->[SELECT RELEASE_LOCK('com.thesearchagency.searchengines.google.contenteditor.dao.account.createAccoun tsLock')] 2012-06-27 18:39:04.086 (4) [P1T1]: time=0.0010 2012-06-27 18:39:04.086 (4) [P1T1]: Query executed in 0.001s 2012-06-27 18:39:04.086 (4) [P1T1]: Returning Object to Pool 2012-06-27 18:39:20.629 (4) [Timer-0]: ContentEditorPropertiesRefresher: contenteditor.properties last modified 1337941320000 2012-06-27 18:39:29.687 (4) [ConnectionCloser]: 5 DatabasePools remaining : 3 pending closure 2012-06-27 18:39:59.688 (4) [ConnectionCloser]: 5 DatabasePools remaining : 3 pending closure 2012-06-27 18:40:00.416 (4) [Timer-13]: LicensingFileRefresher: licensing.properties last modified 1337940573000 2012-06-27 18:40:00.608 (3) [pool-3-thread-1]: Waiting for tasks to be done 2012-06-27 18:40:20.633 (4) [Timer-0]: ContentEditorPropertiesRefresher: contenteditor.properties last modified 1337941320000 2012-06-27 18:40:29.834 (4) [ConnectionCloser]: closing db conn 2012-06-27 18:40:29.835 (4) [ConnectionCloser]: closed [jdbc:mysql://acctdb-01-write:3307/st-tracker?useUnicode=true&characterEncoding=UTF8&zeroDateTime Behavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-06-27 18:40:29.835 (4) [ConnectionCloser]: closing db conn 2012-06-27 18:40:29.835 (4) [ConnectionCloser]: closed [jdbc:mysql://acctdb-01-write:3307/st-tracker?useUnicode=true&characterEncoding=UTF8&zeroDateTime Behavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-06-27 18:40:29.835 (4) [ConnectionCloser]: closing db conn 2012-06-27 18:40:29.836 (4) [ConnectionCloser]: closed [jdbc:mysql://sesystem-01-write:3308/sesystem?useUnicode=true&characterEncoding=UTF8&zeroDateTime Behavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-06-27 18:40:29.836 (4) [ConnectionCloser]: 5 DatabasePools remaining : 0 pending closure 2012-06-27 18:40:59.836 (4) [ConnectionCloser]: 5 DatabasePools remaining : 0 pending closure 2012-06-27 18:41:00.420 (4) [Timer-13]: LicensingFileRefresher: licensing.properties last modified 1337940573000 2012-06-27 18:41:04.080 (4) [P1T1]: Saving GoogleAccountDAO changes 2012-06-27 18:41:04.082 (4) [P1T1]: spike: SQL->[update `content_editor_google`.`gce_googleAccount` set `defaultNetworkTargeting`=null,`parentClientEmai l`=null,`promotionsEnabled`="false",`state`=null,`primaryBusinessCategory`="",`languagePreference`="en_AU",`city`="Sydney",`descriptiveName`="customerQA 4_1",`faxNumber`="0123 456 7890",`postalCode`="2000",`phoneNumber`="0123-456-7891",`name`="Frist Post ",`newsletterEnabled`="false",`currencyCode`="AUD" ,`marketResearchEnabled`="false",`parentClientCustomerID`=9893992638,`accountPerformanceEnabled`="false",`countryCode`="AU",`emailAddress`="tsaoptapi@gm ail.com",`companyName`="Optus TODO Inc.",`addressLine2`="requires a value for database",`addressLine1`="42 Optus TODO Way",`disapprovedAdsEnabled`="true ",`timeZoneEffectiveDate`=null,`customerID`=6743001777 where ((`id`=15))], genflags=no 2012-06-27 18:41:04.085 (4) [P1T1]: time=0.0020 2012-06-27 18:41:04.085 (4) [P1T1]: Query executed in 0.002s, 1 row(s) affected 2012-06-27 18:41:04.085 (4) [P1T1]: spike: SQL->[delete from `content_editor_google`.`gce_googleAccountPendingChange` where (`googleAccountID` in (15))] , genflags=no 2012-06-27 18:41:04.086 (4) [P1T1]: time=0.0010 2012-06-27 18:41:04.086 (4) [P1T1]: Query executed in 0.001s, 1 row(s) affected 2012-06-27 18:41:04.087 (4) [P1T1]: spike: SQL->[delete from `content_editor_google`.`gce_googleAccountError` where (`googleAccountID` in (15))], genfla gs=no 2012-06-27 18:41:04.088 (4) [P1T1]: time=0.0010 2012-06-27 18:41:04.088 (4) [P1T1]: Query executed in 0.001s, 0 row(s) affected 2012-06-27 18:41:04.088 (3) [P1T1]: GoogleAccountDAO(accountID 5904) Request contained 1 adds, 0 updates, 0 deletes. 2012-06-27 18:41:04.088 (3) [P1T1]: GoogleAccountDAO(accountID 5904) DB updates: 1 items updated, 1 pending changes deleted, 0 pending updates deleted, 0 errors cleared 2012-06-27 18:41:04.088 (4) [P1T1]: Using postRequest() method hack 2012-06-27 18:41:04.088 (3) [P1T1]: GCE: TSA Account [5904]: Creating budget for client #6743001777 () 2012-06-27 18:41:04.090 (4) [P1T1]: DataCache: Found key global-sesystem 2012-06-27 18:41:04.104 (4) [P1T1]: opened [jdbc:mysql://sesystem-01-write:3308/sesystem?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=con vertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-06-27 18:41:04.104 (4) [P1T1]: Created new Object 2012-06-27 18:41:04.105 (4) [P1T1]: sesystem: SQL->[select @@version] 2012-06-27 18:41:04.106 (4) [P1T1]: time=0.0010 2012-06-27 18:41:04.106 (4) [P1T1]: Query executed in 0.001s 2012-06-27 18:41:04.106 (4) [P1T1]: test query succeeded, returned "5.1.60-rel13.1" 2012-06-27 18:41:04.106 (4) [P1T1]: sesystem: SQL->[SELECT GET_LOCK('com.thesearchagency.searchengines.google.contenteditor.dao.account.createAccountsLo ck', 900)] 2012-06-27 18:41:04.108 (4) [P1T1]: time=0.0010 2012-06-27 18:41:04.108 (4) [P1T1]: Query executed in 0.001s 2012-06-27 18:41:04.108 (4) [P1T1]: Returning Object to Pool 2012-06-27 18:41:04.113 (4) [P1T1]: sesystem: SQL->[select 1] 2012-06-27 18:41:04.115 (4) [P1T1]: time=0.0020 2012-06-27 18:41:04.115 (4) [P1T1]: Query executed in 0.002s 2012-06-27 18:41:04.115 (4) [P1T1]: sesystem: SQL->[update `sesystem`.`searchEngineConnections` set `searchEngineUserID`=0,`inUse`="true",`holder`="addB udget",`holderIdentifier`="null",`timeStamp`="2012-06-27 18:41:04" where ((`sesystem`.`searchEngineConnections`.`distributionID`=3) and (`sesystem`.`sea rchEngineConnections`.`inUse`="false") and (`sesystem`.`searchEngineConnections`.`owner` is null) and (`sesystem`.`searchEngineConnections`.`searchEngin eUserID`=0)) limit 1], genflags=no 2012-06-27 18:41:04.117 (4) [P1T1]: time=0.0010 2012-06-27 18:41:04.117 (4) [P1T1]: Query executed in 0.001s, 1 row(s) affected 2012-06-27 18:41:09.187 (4) [P1T1]: sesystem: SQL->[select 1] 2012-06-27 18:41:09.189 (4) [P1T1]: time=0.0020 2012-06-27 18:41:09.189 (4) [P1T1]: Query executed in 0.002s 2012-06-27 18:41:09.189 (4) [P1T1]: sesystem: SQL->[select * from `sesystem`.`searchEngineResources` where ((`distributionID`=3) and (`operation`="addBu dget")) limit 1] 2012-06-27 18:41:09.190 (4) [P1T1]: time=0.0010 2012-06-27 18:41:09.191 (4) [P1T1]: Query executed in 0.001s 2012-06-27 18:41:09.192 (4) [P1T1]: Record Loaded 2012-06-27 18:41:09.192 (4) [P1T1]: sesystem: SQL->[insert into `sesystem`.`searchEngineResourceUsage` (`sesystem`.`searchEngineResourceUsage`.`resource ID`,`sesystem`.`searchEngineResourceUsage`.`periodStart`,`sesystem`.`searchEngineResourceUsage`.`holderID`,`sesystem`.`searchEngineResourceUsage`.`lastU sage`,`sesystem`.`searchEngineResourceUsage`.`opCount`) values (213,"2012-06-27 17:00:00","null",NOW(),1) on duplicate key update `sesystem`.`searchEng ineResourceUsage`.`opCount`=`sesystem`.`searchEngineResourceUsage`.`opCount`+1,`sesystem`.`searchEngineResourceUsage`.`lastUsage`=NOW()], genflags=no 2012-06-27 18:41:09.194 (4) [P1T1]: time=0.0020 2012-06-27 18:41:09.194 (4) [P1T1]: Query executed in 0.002s, 1 row(s) affected 2012-06-27 18:41:09.194 (4) [P1T1]: Operations for addBudget: 1 2012-06-27 18:41:09.194 (4) [P1T1]: Quota units for addBudget: 1 2012-06-27 18:41:09.194 (4) [P1T1]: Google Master account used 1 quota on resourceID 213(addBudget) 2012-06-27 18:41:09.194 (4) [P1T1]: sesystem: SQL->[select 1] 2012-06-27 18:41:09.195 (4) [P1T1]: time=0.0010 2012-06-27 18:41:09.195 (4) [P1T1]: Query executed in 0.001s 2012-06-27 18:41:09.196 (4) [P1T1]: sesystem: SQL->[insert into `sesystem`.`quotaUsage` values ("0","213","2012-06-27","1","1") on duplicate key update `quotaUsed`=`quotaUsed`+1,`operations`=`operations`+1], genflags=no 2012-06-27 18:41:09.197 (4) [P1T1]: time=0.0010 2012-06-27 18:41:09.197 (4) [P1T1]: Query executed in 0.001s, 1 row(s) affected 2012-06-27 18:41:09.198 (4) [P1T1]: Quota recorded for seUser #0: 1 quota used for resource ID 213 2012-06-27 18:41:09.198 (4) [P1T1]: sesystem: SQL->[select 1] 2012-06-27 18:41:09.200 (4) [P1T1]: time=0.0020 2012-06-27 18:41:09.200 (4) [P1T1]: Query executed in 0.002s 2012-06-27 18:41:09.200 (4) [P1T1]: sesystem: SQL->[update `sesystem`.`searchEngineConnections` set `holder`="",`inUse`="false",`holderIdentifier`="",`t imeStamp`="2012-06-27 18:41:09" where ((`sesystem`.`searchEngineConnections`.`distributionID`=3) and (`sesystem`.`searchEngineConnections`.`inUse`="true ") and (`sesystem`.`searchEngineConnections`.`holder`="addBudget") and (`sesystem`.`searchEngineConnections`.`holderIdentifier`="null") and (`sesystem`. `searchEngineConnections`.`searchEngineUserID`=0)) limit 1], genflags=no 2012-06-27 18:41:09.201 (4) [P1T1]: time=0.0010 2012-06-27 18:41:09.201 (4) [P1T1]: Query executed in 0.001s, 1 row(s) affected 2012-06-27 18:41:09.201 (4) [P1T1]: null released searchEngineConnection row 2012-06-27 18:41:09.201 (4) [P1T1]: DataCache: Found key global-sesystem 2012-06-27 18:41:09.202 (4) [P1T1]: Took Existing Object from Pool 2012-06-27 18:41:09.202 (4) [P1T1]: sesystem: SQL->[select @@version] 2012-06-27 18:41:09.203 (4) [P1T1]: time=0.0010 2012-06-27 18:41:09.203 (4) [P1T1]: Query executed in 0.001s 2012-06-27 18:41:09.203 (4) [P1T1]: test query succeeded, returned "5.1.60-rel13.1" 2012-06-27 18:41:09.203 (4) [P1T1]: sesystem: SQL->[SELECT RELEASE_LOCK('com.thesearchagency.searchengines.google.contenteditor.dao.account.createAccoun tsLock')] 2012-06-27 18:41:09.204 (4) [P1T1]: time=0.0010 2012-06-27 18:41:09.204 (4) [P1T1]: Query executed in 0.001s 2012-06-27 18:41:09.204 (4) [P1T1]: Returning Object to Pool 2012-06-27 18:41:09.206 (4) [P1T1]: spike: SQL->[select `content_editor_google`.`gce_googleAccount`.*,`content_editor_google`.`gce_googleAccountPendingC hange`.*,`gce_googleAccountPendingUpdate`.`descriptiveName` AS `descriptiveNameChange`,`gce_googleAccountPendingUpdate`.`languagePreference` AS `languag ePreferenceChange`,`gce_googleAccountPendingUpdate`.`primaryBusinessCategory` AS `primaryBusinessCategoryChange`,`gce_googleAccountPendingUpdate`.`defau ltNetworkTargeting` AS `defaultNetworkTargetingChange` from `content_editor_google`.`gce_googleAccount` join `gce_googleAccountPendingChange` on ((`cont ent_editor_google`.`gce_googleAccountPendingChange`.`googleAccountID`=`content_editor_google`.`gce_googleAccount`.`id`)) inner join `gce_googleAccountPe ndingUpdate` on ((`gce_googleAccountPendingUpdate`.`googleAccountID`=`gce_googleAccount`.`id`)) where ((((((`isFailed`="true") and (`tryCount`<10))) or ((`isFailed`="false")))) and (`type`="update") and (`accountID`=5904))] 2012-06-27 18:41:09.208 (4) [P1T1]: time=0.0020 2012-06-27 18:41:09.208 (4) [P1T1]: Query executed in 0.002s 2012-06-27 18:41:09.208 (4) [P1T1]: spike: SQL->[select `content_editor_google`.`gce_googleAccount`.*,`content_editor_google`.`gce_googleAccountPendingC hange`.* from `content_editor_google`.`gce_googleAccount` join `gce_googleAccountPendingChange` on ((`content_editor_google`.`gce_googleAccountPendingCh ange`.`googleAccountID`=`content_editor_google`.`gce_googleAccount`.`id`)) where ((((((`isFailed`="true") and (`tryCount`<10))) or ((`isFailed`="false") ))) and (`type`="delete") and (`accountID`=5904))] 2012-06-27 18:41:09.210 (4) [P1T1]: time=0.0020 2012-06-27 18:41:09.211 (4) [P1T1]: Query executed in 0.002s 2012-06-27 18:41:09.211 (4) [P1T1]: Returning Object to Pool 2012-06-27 18:41:09.211 (4) [P1T1]: DAO released connection to pool 2012-06-27 18:41:20.625 (4) [pool-3-thread-1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBeha vior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-06-27 18:41:20.626 (3) [pool-3-thread-1]: ------------Google Content Editor done 2012-06-27 18:41:20.626 (4) [pool-3-thread-1]: DataCache: Found key acct-content-google 5904 2012-06-27 18:41:20.626 (4) [pool-3-thread-1]: DataCache: Found key acct-content-google-1 2012-06-27 18:41:20.626 (4) [pool-3-thread-1]: Took Existing Object from Pool 2012-06-27 18:41:20.626 (4) [pool-3-thread-1]: spike: SQL->[select @@version] 2012-06-27 18:41:20.628 (4) [pool-3-thread-1]: time=0.0020 2012-06-27 18:41:20.628 (4) [pool-3-thread-1]: Query executed in 0.002s 2012-06-27 18:41:20.628 (4) [pool-3-thread-1]: test query succeeded, returned "5.1.60-rel13.1" 2012-06-27 18:41:20.629 (4) [pool-3-thread-1]: spike: SQL->[select * from `content_editor_google`.`gce_googleAccount` where ((`accountID`=5904) and (`id ` in (15)))] 2012-06-27 18:41:20.630 (4) [pool-3-thread-1]: time=0.0020 2012-06-27 18:41:20.630 (4) [pool-3-thread-1]: Query executed in 0.002s 2012-06-27 18:41:20.631 (3) [pool-3-thread-1]: Returning null, 9893992638 2012-06-27 18:41:20.631 (4) [pool-3-thread-1]: Returning Object to Pool 2012-06-27 18:41:20.631 (3) [pool-3-thread-1]: enabling se user 57238 Identifier:6743001777 userName: 2012-06-27 18:41:20.631 (4) [pool-3-thread-1]: spike: SQL->[select * from `tsacommon`.`searchEngineUsers` where (`id`=57238) limit 1] 2012-06-27 18:41:20.634 (4) [pool-3-thread-1]: time=0.0030 2012-06-27 18:41:20.634 (4) [pool-3-thread-1]: Query executed in 0.003s 2012-06-27 18:41:20.635 (4) [pool-3-thread-1]: Record Loaded 2012-06-27 18:41:20.635 (4) [pool-3-thread-1]: spike: SQL->[update `tsacommon`.`searchEngineUsers` set `enabled`="true",`searchEngineIdentifier`="674300 1777",`managerIDs`=9893992638 where (`id`=57238) limit 1], genflags=no 2012-06-27 18:41:20.637 (4) [Timer-0]: ContentEditorPropertiesRefresher: contenteditor.properties last modified 1337941320000 2012-06-27 18:41:20.656 (4) [pool-3-thread-1]: time=0.021 2012-06-27 18:41:20.656 (4) [pool-3-thread-1]: Query executed in 0.021s, 1 row(s) affected 2012-06-27 18:41:20.657 (3) [pool-3-thread-1]: Assigned new seUserID: 57238 to customerQA4_2000062_10005_campaign4_GT 2012-06-27 18:41:20.657 (3) [pool-3-thread-1]: Assigned new seUserID: 57238 to customerQA4_2000062_10005_campaign4_GM 2012-06-27 18:41:20.657 (3) [pool-3-thread-1]: Assigned new seUserID: 57238 to customerQA4_2000062_10005_campaign4_MO 2012-06-27 18:41:20.657 (3) [pool-3-thread-1]: Assigned 3 campaigns to 1 new user(s). 2012-06-27 18:41:20.657 (4) [pool-3-thread-1]: preparing SQL statement [select id, externalCampaignParentID, gceCampaignID, searchEngineAccountID, accou ntID, enabled from clients.externalCampaign where id = ?] 2012-06-27 18:41:20.659 (4) [pool-3-thread-1]: preparing SQL statement [insert into clients.externalCampaign (id, externalCampaignParentID, gceCampaignI D, searchEngineAccountID, accountID, enabled) values (?, ?, ?, ?, ?, ?)] 2012-06-27 18:41:20.661 (4) [pool-3-thread-1]: preparing SQL statement [select id, externalCampaignParentID, gceCampaignID, searchEngineAccountID, accou ntID, enabled from clients.externalCampaign where id = ?] 2012-06-27 18:41:20.663 (4) [pool-3-thread-1]: preparing SQL statement [insert into clients.externalCampaign (id, externalCampaignParentID, gceCampaignI D, searchEngineAccountID, accountID, enabled) values (?, ?, ?, ?, ?, ?)] 2012-06-27 18:41:20.665 (4) [pool-3-thread-1]: preparing SQL statement [select id, externalCampaignParentID, gceCampaignID, searchEngineAccountID, accou ntID, enabled from clients.externalCampaign where id = ?] 2012-06-27 18:41:20.667 (4) [pool-3-thread-1]: preparing SQL statement [insert into clients.externalCampaign (id, externalCampaignParentID, gceCampaignI D, searchEngineAccountID, accountID, enabled) values (?, ?, ?, ?, ?, ?)] 2012-06-27 18:41:20.669 (3) [pool-3-thread-1]: Creating 3 new campaign(s). 2012-06-27 18:41:20.669 (3) [pool-3-thread-1]: CampaignWorker initialized for account: 5904 2012-06-27 18:41:20.669 (3) [pool-3-thread-1]: Creating customerQA4_2000062_10005_campaign4_GT Status: Paused 2012-06-27 18:41:20.669 (3) [pool-3-thread-1]: Creating customerQA4_2000062_10005_campaign4_GM Status: Paused 2012-06-27 18:41:20.669 (3) [pool-3-thread-1]: Creating customerQA4_2000062_10005_campaign4_MO Status: Paused 2012-06-27 18:41:20.669 (3) [pool-3-thread-1]: CampaignWorker started for account: 5904 2012-06-27 18:41:20.670 (4) [pool-3-thread-1]: DataCache: Found key acct-content-google 5904 2012-06-27 18:41:20.670 (4) [pool-3-thread-1]: DataCache: Found key acct-content-google-1 2012-06-27 18:41:20.670 (4) [pool-3-thread-1]: Took Existing Object from Pool 2012-06-27 18:41:20.670 (4) [pool-3-thread-1]: spike: SQL->[select @@version] 2012-06-27 18:41:20.672 (4) [pool-3-thread-1]: time=0.0020 2012-06-27 18:41:20.672 (4) [pool-3-thread-1]: Query executed in 0.002s 2012-06-27 18:41:20.672 (4) [pool-3-thread-1]: test query succeeded, returned "5.1.60-rel13.1" 2012-06-27 18:41:20.697 (4) [pool-3-thread-1]: Creating GoogleAccountStructure with 3 campaigns... 2012-06-27 18:41:20.697 (4) [pool-3-thread-1]: DB AutoCommit -> true 2012-06-27 18:41:20.701 (4) [pool-3-thread-1]: preparing SQL statement [INSERT INTO gce_campaign (budgetAmount, budgetPeriod, name, contentTargeting, st artDay, endDay, status, searchEngineUserID) VALUES (?, ?, ?, ?, ?, ?, ?, ?)] 2012-06-27 18:41:20.704 (4) [pool-3-thread-1]: spike: SQL->[SELECT LAST_INSERT_ID()] 2012-06-27 18:41:20.705 (2) [pool-3-thread-1]: Warning(s) detected in statement [SELECT LAST_INSERT_ID()] executed by user [spike] 2012-06-27 18:41:20.705 (2) [pool-3-thread-1]: Data truncated for column 'budgetAmount' at row 1 (1265) 2012-06-27 18:41:20.705 (4) [pool-3-thread-1]: time=0.0010 2012-06-27 18:41:20.705 (4) [pool-3-thread-1]: Query executed in 0.001s 2012-06-27 18:41:20.705 (4) [pool-3-thread-1]: preparing SQL statement [INSERT INTO gce_campaignBudgetOptimizerSetting (campaignID, bidCeiling, enabled, takeOnOptimizedBids) VALUES (?, ?, ?, ?)] 2012-06-27 18:41:20.708 (4) [pool-3-thread-1]: spike: SQL->[insert into `content_editor_google`.`gce_campaignPendingChange` (`isFailed`,`requestTime`,`c ampaignID`,`tryCount`,`type`) values ("false","2012-06-27 18:41:20",39,0,"add") on duplicate key update `isFailed`="false",`requestTime`="2012-06-27 18: 41:20",`tryCount`=0,`type`=IF((`type`="add"), "add", "add")], genflags=no 2012-06-27 18:41:20.710 (4) [pool-3-thread-1]: time=0.0020 2012-06-27 18:41:20.710 (4) [pool-3-thread-1]: Query executed in 0.002s, 1 row(s) affected 2012-06-27 18:41:20.710 (4) [pool-3-thread-1]: Inserted a new pending change 2012-06-27 18:41:20.721 (4) [pool-3-thread-1]: DB AutoCommit -> false 2012-06-27 18:41:20.723 (4) [pool-3-thread-1]: spike: SQL->[insert into `content_editor_google`.`gce_campaignTargetMapPendingChange` (`isFailed`,`reques tTime`,`campaignID`,`tryCount`,`type`) values ("false","2012-06-27 18:41:20",39,0,"add") on duplicate key update `isFailed`="false",`requestTime`="2012- 06-27 18:41:20",`tryCount`=0,`type`=IF((`type`="add"), "add", "add")], genflags=no 2012-06-27 18:41:20.724 (4) [pool-3-thread-1]: time=0.0010 2012-06-27 18:41:20.724 (4) [pool-3-thread-1]: Query executed in 0.001s, 1 row(s) affected 2012-06-27 18:41:20.724 (4) [pool-3-thread-1]: Inserted a new pending change 2012-06-27 18:41:20.725 (4) [pool-3-thread-1]: spike: SQL->[start transaction] 2012-06-27 18:41:20.726 (4) [pool-3-thread-1]: time=0.0010 2012-06-27 18:41:20.726 (4) [pool-3-thread-1]: Query executed in 0.001s 2012-06-27 18:41:20.728 (4) [pool-3-thread-1]: preparing SQL statement [SELECT id FROM gce_target WHERE targetType = ? and code = ?] 2012-06-27 18:41:20.728 (4) [pool-3-thread-1]: preparing SQL statement [INSERT INTO `content_editor_google`.`gce_target` (targetType, code, description) VALUES (?, ?, '') ON DUPLICATE KEY UPDATE description=''] 2012-06-27 18:41:20.730 (4) [pool-3-thread-1]: preparing SQL statement [SELECT criterionID FROM gce_target WHERE targetType = ? and code = ?] 2012-06-27 18:41:20.731 (4) [pool-3-thread-1]: preparing SQL statement [INSERT INTO gce_campaignTargetMap (campaignID, targetID, isExclude) VALUES (?, ?, ?)] 2012-06-27 18:41:20.734 (4) [pool-3-thread-1]: preparing SQL statement [SELECT criterionID FROM gce_campaignProximityTargetMap WHERE campaignID = ? and targetID = ?] 2012-06-27 18:41:20.736 (4) [pool-3-thread-1]: preparing SQL statement [INSERT INTO gce_campaignProximityTargetMap (campaignID, targetID, criterionID, l atitudeInMicroDegrees, longitudeInMicroDegrees, radius, radiusUnits) VALUES (?, ?, ?, ?, ?, ?, ?)] 2012-06-27 18:41:20.737 (4) [pool-3-thread-1]: spike: SQL->[delete from `content_editor_google`.`gce_campaign` where (`id` in (39))], genflags=no 2012-06-27 18:41:20.738 (4) [pool-3-thread-1]: time=0.0010 2012-06-27 18:41:20.739 (4) [pool-3-thread-1]: Query executed in 0.001s, 1 row(s) affected 2012-06-27 18:41:20.739 (3) [pool-3-thread-1]: CampaignDAO (accountID 5904) Deleted 1 campaigns from failed transaction 2012-06-27 18:41:20.739 (4) [pool-3-thread-1]: DB AutoCommit -> true 2012-06-27 18:41:20.740 (4) [pool-3-thread-1]: Returning Object to Pool 2012-06-27 18:41:20.740 (4) [pool-3-thread-1]: Returning Object to Pool 2012-06-27 18:41:20.740 (4) [pool-3-thread-1]: Returning Object to Pool 2012-06-27 18:41:20.740 (2) [pool-3-thread-1]: Error: CampID: campaign4_GT Info: Error during add campaigns request. 2012-06-27 18:41:20.741 (2) [pool-3-thread-1]: Error: CampID: campaign4_GM Info: Error during add campaigns request. 2012-06-27 18:41:20.741 (2) [pool-3-thread-1]: Error: CampID: campaign4_MO Info: Error during add campaigns request. 2012-06-27 18:41:20.741 (1) [pool-3-thread-1]: Exception [Error during add campaigns request. ]:com.thesearchagency.searchengines.google.contenteditor.d to.ValidationException: Radius is too small [929] at com.thesearchagency.searchengines.google.contenteditor.dao.campaign.target.CampaignTargetDAO$CampaignProximityTargetInsertStatement.validate( CampaignTargetDAO.java:1268) at com.thesearchagency.searchengines.google.contenteditor.dao.campaign.target.CampaignTargetDAO$CampaignProximityTargetInsertStatement.validate( CampaignTargetDAO.java:1239) at com.thesearchagency.searchengines.google.contenteditor.dao.BaseInsertStatement.set(BaseInsertStatement.java:166) at com.thesearchagency.searchengines.google.contenteditor.dao.BaseInsertStatement.addBatch(BaseInsertStatement.java:97) at com.thesearchagency.searchengines.google.contenteditor.dao.campaign.target.CampaignTargetDAO.addCampaignTargets(CampaignTargetDAO.java:237) at com.thesearchagency.searchengines.google.contenteditor.dao.campaign.CampaignDAO.addCampaigns(CampaignDAO.java:314) at com.thesearchagency.searchengines.google.contenteditor.RequestCreator.createCampaignsHelper(RequestCreator.java:188) at com.thesearchagency.searchengines.google.contenteditor.RequestCreator.createCampaigns(RequestCreator.java:118) at com.thesearchagency.searchengines.google.contenteditor.GoogleContentEditor.createCampaigns(GoogleContentEditor.java:265) at com.thesearchagency.admaxlistener.worker.CampaignCreateWorker.call(CampaignCreateWorker.java:44) at com.thesearchagency.admaxlistener.worker.CampaignCreateWorker.call(CampaignCreateWorker.java:22) at com.thesearchagency.admaxlistener.worker.AccountWorker.createCampaigns(AccountWorker.java:424) at com.thesearchagency.admaxlistener.worker.AccountWorker.deploySync(AccountWorker.java:357) at com.thesearchagency.admaxlistener.worker.AccountWorker.call(AccountWorker.java:153) at com.thesearchagency.admaxlistener.worker.RequestWorker.call(RequestWorker.java:208) at com.thesearchagency.admaxlistener.worker.RequestWorker.call(RequestWorker.java:69) 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-06-27 18:41:20.741 (4) [pool-3-thread-1]: DataCache: Found key global-clients 2012-06-27 18:41:20.742 (4) [pool-3-thread-1]: Took Existing Object from Pool 2012-06-27 18:41:20.742 (4) [pool-3-thread-1]: spike: SQL->[select @@version] 2012-06-27 18:41:20.743 (4) [pool-3-thread-1]: time=0.0010 2012-06-27 18:41:20.743 (4) [pool-3-thread-1]: Query executed in 0.001s 2012-06-27 18:41:20.744 (4) [pool-3-thread-1]: test query succeeded, returned "5.1.60-rel13.1-log" 2012-06-27 18:41:20.746 (4) [pool-3-thread-1]: DataCache: Found key acct-content-google 5904 2012-06-27 18:41:20.746 (4) [pool-3-thread-1]: DataCache: Found key acct-content-google-1 2012-06-27 18:41:20.746 (4) [pool-3-thread-1]: Took Existing Object from Pool 2012-06-27 18:41:20.746 (4) [pool-3-thread-1]: spike: SQL->[select @@version] 2012-06-27 18:41:20.747 (4) [pool-3-thread-1]: time=0.0010 2012-06-27 18:41:20.747 (4) [pool-3-thread-1]: Query executed in 0.001s 2012-06-27 18:41:20.748 (4) [pool-3-thread-1]: test query succeeded, returned "5.1.60-rel13.1" 2012-06-27 18:41:20.751 (4) [pool-3-thread-1]: spike: SQL->[select `gce_campaignPendingChange`.`campaignID`,`errorCode`,`errorText`,`reason`,`policyName `,`isFailed`,`requestTime`,`tryCount`,`type`,`field`,`trigger`,`isExemptable` from `gce_campaignPendingChange` join `gce_campaignError` on ((`gce_campai gnPendingChange`.`campaignID`=`gce_campaignError`.`campaignID`)) where (`gce_campaignPendingChange`.`campaignID` in (39))] 2012-06-27 18:41:20.753 (4) [pool-3-thread-1]: time=0.0020 2012-06-27 18:41:20.753 (4) [pool-3-thread-1]: Query executed in 0.002s 2012-06-27 18:41:20.754 (4) [pool-3-thread-1]: spike: SQL->[select `gce_campaignTargetMapPendingChange`.`campaignID`,`errorCode`,`errorText`,`reason`,`p olicyName`,`isFailed`,`requestTime`,`tryCount`,`type`,`field`,`trigger`,`isExemptable` from `gce_campaignTargetMapPendingChange` join `gce_campaignTarge tMapError` on ((`gce_campaignTargetMapPendingChange`.`campaignID`=`gce_campaignTargetMapError`.`campaignID`)) where (`gce_campaignTargetMapPendingChange `.`campaignID` in (39))] 2012-06-27 18:41:20.755 (4) [pool-3-thread-1]: time=0.0010 2012-06-27 18:41:20.756 (4) [pool-3-thread-1]: Query executed in 0.001s 2012-06-27 18:41:20.756 (4) [pool-3-thread-1]: spike: SQL->[select id from `content_editor_google`.`gce_adGroup` where (`campaignID` in (39))] 2012-06-27 18:41:20.758 (4) [pool-3-thread-1]: time=0.0020 2012-06-27 18:41:20.758 (4) [pool-3-thread-1]: Query executed in 0.002s 2012-06-27 18:41:20.758 (4) [pool-3-thread-1]: Returning Object to Pool 2012-06-27 18:41:20.758 (2) [pool-3-thread-1]: Exception [Error during gce result processing]:com.thesearchagency.searchengines.google.contenteditor.dao .error.ErrorDAO$EmptyCampaignException: No AdGroups found in list [39] at com.thesearchagency.searchengines.google.contenteditor.dao.error.ErrorDAO.getAllErrors(ErrorDAO.java:79) at com.thesearchagency.searchengines.google.contenteditor.GoogleContentEditor.getOperationErrors(GoogleContentEditor.java:387) at com.thesearchagency.admaxlistener.worker.AccountWorker.processGCEResults(AccountWorker.java:642) at com.thesearchagency.admaxlistener.worker.AccountWorker.processResults(AccountWorker.java:695) at com.thesearchagency.admaxlistener.worker.AccountWorker.call(AccountWorker.java:161) at com.thesearchagency.admaxlistener.worker.RequestWorker.call(RequestWorker.java:208) at com.thesearchagency.admaxlistener.worker.RequestWorker.call(RequestWorker.java:69) 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-06-27 18:41:20.758 (4) [pool-3-thread-1]: DataCache: Found key acct-st-tracker 5904 2012-06-27 18:41:20.758 (4) [pool-3-thread-1]: DataCache: Found key acct-st-tracker-1 2012-06-27 18:41:20.774 (4) [pool-3-thread-1]: opened [jdbc:mysql://acctdb-01-write:3307/st-tracker?useUnicode=true&characterEncoding=UTF8&zeroDateTimeB ehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-06-27 18:41:20.775 (4) [pool-3-thread-1]: Created new Object 2012-06-27 18:41:20.775 (4) [pool-3-thread-1]: spike: SQL->[select @@version] 2012-06-27 18:41:20.776 (4) [pool-3-thread-1]: time=0.0010 2012-06-27 18:41:20.776 (4) [pool-3-thread-1]: Query executed in 0.001s 2012-06-27 18:41:20.777 (4) [pool-3-thread-1]: test query succeeded, returned "5.1.60-rel13.1" 2012-06-27 18:41:20.777 (3) [pool-3-thread-1]: Finished DEPLOY request for campaign customerQA4_2000062_10005_campaign4_GT: FAILED 2012-06-27 18:41:20.777 (3) [pool-3-thread-1]: Finished DEPLOY request for campaign customerQA4_2000062_10005_campaign4_GM: FAILED 2012-06-27 18:41:20.777 (3) [pool-3-thread-1]: Finished DEPLOY request for campaign customerQA4_2000062_10005_campaign4_MO: FAILED 2012-06-27 18:41:20.777 (3) [pool-3-thread-1]: customerQA4 has 0 campaigns for a SE Update accounts sync. 2012-06-27 18:41:20.777 (3) [pool-3-thread-1]: customerQA4 has 0 campaigns for a SE Update groups-listings sync. 2012-06-27 18:41:20.777 (3) [pool-3-thread-1]: Finished sub-campaign processing for DEPLOY deploymentID (1). account customerQA4. 3 submitted, 0 ok. 2012-06-27 18:41:20.777 (4) [pool-3-thread-1]: Returning Object to Pool 2012-06-27 18:41:20.777 (4) [pool-3-thread-1]: Returning Object to Pool 2012-06-27 18:41:20.777 (4) [pool-3-thread-1]: Returning Object to Pool 2012-06-27 18:41:20.777 (4) [pool-3-thread-1]: Returning results. 2012-06-27 18:41:20.778 (4) [pool-3-thread-1]: DataCache: Found key global-clients 2012-06-27 18:41:20.778 (4) [pool-3-thread-1]: Took Existing Object from Pool 2012-06-27 18:41:20.778 (4) [pool-3-thread-1]: spike: SQL->[select @@version] 2012-06-27 18:41:20.779 (4) [pool-3-thread-1]: time=0.0010 2012-06-27 18:41:20.779 (4) [pool-3-thread-1]: Query executed in 0.001s 2012-06-27 18:41:20.779 (4) [pool-3-thread-1]: test query succeeded, returned "5.1.60-rel13.1-log" 2012-06-27 18:41:20.779 (3) [pool-3-thread-1]: Updating deployment status to 'Failure' for campaignID: campaign4 2012-06-27 18:41:20.779 (4) [pool-3-thread-1]: preparing SQL statement [update clients.externalCampaignParentDeployStatus set status = ? where descripti on = ?] 2012-06-27 18:41:20.782 (3) [pool-3-thread-1]: Finished DEPLOY request for customerQA4_2000062_10005_campaign4: FAILED 2012-06-27 18:41:20.782 (3) [pool-3-thread-1]: Finished DEPLOY request, deploymentID (1), account customerQA4 2012-06-27 18:41:20.782 (4) [pool-3-thread-1]: preparing SQL statement [select id, description, accountID, admaxCampaignID, status, typeID from clients. externalCampaignParent where accountID = ? and status != ?] 2012-06-27 18:41:20.783 (4) [pool-3-thread-1]: preparing SQL statement [select c.id from clients.externalCampaignParent p join clients.externalCampaign c on(p.id = c.externalCampaignParentID) where p.description = ?] 2012-06-27 18:41:20.785 (4) [pool-3-thread-1]: preparing SQL statement [select id, externalCampaignParentID, gceCampaignID, searchEngineAccountID, accou ntID, enabled from clients.externalCampaign where id = ?] 2012-06-27 18:41:20.786 (4) [pool-3-thread-1]: preparing SQL statement [select id, externalCampaignParentID, gceCampaignID, searchEngineAccountID, accou ntID, enabled from clients.externalCampaign where id = ?] 2012-06-27 18:41:20.788 (4) [pool-3-thread-1]: preparing SQL statement [select id, externalCampaignParentID, gceCampaignID, searchEngineAccountID, accou ntID, enabled from clients.externalCampaign where id = ?] 2012-06-27 18:41:20.789 (4) [pool-3-thread-1]: spike: SQL->[SELECT RELEASE_LOCK('com.thesearchagency.admaxlistener.dao.TSACommonDAO.customerQA4')] 2012-06-27 18:41:20.791 (4) [pool-3-thread-1]: time=0.0020 2012-06-27 18:41:20.791 (4) [pool-3-thread-1]: Query executed in 0.002s 2012-06-27 18:41:20.791 (4) [pool-3-thread-1]: Released account lock: customerQA4 2012-06-27 18:41:20.791 (4) [pool-3-thread-1]: Returning Object to Pool 2012-06-27 18:41:20.791 (4) [pool-3-thread-1]: Returning Object to Pool 2012-06-27 18:41:21.350 (3) [AdMaxListener]: Sent message to response queue. 2012-06-27 18:41:29.842 (4) [ConnectionCloser]: 5 DatabasePools remaining : 7 pending closure 2012-06-27 18:41:59.834 (4) [ConnectionCloser]: 5 DatabasePools remaining : 7 pending closure 2012-06-27 18:42:00.426 (4) [Timer-13]: LicensingFileRefresher: licensing.properties last modified 1337940573000 2012-06-27 18:42:20.643 (4) [Timer-0]: ContentEditorPropertiesRefresher: contenteditor.properties last modified 1337941320000 2012-06-27 18:42:29.840 (4) [ConnectionCloser]: closing db conn 2012-06-27 18:42:29.840 (4) [ConnectionCloser]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-06-27 18:42:29.840 (4) [ConnectionCloser]: closing db conn 2012-06-27 18:42:29.841 (4) [ConnectionCloser]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-06-27 18:42:29.841 (4) [ConnectionCloser]: closing db conn 2012-06-27 18:42:29.841 (4) [ConnectionCloser]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-06-27 18:42:29.841 (4) [ConnectionCloser]: closing db conn 2012-06-27 18:42:29.841 (4) [ConnectionCloser]: closed [jdbc:mysql://acctdb-01-write:3307/st-tracker?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-06-27 18:42:29.841 (4) [ConnectionCloser]: closing db conn 2012-06-27 18:42:29.842 (4) [ConnectionCloser]: closed [jdbc:mysql://clients-01-write:3306/clients?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-06-27 18:42:29.842 (4) [ConnectionCloser]: closing db conn 2012-06-27 18:42:29.842 (4) [ConnectionCloser]: closed [jdbc:mysql://acctdb-01-write:3307/content_editor_google?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-06-27 18:42:29.842 (4) [ConnectionCloser]: closing db conn 2012-06-27 18:42:29.842 (4) [ConnectionCloser]: closed [jdbc:mysql://sesystem-01-write:3308/sesystem?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-06-27 18:42:29.842 (4) [ConnectionCloser]: 5 DatabasePools remaining : 0 pending closure 2012-06-27 18:42:59.842 (4) [ConnectionCloser]: 5 DatabasePools remaining : 0 pending closure 2012-06-27 18:43:00.430 (4) [Timer-13]: LicensingFileRefresher: licensing.properties last modified 1337940573000 2012-06-27 18:43:20.647 (4) [Timer-0]: ContentEditorPropertiesRefresher: contenteditor.properties last modified 1337941320000 2012-06-27 18:43:29.848 (4) [ConnectionCloser]: 0 DatabasePools remaining : 0 pending closure 2012-06-27 18:43:29.848 (4) [ConnectionCloser]: Stopping DatabasePool ConnectionCloserThread 2012-06-27 18:44:00.444 (4) [Timer-13]: LicensingFileRefresher: licensing.properties last modified 1337940573000 2012-06-27 18:44:20.661 (4) [Timer-0]: ContentEditorPropertiesRefresher: contenteditor.properties last modified 1337941320000 2012-06-27 18:45:00.448 (4) [Timer-13]: LicensingFileRefresher: licensing.properties last modified 1337940573000 2012-06-27 18:45:20.665 (4) [Timer-0]: ContentEditorPropertiesRefresher: contenteditor.properties last modified 1337941320000