Error from delivery reporter: DBD::mysql::db selectall_arrayref failed

There are various error reports which are sent to your inbox by cpanel server regarding status of your server. One fine day, I got error report as follows:

Error from delivery reporter: DBD::mysql::db selectall_arrayref failed: Table ‘./eximstats/sends’ is marked as crashed and should be repaired

I have tried lot of ways to fix this issue, unfortunately none of them work. So, I started investigating it myself and found a simple solution for this issue.

First you will have to login to the server with root user, then follow below mentioned steps.
This is an easy fix. If you are not unfamiliar with root, please do not try this.

Run the following command

mysqlcheck —repair eximstats

Once you run the command you will get long lines with following content.

status : Operation failed

This indicates that the database cannot be repaired and you will need to create a new database.
To create new database, run following commands in order.

mysql
use eximstats;
drop table failures;
/usr/local/cpanel/bin/updateeximstats

This should fix your issue. What that last line of code will do is fix the database scheme just because you just dropped the failed table.

Leave a Reply