[MDEV-15900]  fdatasync value is not recognized by the option mariabackup innodb-flush-method Created: 2018-04-17  Updated: 2018-04-17  Resolved: 2018-04-17

Status: Closed
Project: MariaDB Server
Component/s: Backup
Affects Version/s: 10.2.14, 10.3.6
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Zdravelina Sokolovska (Inactive) Assignee: Unassigned
Resolution: Not a Bug Votes: 0
Labels: None
Environment:

CentOS 7.4

Issue Links:
Problem/Incident
is caused by MDEV-15903 innodb-flush-method documentation nee... Closed
is caused by MDEV-15904 mariabackup documentation - remove sp... Open

 Description   

fdatasync value is not recognized by the option mariabackup innodb-flush-method 

# mariabackup -u root --backup --target-dir /var/mariadb/backup1 --innodb-flush-method=fdatasync
 
180417 14:14:58 Connecting to MySQL server host: localhost, user: root, password: not set, port: not set, socket: not set
 
Using server version 10.2.14-MariaDB
 
mariabackup based on MariaDB server 10.2.14-MariaDB Linux (x86_64)
 
mariabackup: uses posix_fadvise().
 
mariabackup: cd to /var/lib/mysql/
 
mariabackup: open files limit requested 0, set to 1024
 
mariabackup: using the following InnoDB configuration:
 
mariabackup:   innodb_data_home_dir = .
 
mariabackup:   innodb_data_file_path = ibdata1:12M:autoextend
 
mariabackup:   innodb_log_group_home_dir = ./
 
mariabackup: Unrecognized value fdatasync for innodb_flush_method
 



# mariabackup -u root --backup --target-dir /var/mariadb/backup1 --innodb-flush-method="fdatasync"
 
180417 14:24:39 Connecting to MySQL server host: localhost, user: root, password: not set, port: not set, socket: not set
 
Using server version 10.2.14-MariaDB
 
mariabackup based on MariaDB server 10.2.14-MariaDB Linux (x86_64)
 
mariabackup: uses posix_fadvise().
 
mariabackup: cd to /var/lib/mysql/
 
mariabackup: open files limit requested 0, set to 1024
 
mariabackup: using the following InnoDB configuration:
 
mariabackup:   innodb_data_home_dir = .
 
mariabackup:   innodb_data_file_path = ibdata1:12M:autoextend
 
mariabackup:   innodb_log_group_home_dir = ./
 
mariabackup: Unrecognized value fdatasync for innodb_flush_method



 Comments   
Comment by Vladislav Vaintroub [ 2018-04-17 ]

In fails, because Innodb does not support fdatasync as valid value for this option.

valid options are listed e.g here :
https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html#sysvar_innodb_flush_method

Comment by Zdravelina Sokolovska (Inactive) [ 2018-04-17 ]

wladyou are referring to the mysql docs in the comment above docs https://dev.mysql.com/doc not to the maridb
for that reason that should not be not a bug

Comment by Zdravelina Sokolovska (Inactive) [ 2018-04-17 ]

wlad fdatasync is given as Valid Value in both mariadb docs mariabackup-options and xtradbinnodb-server-system-variables

innodb_flush_method

-innodb-flush-method

Comment by Vladislav Vaintroub [ 2018-04-17 ]

if you cannot start server with that value, it is invalid, disregarding the outdated documentation for which I created issue MDEV-15903

Generated at Thu Feb 08 08:24:52 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.