[jira] [Commented] (ROL-2175) mysql connection errors due to no validation

["David M. Johnson (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/ROL-2175?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17564718#comment-17564718 ] 

David M. Johnson commented on ROL-2175:
---------------------------------------

Hi [~cml] , thanks for pointing this out. I see reference to a validationQuery in the Tomcat docs ([https://tomcat.apache.org/tomcat-9.0-doc/jdbc-pool.html)] and it looks like something that needs to be added to the Tomcat configuration for Roller. 

The Roller install guide discusses using a <Context> configuration file with a <Resource> for the Roller database connection and that is where the valudationQuery would go:

https://github.com/apache/roller/blob/roller-6.0.x/docs/roller-install-guide.adoc#62-using-server-provided-database--mail-resources-optional

> mysql connection errors due to no validation
> --------------------------------------------
>
>                 Key: ROL-2175
>                 URL: https://issues.apache.org/jira/browse/ROL-2175
>             Project: Apache Roller
>          Issue Type: Bug
>            Reporter: Chris Lambertus
>            Priority: Major
>
> Pursuant to INFRA-22461, despite having autoReconnect=true in our JDBC URI, we still see these failures constantly:
> DatabaseException
> Internal Exception: com.mysql.cj.jdbc.exceptions.CommunicationsException: The last packet successfully received from the server was 85,486,668 milliseconds ago. The last packet sent successfully to the server was 85,486,674 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.
> Error Code: 0
>  
> Most java applications using the default Tomcat JDBC Resource allow for a validationQuery parameter such as "SELECT 1" to keep the database connection alive. Can such a parameter be added to roller to avoid database timeouts?



--
This message was sent by Atlassian Jira
(v8.20.10#820010)