mysql:11891
From: "T.Sasaki" <"T.Sasaki" <papasan2000@xxxxxxxxxx>>
Date: 5 Aug 2005 12:44:18 +0900
Subject: [mysql 11891] Re: REPAIR TABLE¤Ç¤Î¥¨¥é¡¼¤Ë¤Ä¤¤¤Æ
º´¡¹ÌڤǤ¹¡£ Ⱦ¤ÐÆȤê¸À¤Ç¤¹¡¦¡¦¡¦¡£ > Ä´¤Ù¤Æ¤Ï¤¤¤ë¤Î¤Ç¤¹¤¬¡¢¤É¤ÎÀßÄ꤬±Æ¶Á¤¹¤ë¤Î¤«¤òÁ´ÉôÄɤ¤¤¤ì¤º¤Ë¤¤¤Þ¤¹¡£ > OS Ū¤Ë¤Ï½½Ê¬¤¹¤®¤ë¤Û¤É¶õ¤¤¤Æ¤¤¤Þ¤¹¤Î¤Ç¡¢my.cnf ¤òµ¿¤Ã¤Æ¤¤¤Þ¤¹¡£ ·ï¤Î¥¨¥é¡¼¤Ï myisamchk() -> mi_repair() ¤«¤é¸Æ¤Ð¤ì¤ë sort_get_next_record() ¤È¤¤¤¦ ´Ø¿ôÆâ¤ÇȯÀ¸¤·¤Æ¤¤¤ë¤Î¤Ç¡¢¥½¡¼¥È½èÍý¤Ë»ÈÍѤ¹¤ë¥Ð¥Ã¥Õ¥¡¡¢ ¤â¤·¤¯¤Ï¤½¤ì¤ò´Þͤ¹¤ë¥Ñ¥é¥á¡¼¥¿¤Ç¤·¤ç¤¦¤«¡¦¡¦¡¦¡£ ¤³¤³¤Ë¿§¡¹¾è¤Ã¤Æ¤Þ¤¹¤Í¡£:-) http://dev.mysql.com/doc/mysql/ja/show-variables.html "SUGIMURA Takashi ¿ù¼ µ®»Î" <sugimura@xxxxxxxxxx> wrote: > ¿ù¼¤Ç¤¹¡£ > > > Not enough memory for blob at [sort_param->start_recpos] (need [block_info.rec_len]) > > > > ¤È¤¤¤¦¥á¥Ã¥»¡¼¥¸¤Ï¡¢¤½¤Î¥Ð¥Ã¥Õ¥¡¤Ø¤Î¥á¥â¥ê³ÎÊݤ˼ºÇÔ¤·¤¿¤È¤¤Ë½ÐÎϤµ¤ì¤ë¤è¤¦¤Ç¤¹¡£ > > ¤Ç¤¹¤«¤é¡¢REPAIR TABLE Ì¿Îáȯ¹Ô¸å¤Î¥á¥â¥ê¾õ¶·¤ä MySQL ¤ÎÀßÄê¤òÄ´ºº¤¹¤ì¤Ð²¿¤«¤ï¤«¤ë¤«¤âÃΤì¤Þ¤»¤ó¡£ > > > > Ä´¤Ù¤Æ¤Ï¤¤¤ë¤Î¤Ç¤¹¤¬¡¢¤É¤ÎÀßÄ꤬±Æ¶Á¤¹¤ë¤Î¤«¤òÁ´ÉôÄɤ¤¤¤ì¤º¤Ë¤¤¤Þ¤¹¡£ > OS Ū¤Ë¤Ï½½Ê¬¤¹¤®¤ë¤Û¤É¶õ¤¤¤Æ¤¤¤Þ¤¹¤Î¤Ç¡¢my.cnf ¤òµ¿¤Ã¤Æ¤¤¤Þ¤¹¡£ > > > > ¤Þ¤¿¡¢¼¡¤ÎÍ×ÁǤ«¤é¤â²¿¤«¥Ò¥ó¥È¤òÆÀ¤é¤ì¤ë¤«¤âÃΤì¤Þ¤»¤ó¡£ > > ¡Êhttp://dev.mysql.com/doc/mysql/ja/repair-table.html ¤è¤ê¡Ë > > > > ¤³¤Î¥Ú¡¼¥¸¤ä¤½¤Î¼þÊÕ¤ò¸«¤Þ¤·¤Æ¡¢ÉÔÍ×¤Ê INDEX ¤Îºï½ü¤Þ¤Ç¤Ï¤Ç¤¤Þ¤·¤¿¡£ > > [DB Ää»ß¾õÂÖ¤Ç myisamchk -e -i] > > # myisamchk -e -i XXXXXXXXXXXXXX > Checking MyISAM file: XXXXXXXXXXXXXX > Data records: 3413 Deleted blocks: 0 > myisamchk: warning: Table is marked as crashed and last repair failed > - check file-size > myisamchk: warning: Size of indexfile is: 1499136 Should be: 171008 > - check record delete-chain > - check key delete-chain > - check index reference > - check data record references index: 1 > myisamchk: error: Found 3414 keys of 3413 > - check data record references index: 2 > myisamchk: error: Found 3414 keys of 3413 > - check data record references index: 3 > myisamchk: error: Found 3414 keys of 3413 > - check records and index references > myisamchk: error: Record at: 32577612 Can't find key for index: 1 > MyISAM-table 'LOG_PACKETDATA' is corrupted > Fix it using switch "-r" or "-o" > > User time 0.23, System time 0.21 > Maximum resident set size 72032, Integral resident set size 9203888 > Non-physical pagefaults 17884, Physical pagefaults 0, Swaps 0 > Blocks in 0 out 0, Messages in 0 out 0, Signals 0 > Voluntary context switches 0, Involuntary context switches 46 > > > [¥Á¥§¥Ã¥¯¤·¤Æ¥¨¥é¡¼¤¬¤¢¤Ã¤¿¤Î¤Ç½¤Éü] > > svsadev# myisamchk --safe-recover XXXXXXXXXXXXXX > - recovering (with keycache) MyISAM-table 'XXXXXXXXXXXXXX' > Data records: 3413 > Data records: 30138 > > > [MySQLºÆµ¯Æ°¡¢ÌÜŪ¤ÎINDEX¤òºï½ü] > > mysql> drop index IX_XXXXXXXXXXXXXXXX ON XXXXXXXXXXXXXX; > Query OK, 30138 rows affected (20.94 sec) > Records: 30138 Duplicates: 0 Warnings: 0 > > > [¤·¤«¤·ÊÌ¤Ê INDEX ¤òºîÀ®¤·¤è¤¦¤È¤¹¤ë¤È¥¨¥é¡¼] > > mysql> CREATE INDEX IX_XXXXXXXXXXXXXXXX ON XXXXXXXXXXXXXX (A, B); > ERROR 1030 (HY000): Got error 12 from storage engine > > % perror 12 > OS error code 12: Cannot allocate memory > > > ¤É¤Î¥á¥â¥ê¤¬Â¤ê¤Ê¤«¤Ã¤¿¤Î¤«¤¬¤ï¤«¤ë¤È¤â¤¦¾¯¡¹Äɤ¤¤ä¤¹¤¤¤Î¤Ç¤¹¤¬¡¢ > ¤Ê¤«¤Ê¤«Æñ¤·¤¤¤È¤³¤í¤Ç¤¹¡£ > > > > »ÄÇ°¤Ê¤¬¤é»ä¤¬ÎϤˤʤì¤ë¤Î¤Ï¤³¤ÎÊÕ¤ê¤Þ¤Ç¤Î¤è¤¦¤Ç¤¹¡¦¡¦¡¦¡£ > > > > ¤¤¤¨¤¤¤¨¡£¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤¹¡£ > > --- > ¿ù¼ µ®»Î <sugimura@xxxxxxxxxx> > GnuPG fingerprint: C81B 9835 1C9E BD9B 84BF 9785 0B91 D08B F667 DCED > >
11880 2005-08-04 17:54 [SUGIMURA Takashi ¿ùÂ] REPAIR TABLE ¤Ç¤Î¥¨¥é¡¼¤Ë¤Ä¤¤¤Æ 11885 2005-08-05 10:05 ¨²["T.Sasaki" <papasan2] 11888 2005-08-05 11:03 ¨¨±[SUGIMURA Takashi ¿ùÂ] -> 11891 2005-08-05 12:44 ¨¡¡¨²["T.Sasaki" <papasan2] 11892 2005-08-05 12:44 ¨¡¡¨±[¤È¤ß¤¿¤Þ¤µ¤Ò¤í <tomm] 11893 2005-08-05 12:55 ¨¡¡¡¡¨±[SUGIMURA Takashi ¿ùÂ] 11895 2005-08-05 14:04 ¨±[<takeshi@xxxxxxxxxx>]