2016-06-03 11:54:17.058 (3) [pool-33-thread-2]: ------------Google Content Editor done
2016-06-03 11:54:17.058 (3) [pool-33-thread-2]: Completed Google Replace Campaigns Worker..
2016-06-03 11:54:17.059 (4) [pool-3-thread-4]: DataCache: Found key acct-content-google 127
2016-06-03 11:54:17.060 (4) [pool-3-thread-4]: DataCache: Found key acct-content-google-1
2016-06-03 11:54:17.060 (4) [pool-3-thread-4]: Took Existing Object from Pool
2016-06-03 11:54:17.060 (4) [pool-3-thread-4]: spike: SQL->[select @@version]
2016-06-03 11:54:17.061 (4) [pool-3-thread-4]: time=0.0010
2016-06-03 11:54:17.061 (4) [pool-3-thread-4]: Query executed in 0.001s
2016-06-03 11:54:17.061 (4) [pool-3-thread-4]: test query succeeded, returned "5.5.32"
2016-06-03 11:54:17.062 (4) [pool-3-thread-4]: DB IsolationLevel -> 2
2016-06-03 11:54:17.062 (4) [pool-3-thread-4]: DB AutoCommit -> false
2016-06-03 11:54:17.063 (4) [pool-3-thread-4]: spike: SQL->[start transaction]
2016-06-03 11:54:17.064 (4) [pool-3-thread-4]: time=0.0010
2016-06-03 11:54:17.064 (4) [pool-3-thread-4]: Query executed in 0.001s
2016-06-03 11:54:17.064 (4) [pool-3-thread-4]: preparing SQL statement [select count(*) from gce_adGroup join gce_keyword on gce_adGroup.id=adGroupID where campaignID in (5,6) and isNegative='false' and (destinationURL is not null or destinationURL != ?)]
2016-06-03 11:54:17.066 (4) [pool-3-thread-4]: preparing SQL statement [insert into gce_keywordPendingChange (keywordID, type, tryCount, isFailed) select gce_keyword.id, 'update', 0, 'false' from gce_adGroup join gce_keyword on gce_adGroup.id=adGroupID left join gce_keywordPendingChange on (gce_keyword.id=keywordID) where campaignID in (5,6) and gce_keywordPendingChange.keywordID is null and isNegative='false' and (destinationURL is not null or destinationURL != ?)]
2016-06-03 11:54:17.066 (4) [pool-3-thread-4]: preparing SQL statement [insert into gce_keywordPendingUpdate (keywordID, destinationURL) select gce_keyword.id, ? from gce_adGroup join gce_keyword on gce_adGroup.id=adGroupID join gce_keywordPendingChange on (gce_keyword.id=keywordID) where campaignID in (5,6) and gce_keywordPendingChange.type='update' and tryCount=0 and isFailed='false' and isNegative='false' and (destinationURL is not null or destinationURL != ?)]
2016-06-03 11:54:17.069 (2) [pool-3-thread-4]: SQLTransaction try # 1: non-deadlock exception, not retrying
2016-06-03 11:54:17.069 (4) [pool-3-thread-4]: spike: SQL->[rollback]
2016-06-03 11:54:17.070 (4) [pool-3-thread-4]: time=0.0010
2016-06-03 11:54:17.070 (4) [pool-3-thread-4]: Query executed in 0.001s
2016-06-03 11:54:17.070 (4) [pool-3-thread-4]: DB AutoCommit -> true
2016-06-03 11:54:17.071 (4) [pool-3-thread-4]: DB IsolationLevel -> 4
2016-06-03 11:54:17.071 (4) [pool-3-thread-4]: Returning Object to Pool
2016-06-03 11:54:17.071 (2) [pool-3-thread-4]: Error: CampID: 711_GT Info: Error during update request.
2016-06-03 11:54:17.071 (2) [pool-3-thread-4]: Error: CampID: 711_GM Info: Error during update request.
2016-06-03 11:54:17.072 (2) [pool-3-thread-4]: Error: CampID: 712_GT Info: Error during update request.
2016-06-03 11:54:17.072 (2) [pool-3-thread-4]: Error: CampID: 712_GM Info: Error during update request.
2016-06-03 11:54:17.072 (1) [pool-3-thread-4]: Exception [Error during update request.]:com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '342' for key 'PRIMARY'
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
        at com.mysql.jdbc.Util.getInstance(Util.java:386)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1041)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2815)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2458)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2375)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2359)
        at com.thesearchagency.searchengines.google.contenteditor.dao.criterion.keyword.KeywordDAO.createDestinationURLUpdateRequest(KeywordDAO.java:487)
        at com.thesearchagency.searchengines.google.contenteditor.dao.criterion.keyword.KeywordDAO.updateKeywordDestinationURLs(KeywordDAO.java:388)
        at com.thesearchagency.searchengines.google.contenteditor.RequestCreator$KeywordURLUpdateTransaction.databaseCalls(RequestCreator.java:1723)
        at com.carldunham.jst.db.SQLTransaction.execute(SQLTransaction.java:68)
        at com.thesearchagency.searchengines.google.contenteditor.RequestCreator.updateKeywordDestinationURLs(RequestCreator.java:291)
        at com.thesearchagency.searchengines.google.contenteditor.GoogleContentEditor.updateKeywordDestinationURLs(GoogleContentEditor.java:283)
        at com.thesearchagency.admaxlistener.deployer.MultiplexAccountDeployer.updateKeywordDestinationURLs(MultiplexAccountDeployer.java:400)
        at com.thesearchagency.admaxlistener.worker.CampaignUpdateWorker.campaignSync(CampaignUpdateWorker.java:540)
        at com.thesearchagency.admaxlistener.worker.CampaignUpdateWorker.call(CampaignUpdateWorker.java:120)
        at com.thesearchagency.admaxlistener.worker.AccountWorker.updateCampaigns(AccountWorker.java:530)
        at com.thesearchagency.admaxlistener.worker.AccountWorker.deploySync(AccountWorker.java:396)
        at com.thesearchagency.admaxlistener.worker.AccountWorker.call(AccountWorker.java:151)
        at com.thesearchagency.admaxlistener.worker.RequestWorker.call(RequestWorker.java:297)
        at com.thesearchagency.admaxlistener.worker.RequestWorker.call(RequestWorker.java:96)
        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)

