Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.4.12, 10.2.41, 10.3.32, 10.5.13, 10.6.5, 10.7.1, 10.8(EOL)
-
None
Description
With settings like these:
log-bin = /data/mysql/log/hostname-bin
|
log-bin-index = /data/mysql/log/hostname.bdx
|
in [server] section of my.cnf, SST fails like this when removing the binary logs:
...
|
Oct 19 02:59:19 host-galera1 mysqld: removed ‘/data/mysql/log/hostname-bin.000287’
|
Oct 19 02:59:19 host-galera1 mysqld: removed ‘/data/mysql/log/hostname-bin.000277’
|
Oct 19 02:59:19 host-galera1 mysqld: removed ‘/data/mysql/log/hostname-bin.000281’
|
Oct 19 02:59:19 host-galera1 mysqld: rm: cannot remove ‘/data/mysql/log/*.index’: No such file or directory
|
...
|
Here (mariabackup-based) SST script assumes that binlog index file has extension of .index, instead of reading proper log_bin_index value from the config file. The real index file (hostname.bdx) does not get removed, but all binary logs do.
Then when SST completes, server is brought up and it reads the name of the binlog index file from [server] section, finding it. But in the index file there are filenames of deleted binary logs which are not found, so server shuts down.
See GitHub source code:
to find out what only [mysqld] section is checked for binary log related settings, even in current 10.7.