Home > database >  ERROR 126 (HY000) at line 1: Incorrect key file for the table '/TMP/# sql_6d45_0 MYI'
ERROR 126 (HY000) at line 1: Incorrect key file for the table '/TMP/# sql_6d45_0 MYI'

Time:10-06

Mysql talking about a merge table of each field accumulation is called the above error, the SQL statement is as follows:

Insert into ADD_FRIEND_CREDIT_RESULT. Addfri_result_Hash ${I} select uin, sum (active_days), sum (add_friend_count), sum (add_friend_uin_count), sum (impeach_uin_count), sum (black_count), sum (black_uin_count), sum (black_count1), sum (black_uin_count1), sum (add_refused_count), sum (add_refused_uin_count), sum (add_ignore_count), sum (add_ignore_uin_count), sum (add_agree_count) from ADD_FRIEND_CREDIT_RESULT. Addfri_merge_table_Hash ${I} group by uin

Use perror command to see the error as follows:
MySQL error code: 126 Index file is crashed

Please which predecessors knowledge, grateful!

CodePudding user response:

Have solve the problem

CodePudding user response:

What circumstance?
  • Related