2025年 4月5日(土) 08:03 JST

mysql upgrade時の問題

  • 2011年10月31日(月) 10:01 JST
  • 投稿者:
  • 表示回数 149

結構前からの問題だが、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