pb with nuxeo and mysql database

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

0 votes

0 answers

796 views

ANSWER

Are you using ;autoReconnect=true in your jdbc connection string?
11/12/2013

yes we had add it….same result
11/12/2013

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?
11/12/2013

we are planning to transfer database to an oracle system…I will take a look to the timeout. thanks
11/12/2013