MySQL timeout

Q&A
1

I have a Bonitasoft 7.3 test server running MySQL on Windows. When I try unable to login to the portal after the server has been idle for a period of time the login request hangs. In the log file there is an error message that the connection has already been closed.

My understanding is that a connection is obtained from the connection pool and a select 1 is performed. If an exception is thrown the connection is discarded and another connection is obtained from the pool. This does not seem to be happening.

I am using the sample configuration in bitronix-resources.properties

MySQL example

resource.ds1.className=com.mysql.jdbc.jdbc2.optional.MysqlXADataSource
resource.ds1.driverProperties.user=bonita
resource.ds1.driverProperties.password=bonita
resource.ds1.driverProperties.URL=jdbc:mysql://localhost:3306/bonita?dontTrackOpenResources=true&useUnicode=true&characterEncoding=UTF-8
resource.ds1.testQuery=SELECT 1

2

I discovered that the disk drive the MySQL database was on was out of space. This problem seems to have gone away after I resolved that problem.