Need help for resolving the following error by Sonar-runner:
13:57:55.705 WARN - exception clearing maxRows/queryTimeout
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed.
. . . . .
13:57:55.707 WARN - SQL Error: 0, SQLState: 08S01
13:57:55.708 ERROR - Communications link failure
The last packet successfully received from the server was 3,765,195 milliseconds ago.
The last packet sent successfully to the server was 3 milliseconds ago.
MySQL Configuration:
mysql> show global variables like '%timeout%';
interactive_timeout= 28800
wait_timeout = 28800
JDBC Connection string:
jdbc:mysql://usaus020013srv.us002.siemens.net:3306/sonartest?enableQueryTimeouts=false&autoReconnet=true&useUnicode=true&characterEncoding=utf8
There are already threads which suggest that change the wait_timeout to a sufficiently big value, but I already have it set to 28800 which is 8 hours.
Regards, Girish Joshi