How to check for corrupted databases

This template is in trial mode. Please do not use this template unless you have been authorized to do so by your Supervisor. Thanks!

Ticket Subject(s)

(paste the subject of the ticket here. upon adding the 4th ticket subject, submit article For Review after editing)

• mysql

• MySQL Database responsiveness very slow in cPanel

• unable to check database 

• concert roundcube to sqlite

Customer Request Summary

(in a sentence or two, describe the issue from the perspective of the customer)

• I have fixed the corruption on some of my databases. How can I check to ensure that the corruption is in fact fixed?

• Steps:

1. visit https://icon.seaspotmediagroup.com:2083/
2. Login to cPanel as user 'smg' user. password
3. Click to  "MySQL Databases» https://icon.seaspotmediagroup.com:2083/cpsess4900544521/frontend/jupiter/sql/index.html
4. Observe the extremely delayed loading time

• When checking a database in cPanel this is returned:

There was a problem checking the database “act4can_cividb”. The request failed. (Error ID: 3bbff8) Ask your hosting provider to research this error in cPanel & WHM’s main error log.

• [placeholder for next ticket we get about this issue]

Workarounds

(if no known workaround or no change to the existing workaround, simply link to the source ticket with a brief note such as "no workaround")

• https://cpanel.zendesk.com/agent/tickets/94425210 - restart the database or use mysqlcheck

• https://cpanel.zendesk.com/agent/tickets/95054184- ran mysqlcheck

• https://cpanel.zendesk.com/agent/tickets/95367369 - Checking the database in cPanel took a while to complete and eventually failed with:

There was a problem checking the database “act4can_cividb”. The request failed. (Error ID: 3bbff8) Ask your hosting provider to research this error in cPanel & WHM’s main error log.

This was logged:

# tail -f -n0 !$
tail -f -n0 /usr/local/cpanel/logs/error_log
Cpanel::Exception/(XID yb9xhd) PID 907530: The cPanel Server operation timed out at cpsrvd.pl line 669.
...propagated at /usr/local/cpanel/Cpanel/Admin/Base.pm line 770.

The database being checked was quite large, at 20GB. Due to size of database and since the cPanel hardcoded timeout can not be changed, I recommended using mysqlcheck on command-line instead of using cPanel interface.

• #95368385 How to check the mysql database. ; provided mysqlcheck

Links to relevant information or resources

(optional and no restrictions on sources)

• https://dev.mysql.com/doc/refman/8.0/en/mysqlcheck.html

• [placeholder for source link]

• [placeholder for source link]

• [placeholder for source link]