MySQL Bugs: #68485: relay-log-info-repository=TABLE option is not being picked up from options file

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:	None
Category:	MySQL Server: Replication	Severity:	S2 (Serious)
Version:	5.6.10	OS:	Windows (Server 2012)
Assigned to:		CPU Architecture:	Any
Tags:	logging, windows

Description:
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

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.

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?

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?

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".

It works now. Its just weird as I didn't really change anything and suddenly after the next restart it started working! Thanks