Re: Inconsistent Exceptions: Unable to Connect and Timeout

[Greg Wyatt]

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: http://support.microsoft.com/kb/2553549

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