← Back to team overview

percona-discussion team mailing list archive

  1. percona-discussion team
  2. Mailing list archive
  3. Message #00451

[Bug 357653] [NEW] innobackupex-1.5.1 --copy-back fails

  Thread Previous • Date Previous • • Thread Next 
Public bug reported:

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

** Affects: percona-xtrabackup
     Importance: Undecided
         Status: New

** Description changed:

  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
  
- Another bug in path code of the xtrabackup-tool?
- 
  Btw. backup-my.cnf: /mysql/data in innodb_data_file_path doesn't seem
  right, does it?
  
- 
  Greets
  Mark Davis

-- 
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

Follow ups

References

  Thread Previous • Date Previous • • Thread Next