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

Jive Software Open Source | Guus der Kinderen | 1 year ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  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 | 1 year 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 | 1 year 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 | 1 year 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 | 1 year ago
    com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed.
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