Bug #44147 SQL Database error
Submitted: 8 Apr 2009 10:02 Modified: 8 May 2009 12:19
Reporter: Nick Yates Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Errors Severity:S2 (Serious)
Version:5.1 OS:Windows (Server 2003)
Assigned to: CPU Architecture:Any

[8 Apr 2009 10:02] Nick Yates 
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:
?
[8 Apr 2009 11:41] MySQL Verification Team 
Thank you for the bug report. Duplicate of bug: http://bugs.mysql.com/bug.php?id=24509.
[8 Apr 2009 12:19] MySQL Verification Team 
Could you please try to track if actually you are reaching that file descriptor limit. Thanks in advance.
[8 May 2009 23:00] Bugs System 
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".