Operating system error number 17 when use parallel backup

Bug #900175 reported by yczealot
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona XtraBackup moved to https://jira.percona.com/projects/PXB
Fix Released
Medium
Alexey Kopytov
1.6
Fix Released
Medium
Alexey Kopytov
2.0
Fix Released
Medium
Alexey Kopytov

Bug Description

111128 02:18:13 innobackupex: Starting ibbackup with command: xtrabackup_55 --defaults-file="/data1/mysql4554/my4554.cnf.bakuse" --backup --suspend-at-end --target-dir=/baknfs1/backup/day/mysql4554/20111128/mysql4554 --throttle=1000 --parallel=4
innobackupex: Waiting for ibbackup (pid=16571) to suspend
innobackupex: Suspend file '/baknfs1/backup/day/mysql4554/20111128/mysql4554/xtrabackup_suspended'

xtrabackup: uses posix_fadvise().
xtrabackup: cd to /data1/mysql4554
xtrabackup: Target instance is assumed as followings.
xtrabackup: innodb_data_home_dir = ./
xtrabackup: innodb_data_file_path = ibdata1:10M:autoextend
xtrabackup: innodb_log_group_home_dir = ./
xtrabackup: innodb_log_files_in_group = 3
xtrabackup: innodb_log_file_size = 1363148800
111128 2:18:13 InnoDB: Using Linux native AIO
xtrabackup: use O_DIRECT
111128 2:18:13 InnoDB: Warning: allocated tablespace 3192, old maximum was 9
>> log scanned up to (619544778885)
111128 2:18:24 InnoDB: Operating system error number 17 in a file operation.
InnoDB: Error number 17 means 'File exists'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/operating-system-error-codes.html
[01] xtrabackup: error: cannot open /baknfs1/backup/day/mysql4554/20111128/mysql4554/relation_7/relation_376.ibd
[01] xtrabackup: Error: xtrabackup_copy_datafile() failed.
[01] xtrabackup: Error: failed to copy datafile.
xtrabackup_55 version 1.6.3 for Percona Server 5.5.9 Linux (x86_64) (revision id: 292)
xtrabackup: Starting 4 threads for parallel data files transfer
[03] Copying ./relation_7/relation_376.ibd
     to /baknfs1/backup/day/mysql4554/20111128/mysql4554/relation_7/relation_376.ibd
[02] Copying ./ibdata1
     to /baknfs1/backup/day/mysql4554/20111128/mysql4554/ibdata1
innobackupex: Error: ibbackup child process has died at /usr/bin/innobackupex line 343.

-----------------------------
I use xtrabackup to backup more than 50 databases , I find one or two databases backup failed almost everyday ,and they aren't same one.
I guess this due to the parallel parameter.Could you give me some advice?

Related branches

Revision history for this message
yczealot (yczealot) wrote :

another example:

111201 03:58:20 innobackupex: Starting ibbackup with command: xtrabackup_55 --defaults-file="/data1/mysql4133/my4133.cnf.bakuse" --backup --suspend-at-end --target-dir=/baknfs1/backup/day/mysql4133/20111201/mysql4133 --throttle=1000 --parallel=4
innobackupex: Waiting for ibbackup (pid=10535) to suspend
innobackupex: Suspend file '/baknfs1/backup/day/mysql4133/20111201/mysql4133/xtrabackup_suspended'

xtrabackup: uses posix_fadvise().
xtrabackup: cd to /data1/mysql4133
xtrabackup: Target instance is assumed as followings.
xtrabackup: innodb_data_home_dir = ./
xtrabackup: innodb_data_file_path = ibdata1:100M:autoextend
xtrabackup: innodb_log_group_home_dir = ./
xtrabackup: innodb_log_files_in_group = 3
xtrabackup: innodb_log_file_size = 134217728
111201 3:58:20 InnoDB: Using Linux native AIO
xtrabackup: use O_DIRECT
111201 3:58:21 InnoDB: Warning: allocated tablespace 2219, old maximum was 9
>> log scanned up to (33005021)
111201 3:58:21 InnoDB: Operating system error number 17 in a file operation.
InnoDB: Error number 17 means 'File exists'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/operating-system-error-codes.html
[02] xtrabackup: error: cannot open /baknfs1/backup/day/mysql4133/20111201/mysql4133/mytv_user_playlist/stv_user_playlist_aa.ibd
[02] xtrabackup: Error: xtrabackup_copy_datafile() failed.
[02] xtrabackup: Error: failed to copy datafile.
xtrabackup_55 version 1.6.3 for Percona Server 5.5.9 Linux (x86_64) (revision id: 292)
xtrabackup: Starting 4 threads for parallel data files transfer
[03] Copying ./mytv_user_playlist/stv_user_playlist_aa.ibd
     to /baknfs1/backup/day/mysql4133/20111201/mysql4133/mytv_user_playlist/stv_user_playlist_aa.ibd
[04] Copying ./mytv_user_playlist/stv_user_playlist_f3.ibd
     to /baknfs1/backup/day/mysql4133/20111201/mysql4133/mytv_user_playlist/stv_user_playlist_f3.ibd
innobackupex: Error: ibbackup child process has died at /usr/bin/innobackupex line 343.

Revision history for this message
Alexey Kopytov (akopytov) wrote :

Probably a duplicate of bug #826632.

Revision history for this message
Stewart Smith (stewart) wrote :

Setting as confirmed as we are seeing existing failures and have test cases. After bug #826632 is fixed, we can check if it also fixes this.

Changed in percona-xtrabackup:
importance: Undecided → Medium
status: New → Triaged
Changed in percona-xtrabackup:
assignee: nobody → Patrick Crews (patrick-crews)
Changed in percona-xtrabackup:
assignee: Patrick Crews (patrick-crews) → Alexey Kopytov (akopytov)
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXB-583

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.