Uploaded image for project: 'ONE'
  1. ONE
  2. ONE-5741

"Connection is closed" or "No operations allowed after connection closed."

    XMLWordPrintable

    Details

    • Team:
      Support
    • Host platform:
      JIRA server
    • SoftwarePlant People involved:
      katarzyna.gniadek Katarzyna Gniadek , marta.mazurkiewicz Marta Mazurkiewicz , vira.yaremchuk Vira Yaremchuk , lukasz.romaniuk Łukasz Romaniuk , grzegorz.duzy Grzegorz Duży , pawel.guz Pawel Guz , gabriel.wielkopolski Gabriel Wielkopolski , jacek.ejsmont Jacek Ejsmont , marcin.kozinski Marcin Koziński , robert.zientarski Robert Zientarski (Inactive) , tom.kucharski Tom Kucharski , rafal.sosnowski Rafał Sosnowski , tomasz.jaskiewicz Tomasz Jaśkiewicz , michal.niwinski Michal Niwinski
    • Customer Rank:
      82

      Description

      at com.softwareplant.util.jpa.DiagnosticConnectionProxyFactory$DiagnosticConnectionInvocationHandler.invoke(DiagnosticConnectionProxyFactory.java:46)
      ... 305 more
      Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.
      at sun.reflect.GeneratedConstructorAccessor1203.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:411)
      at com.mysql.jdbc.Util.getInstance(Util.java:386)
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:975)
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:920)
      at com.mysql.jdbc.ConnectionImpl.throwConnectionClosedException(ConnectionImpl.java:1311)
      at com.mysql.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:1303)
      at com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:4530)
      at com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:4495)
      at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:288)
      at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:288)
      at org.ofbiz.core.entity.jdbc.interceptors.connection.DelegatingConnection.prepareStatement(DelegatingConnection.java:37)
      ... 309 more
      Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 33.472.100 milliseconds ago. The last packet sent successfully to the server was 33.472.100 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
      at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      

        Attachments

          Activity

              People

              Assignee:
              Unassigned
              Reporter:
              michal.niwinski Michal Niwinski
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: