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

Hi all! Mark wrote: On my FreeBSD: usr/include/errno.h:#define EAGAIN 35 /* Resource temporarily unavailable */ /usr/include/errno.h-#ifndef _POSIX_SOURCE /usr/include/errno.h-#define EWOULDBLOCK EAGAIN /* Operation would block */ Ok, next step then: The OP wrote the problem was when

RE: 1135: Can't create a new thread (errno 35); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug

Seems I was in error suggesting a file limit issue; which is why I wisely left it to to, Jörg. :) Ok, next step, then: ERRORS pthread_create() will fail if: [EAGAIN] The system lacked the necessary resources to create another thread, or the system-imposed limit on the total

1135: Can't create a new thread (errno 35); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug

Hello guys and gurus I am keep getting this error after a while *1135: Can't create a new thread (errno 35); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug* Even though, I have 16GB memory and 32GB swap. But mysqlserver stops answering. Could

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

Hi folks then if I check with the process: I get following output: # ps ax | grep mysqld 797 con- I 0:00.00 /bin/sh /usr/local/bin/mysqld_safe --defaults-extra-file=/var/db/mysql/my.cnf --user=mysql --datadir=/var/db/mysql --pid-file=/var/db/mysql/localhost.server1.pid 835 con- S

RE: 1135: Can't create a new thread (errno 35); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug

I happen to run the exact same MySQL version + OS version (although I'm doing a huge upgrade to 5.1.34 today), and I have not experienced any such issues. Granted, I only get ~60 queries/s, so your traffic is probably much higer. At any rate, the first place I'd look is for open files limit (and

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

Hi VeeJay, Mark, all, VeeJay wrote: Hi Mark Yes, you are right. I should have provided complete information in order to get help... I am running DB: Server version: 5.0.77-log FreeBSD port: mysql-server-5.0.77_1 OS: FreeBSD 7.1 On Tue, Apr 28, 2009 at 10:44 AM, Mark

RE: 1135: Can't create a new thread (errno 35); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug

Jörg mgai...@martini ~ FGIN.sh 35 | fgrep errno find: File system loop detected; `/usr/include/gnome-xml/libxml' is part of the same file system loop as `/usr/include/gnome-xml'. /usr/include/apr-1/apr_errno.h:806:#define SOCEWOULDBLOCK (SOCBASEERR+3 5)/* Operation would

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

Hi Mark Yes, you are right. I should have provided complete information in order to get help... I am running DB: Server version: 5.0.77-log FreeBSD port: mysql-server-5.0.77_1 OS: FreeBSD 7.1 On Tue, Apr 28, 2009 at 10:44 AM, Mark ad...@asarian-host.net wrote: It would probably

RE: 1135: Can't create a new thread (errno 35); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug

On my FreeBSD: usr/include/errno.h:#define EAGAIN 35 /* Resource temporarily unavailable */ /usr/include/errno.h-#ifndef _POSIX_SOURCE /usr/include/errno.h-#define EWOULDBLOCK EAGAIN /* Operation would block */ I still wouldn't discount the files resources limit; though obviously I bow to