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
• Status: Verified
• Category: MySQL Server: MyISAM storage engine
• Severity: S3 (Non-critical)
• Version: 5.0-bk, 5.1-maria
• OS: Linux
• 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.