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

Atlassian JIRA | Foogie Sim [Atlassian] | 2 years ago
  1. 0

    We have seen an issue where an instance would run into OOM, despite having a really large Heap (10GB), because the size of their BODYCONTENT is really large. We should not load the entire BODYCONTENT into memory to generate this recovery file. See: {code} 2015-04-26 00:23:03,049 INFO [localhost-startStop-1] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [bandana] 2015-04-26 00:23:03,049 INFO [localhost-startStop-1] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [bodycontent] 2015-04-26 00:24:46,119 WARN [localhost-startStop-1] [v2.c3p0.impl.NewPooledConnection] handleThrowable [c3p0] A PooledConnection that has already signalled a Connection error is still in use! 2015-04-26 00:24:46,119 WARN [localhost-startStop-1] [v2.c3p0.impl.NewPooledConnection] handleThrowable [c3p0] Another error has occurred [ com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed. ] which will not be reported to listeners! com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:389) at com.mysql.jdbc.Util.getInstance(Util.java:372) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:958) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:937) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:872) at com.mysql.jdbc.ConnectionImpl.throwConnectionClosedException(ConnectionImpl.java:1236) at com.mysql.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:1231) at com.mysql.jdbc.ConnectionImpl.setAutoCommit(ConnectionImpl.java:4811) at com.mchange.v2.c3p0.impl.NewProxyConnection.setAutoCommit(NewProxyConnection.java:881) at com.atlassian.confluence.upgrade.recovery.DefaultRecoveryFileGenerator.generate(DefaultRecoveryFileGenerator.java:91) at com.atlassian.confluence.upgrade.impl.DefaultUpgradeManager.entireUpgradeFinished(DefaultUpgradeManager.java:307) at com.atlassian.confluence.upgrade.PluginFrameworkDependentUpgrader.startup(PluginFrameworkDependentUpgrader.java:29) at com.atlassian.config.lifecycle.DefaultLifecycleManager.startUp(DefaultLifecycleManager.java:40) at com.atlassian.config.lifecycle.LifecycleServletContextListener.contextInitialized(LifecycleServletContextListener.java:17) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4973) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5467) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1559) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1549) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: java.lang.OutOfMemoryError: Java heap space {code} Failed with: {code} -Xms10240m -Xmx10240m {code} h3.Workaround Disable the upgrade recovery file generation by adding this to your startup parameter: {code} -Dconfluence.upgrade.recovery.file.enabled=false {code}

    Atlassian JIRA | 2 years ago | Foogie Sim [Atlassian]
    com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.
  2. 0

    We have seen an issue where an instance would run into OOM, despite having a really large Heap (10GB), because the size of their BODYCONTENT is really large. We should not load the entire BODYCONTENT into memory to generate this recovery file. See: {code} 2015-04-26 00:23:03,049 INFO [localhost-startStop-1] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [bandana] 2015-04-26 00:23:03,049 INFO [localhost-startStop-1] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [bodycontent] 2015-04-26 00:24:46,119 WARN [localhost-startStop-1] [v2.c3p0.impl.NewPooledConnection] handleThrowable [c3p0] A PooledConnection that has already signalled a Connection error is still in use! 2015-04-26 00:24:46,119 WARN [localhost-startStop-1] [v2.c3p0.impl.NewPooledConnection] handleThrowable [c3p0] Another error has occurred [ com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed. ] which will not be reported to listeners! com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:389) at com.mysql.jdbc.Util.getInstance(Util.java:372) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:958) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:937) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:872) at com.mysql.jdbc.ConnectionImpl.throwConnectionClosedException(ConnectionImpl.java:1236) at com.mysql.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:1231) at com.mysql.jdbc.ConnectionImpl.setAutoCommit(ConnectionImpl.java:4811) at com.mchange.v2.c3p0.impl.NewProxyConnection.setAutoCommit(NewProxyConnection.java:881) at com.atlassian.confluence.upgrade.recovery.DefaultRecoveryFileGenerator.generate(DefaultRecoveryFileGenerator.java:91) at com.atlassian.confluence.upgrade.impl.DefaultUpgradeManager.entireUpgradeFinished(DefaultUpgradeManager.java:307) at com.atlassian.confluence.upgrade.PluginFrameworkDependentUpgrader.startup(PluginFrameworkDependentUpgrader.java:29) at com.atlassian.config.lifecycle.DefaultLifecycleManager.startUp(DefaultLifecycleManager.java:40) at com.atlassian.config.lifecycle.LifecycleServletContextListener.contextInitialized(LifecycleServletContextListener.java:17) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4973) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5467) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1559) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1549) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: java.lang.OutOfMemoryError: Java heap space {code} Failed with: {code} -Xms10240m -Xmx10240m {code} h3.Workaround Disable the upgrade recovery file generation by adding this to your startup parameter: {code} -Dconfluence.upgrade.recovery.file.enabled=false {code}

    Atlassian JIRA | 2 years ago | Foogie Sim [Atlassian]
    com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.
  3. 0

    [CONF-37360] Post-Upgrade Recovery File Generation Results in OOM If Size of BodyContent Is Really Large - Atlassian JIRA

    atlassian.com | 1 year ago
    com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    [CONF-37360] Post-Upgrade Recovery File Generation Results in OOM If Size of BodyContent Is Really Large - Atlassian JIRA

    atlassian.com | 1 year ago
    com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.
  6. 0

    MySQLNonTransientConnectionException with MySQL 5.7.9

    GitHub | 1 year ago | piedrahitac
    liquibase.exception.DatabaseException: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection 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 connection closed.

    at sun.reflect.NativeConstructorAccessorImpl.newInstance0()
  2. Java RT
    Constructor.newInstance
    1. sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2. sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    3. sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    4. java.lang.reflect.Constructor.newInstance(Unknown Source)
    4 frames
  3. MySQL jdbc
    ConnectionImpl.setAutoCommit
    1. com.mysql.jdbc.Util.handleNewInstance(Util.java:389)
    2. com.mysql.jdbc.Util.getInstance(Util.java:372)
    3. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:958)
    4. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:937)
    5. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
    6. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:872)
    7. com.mysql.jdbc.ConnectionImpl.throwConnectionClosedException(ConnectionImpl.java:1236)
    8. com.mysql.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:1231)
    9. com.mysql.jdbc.ConnectionImpl.setAutoCommit(ConnectionImpl.java:4811)
    9 frames
  4. c3p0:JDBC DataSources/Resource Pools
    NewProxyConnection.setAutoCommit
    1. com.mchange.v2.c3p0.impl.NewProxyConnection.setAutoCommit(NewProxyConnection.java:881)
    1 frame
  5. com.atlassian.confluence
    PluginFrameworkDependentUpgrader.startup
    1. com.atlassian.confluence.upgrade.recovery.DefaultRecoveryFileGenerator.generate(DefaultRecoveryFileGenerator.java:91)
    2. com.atlassian.confluence.upgrade.impl.DefaultUpgradeManager.entireUpgradeFinished(DefaultUpgradeManager.java:307)
    3. com.atlassian.confluence.upgrade.PluginFrameworkDependentUpgrader.startup(PluginFrameworkDependentUpgrader.java:29)
    3 frames
  6. com.atlassian.config
    LifecycleServletContextListener.contextInitialized
    1. com.atlassian.config.lifecycle.DefaultLifecycleManager.startUp(DefaultLifecycleManager.java:40)
    2. com.atlassian.config.lifecycle.LifecycleServletContextListener.contextInitialized(LifecycleServletContextListener.java:17)
    2 frames
  7. Glassfish Core
    ContainerBase$StartChild.call
    1. org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4973)
    2. org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5467)
    3. org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
    4. org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1559)
    5. org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1549)
    5 frames
  8. Java RT
    Thread.run
    1. java.util.concurrent.FutureTask.run(Unknown Source)
    2. java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    3. java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    4. java.lang.Thread.run(Unknown Source)
    4 frames