Start slave creates master.info file

[monty solomon]

Executing the statement "start slave" on a master server erroneously creates a master.info file.

[monty solomon (monty+launchpad)]

# ls
heartbeat mysql.sock performance_schema test
ibdata1 mysql_upgrade_info RPM_UPGRADE_HISTORY
mysql percona RPM_UPGRADE_MARKER-LAST

# service mysql restart ; mysql -uroot -e "start slave"
Shutting down MySQL (Percona Server)....... [ OK ]
Starting MySQL (Percona Server)........ [ OK ]
ERROR 1200 (HY000) at line 1: The server is not configured as slave; fix in config file or with CHANGE MASTER TO

# ls
heartbeat mysql percona RPM_UPGRADE_MARKER-LAST
ibdata1 mysql.sock performance_schema test
master.info mysql_upgrade_info RPM_UPGRADE_HISTORY

[monty solomon (monty+launchpad)]

Server version: 5.5.34-32.0-log Percona Server (GPL), Release rel32.0, Revision 591

CentOS release 6.3 (Final)

Linux 2.6.32-279.19.1.el6.x86_64 #1 SMP Wed Dec 19 07:05:20 UTC 2012 x86_64 x86_64 x86_64 GNU/Linux

[monty solomon (monty+launchpad)]

my.cnf contains

binlog-format = MIXED
sync_binlog = 1
sync_master_info = 10000
sync_relay_log = 10000
sync_relay_log_info = 10000

[Valerii Kravchuk (valerii-kravchuk)]

First of all, the file is indeed created, this is easy to check. It's the same with upstream MySQL on Windows, for example. I do not see this explicitly documented in the manual:

http://dev.mysql.com/doc/refman/5.5/en/start-slave.html
http://dev.mysql.com/doc/refman/5.5/en/slave-logs-status.html

so I am going to create an upstream MySQL bug report for this. Stay tuned.

[Valerii Kravchuk (valerii-kravchuk)]

That's what happens:

[openxs@chief p5.5]$ ls data
chief.err ibdata1 ib_logfile1 performance_schema
chief.pid ib_logfile0 mysql test
[openxs@chief p5.5]$ ls -l data
total 28696
-rw-r----- 1 openxs openxs 4313 Dec 10 10:39 chief.err
-rw-rw---- 1 openxs openxs 5 Dec 10 10:39 chief.pid
-rw-rw---- 1 openxs openxs 18874368 Oct 4 13:14 ibdata1
-rw-rw---- 1 openxs openxs 5242880 Dec 10 10:39 ib_logfile0
-rw-rw---- 1 openxs openxs 5242880 Oct 2 08:40 ib_logfile1
drwx------ 2 openxs openxs 4096 Oct 2 08:39 mysql
drwx------ 2 openxs openxs 4096 Oct 2 08:39 performance_schema
drwx------ 2 openxs openxs 4096 Oct 4 13:14 test
[openxs@chief p5.5]$ bin/mysql --no-defaults -uroot test
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.5.32 MySQL Community Server (GPL)

Copyright (c) 2009-2013 Percona Ireland Ltd.
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> start slave;
ERROR 1200 (HY000): The server is not configured as slave; fix in config file or with CHANGE MASTER TO
mysql> exit
Bye
[openxs@chief p5.5]$ ls -l data
total 28712
-rw-r----- 1 openxs openxs 4551 Dec 10 10:40 chief.err
-rw-rw---- 1 openxs openxs 5 Dec 10 10:39 chief.pid
-rw-rw---- 1 openxs openxs 107 Dec 10 10:40 chief-relay-bin.000001
-rw-rw---- 1 openxs openxs 25 Dec 10 10:40 chief-relay-bin.index
-rw-rw---- 1 openxs openxs 18874368 Oct 4 13:14 ibdata1
-rw-rw---- 1 openxs openxs 5242880 Dec 10 10:39 ib_logfile0
-rw-rw---- 1 openxs openxs 5242880 Oct 2 08:40 ib_logfile1
-rw-rw---- 1 openxs openxs 38 Dec 10 10:40 master.info
drwx------ 2 openxs openxs 4096 Oct 2 08:39 mysql
drwx------ 2 openxs openxs 4096 Oct 2 08:39 performance_schema
-rw-rw---- 1 openxs openxs 30 Dec 10 10:40 relay-log.info
drwx------ 2 openxs openxs 4096 Oct 4 13:14 test

[Valerii Kravchuk (valerii-kravchuk)]

Here is my upstream bug report:

http://bugs.mysql.com/bug.php?id=71123

Please, check if I missed something there.

[monty solomon (monty+launchpad)]

Looks good.

Thanks.

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-2051