[MDEV-8596] Detect conflicts between file name settings of similarly named variables - JIRA

Details

Type: Task
Status: Open
Priority: Minor
Resolution: Unresolved
Fix Version/s: 10.1
Component/s: Replication
Labels:
- replication

Description

root@db2:~# ls -la /srv/mysqllog/ /srv/mysqldata/
/srv/mysqldata/:
total 280764
drwxr-xr-x 6 mysql root      4096 Aug 10 07:22 .
drwxr-xr-x 4 root  root      4096 Jul 31 07:30 ..
-rw-rw---- 1 mysql mysql    16384 Aug 10 07:19 aria_log.00000001
-rw-rw---- 1 mysql mysql       52 Aug 10 07:19 aria_log_control
-rw-rw---- 1 mysql mysql    13033 Aug 10 07:19 ib_buffer_pool
-rw-rw---- 1 mysql mysql 77594624 Aug 10 07:21 ibdata1
drwx------ 2 mysql mysql    40960 Aug  9 11:56 ibis
-rw-rw---- 1 mysql mysql 52428800 Aug 10 07:21 ib_logfile0
-rw-rw---- 1 mysql mysql 52428800 Aug  9 23:36 ib_logfile1
-rw-rw---- 1 mysql mysql 52428800 Aug  9 23:56 ib_logfile2
-rw-rw---- 1 mysql mysql 52428800 Aug 10 00:08 ib_logfile3
-rw-rw---- 1 mysql mysql        0 Aug 10 07:22 master.info
-rw-rw---- 1 mysql mysql        0 Aug 10 06:57 multi-master.info
drwx------ 2 mysql root      4096 Aug  9 07:48 mysql
-rw------- 1 root  root        15 Aug  9 07:48 mysql_upgrade_info
drwx------ 2 mysql mysql     4096 Aug 10 06:48 performance_schema
-rw-rw---- 1 mysql mysql    59086 Aug 10 07:22 sql_errors.log
drwx------ 2 mysql mysql     8192 Aug  1 03:24 sys

/srv/mysqllog/:
total 24
drwxr-xr-x 2 mysql mysql  139 Aug 10 07:22 .
drwxr-xr-x 4 root  root  4096 Jul 31 07:30 ..
-rw-rw---- 1 mysql mysql  359 Aug 10 07:21 mariadb-bin.000001
-rw-rw---- 1 mysql mysql  355 Aug 10 07:21 mariadb-bin.000002
-rw-rw---- 1 mysql mysql   66 Aug 10 07:21 mariadb-bin.index
-rw-rw---- 1 mysql mysql  267 Aug 10 07:22 mysqld-relay-bin.000001
-rw-rw---- 1 mysql mysql   38 Aug 10 07:22 mysqld-relay-bin.index

MariaDB [(none)]> reset slave all; reset master;flush logs;   
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.01 sec)

Query OK, 0 rows affected (0.00 sec)

root@db2:~# ls -la /srv/mysqllog/ /srv/mysqldata/
/srv/mysqldata/:
total 280764
drwxr-xr-x 6 mysql root      4096 Aug 10 07:23 .
drwxr-xr-x 4 root  root      4096 Jul 31 07:30 ..
-rw-rw---- 1 mysql mysql    16384 Aug 10 07:19 aria_log.00000001
-rw-rw---- 1 mysql mysql       52 Aug 10 07:19 aria_log_control
-rw-rw---- 1 mysql mysql    13033 Aug 10 07:19 ib_buffer_pool
-rw-rw---- 1 mysql mysql 77594624 Aug 10 07:21 ibdata1
drwx------ 2 mysql mysql    40960 Aug  9 11:56 ibis
-rw-rw---- 1 mysql mysql 52428800 Aug 10 07:21 ib_logfile0
-rw-rw---- 1 mysql mysql 52428800 Aug  9 23:36 ib_logfile1
-rw-rw---- 1 mysql mysql 52428800 Aug  9 23:56 ib_logfile2
-rw-rw---- 1 mysql mysql 52428800 Aug 10 00:08 ib_logfile3
-rw-rw---- 1 mysql mysql        0 Aug 10 06:57 multi-master.info
drwx------ 2 mysql root      4096 Aug  9 07:48 mysql
-rw------- 1 root  root        15 Aug  9 07:48 mysql_upgrade_info
drwx------ 2 mysql mysql     4096 Aug 10 06:48 performance_schema
-rw-rw---- 1 mysql mysql    59086 Aug 10 07:22 sql_errors.log
drwx------ 2 mysql mysql     8192 Aug  1 03:24 sys

