MySQL Bugs: #77206: "Neither --relay-log nor --relay-log-index were used" lacks gender-equality

Bug #77206	"Neither --relay-log nor --relay-log-index were used" lacks gender-equality
Submitted:	1 Jun 2015 10:44	Modified:	25 Dec 2016 12:13
Reporter:	Timothy Vaillancourt	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Errors	Severity:	S3 (Non-critical)
Version:	5.6.23	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
Hey guys,

I think MySQL is a great database server, and that it if it took the form of a human, it would be equally as awesome as a Male or Female. In fact, MySQL was originally named after a female, Monty's daughter My.

With this in mind, it may sound trivial but I'd like to see us modify the following warning below, discovered in 5.6.23 and likely all older releases. This warning refers to MySQL using the word "his", suggesting it is "Male". :)

TODAY: "[Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=691073-gosltmdb0779-relay-bin' to avoid this problem."

PROPOSED: "[Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has its hostname changed!! Please use '--relay-log=691073-gosltmdb0779-relay-bin' to avoid this problem."

Gender equality for all! :)

Cheers,

Tim

How to repeat:
1) Install 5.6.23 or possibly newer.
2) Setup server as a slave of another mysqld, without including the following in my.cnf: --relay-log AND --relay-log-index.
3) Restart mysqld.
4) Observe warning I refer to in the error log.

Suggested fix:
Change the warning to the following, or similar:

[Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has its hostname changed!! Please use '--relay-log=691073-gosltmdb0779-relay-bin' to avoid this problem."

Posted by developer:
 
Interestingly enough, there is one occurrence of "...acts as a slave and has his hostname changed" in sql/rpl_rli.cc, and another of "..acts as a master and has his hostname changed".

The former was introduced in 2010, the latter has been with us since 2005.

Posted by developer:
 
... the latter is in sql/mysqld.cc