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

urgido

Well-Known Member
Jul 19, 2005
129
10
168
cPanel Access Level
Root Administrator
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

Well-Known Member
Jul 19, 2005
129
10
168
cPanel Access Level
Root Administrator
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

Administrator
Staff member
Apr 11, 2011
47,880
2,270
463
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.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,880
2,270
463
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:

Code:
myisamchk -r /var/lib/mysql/eximstats/sends.MYI
Thank you.
 
  • Like
Reactions: urgido

urgido

Well-Known Member
Jul 19, 2005
129
10
168
cPanel Access Level
Root Administrator
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

Administrator
Staff member
Apr 11, 2011
47,880
2,270
463
  • Like
Reactions: urgido