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

mysql:15565

From: Takeshi Hayase <Takeshi Hayase <linus@xxxxxxxxxx>>
Date: Thu, 07 Apr 2011 12:38:33 +0900
Subject: [mysql 15565] Re: MySQL¥¨¥é¡¼¥³¡¼¥É¡Ö159¡×¤Ë¤Ä¤¤¤Æ

½é¤á¤Þ¤·¤Æ¡£
hayase¤È¿½¤·¤Þ¤¹¡£

½é¤á¤Æ¸«¤ë¥¨¥é¡¼¤Ê¤Î¤ÇÄ´¤Ù¤Æ¤ß¤Þ¤·¤¿¤¬¡¢¤ï¤«¤ê¤Þ¤»¤ó¤Ç¤·¤¿¡£
¤Ê¤ª¡¢»ä¤ÎÊý¤Ç¼Â¹Ô¤·¤¿ºÝ¤Ë¤Ï¡¢¥¨¥é¡¼¤Ï½Ð¤Þ¤»¤ó¤Ç¤·¤¿¡£
ÅöÊý¤Î´Ä¶­¡¡¢Í¡¡CentOS5.5+MySQL5.1.53

¤Á¤Ê¤ß¤Ë¡¢Version¾ðÊó¤äPlatformÅù¤¬½ñ¤¤¤Æ¤¢¤ë¤È
Åú¤¨¤ä¤¹¤¯¤Ê¤ë¤Î¤Ï¸Åº£ÅìÀ¾¶¦Ä̤·¤Æ¤¤¤ë¤È»×¤¤¤Þ¤¹¡£
¤Þ¤¿¡¢³ºÅö¥Æ¡¼¥Ö¥ë¤òºîÀ®¤·¤¿createʸ¤â¤¢¤Ã¤¿¤éÎɤ¤¤Ç¤¹¤Í¡£

> Æ°ºî³Îǧ¤ò¤·¤¿¤È¤³¤í¡¢ÆäËÌäÂê¤Ï¤Ê¤¤¤Î¤Ç¤¹¤¬¡¢

ÌäÂê̵¤¤¤È¤¤¤¦¤Î¤Ï¡¢
­¡¡¡¥¨¥é¡¼¤Ï½Ð¤¿¤¬Àµ¾ï¤Ë¼Â¹Ô¤µ¤ì¤¿¡ÊINDEX¤¬Àµ¤·¤¯ºî¤é¤ì¤¿¡Ë
­¢¡¡ºîÀ®¤·¤Ê¤¯¤Æ¤â¤è¤¤INDEX¤À¤Ã¤¿

¤É¤Á¤é¤Ç¤·¤ç¤¦¡©

¤Ê¤ó¤È¤Ê¤¯´Ä¶­¤ÎÌäÂê¤Î¤è¤¦¤Êµ¤¤¬¤·¤Þ¤¹¤¬¡¦¡¦¡¦
¤ªÌò¤ËΩ¤Æ¤Ê¤¯¤Æ¿½¤·Ìõ¤¢¤ê¤Þ¤»¤ó¡£



(2011/04/07 11:54), mysql@xxxxxxxxxx wrote:
> ¥«¥ï¥Ð¥¿¤È¿½¤·¤Þ¤¹¡£
> 
> Innodb¤Î¥Æ¡¼¥Ö¥ë¤ËÂФ·¤Æ¥¤¥ó¥Ç¥Ã¥¯¥¹¤òÄɲä·¤¿¤é¡¢
> °Ê²¼¤Î¥¨¥é¡¼¤¬½ÐÎϤµ¤ì¤Þ¤·¤¿¡£
> Æ°ºî³Îǧ¤ò¤·¤¿¤È¤³¤í¡¢ÆäËÌäÂê¤Ï¤Ê¤¤¤Î¤Ç¤¹¤¬¡¢
> ¤É¤Î¤è¤¦¤Ê¸¶°ø¤Ç°Ê²¼¤Î¥¨¥é¡¼¤¬½ÐÎϤµ¤ì¤ë¤Î¤«
> ¤´Â¸¤¸¤ÎÊý¤¬¤¤¤é¤Ã¤·¤ã¤¤¤Þ¤·¤¿¤é¤´¶µ¼ø¤ª´ê¤¤¤·¤Þ¤¹¡£
> 
> ¢£¼Â¹Ô¥¯¥¨¥ê
> ALTER TABLE table ADD INDEX key1 (col1, col2, col3, col4);
> 
> ¢£¥¨¥é¡¼¥á¥Ã¥»¡¼¥¸
> [ERROR] Got error 159 when reading table './schema/table'
> 
> ¢£perror
> MySQL error code 159: The table changed in storage engine
> 
> °Ê¾å¡¢µ¹¤·¤¯¤ª´ê¤¤¤·¤Þ¤¹¡£
> 
> 
> 
> 

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

     15564 2011-04-07 11:54 [<mysql@xxxxxxxxxx>  ] MySQL¥¨¥é¡¼¥³¡¼¥É¡Ö159¡×¤Ë¤Ä¤¤¤Æ        
->   15565 2011-04-07 12:38 ¨±[Takeshi Hayase <linu]                                       
     15566 2011-04-07 13:01 ¡¡¨±[<mysql@xxxxxxxxxx>  ]