After moving my sites to WordOps this past week, I have observed that my database restarts multiple times a day.
I enabled Error logging and I could see the following:
2021-07-25 3:43:46 8 [ERROR] mariadbd: Table './site_com_3EbfsIqU/wp_posts' is marked as crashed and should be repaired
2021-07-25 3:43:46 8 [Warning] Checking table: './site_com_3EbfsIqU/wp_posts'
2021-07-25 3:43:46 0 [Note] InnoDB: Buffer pool(s) load completed at 210725 3:43:46
2021-07-25 3:43:47 12 [ERROR] mariadbd: Table './site_com_3EbfsIqU/wp_postmeta' is marked as crashed and should be repaired
2021-07-25 3:43:47 12 [Warning] Checking table: './site_com_3EbfsIqU/wp_postmeta'
2021-07-25 3:43:47 9 [ERROR] mariadbd: Table './site_com_3EbfsIqU/wp_term_relationships' is marked as crashed and should be repaired
2021-07-25 3:43:47 9 [Warning] Checking table: './site_com_3EbfsIqU/wp_term_relationships'
2021-07-25 3:55:08 528 [ERROR] mariadbd: Table './site_com_3EbfsIqU/wp_users' is marked as crashed and should be repaired
2021-07-25 3:55:08 528 [Warning] Checking table: './site_com_3EbfsIqU/wp_users'
2021-07-25 4:01:08 577 [Warning] Aborted connection 577 to db: 'site_com_3EbfsIqU' user: 'sitecomB4SQ' host: 'localhost' (Got an error reading communication packets)
2021-07-25 4:05:16 1010 [ERROR] mariadbd: Table './site_com_3EbfsIqU/wp_usermeta' is marked as crashed and should be repaired
2021-07-25 4:05:16 1010 [Warning] Checking table: './site_com_3EbfsIqU/wp_usermeta'
I checked those tables with WP CLI as well as with PHPMyadmin and even manually repaired them.
A few hours later, the database is restarted automatically with the same pattern of Errors.
Please any ideas to resolve this?