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

urgido

• January 16, 2017 17:56

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

  • January 16, 2017 23:02

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

  0
• 

  cPanelMichael

  • January 16, 2017 23:03

  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.

  0
• 

  urgido

  • January 17, 2017 00:52

  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@ [/]#
  

  0
• 

  cPanelMichael

  • January 18, 2017 19:28

  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.

  0
• 

  urgido

  • January 18, 2017 20:50

  Support Request ID is: 8141381

  0
• 

  cPanelMichael

  • January 20, 2017 16:47

  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.

  0
• 

  urgido

  • February 15, 2017 15:07

  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

  0
• 

  cPanelMichael

  • February 15, 2017 17:03

  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.

  0
• 

  urgido

  • February 15, 2017 19:54

  SOLVED! thanks

  0

Please sign in to leave a comment.