Details
-
Type: Bug
-
Status: Open
-
Priority: Major
-
Resolution: Unresolved
-
Affects Version/s: Mercury
-
Fix Version/s: Saturn
-
Component/s: Admax Deployment Service
-
Labels:None
-
Environment:
Mercury Production builds
Description
1) Create an order with multiple campaigns or with campaigns with many alias.
2) When it starts processing, restart the listener (make sure to restart the listener before the Google Content Editor is done).
Actual Result:
Order goes to error state.
Following error seen in listener log
2016-07-28 07:43:26.556 (2) [pool-3-thread-2]: Error: CampID: 11398_GT Info: Error during add campaigns request.
2016-07-28 07:43:26.556 (2) [pool-3-thread-2]: Error: CampID: 11398_GM Info: Error during add campaigns request.
2016-07-28 07:43:26.556 (2) [pool-3-thread-2]: Error: CampID: 11399_GT Info: Error during add campaigns request.
2016-07-28 07:43:26.556 (2) [pool-3-thread-2]: Error: CampID: 11399_GM Info: Error during add campaigns request.
2016-07-28 07:43:26.556 (2) [pool-3-thread-2]: Error: CampID: 11400_GT Info: Error during add campaigns request.
2016-07-28 07:43:26.556 (2) [pool-3-thread-2]: Error: CampID: 11400_GM Info: Error during add campaigns request.
2016-07-28 07:43:26.556 (2) [pool-3-thread-2]: Error: CampID: 11401_GT Info: Error during add campaigns request.
2016-07-28 07:43:26.556 (2) [pool-3-thread-2]: Error: CampID: 11401_GM Info: Error during add campaigns request.
2016-07-28 07:43:26.557 (2) [pool-3-thread-2]: Error: CampID: 11402_GT Info: Error during add campaigns request.
2016-07-28 07:43:26.557 (2) [pool-3-thread-2]: Error: CampID: 11402_GM Info: Error during add campaigns request.
2016-07-28 07:43:26.557 (2) [pool-3-thread-2]: Error: CampID: 11403_GT Info: Error during add campaigns request.
2016-07-28 07:43:26.557 (2) [pool-3-thread-2]: Error: CampID: 11403_GM Info: Error during add campaigns request.
2016-07-28 07:43:26.557 (2) [pool-3-thread-2]: Error: CampID: 11404_GT Info: Error during add campaigns request.
2016-07-28 07:43:26.557 (2) [pool-3-thread-2]: Error: CampID: 11404_GM Info: Error during add campaigns request.
2016-07-28 07:43:26.557 (2) [pool-3-thread-2]: Error: CampID: 11405_GT Info: Error during add campaigns request.
2016-07-28 07:43:26.557 (2) [pool-3-thread-2]: Error: CampID: 11405_GM Info: Error during add campaigns request.
2016-07-28 07:43:26.558 (1) [pool-3-thread-2]: Exception [Error during add campaigns request. ]:java.util.concurrent.ExecutionException: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Data source is closed
at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:222)
at java.util.concurrent.FutureTask.get(FutureTask.java:83)
at com.thesearchagency.admaxlistener.deployer.MultiplexAccountDeployer.createCampaigns(MultiplexAccountDeployer.java:222)
at com.thesearchagency.admaxlistener.worker.CampaignCreateWorker.call(CampaignCreateWorker.java:58)
at com.thesearchagency.admaxlistener.worker.CampaignCreateWorker.call(CampaignCreateWorker.java:32)
at com.thesearchagency.admaxlistener.worker.AccountWorker.createCampaigns(AccountWorker.java:477)
at com.thesearchagency.admaxlistener.worker.AccountWorker.deploySync(AccountWorker.java:406)
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)
Caused by: 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.update(JdbcTemplate.java:818)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:874)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:882)
at com.thesearchagency.services.client.bing.dao.BingErrorDAO.delete(BingErrorDAO.java:211)
at com.thesearchagency.services.client.bing.BingCampaignServiceComponent.createCampaignStructures(BingCampaignServiceComponent.java:153)
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:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
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:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy12.createCampaignStructures(Unknown Source)
at com.thesearchagency.searchengines.bing.BingAccountDeployer.createAccountStructure(BingAccountDeployer.java:360)
at com.thesearchagency.searchengines.bing.BingAccountDeployer.createCampaigns(BingAccountDeployer.java:342)
at com.thesearchagency.admaxlistener.worker.SearchEngineCampaignWorker.call(SearchEngineCampaignWorker.java:62)
at com.thesearchagency.admaxlistener.worker.SearchEngineCampaignWorker.call(SearchEngineCampaignWorker.java:23)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
... 5 more
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)
... 31 more
2016-07-28 07:43:26.563 (2) [pool-3-thread-2]: Error: CampID: 11405_GT Info: []
2016-07-28 07:43:26.726 (3) [pool-3-thread-2]: Finished DEPLOY request for 824cc8bf-2db8-4d44-972c-b43b18ef1071_12932_1_11385: FAILED (merchant: 824cc8bf-2db8-4d44-972c-b43b18ef1071)
2016-07-28 07:43:26.726 (3) [pool-3-thread-2]: Finished DEPLOY request, deploymentID (81388aa7-cd57-444a-b305-eb34d5d2d523), account 824cc8bf-2db8-4d44-972c-b43b18ef107
Expected Result: Order should get processed from where it was left and should get deployed successfully.