مشکل Cpanel ممنون می شم راهنمایی کنید

[AhrimanSefid]

سلام
مشکل این ارورر هاست :

160629 04:47:12 mysqld_safe mysqld from pid file /var/lib/mysql/static.clients.your-server.de.pid ended
160629 04:48:45 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160629  4:48:45 [Note] /usr/sbin/mysqld (mysqld 5.5.50-cll) starting as process 2123 ...
160629  4:48:45 [Note] Plugin 'FEDERATED' is disabled.
160629  4:48:46 InnoDB: The InnoDB memory heap is disabled
160629  4:48:46 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160629  4:48:46 InnoDB: Compressed tables use zlib 1.2.3
160629  4:48:46 InnoDB: Using Linux native AIO
160629  4:48:46 InnoDB: Initializing buffer pool, size = 128.0M
160629  4:48:46 InnoDB: Completed initialization of buffer pool
160629  4:48:46 InnoDB: highest supported file format is Barracuda.
160629  4:48:47  InnoDB: Waiting for the background threads to start
160629  4:48:48 InnoDB: 5.5.50 started; log sequence number 7864001731
160629  4:48:48 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
160629  4:48:48 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
160629  4:48:48 [Note] Server socket created on IP: '0.0.0.0'.
160629  4:48:48 [Note] Event Scheduler: Loaded 0 events
160629  4:48:48 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.50-cll'  socket: '/var/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
160629  4:49:32 [ERROR] /usr/sbin/mysqld: Table './eximstats/failures' is marked as crashed and should be repaired
160629  4:49:32 [ERROR] /usr/sbin/mysqld: Table './eximstats/defers' is marked as crashed and should be repaired
160629  4:49:33 [ERROR] /usr/sbin/mysqld: Table './eximstats/failures' is marked as crashed and should be repaired
160629  4:49:33 [ERROR] /usr/sbin/mysqld: Table './eximstats/defers' is marked as crashed and should be repaired
160629  4:49:37 [ERROR] /usr/sbin/mysqld: Table './eximstats/defers' is marked as crashed and should be repaired
160629  4:49:49 [ERROR] /usr/sbin/mysqld: Table './eximstats/defers' is marked as crashed and should be repaired
160629  4:49:49 [ERROR] /usr/sbin/mysqld: Table './eximstats/failures' is marked as crashed and should be repaired
160629  4:49:58 [ERROR] /usr/sbin/mysqld: Table './eximstats/defers' is marked as crashed and should be repaired
160629  4:49:59 [ERROR] /usr/sbin/mysqld: Table './eximstats/defers' is marked as crashed and should be repaired
160629  4:50:03 [ERROR] /usr/sbin/mysqld: Table './eximstats/defers' is marked as crashed and should be repaired
160629  4:50:04 [ERROR] /usr/sbin/mysqld: Table './eximstats/defers' is marked as crashed and should be repaired
160629  4:50:05 [ERROR] /usr/sbin/mysqld: Table './eximstats/defers' is marked as crashed and should be repaired
160629  4:50:22 [ERROR] /usr/sbin/mysqld: Table './eximstats/defers' is marked as crashed and should be repaired
160629  4:50:22 [ERROR] /usr/sbin/mysqld: Table './eximstats/failures' is marked as crashed and should be repaired
160629  4:50:37 [ERROR] /usr/sbin/mysqld: Table './eximstats/defers' is marked as crashed and should be repaired
160629  4:50:53 [ERROR] /usr/sbin/mysqld: Table './eximstats/defers' is marked as crashed and should be repaired
160629  4:50:53 [ERROR] /usr/sbin/mysqld: Table './eximstats/failures' is marked as crashed and should be repaired
160629  4:51:03 [ERROR] /usr/sbin/mysqld: Table './eximstats/defers' is marked as crashed and should be repaired
160629  4:51:09 [ERROR] /usr/sbin/mysqld: Table './eximstats/defers' is marked as crashed and should be repaired
160629  4:51:27 [ERROR] /usr/sbin/mysqld: Table './eximstats/defers' is marked as crashed and should be repaired
160629  4:51:42 [ERROR] /usr/sbin/mysqld: Table './eximstats/defers' is marked as crashed and should be repaired
160629  4:51:58 [ERROR] /usr/sbin/mysqld: Table './eximstats/defers' is marked as crashed and should be repaired
160629  4:52:03 [ERROR] /usr/sbin/mysqld: Table './eximstats/defers' is marked as crashed and should be repaired
160629  4:52:15 [ERROR] /usr/sbin/mysqld: Table './eximstats/defers' is marked as crashed and should be repaired
160629  4:52:30 [ERROR] /usr/sbin/mysqld: Table './eximstats/defers' is marked as crashed and should be repaired
160629  4:52:30 [ERROR] /usr/sbin/mysqld: Table './eximstats/failures' is marked as crashed and should be repaired

[hegza]

mysqlcheck --repair eximstats 

[AhrimanSefid]

بله زدم.

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

[hegza]

بله زدم.

خروجی دو کد زیر رو بدین

df -h
df -i 

[AhrimanSefid]

این هم از این.

/dev/mapper/VolGroup-lv_root
485G 20G 441G 5% /
tmpfs 7.8G 0 7.8G 0% /dev/shm
/dev/sda1 477M 67M 385M 15% /boot
/usr/tmpDSK 4.0G 137M 3.7G 4% /tmp

Filesystem Inodes IUsed IFree IUse% Mounted on
/dev/mapper/VolGroup-lv_root
32125920 675781 31450139 3% /
tmpfs 2041756 1 2041755 1% /dev/shm
/dev/sda1 128016 46 127970 1% /boot
/usr/tmpDSK 262144 165 261979 1% /tmp

[AhrimanSefid]

خوب الان باید چی کار کنم؟
ممنون می شم پاسخ بدین.

[Yas-Host]

eximstats یک ابزار بدرد نخور برای سرور های هاستینگ است! طبق تجربه بهتر است از قسمت Service manager آن را غیرفعال و دیتابیس آن را از phpmyadmin روت WHM حذف بفرمایید.

[hegza]

ضمن تائید گفته های جناب سنجری
و البته اگر اصرار دارید به استفاده اون دو تیبل مورد دار رو حذف و مجدد آپدیت کنید

[AhrimanSefid]

چطوری این کار باید انجام بشه؟

[hegza]

چطوری این کار باید انجام بشه؟

ابتدا دو دستور زیر رو بزنید

 myisamchk -r -f sends.MYI
myisamchk -r -f smtp.TMD

و بعد از اون

mysqlcheck --repair eximstats

- - - Updated - - -

و البته هم میتونید از phpmyadmin این دو تیبل رو خالی کنید و یا از اونجا ترمیم و باز سازی رو انجام بدین

- - - Updated - - -

اینم دیتا بیس خام eximstats که میتونید از phpmyadmin ایمپورت کنید. با اینکه با دستورات قبلی مشکلتون حل میشه . ولی ممکنه بعدا کسانی به مشکل بخورند و دسترسی ssh نداشته باشند.