xtrabackup_56 2.1.4 ro4 MySQL server 5.6.11 dont recognisies flush_method = ALL_O_DIRECT
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona XtraBackup moved to https://jira.percona.com/projects/PXB |
Fix Released
|
Medium
|
Alexey Kopytov | ||
2.0 |
Won't Fix
|
Undecided
|
Unassigned | ||
2.1 |
Fix Released
|
Medium
|
Alexey Kopytov | ||
2.2 |
Fix Released
|
Medium
|
Alexey Kopytov |
Bug Description
Bug appeared again in
xtrabackup_56 version 2.1.4 for MySQL server 5.6.11 Linux (x86_64) (revision id: 656)
[<email address hidden> /home/banyek]# innobackupex /tmp/test/
InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona Ireland Ltd 2009-2012. All Rights Reserved.
This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.
131217 14:41:42 innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:
131217 14:41:42 innobackupex: Connected to MySQL server
IMPORTANT: Please check that the backup run completes successfully.
At the end of a successful backup run innobackupex
prints "completed OK!".
innobackupex: Using mysql server version 5.6.14-56-log
innobackupex: Created backup directory /tmp/test/
131217 14:41:42 innobackupex: Starting ibbackup with command: xtrabackup_56 --defaults-
innobackupex: Waiting for ibbackup (pid=25593) to suspend
innobackupex: Suspend file '/tmp/test/
xtrabackup_56 version 2.1.4 for MySQL server 5.6.11 Linux (x86_64) (revision id: 656)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /var/lib/mysql
xtrabackup: using the following InnoDB configuration:
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: Unrecognized value ALL_O_DIRECT for innodb_flush_method
innobackupex: Error: ibbackup child process has died at /usr/bin/
-----
Right after commented out the
innodb_flush_method = ALL_O_DIRECT
from /etc/my.cnf it started working. <- but we can agree this is not the best workaround? ;)
Related branches
- Alexey Kopytov (community): Approve
-
Diff: 932 lines (+210/-95)3 files modifiedpatches/innodb56.patch (+209/-91)
src/xtrabackup.cc (+1/-1)
test/t/bug759225.sh (+0/-3)
- Alexey Kopytov (community): Approve
-
Diff: 175 lines (+34/-18)8 files modifiedstorage/innobase/fil/fil0fil.cc (+5/-4)
storage/innobase/include/srv0srv.h (+5/-1)
storage/innobase/log/log0log.cc (+9/-4)
storage/innobase/log/log0recv.cc (+5/-1)
storage/innobase/os/os0file.cc (+5/-2)
storage/innobase/srv/srv0start.cc (+3/-0)
storage/innobase/xtrabackup/src/xtrabackup.cc (+2/-3)
storage/innobase/xtrabackup/test/t/bug759225.sh (+0/-3)
xtrabackup_56 has to support innodb_flush_method = ALL_O_DIRECT in Percona Server 5.6. That feature wasn't ported originally, but was re-introduced in Percona Server 5.6.13.