Table names containing chars other than [_a-zA-Z0-9] are skipped
Bug #1035778 reported by
Vasco da Gama
This bug affects 2 people
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona XtraBackup moved to https://jira.percona.com/projects/PXB |
Triaged
|
Medium
|
Unassigned | ||
2.0 |
Won't Fix
|
Medium
|
Unassigned | ||
2.1 |
Triaged
|
Medium
|
Unassigned | ||
2.2 |
Triaged
|
Medium
|
Unassigned | ||
2.3 |
Triaged
|
Medium
|
Unassigned |
Bug Description
If a table name contains characters other than [_a-zA-Z0-9] the table is skipped. I asume that this is because the table file name does not match the table name any more. (See http://
How to reproduce:
1. Create a table with a character that is not from [_a-zA-Z0-9] in its name, e.g. CREATE TABLE `test-table` (id int) engine=innodb; (The table data file names are then test@002dtable.* which seems to be the problem.
2. Put stuff in the table
3. Try to backup it using innobackupex
To post a comment you must log in.
Vasco,
I am not able to reproduce this on Percona Server 5.5.25a, XtraBackup 2.0.1 - do you can you share your versions, my.cnf and specific procedure - a transcript like mine below can help.
[revin@forge msb_5_5_250]$ ./use test
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.5.25a-rel27.1 Percona Server with XtraDB (GPL), Release rel27.1, Revision 277
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql [localhost] {msandbox} (test) > drop table `test-ab`;
Query OK, 0 rows affected (0.00 sec)
mysql [localhost] {msandbox} (test) > set global innodb_ file_per_ table=1;
Query OK, 0 rows affected (0.00 sec)
mysql [localhost] {msandbox} (test) > create table `test-ab` (id int) engine=innodb;
Query OK, 0 rows affected (0.01 sec)
mysql [localhost] {msandbox} (test) > insert into `test-ab` values(100);
Query OK, 1 row affected (0.00 sec)
mysql [localhost] {msandbox} (test) > \q file=/ssd/ msb/msb_ 5_5_250/ my.sandbox. cnf /ssd/msb/ msb_5_5_ 250/bkp/
Bye
[revin@forge msb_5_5_250]$ ls -alh data/test/
total 144K
drwx------. 2 revin revin 50 Aug 11 22:34 .
drwx------. 5 revin revin 4.0K Aug 11 22:32 ..
-rw-rw----. 1 revin revin 8.4K Aug 11 22:34 test@002dab.frm
-rw-rw----. 1 revin revin 96K Aug 11 22:35 test@002dab.ibd
[revin@forge msb_5_5_250]$ innobackupex --defaults-
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.
120811 22:35:22 innobackupex: Starting mysql with options: --defaults- file='/ ssd/msb/ msb_5_5_ 250/my. sandbox. cnf' --unbuffered --
120811 22:35:22 innobackupex: Connected to database with mysql child process (pid=14750)
120811 22:35:28 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.27, 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 /ssd/msb/ msb_5_5_ 250/bkp/ 2012-08- 11_22-35- 28 file='/ ssd/msb/ msb_5_5_ 250/my. sandbox. cnf' --unbuffered --
120811 22:35:28 innobackupex: Starting mysql with options: --defaults-
120811 22:35:28 innobackupex: Connected to database with mysql child process (pid=14778)
120811 22:35:30 innobackupex: Connection to database server closed
120811 22:35:30 innobackupex: Starting ibbackup with command: xtrabackup_55 --defaults- file="/ ssd/msb/ msb_5_5_ 250/my. sandbox. cnf" --defaults- group=" mysqld" --backup --suspend-at-end --target- dir=/ssd/ msb/msb_ 5_5_250/ bkp/2012- 08...