mysql:11888

錯翹匹允﹝

> 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