Re: Can't create a new thread (errno 11). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug'

[Jocelyn Fournier]

Hi,

For me it sounds like a glibc issue.
BTW, currently the 4.1.10a build is compiled against glibc-2.2, does 
MySQL plan to build next releases against glibc-2.3 which seems to 
handle much better a high number of simultaneous connected threads ?

Thanks !
   Jocelyn

Gleb Paharenko wrote:
> Hello.
> 
> 
> 
> Please switch to the mysql-debug-4.1.10a version and send  
> 
> the error log with resolved stack trace. Include the
> 
> output of the following statement as well:
> 
> 
> 
>   SHOW VARIABLES;
> 
> 
> 
> 
> 
> 
>>I'm getting this strange error when there are more than 1100 mysql
> 
> 
>>connections connected to the same server.
> 
> 
> 
> 
> What about ulimits and free memory of your system?
> 
> 
> 
> 
> 
> 
> 
> 
> 
> "Andrew Braithwaite" <Andrew@stripped> wrote:
> 
> 
>>Hi,
> 
> 
> 
>>Yes - am using the standard binaries and have even upgraded to
> 
> 
>>mysql-standard-4.1.10a-pc-linux-gnu-i686.  I'm still getting this error
> 
> 
>>- does anyone have any ideas?=20
> 
> 
> 
>>Cheers,
> 
> 
> 
>>Andrew
> 
> 
> 
>>-----Original Message-----
> 
> 
>>From: Gleb Paharenko [mailto:gleb.paharenko@stripped]=20
> 
> 
>>Sent: Thu 31 March 2005 02:31
> 
> 
>>To: mysql@stripped
> 
> 
>>Subject: Re: Can't create a new thread (errno 11). If you are not out of
> 
> 
>>available memory, you can consult the manual for a possible OS-dependent
> 
> 
>>bug'
> 
> 
> 
>>Hello.
> 
> 
> 
>>I strongly recommend you to upgrade to the latest release. Do you use
> 
> 
>>official binaries? See:
> 
> 
> 
>> http://dev.mysql.com/doc/mysql/en/crashing.html
> 
> 
> 
> 
> 
> 
> 
>>"Andrew Braithwaite" <Andrew@stripped> wrote:
> 
> 
>>>Hi,
> 
> 
>>>=20
> 
> 
>>>I'm getting this strange error when there are more than 1100 mysql=20
> 
> 
>>>connections connected to the same server.
> 
> 
>>>=20
> 
> 
>>>[root@someserver mysql]# bin/mysql
> 
> 
>>>bin/mysql: connect to server at 'localhost' failed
> 
> 
>>>error: 'Can't create a new thread (errno 11). If you are not out of=20
> 
> 
>>>available memory, you can consult the manual for a possible=20
> 
> 
>>>OS-dependent bug'
> 
> 
>>>=20
> 
> 
>>>I've had this running fine in the past with MySQL 4.0.17 and Red Hat=20
> 
> 
>>>7.3 (linux 2.4..) but with the same hardware and MySQL versions using=20
> 
> 
>>>Fedora core 2 (linux 2.6) I am getting these problems.
> 
> 
>>>=20
> 
> 
>>>I have checked max_connections and others in my.cnf and all is good.
> 
> 
>>>I'm running 'out of the box' linux and 'out of the box' MySQL
> 
> 
>>binaries.
> 
> 
>>>=20
> 
> 
>>>Has anyone had this before?
> 
> 
>>>=20
> 
> 
>>>I would love to hear your thoughts and ideas..
> 
> 
>>>=20
> 
> 
>>>Cheers for the help,
> 
> 
>>>=20
> 
> 
>>>Andrew
> 
> 
>>>=20
> 
> 
>>>SQL, Query
> 
> 
>>>=20
> 
> 
>>>=20
> 
> 
> 
> 
>>--
> 
> 
>>For technical support contracts, goto
> 
> 
>>https://order.mysql.com/?ref=3Densita
> 
> 
>>This email is sponsored by Ensita.NET http://www.ensita.net/
> 
> 
>>  __  ___     ___ ____  __
> 
> 
>> /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
> 
> 
>>/ /|_/ / // /\ \/ /_/ / /__   Gleb.Paharenko@stripped
> 
> 
>>/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
> 
> 
>>      <___/   www.mysql.com
> 
> 
> 
> 
> 
> 
>>--=20
> 
> 
>>MySQL General Mailing List
> 
> 
>>For list archives: http://lists.mysql.com/mysql
> 
> 
>>To unsubscribe:
> 
> 
>>http://lists.mysql.com/mysql?unsub=1
> 
> 
> 
> 
> 
> 
> 
>