Description:
* Create database dbb and tables dbb.td1, dbb.td2, dbb.td3, dbb.te1, dbb.te2. dbb.tf1
* Dump some data in these tables.
* Execute innobackup to backup only tables starting from 'td' using --include regexp
* Apply logs for recovering the tables
* Drop database dbb and shutdown the server
* Perform innobackup --copy-back operation
* Restore the server
* Check that dbb.td* tables are restored and also verify that no other tables are recovered.
* After the test execution, some warnings and error messages are produced for non backed up tables of InnoDB
How to repeat:
Please find the attached test case for reproducing this.
==============================================================================
TEST RESULT TIME (ms)
------------------------------------------------------------
worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
meb.innobackup_reg [ fail ] Found warnings/errors in server log file!
Test ended at 2010-05-27 01:07:03
line
100527 2:07:02 InnoDB: Error: table 'dbb/te1'
100527 2:07:02 InnoDB: Error: table 'dbb/te2'
100527 2:07:02 InnoDB: Error: table 'dbb/tf1'
100527 2:07:02 InnoDB: Error: table 'mysql/ibbackup_binlog_marker'
100527 2:07:03 InnoDB: Error: trying to open a table, but could not
100527 2:07:03 [ERROR] MySQL is trying to open a table handle but the .ibd file for
100527 2:07:03 InnoDB: Error: trying to open a table, but could not
100527 2:07:03 [ERROR] MySQL is trying to open a table handle but the .ibd file for
100527 2:07:03 InnoDB: Error: table 'dbb/tf1'
100527 2:07:03 InnoDB: Error: table 'dbb/te1'
100527 2:07:03 InnoDB: Error: trying to open a table, but could not
100527 2:07:03 InnoDB: Error: table 'dbb/te2'
Note:
* Although there is way to suppress these errors and warnings messages, there should be a way to avoid this.
* I tried to delete the .frm files, .ibd files for all tables and also removed the ib* (ibdata1, ibdata2, ib_logfile etc) files from data directory. This also did not help and eventually produced the errors and warnings after test execution.
Description: * Create database dbb and tables dbb.td1, dbb.td2, dbb.td3, dbb.te1, dbb.te2. dbb.tf1 * Dump some data in these tables. * Execute innobackup to backup only tables starting from 'td' using --include regexp * Apply logs for recovering the tables * Drop database dbb and shutdown the server * Perform innobackup --copy-back operation * Restore the server * Check that dbb.td* tables are restored and also verify that no other tables are recovered. * After the test execution, some warnings and error messages are produced for non backed up tables of InnoDB How to repeat: Please find the attached test case for reproducing this. ============================================================================== TEST RESULT TIME (ms) ------------------------------------------------------------ worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 meb.innobackup_reg [ fail ] Found warnings/errors in server log file! Test ended at 2010-05-27 01:07:03 line 100527 2:07:02 InnoDB: Error: table 'dbb/te1' 100527 2:07:02 InnoDB: Error: table 'dbb/te2' 100527 2:07:02 InnoDB: Error: table 'dbb/tf1' 100527 2:07:02 InnoDB: Error: table 'mysql/ibbackup_binlog_marker' 100527 2:07:03 InnoDB: Error: trying to open a table, but could not 100527 2:07:03 [ERROR] MySQL is trying to open a table handle but the .ibd file for 100527 2:07:03 InnoDB: Error: trying to open a table, but could not 100527 2:07:03 [ERROR] MySQL is trying to open a table handle but the .ibd file for 100527 2:07:03 InnoDB: Error: table 'dbb/tf1' 100527 2:07:03 InnoDB: Error: table 'dbb/te1' 100527 2:07:03 InnoDB: Error: trying to open a table, but could not 100527 2:07:03 InnoDB: Error: table 'dbb/te2' Note: * Although there is way to suppress these errors and warnings messages, there should be a way to avoid this. * I tried to delete the .frm files, .ibd files for all tables and also removed the ib* (ibdata1, ibdata2, ib_logfile etc) files from data directory. This also did not help and eventually produced the errors and warnings after test execution.