Re: connection unexectedly terminated
Posted by: Fernando Gonzalez Sanchez
Date: October 15, 2014 02:13PM

Hi, you'll need to provide more details

Off hand the problem may be due to network errors or timeouts from the Server, in case of timeout, you can reconfigure a larger threshold

As specified from:
http://bugs.mysql.com/bug.php?id=57365


the documentation for this variables is avialable here http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_net_read_timeou...

No mention of max value, however I checked at the server code 5.6.4 and found that the biggest value allowed for these net_xx_timeout variables is 31536000.

I tested it and is set correctly with the queries:

set net_write_timeout = 31536000
show variables like 'net_write_timeout'

Source:

sql\sys_vars.c
static Sys_var_ulong Sys_net_write_timeout(
"net_write_timeout",
"Number of seconds to wait for a block to be written to a connection "
"before aborting the write",
SESSION_VAR(net_write_timeout), CMD_LINE(REQUIRED_ARG),
VALID_RANGE(1, LONG_TIMEOUT), DEFAULT(NET_WRITE_TIMEOUT), BLOCK_SIZE(1),
NO_MUTEX_GUARD, NOT_IN_BINLOG, ON_CHECK(0),
ON_UPDATE(fix_net_write_timeout));

sql\sql_const.h
#define LONG_TIMEOUT ((ulong) 3600L*24L*365L)

*** My opinions do not necessarily reflect the opinions of my employeer ***
Fernando Gonzalez Sanchez
Sr. Software Engineer
MySql Connector/NET Team
Oracle Corporation

Options: ReplyQuote


Subject
Written By
Posted
Re: connection unexectedly terminated
October 15, 2014 02:13PM


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.