<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">I got this same error this morning when
I tried to log into the workplace again. This time it is the<br>
8.0.4 to 9.0.1 updated workplace server.<br>
<br>
It looks something wants to run a JDBC4 prepared statement?<br>
<br>
Which component is using JDBC anyway?<br>
<br>
restarting tomcat was not necessary. Only after two other login
attempts the workplace came up.<br>
<br>
Any ideas?<br>
<br>
<br>
<br>
Am 27.08.2014 um 09:02 schrieb Christoph Kukulies:<br>
</div>
<blockquote cite="mid:53FD828D.2020803@physik.rwth-aachen.de"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
I tried to login into the 9.0.1 workplace this morning and got:<br>
<br>
<i><small><small><font face="Courier New, Courier, monospace">An
SQL error occurred when executing the following query:
com.mysql.jdbc.JDBC4PreparedStatement@191b0b1: EXCEPTION:
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException:
No operations allowed after statement closed.. <br>
Reason: The last packet successfully received from the
server was 47,922,526 milliseconds ago. The last packet
sent successfully to the server was 47,922,526
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: Broken pipe </font></small></small></i><br>
<pre><pre>org.opencms.db.CmsDbSqlException: An SQL error occurred when executing the following query: com.mysql.jdbc.JDBC4PreparedStatement@191b0b1: EXCEPTION: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed..
at org.opencms.db.generic.CmsVfsDriver.readResource(CmsVfsDriver.java:2330)
at org.opencms.db.CmsDriverManager.readResource(CmsDriverManager.java:7500)
at org.opencms.db.CmsSecurityManager.readResource(CmsSecurityManager.java:7241)
at org.opencms.db.CmsSecurityManager.readResource(CmsSecurityManager.java:4898)
at org.opencms.file.CmsObject.readResource(CmsObject.java:2957)
at org.opencms.file.CmsObject.readResource(CmsObject.java:2924)
at org.opencms.file.CmsObject.readDefaultFile(CmsObject.java:2252)
at org.opencms.main.OpenCmsCore.initResource(OpenCmsCore.java:1493)
at org.opencms.main.OpenCmsCore.showResource(OpenCmsCore.java:1716)
at org.opencms.main.OpenCmsServlet.doGet(OpenCmsServlet.java:153)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:620)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:315)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 47,922,526 milliseconds ago. The last packet sent successfully to the server was 47,922,526 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(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: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:2309)
... 27 more
Caused by: java.net.SocketException: Broken pipe
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:113)
at java.net.SocketOutputStream.write(SocketOutputStream.java:159)
at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)
at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3922)
... 36 more</pre></pre>
Only restarting Tomcat7 again made it possible to login again.<br>
<br>
<br>
<div class="moz-signature">-- <br>
Chris Christoph P. U. Kukulies kukulies (at) rwth-aachen.de </div>
<br>
</blockquote>
<br>
<br>
<div class="moz-signature">-- <br>
Chris Christoph P. U. Kukulies kukulies (at) rwth-aachen.de
</div>
</body>
</html>