MySQL Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community ForumsDatabasesMySQL Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old January 22nd, 2004, 12:49 AM
rasputinj rasputinj is offline
Junior Member
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Sep 2003
Posts: 5 rasputinj User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
MySql Error Can't create a new thread (errno 11).?

I am getting this error at times when I have light traffic, and the server is not overloaded, and memory is available.

mysql_select_db(): 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

I am on a a VPS with Virtuozzo, it runs on Redhat 7.3,

mysql (4.0.15-standard), php 4.3.3.

I am running PHP Nuke and have not had this error and have run for months. I have not tweaked or changed mysql or php.

Any help would be appreciated.

Reply With Quote
  #2  
Old January 22nd, 2004, 07:21 AM
MadCowDzz's Avatar
MadCowDzz MadCowDzz is offline
I'm Internet Famous
Dev Articles Frequenter (2500 - 2999 posts)
 
Join Date: Jan 2003
Location: Toronto, Canada
Posts: 2,890 MadCowDzz User rank is Lance Corporal (50 - 100 Reputation Level)MadCowDzz User rank is Lance Corporal (50 - 100 Reputation Level)MadCowDzz User rank is Lance Corporal (50 - 100 Reputation Level) 
Time spent in forums: 1 Week 16 h 14 m 9 sec
Reputation Power: 8
Perhaps you should upgrade your Redhad distro to the latest version. This might be a known bug in the OS which has been fixed in new versions

I have no evidence of this, but I do know they're up to at least 9.0 now

Reply With Quote
  #3  
Old January 22nd, 2004, 11:31 AM
rasputinj rasputinj is offline
Junior Member
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Sep 2003
Posts: 5 rasputinj User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
I can not go up to 9.0 the Virtual Private Server runs on 7.3. So I might be screwed.

Reply With Quote
  #4  
Old January 22nd, 2004, 02:06 PM
MadCowDzz's Avatar
MadCowDzz MadCowDzz is offline
I'm Internet Famous
Dev Articles Frequenter (2500 - 2999 posts)
 
Join Date: Jan 2003
Location: Toronto, Canada
Posts: 2,890 MadCowDzz User rank is Lance Corporal (50 - 100 Reputation Level)MadCowDzz User rank is Lance Corporal (50 - 100 Reputation Level)MadCowDzz User rank is Lance Corporal (50 - 100 Reputation Level) 
Time spent in forums: 1 Week 16 h 14 m 9 sec
Reputation Power: 8
It may not even fix the problem... only a suggestion...
How about upgrading your mysql version?

Have you tried restarting the webserver and/or mysql server?

Reply With Quote
  #5  
Old January 22nd, 2004, 02:12 PM
MadCowDzz's Avatar
MadCowDzz MadCowDzz is offline
I'm Internet Famous
Dev Articles Frequenter (2500 - 2999 posts)
 
Join Date: Jan 2003
Location: Toronto, Canada
Posts: 2,890 MadCowDzz User rank is Lance Corporal (50 - 100 Reputation Level)MadCowDzz User rank is Lance Corporal (50 - 100 Reputation Level)MadCowDzz User rank is Lance Corporal (50 - 100 Reputation Level) 
Time spent in forums: 1 Week 16 h 14 m 9 sec
Reputation Power: 8
I just searched google and found lots of different answers in other forums... some suggestions were restart the server... don't use mysql_pconnect() (in PHP)... change max_used_connections (in my.cnf) to 10 (That'll get the connections to die off after 10 seconds)

Hopefully something here will help ya? =)

Here's my google search

Reply With Quote
  #6  
Old January 22nd, 2004, 03:45 PM
rasputinj rasputinj is offline
Junior Member
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Sep 2003
Posts: 5 rasputinj User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Quote:
Originally posted by MadCowDzz
It may not even fix the problem... only a suggestion...
How about upgrading your mysql version?

Have you tried restarting the webserver and/or mysql server?


I have restarted and things are better for the last 14 hours, I do not use the pcconnect so I will look into the max_used_connections (in my.cnf) to 10 (That'll get the connections to die off after 10 seconds)

Thanks I will try it out.

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsDatabasesMySQL Development > MySql Error Can't create a new thread (errno 11).?


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 4 hosted by Hostway