2017-02-06 11:06:58.634 (3) [pool-10-thread-1]: KeywordDAO(accountID 1949) Request contained 81 adds, 0 updates, 0 deletes. 2017-02-06 11:06:58.634 (3) [pool-10-thread-1]: KeywordDAO(accountID 1949) DB updates: 81 items updated, 81 pending changes deleted, 0 pending updates deleted, 0 errors cleared 2017-02-06 11:06:58.714 (3) [P2T1]: ... SEUser 2681 finished 2017-02-06 11:06:58.714 (3) [pool-8-thread-2]: ------------Google Content Editor done 2017-02-06 11:06:58.723 (3) [pool-8-thread-2]: Completed Google Create Campaign Worker.. 2017-02-06 11:06:58.734 (3) [pool-3-thread-2]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2017-02-06 11:06:58.768 (3) [pool-3-thread-2]: 13068_GM has no applicable GCE errors. 2017-02-06 11:06:58.774 (3) [pool-3-thread-2]: 13068_GT has no applicable GCE errors. 2017-02-06 11:06:58,878 [pool-3-thread-2] ERROR jdbc.sqlonly - null. DataSource.getConnection() java.sql.SQLException: Data source is closed at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1362) ~[deployment-bidmgr-shaded-jar-2.9.7-BETA7.jar:na] at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) ~[deployment-bidmgr-shaded-jar-2.9.7-BETA7.jar:na] at net.sf.log4jdbc.sql.jdbcapi.DataSourceSpy.getConnection(DataSourceSpy.java:147) ~[deployment-bidmgr-shaded-jar-2.9.7-BETA7.jar:na] at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111) [deployment-bidmgr-shaded-jar-2.9.7-BETA7.jar:na] at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77) [deployment-bidmgr-shaded-jar-2.9.7-BETA7.jar:na] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:575) [deployment-bidmgr-shaded-jar-2.9.7-BETA7.jar:na] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:639) [deployment-bidmgr-shaded-jar-2.9.7-BETA7.jar:na] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:668) [deployment-bidmgr-shaded-jar-2.9.7-BETA7.jar:na] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:676) [deployment-bidmgr-shaded-jar-2.9.7-BETA7.jar:na] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:716) [deployment-bidmgr-shaded-jar-2.9.7-BETA7.jar:na] at com.thesearchagency.services.client.bing.dao.BingErrorDAO.get(BingErrorDAO.java:92) [deployment-bidmgr-shaded-jar-2.9.7-BETA7.jar:na] at com.thesearchagency.services.client.bing.BingCampaignServiceComponent.getErrors(BingCampaignServiceComponent.java:366) [deployment-bidmgr-shaded-jar-2.9.7-BETA7.jar:na] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.6.0_27] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) ~[na:1.6.0_27] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) ~[na:1.6.0_27] at java.lang.reflect.Method.invoke(Method.java:597) ~[na:1.6.0_27] at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) [deployment-bidmgr-shaded-jar-2.9.7-BETA7.jar:na] at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) [deployment-bidmgr-shaded-jar-2.9.7-BETA7.jar:na] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) [deployment-bidmgr-shaded-jar-2.9.7-BETA7.jar:na] at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96) [deployment-bidmgr-shaded-jar-2.9.7-BETA7.jar:na] at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260) [deployment-bidmgr-shaded-jar-2.9.7-BETA7.jar:na] at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94) [deployment-bidmgr-shaded-jar-2.9.7-BETA7.jar:na] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [deployment-bidmgr-shaded-jar-2.9.7-BETA7.jar:na] at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207) [deployment-bidmgr-shaded-jar-2.9.7-BETA7.jar:na] at $Proxy12.getErrors(Unknown Source) [na:na] at com.thesearchagency.searchengines.bing.GetBingOperationErrors.get(GetBingOperationErrors.java:30) [deployment-bidmgr-shaded-jar-2.9.7-BETA7.jar:na] at com.thesearchagency.searchengines.bing.BingAccountDeployer.getOperationErrors(BingAccountDeployer.java:1129) [deployment-bidmgr-shaded-jar-2.9.7-BETA7.jar:na] at com.thesearchagency.admaxlistener.deployer.MultiplexAccountDeployer.getOperationErrors(MultiplexAccountDeployer.java:414) [deployment-bidmgr-shaded-jar-2.9.7-BETA7.jar:na] at com.thesearchagency.admaxlistener.worker.AccountWorker.processGCEResults(AccountWorker.java:754) [deployment-bidmgr-shaded-jar-2.9.7-BETA7.jar:na] at com.thesearchagency.admaxlistener.worker.AccountWorker.processResults(AccountWorker.java:838) [deployment-bidmgr-shaded-jar-2.9.7-BETA7.jar:na] at com.thesearchagency.admaxlistener.worker.AccountWorker.call(AccountWorker.java:163) [deployment-bidmgr-shaded-jar-2.9.7-BETA7.jar:na] at com.thesearchagency.admaxlistener.worker.RequestWorker.call(RequestWorker.java:297) [deployment-bidmgr-shaded-jar-2.9.7-BETA7.jar:na] at com.thesearchagency.admaxlistener.worker.RequestWorker.call(RequestWorker.java:96) [deployment-bidmgr-shaded-jar-2.9.7-BETA7.jar:na] at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [na:1.6.0_27] at java.util.concurrent.FutureTask.run(FutureTask.java:138) [na:1.6.0_27] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [na:1.6.0_27] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [na:1.6.0_27] at java.lang.Thread.run(Thread.java:662) [na:1.6.0_27] 2017-02-06 11:06:58.881 (1) [pool-3-thread-2]: Exception [Results processing failed!]:org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Data source is closed at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:575) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:639) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:668) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:676) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:716) at com.thesearchagency.services.client.bing.dao.BingErrorDAO.get(BingErrorDAO.java:92) at com.thesearchagency.services.client.bing.BingCampaignServiceComponent.getErrors(BingCampaignServiceComponent.java:366) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207) at $Proxy12.getErrors(Unknown Source) at com.thesearchagency.searchengines.bing.GetBingOperationErrors.get(GetBingOperationErrors.java:30) at com.thesearchagency.searchengines.bing.BingAccountDeployer.getOperationErrors(BingAccountDeployer.java:1129) at com.thesearchagency.admaxlistener.deployer.MultiplexAccountDeployer.getOperationErrors(MultiplexAccountDeployer.java:414) at com.thesearchagency.admaxlistener.worker.AccountWorker.processGCEResults(AccountWorker.java:754) at com.thesearchagency.admaxlistener.worker.AccountWorker.processResults(AccountWorker.java:838) at com.thesearchagency.admaxlistener.worker.AccountWorker.call(AccountWorker.java:163) 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) Caused by: java.sql.SQLException: Data source is closed at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1362) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) at net.sf.log4jdbc.sql.jdbcapi.DataSourceSpy.getConnection(DataSourceSpy.java:147) at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111) at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77) ... 33 more 2017-02-06 11:06:58.882 (2) [pool-3-thread-2]: No parent result for 13067, assuming failure. 2017-02-06 11:06:58.882 (3) [pool-3-thread-2]: Updating deployment status to 'Failure' for campaignID: 13067 2017-02-06 11:06:58.883 (3) [pool-3-thread-2]: Finished DEPLOY request for 15aeb286-155a-4bb2-8fe7-d091d3d94e3a_10004_1_13067: FAILED (merchant: 15aeb286-155a-4bb2-8fe7-d091d3d94e3a) 2017-02-06 11:06:58.883 (2) [pool-3-thread-2]: No parent result for 13068, assuming failure. 2017-02-06 11:06:58.883 (3) [pool-3-thread-2]: Updating deployment status to 'Failure' for campaignID: 13068 2017-02-06 11:06:58.883 (3) [pool-3-thread-2]: Finished DEPLOY request for 15aeb286-155a-4bb2-8fe7-d091d3d94e3a_10004_1_13068: FAILED (merchant: 15aeb286-155a-4bb2-8fe7-d091d3d94e3a) 2017-02-06 11:06:58.884 (3) [pool-3-thread-2]: Finished DEPLOY request, deploymentID (3800fc5d-a5da-458d-b147-22e598de2322), account 15aeb286-155a-4bb2-8fe7-d091d3d94e3a 2017-02-06 11:06:58.884 (3) [pool-3-thread-2]: Request removed from map for customerID 15aeb286-155a-4bb2-8fe7-d091d3d94e3a 2017-02-06 11:06:58.941 (3) [pool-3-thread-2]: Initial campaign deployment for customerID: 15aeb286-155a-4bb2-8fe7-d091d3d94e3a 2017-02-06 11:06:59.787 (3) [AdMaxListener]: Sent message to response queue. 2017-02-06 11:07:00.240 (3) [Listener Shutdown Thread]: Shutting down...Executor active count: 0 future size: 0 2017-02-06 11:07:01.241 (3) [Listener Shutdown Thread]: Stopping jobs in job timer... 2017-02-06 11:07:01.242 (3) [Listener Shutdown Thread]: Jobs in job timer stopped. 2017-02-06 11:07:01.242 (3) [Listener Shutdown Thread]: All jobs finished. 2017-02-06 11:07:01.242 (3) [Listener Shutdown Thread]: Shutdown connection called... 2017-02-06 11:07:01.242 (3) [Listener Shutdown Thread]: Shutting down refund listener... 2017-02-06 11:07:01.246 (3) [Listener Shutdown Thread]: Refund listener stopped. 2017-02-06 11:07:01.246 (3) [Listener Shutdown Thread]: Shutting down updater task queue... 2017-02-06 11:07:01.246 (3) [Listener Shutdown Thread]: Queue worker shutdown() called. 2017-02-06 11:07:01.246 (3) [Listener Shutdown Thread]: Queue worker close() called. 2017-02-06 11:07:01.246 (3) [Listener Shutdown Thread]: Queue worker shutdown() called. 2017-02-06 11:07:01.246 (3) [Listener Shutdown Thread]: Queue worker close() called. 2017-02-06 11:07:01.246 (3) [Listener Shutdown Thread]: updater task queue stopped. 2017-02-06 11:07:01.256 (3) [Listener Shutdown Thread]: Connection has been closed. 2017-02-06 11:07:01.256 (3) [Listener Shutdown Thread]: AdMaxJMSListener: 2m 48.204s 2017-02-06 11:07:01.256 (3) [Listener Shutdown Thread]: by key: 2017-02-06 11:07:01.257 (3) [Listener Shutdown Thread]: db: 0.385s 2017-02-06 11:07:01.257 (3) [Listener Shutdown Thread]: by thread: 2017-02-06 11:07:01.257 (3) [Listener Shutdown Thread]: pool-10-thread-1: 0.044s 2017-02-06 11:07:01.257 (3) [Listener Shutdown Thread]: pool-9-thread-2: 0.015s 2017-02-06 11:07:01.257 (3) [Listener Shutdown Thread]: P2T1: 0.093s 2017-02-06 11:07:01.257 (3) [Listener Shutdown Thread]: pool-3-thread-1: 0.076s 2017-02-06 11:07:01.257 (3) [Listener Shutdown Thread]: pool-9-thread-1: 0.010s 2017-02-06 11:07:01.257 (3) [Listener Shutdown Thread]: pool-10-thread-2: 0.039s 2017-02-06 11:07:01.258 (3) [Listener Shutdown Thread]: pool-3-thread-2: 0.037s 2017-02-06 11:07:01.258 (3) [Listener Shutdown Thread]: pool-8-thread-2: 0.025s 2017-02-06 11:07:01.258 (3) [Listener Shutdown Thread]: P1T1: 0.037s 2017-02-06 11:07:01.258 (3) [Listener Shutdown Thread]: pool-8-thread-1: 0.002s 2017-02-06 11:07:01.258 (3) [Listener Shutdown Thread]: pool-5-thread-2: 0.007s 2017-02-06 11:07:01.258 (3) [Listener Shutdown Thread]: AccountWorker: UPDATE: 5.000s 2017-02-06 11:07:01.258 (3) [Listener Shutdown Thread]: google: 7.420s 2017-02-06 11:07:01.258 (3) [Listener Shutdown Thread]: by thread: 2017-02-06 11:07:01.258 (3) [Listener Shutdown Thread]: pool-10-thread-1: 0.866s 2017-02-06 11:07:01.259 (3) [Listener Shutdown Thread]: pool-9-thread-2: 0.573s 2017-02-06 11:07:01.259 (3) [Listener Shutdown Thread]: P2T1: 4.383s 2017-02-06 11:07:01.259 (3) [Listener Shutdown Thread]: pool-9-thread-1: 0.782s 2017-02-06 11:07:01.259 (3) [Listener Shutdown Thread]: pool-10-thread-2: 0.816s 2017-02-06 11:07:01.259 (3) [Listener Shutdown Thread]: RequestWorker: 28.993s 2017-02-06 11:07:01.259 (3) [Listener Shutdown Thread]: by thread: 2017-02-06 11:07:01.259 (3) [Listener Shutdown Thread]: pool-3-thread-1: 5.728s 2017-02-06 11:07:01.259 (3) [Listener Shutdown Thread]: pool-3-thread-2: 23.265s 2017-02-06 11:07:01.260 (3) [Listener Shutdown Thread]: AccountWorker: DEPLOY: 23.052s 2017-02-06 11:07:01.260 (3) [Listener Shutdown Thread]: other: 1m 43.354s 2017-02-06 11:07:01.260 (3) [Listener Shutdown Thread]: Exited in 21.048 seconds