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


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