Operating system error number 17 when use parallel backup
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-
innobackupex: Waiting for ibbackup (pid=16571) to suspend
innobackupex: Suspend file '/baknfs1/
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /data1/mysql4554
xtrabackup: Target instance is assumed as followings.
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
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://
[01] xtrabackup: error: cannot open /baknfs1/
[01] xtrabackup: Error: xtrabackup_
[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_
to /baknfs1/
[02] Copying ./ibdata1
to /baknfs1/
innobackupex: Error: ibbackup child process has died at /usr/bin/
-------
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
- Stewart Smith (community): Approve
-
Diff: 24 lines (+4/-1)1 file modifiedsrc/xtrabackup.c (+4/-1)
- Stewart Smith (community): Approve
-
Diff: 24 lines (+4/-1)1 file modifiedxtrabackup.c (+4/-1)
Changed in percona-xtrabackup: | |
assignee: | nobody → Patrick Crews (patrick-crews) |
Changed in percona-xtrabackup: | |
assignee: | Patrick Crews (patrick-crews) → Alexey Kopytov (akopytov) |
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 backup/ day/mysql4133/ 20111201/ mysql4133/ xtrabackup_ suspended'
innobackupex: Waiting for ibbackup (pid=10535) to suspend
innobackupex: Suspend file '/baknfs1/
xtrabackup: uses posix_fadvise(). data_home_ dir = ./ data_file_ path = ibdata1: 100M:autoextend log_group_ home_dir = ./ log_files_ in_group = 3 log_file_ size = 134217728 dev.mysql. com/doc/ refman/ 5.5/en/ operating- system- error-codes. html backup/ day/mysql4133/ 20111201/ mysql4133/ mytv_user_ playlist/ stv_user_ playlist_ aa.ibd copy_datafile( ) failed. user_playlist/ stv_user_ playlist_ aa.ibd backup/ day/mysql4133/ 20111201/ mysql4133/ mytv_user_ playlist/ stv_user_ playlist_ aa.ibd user_playlist/ stv_user_ playlist_ f3.ibd backup/ day/mysql4133/ 20111201/ mysql4133/ mytv_user_ playlist/ stv_user_ playlist_ f3.ibd innobackupex line 343.
xtrabackup: cd to /data1/mysql4133
xtrabackup: Target instance is assumed as followings.
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
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://
[02] xtrabackup: error: cannot open /baknfs1/
[02] xtrabackup: Error: xtrabackup_
[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_
to /baknfs1/
[04] Copying ./mytv_
to /baknfs1/
innobackupex: Error: ibbackup child process has died at /usr/bin/