[MDEV-13752] mariabackup Error Invalid argument Created: 2017-09-07  Updated: 2017-09-07  Resolved: 2017-09-07

Status: Closed
Project: MariaDB Server
Component/s: Backup
Affects Version/s: 10.2
Fix Version/s: 10.2.8

Type: Bug Priority: Major
Reporter: TAO ZHOU Assignee: Andrii Nikitin (Inactive)
Resolution: Duplicate Votes: 0
Labels: None
Environment:

FreeBSD

Issue Links:
Duplicate
duplicates MDEV-13416 mariabackup --backup fails to copy lo... Closed

 Description   

Here's the error message I got when I was trying to use mariabackup for sst.

170907 12:16:25 innobackupex: Starting the backup operation
 
 
 
IMPORTANT: Please check that the backup run completes successfully.
 
           At the end of a successful backup run innobackupex
 
           prints "completed OK!".
 
 
 
170907 12:16:25 Connecting to MySQL server host: localhost, user: galera, password: set, port: 3306, socket: /tmp/mysql.sock
 
Using server version 10.2.7-MariaDB-log
 
innobackupex based on MariaDB server 10.2.7-MariaDB FreeBSD11.0 (amd64)
 
xtrabackup: uses posix_fadvise().
 
xtrabackup: cd to /var/mysql-data/
 
xtrabackup: open files limit requested 0, set to 706518
 
xtrabackup: using the following InnoDB configuration:
 
xtrabackup:   innodb_data_home_dir = /var/mysql-data
 
xtrabackup:   innodb_data_file_path = ibdata1:10M:autoextend
 
xtrabackup:   innodb_log_group_home_dir = /var/mysql-logs
 
xtrabackup: using O_DIRECT
 
xtrabackupp: Warning: ignoring innodb_flush_method = O_DIRECT on Windows.
 
2017-09-07 12:16:26 34426937344 [Note] InnoDB: Number of pools: 1
 
innobackupex: Error writing file 'UNKNOWN' (Errcode: 22 "Invalid argument")
 
xb_stream_write_data() failed.
 
xtrabackup: Error: write to logfile failed
 
xtrabackup: Error: xtrabackup_copy_logfile() failed.

Then I executed mariabakup mannually, and got this:

170907 13:25:39 Connecting to MySQL server host: localhost, user: tao, password: set, port: 3306, socket: /tmp/mysql.sock
Using server version 10.2.7-MariaDB-log
mariabackup based on MariaDB server 10.2.7-MariaDB FreeBSD11.0 (amd64)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /var/mysql-data/
xtrabackup: open files limit requested 0, set to 706518
xtrabackup: using the following InnoDB configuration:
xtrabackup: innodb_data_home_dir = /var/mysql-data
xtrabackup: innodb_data_file_path = ibdata1:10M:autoextend
xtrabackup: innodb_log_group_home_dir = /var/mysql-logs
xtrabackup: using O_DIRECT
xtrabackupp: Warning: ignoring innodb_flush_method = O_DIRECT on Windows.
2017-09-07 13:25:39 34426937344 [Note] InnoDB: Number of pools: 1
mariabackup: Error writing file '/tmp/backup/ib_logfile0' (Errcode: 22 "Invalid argument")
xtrabackup: Error: write to logfile failed
xtrabackup: Error: xtrabackup_copy_logfile() failed.

 Comments   
Comment by Andrii Nikitin (Inactive) [ 2017-09-07 ]

This looks like duplicate of MDEV-13416 "mariabackup --backup fails to copy log if LSN is above 4294967295"

To confirm that - please send one of:

  • send us Error log from MariaDB Server
  • send us output of SQL command SHOW ENGINE INNODB STATUS

If 'last sequence number' in one of above is above 4294967295 , then problem is fixed in 10.2.8

Comment by TAO ZHOU [ 2017-09-07 ]

Thanks Andrii!
The last LSN is 665869443495.
Is there a patch I can use?

Comment by Andrii Nikitin (Inactive) [ 2017-09-07 ]

10.2.8 was released on 18-Aug, so I think it may be the easiest to just use that version.
Or feel free to try single line commit in xtrabackup.cc https://github.com/MariaDB/server/commit/5a43c8bae72fea5c3e55ea852630ae01d2f7da94#diff-e63469103825200ae5c25b83f957c7bd

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