How to resolve : MySQLNonTransientConectionException when trying to run a query against MySQL DB

[MeenaExplore]

I'm recieving the below error when I run my query against my MySQL DB. The result of this just has max of 4 records. If I run it against my DB client like TOAD or Aquadata, it works perfectly fine. I'm sure this error is because of the SOAPUIPro(Ready API) tool where the connection object might not be properly handled internally and hence its resulting this error. This was running fine for first few runs and then it started to give this error. Has somebody faced this issue and if so, can you please help me as this is frustrating and uts blocking my automated test.

2019-08-01 14:54:16.029 - Error getting response; com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Too many connections

[Olga_T]

Thanks for reaching out, @MeenaExplore. Sorry to hear that you are facing this situation.

Community, can we help MeenaExplore with comments, suggestions, ideas?

[Nastya_Khovrina · Accepted solution]

Hi @MeenaExplore,

Please try the suggestions from these articles:

- https://stackoverflow.com/questions/5274558/mysqlnontransientconnectionexception-too-many-connection...

- https://support.xebialabs.com/hc/en-us/articles/360000141586-How-to-fix-com-mysql-jdbc-exceptions-jd...

- https://intojava.wordpress.com/2017/09/27/mysqlnontransientconnectionexception-too-many-connections/

If this doesn't help, please provide the following details:

- What driver do you use?

- Can you reproduce the issue after you restart ReadyAPI?

- Can you reproduce the issue for another query?

[Olga_T]

Thank you for the reply, @Nastya_Khovrina.

@MeenaExplore, did the above information help you? We are looking forward to hearing from you.