Description:
A specific table (see "How-To-Repeat) with a FULLTEXT index causes errors in
the MYI file when inserting new rows.
The error only occurs when the FULLTEXT index is in the table. I've tried to
recreate the table completely, and it still occurs.
The bug is found on the following platforms/versions:
Win2k server SP2, MySQL 3.23.32
Win2k server SP2, MySQL 3.23.39
Linux, MySQL 3.23.39
How-To-Repeat:
1) Create the following table:
CREATE TABLE `visitkort` (
`id` int(10) unsigned NOT NULL auto_increment,
`kategori_id` int(10) unsigned NOT NULL default '0',
`aktiv` tinyint(3) unsigned NOT NULL default '0',
`navn` varchar(60) NOT NULL default '',
`adresse` varchar(150) NOT NULL default '',
`postnr` varchar(5) NOT NULL default '',
`tlf` varchar(20) NOT NULL default '',
`fax` varchar(20) NOT NULL default '',
`email` varchar(60) NOT NULL default '',
`password` varchar(20) NOT NULL default '',
`url` varchar(150) NOT NULL default '',
`beskrivelse` varchar(200) NOT NULL default '',
`visitkort` tinyint(3) unsigned NOT NULL default '0',
`skabelon` tinyint(3) unsigned NOT NULL default '0',
`logo` tinyint(3) unsigned NOT NULL default '0',
`billede` tinyint(3) unsigned NOT NULL default '0',
`tekst1` text NOT NULL,
`tekst2` text NOT NULL,
`tekst3` text NOT NULL,
`tekst4` text NOT NULL,
PRIMARY KEY (`id`),
KEY `kategori_id` (`kategori_id`),
KEY `bruger_id` (`visitkort`),
KEY `postnr` (`postnr`),
KEY `email` (`email`),
FULLTEXT KEY `ft`
(`navn`,`beskrivelse`,`tekst1`,`tekst2`,`tekst3`,`tekst4`)
) TYPE=MyISAM;
2)
Insert a row with the following statement:
insert into visitkort (navn, kategori_id) values ('test7', 106);
3) Run myisamchk with the option --extend-check and you get the following
result
C:\mysql\data\midtfyn>myisamchk --extend-check visitkort
Checking MyISAM file: visitkort
Data records: 339 Deleted blocks: 0
myisamchk: warning: 1 clients is using or hasn't closed the table properly
- check file-size
- check key delete-chain
- check record delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
- check data record references index: 3
- check data record references index: 4
- check data record references index: 5
- check records and index references
MyISAM-table 'visitkort' is usable but should be fixed
4) To repair the table, you need to do a "flush table" and then the
myisamchk --safe-recover
C:\mysql\data\midtfyn>myisamchk --safe-recover -force visitkort
- recovering (with sort) MyISAM-table 'visitkort.MYI'
Data records: 339
- Fixing index 1
Found block with too small length at 22812; Skipped
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
Fix:
The error does not occur, if you drop the FULLTEXT index
Synopsis: FULLTEXT index corrupts the index with too many TEXT fields
Submitter-Id:
Originator: Carsten Gehling
Organization: Sarum
MySQL support: [none]
Severity: [serious]
Priority: [low | medium | high ]
Category: [mysqld]
Class: [sw-bug]
Release: mysql-3.23.39
Exectutable: [mysqld]
Environment: MySQL console
System: <Win200>
Compiler: Binary distribution
Architecture: i
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
