Guest

Preview Tool

Cisco Bug: CSCsz66897 - Exception: No operations allowed after statement closed in mysql

Last Modified

Jul 22, 2010

Products (1)

  • Cisco SCE 2000 Series Service Control Engine

Known Affected Releases

3.5.0

Description (partial)

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)
  • Status
  • Severity
  • Known Fixed Releases
  • Related Community Discussions
  • Number of Related Support Cases
Bug information is viewable for customers and partners who have a service contract. Registered users can view up to 200 bugs per month without a service contract.