topic Re: pb with nuxeo and mysql database in Nuxeo Forum

pb with nuxeo and mysql database

philippe_gassin — Tue, 12 Nov 2013 10:11:17 GMT

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

Re: pb with nuxeo and mysql database

bruce_Grant — Tue, 12 Nov 2013 14:07:00 GMT

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

Re: pb with nuxeo and mysql database

philippe_gassin — Tue, 12 Nov 2013 14:15:11 GMT

yes we had add it....same result

Re: pb with nuxeo and mysql database

bruce_Grant — Tue, 12 Nov 2013 14:23:57 GMT

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?

Re: pb with nuxeo and mysql database

philippe_gassin — Tue, 12 Nov 2013 14:56:38 GMT

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