<html>
<head>
<meta content="text/html; charset=iso-8859-15"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">I've been advised in private Email by a
friendly co-reader of this list - all here are friendly, of course
- <br>
to raise values in my.ini / my.cnf of wait_timeout und
interactive_timeout. default is 28800 secs.<br>
(which seems to me a large value). OTOH I read in the net that it
is advisable to lower this value<br>
on webservers in production environments, where it may appear
undesirable to have dangling sockets<br>
blocking for such a long time. <br>
<br>
<div class="moz-signature">-- <br>
Chris Christoph P. U. Kukulies kukulies (at) rwth-aachen.de
</div>
<br>
<br>
Am 12.02.2016 um 09:45 schrieb Christoph Kukulies:<br>
</div>
<blockquote cite="mid:56BD9BB8.2070602@physik.rwth-aachen.de"
type="cite">
<meta http-equiv="content-type" content="text/html;
charset=iso-8859-15">
<div class="moz-signature">This just happened to me under 9.5.3 on
a large publish<br>
<br>
An SQL error occurred when executing the following query:
com.mysql.jdbc.JDBC4PreparedStatement@13ad085: EXCEPTION:
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException:
No operations allowed after statement closed..<br>
Reason: The last packet successfully received from the server
was 58,031,040 milliseconds ago. The last packet sent
successfully to the server was 58,031,040 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.<br>
Reason: Software caused connection abort: socket write error<br>
<br>
<br>
<br>
<br>
Corresponding Details:<br>
<pre><pre>org.opencms.db.CmsDbSqlException: An SQL error occurred when executing the following query: com.mysql.jdbc.JDBC4PreparedStatement@13ad085: EXCEPTION: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed..
at org.opencms.db.generic.CmsVfsDriver.readResource(CmsVfsDriver.java:2354)
at org.opencms.db.CmsDriverManager.readResource(CmsDriverManager.java:7579)
at org.opencms.db.CmsSecurityManager.readResource(CmsSecurityManager.java:7348)
at org.opencms.db.CmsSecurityManager.readResource(CmsSecurityManager.java:4987)
at org.opencms.file.CmsObject.readResource(CmsObject.java:3084)
at org.opencms.file.CmsObject.readDefaultFile(CmsObject.java:2379)
at org.opencms.file.CmsObject.readDefaultFile(CmsObject.java:2347)
at org.opencms.main.OpenCmsCore.initResource(OpenCmsCore.java:1537)
at org.opencms.main.OpenCmsCore.showResource(OpenCmsCore.java:1730)
at org.opencms.main.OpenCmsServlet.doGet(OpenCmsServlet.java:159)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:620)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Unknown Source)
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 58,031,040 milliseconds ago. The last packet sent successfully to the server was 58,031,040 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)
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:411)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1121)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3941)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2551)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2818)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2157)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2324)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.opencms.db.generic.CmsVfsDriver.readResource(CmsVfsDriver.java:2335)
... 23 more
Caused by: java.net.SocketException: Software caused connection abort: socket write error
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(Unknown Source)
at java.net.SocketOutputStream.write(Unknown Source)
at java.io.BufferedOutputStream.flushBuffer(Unknown Source)
at java.io.BufferedOutputStream.flush(Unknown Source)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3922)
... 32 more
Anyone seen this before?
</pre></pre>
<br>
-- <br>
Chris Christoph P. U. Kukulies kukulies (at) rwth-aachen.de </div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">Dieser Nachrichteninhalt wird auf Anfrage komplett heruntergeladen.</pre>
</blockquote>
<br>
<div class="moz-signature">-- <br>
Chris Christoph P. U. Kukulies kukulies (at) rwth-aachen.de
</div>
</body>
</html>