Bug #38102 Test 'ctype_many' fails (randomly) on Mac OS X 10.4 PowerPC, "Error on rename"

• Submitted: 14 Jul 2008 14:22
• Modified: 16 Aug 2008 12:10
• Reporter: Kent Boortz
• Status: No Feedback
• Category: MySQL Server: Tests
• Severity: S3 (Non-critical)
• Version: 5.0.66
• OS: MacOS (PowerPC 32bit)
• CPU Architecture: Any

[14 Jul 2008 14:22] Kent Boortz

Description:
Test fails with

  ctype_many                     [ fail ]

  mysqltest: At line NNN: query 'ALTER TABLE t1 ADD ucs2_f CHAR(32) CHARACTER SET ucs2'
  failed: 7: Error on rename of './test/#sql-419c_1.frm' to './test/t1.frm' (Errcode: 2)

  The result from queries just before the failure was:
  < snip >
  CYR SMALL YERU        CYR CAPIT YERU
  CYR SMALL YERU        CYR SMALL YERU
  CYR CAPIT SOFT SIGN   CYR CAPIT SOFT SIGN
  CYR CAPIT SOFT SIGN   CYR SMALL SOFT SIGN
  CYR SMALL SOFT SIGN   CYR CAPIT SOFT SIGN
  CYR SMALL SOFT SIGN   CYR SMALL SOFT SIGN
  CYR CAPIT E   CYR CAPIT E
  CYR CAPIT E   CYR SMALL E
  CYR SMALL E   CYR CAPIT E
  CYR SMALL E   CYR SMALL E
  CYR CAPIT YU  CYR CAPIT YU
  CYR CAPIT YU  CYR SMALL YU
  CYR SMALL YU  CYR CAPIT YU
  CYR SMALL YU  CYR SMALL YU
  CYR CAPIT YA  CYR CAPIT YA
  CYR CAPIT YA  CYR SMALL YA
  CYR SMALL YA  CYR CAPIT YA
  CYR SMALL YA  CYR SMALL YA
  SET CHARACTER SET utf8;
  ALTER TABLE t1 ADD ucs2_f CHAR(32) CHARACTER SET ucs2;

  Warnings from just before the error:
  Error 7 Error on rename of './test/#sql-419c_1.frm' to './test/t1.frm' (Errcode: 2)
  Error 1025 Error on rename of './test/#sql-419c_1' to './test/t1' (errno: 2)

How to repeat:
Likely need to run the test many times, as it is probably a random failure

[16 Jul 2008 12:10] Susanne Ebrecht

Kent,

please define many ....
after 100 times I couldn't repeat

[16 Aug 2008 23:00] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".