Ok. So i'm a bit confused with all the timeout values. My replication process is killed because of a net_read_timeout which is 30 secondes .
I think there's at least three different timeouts : net_read_timeout : The process will be killed if it doesn't receive data during net_read_timeout secs. slave_read_timeout : The replication process timeout (default 1 hour) wait_timeout : Inactivity timeout of a connection Maybe there's a lack of documentation about that. In my case, I have increase the net_read_timeout and now everything is fine. But what about the "priority" of timeouts ? Does the wait_timeout overwrite the net_read_timeout ? Is there a special case for System user and replication user ? Thanks by advance for any answer. Regards, S¨¦bastien sql query > Hi, > > I used replication as a real-time backup for months and I'am now trying to > configure a two-way replication between two MySQL servers (srv1 and srv2). > So, srv1 replicates from srv2 and srv2 replicates from srv1 (They are both > master and slave). > The One-way replication is working fine from srv1 to srv2. But often every > minute, srv1 failed to replicate from srv2. > > Here is the message from .err file: > 020614 5:37:36 Error reading packet from server: (server_errno=1159) > 020614 5:38:36 Slave: Failed reading log event, reconnecting to > retry, log > 'srv02-bin.003' position 386 > 020614 5:38:36 Slave: reconnected to master > '[EMAIL PROTECTED]:3306',replication resumed in log 'srv02-bin.003' at > position 386 > > (You can see that the replication is working quite fine because the slave > restarts by himself after "Connect_retry" secondes) > > According to the include/mysqld_error.h file, the error number 1159 is > ER_NET_READ_INTERRUPTED. So it seems to be a network error ? > > The configuration is exactly the same on the two boxes (MySQL 3.23.51 > compiled on mipsel linux). And the configuration options are exactly the > same. > > Does anyone has any suggestion ? > > S¨¦bastien > sql, query > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
