Re: SQLException - Could not retrieve transation read-only status server
Posted by: Filipe Silva
Date: February 03, 2020 11:23AM

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.

Options: ReplyQuote


Subject
Written By
Posted
Re: SQLException - Could not retrieve transation read-only status server
February 03, 2020 11:23AM


Sorry, only registered users may post in this forum.

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.