分类： Mysql/postgreSQL
2009-04-20 21:40:40
mysqldump: Error 1194: Table 'searchindex' is marked as crashed and should be repaired when dumping table `searchindex` at row: 550
# mysqlcheck --all-database -uroot -p
Enter password:
mysql.columns_priv OK
mysql.db OK
mysql.func OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.host OK
mysql.proc OK
mysql.procs_priv OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.user OK
wikidb.archive OK
wikidb.categorylinks OK
wikidb.externallinks OK
wikidb.filearchive OK
wikidb.hitcounter
note : The storage engine for the table doesn't support check
wikidb.image OK
wikidb.imagelinks OK
wikidb.interwiki OK
wikidb.ipblocks OK
wikidb.job OK
wikidb.langlinks OK
wikidb.logging OK
wikidb.math OK
wikidb.objectcache OK
wikidb.oldimage OK
wikidb.page OK
wikidb.page_restrictions OK
wikidb.pagelinks OK
wikidb.protected_titles OK
wikidb.querycache OK
wikidb.querycache_info OK
wikidb.querycachetwo OK
wikidb.recentchanges OK
wikidb.redirect OK
wikidb.revision OK
wikidb.searchindex
warning : 3 clients are using or haven't closed the table properly
error : Wrong bytesec: 41-115-113 at linkstart: 100039100
error : Corrupt
wikidb.site_stats OK
wikidb.templatelinks OK
wikidb.text OK
wikidb.trackbacks OK
wikidb.transcache OK
wikidb.user OK
wikidb.user_groups OK
wikidb.user_newtalk OK
wikidb.watchlist OK
#
无效
现象：
发生数据库查询语法错误。可能是由于软件自身的错误所引起。最后一次数据库查询指令是:
(SQL查询已隐藏)
来自于函数 "SearchMySQL4::update"。 MySQL返回错误 "145: Table './wikidb/searchindex' is marked as crashed and should be repaired (127.0.0.1)"。
# mysqldump --all-databases -p >202119.sql
Enter password:
mysqldump: Got error: 145: Table './wikidb/searchindex' is marked as crashed and should be repaired when using LOCK TABLES
#
# mysqlcheck -uroot -p -f /var/mysql/wikidb/searchindex.MYI
Enter password:
mysqlcheck: Got error: 1102: Incorrect database name '/var/mysql/wikidb/searchindex.MYI' when selecting the database
#
处理:
# mysqlcheck -uroot -p --auto-repair wikidb
Enter password:
wikidb.archive OK
wikidb.categorylinks OK
wikidb.externallinks OK
wikidb.filearchive OK
wikidb.hitcounter
note : The storage engine for the table doesn't support check
wikidb.image OK
wikidb.imagelinks OK
wikidb.interwiki OK
wikidb.ipblocks OK
wikidb.job OK
wikidb.langlinks OK
wikidb.logging OK
wikidb.math OK
wikidb.objectcache OK
wikidb.oldimage OK
wikidb.page OK
wikidb.page_restrictions OK
wikidb.pagelinks OK
wikidb.protected_titles OK
wikidb.querycache OK
wikidb.querycache_info OK
wikidb.querycachetwo OK
wikidb.recentchanges OK
wikidb.redirect OK
wikidb.revision OK
wikidb.searchindex
warning : Table is marked as crashed
warning : 3 clients are using or haven't closed the table properly
error : Wrong bytesec: 41-115-113 at linkstart: 100039100
error : Corrupt
wikidb.site_stats OK
wikidb.templatelinks OK
wikidb.text OK
wikidb.trackbacks OK
wikidb.transcache OK
wikidb.user OK
wikidb.user_groups OK
wikidb.user_newtalk OK
wikidb.watchlist OK
Repairing tables
wikidb.searchindex
info : Wrong bytesec: 41-115-113 at 100039100; Skipped
warning : Number of rows changed from 10198 to 10197
status : OK
#
#
