<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Vorformatiert Zchn";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
span.HTMLVorformatiertZchn
{mso-style-name:"HTML Vorformatiert Zchn";
mso-style-priority:99;
mso-style-link:"HTML Vorformatiert";
font-family:Consolas;
color:black;}
span.E-MailFormatvorlage19
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body bgcolor="white" lang="DE" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Hi Chris,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">wait_timeout:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><a href="http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_wait_timeout">http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_wait_timeout</a><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">JDBC:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><a href="http://www.oracle.com/technetwork/java/javase/jdbc/index.html">http://www.oracle.com/technetwork/java/javase/jdbc/index.html</a><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">AFAIK, this error occurs, if the time between two database “requests” is longer than wait_timeout.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">HTH<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Best regards<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Kai<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext">Von:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext"> opencms-dev-bounces@opencms.org [mailto:opencms-dev-bounces@opencms.org]
<b>Im Auftrag von </b>Christoph Kukulies<br>
<b>Gesendet:</b> Freitag, 29. August 2014 11:56<br>
<b>An:</b> opencms >> The OpenCms mailing list<br>
<b>Betreff:</b> Re: [opencms-dev] SQL error in OpenCms 9.0.1 workplace<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">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:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal">I tried to login into the 9.0.1 workplace this morning and got:<br>
<br>
<i><span style="font-size:7.5pt;font-family:"Courier New"">An SQL error occurred when executing the following query:
<a href="mailto:com.mysql.jdbc.JDBC4PreparedStatement@191b0b1">com.mysql.jdbc.JDBC4PreparedStatement@191b0b1</a>: 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 </span></i><o:p></o:p></p>
<pre>org.opencms.db.CmsDbSqlException: An SQL error occurred when executing the following query: <a href="mailto:com.mysql.jdbc.JDBC4PreparedStatement@191b0b1">com.mysql.jdbc.JDBC4PreparedStatement@191b0b1</a>: EXCEPTION: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed.. <o:p></o:p></pre>
<pre> at org.opencms.db.generic.CmsVfsDriver.readResource(CmsVfsDriver.java:2330)<o:p></o:p></pre>
<pre> at org.opencms.db.CmsDriverManager.readResource(CmsDriverManager.java:7500)<o:p></o:p></pre>
<pre> at org.opencms.db.CmsSecurityManager.readResource(CmsSecurityManager.java:7241)<o:p></o:p></pre>
<pre> at org.opencms.db.CmsSecurityManager.readResource(CmsSecurityManager.java:4898)<o:p></o:p></pre>
<pre> at org.opencms.file.CmsObject.readResource(CmsObject.java:2957)<o:p></o:p></pre>
<pre> at org.opencms.file.CmsObject.readResource(CmsObject.java:2924)<o:p></o:p></pre>
<pre> at org.opencms.file.CmsObject.readDefaultFile(CmsObject.java:2252)<o:p></o:p></pre>
<pre> at org.opencms.main.OpenCmsCore.initResource(OpenCmsCore.java:1493)<o:p></o:p></pre>
<pre> at org.opencms.main.OpenCmsCore.showResource(OpenCmsCore.java:1716)<o:p></o:p></pre>
<pre> at org.opencms.main.OpenCmsServlet.doGet(OpenCmsServlet.java:153)<o:p></o:p></pre>
<pre> at javax.servlet.http.HttpServlet.service(HttpServlet.java:620)<o:p></o:p></pre>
<pre> at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)<o:p></o:p></pre>
<pre> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)<o:p></o:p></pre>
<pre> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)<o:p></o:p></pre>
<pre> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)<o:p></o:p></pre>
<pre> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)<o:p></o:p></pre>
<pre> at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)<o:p></o:p></pre>
<pre> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)<o:p></o:p></pre>
<pre> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)<o:p></o:p></pre>
<pre> at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)<o:p></o:p></pre>
<pre> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)<o:p></o:p></pre>
<pre> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)<o:p></o:p></pre>
<pre> at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)<o:p></o:p></pre>
<pre> at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)<o:p></o:p></pre>
<pre> at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:315)<o:p></o:p></pre>
<pre> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)<o:p></o:p></pre>
<pre> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)<o:p></o:p></pre>
<pre> at java.lang.Thread.run(Thread.java:745)<o:p></o:p></pre>
<pre>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.<o:p></o:p></pre>
<pre> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)<o:p></o:p></pre>
<pre> at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)<o:p></o:p></pre>
<pre> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)<o:p></o:p></pre>
<pre> at java.lang.reflect.Constructor.newInstance(Constructor.java:526)<o:p></o:p></pre>
<pre> at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)<o:p></o:p></pre>
<pre> at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1121)<o:p></o:p></pre>
<pre> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3941)<o:p></o:p></pre>
<pre> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2551)<o:p></o:p></pre>
<pre> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)<o:p></o:p></pre>
<pre> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2818)<o:p></o:p></pre>
<pre> at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2157)<o:p></o:p></pre>
<pre> at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2324)<o:p></o:p></pre>
<pre> at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)<o:p></o:p></pre>
<pre> at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)<o:p></o:p></pre>
<pre> at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)<o:p></o:p></pre>
<pre> at org.opencms.db.generic.CmsVfsDriver.readResource(CmsVfsDriver.java:2309)<o:p></o:p></pre>
<pre> ... 27 more<o:p></o:p></pre>
<pre>Caused by: java.net.SocketException: Broken pipe<o:p></o:p></pre>
<pre> at java.net.SocketOutputStream.socketWrite0(Native Method)<o:p></o:p></pre>
<pre> at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:113)<o:p></o:p></pre>
<pre> at java.net.SocketOutputStream.write(SocketOutputStream.java:159)<o:p></o:p></pre>
<pre> at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)<o:p></o:p></pre>
<pre> at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140)<o:p></o:p></pre>
<pre> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3922)<o:p></o:p></pre>
<pre> ... 36 more<o:p></o:p></pre>
<p class="MsoNormal" style="margin-bottom:12.0pt">Only restarting Tomcat7 again made it possible to login again.<br>
<br>
<o:p></o:p></p>
<div>
<p class="MsoNormal">-- <br>
Chris Christoph P. U. Kukulies kukulies (at) rwth-aachen.de <o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</blockquote>
<p class="MsoNormal" style="margin-bottom:12.0pt"><o:p> </o:p></p>
<div>
<p class="MsoNormal">-- <br>
Chris Christoph P. U. Kukulies kukulies (at) rwth-aachen.de <o:p></o:p></p>
</div>
</div>
</body>
</html>