Hi,
>> Description:
>
> Under a variety of circumstances, creates and inserts of a
> table with many columns, 2304 to be exact, hang the server. The
> symptoms are that the mysqld thread gets a signal 11, and the client
> never completes. "show processlist" gives, for example
>> How-To-Repeat:
> The following commands:
> mysql test < create.sql
> mysql test < insert.sql
> mysql test < insert.sql
> mysql test < insert.sql
> .
> .
> .
>
> executed rapidly from the shell seems to reliably hang the
> server. Here create.sql and insert.sql can be found at
>
> http://www.jlab.org/~marki/mysql_bug/create.sql
> http://www.jlab.org/~marki/mysql_bug/insert.sql
I was unable to repeat this. Can you try upgrading to the latest version
(3.23.55 currently, but 3.23.56 with numerous bug fixes should be out today
or tomorrow, if you could wait for that) and see if the problem persists. If
possible, please try our binary/rpm instead of compiling on your own.
Rgds,
Indrek
--
MySQL Users Conference and Expo: http://www.mysql.com/events/uc2003/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Indrek Siitan <tfr@stripped>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, The Support Guy
/_/ /_/\_, /___/\___\_\___/ Uuemõisa, Haapsalu, Estonia
<___/ www.mysql.com