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

Ads disapproval notification script fails when run for many accounts

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: Mercury
    • Fix Version/s: Mercury
    • Component/s: Other / Misc.
    • Labels:
      None
    • Environment:

      Bidmgr #1015

    • Sprint:
      Sprint 15

      Description

      Ads disapproval notification script fails when run for many accounts like 80 plus for bing.
      Tried by increasing the number of threads as well. Same behavior seen.
      Fails with "Too many connections" error in log

      Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Too many connections
      at sun.reflect.GeneratedConstructorAccessor51.newInstance(Unknown Source)
      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:1015)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:925)
      at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1704)
      at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1250)
      at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2483)
      at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2516)
      at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2301)
      at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:834)
      at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
      at sun.reflect.GeneratedConstructorAccessor13.newInstance(Unknown Source)
      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.ConnectionImpl.getInstance(ConnectionImpl.java:416)
      at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:317)
      at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
      at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
      at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
      at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
      ... 18 more

      2015-12-18 11:13:49.677 (3) [main]: --------------- Finished filling information maps. Completed Successfully: false
      2015-12-18 11:13:49.679 (3) [P1T1]: Starting Distribution 147
      2015-12-18 11:13:49.680 (1) [P1T1]: Exception [Distribution 147 Catch all]:java.lang.NullPointerException
      at com.thesearchagency.searchengines.GetDisapprovedAds$DistributionWorker.call(GetDisapprovedAds.java:406)
      at com.thesearchagency.searchengines.GetDisapprovedAds$DistributionWorker.call(GetDisapprovedAds.java:177)
      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)

        Attachments

          Activity

            People

            • Assignee:
              Madhan Madhan Pulipati [X] (Inactive)
              Reporter:
              varshini.padmanabhan Varshini Padmanabhan (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: