MySQL Bugs: #29807: innodb_mysql.test: Cannot find table test/t2 from the internal data dictionary

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

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

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.

Approved, will be pushed with the nearest push to main.

Pushed into 5.1.21-beta

Test case change. No changelog entry needed.