/srv/mysqllog/:
total 20
drwxr-xr-x 2 mysql mysql  110 Aug 10 07:23 .
drwxr-xr-x 4 root  root  4096 Jul 31 07:30 ..
-rw-rw---- 1 mysql mysql  359 Aug 10 07:23 mariadb-bin.000001
-rw-rw---- 1 mysql mysql  355 Aug 10 07:23 mariadb-bin.000002
-rw-rw---- 1 mysql mysql   66 Aug 10 07:23 mariadb-bin.index
-rw-rw---- 1 mysql mysql  267 Aug 10 07:22 mysqld-relay-bin.000001

mysqld-relay-bin.000001 left over - delete manually

root@db2:~# rm /srv/mysqllog/mysqld-relay-bin.000001


MariaDB [(none)]>  change master to master_host='172.31.2.235',master_user='repl',master_password='XXXXXX',master_log_file='mysql-bin.008137', master_log_pos=187008516;
ERROR 1201 (HY000): Could not initialize master info structure for ''; more error messages can be found in the MariaDB error log

root@db2:~# ls -la /srv/mysqllog/ /srv/mysqldata/
/srv/mysqldata/:
total 280764
drwxr-xr-x 6 mysql root      4096 Aug 10 07:25 .
drwxr-xr-x 4 root  root      4096 Jul 31 07:30 ..
-rw-rw---- 1 mysql mysql    16384 Aug 10 07:19 aria_log.00000001
-rw-rw---- 1 mysql mysql       52 Aug 10 07:19 aria_log_control
-rw-rw---- 1 mysql mysql    13033 Aug 10 07:19 ib_buffer_pool
-rw-rw---- 1 mysql mysql 77594624 Aug 10 07:21 ibdata1
drwx------ 2 mysql mysql    40960 Aug  9 11:56 ibis
-rw-rw---- 1 mysql mysql 52428800 Aug 10 07:21 ib_logfile0
-rw-rw---- 1 mysql mysql 52428800 Aug  9 23:36 ib_logfile1
-rw-rw---- 1 mysql mysql 52428800 Aug  9 23:56 ib_logfile2
-rw-rw---- 1 mysql mysql 52428800 Aug 10 00:08 ib_logfile3
-rw-rw---- 1 mysql mysql        0 Aug 10 07:25 master.info
-rw-rw---- 1 mysql mysql        0 Aug 10 06:57 multi-master.info
drwx------ 2 mysql root      4096 Aug  9 07:48 mysql
-rw------- 1 root  root        15 Aug  9 07:48 mysql_upgrade_info
drwx------ 2 mysql mysql     4096 Aug 10 06:48 performance_schema
-rw-rw---- 1 mysql mysql    59413 Aug 10 07:25 sql_errors.log
drwx------ 2 mysql mysql     8192 Aug  1 03:24 sys

/srv/mysqllog/:
total 24
drwxr-xr-x 2 mysql mysql  139 Aug 10 07:25 .
drwxr-xr-x 4 root  root  4096 Jul 31 07:30 ..
-rw-rw---- 1 mysql mysql  359 Aug 10 07:23 mariadb-bin.000001
-rw-rw---- 1 mysql mysql  355 Aug 10 07:23 mariadb-bin.000002
-rw-rw---- 1 mysql mysql   66 Aug 10 07:23 mariadb-bin.index
-rw-rw---- 1 mysql mysql  267 Aug 10 07:25 mysqld-relay-bin.000001
-rw-rw---- 1 mysql mysql   38 Aug 10 07:25 mysqld-relay-bin.index

Aug 10 07:25:02 db2 mysqld: 150810  7:25:02 [Note] Master: ''  Master_info_file: 'master.info'  Relay_info_file: '/srv/mysqllog/mysqld-relay-bin.index'
Aug 10 07:25:02 db2 mysqld: 150810  7:25:02 [ERROR] Error reading slave log configuration

