Bug #68600 master-info-repository variable is not read only

• Submitted: 7 Mar 2013 16:17
• Modified: 14 Mar 2013 12:34
• Reporter: Kolbe Kegel
• Status: Closed
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• Version: 5.6.10
• OS: Any
• Assigned to: Jon Stephens
• CPU Architecture: Any

[7 Mar 2013 16:17] Kolbe Kegel

Description:
http://dev.mysql.com/doc/refman/5.6/en/replication-options-slave.html#sysvar_master_info_r... claims that the master_info_repository "variable is read-only". This is not true in MySQL 5.6.10.

How to repeat:
set global master_info_repository='file';
set global master_info_repository='table';

mysql 5.6.10-log (root) [test]> select @@master_info_repository;
+--------------------------+
| @@master_info_repository |
+--------------------------+
| FILE                     |
+--------------------------+
1 row in set (0.00 sec)

mysql 5.6.10-log (root) [test]> set global master_info_repository='table';
Query OK, 0 rows affected (0.00 sec)

mysql 5.6.10-log (root) [test]>
[7]+  Stopped                 ./bin/mysql -S ./box2/mysql.sock

kolbe@prosimmon 5.6 $ ls ./box2/master.info
ls: ./box2/master.info: No such file or directory

kolbe@prosimmon 5.6 $ fg
./bin/mysql -S ./box2/mysql.sock

mysql 5.6.10-log (root) [test]> set global master_info_repository='file';
Query OK, 0 rows affected (0.01 sec)

mysql 5.6.10-log (root) [test]>
[7]+  Stopped                 ./bin/mysql -S ./box2/mysql.sock

kolbe@prosimmon 5.6 $ ls ./box2/master.info
./box2/master.info

Suggested fix:
Correct documentation to note that this variable is not read-only.

[8 Mar 2013 11:32] Erlend Dahl

Thank you for the bug report.

[13 Mar 2013 7:33] Jon Stephens

I don't believe the intention was for this to be settable at runtime, so it's a Server bug. Updated category accordingly.

[14 Mar 2013 12:34] Jon Stephens

Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.

[14 Mar 2013 12:35] Jon Stephens

Fixed in mysqldoc rev 34629.

Closed.