Bug #68485 relay-log-info-repository=TABLE option is not being picked up from options file
Submitted: 25 Feb 2013 14:24 Modified: 16 Apr 2013 6:06
Reporter: Salman Akram Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Replication Severity:S2 (Serious)
Version:5.6.10 OS:Windows (Server 2012)
Assigned to: CPU Architecture:Any
Tags: logging, windows

[25 Feb 2013 14:24] Salman Akram
I am trying to set relay-log-info-repository=TABLE option in my.ini on Windows Server 2012. However, MySQL is not picking up this option and still shows FILE against this value.

When I try to do it from MySQL client using following statement it works fine:

SET @@global.relay_log_info_repository = 'TABLE';

What I am concerned is that after MySQL restart it will again switch back to FILE logging and can corrupt replication data. Any idea what's going on?

How to repeat:
1- set relay-log-info-repository=TABLE in my.ini
2- restart MySQL
3- Server variables still show FILE for this variable
[25 Feb 2013 18:47] MySQL Verification Team
It works for me when I tested it.  My only thought is that either the setting is in the wrong section of my.ini, there are multiple settings and mysqld takes the last one, or the my.ini is not being read at all.
[26 Feb 2013 3:46] Salman Akram
Initially I thought so but unfortunately none of the 3 options are true. All other settings on my.ini are being picked up and are under mysqld section and in fact below two lines are together:

master-info-repository = TABLE
relay-log-info-repository = TABLE

Master Info properly switches to a TABLE and FILE on changing the setting but no effect on Relay log. Any other suggestions?
[15 Mar 2013 12:35] MySQL Verification Team
if this is still an issue, please upload the exact my.ini here.  Maybe the previous option is wrong, or there are stray non-printable characters affecting the reading of my.ini?
[16 Apr 2013 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[16 Apr 2013 6:06] Salman Akram
It works now. Its just weird as I didn't really change anything and suddenly after the next restart it started working! Thanks