<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none"><!-- p { margin-top: 0px; margin-bottom: 0px; }--></style>
</head>
<body dir="ltr" style="font-size:12pt;color:#000000;background-color:#FFFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;">
<p>Dear all...<br>
</p>
<p>I have an interesting problem.<br>
</p>
<p>On one of my OpenCMS instances I get following errors:<br>
</p>
<p><br>
</p>
<div>15 May 2018 10:53:22,225 WARN [cexport.CmsStaticExportManager:2434] Datei "/shared/Bilder/Logos/AMP_logo2.png_790064987.png" kann nicht exportiert werden. Hat der Benutzer "guest" Leseberechtigung?</div>
<div>org.opencms.db.CmsDbSqlException: Fehler beim Lesen der Parameter f?r eine Ressource in der Tabelle aller ver?ffentlichter Template-Ressourcen mit dem tats?chlichen Dateinamen "/shared/Bilder/Logos/AMP_logo2.png_790064987.png".</div>
<div><span style="white-space:pre"></span>at org.opencms.db.CmsDbSqlException.createException(CmsDbSqlException.java:109)</div>
<div><span style="white-space:pre"></span>at org.opencms.db.CmsDbContext.throwException(CmsDbContext.java:335)</div>
<div><span style="white-space:pre"></span>at org.opencms.db.CmsDbContext.report(CmsDbContext.java:287)</div>
<div><span style="white-space:pre"></span>at org.opencms.db.CmsSecurityManager.readStaticExportPublishedResourceParameters(CmsSecurityManager.java:5279)</div>
<div><span style="white-space:pre"></span>at org.opencms.file.CmsObject.readStaticExportPublishedResourceParameters(CmsObject.java:3491)</div>
<div><span style="white-space:pre"></span>at org.opencms.staticexport.CmsStaticExportManager.getRfsExportData(CmsStaticExportManager.java:2410)</div>
<div><span style="white-space:pre"></span>at org.opencms.staticexport.CmsStaticExportManager.getExportData(CmsStaticExportManager.java:910)</div>
<div><span style="white-space:pre"></span>at org.opencms.main.OpenCmsServlet.handle(OpenCmsServlet.java:209)</div>
<div><span style="white-space:pre"></span>at org.opencms.main.OpenCmsServlet.invokeHandler(OpenCmsServlet.java:292)</div>
<div><span style="white-space:pre"></span>at org.opencms.main.OpenCmsServlet.doGet(OpenCmsServlet.java:153)</div>
<div><span style="white-space:pre"></span>at javax.servlet.http.HttpServlet.service(HttpServlet.java:618)</div>
<div><span style="white-space:pre"></span>at javax.servlet.http.HttpServlet.service(HttpServlet.java:725)</div>
<div><span style="white-space:pre"></span>at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)</div>
<div><span style="white-space:pre"></span>at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)</div>
<div><span style="white-space:pre"></span>at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)</div>
<div><span style="white-space:pre"></span>at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)</div>
<div><span style="white-space:pre"></span>at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)</div>
<div><span style="white-space:pre"></span>at org.opencms.jsp.jsonpart.CmsJsonPartFilter.doFilter(CmsJsonPartFilter.java:281)</div>
<div><span style="white-space:pre"></span>at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)</div>
<div><span style="white-space:pre"></span>at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)</div>
<div><span style="white-space:pre"></span>at org.opencms.main.OpenCmsUrlServletFilter.doFilter(OpenCmsUrlServletFilter.java:132)</div>
<div><span style="white-space:pre"></span>at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)</div>
<div><span style="white-space:pre"></span>at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)</div>
<div><span style="white-space:pre"></span>at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)</div>
<div><span style="white-space:pre"></span>at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)</div>
<div><span style="white-space:pre"></span>at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506)</div>
<div><span style="white-space:pre"></span>at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)</div>
<div><span style="white-space:pre"></span>at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)</div>
<div><span style="white-space:pre"></span>at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:610)</div>
<div><span style="white-space:pre"></span>at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)</div>
<div><span style="white-space:pre"></span>at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:537)</div>
<div><span style="white-space:pre"></span>at org.apache.coyote.ajp.AbstractAjpProcessor.process(AbstractAjpProcessor.java:827)</div>
<div><span style="white-space:pre"></span>at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:658)</div>
<div><span style="white-space:pre"></span>at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1580)</div>
<div><span style="white-space:pre"></span>at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1537)</div>
<div><span style="white-space:pre"></span>at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1152)</div>
<div><span style="white-space:pre"></span>at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:622)</div>
<div><span style="white-space:pre"></span>at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)</div>
<div><span style="white-space:pre"></span>at java.lang.Thread.run(Thread.java:748)</div>
<div>Caused by: org.opencms.db.CmsDbSqlException: Ein SQL-Fehler ist aufgetreten beim Ausf?hren der folgenden Datenbankabfrage: com.mysql.jdbc.JDBC4PreparedStatement@37826c1: EXCEPTION: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No
operations allowed after statement closed.. </div>
<div><span style="white-space:pre"></span>at org.opencms.db.generic.CmsProjectDriver.readStaticExportPublishedResourceParameters(CmsProjectDriver.java:2604)</div>
<div><span style="white-space:pre"></span>at org.opencms.db.CmsDriverManager.readStaticExportPublishedResourceParameters(CmsDriverManager.java:7950)</div>
<div><span style="white-space:pre"></span>at org.opencms.db.CmsSecurityManager.readStaticExportPublishedResourceParameters(CmsSecurityManager.java:5277)</div>
<div><span style="white-space:pre"></span>... 35 more</div>
<div>Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 83,754,956 milliseconds ago. The last packet sent successfully to the server was 83,754,956 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.</div>
<div><span style="white-space:pre"></span>at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)</div>
<div><span style="white-space:pre"></span>at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)</div>
<div><span style="white-space:pre"></span>at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)</div>
<div><span style="white-space:pre"></span>at java.lang.reflect.Constructor.newInstance(Constructor.java:526)</div>
<div><span style="white-space:pre"></span>at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)</div>
<div><span style="white-space:pre"></span>at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1121)</div>
<div><span style="white-space:pre"></span>at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3941)</div>
<div><span style="white-space:pre"></span>at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2551)</div>
<div><span style="white-space:pre"></span>at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)</div>
<div><span style="white-space:pre"></span>at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2818)</div>
<div><span style="white-space:pre"></span>at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2157)</div>
<div><span style="white-space:pre"></span>at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2324)</div>
<div><span style="white-space:pre"></span>at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)</div>
<div><span style="white-space:pre"></span>at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)</div>
<div><span style="white-space:pre"></span>at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)</div>
<div><span style="white-space:pre"></span>at org.opencms.db.generic.CmsProjectDriver.readStaticExportPublishedResourceParameters(CmsProjectDriver.java:2594)</div>
<div><span style="white-space:pre"></span>... 37 more</div>
<div>Caused by: java.net.SocketException: Broken pipe (Write failed)</div>
<div><span style="white-space:pre"></span>at java.net.SocketOutputStream.socketWrite0(Native Method)</div>
<div><span style="white-space:pre"></span>at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:115)</div>
<div><span style="white-space:pre"></span>at java.net.SocketOutputStream.write(SocketOutputStream.java:161)</div>
<div><span style="white-space:pre"></span>at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)</div>
<div><span style="white-space:pre"></span>at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140)</div>
<div><span style="white-space:pre"></span>at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3922)</div>
<div><span style="white-space:pre"></span>... 46 more</div>
<div><br>
<br>
</div>
<div>Where can I configure such a "wait_timeout" ??<br>
</div>
<div>After log in an re-export static content everything is fine....<br>
</div>
<div><br>
</div>
<div>kr<br>
</div>
<div>Bernhard<br>
</div>
<p><br>
</p>
</body>
</html>