• From: Gothenburg, Sweden
  • Registered: 2002-07-03
  • Posts: 946

Topic: MySQL error 11 - Thread problems

I'm settings up my last project at a friends server, and found out that there's a problem. After a while there's too much mysql-threads (they doesn't close... don't know why) so MySQL can't create more of them and gives the error-message:

Warning: mysql_connect(): 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 in...

Does someone knows how to fix this? (He's running some kind of linux-installation...)

Edit: No, I've not consulted the manual...

2 Reply by zc923

  • zc923
  • Senior Member
  • Offline
  • From: -5 GMT
  • Registered: 2003-12-15
  • Posts: 446

Re: MySQL error 11 - Thread problems

What version of mysql?

Do, or do not.
  • From: Gothenburg, Sweden
  • Registered: 2002-07-03
  • Posts: 946

Re: MySQL error 11 - Thread problems

MySQL info from phpinfo():

Client API version: 3.23.56

  • From: Göteborg
  • Registered: 2003-02-25
  • Posts: 168

Re: MySQL error 11 - Thread problems

Are you using mysql_pconnect? In that case try using mysql_connect isnstead.
If you're using mysql_connect already, try putting a mysql_close() in the bottom of your scripts to make sure they close.

  • From: Gothenburg, Sweden
  • Registered: 2002-07-03
  • Posts: 946

Re: MySQL error 11 - Thread problems

Gaaah! Now it happened again! MySQL have 1500 processes running, and can't create new ones :( And to make things worce, I don't have root-access :(

RNilsson wrote:

Are you using mysql_pconnect? In that case try using mysql_connect isnstead.
If you're using mysql_connect already, try putting a mysql_close() in the bottom of your scripts to make sure they close.

I'm running Pun on it, and the owner have a PhpBB-forum or something like that. Don't know if he's using any pconnections though...

Do I need to close the connection when using Perl?

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: MySQL error 11 - Thread problems

Chacmool wrote:

Do I need to close the connection when using Perl?

I can't imagine otherwise.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website