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 Email Updates:
Status: Closed Impact on me:
None 
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.