The database was found down on 7/28/2022 morning.
After restarting the database server, sites went back to normal.
Also the file limit was increased to prevent or reduce the possibility of Database being shut down again.
A task page was set up to investigate the cause of high volume file open requests.
Study: Investigate the high volume file open requests (8/10/2022)
It was found that the high volume MySQL file open requests were from the database st5bu that frequently reaching the open file limit:
[root@host ~]# grep "220723" /var/log/mariadb/mariadb.log | head -n1 220723 3:22:39 [ERROR] mysqld: Can't open file: './st5bu/wp_links.frm' (errno: 24) [root@host ~]# grep "220724" /var/log/mariadb/mariadb.log | head -n1 220724 3:42:11 [ERROR] mysqld: Can't open file: './st5bu/wp_login_redirects.frm' (errno: 24)
And it’s suspected that it could come from either study.fivebranches.edu
or eva.study.fivebranches.edu
The database st5bu was found beloging to the study.fivebranches.edu site. (8/2/2022)
Check it out from this Screenshot
1 thought on “Resolve the database server down issue”
This task is closed, and a new task page was set up to investigate the cause of high volume file open requests.
Study: Investigate the high volume file open requests (check the link above)