root@db2:~# ls -la /srv/mysqllog/ /srv/mysqldata/
/srv/mysqldata/:
total 280764
drwxr-xr-x 6 mysql root      4096 Aug 10 07:26 .
drwxr-xr-x 4 root  root      4096 Jul 31 07:30 ..
-rw-rw---- 1 mysql mysql    16384 Aug 10 07:26 aria_log.00000001
-rw-rw---- 1 mysql mysql       52 Aug 10 07:26 aria_log_control
-rw-rw---- 1 mysql mysql    13033 Aug 10 07:26 ib_buffer_pool
-rw-rw---- 1 mysql mysql 77594624 Aug 10 07:26 ibdata1
drwx------ 2 mysql mysql    40960 Aug  9 11:56 ibis
-rw-rw---- 1 mysql mysql 52428800 Aug 10 07:26 ib_logfile0
-rw-rw---- 1 mysql mysql 52428800 Aug  9 23:36 ib_logfile1
-rw-rw---- 1 mysql mysql 52428800 Aug  9 23:56 ib_logfile2
-rw-rw---- 1 mysql mysql 52428800 Aug 10 00:08 ib_logfile3
-rw-rw---- 1 mysql mysql        0 Aug 10 07:25 master.info
-rw-rw---- 1 mysql mysql        0 Aug 10 06:57 multi-master.info
drwx------ 2 mysql root      4096 Aug  9 07:48 mysql
-rw------- 1 root  root        15 Aug  9 07:48 mysql_upgrade_info
drwx------ 2 mysql mysql     4096 Aug 10 06:48 performance_schema
-rw-rw---- 1 mysql mysql    59523 Aug 10 07:26 sql_errors.log
drwx------ 2 mysql mysql     8192 Aug  1 03:24 sys

/srv/mysqllog/:
total 28
drwxr-xr-x 2 mysql mysql 4096 Aug 10 07:26 .
drwxr-xr-x 4 root  root  4096 Jul 31 07:30 ..
-rw-rw---- 1 mysql mysql  359 Aug 10 07:23 mariadb-bin.000001
-rw-rw---- 1 mysql mysql  374 Aug 10 07:26 mariadb-bin.000002
-rw-rw---- 1 mysql mysql   66 Aug 10 07:23 mariadb-bin.index
-rw-rw---- 1 mysql mysql    0 Aug 10 07:26 mariadb-bin.state
-rw-rw---- 1 mysql mysql  267 Aug 10 07:25 mysqld-relay-bin.000001
-rw-rw---- 1 mysql mysql   38 Aug 10 07:25 mysqld-relay-bin.index
root@db2:~# rm /srv/mysqllog/mysqld-relay-bin*
root@db2:~# service mysql  start
 * Starting MariaDB database server mysqld                                                                                                                  [ OK ] 
 * Checking for corrupt, not cleanly closed and upgrade needing tables.

root@db2:~# ls -la /srv/mysqllog/ /srv/mysqldata/
/srv/mysqldata/:
total 280764
drwxr-xr-x 6 mysql root      4096 Aug 10 07:26 .
drwxr-xr-x 4 root  root      4096 Jul 31 07:30 ..
-rw-rw---- 1 mysql mysql    16384 Aug 10 07:26 aria_log.00000001
-rw-rw---- 1 mysql mysql       52 Aug 10 07:26 aria_log_control
-rw-rw---- 1 mysql mysql    13033 Aug 10 07:26 ib_buffer_pool
-rw-rw---- 1 mysql mysql 77594624 Aug 10 07:26 ibdata1
drwx------ 2 mysql mysql    40960 Aug  9 11:56 ibis
-rw-rw---- 1 mysql mysql 52428800 Aug 10 07:26 ib_logfile0
-rw-rw---- 1 mysql mysql 52428800 Aug  9 23:36 ib_logfile1
-rw-rw---- 1 mysql mysql 52428800 Aug  9 23:56 ib_logfile2
-rw-rw---- 1 mysql mysql 52428800 Aug 10 00:08 ib_logfile3
-rw-rw---- 1 mysql mysql        0 Aug 10 07:25 master.info
-rw-rw---- 1 mysql mysql        0 Aug 10 06:57 multi-master.info
drwx------ 2 mysql root      4096 Aug  9 07:48 mysql
-rw------- 1 root  root        15 Aug  9 07:48 mysql_upgrade_info
drwx------ 2 mysql mysql     4096 Aug 10 06:48 performance_schema
-rw-rw---- 1 mysql mysql    59523 Aug 10 07:26 sql_errors.log
drwx------ 2 mysql mysql     8192 Aug  1 03:24 sys

