Mysql 提示錯誤

標籤：

在登陸umail時.登陸某一個使用者.有出現下面的錯誤提示.

Fatal error:  Uncaught exception ‘PDOException‘ with message ‘SQLSTATE[HY000]: General error: 145 Table ‘./umail/wm_statistics‘ is marked as crashed and should be repaired‘ in /usr/local/u-mail/data/www/webmail/admin/lib/UMail/BaseDB.php:0Stack trace:#0 /usr/local/u-mail/data/www/webmail/admin/lib/UMail/BaseDB.php(0): PDOStatement->execute()#1 [internal function]: UMail\BaseDB->callGetone(‘wm_statistics‘, ‘mailbox_id‘, ‘domain_id = :do...‘, Array, 0)#2 /usr/local/u-mail/data/www/webmail/admin/lib/UMail/BaseDB.php(0): call_user_func_array(Array, Array)#3 /usr/local/u-mail/data/www/webmail/admin/lib/Webmail.php(0): UMail\BaseDB->__call(‘getone_statisti...‘, Array)#4 /usr/local/u-mail/data/www/webmail/admin/lib/Webmail.php(0): Webmail->getone_statistics(‘mailbox_id‘, ‘domain_id = :do...‘, Array, 0)#5 /usr/local/u-mail/data/www/webmail/admin/lib/Webmail.php(0): Webmail->getStatisticsByID(‘1‘, ‘239‘, ‘mailbox_id‘, 0)#6 /usr/local/u-mail/data/www/webmail/module/default/program/o_user.php(0): Webmail->setLastLoginStat(‘1‘ in /usr/local/u-mail/data/www/webmail/admin/lib/UMail/BaseDB.php on line 0

經檢查,是表的問題所導致的.

尋找. 需要修複下表的索引即可.既MYI檔案.

最終解決辦法:

[[email protected] bin]# ./myisamchk -c -r /usr/local/u-mail/data/mysql/default/umail/wm_statistics.MYI
Warning: Using unique option prefix read_buffer instead of read_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
Warning: Using unique option prefix write_buffer instead of write_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
- recovering (with sort) MyISAM-table ‘/usr/local/u-mail/data/mysql/default/umail/wm_statistics.MYI‘
Data records: 95
- Fixing index 1
[[email protected] bin]# pwd
/usr/local/u-mail/service/mysql/bin
[[email protected] bin]# 

再次嘗試登陸.恢複正常.

Mysql 提示錯誤