Re: Mysql connectTimeout And socketTimeout not working
Posted by: Filipe Silva
Date: July 09, 2014 12:02PM

Hi,

'connectTimeout' is used only while establishing the connection to the server. Once the connection is established 'socketTimeout' sets the timeout for every single read/write operation. If there is some network problem it may cause some operations take longer than others and at some point one actually reaches the timeout so, the sum of all wait times would be longer than the timeout. I'm not saying that this is what's happening but could be an explanation for different timeout times.

On the other hand, this looks very close to the Bug#24995 (http://bugs.mysql.com/bug.php?id=24995). We still don't have a clear idea about what's happening but can you check it out to see if it fits your situation?

Meanwhile, it could be useful to see the stack trace for both situations: a failed connection and the wait indefinitely situation, can you provide those?

I really recommend that you use the latest Connector/J (no need to upgrade servers) to the latest version or at least to version 5.1.28, where the socket related code was changed for the last time.

Options: ReplyQuote




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.