InnoDB tables which names contain *opt*, *par*, *CSV*, *MYD* and so on backed up twice
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona XtraBackup moved to https://jira.percona.com/projects/PXB |
Fix Released
|
High
|
Sergei Glushchenko | ||
2.0 |
Fix Released
|
High
|
Sergei Glushchenko | ||
2.1 |
Fix Released
|
High
|
Sergei Glushchenko |
Bug Description
Output of innobackupex:
sudo innobackupex --no-lock --stream=xbstream ~/test-1 > ~/test-4.xbm
[sudo] password for raghu:
InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona Inc 2009-2012. All Rights Reserved.
This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.
120427 10:14:47 innobackupex: Starting mysql with options: --unbuffered --
120427 10:14:47 innobackupex: Connected to database with mysql child process (pid=5816)
120427 10:14:53 innobackupex: Connection to database server closed
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.5.21, for Linux (x86_64) using readline 5.1
innobackupex: Using mysql server version Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
innobackupex: Created backup directory /home/raghu/test-1
120427 10:14:53 innobackupex: Starting mysql with options: --unbuffered --
120427 10:14:53 innobackupex: Connected to database with mysql child process (pid=5846)
120427 10:14:55 innobackupex: Connection to database server closed
120427 10:14:55 innobackupex: Starting ibbackup with command: xtrabackup_55 --backup --suspend-at-end --target-dir=/tmp/ --stream=xbstream
innobackupex: Waiting for ibbackup (pid=5854) to suspend
innobackupex: Suspend file '/tmp//
xtrabackup_55 version 2.0.0 for Percona Server 5.5.16 Linux (x86_64) (revision id: 417)
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_
120427 10:14:55 InnoDB: Using Linux native AIO
xtrabackup: using O_DIRECT
120427 10:14:55 InnoDB: Warning: allocated tablespace 66, old maximum was 9
>> log scanned up to (1492855886)
[01] Streaming /var/lib/
[01] ...done
[01] Streaming ./testxbm/
[01] ...done
[01] Streaming ./xyz/dtrpg_
[01] ...done
[01] Streaming ./xyz/products.ibd
[01] ...done
[01] Streaming ./xyz/products_
[01] ...done
[01] Streaming ./test/items.ibd
[01] ...done
[01] Streaming ./test/t.ibd
[01] ...done
[01] Streaming ./test/
[01] ...done
[01] Streaming ./test/
[01] ...done
[01] Streaming ./test/
[01] ...done
[01] Streaming ./i22429/
[01] ...done
[01] Streaming ./i22429/
[01] ...done
[01] Streaming ./i22429/
[01] ...done
[01] Streaming ./i22429/
[01] ...done
[01] Streaming ./i22429/
[01] ...done
[01] Streaming ./i22429/
[01] ...done
[01] Streaming ./i22429/
[01] ...done
[01] Streaming ./i22429/
[01] ...done
[01] Streaming ./i22429/
[01] ...done
[01] Streaming ./i22429/
[01] ...done
[01] Streaming ./i22429/
[01] ...done
[01] Streaming ./i22429/
[01] ...done
[01] Streaming ./i22429/
[01] ...done
[01] Streaming ./i22429/
[01] ...done
[01] Streaming ./i22429/
[01] ...done
[01] Streaming ./i22429/
[01] ...done
[01] Streaming ./i22429/
[01] ...done
[01] Streaming ./i22429/
[01] ...done
[01] Streaming ./i22429/
[01] ...done
[01] Streaming ./i22429/
[01] ...done
[01] Streaming ./i22429/data.ibd
[01] ...done
[01] Streaming ./i22429/
[01] ...done
[01] Streaming ./i22429/
[01] ...done
[01] Streaming ./i22429/
[01] ...done
[01] Streaming ./test1/t1.ibd
[01] ...done
[01] Streaming ./test1/t2.ibd
[01] ...done
120427 10:14:59 innobackupex: Continuing after ibbackup has suspended
120427 10:14:59 innobackupex: Starting mysql with options: --unbuffered --
120427 10:14:59 innobackupex: Connected to database with mysql child process (pid=5868)
>> log scanned up to (1492855886)
120427 10:15:01 innobackupex: Starting to backup .frm, .MRG, .MYD, .MYI,
innobackupex: .TRG, .TRN, .ARM, .ARZ, .CSM, .CSV and .opt files in
innobackupex: subdirectories of '/var/lib/mysql'
innobackupex: Backing up file '/var/lib/
innobackupex: Backing up file '/var/lib/
innobackupex: Backing up file '/var/lib/
innobackupex: Backing up file '/var/lib/
innobackupex: Backing up file '/var/lib/
innobackupex: Backing up file '/var/lib/
innobackupex: Backing up file '/var/lib/
innobackupex: Backing up file '/var/lib/
innobackupex: Backing up file '/var/lib/
innobackupex: Backing up file '/var/lib/
innobackupex: Backing up file '/var/lib/
innobackupex: Backing up file '/var/lib/
innobackupex: Backing up file '/var/lib/
innobackupex: Backing up file '/var/lib/
innobackupex: Backing up file '/var/lib/
innobackupex: Backing up file '/var/lib/
innobackupex: Backing up file '/var/lib/
innobackupex: Backing up file '/var/lib/
innobackupex: Backing up files '/var/lib/
innobackupex: Backing up files '/var/lib/
innobackupex: Backing up files '/var/lib/
innobackupex: Backing up files '/var/lib/
innobackupex: Backing up file '/var/lib/
innobackupex: Backing up file '/var/lib/
innobackupex: Backing up file '/var/lib/
120427 10:15:02 innobackupex: Finished backing up .frm, .MRG, .MYD, .MYI, .TRG, .TRN, .ARM, .ARZ, .CSV, .CSM and .opt files
innobackupex: Resuming ibbackup
xtrabackup: The latest check point (for incremental): '1492855886'
xtrabackup: Stopping log copying thread.
.>> log scanned up to (1492855886)
xtrabackup: Streaming transaction log from a temporary file...
xtrabackup: Done.
xtrabackup: Transaction log of lsn (1492855886) to (1492855886) was copied.
120427 10:15:03 innobackupex: Connection to database server closed
innobackupex: Backup created in directory '/home/
120427 10:15:03 innobackupex: completed OK!
Which cause failure when xbstream extracting backup:
mkdir ~/test-4; cat ~/test-4.xbm | xbstream -v -x -C ~/test-4
backup-my.cnf
ibdata1
./testxbm/
./xyz/dtrpg_
./xyz/products.ibd
./xyz/products_
./test/items.ibd
./test/t.ibd
./test/
./test/
./test/
./i22429/
./i22429/
./i22429/
./i22429/
./i22429/
./i22429/
./i22429/
./i22429/
./i22429/
./i22429/
./i22429/
./i22429/
./i22429/
./i22429/
./i22429/
./i22429/
./i22429/
./i22429/
./i22429/
./i22429/
./i22429/data.ibd
./i22429/
./i22429/
./i22429/
./test1/t1.ibd
./test1/t2.ibd
testxbm/db.opt
testxbm/lolopt.frm
xbstream: Can't create/write to file './testxbm/
xbstream: failed to create file.
Related branches
- Stewart Smith (community): Approve
-
Diff: 36 lines (+20/-1)2 files modifiedinnobackupex (+1/-1)
test/t/bug989397.sh (+19/-0)
tags: | added: i23119 |
Changed in percona-xtrabackup: | |
status: | New → Triaged |
importance: | Undecided → High |
assignee: | nobody → Sergei Glushchenko (sergei.glushchenko) |
Changed in percona-xtrabackup: | |
status: | Fix Committed → Fix Released |
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/ /jira.percona. com/browse/ PXB-328