Bug #21869 Rpl_recovery_rank: Remove variable without function
Submitted: 28 Aug 2006 13:49 Modified: 30 Oct 9:36
Reporter: Stefan Hinz
Status: Closed
Category:Server: Replication Severity:S3 (Non-critical)
Version:all OS:Any (all)
Assigned to: Zhenxing He Target Version:
Triage: Triaged: D4 (Minor)

[28 Aug 2006 13: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 16:48] Lars Thalmann 
To be fixed in 5.1.
[4 Sep 2006 16: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 5: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 9:36] Zhenxing He 
Fixed by bug#13963