Uploaded image for project: 'AdMaxLocal'
  1. AdMaxLocal
  2. AML-4254

Listener fails to process an order in processing state on restart

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: Mercury
    • Fix Version/s: Saturn
    • 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.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              varshini.padmanabhan Varshini Padmanabhan (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: