[opencms-dev] SQL-Timeout

[Bernhard Zebedin]

Dear all...

I have an interesting problem.

On one of my OpenCMS instances I get following errors:


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?
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".
at org.opencms.db.CmsDbSqlException.createException(CmsDbSqlException.java:109)
at org.opencms.db.CmsDbContext.throwException(CmsDbContext.java:335)
at org.opencms.db.CmsDbContext.report(CmsDbContext.java:287)
at org.opencms.db.CmsSecurityManager.readStaticExportPublishedResourceParameters(CmsSecurityManager.java:5279)
at org.opencms.file.CmsObject.readStaticExportPublishedResourceParameters(CmsObject.java:3491)
at org.opencms.staticexport.CmsStaticExportManager.getRfsExportData(CmsStaticExportManager.java:2410)
at org.opencms.staticexport.CmsStaticExportManager.getExportData(CmsStaticExportManager.java:910)
at org.opencms.main.OpenCmsServlet.handle(OpenCmsServlet.java:209)
at org.opencms.main.OpenCmsServlet.invokeHandler(OpenCmsServlet.java:292)
at org.opencms.main.OpenCmsServlet.doGet(OpenCmsServlet.java:153)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:618)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:725)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.opencms.jsp.jsonpart.CmsJsonPartFilter.doFilter(CmsJsonPartFilter.java:281)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.opencms.main.OpenCmsUrlServletFilter.doFilter(OpenCmsUrlServletFilter.java:132)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:610)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:537)
at org.apache.coyote.ajp.AbstractAjpProcessor.process(AbstractAjpProcessor.java:827)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:658)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1580)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1537)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1152)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:622)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.opencms.db.CmsDbSqlException: Ein SQL-Fehler ist aufgetreten beim Ausf?hren der folgenden Datenbankabfrage: com.mysql.jdbc.JDBC4PreparedStatement at 37826c1: EXCEPTION: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed..
at org.opencms.db.generic.CmsProjectDriver.readStaticExportPublishedResourceParameters(CmsProjectDriver.java:2604)
at org.opencms.db.CmsDriverManager.readStaticExportPublishedResourceParameters(CmsDriverManager.java:7950)
at org.opencms.db.CmsSecurityManager.readStaticExportPublishedResourceParameters(CmsSecurityManager.java:5277)
... 35 more
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.
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.CmsProjectDriver.readStaticExportPublishedResourceParameters(CmsProjectDriver.java:2594)
... 37 more
Caused by: java.net.SocketException: Broken pipe (Write failed)
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:115)
at java.net.SocketOutputStream.write(SocketOutputStream.java:161)
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)
... 46 more

?
Where can I configure such a "wait_timeout" ??
After log in an re-export static content everything is fine....

kr
Bernhard

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20180515/cb1b6a6a/attachment.htm>