Bug #9127 rpl_max_relay_size fails
Submitted: 11 Mar 2005 14:56 Modified: 18 Jun 2005 2:50
Reporter: Guilhem Bichot Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Replication Severity:S3 (Non-critical)
Version:4.1 OS:Linux (linux)
Assigned to: CPU Architecture:Any

[11 Mar 2005 14:56] Guilhem Bichot
Description:
From autobuild mysql-4.1.11-nightly-20050311-build:
> Below are the diffs between actual and expected results:
> -------------------------------------------------------
> *** r/rpl_max_relay_size.result	Fri Mar 11 07:47:05 2005
> --- r/rpl_max_relay_size.reject	Fri Mar 11 08:32:43 2005
> ***************
> *** 36,42 ****
>   start slave;
>   show slave status;
>   Slave_IO_State	Master_Host	Master_User	Master_Port	Connect_Retry	Master_Log_File	Read_Master_Log_Pos	Relay_Log_File	Relay_Log_Pos	Relay_Master_Log_File	Slave_IO_Running	Slave_SQL_Running	Replicate_Do_DB	Replicate_Ignore_DB	Replicate_Do_Table	Replicate_Ignore_Table	Replicate_Wild_Do_Table	Replicate_Wild_Ignore_Table	Last_Errno	Last_Error	Skip_Counter	Exec_Master_Log_Pos	Relay_Log_Space	Until_Condition	Until_Log_File	Until_Log_Pos	Master_SSL_Allowed	Master_SSL_CA_File	Master_SSL_CA_Path	Master_SSL_Cert	Master_SSL_Cipher	Master_SSL_Key	Seconds_Behind_Master
> ! #	127.0.0.1	root	MASTER_PORT	1	master-bin.000001	50477	slave-relay-bin.000008	1283	master-bin.000001	Yes	Yes							0		0	50477	1283	None		0	No						#
>   stop slave;
>   reset slave;
>   flush logs;
> --- 36,42 ----
>   start slave;
>   show slave status;
>   Slave_IO_State	Master_Host	Master_User	Master_Port	Connect_Retry	Master_Log_File	Read_Master_Log_Pos	Relay_Log_File	Relay_Log_Pos	Relay_Master_Log_File	Slave_IO_Running	Slave_SQL_Running	Replicate_Do_DB	Replicate_Ignore_DB	Replicate_Do_Table	Replicate_Ignore_Table	Replicate_Wild_Do_Table	Replicate_Wild_Ignore_Table	Last_Errno	Last_Error	Skip_Counter	Exec_Master_Log_Pos	Relay_Log_Space	Until_Condition	Until_Log_File	Until_Log_Pos	Master_SSL_Allowed	Master_SSL_CA_File	Master_SSL_CA_Path	Master_SSL_Cert	Master_SSL_Cipher	Master_SSL_Key	Seconds_Behind_Master
> ! #	127.0.0.1	root	MASTER_PORT	1	master-bin.000001	50477	slave-relay-bin.000008	1283	master-bin.000001	Yes	Yes							0		0	50477	1220	None		0	No						#

Apparently the code counting Relay_Log_Space is wrong; it should never
be smaller than the length of the last relay log, whereas it is here:
1220 < 1283 !
This has happened several times already, so I'm filing a bug report so
that it does not get forgotten.

How to repeat:
could not.
[18 Jun 2005 2:50] MySQL Verification Team
Loading Standard Test Databases
Starting Tests

TEST                            RESULT
-------------------------------------------------------
rpl_max_relay_size             [ pass ]   
-------------------------------------------------------

Ending Tests
Shutting-down MySQL daemon

Master shutdown finished
Slave shutdown finished
All 1 tests were successful.