percona-discussion team mailing list archive

[MarkD <mark.davis@xxxxxxxxx>]

Mhh,

not really a proper fix... Just got this:

innobackupex: Copying file '/mysql/backup/2009-04-08_10-24-32/ibdata1'

innobackupex: Starting to copy InnoDB tables and indexes
innobackupex: in '/mysql/backup/2009-04-08_10-24-32'
innobackupex: back to original InnoDB data directory '/'
innobackupex: Copying file '/mysql/backup/2009-04-08_10-24-32//mysql/data/ibdata1'
cp: cannot stat `/mysql/backup/2009-04-08_10-24-32//mysql/data/ibdata1': No such file or directory
innobackupex: Error: Failed to copy file '/mysql/data/ibdata1': Bad file descriptor at ./innobackupex-1.5.1 line 433.

-- 
innobackupex-1.5.1 --copy-back fails
https://bugs.launchpad.net/bugs/357653
You received this bug notification because you are a member of Percona
developers, which is the registrant for Percona-XtraBackup.

Status in Open source backup tool for InnoDB and XtraDB: New

Bug description:
Hi,

i'm currently trying to copy back a backup and i get the following error:

innobackupex-1.5.1 --copy-back  /mysql/backup/2009-04-08_10-24-32

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 copy-back run completes successfully.
           At the end of a successful copy-back run innobackup
           prints "innobackup completed OK!".

innobackupex: Error: Backup data file '/mysql/backup/2009-04-08_10-24-32//mysql/data/ibdata1' does not exist. at ./innobackupex-1.5.1 line 433.

-------

stat("/mysql/data", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
stat("/", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
stat("/mysql/logs", {st_mode=S_IFDIR|0755, st_size=20480, ...}) = 0
stat("/mysql/backup/2009-04-08_10-24-32//mysql/data/ibdata1", 0xa9b3140) = -1 ENOENT (No such file or directory)
stat("/mysql/backup/2009-04-08_10-24-32//mysql/data/ibdata1.ibz", 0xa9b3140) = -1 ENOENT (No such file or directory)
write(2, "innobackupex: Error: Backup data"..., 144innobackupex: Error: Backup data file '/mysql/backup/2009-04-08_10-24-32//mysql/data/ibdata1' does not exist. at ./innobackupex-1.5.1 line 433.

-------

Backup created with "innobackupex-1.5.1 --prepare" and "innobackupex-1.5.1 --apply-log" (all ended with OK).

my.cnf:
.........
innodb_data_home_dir = /
innodb_data_file_path = /mysql/data/ibdata1:128M:autoextend
innodb_file_per_table
innodb_log_group_home_dir = /mysql/logs
innodb_buffer_pool_size = 4096M
innodb_additional_mem_pool_size = 32M
innodb_log_file_size = 128M
innodb_log_files_in_group = 2


/mysql/backup/backup-my.cnf:
# This MySQL options file was generated by innobackup.

# The MySQL server
[mysqld]
datadir=/media/local-data0/backup/2009-04-08_10-24-32
innodb_data_home_dir=/media/local-data0/backup/2009-04-08_10-24-32
innodb_data_file_path=/mysql/data/ibdata1:128M:autoextend
innodb_log_group_home_dir=/media/local-data0/backup/2009-04-08_10-24-32
innodb_log_files_in_group=2
innodb_log_file_size=134217728

Btw. backup-my.cnf: /mysql/data in innodb_data_file_path doesn't seem right, does it?

Greets
Mark Davis