[opencms-dev] SQL-Timeout

[Schliemann, Kai]

Hi Bernhard,
you may try to set a test query in opencms.properties like this:

db.pool.default.testQuery=SELECT 1

HTH
Best regards
Kai

Von: opencms-dev-bounces at opencms.org <opencms-dev-bounces at opencms.org> Im Auftrag von Bernhard Zebedin
Gesendet: Dienstag, 15. Mai 2018 11:27
An: The OpenCms mailing list <opencms-dev at opencms.org>
Betreff: [opencms-dev] SQL-Timeout


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<mailto: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/20180516/c98614ed/attachment.htm>