/srv/mysqllog/:
total 20
drwxr-xr-x 2 mysql mysql  105 Aug 10 07:26 .
drwxr-xr-x 4 root  root  4096 Jul 31 07:30 ..
-rw-rw---- 1 mysql mysql  359 Aug 10 07:23 mariadb-bin.000001
-rw-rw---- 1 mysql mysql  374 Aug 10 07:26 mariadb-bin.000002
-rw-rw---- 1 mysql mysql  314 Aug 10 07:26 mariadb-bin.000003
-rw-rw---- 1 mysql mysql   99 Aug 10 07:26 mariadb-bin.index

MariaDB [(none)]>  change master to master_host='172.31.2.235',master_user='repl',master_password='d5lganeOQo/x4gt',master_log_file='mysql-bin.008137', master_log_pos=187008516;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    33  
Current database: *** NONE ***

ERROR 1201 (HY000): Could not initialize master info structure for ''; more error messages can be found in the MariaDB error log  

Aug 10 07:27:14 db2 mysqld: 150810  7:27:14 [Note] Master: ''  Master_info_file: 'master.info'  Relay_info_file: '/srv/mysqllog/mysqld-relay-bin.index'
Aug 10 07:27:14 db2 mysqld: 150810  7:27:14 [ERROR] Error reading master configuration

root@db2:~# service mysql  stop
 * Stopping MariaDB database server mysqld                                                                                                                  [ OK ] 
root@db2:~# ls -la /srv/mysqllog/ /srv/mysqldata/
/srv/mysqldata/:
total 280764
drwxr-xr-x 6 mysql root      4096 Aug 10 07:28 .
drwxr-xr-x 4 root  root      4096 Jul 31 07:30 ..
-rw-rw---- 1 mysql mysql    16384 Aug 10 07:28 aria_log.00000001
-rw-rw---- 1 mysql mysql       52 Aug 10 07:28 aria_log_control
-rw-rw---- 1 mysql mysql    13033 Aug 10 07:28 ib_buffer_pool
-rw-rw---- 1 mysql mysql 77594624 Aug 10 07:28 ibdata1
drwx------ 2 mysql mysql    40960 Aug  9 11:56 ibis
-rw-rw---- 1 mysql mysql 52428800 Aug 10 07:28 ib_logfile0
-rw-rw---- 1 mysql mysql 52428800 Aug  9 23:36 ib_logfile1
-rw-rw---- 1 mysql mysql 52428800 Aug  9 23:56 ib_logfile2
-rw-rw---- 1 mysql mysql 52428800 Aug 10 00:08 ib_logfile3
-rw-rw---- 1 mysql mysql        0 Aug 10 07:25 master.info
-rw-rw---- 1 mysql mysql        0 Aug 10 06:57 multi-master.info
drwx------ 2 mysql root      4096 Aug  9 07:48 mysql
-rw------- 1 root  root        15 Aug  9 07:48 mysql_upgrade_info
drwx------ 2 mysql mysql     4096 Aug 10 06:48 performance_schema
-rw-rw---- 1 mysql mysql    59960 Aug 10 07:28 sql_errors.log
drwx------ 2 mysql mysql     8192 Aug  1 03:24 sys

/srv/mysqllog/:
total 20
drwxr-xr-x 2 mysql mysql  129 Aug 10 07:28 .
drwxr-xr-x 4 root  root  4096 Jul 31 07:30 ..
-rw-rw---- 1 mysql mysql  359 Aug 10 07:23 mariadb-bin.000001
-rw-rw---- 1 mysql mysql  374 Aug 10 07:26 mariadb-bin.000002
-rw-rw---- 1 mysql mysql  333 Aug 10 07:28 mariadb-bin.000003
-rw-rw---- 1 mysql mysql   99 Aug 10 07:26 mariadb-bin.index
-rw-rw---- 1 mysql mysql    0 Aug 10 07:28 mariadb-bin.state

root@db2:~# rm /srv/mysqldata/master.info /srv/mysqldata/multi-master.info
root@db2:~# strace  -f -s 99 -o /tmp/xxx service mysql restart

