Re: Communications link failure due to underlying exception...various network exceptions

[mreichman]

Another EOF:
2007-02-10 20:48:45,734 [CarsRouter-0] ERROR com.virage.util.database.SQLProcessor - Could not perform the query for com.mysql.jdbc.ServerPreparedStatement[17487] - SELECT vir_assets.asset_id, vir_asset_tracks.track_id, vir_asset_tracks.track_name, vir_asset_tracks.track_type, vir_text_tracks.start_msec, vir_text_tracks.end_msec, vir_text_tracks.start_smpte, vir_text_tracks.end_smpte, vir_text_tracks.vdf_track_rec_id, vir_text_tracks.confidence, vir_text_tracks.text_data FROM vir_text_tracks, vir_assets, vir_asset_tracks WHERE vir_asset_tracks.asset_id=vir_assets.asset_id AND vir_asset_tracks.asset_id=vir_text_tracks.asset_id AND vir_asset_tracks.track_id=vir_text_tracks.track_id AND ( vir_asset_tracks.track_type='TEXT' OR vir_asset_tracks.track_type='WEIGHTED_TEXT' ) AND vir_assets.asset_id IN (79918) ORDER BY vir_assets.asset_id, vir_asset_tracks.track_id, vir_text_tracks.start_msec
com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

** 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:2357)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2803)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812)
at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1295)
at com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.java:2262)
at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:439)
at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:1970)
at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:1387)
at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1195)
at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:693)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1266)
at com.virage.util.database.SQLProcessor.handleQuery(SQLProcessor.java:398)
at com.virage.util.database.SQLProcessor.doExecuteQuery(SQLProcessor.java:213)
at com.virage.util.database.SQLProcessor.executeQuery(SQLProcessor.java:171)
at com.virage.store.db.DbAssetLoader.loadTextTracks(DbAssetLoader.java:800)
at com.virage.store.db.DbAssetLoader.load(DbAssetLoader.java:151)
at com.virage.store.db.AssetManagerImpl.getAssetList(AssetManagerImpl.java:89)
at com.virage.store.db.AssetManagerImpl.getAsset(AssetManagerImpl.java:60)
at com.virage.atg.util.AssetUtil.<init>(AssetUtil.java:46)
at com.virage.atg.cars.plugins.NamedEntityPlugIn.populateAssetData(NamedEntityPlugIn.java:267)
at com.virage.atg.cars.plugins.NamedEntityPlugIn.run(NamedEntityPlugIn.java:77)
at com.virage.atg.cars.PlugInManager.run(PlugInManager.java:196)
at com.virage.atg.thread.ATGThread.doWork(ATGThread.java:117)
at com.virage.atg.thread.ATGThread.run(ATGThread.java:142)


** END NESTED EXCEPTION **



Last packet sent to the server was 323968 ms ago.
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2803)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812)
at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1295)
at com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.java:2262)
at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:439)
at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:1970)
at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:1387)
at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1195)
at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:693)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1266)
at com.virage.util.database.SQLProcessor.handleQuery(SQLProcessor.java:398)
at com.virage.util.database.SQLProcessor.doExecuteQuery(SQLProcessor.java:213)
at com.virage.util.database.SQLProcessor.executeQuery(SQLProcessor.java:171)
at com.virage.store.db.DbAssetLoader.loadTextTracks(DbAssetLoader.java:800)
at com.virage.store.db.DbAssetLoader.load(DbAssetLoader.java:151)
at com.virage.store.db.AssetManagerImpl.getAssetList(AssetManagerImpl.java:89)
at com.virage.store.db.AssetManagerImpl.getAsset(AssetManagerImpl.java:60)
at com.virage.atg.util.AssetUtil.<init>(AssetUtil.java:46)
at com.virage.atg.cars.plugins.NamedEntityPlugIn.populateAssetData(NamedEntityPlugIn.java:267)
at com.virage.atg.cars.plugins.NamedEntityPlugIn.run(NamedEntityPlugIn.java:77)
at com.virage.atg.cars.PlugInManager.run(PlugInManager.java:196)
at com.virage.atg.thread.ATGThread.doWork(ATGThread.java:117)
at com.virage.atg.thread.ATGThread.run(ATGThread.java:142)

I'm starting to experiment with useServerPrepSmtms=false, but it's hard to see this happen often. what's the performance hit of using this option?