Re: Inconsistent Exceptions: Unable to Connect and Timeout
Posted by: Greg Wyatt
Date: February 08, 2013 12:27PM

Thank you so much for your reply!!! That ended up being the solution. However, for anyone else experiencing this problem, please let me add some additional details.

The article that is referenced by Fernando Gonzalez.Sanchez correctly identifies the problem, but in our case the cause was different. The article makes the assumption that the problem occurs with high traffic volumne(which it can, but this wasn't our case). What was happening in our system was that port connections were being orphaned in the TIME_WAIT state over a long period of time(several months). Eventually the system was running out of available ports and so the MySQL .Net Connector was unable to connect to any of the specified hosts. I was unable to find a way to kill the connections without cycling the machine(which is not the ideal solution, but works as a temporary fix).

I also found an article detailing a System issue that could be the cause of this, but have yet to investigate it. I will include it in case it is useful for anyone else:

Again, tons of thanks to Fernando Gonzalez.Sanchez for their help with this.

Options: ReplyQuote

Written By
Re: Inconsistent Exceptions: Unable to Connect and Timeout
February 08, 2013 12:27PM

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.