List:Bugs« Previous MessageNext Message »
From:Indrek Siitan Date:March 14 2003 6:34pm
Subject:Re: long write queries hang the server
View as plain text  
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

Thread
long write queries hang the serverMark M. Ito14 Mar
  • Re: long write queries hang the serverIndrek Siitan14 Mar
    • Re: long write queries hang the serverMark M. Ito18 Mar
      • Re: long write queries hang the servermiguel solórzano19 Mar
        • Re: long write queries hang the serverMark M. Ito20 Mar
          • Re: long write queries hang the serverSinisa Milivojevic20 Mar