Details
-
Type:
Bug
-
Status: Open
-
Priority:
Minor
-
Resolution: Unresolved
-
Affects Version/s: Daily Data Availability Phase 2
-
Fix Version/s: Daily Data Availability Phase 2
-
Component/s: Data Summarization
-
Labels:None
-
Environment:
xml06.dc1bos.thesearchagency.com
Description
I noticed this exception in /tmp/2011-11-13/lowgran_whsumm.sh_d_3_T_2011_11_12_a_687\,690\,698\,759\,774\,826\,843_03\:45\:25.log
2011-11-13 13:45:58.005 (2) [main]: Timeout exceeded. Exiting...
2011-11-13 13:45:58.006 (2) [main]: Remaining account IDs: [774, 687]
2011-11-13 13:45:58.030 (1) [main]: Exception [Error loading record]:com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying ex
ception:
2011-11-13 13:45:58.030 (1) [main]: Exception [Error loading record]:com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying ex
ception:
-
- BEGIN NESTED EXCEPTION **
java.io.EOFException
STACKTRACE:
java.io.EOFException
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1913)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2304)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2803)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3170)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3099)
at com.mysql.jdbc.Statement.executeQuery(Statement.java:1169)
at com.carldunham.jst.db.Database.executeQuery(Database.java:356)
at com.carldunham.jst.db.Database.executeQuery(Database.java:308)
at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:184)
at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:404)
at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:373)
at com.thesearchagency.perf.AccountLowGranDispatcher.dispatchAccount(AccountLowGranDispatcher.java:624)
at com.thesearchagency.perf.AccountLowGranDispatcher.runForKnownDate(AccountLowGranDispatcher.java:323)
at com.thesearchagency.perf.AccountLowGranDispatcher.run(AccountLowGranDispatcher.java:101)
at com.thesearchagency.perf.WarehouseSummarizer.run(WarehouseSummarizer.java:364)
at com.thesearchagency.perf.WarehouseSummarizer.main(WarehouseSummarizer.java:421)
-
- END NESTED EXCEPTION **
So it needs to be rerun for those accounts:
nohup $DIR/whsumm.sh -d3 -T 2011-11-12 -a 687,774 --lowgran 2> /tmp/2011-11-14/whsumm_lowgran_20111112_a687,774_rerun.log &
Ideally, code (AccountLowGranDispatcher.java) would catch this exception and retry, as this cause of this exception is often resolved quickly (ie. happens when server is overloaded, network issue, etc) – that would prevent a manual rerun.
