Bug #12527 yassl causes errors in "repair" and "optimize"
Submitted: 11 Aug 2005 15:08 Modified: 1 Sep 2005 0:38
Reporter: Joerg Bruehe Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0.11 OS:various Unix
Assigned to: Magnus Blåudd CPU Architecture:Any

[11 Aug 2005 15:08] Joerg Bruehe 
Description:
Test build with "yassl" enabled on all platforms.

Test failure:

archive                        [ fail ]

Errors are (from PATH/mysqltest-time) :
At line 1338: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/archive.result
--- r/archive.reject
***************
*** 2622,2628
  INSERT INTO t2 VALUES (4,011403,37,'intercepted','audiology','tinily','');
  OPTIMIZE TABLE t2 EXTENDED;
  Table Op      Msg_type        Msg_text
! test.t2       optimize        status  OK
  SELECT * FROM t2;
  auto  fld1    companynr       fld3    fld4    fld5    fld6
  1     000001  00      Omaha   teethe  neat
--- 2622,2628
  INSERT INTO t2 VALUES (4,011403,37,'intercepted','audiology','tinily','');
  OPTIMIZE TABLE t2 EXTENDED;
  Table Op      Msg_type        Msg_text
! test.t2       optimize        error   Unknown - internal error during operation
  SELECT * FROM t2;
  auto  fld1    companynr       fld3    fld4    fld5    fld6
  1     000001  00      Omaha   teethe  neat
***************
*** 3833,3839
  4     011403  37      intercepted     audiology       tinily
  REPAIR TABLE t2;
  Table Op      Msg_type        Msg_text
! test.t2       repair  status  OK
  SELECT * FROM t2;
  auto  fld1    companynr       fld3    fld4    fld5    fld6
  1     000001  00      Omaha   teethe  neat
--- 3833,3839
  4     011403  37      intercepted     audiology       tinily
  REPAIR TABLE t2;
  Table Op      Msg_type        Msg_text
! test.t2       repair  error   Unknown - internal error during operation
  SELECT * FROM t2;
  auto  fld1    companynr       fld3    fld4    fld5    fld6
  1     000001  00      Omaha   teethe  neat
-------------------------------------------------------

sol10-amd64-a-5.0-standard.log   normal
sol10-sparc-a-5.0-standard.log   normal
sol10-x86-5.0-standard.log   normal
sol9x86-5.0-standard.log   normal
sunfire100b-5.0-standard.log   normal

How to repeat:
Test suite failure.
[24 Aug 2005 13:44] Magnus Blåudd 
*** r/archive.result    Mon Aug 22 12:32:30 2005
--- r/archive.reject    Wed Aug 24 15:45:11 2005
***************
*** 2622,2628 ****
  INSERT INTO t2 VALUES (4,011403,37,'intercepted','audiology','tinily','');
  OPTIMIZE TABLE t2 EXTENDED;
  Table Op      Msg_type        Msg_text
! test.t2       optimize        status  OK
  SELECT * FROM t2;
  auto  fld1    companynr       fld3    fld4    fld5    fld6
  1     000001  00      Omaha   teethe  neat
--- 2622,2628 ----
  INSERT INTO t2 VALUES (4,011403,37,'intercepted','audiology','tinily','');
  OPTIMIZE TABLE t2 EXTENDED;
  Table Op      Msg_type        Msg_text
! test.t2       optimize        error   Unknown - internal error 2 during operation
  SELECT * FROM t2;
  auto  fld1    companynr       fld3    fld4    fld5    fld6
  1     000001  00      Omaha   teethe  neat
***************
*** 3833,3839 ****
  4     011403  37      intercepted     audiology       tinily
  REPAIR TABLE t2;
  Table Op      Msg_type        Msg_text
! test.t2       repair  status  OK
  SELECT * FROM t2;
  auto  fld1    companynr       fld3    fld4    fld5    fld6
  1     000001  00      Omaha   teethe  neat
--- 3833,3839 ----
  4     011403  37      intercepted     audiology       tinily
  REPAIR TABLE t2;
  Table Op      Msg_type        Msg_text
! test.t2       repair  error   Unknown - internal error 144 during operation
  SELECT * FROM t2;
  auto  fld1    companynr       fld3    fld4    fld5    fld6
  1     000001  00      Omaha   teethe  neat
-------------------------------------------------------
Please follow the instructions outlined at
http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html
to find the reason to this problem and how to report this.

Aborting: archive failed in default mode. To continue, re-run with '--force'.

Ending Tests
Shutting-down MySQL daemon

Master shutdown finished
Slave shutdown finished
[29 Aug 2005 12:04] 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/internals/28971
[1 Sep 2005 0:38] Paul DuBois 
No changelog entry needed (unreleased version only).