Bug #29807 innodb_mysql.test: Cannot find table test/t2 from the internal data dictionary
Submitted: 15 Jul 2007 10:25 Modified: 17 Jul 2007 17:30
Reporter: Ingo Strüwing Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Tests Severity:S7 (Test Cases)
Version:5.1.21 OS:Any
Assigned to: Sergey Vojtovich CPU Architecture:Any

[15 Jul 2007 10:25] Ingo Strüwing
Description:
From master.err:

070715 13:22:22070715 13:22:22 [ERROR] Cannot find table test/t2 from the internal data dictionary
of InnoDB though the .frm file for the table exists. Maybe you
have deleted and recreated InnoDB data files but have forgotten
to delete the corresponding .frm files of InnoDB tables, or you
have moved .frm files to another database?
See http://dev.mysql.com/doc/refman/5.1/en/innodb-troubleshooting.html
how you can resolve the problem.

070715 13:22:22  InnoDB: Error: table `test`.`t2` does not exist in the InnoDB internal
InnoDB: data dictionary though MySQL is trying to drop it.
InnoDB: Have you copied the .frm file of the table to the
InnoDB: MySQL database directory from another database?
InnoDB: You can look for further help from
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/innodb-troubleshooting.html

NOTE: I am going to diable innodb_mysql. Please re-enable when this is fixed.

How to repeat:
bk clone bk-internal.mysql.com:/home/bk/mysql-5.1 'mysql-5.1-amain'
cd 'mysql-5.1-amain'
BUILD/compile-pentium-debug-max --with-debug=full
cd mysql-test
./mysql-test-run.pl --mysqld=--binlog-format=statement innodb_mysql
[16 Jul 2007 11:06] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/30956

ChangeSet@1.2553, 2007-07-16 15:09:46+05:00, svoj@mysql.com +4 -0
  BUG#29807 - innodb_mysql.test: Cannot find table test/t2 from the
              internal data dictionary
  - re-enabled innodb_mysql test;
  - added a rule to through away expected warning to mtr_report.pl;
  - fixed a test case to produce unique warning.
[17 Jul 2007 9:29] Konstantin Osipov
Approved, will be pushed with the nearest push to main.
[17 Jul 2007 15:30] Bugs System
Pushed into 5.1.21-beta
[17 Jul 2007 17:30] Paul Dubois
Test case change. No changelog entry needed.