pb with nuxeo and mysql database

[philippe_gassin]

hello, I use a mysql database with nuxeo (version 5.6.0-HF17)...once a day we are obliged to reboot the application due to this kind of error

"Can not read response from server" (com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3002)

do someone have an answer to this type of problem ? thanks

[bruce_Grant]

Are you using ;autoReconnect=true in your jdbc connection string?

[philippe_gassin]

yes we had add it....same result

[bruce_Grant]

Used to run MySQL with Nuxeo but abandoned a few years ago when I kept having similar problems... Have you turned on detailed logging to see if there is anything of interest? Have you tried to set nuxeo.db.transactiontimeout higher in case it's a saturation issue?

[philippe_gassin]

we are planning to transfer database to an oracle system...I will take a look to the timeout. thanks