[Á°][¼¡][ÈÖ¹æ½ç°ìÍ÷][¥¹¥ì¥Ã¥É°ìÍ÷]

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>]