MySQL Bugs: #35693: #1040 - Too many connections error and Error 28

Bug #35693	#1040 - Too many connections error and Error 28 - Low disk space
Submitted:	31 Mar 2008 6:49	Modified:	30 Apr 2008 16:19
Reporter:	Ranju VS	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server: Errors	Severity:	S3 (Non-critical)
Version:	5.0.45	OS:	Linux
Assigned to:		CPU Architecture:	Any
Tags:	Error 1040, Error 28

Description:
I have a large database to manage inventory. The inventory list comes around 5.1 million.While fetching data from this table its taking quite long time. We got an error while trying to fetch out all the records.

Error 28  Low disk space. But later it was not seen.

As part of optimization, last week I tried to optimize the inventory table. In the middle of the process the MySql server went down. The MySql server was restarted but when I took PhpMyadmin I was getting the #1040 - Too many connections error.

How to repeat:
To Repeat Error 28.

Allocate the tmp partition a space of 450 mb. create a table with records greater than 5 million. Try to retrieve all the last 100 - 200 records.

To repeat Error 1040.

Try running the different query to alter, update. Try to optimize the table.

It may depend on the hardware used.

Suggested fix:
Allocate more space for tmp partition.

Thank you for the report.

Only wrong "Too many connections" error can be considered as MySQL bug. To check this login as root using mysql command line client and run query SHOW PROCESSLIST then problem occurs. Additionally version 5.0.45 is a bit old. Please upgrade to current verion 5.0.51a, try with it and if problem still exists provide error log file.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".