tag:blogger.com,1999:blog-1471072446855788166.post3182489545200076416..comments2023-03-08T17:15:27.097+09:00Comments on 柴田(ひ)食堂: VirtualBoxのテストluky.orghttp://www.blogger.com/profile/17273806834102337860noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-1471072446855788166.post-91669106751667607832014-03-09T17:17:11.000+09:002014-03-09T17:17:11.000+09:00上記記事をpostしようとしたら、何度も「ログインできません」的なメッセージが出た(^^;。/var...上記記事をpostしようとしたら、何度も「ログインできません」的なメッセージが出た(^^;。<br>/var/log/mysql/error.logを見ると<br>140309 8:06:45 [ERROR] /usr/sbin/mysqld: Table './MT/mt_session' is marked as crashed and last (automatic?) repair failed<br>てな感じ(--;。<br>以下のようにしてリペア。<br>root@shibata-VirtualBox:/var/lib/mysql/MT# myisamchk mt_session.MYI<br>Checking MyISAM file: mt_session.MYI<br>Data records: 3394 Deleted blocks: 0<br>myisamchk: warning: Table is marked as crashed and last repair failed<br>- check file-size<br>myisamchk: warning: Size of indexfile is: 549888 Should be: 159744<br>- check record delete-chain<br>- check key delete-chain<br>- check index reference<br>- check data record references index: 1<br>myisamchk: error: Found 3178 keys of 3394<br>- check record links<br>myisamchk: error: Record-count is not ok; is 3178 Should be: 3394<br>myisamchk: warning: Found 33368 deleted space. Should be 0<br>myisamchk: warning: Found 404 deleted blocks Should be: 0<br>myisamchk: warning: Found 4591 key parts. Should be: 3178<br>MyISAM-table 'mt_session.MYI' is corrupted<br>Fix it using switch "-r" or "-o"<br>root@shibata-VirtualBox:/var/lib/mysql/MT# myisamchk -r mt_session.MYI<br>- recovering (with sort) MyISAM-table 'mt_session.MYI'<br>Data records: 3394<br>- Fixing index 1<br>- Fixing index 2<br>- Fixing index 3<br>- Fixing index 4<br>- Fixing index 5<br>Data records: 3178<br>上記後にpostで来ていました。<br>これはコメントの投稿テストも兼ねて書いておきます。<br>hishttp://hoop.euqset.org/archives/111483.htmlnoreply@blogger.com