Contributed by: akira on 2011年10月31日(月) 10:01 JST
Last modified on
結構前からの問題だが、mysql再起動時に、このエラー(警告)が消えてない。
Checking for corrupt, not cleanly closed and upgrade needing tables..
どの、databaseのことを言っているのか分かれば良いのだが。
試しに、データベース内でInnoDBとMyISAMストレージエンジンが混在している物を統一してみる。
cms(cmsmadesimple)は成功、Concrete5は、テーブル名 PageSearchIndexに於いて失敗
"The used table type doesn't support FULLTEXT indexes"
InnoDBはFULLTEXTのインデックスはサポートしないとの事、それではどうするのか？
そもそも、Concrete5はInnoDBで動くのか、という情報が見つからない。
# myisamchk */*.MYI > /tmp/checkdb
STDERRはでるが、チェックのたびに変わる。
最終的には、scuttle/sc_searchhistory.MYIだけ。
myisamchk: warning: 2 clients are using or haven't closed the table properly
MyISAM-table 'cms/cms_siteprefs.MYI' is usable but should be fixed
myisamchk: warning: 1 client is using or hasn't closed the table properly
MyISAM-table 'concrete/PageStatistics.MYI' is usable but should be fixed
myisamchk: warning: 1 client is using or hasn't closed the table properly
MyISAM-table 'geeklog/gl_blocks.MYI' is usable but should be fixed
myisamchk: warning: 1 client is using or hasn't closed the table properly
MyISAM-table 'geeklog/gl_sessions.MYI' is usable but should be fixed
myisamchk: warning: 1 client is using or hasn't closed the table properly
MyISAM-table 'geeklog/gl_stories.MYI' is usable but should be fixed
myisamchk: warning: 1 client is using or hasn't closed the table properly
MyISAM-table 'geeklog/gl_syndication.MYI' is usable but should be fixed
myisamchk: warning: 1 client is using or hasn't closed the table properly
MyISAM-table 'geeklog/gl_tokens.MYI' is usable but should be fixed
myisamchk: warning: 1 client is using or hasn't closed the table properly
MyISAM-table 'geeklog/gl_vars.MYI' is usable but should be fixed
myisamchk: warning: 3 clients are using or haven't closed the table properly
MyISAM-table 'scuttle/sc_searchhistory.MYI' is usable but should be fixed