MySQL Bugs: #44147: SQL Database error

Bug #44147	SQL Database error
Submitted:	8 Apr 12:02	Modified:	8 May 14:19
Reporter:	Nick Yates
Status:	No Feedback
Category:	Server: Errors	Severity:	S2 (Serious)
Version:	5.1	OS:	Microsoft Windows (Server 2003)
Assigned to:		Target Version:

Description:
We use MySQL Server 5.1 on our website hosting server and today we had a phonecall saying
that our client's website was down. The website was displaying a SQL database error and
was unable to connect to the SQL database.

I have checked through the event logs and found a few warnings:

Changed limits: max_open_files: 2048  max_connections: 735  table_cache: 651

Server variable data_file_path of plugin InnoDB was forced to be read-only: string
variable without update_func and PLUGIN_VAR_MEMALLOC flag

And then the following error:

Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist

After rebooting the server the SQL databases were accessable again but it's a bit
worrying that this happened, is there any insight into this what this problem is or what
can be done to resolve it?

Thanks for any help.

Nick

How to repeat:
?

Thank you for the bug report. Duplicate of bug: http://bugs.mysql.com/bug.php?id=24509.

Could you please try to track if actually you are reaching that file descriptor limit.
Thanks in advance.

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".