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

CLONE - Pixel Playback is ignoring the isOnline column in the accounts table

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.2.0
    • Fix Version/s: Web Pages Release
    • Labels:
      None
    • Environment:

      pixel playback on xml-07

      bidmgr build: tsa-build-bidmgr-2012-03-16-p25-r31811/

      log file: /var/local/tsa/log/2012-04-13/processwp-v2-catch-all.sh_10.log

    • Sprint:
      Sprint 1

      Description

      Pixel playback is trying to create an AltKeyStrategy instance before checking the isOnline column for that account, and then the DB query to get the AltKeyStrategyClass from the settings table in the database fails because the account shard is offline for maintenance.

      2012-04-13 10:22:22.926 (3) [main]: uas.getTimeZoneIdentifierByAccountID(17) = America/Los_Angeles

      2012-04-13 10:22:22.946 (3) [main]: DatabasePool with a limit of 5 created

      2012-04-13 10:22:22.952 (2) [main]: Exception [creating pooled Database]:com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

        • BEGIN NESTED EXCEPTION **

      java.net.SocketException

      MESSAGE: java.net.ConnectException: Connection refused

      STACKTRACE:

      java.net.SocketException: java.net.ConnectException: Connection refused

      at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156)

      at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:277)

      at com.mysql.jdbc.Connection.createNewIO(Connection.java:2668)

      at com.mysql.jdbc.Connection.<init>(Connection.java:1531)

      at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)

      at java.sql.DriverManager.getConnection(DriverManager.java:525)

      at java.sql.DriverManager.getConnection(DriverManager.java:171)

      at com.carldunham.jst.db.Database.init(Database.java:203)

      at com.carldunham.jst.db.Database.<init>(Database.java:188)

      at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:172)

      at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:35)

      at com.carldunham.jst.pooling.ObjectPool.get(ObjectPool.java:88)

      at com.carldunham.jst.db.DatabasePool.get(DatabasePool.java:96)

      at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:326)

      at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:314)

      at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:115)

      at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:107)

      at com.thesearchagency.clients.AltKeyStrategyFactory.makeAltKeyStrategy(AltKeyStrategyFactory.java:126)

      at com.thesearchagency.clients.AltKeyStrategyFactory.getAltKeyStrategy(AltKeyStrategyFactory.java:94)

      at com.thesearchagency.pixelplayback.v2.PixelLogPlayback.createWorker(PixelLogPlayback.java:88)

      at com.thesearchagency.AccountDispatcher.run(AccountDispatcher.java:161)

      at com.thesearchagency.pixelplayback.v2.PixelLogPlayback.run(PixelLogPlayback.java:488)

      at com.thesearchagency.pixelplayback.v2.PixelLogPlayback.main(PixelLogPlayback.java:59)

        • END NESTED EXCEPTION **

      Last packet sent to the server was 1 ms ago.

      at com.mysql.jdbc.Connection.createNewIO(Connection.java:2741)

      at com.mysql.jdbc.Connection.<init>(Connection.java:1531)

      at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)

      at java.sql.DriverManager.getConnection(DriverManager.java:525)

      at java.sql.DriverManager.getConnection(DriverManager.java:171)

      at com.carldunham.jst.db.Database.init(Database.java:203)

      at com.carldunham.jst.db.Database.<init>(Database.java:188)

      at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:172)

      at com.carldunham.jst.db.DatabasePool.create(DatabasePool.java:35)

      at com.carldunham.jst.pooling.ObjectPool.get(ObjectPool.java:88)

      at com.carldunham.jst.db.DatabasePool.get(DatabasePool.java:96)

      at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:326)

      at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:314)

      at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:115)

      at com.thesearchagency.db.util.MultiplexDatabasePool.get(MultiplexDatabasePool.java:107)

      at com.thesearchagency.clients.AltKeyStrategyFactory.makeAltKeyStrategy(AltKeyStrategyFactory.java:126)

      at com.thesearchagency.clients.AltKeyStrategyFactory.getAltKeyStrategy(AltKeyStrategyFactory.java:94)

      at com.thesearchagency.pixelplayback.v2.PixelLogPlayback.createWorker(PixelLogPlayback.java:88)

      at com.thesearchagency.AccountDispatcher.run(AccountDispatcher.java:161)

      at com.thesearchagency.pixelplayback.v2.PixelLogPlayback.run(PixelLogPlayback.java:488)

      at com.thesearchagency.pixelplayback.v2.PixelLogPlayback.main(PixelLogPlayback.java:59)

      2012-04-13 10:22:22.957 (2) [main]: Unable to get Database from pool!

      2012-04-13 10:22:22.957 (2) [main]: Null db returned for url [jdbc:mysql://acctdb-03-write:3306/st-tracker?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=tru

      e&jdbcCompliantTruncation=false]

      2012-04-13 10:22:22.957 (2) [main]: Exception [handling account - ignoring]:java.lang.NullPointerException

      at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:184)

      at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:149)

      at com.thesearchagency.Settings.load(Settings.java:220)

      at com.thesearchagency.Settings.<init>(Settings.java:86)

      at com.thesearchagency.Settings.getSettings(Settings.java:57)

      at com.thesearchagency.clients.AltKeyStrategyFactory.makeAltKeyStrategy(AltKeyStrategyFactory.java:128)

      at com.thesearchagency.clients.AltKeyStrategyFactory.getAltKeyStrategy(AltKeyStrategyFactory.java:94)

      at com.thesearchagency.pixelplayback.v2.PixelLogPlayback.createWorker(PixelLogPlayback.java:88)

      at com.thesearchagency.AccountDispatcher.run(AccountDispatcher.java:161)

      at com.thesearchagency.pixelplayback.v2.PixelLogPlayback.run(PixelLogPlayback.java:488)

      at com.thesearchagency.pixelplayback.v2.PixelLogPlayback.main(PixelLogPlayback.java:59)

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                therouxj Jeff Theroux
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated: