RE: Cannot Connect: Can't create a new thread (errno 11)

Hi Alex,  

You mean in the user table, right? max_questions, max_updates and max_connections are all set to 0 for all accounts.  

Can you think of anything else?  

Thanks
-Chris

From: alex.lurthu@gmail.com on behalf of Alex Arul Lurthu Sent: Thu 7/5/2007 2:03 AM
To: cfaust-dougot
Cc: mysql@lists.mysql.com
Subject: Re: Cannot Connect: Can't create a new thread (errno 11)

Chris,

Did you check if there are any user level MAX_USER_CONNECTIONS restriction set while granting access ?

Thanks
Alex

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek

On 7/4/07, Chris Faust <cfaust@doyougot.com> wrote:

        Folks,                           

	I'm wondering is someone could help us in trying to resolve the above error,
	we have read through what threads we could find and tried all the
	suggestions, but have had no luck.
	
	
	
	There are no memory problems, in fact when this happens if there is still a 
	localhost client connection to the server you can do whatever you want,
	everything is running normal. It just refuses all new connections. When it
	happens there is plenty of memory on the machine and no load at all 
	(everything is running just as it should). Once things fall below 90,
	everything comes back.
	
	
	
	The problem happens when the process list hits the 91st process every time.
	90 processes, no problems, the 91st process/connection gets the above error 
	and any after that simple gets "Can't connect to MySQL server".
	
	
	
	We've tried all the obvious things, messing with the number of connections,
	open files etc. Nothing seems to work.
	
	
	
	We are running MySQL 5 on Centos 5 (flavor of RedHat). The machine is
	dedicated to MySQL.
	
	
	
	Below is a link to a text file that shows the OS limits for the mysql
	account on the machine and the output from show variables (including it made 
	the message to large for the list).
	
	
	
	
http://208.3.90.212/wtresults.txt
	
	
	
	If anyone has any suggestions, it would be appreciated.
	
	
	
	Thanks!