Bug #21869 Rpl_recovery_rank: Remove variable without function

• Submitted: 28 Aug 2006 11:49
• Modified: 30 Oct 2009 8:36
• Reporter: Stefan Hinz
• Status: Closed
• 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