Bug #37307 MyISAM: R-tree unit test produces corrupted table
Submitted: 10 Jun 2008 13:23 Modified: 18 Dec 2008 10:02
Reporter: Guilhem Bichot Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: MyISAM storage engine Severity:S3 (Non-critical)
Version:5.0-bk, 5.1-maria OS:Linux
Assigned to: CPU Architecture:Any

[10 Jun 2008 13:23] Guilhem Bichot
Description:
./ma_rt_test
./maria_chk -se rt_test
Checking MARIA file: rt_test
Data records:      30   Deleted blocks:      10
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
maria_chk: error: Key in wrong position at page 8192
- check records and index references
maria_chk: error: Record at:            360  Can't find key for index:  1
MARIA-table 'rt_test' is corrupted

How to repeat:
./ma_rt_test
./maria_chk -se rt_test
[12 Jun 2008 14:34] Guilhem Bichot
This happens in 5.0 too with storage/myisam/rt_test.
It does not happen in 5.1 because storage/myisam/rt_test crashes before.
In 5.1-maria we fixed the crash, so rt_test and ma_rt_test finish, but still
produce a corrupted table like in 5.0.
Asked help from Bar, Holyfoot and Ramil about that.
[16 Jun 2008 19:32] Guilhem Bichot
rt_test.c and sp_test.c from Maria tree, the best available versions

Attachment: rt_sp_test.c.tar.bz2 (application/x-bzip2, text), 5.06 KiB.

[16 Jun 2008 19:33] Guilhem Bichot
The files attached above are to be put into storage/myisam; they are identical to those in 5.1-main except that we fixed a bunch of easy crash bugs (due to the API of mi_rkey() changed without the tests being updated).
[30 Jun 2008 18:18] Bugs System
Pushed into 5.1.25-maria-alpha
[30 Jun 2008 18:22] Bugs System
Pushed into 5.1.25-maria-alpha
[30 Jun 2008 18:26] Bugs System
Pushed into 5.1.25-maria-alpha
[30 Jun 2008 18:29] Bugs System
Pushed into 5.1.25-maria-alpha
[30 Jun 2008 18:32] Bugs System
Pushed into 5.1.25-maria-alpha
[27 Nov 2008 20:22] Trudy Pelzer
Comments indicate pushes in June. Is this fixed?
[27 Nov 2008 20:34] Guilhem Bichot
Hello Trudy. Probably nothing has happened. Those "pushed" posts come from the automated system, must be a bug of it. I was not assigned to work on that bug, I only reported and analysed it a bit.
When I run "rt_test" in the latest 5.1 it crashes, so that makes it even more sure that the bug was not fixed.
[18 Dec 2008 10:02] Guilhem Bichot
It was assigned to me so that I answer Trudy's question, now I did, I de-assign.
[18 Dec 2008 10:02] Guilhem Bichot
and "verified", as I saw crashes.