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 <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
