Re: SQLException - Could not retrieve transation read-only status server
It looks like you have some stalled connections hanging around in the connection pool for a long time.
I don't know any details about how to configure it but it seems to me you are missing some keep-alive verification settings on it. There's not much more I can do with the information you shared.
Another thing you could try doing is monitoring open sessions on server and try to identify processes (sessions) in a bad state.
There seemed to be some issues with server-side prepared statements on MySQL 5.6 that could affect this, but by the looks of your connection string you are not using them.
Please note that Connector/J 6.0 is not a supported series. You should upgrade to latest version of Connector/J 8.0 as soon as possible. I would also recommend you to use MySQL Server 8.0.
Subject
Written By
Posted
February 03, 2020 02:56AM
February 03, 2020 03:10AM
Re: SQLException - Could not retrieve transation read-only status server
February 03, 2020 11:23AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.