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

mysql:11888

From: SUGIMURA Takashi ¿ù¼ µ®»Î <SUGIMURA Takashi ¿ù¼ µ®»Î <sugimura@xxxxxxxxxx>>
Date: Fri, 05 Aug 2005 11:03:06 +0900 (JST)
Subject: [mysql 11888] Re: REPAIR TABLE ¤Ç¤Î¥¨¥é¡¼¤Ë¤Ä¤¤¤Æ

¿ù¼¤Ç¤¹¡£

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