[ADMAX-3096] Pixel Playback is ignoring the isOnline column in the accounts table - Admax Local

Details

Type: Bug
Status: Closed
Priority: Major
Resolution: Fixed
Affects Version/s: Sustaining
Fix Version/s: Sustaining
Component/s: Data Summarization, TSA Tracking
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, Sprint 4

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)