root@db2:~# ls -la /srv/mysql*
/srv/mysqldata:
total 280764
drwxr-xr-x 6 mysql root      4096 Aug 10 07:29 .
drwxr-xr-x 4 root  root      4096 Jul 31 07:30 ..
-rw-rw---- 1 mysql mysql    16384 Aug 10 07:28 aria_log.00000001
-rw-rw---- 1 mysql mysql       52 Aug 10 07:28 aria_log_control
-rw-rw---- 1 mysql mysql    13033 Aug 10 07:28 ib_buffer_pool
-rw-rw---- 1 mysql mysql 77594624 Aug 10 07:29 ibdata1
drwx------ 2 mysql mysql    40960 Aug  9 11:56 ibis
-rw-rw---- 1 mysql mysql 52428800 Aug 10 07:29 ib_logfile0
-rw-rw---- 1 mysql mysql 52428800 Aug  9 23:36 ib_logfile1
-rw-rw---- 1 mysql mysql 52428800 Aug  9 23:56 ib_logfile2
-rw-rw---- 1 mysql mysql 52428800 Aug 10 00:08 ib_logfile3
-rw-rw---- 1 mysql mysql        0 Aug 10 07:29 multi-master.info
drwx------ 2 mysql root      4096 Aug  9 07:48 mysql
-rw------- 1 root  root        15 Aug  9 07:48 mysql_upgrade_info
drwx------ 2 mysql mysql     4096 Aug 10 06:48 performance_schema
-rw-rw---- 1 mysql mysql    59960 Aug 10 07:28 sql_errors.log
drwx------ 2 mysql mysql     8192 Aug  1 03:24 sys

/srv/mysqllog:
total 24
drwxr-xr-x 2 mysql mysql  130 Aug 10 07:29 .
drwxr-xr-x 4 root  root  4096 Jul 31 07:30 ..
-rw-rw---- 1 mysql mysql  359 Aug 10 07:23 mariadb-bin.000001
-rw-rw---- 1 mysql mysql  374 Aug 10 07:26 mariadb-bin.000002
-rw-rw---- 1 mysql mysql  333 Aug 10 07:28 mariadb-bin.000003
-rw-rw---- 1 mysql mysql  314 Aug 10 07:29 mariadb-bin.000004
-rw-rw---- 1 mysql mysql  132 Aug 10 07:29 mariadb-bin.index

MariaDB [(none)]>  change master to master_host='172.31.2.235',master_user='repl',master_password='XXXXX',master_log_file='mysql-bin.008137', master_log_pos=187008516;
ERROR 1201 (HY000): Could not initialize master info structure for ''; more error messages can be found in the MariaDB error log

Aug 10 07:30:36 db2 mysqld: 150810  7:30:36 [Note] Master: ''  Master_info_file: 'master.info'  Relay_info_file: '/srv/mysqllog/mysqld-relay-bin.index'
Aug 10 07:30:36 db2 mysqld: 150810  7:30:36 [ERROR] Error reading slave log configuration


