Re: Communications link failure due to underlying exception...various network exceptions
Posted by: Mark Matthews
Date: February 13, 2007 01:52PM

What happens if you run with "useServerPrepStmts=false"? It looks like the connection is going away while the driver is trying to read results, which often is one of two things...The server is crashing, or your client is reading rows slower than the timeout 'net_write_timeout' on the server.

Disabling server-side prepared statements usually takes care of the former (and in fact, they're disabled by default in 5.0.5 and later).

-Mark

Mark Matthews
Consulting Member Technical Staff - MySQL Enterprise Tools
Oracle
http://www.mysql.com/products/enterprise/monitor.html

Options: ReplyQuote


Subject
Written By
Posted
Re: Communications link failure due to underlying exception...various network exceptions
February 13, 2007 01:52PM


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.