Re: Mysqld 3.23.56 crash on concurrent ALTER TABLE and FLUSH TABLE

Fred,

> I reproduced it on 3.23.56 with this script:

I am indeed seeing crashes (or lockups) with your script with several 
versions, but:
 
> ALTER TABLE a UNION=($union);

This shows a problem with multiple threads altering the UNION for the 
same MERGE table, which is not quite the problem you described.  

If I change this to:

ALTER TABLE $basetable UNION=($union);

then I am unable to reproduce any problem with 3.23.58.

Can you verify whether or not your connections are actually altering the 
same MERGE table?  Also, you should try your test with the above change 
and see if you are still seeing crashes when the connections are not in 
fact altering the same MERGE set.

Best regards,
-- 
Dean Ellis, Support Engineer & Software Developer
MySQL AB, www.mysql.com

Want to swim with the dolphins? (April 14-16, 2004)
http://www.mysql.com/uc2004/


-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]