Bug #52204 Several tests using innodb fail with "Incorrect key file for table" on Mac OSX

• Submitted: 19 Mar 2010 8:45
• Modified: 20 Jul 2010 6:58
• Reporter: Alexander Nozdrin
• Status: Can't repeat
• Category: MySQL Server: InnoDB Plugin storage engine
• Severity: S1 (Critical)
• Version: M3 (Celosia)
• OS: MacOS (i386 max)
• Assigned to: Calvin Sun
• CPU Architecture: Any
• Tags: mysql-trunk-bugfixing, pb2, test failure

[19 Mar 2010 8:45] Alexander Nozdrin

Description:
Test cases:

  - main.innodb_mysql

mysqltest: In included file "./include/mix1.inc": At line 323: query 'create index idx12672_0 on t4 (a1)' failed: 1034: Incorrect key file for table 't4'; try to repair it

  - innodb.innodb_bug41904

mysqltest: At line 12: query 'CREATE UNIQUE INDEX ui ON bug41904 (uniquecol)' failed: 1034: Incorrect key file for table 'bug41904'; try to repair it

  - main.group_min_max_innodb

mysqltest: At line 58: query 'create index idx12672_0 on t4 (a1)' failed: 1034: Incorrect key file for table 't4'; try to repair it

  - main.implicit_commit

mysqltest: In included file "./include/implicit_commit_helper.inc": At line 3: query '$statement' failed: 1034: Incorrect key file for table 't1'; try to repair it

  - main.type_bit_innodb

mysqltest: At line 52: query 'alter table t1 add key (a)' failed: 1034: Incorrect key file for table 't1'; try to repair it

  - main.sp_trans

mysqltest: At line 456: query 'call bug10656_create_index()' failed: 1034: Incorrect key file for table 't3'; try to repair it

How to repeat:
Check out PB page for mysql-trunk-bugfixing.

Sample log: http://tinyurl.com/yjhunpo

[19 Mar 2010 15:34] Valeriy Kravchuk

All these tests pass OK on current mysql-trunk tree. So the problem is specific to mysql-trunk-bugfixing.

[22 Mar 2010 11:56] Sveta Smirnova

Thank you for the report.

Verified as described using link provided. Not repeatable in my environment.

[20 Jul 2010 6:58] Alexander Nozdrin

Closing as Can't Repeat anymore.