2016-06-03 11:54:17.072 (4) [pool-3-thread-4]: no account, or instance for databaseInstance, skipping lookup...
2016-06-03 11:54:17.072 (4) [pool-3-thread-4]: Took Existing Object from Pool
2016-06-03 11:54:17.072 (4) [pool-3-thread-4]: spike: SQL->[select @@version]
2016-06-03 11:54:17.073 (4) [pool-3-thread-4]: time=0.0010
2016-06-03 11:54:17.074 (4) [pool-3-thread-4]: Query executed in 0.001s
2016-06-03 11:54:17.074 (4) [pool-3-thread-4]: test query succeeded, returned "5.5.32"
2016-06-03 11:54:17.074 (4) [pool-3-thread-4]: DataCache: Found key global-clients
2016-06-03 11:54:17.074 (4) [pool-3-thread-4]: Took Existing Object from Pool
2016-06-03 11:54:17.074 (4) [pool-3-thread-4]: spike: SQL->[select @@version]
2016-06-03 11:54:17.075 (4) [pool-3-thread-4]: time=0.0010
2016-06-03 11:54:17.075 (4) [pool-3-thread-4]: Query executed in 0.001s
2016-06-03 11:54:17.075 (4) [pool-3-thread-4]: test query succeeded, returned "5.5.32"
2016-06-03 11:54:17.076 (4) [pool-3-thread-4]: SearchEngineUserWorker initialized for account: 127
2016-06-03 11:54:17.076 (4) [pool-3-thread-4]: preparing SQL statement [select u.id as `seUserID`, u.`distributionID`, count(case when a.searchEngineStatus = ? then null else a.id end) as `numCampaigns`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]