Bug #21869 Rpl_recovery_rank: Remove variable without function
Submitted: 28 Aug 2006 11:49 Modified: 30 Oct 2009 8:36
Reporter: Stefan Hinz Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Replication Severity:S3 (Non-critical)
Version:all OS:Any (all)
Assigned to: Zhenxing He CPU Architecture:Any

[28 Aug 2006 11:49] Stefan Hinz
Description:
There's a server system variable that doesn't have a function because the planned functionality was never implemented (Mats/Flupps/Stefan on the dev channel, Aug 28). It shows with two SQL statements:
mysql> show slave hosts;
+------------+-----------+------+-------------------+-----------+
| Server_id  | Host      | Port | Rpl_recovery_rank | Master_id |
+------------+-----------+------+-------------------+-----------+
|  192168010 | iconnect2 | 3306 |                 0 | 192168011 |
| 1921680101 | athena    | 3306 |                 0 | 192168011 |
+------------+-----------+------+-------------------+-----------+
2 rows in set (0.00 sec)
mysql> show slave hosts;
+------------+-----------+------+-------------------+-----------+
| Server_id  | Host      | Port | Rpl_recovery_rank | Master_id |
+------------+-----------+------+-------------------+-----------+
|  192168010 | iconnect2 | 3306 |                 0 | 192168011 |
| 1921680101 | athena    | 3306 |                 0 | 192168011 |
+------------+-----------+------+-------------------+-----------+
2 rows in set (0.00 sec)
mysql> show variables like 'Rpl_recovery_rank';
+-------------------+-------+
| Variable_name     | Value |
+-------------------+-------+
| rpl_recovery_rank | 0     |
+-------------------+-------+
1 row in set (0.00 sec)

There's no functionality planned any more, so that variable should be removed.

How to repeat:
See description about those two SQL statements.

Suggested fix:
Remove the Rpl_recovery_rank variable.
[1 Sep 2006 14:48] Lars Thalmann
To be fixed in 5.1.
[4 Sep 2006 14:55] Rafal Somla
Seems that the variable is used in repl_failsafe.cc function update_slave_list(). Don't know if it is important.
[31 Jan 2007 4:12] Rafal Somla
I created a patch removing the variable but come across problems when testing. Because of higher priority bugs I can't work on it now.
[30 Oct 2009 8:36] Zhenxing He
Fixed by bug#13963