innobackupex say "completed OK!" but backup is failed due out of free space
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona XtraBackup moved to https://jira.percona.com/projects/PXB |
Fix Released
|
High
|
Valentine Gostev |
Bug Description
[root@oscar tmp]# /usr/bin/
InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy.
All Rights Reserved.
This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.
IMPORTANT: Please check that the backup run completes successfully.
At the end of a successful backup run innobackupex
prints "completed OK!".
innobackupex: Using mysql Ver 14.14 Distrib 5.1.50, for unknown-linux-gnu (x86_64) using readline 5.1
innobackupex: Using mysql server version Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
innobackupex: Created backup directory /home/backup/
101107 13:11:01 innobackupex: Starting mysql with options: --password=******* --user=root --unbuffered --
101107 13:11:01 innobackupex: Connected to database with mysql child process (pid=27714)
101107 13:11:05 innobackupex: Connection to database server closed
101107 13:11:05 innobackupex: Starting ibbackup with command: xtrabackup --backup --suspend-at-end --target-
innobackupex: Waiting for ibbackup (pid=27720) to suspend
innobackupex: Suspend file '/home/
xtrabackup Ver 1.2 Rev 132 for 5.1.45 unknown-linux-gnu (x86_64)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /var/lib/mysql
xtrabackup: Target instance is assumed as followings.
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
>> log scanned up to (259264105271)
Copying ./ibdata1
to /home/backup/
xtrabackup: Page 64 seems double write buffer. passing the check.
...skip...
xtrabackup: Page 191 seems double write buffer. passing the check.
>> log scanned up to (259264115850)
...done
Copying ./saturn/
to /home/backup/
...done
... skip ...
101107 13:41:15 InnoDB: Error: Write to file /home/backup/
InnoDB: 524288 bytes should have been written, only 65536 were written.
InnoDB: Operating system error number 2.
InnoDB: Check that your OS and file system support files of this size.
InnoDB: Check also that the disk is not full or a disk quota exceeded.
InnoDB: Error number 2 means 'No such file or directory'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://
xtrabackup: Error: xtrabackup_
xtrabackup: Warining: failed to copy, but continuing.
101107 13:41:16 innobackupex: Continuing after ibbackup has suspended
101107 13:41:16 innobackupex: Starting mysql with options: --password=******* --user=root --unbuffered --
101107 13:41:16 innobackupex: Connected to database with mysql child process (pid=30018)
101107 13:41:20 innobackupex: Starting to lock all tables...
>> log scanned up to (259280275767)
>> log scanned up to (259280323407)
101107 13:41:30 innobackupex: All tables locked and flushed to disk
101107 13:41:30 innobackupex: Starting to backup .frm, .MRG, .MYD, .MYI,
innobackupex: .TRG, .TRN, .ARM, .ARZ and .opt files in
innobackupex: subdirectories of '/var/lib/mysql'
innobackupex: Backing up files '/var/lib/
>> log scanned up to (259280323712)
innobackupex: Backing up files '/var/lib/
101107 13:41:31 innobackupex: Finished backing up .frm, .MRG, .MYD, .MYI, .TRG, .TRN, .ARM, .ARZ and .opt files
innobackupex: Resuming ibbackup
xtrabackup: The latest check point (for incremental): '259267465559'
>> log scanned up to (259280324183)
xtrabackup: Stopping log copying thread.....
xtrabackup: Transaction log of lsn (259261055368) to (259280324183) was copied.
101107 13:41:34 innobackupex: All tables unlocked
101107 13:41:34 innobackupex: Connection to database server closed
innobackupex: Backup created in directory '/home/
innobackupex: MySQL binlog position: filename '', position
101107 13:41:34 innobackupex: completed OK!
Changed in percona-xtrabackup: | |
milestone: | none → 1.6 |
assignee: | nobody → Valentine Gostev (core-longbow) |
I think I fixed this bug while working on support for compressed InnoDB tables: http:// bazaar. launchpad. net/~percona- dev/percona- xtrabackup/ trunk/revision/ 206.2.1
Which means the fix will be available in XtraBackup 1.6.