Bug #25673 spatial index corruption, error 126 incorrect key file for table
Submitted: 17 Jan 2007 10:27 Modified: 15 Mar 2007 3:46
Reporter: Shane Bester
Status: Closed
Category:Server: MyISAM Severity:S1 (Critical)
Version:5.0.34,5.0.36-BK,5.1.15-BK OS: *
Assigned to: Ingo Strüwing Target Version:
Tags: bfsm_2007_02_01, spatial, corruption, myisam

File: Maximum allowed size is 500KB.
Description:
Privacy:

If the data you need to attach is more than 500KB, you should create a compressed archive of the data and a README file that describes the data with a filename that includes the bug number (example: bug-data-25673.zip), and use FTP to upload the archive to ftp://ftp.mysql.com/pub/mysql/upload/. Once you have uploaded the file, add a comment to this bug to notify us about it. Note: This directory is unlistable, which means that once you have uploaded your file, you will not be able to see it.

All entries become the exclusive editorial property of Sun Microsystems, Inc.

[17 Jan 2007 10:29] Shane Bester 
see top of file for build instructions, host, user, port, etc

Attachment: testcase.c (text/plain), 5.75 KiB.
[24 Feb 2007 12:34] Shane Bester 
and here's the promised testcase. simply import using command line client

Attachment: bug25673.zip (application/zip, text), 207.97 KiB.
[25 Feb 2007 6:05] Shane Bester 
a final version of testcase, 538 lines long!!!

Attachment: bug25673_reduced.sql (application/octet-stream, text), 54.33 KiB.
[25 Feb 2007 6:53] Shane Bester 
same testcase as bug25673_reduced.sql except multirow insert and less indexes are used.

Attachment: bug25673_tiny.sql (application/octet-stream, text), 34.54 KiB.
[2 Mar 2007 22:47] Ingo Strüwing 
Some comments on rtree index structures and algorithmns.

Attachment: rtree-indexes.txt (text/plain), 6.42 KiB.