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

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

Page generated in 0.050 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.