AnsweredAssumed Answered

wait_timeout

Question asked by Rafael Valenzuela on Jan 6, 2018
Latest reply on Apr 11, 2018 by Rafael Valenzuela


Hi all!

I have a little problem with my Pentaho (server) and MySQL. I'm following the Pentaho documentation for change the repository a MySQL.

I'm trying to use a C3PO but the behavior is the same.

The principal error is :

 

Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 71,926,795 milliseconds ago.  The last packet se
nt successfully to the server was 71,926,796 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testin
g 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.

 

Any idea?

Outcomes