<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: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:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@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:"Form\00E1tovan\00FD v HTML Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
span.FormtovanvHTMLChar
{mso-style-name:"Form\00E1tovan\00FD v HTML Char";
mso-style-priority:99;
mso-style-link:"Form\00E1tovan\00FD v HTML";
font-family:"Consolas","serif";
color:black;}
span.StylE-mailovZprvy19
{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 70.85pt 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=CS 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'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>i think you can avoid this exception by modify some mysql connection pool settings in opencms.properties too, byt i dont remember which atributes makes the trick</span><span style='font-size:11.0pt;font-family:Wingdings;color:#1F497D'>J</span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><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><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>--<br>S pozdravem / </span><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";mso-fareast-language:DE'>Kind regards</span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'><br>Filip Kratochvil<br>------------------------------------------------<br>NELASOFT Technologies, s.r.o.</span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><br></span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>E-mail: </span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><a href="mailto:filip.kratochvil@nelasoft.cz"><span style='color:blue'>filip.kratochvil@nelasoft.cz</span></a><br></span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>Web:</span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> <a href="http://www.nelasoft.cz/" target="_blank"><span style='color:blue'>www.nelasoft.cz</span></a><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>Twitter: </span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><a href="https://twitter.com/NELASOFT"><span style='color:blue'>@NELASOFT</span></a></span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p></o:p></span></p></div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><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'>From:</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>On Behalf Of </b>Christoph Kukulies<br><b>Sent:</b> Friday, February 12, 2016 10:55 AM<br><b>To:</b> opencms-dev@opencms.org<br><b>Subject:</b> Re: [opencms-dev] mysql jdbc4 socket write error<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal style='margin-bottom:12.0pt'>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. <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><br><br>Am 12.02.2016 um 09:45 schrieb Christoph Kukulies:<o:p></o:p></p></div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><p class=MsoNormal>This just happened to me under 9.5.3 on a large publish<br><br>An SQL error occurred when executing the following query: <a href="mailto:com.mysql.jdbc.JDBC4PreparedStatement@13ad085">com.mysql.jdbc.JDBC4PreparedStatement@13ad085</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 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:<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@13ad085">com.mysql.jdbc.JDBC4PreparedStatement@13ad085</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:2354)<o:p></o:p></pre><pre> at org.opencms.db.CmsDriverManager.readResource(CmsDriverManager.java:7579)<o:p></o:p></pre><pre> at org.opencms.db.CmsSecurityManager.readResource(CmsSecurityManager.java:7348)<o:p></o:p></pre><pre> at org.opencms.db.CmsSecurityManager.readResource(CmsSecurityManager.java:4987)<o:p></o:p></pre><pre> at org.opencms.file.CmsObject.readResource(CmsObject.java:3084)<o:p></o:p></pre><pre> at org.opencms.file.CmsObject.readDefaultFile(CmsObject.java:2379)<o:p></o:p></pre><pre> at org.opencms.file.CmsObject.readDefaultFile(CmsObject.java:2347)<o:p></o:p></pre><pre> at org.opencms.main.OpenCmsCore.initResource(OpenCmsCore.java:1537)<o:p></o:p></pre><pre> at org.opencms.main.OpenCmsCore.showResource(OpenCmsCore.java:1730)<o:p></o:p></pre><pre> at org.opencms.main.OpenCmsServlet.doGet(OpenCmsServlet.java:159)<o:p></o:p></pre><pre> at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)<o:p></o:p></pre><pre> at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)<o:p></o:p></pre><pre> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)<o:p></o:p></pre><pre> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<o:p></o:p></pre><pre> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)<o:p></o:p></pre><pre> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)<o:p></o:p></pre><pre> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)<o:p></o:p></pre><pre> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)<o:p></o:p></pre><pre> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)<o:p></o:p></pre><pre> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)<o:p></o:p></pre><pre> at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)<o:p></o:p></pre><pre> at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:620)<o:p></o:p></pre><pre> at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)<o:p></o:p></pre><pre> at java.lang.Thread.run(Unknown Source)<o:p></o:p></pre><pre>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.<o:p></o:p></pre><pre> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)<o:p></o:p></pre><pre> at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)<o:p></o:p></pre><pre> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)<o:p></o:p></pre><pre> at java.lang.reflect.Constructor.newInstance(Unknown Source)<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:2335)<o:p></o:p></pre><pre> ... 23 more<o:p></o:p></pre><pre>Caused by: java.net.SocketException: Software caused connection abort: socket write error<o:p></o:p></pre><pre> at java.net.SocketOutputStream.socketWrite0(Native Method)<o:p></o:p></pre><pre> at java.net.SocketOutputStream.socketWrite(Unknown Source)<o:p></o:p></pre><pre> at java.net.SocketOutputStream.write(Unknown Source)<o:p></o:p></pre><pre> at java.io.BufferedOutputStream.flushBuffer(Unknown Source)<o:p></o:p></pre><pre> at java.io.BufferedOutputStream.flush(Unknown Source)<o:p></o:p></pre><pre> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3922)<o:p></o:p></pre><pre> ... 32 more<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>Anyone seen this before?<o:p></o:p></pre><pre><o:p> </o:p></pre><p class=MsoNormal><br>-- <br>Chris Christoph P. U. Kukulies kukulies (at) rwth-aachen.de <o:p></o:p></p></div><p class=MsoNormal><br><br><br><o:p></o:p></p><pre>Dieser Nachrichteninhalt wird auf Anfrage komplett heruntergeladen.<o:p></o:p></pre></blockquote><p class=MsoNormal><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>