SOLVED Table './eximstats/sends' is marked as crashed

[urgido]

I have a problem with eximstats DB.

I RAN: /usr/local/cpanel/bin/updateeximstats
RESULT:

mysqldiff failed: El comando â/usr/local/cpanel/3rdparty/perl/522/bin/mysqldiffâ
O utput was: mysqldump failed. Exit status: 2:
mysqldump: Got error: 144: Table './eximstats/sends' is marked as crashed and la st (automatic?) repair failed when using LOCK TABLES

-- MySQL dump 10.13 Distrib 5.5.52, for Linux (x86_64)

--

-- Host: localhost Database: eximstats

-- ------------------------------------------------------

-- Server version 5.5.52-cll



/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8 */;

/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;

/*!40103 SET TIME_ZONE='+00:00' */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

At this moment the problem still present so, I go to WHM interface and here is what I got:

Repairing eximstats
eximstats.defers OK
eximstats.failures OK
eximstats.sends
error : Can't create new tempfile: './eximstats/sends.TMD'
status : Operation failed
eximstats.smtp OK

Done.

As you see the problem is not solved, any clue?
Bless

 

[urgido]

I tried to follow the steps posted on SOLVED - Database Error: Table './eximstats/sends but no luck

 

[cPanelMichael]

error : Can't create new tempfile: './eximstats/sends.TMD'

Hello,

This topic is discussed on the following thread:

exim stats failing, can't run mail reports

Thank you.

 

[urgido]

root@ [/]# myisamchk -r -f sends.MYI
myisamchk: error: File 'sends.MYI' doesn't exist
root@ [/]# mysqlcheck --repair eximstats
eximstats.defers OK
eximstats.sends
error : Can't create new tempfile: './eximstats/sends.TMD'
status : Operation failed
eximstats.smtp OK
root@ [/]#

 

[cPanelMichael]

Hello,

Could you open a support ticket using the link in my signature so we can take a closer look? You can post the ticket number here so we can update this thread with the outcome.

Thank you.

 

[urgido]

Support Request ID is: 8141381

 

[cPanelMichael]

To update, the issue was addressed by moving the SENDS.MYI file out of the way and then running the following command with MySQL stopped:

myisamchk -r /var/lib/mysql/eximstats/sends.MYI

Thank you.

 

[urgido]

New error:

myisamchk -r /var/lib/mysql/eximstats/sends.MYI
- recovering (with sort) MyISAM-table '/var/lib/mysql/eximstats/sends.MYI'
Data records: 3619
myisamchk: error: Can't create new tempfile: '/var/lib/mysql/eximstats/sends.TMD'
MyISAM-table '/var/lib/mysql/eximstats/sends.MYI' is not fixed because of errors
Try fixing it by using the --safe-recover (-o), the --force (-f) option or by not using the --quick (-q) flag

 

[cPanelMichael]

myisamchk: error: Can't create new tempfile: '/var/lib/mysql/eximstats/sends.TMD'

Please verify if you have tried dropping and rebuilding the entire eximstats database using the instructions on the following thread:

exim stats failing, can't run mail reports

Thank you.

 

[urgido]

SOLVED! thanks