3877  recvfrom(96, "\3change master to master_host='172.31.2.235',master_user='repl',master_password='XXXXXX',m"..., 158, MSG_DONTWAIT, NULL, NULL) = 158  
3877  clock_gettime(CLOCK_REALTIME, {1439191836, 626147729}) = 0  
3877  clock_gettime(CLOCK_MONOTONIC, {12967, 357213393}) = 0  
3877  clock_gettime(CLOCK_REALTIME, {1439191836, 626294479}) = 0  
3877  clock_gettime(CLOCK_REALTIME, {1439191836, 626407638}) = 0  
3877  write(2, "150810  7:30:36 [Note] Master: ''  Master_info_file: 'master.info'  Relay_info_file: '/srv/mysqllog"..., 124) = 124  
3840  <... read resumed> "150810  7:30:36 [Note] Master: ''  Master_info_file: 'master.info'  Relay_info_file: '/srv/mysqllog"..., 4096) = 124  
3877  getcwd("/srv/mysqldata", 4096)    = 15  
3840  sendto(1, "<27>Aug 10 07:30:36 mysqld: 150810  7:30:36 [Note] Master: ''  Master_info_file: 'master.info'  Rel"..., 151, MSG_NOSIGNAL, NULL, 0 <unfinished ...> 
3877  lstat("/srv/mysqldata/master.info", 0x7f7975b98dc0) = -1 ENOENT (No such file or directory)
3840  <... sendto resumed> )            = 151
3877  access("/srv/mysqldata/master.info", F_OK <unfinished ...>
3840  read(0,  <unfinished ...>
3877  <... access resumed> )            = -1 ENOENT (No such file or directory)
3877  open("/srv/mysqldata/master.info", O_RDWR|O_CREAT, 0660) = 128
3877  lstat("/srv", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
3877  lstat("/srv/mysqldata", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
3877  lseek(128, 0, SEEK_CUR)           = 0
3877  lseek(128, 0, SEEK_END)           = 0  
3877  lstat("/srv", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
3877  lstat("/srv/mysqllog", {st_mode=S_IFDIR|0755, st_size=130, ...}) = 0
3877  lstat("/srv/mysqllog/mysqld-relay-bin.index", 0x7f7975b98230) = -1 ENOENT (No such file or directory)
3877  lstat("/tmp", {st_mode=S_IFDIR|S_ISVTX|0777, st_size=4096, ...}) = 0
3877  lstat("/tmp", {st_mode=S_IFDIR|S_ISVTX|0777, st_size=4096, ...}) = 0  
3877  lstat("/tmp/SQL_LOAD-", 0x7f7975b98230) = -1 ENOENT (No such file or directory)
3877  open("/srv/mysqllog/mysqld-relay-bin.index", O_RDWR|O_CREAT, 0660) = 129
3877  lstat("/srv", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
3877  lstat("/srv/mysqllog", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
3877  fdatasync(129)                    = 0
3877  lseek(129, 0, SEEK_END)           = 0  
3877  lseek(129, 0, SEEK_CUR)           = 0  
3877  open("/srv/mysqllog/mysqld-relay-bin.~rec~", O_RDWR|O_CREAT, 0660) = 130
3877  lseek(130, 0, SEEK_CUR)           = 0
3877  lseek(130, 0, SEEK_END)           = 0  
3877  close(130)                        = 0  
3877  unlink("/srv/mysqllog/mysqld-relay-bin.~rec~") = 0
3877  openat(AT_FDCWD, "/srv/mysqllog/", O_RDONLY|O_NONBLOCK|O_DIRECTORY|O_CLOEXEC) = 130
3877  getdents(130, /* 8 entries */, 32768) = 296
3877  getdents(130, /* 0 entries */, 32768) = 0
3877  close(130)                        = 0
3877  unlink("/srv/mysqllog/mysqld-relay-bin.~rec~") = -1 ENOENT (No such file or directory)
3877  open("/srv/mysqllog/mysqld-relay-bin.~rec~", O_RDWR|O_CREAT, 0660) = 130
3877  lseek(130, 0, SEEK_CUR)           = 0
3877  write(130, "/srv/mysqllog/mysqld-relay-bin.000001\n", 38) = 38
3877  fsync(130)                        = 0
3877  openat(AT_FDCWD, "/srv/mysqllog/", O_RDONLY|O_NONBLOCK|O_DIRECTORY|O_CLOEXEC) = 131
3877  getdents(131, /* 9 entries */, 32768) = 344
3877  getdents(131, /* 0 entries */, 32768) = 0
3877  close(131)                        = 0
3877  stat("/srv/mysqllog/mysqld-relay-bin.000001", 0x7f7975b98fc0) = -1 ENOENT (No such file or directory)
3877  open("/srv/mysqllog/mysqld-relay-bin.000001", O_RDWR|O_CREAT|O_APPEND, 0660) = 131
3877  lstat("/srv", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
3877  lstat("/srv/mysqllog", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
3877  lseek(131, 0, SEEK_CUR)           = 0
3877  lseek(131, 0, SEEK_CUR)           = 0
3877  lseek(131, 0, SEEK_END)           = 0
3877  lseek(131, 0, SEEK_END)           = 0
3877  write(131, "\376bin\34S\310U\17\n\0\0\0\364\0\0\0\370\0\0\0\0\0\4\00010.0.21-MariaDB-1~trusty-log\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0238\r\0\10\0\22\0\4\4\4\4\22\0\0\334\0\4\32\10"..., 248) = 248 
3877  fsync(131)                        = 0
3877  write(129, "/srv/mysqllog/mysqld-relay-bin.000001\n", 38) = 38
3877  fsync(129)                        = 0
3877  close(130)                        = 0
3877  unlink("/srv/mysqllog/mysqld-relay-bin.~rec~") = 0
3877  access("/srv/mysqllog/mysqld-relay-bin.index", F_OK) = 0
3877  open("/srv/mysqllog/mysqld-relay-bin.index", O_RDWR) = 130
3877  lstat("/srv", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
3877  lstat("/srv/mysqllog", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
3877  lseek(130, 0, SEEK_CUR)           = 0
3877  lseek(130, 0, SEEK_END)           = 38
3877  lseek(130, 0, SEEK_SET)           = 0
3877  read(130, "/srv/mysqllog/mysqld-relay-bin.000001\n", 38) = 38
3877  clock_gettime(CLOCK_REALTIME, {1439191836, 635007726}) = 0
3877  write(2, "150810  7:30:36 [ERROR] Error reading slave log configuration\n", 62) = 62
3840  <... read resumed> "150810  7:30:36 [ERROR] Error reading slave log configuration\n", 4096) = 62
3877  close(130 <unfinished ...>
3840  sendto(1, "<27>Aug 10 07:30:36 mysqld: 150810  7:30:36 [ERROR] Error reading slave log configuration", 89, MSG_NOSIGNAL, NULL, 0 <unfinished ...>
3877  <... close resumed> )             = 0
3840  <... sendto resumed> )            = 89
3840  read(0,  <unfinished ...>
3877  write(131, "\34S\310U\3\n\0\0\0\23\0\0\0\v\1\0\0\0\0", 19) = 19
3877  fdatasync(131)                    = 0
3877  close(131)                        = 0
3877  close(129)                        = 0
3877  close(128)                        = 0
3877  clock_gettime(CLOCK_REALTIME, {1439191836, 636955514}) = 0
3877  lseek(25, 0, SEEK_CUR)            = 0
3877  write(25, "2015-08-10  7:30:36 root[root] @ localhost [] ERROR 1201: Could not initialize master info structur"..., 327) = 327
3877  clock_gettime(CLOCK_MONOTONIC, {12967, 368273858}) = 0
3877  sendto(96, "u\0\0\1\377\261\4#HY000Could not initialize master info structure for ''; more error messages can be found in"..., 121, MSG_DONTWAIT, NULL, 0) = 121

Gliffy Diagrams

Attachments

Issue Links

relates to

MDEV-7416 Using named slaves; 'empty' mysql-relay-bin.xxx logs are not removed

Open

Activity

Ascending order - Click to sort in descending order

Hide

Permalink

Daniel Black added a comment - 2015-08-11 14:37 - edited

after removing relay_log_info_file = /srv/mysqllog/mysqld-relay-bin.index from my configuration file the replication was able to be created.

rest of configuration - as per ~~MDEV-8595~~

so moral of the day - relay_log_info_file is very different from relay_log_index and if you set relay_log_info_file to the default of relay_log_index you will get this error and be very confused.

Show

Daniel Black added a comment - 2015-08-11 14:37 - edited after removing relay_log_info_file = /srv/mysqllog/mysqld-relay-bin.index from my configuration file the replication was able to be created. rest of configuration - as per MDEV-8595 so moral of the day - relay_log_info_file is very different from relay_log_index and if you set relay_log_info_file to the default of relay_log_index you will get this error and be very confused.

Hide

Permalink

Elena Stepanova added a comment - 2015-08-11 18:18

Well, these are two different files and different options, and I imagine overriding one with another can cause any kind of mess, the variation depends on what was overridden by what, and what the server wanted to read. Do you expect to work any different?

Show

Elena Stepanova added a comment - 2015-08-11 18:18 Well, these are two different files and different options, and I imagine overriding one with another can cause any kind of mess, the variation depends on what was overridden by what, and what the server wanted to read. Do you expect to work any different?

Hide

Permalink

Daniel Black added a comment - 2015-08-12 01:30

The mess was expected in hind sight. It was just a bit hard (or I was having an off moment) to identify the cause in hindsight. MDEV-8594 covers some of the error messages however for expectations, can this be a minor feature request to detect when file name settings of similar named variables conflict.

Show

Daniel Black added a comment - 2015-08-12 01:30 The mess was expected in hind sight. It was just a bit hard (or I was having an off moment) to identify the cause in hindsight. MDEV-8594 covers some of the error messages however for expectations, can this be a minor feature request to detect when file name settings of similar named variables conflict.

Detect conflicts between file name settings of similarly named variables

Details

Description

Gliffy Diagrams

Attachments

Issue Links

Activity

People

Dates

Agile