Bug #38008 invalid Relay_Log_Space value after slave i/o error

Submitted: 10 Jul 2008 6:37 Modified: 9 Mar 2012 16:56
Reporter: Shane Bester (Platinum Quality Contributor) Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Replication Severity:S3 (Non-critical)
Version:5.1.24 OS:Windows
Assigned to: CPU Architecture:Any
Tags: Relay_Log_Space

[10 Jul 2008 6:37] Shane Bester
Description:
after some slave i/o errors, show slave status outputs a negative longlong value for relay_log_space:

mysql> show slave status\G
*************************** 1. row ***************************
               Slave_IO_State: Reconnecting after a failed master event read
                  Master_Host: 127.0.0.1
                  Master_User: root
                  Master_Port: 3307
                Connect_Retry: 60
              Master_Log_File: xp64-bin.007566
          Read_Master_Log_Pos: 4
               Relay_Log_File: xp64-relay-bin.015121
                Relay_Log_Pos: 148
        Relay_Master_Log_File: xp64-bin.007566
             Slave_IO_Running: No
            Slave_SQL_Running: Yes
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 4
              Relay_Log_Space: 18446744073709547643
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: NULL
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 2003
                Last_IO_Error: error reconnecting to master 'root@127.0.0.1:3307'
               Last_SQL_Errno: 0
               Last_SQL_Error:

according to the manual: "
#Relay_Log_Space
The total combined size of all existing relay logs.
"

How to repeat:
setup replication and make some traffic.
stop/start the master every 30 seconds.
run show slave status on the slave until the error happens.
i used max_binlog_size=4096 in my tests.
[10 Jul 2008 6:38] Shane Bester
error logs and some show slave status snapshots.

Attachment: bug38008_logs.txt (text/plain), 25.72 KiB.

[16 Jan 2009 17:03] Susanne Ebrecht
Shane,

please will you look if this also happens with actual 5.1 version?
[17 Feb 2009 0:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[19 Feb 2010 14:53] Susanne Ebrecht
Sorry, bug number confusion ... bug #51194 is the duplicate and not the above one.
[29 Mar 2010 4:53] Sveta Smirnova
Thank you for the report.

Please provide output of DIR path/to/dir/where/relay/logs/located and relay.index file.
[29 Apr 2010 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[9 Mar 2012 11:38] Shane Bester
i cant repeat this on 5.1.24 or 5.1.61 anymore.  not sure how i did it to begin with.
[9 Mar 2012 16:56] Sveta Smirnova
Thank you for the feedback.

Closed as "Can't repeat" for now.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.062 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
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.