Error: Unable to open database files while the database is running.
One, the problem report error two, the solution idea three, the treatment method
First, the problem report error
Can’t open file (errno:24)
Second, the solution
First we need to look at the error log of the database. Then determine whether the table is corrupt or a permission problem. There may also be insufficient disk space to properly access the table; Operating system limitations are also a concern; Use the perl error tool to see specific errors!
linux:/usr/local/mysql/bin # ./perror 24
OS error code 24: Too many open files
Maximum number of open files exceeded! The maximum number of open files on the system is 65535. It cannot be exceeded! The maximum number of open files in the database must be out of limit! Show variables like ‘open_files_limit’; MySQL> reset MySQL = 2048; MySQL> reset MySQL = 2048;
Three, the treatment method
repair table ;
chown mysql Permissions
Clean up junk data from the disk
Read More:
- RECEIVED ERROR PACKET: ERRNO = 1236, SQLSTATE = HY000 ERRMSG = COULD NOT FIND FIRST LOG FILE NAME IN BINARY LOG INDEX FILE
- Zabbix import MySQL database error ERROR 1046 (3D000) at line 1: No database selected
- Centos7 Initialize mysql Error: Could not open file ‘/usr/local/mysql/log/mysqld.log‘ for error logging: Per
- [Linux Docker Mirror] MYSQL Run sql Script Error: Failed to open file ‘/home/mydatabase.sql‘, error: 2
- How to Fix MySQL error 1005: can’t create table (errno: 150)
- MySQL installation error: error while loading shared libraries: libaio.so .1: cannot open shared object file: No such
- [Solved] C# connecting to MySQL database reports an error
- [Solved] Error 1044: Access denied for user ‘syz-remote‘@‘%‘ to database ‘webapp‘
- Oracle Database AWR error: ORA-06502 [How to Solve]
- [Solved] Connections could not be acquired from the underlying database
- scm_prepare_database.sh CDH initial data script execute error
- How to Solve MYSQL Error: Failed to start MySQL 8.0 database server
- [Solved] Daily further: database error: unknown column ‘model’ in ‘field list‘
- C# System.Data.SQLite.SQLiteException:“SQL logic error or missing database no such table: XX”
- mysql workbench Error Code: 1046. No database selected Select the default DB to be used by doubl
- IDEA Database Tool connects to SQL Server 2008 Error [How to Solve]
- [Solved] Red hat 7.9 install DM8 of Damon database and starting graphical error with xmanager enterprise 5
- [Solved] com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server.
- IDEA maven Config MYSQL Connection Error: Could not create connection to database server.
- Remote connection to MySQL database error: is not allowed to connect to this MYSQL server solution