Cisco Bug: CSCsz66897 - Exception: No operations allowed after statement closed in mysql
Jul 22, 2010
- Cisco SCE 2000 Series Service Control Engine
Known Affected Releases
Symptom: No service affected, just seeing the following entry in the TAAdapter logs: 2009-04-10 00:00:18,270 [TAAdapter:execCodeWithTimeout]Exxxx com.cisco.scmscm.db.JdbcConnection.RPT_TOPS_PERIOD1 - psExecuteBatch - got SQLException java.sql.BatchUpdateException: No operations allowed after statement closed. at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement. java:1269) at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:955 ) at com.cisco.scmscm.db.JdbcConnection.psExecuteBatch(JdbcConnection.java:37 9) at com.cisco.scmscm.db.DbInserter.executeBatch(DbInserter.java:794) at com.cisco.scmscm.adapters.topper.TAAdapter$1.run(TAAdapter.java:434) at java.lang.Thread.run(Unknown Source) Conditions: That is a cosmetinc entry, the connection is re-established after the stale handler exception is detected.
Bug details contain sensitive information and therefore require a Cisco.com account to be viewed.
Bug Details Include
- Full Description (including symptoms, conditions and workarounds)
- Known Fixed Releases
- Related Community Discussions
- Number of Related Support Cases