Hi Joerg
Thank you very much for the response.
I found an answer this morning (about 15 minutes ago) where the
server's Thread cache was used up and the amount of max connections exceeded
causing the same error.
We have not yet been able to establish the source of the amount of
connections though.
Machiel Richards
MySQL DBA
Relational Database Consulting
-----Original Message-----
From: joerg.bru...@sun.com [mailto:joerg.bru...@sun.com]
Sent: 30 June 2010 10:53 AM
To: mysql@lists.mysql.com
Cc: Machiel Richards
Subject: Re: Mysql error causing database to not accept threads
Hi!
Machiel Richards wrote:
> [[...]]
>
> We received an error on a MySQL database this morning
which
> caused it to be unavailable for connections.
>
> Error:
>
> ERROR 1135 (00000): 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
>
> [[...]]
You don't say anything about the MySQL version you are running, or your
platform.
I hope this here will help you, though:
| u...@h:~> fgrep 11 /usr/include/asm-generic/errno-base.h
| #define EAGAIN 11 /* Try again */
| u...@h:~> man pthread_create
| PTHREAD_CREATE(3P) POSIX Programmer's Manual
PTHREAD_CREATE(3P)
|
|
|
| NAME
| pthread_create - thread creation
|
| [[...]]
|
| ERRORS
| The pthread_create() function shall fail if:
|
| EAGAIN The system lacked the necessary resources to create
another thread, or the system-imposed
| limit on the total number of threads in a process
{PTHREAD_THREADS_MAX} would be exceeded.
|
| [[...]]
Jörg
--
Joerg Bruehe, MySQL Build Team, joerg.bru...@sun.com
Sun Microsystems GmbH, Komturstrasse 18a, D-12099 Berlin
Geschaeftsfuehrer: Juergen Kunz
Amtsgericht Muenchen: HRB161028
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
