Array
(
[message] => _doQuery: [Error message: Could not execute statement]
[Last executed query: ALTER TABLE aaa_srch_post_back RENAME TO aaa_srch_post;]
[Native code: 144]
[Native message: Table ‘./search/aaa_srch_post_back’ is marked as crashed and last (automatic?) repair failed]
=> 256
)

表示されたエラーコードによって、対応の仕方が違う。
126 = Index file is crashed / Wrong file format
127 = Record-file is crashed
132 = Old database file
134 = Record was already deleted (or record file crashed)
135 = No more room in record file
136 = No more room in index file
141 = Duplicate unique key or constraint on write or update
144 = Table is crashed and last repair failed
145 = Table was marked as crashed and should be repaired
135,136の場合は、
ALTER TABLE table MAX_ROWS=xxx AVG_ROW_LENGTH=yyy;
が有効。
その他のエラーは、
REPAIR TABLE tableName;

http://life1204.blogspot.com/2008_07_01_archive.html

コメントを残す