New structures, the database, the application after connecting up, with the following process:
120528 10:07:32 [ERROR]/usr/local/mysql/bin/mysqld: Can ‘t open file:./ag4_1/raa4_1 FRM’ (24) errno:
I didn’t look at the error code carefully at first! Thought the file was corrupted, reimport! Throw the above error again!
Use the perl error tool to see specific errors!
Linux:/usr/local/mysql/bin #./perror 24
OS error code 24: Too many open files
beyond the maximum number of open file limit! 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’; show variables like ‘open_files_limit’;
>
Reproduced in: https://blog.51cto.com/imysqldba/883374
Read More:
- mysqldump: Got error: 1016: Can’t open file: ‘./xxx.frm’ (errno: 24) when using LOCK TABLES
- Error in startup after the supervisor modifies the configuration file: error: cannot open an HTTP server: socket.error reported errno.eaddnotavail
- Error in header file when calling OpenGL to open obj file in vs2013: unable to open include file: “GL / glut. H”: no such file or directories
- ImportError: libcudnn.so.7: cannot open shared object file: No such file or directory
- Cannot open include file: ‘io.h‘: No such file or directory
- Importerror of [docker] error: libGL.so .1: cannot open shared object file: No such file or directory
- Win10 vs 2017 prompt cannot open include file: “windows. H”: no such file or director
- VS2010 compiler can’t open include file: “GL / glaux. H”: no such file or directory
- When Python Django creates a database, can’t open file ‘ manage.py ‘: [Errno 2] No such file or directory
- Solution of vs unable to open source file and link library file
- In VS2010, the compiler cannot open the file “GL / glaux. H”: no such file or directory
- #During OpenGL development, fatal error C1083: can’t open include file: “GL / glut. H”: no such file or directory
- Problem solving: importerror: libcublas.so .9.0: cannot open shared object file: No such file
- OSError: libnccl.so.2: cannot open shared object file: No such file or directory
- Vs fatal error C1083: unable to open include file: “sys / socket. H”: no such file
- Vs2017 cannot open the source file “XXX. H” by adding a file name after creating a new class
- How to solve the problem of “unable to open include file:” graphics. H “: no such file or directory”
- Panda was unable to open the. Xlsx file, xlrd.biffh.XLRDError : Excel xlsx file； not supported
- error while loading shared libraries: libpng16.so.16: cannot open shared object file: No such file
- error while loading shared libraries: libstdc++.so.6: cannot open shared object file: No such file o