Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.0.16-galera
-
None
-
prod
Description
Performing an SST using xtrabackup-v2 methods
fails with following errors:
 |
150330 11:09:37 [ERROR] I/O error reading the header from the binary log, errno=175, io cache code=0
|
150330 11:09:37 [ERROR] I/O error reading the header from the binary log
|
150330 11:09:37 [ERROR] Can't init tc log
|
150330 11:09:37 [ERROR] Aborting
|
It creates some corrupt binary log file on the joiner node
root@con:~# ls -lh /data/mysql/binlog/
|
total 4.0K
|
-rw-rw---- 1 mysql mysql 32 Mar 30 11:09 binlog.index
|
-rw-rw---- 1 mysql mysql 0 Mar 30 11:09 binlog.state
|
This issue is repeatable, set log_bin to non-default location on all the nodes e.g. we have set it to
log_bin=/data/mysql/binlog/binlog
|
Work around was to change log_bin location to its default location on all the nodes i.e.
log_bin=binlog
|
SST using xtrabackup-v2 on a joiner node would be a success.
Attachments
Issue Links
- is blocked by
-
MDEV-7110 Add missing MySQL variable log_bin_basename and log_bin_index
- Closed