List:General Discussion« Previous MessageNext Message »
From:Sergei Golubchik Date:December 29 2003 4:00pm
Subject:Re: ADDING INDEXES TO A TABLE LEADS TO MYSQL CRASH, BUG!!
View as plain text  
Hi!

On Dec 28, Derek J wrote:
> Hello Every Body , 
> I have been facing a strange problem, that i assume its a mysql bug of
> some sort.
> 
> In my datadabase there are 2 tables, if i tried to add any index to them
> ,any INSERT INTO request status will be - in show processlist- update
> and will freeze like this forever , and consequently all inserts ot this
> table stays in the que, untill mysql stops responding.
> 
> If i drop the INDEX on those tables INSERTS works fine, once i create
> ANY index except PRIMARY  index, INSERTS fails.
> 
> ALL kind of tricks, like myisamchk, drop table and creating a new one,
> even moving it to a new machine seems to cause the same problem.
> 
> Running Mysqld 4.0.16 / 4.0.17 ( tried both) on AMD opteron 2 gig ram
> using MySQL Binaries on REDHAT AS3.
> 
> one of The table structures:
> 
> CREATE TABLE `keywordlog` (
>   `username` char(40) default NULL,
>   `country` enum('Unknown','Unknown','AD','Andorra','AE',**removed rest
> of enumerate due to restricton on email size**,'ZW','Zimbabwe') NOT NULL
> default 'Unknown',
>   `ip` char(15) NOT NULL default '',
>   `time_date` datetime NOT NULL default '0000-00-00 00:00:00',
>   `keyword` char(50) NOT NULL default '',
>   `refer_url` char(70) default NULL,
>   `request_url` char(70) default NULL,
>   `xmlstatus` enum('HTML','XML') NOT NULL default 'HTML',
>   `bid` char(6) NOT NULL default '',
>   `toolbar` int(1) default '0'
> ) TYPE=MyISAM;

What columns are you trying to index ? What is the index definition ?
What does SHOW PROCESSLIST show when there are "freezed" inserts ?
How big is your table ?
Can you create a repeatable test case ?

Regards,
Sergei

-- 
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik <serg@stripped>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, Senior Software Developer
/_/  /_/\_, /___/\___\_\___/  Osnabrueck, Germany
       <___/  www.mysql.com
Thread
ADDING INDEXES TO A TABLE LEADS TO MYSQL CRASH, BUG!!Derek J29 Dec
  • Re: ADDING INDEXES TO A TABLE LEADS TO MYSQL CRASH, BUG!!mos29 Dec
    • Re: ADDING INDEXES TO A TABLE LEADS TO MYSQL CRASH, BUG!!Derek J29 Dec
  • Re: ADDING INDEXES TO A TABLE LEADS TO MYSQL CRASH, BUG!!Sergei Golubchik29 Dec
    • Re: ADDING INDEXES TO A TABLE LEADS TO MYSQL CRASH, BUG!!Derek J29 Dec
      • Re: ADDING INDEXES TO A TABLE LEADS TO MYSQL CRASH, BUG!!Sergei Golubchik29 Dec