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

XML

Word

Printable

Details

Type: Task
Status: Closed (View Workflow)
Priority: Minor
Resolution: Won't Fix
Fix Version/s: N/A
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

Attachments

Issue Links

relates to

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

Confirmed

Activity

People

Assignee:: Unassigned

Reporter:: Daniel Black

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2015-08-10 10:34

Updated:: 2021-10-13 20:47

Resolved:: 2021-10-13 20:47

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.