Problem in database

morteza3245

September 25, 2013 07:49

Hello i see much of following line in my error log mysql: /var/lib/mysql/Host.domain.com.err each day i have more than 500Line create like them. Please help me, what is do ? [QUOTE]130925 5:47:56 [ERROR] /usr/sbin/mysqld: Table './database3_wp/wp_wfHits' is marked as crashed and should be repaired 130925 5:47:57 [ERROR] /usr/sbin/mysqld: Table './database3_wp/wp_wfHits' is marked as crashed and should be repaired 130925 5:47:57 [ERROR] /usr/sbin/mysqld: Table './database3_wp/wp_wfHits' is marked as crashed and should be repaired 130925 5:47:57 [ERROR] /usr/sbin/mysqld: Table './database3_wp/wp_wfHits' is marked as crashed and should be repaired 130925 5:47:57 [ERROR] /usr/sbin/mysqld: Table './database3_wp/wp_wfHits' is marked as crashed and should be repaired 130925 5:47:57 [ERROR] /usr/sbin/mysqld: Table './database3_wp/wp_wfHits' is marked as crashed and should be repaired 130925 5:48:01 [ERROR] /usr/sbin/mysqld: Table './database3_wp/wp_wfHits' is marked as crashed and should be repaired 130925 5:48:03 [Note] Found 26651 of 26658 rows when repairing './database3_wp/wp_wfHits' 130925 5:50:11 [ERROR] /usr/sbin/mysqld: Table './database2_database2/td5ia_k2_items' is marked as crashed and should be repaired 130925 5:50:12 [ERROR] /usr/sbin/mysqld: Table './database2_database2/td5ia_k2_items' is marked as crashed and should be repaired 130925 5:50:12 [ERROR] /usr/sbin/mysqld: Table './database2_database2/td5ia_k2_items' is marked as crashed and should be repaired 130925 5:50:16 [Note] Found 20704 of 20708 rows when repairing './database2_database2/td5ia_k2_comments' 130925 5:59:52 [ERROR] /usr/sbin/mysqld: Table './database1_database1/nuke_antiflood' is marked as crashed and should be repaired 130925 5:59:52 [ERROR] /usr/sbin/mysqld: Table './database1_database1/nuke_session' is marked as crashed and should be repaired 130925 5:59:57 [ERROR] /usr/sbin/mysqld: Table './database1_database1/nuke_antiflood' is marked as crashed and should be repaired 130925 5:59:57 [ERROR] /usr/sbin/mysqld: Table './database1_database1/nuke_antiflood' is marked as crashed and should be repaired
Thanks for your Help.

Comments

8 comments

thinkbot

September 25, 2013 13:15
from command line run mysqlcheck -A --auto-repair or from phpmyadmin repair those tables
0
cPanelMichael

September 25, 2013 14:34
Hello :) Try repairing that database with a command such as: mysqlcheck --repair database1_database1
Thank you.
0
morteza3245

September 25, 2013 21:43
i see following error in some of table: [QUOTE]note : The storage engine for the table doesn't support repair database1_database1.td5ia_user_notes note : The storage engine for the table doesn't support repair database1_database1.td5ia_user_profiles note : The storage engine for the table doesn't support repair database1_database1.td5ia_user_usergroup_map note : The storage engine for the table doesn't support repair database1_database1.td5ia_usergroups note : The storage engine for the table doesn't support repair database1_database1.td5ia_users note : The storage engine for the table doesn't support repair database1_database1.td5ia_viewlevels note : The storage engine for the table doesn't support repair
what do i do? Thanks.
0
thinkbot

September 25, 2013 22:11
Those tables doesn't support that kind of repair, and probably don't need it, so ignore
0
morteza3245

September 25, 2013 22:38
i can transfer them to any type, for support repair? Thanks.
0
thinkbot

September 25, 2013 22:56
no need, couse they are not damaged they just don't support MyISAM type repair
0
morteza3245

September 25, 2013 23:00
Thanks, now i see following line: [QUOTE]130926 3:41:36 [ERROR] Got an error from thread_id=5369015, /home/rpmbuild/rpm-build/BUILD/mysql-5.5.32/mysql-5.5.32/storage/myisam/ha_myisam.cc:915 130926 3:41:36 [ERROR] MySQL thread id 5369015, OS thread handle 0x7f6d7cfae700, query id 961728564 localhost root Checking table CHECK TABLE `failures` 130926 3:41:54 [ERROR] Got an error from thread_id=5369015, /home/rpmbuild/rpm-build/BUILD/mysql-5.5.32/mysql-5.5.32/storage/myisam/ha_myisam.cc:915 130926 3:41:54 [ERROR] MySQL thread id 4946554, OS thread handle 0x7f6d7cc4f700, query id 961737449 localhost eximstats Waiting for table level lock INSERT INTO sends (mailtime,msgid,processed,domain,email,user,size,host,ip,auth,localsender,spamscore) VALUES(FROM_UNIXTIME('1380148913'),'1VOxmK-003CCO-NA$ 130926 3:41:54 [ERROR] MySQL thread id 5369015, OS thread handle 0x7f6d7cfae700, query id 961732568 localhost root Checking table CHECK TABLE `sends` 130926 3:42:06 [ERROR] MySQL thread id 5369015, OS thread handle 0x7f6d7cfae700, query id 961742787 localhost root Checking table CHECK TABLE `wp_commentmeta`
what i must do for this lines? Thanks.
0
cPanelMichael

September 26, 2013 13:49
That indicates some of the tables referenced may be corrupted. Please review the following documentation on repairing corrupted tables in MySQL: [url=http://dev.mysql.com/doc/refman/5.5/en/mysqlcheck.html]MySQL :: MySQL 5.5 Reference Manual :: 4.5.3 mysqlcheck Thank you.
0

Please sign in to leave a comment.

Comments

Didn't find what you were looking for?