com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed.

Jive Software Open Source | Guus der Kinderen | 12 months ago
  1. 0

    When starting Openfire, this was logged (we're unable to reproduce). Might be a database connection pool concurrency issue. {code}2015-12-21 13:54:42,954 ERROR [main] MUCPersistenceManager.java:451 - A database error prevented MUC rooms to be loaded from the database. com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:526) at com.mysql.jdbc.Util.handleNewInstance(Util.java:409) at com.mysql.jdbc.Util.getInstance(Util.java:384) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:973) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:918) at com.mysql.jdbc.StatementImpl.checkClosed(StatementImpl.java:463) at com.mysql.jdbc.PreparedStatement.setString(PreparedStatement.java:4328) at sun.reflect.GeneratedMethodAccessor7.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100) at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57) at $java.sql.PreparedStatement$$EnhancerByProxool$$2485c035.setString(<generated>) at org.jivesoftware.openfire.muc.spi.MUCPersistenceManager.loadRooms(MUCPersistenceManager.java:481) at org.jivesoftware.openfire.muc.spi.MUCPersistenceManager.loadRoomsFromDB(MUCPersistenceManager.java:445) at org.jivesoftware.openfire.muc.spi.MultiUserChatServiceImpl.start(MultiUserChatServiceImpl.java:1151) at org.jivesoftware.openfire.component.InternalComponentManager.addComponent(InternalComponentManager.java:159) at org.jivesoftware.openfire.muc.MultiUserChatManager.registerMultiUserChatService(MultiUserChatManager.java:160) at org.jivesoftware.openfire.muc.MultiUserChatManager.start(MultiUserChatManager.java:111) at org.jivesoftware.openfire.XMPPServer.startModules(XMPPServer.java:591) at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:455) at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:169){code}

    Jive Software Open Source | 12 months ago | Guus der Kinderen
    com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed.
  2. 0

    When starting Openfire, this was logged (we're unable to reproduce). Might be a database connection pool concurrency issue. {code}2015-12-21 13:54:42,954 ERROR [main] MUCPersistenceManager.java:451 - A database error prevented MUC rooms to be loaded from the database. com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:526) at com.mysql.jdbc.Util.handleNewInstance(Util.java:409) at com.mysql.jdbc.Util.getInstance(Util.java:384) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:973) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:918) at com.mysql.jdbc.StatementImpl.checkClosed(StatementImpl.java:463) at com.mysql.jdbc.PreparedStatement.setString(PreparedStatement.java:4328) at sun.reflect.GeneratedMethodAccessor7.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100) at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57) at $java.sql.PreparedStatement$$EnhancerByProxool$$2485c035.setString(<generated>) at org.jivesoftware.openfire.muc.spi.MUCPersistenceManager.loadRooms(MUCPersistenceManager.java:481) at org.jivesoftware.openfire.muc.spi.MUCPersistenceManager.loadRoomsFromDB(MUCPersistenceManager.java:445) at org.jivesoftware.openfire.muc.spi.MultiUserChatServiceImpl.start(MultiUserChatServiceImpl.java:1151) at org.jivesoftware.openfire.component.InternalComponentManager.addComponent(InternalComponentManager.java:159) at org.jivesoftware.openfire.muc.MultiUserChatManager.registerMultiUserChatService(MultiUserChatManager.java:160) at org.jivesoftware.openfire.muc.MultiUserChatManager.start(MultiUserChatManager.java:111) at org.jivesoftware.openfire.XMPPServer.startModules(XMPPServer.java:591) at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:455) at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:169){code}

    JIRA | 12 months ago | Guus der Kinderen
    com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed.
  3. 0

    When starting Openfire, this was logged (we're unable to reproduce). Might be a database connection pool concurrency issue. {code}2015-12-21 13:54:42,954 ERROR [main] MUCPersistenceManager.java:451 - A database error prevented MUC rooms to be loaded from the database. com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:526) at com.mysql.jdbc.Util.handleNewInstance(Util.java:409) at com.mysql.jdbc.Util.getInstance(Util.java:384) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:973) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:918) at com.mysql.jdbc.StatementImpl.checkClosed(StatementImpl.java:463) at com.mysql.jdbc.PreparedStatement.setString(PreparedStatement.java:4328) at sun.reflect.GeneratedMethodAccessor7.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100) at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57) at $java.sql.PreparedStatement$$EnhancerByProxool$$2485c035.setString(<generated>) at org.jivesoftware.openfire.muc.spi.MUCPersistenceManager.loadRooms(MUCPersistenceManager.java:481) at org.jivesoftware.openfire.muc.spi.MUCPersistenceManager.loadRoomsFromDB(MUCPersistenceManager.java:445) at org.jivesoftware.openfire.muc.spi.MultiUserChatServiceImpl.start(MultiUserChatServiceImpl.java:1151) at org.jivesoftware.openfire.component.InternalComponentManager.addComponent(InternalComponentManager.java:159) at org.jivesoftware.openfire.muc.MultiUserChatManager.registerMultiUserChatService(MultiUserChatManager.java:160) at org.jivesoftware.openfire.muc.MultiUserChatManager.start(MultiUserChatManager.java:111) at org.jivesoftware.openfire.XMPPServer.startModules(XMPPServer.java:591) at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:455) at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:169){code}

    Jive Software Open Source | 12 months ago | Guus der Kinderen
    com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    MySQL reconnect issue

    GitHub | 4 years ago | SelbieNL
    com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed.
  6. 0

    [AMQ-2534] Broker gets stuck with an error about using a closed JDBC statement - ASF JIRA

    apache.org | 11 months ago
    com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed.

  1. tvrmsmith 1 times, last 3 weeks ago
  2. fima 24 times, last 2 months ago
  3. mauritius 6 times, last 3 months ago
  4. tvrmsmith 3 times, last 3 months ago
  5. linxiaolong 1 times, last 5 months ago
4 more registered users
38 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException

    No operations allowed after statement closed.

    at sun.reflect.NativeConstructorAccessorImpl.newInstance0()
  2. Java RT
    Constructor.newInstance
    1. sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2. sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
    3. sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    4. java.lang.reflect.Constructor.newInstance(Constructor.java:526)
    4 frames
  3. MySQL jdbc
    PreparedStatement.setString
    1. com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
    2. com.mysql.jdbc.Util.getInstance(Util.java:384)
    3. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013)
    4. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
    5. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:973)
    6. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:918)
    7. com.mysql.jdbc.StatementImpl.checkClosed(StatementImpl.java:463)
    8. com.mysql.jdbc.PreparedStatement.setString(PreparedStatement.java:4328)
    8 frames
  4. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor7.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    3. java.lang.reflect.Method.invoke(Method.java:606)
    3 frames
  5. org.logicalcobwebs.proxool
    ProxyStatement.intercept
    1. org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
    2. org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
    2 frames
  6. $java.sql
    PreparedStatement$$EnhancerByProxool$$2485c035.setString
    1. $java.sql.PreparedStatement$$EnhancerByProxool$$2485c035.setString(<generated>)
    1 frame
  7. org.jivesoftware.openfire
    XMPPServer.start
    1. org.jivesoftware.openfire.muc.spi.MUCPersistenceManager.loadRooms(MUCPersistenceManager.java:481)
    2. org.jivesoftware.openfire.muc.spi.MUCPersistenceManager.loadRoomsFromDB(MUCPersistenceManager.java:445)
    3. org.jivesoftware.openfire.muc.spi.MultiUserChatServiceImpl.start(MultiUserChatServiceImpl.java:1151)
    4. org.jivesoftware.openfire.component.InternalComponentManager.addComponent(InternalComponentManager.java:159)
    5. org.jivesoftware.openfire.muc.MultiUserChatManager.registerMultiUserChatService(MultiUserChatManager.java:160)
    6. org.jivesoftware.openfire.muc.MultiUserChatManager.start(MultiUserChatManager.java:111)
    7. org.jivesoftware.openfire.XMPPServer.startModules(XMPPServer.java:591)
    8. org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:455)
    8 frames