morteza3245

Well-Known Member
Sep 16, 2013
148
1
68
cPanel Access Level
Root Administrator
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 ?

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.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,202
363
Hello :)

Try repairing that database with a command such as:

Code:
mysqlcheck --repair database1_database1
Thank you.
 

morteza3245

Well-Known Member
Sep 16, 2013
148
1
68
cPanel Access Level
Root Administrator
i see following error in some of table:

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.
 

morteza3245

Well-Known Member
Sep 16, 2013
148
1
68
cPanel Access Level
Root Administrator
Thanks, now i see following line:

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.