Re: ADDING INDEXES TO A TABLE LEADS TO MYSQL CRASH, BUG!!

2003-12-29 Thread Sergei Golubchik
Hi! On Dec 29, Derek J wrote: > Hello, >First, Yes I can create repeatable test case, I still have live > server with the same problem. and another Dual opteron server, which i > created the same database there as a test to make sure there are no > hardware faliures casuing this probles, but i

Re: ADDING INDEXES TO A TABLE LEADS TO MYSQL CRASH, BUG!!

2003-12-29 Thread Derek J
Hello, First, Yes I can create repeatable test case, I still have live server with the same problem. and another Dual opteron server, which i created the same database there as a test to make sure there are no hardware faliures casuing this probles, but i still had the same problem there too. I

Re: ADDING INDEXES TO A TABLE LEADS TO MYSQL CRASH, BUG!!

2003-12-29 Thread Sergei Golubchik
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

Re: ADDING INDEXES TO A TABLE LEADS TO MYSQL CRASH, BUG!!

2003-12-28 Thread Derek J
I have enough disk space for indexes, the problem doesn't happen during adding an index. it happens after the index is added. On Sun, 2003-12-28 at 21:33, mos wrote: > At 06:28 PM 12/28/2003, you wrote: > >Hello Every Body , > >I have been facing a strange problem, that i assume its a mysql bug of

Re: ADDING INDEXES TO A TABLE LEADS TO MYSQL CRASH, BUG!!

2003-12-28 Thread mos
At 06:28 PM 12/28/2003, you 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

ADDING INDEXES TO A TABLE LEADS TO MYSQL CRASH, BUG!!

2003-12-28 Thread Derek J
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