Resolve the database server down issue

Status: 

Closed

Priority: 

N/A

Test URL(s):

References:

Request(s):

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”

  1. 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)

Leave a Comment