panjianm 发表于 2018-10-11 08:53:50

mysql临时表报错

1612291:32:36 /export/servers/mysql/bin/mysqld: Incorrect key file for table '/export/data/mysql/tmp/#sql_6c04_8.MYI'; try to repair it　　
1612291:32:36 /export/servers/mysql/bin/mysqld: Incorrect key file for table '/export/data/mysql/tmp/#sql_6c04_2.MYI'; try to repair it
　　
1612291:32:36 Got an error from unknown thread, /usr/local/test/mysql-5.5.38/storage/myisam/mi_write.c:226
　　
1612291:32:36 /export/servers/mysql/bin/mysqld: Incorrect key file for table '/export/data/mysql/tmp/#sql_6c04_4.MYI'; try to repair it
　　
1612291:32:36 Got an error from unknown thread, /usr/local/test/mysql-5.5.38/storage/myisam/mi_write.c:226
　　
1612291:32:36 /export/servers/mysql/bin/mysqld: Incorrect key file for table '/export/data/mysql/tmp/#sql_6c04_7.MYI'; try to repair it
　　
1612291:32:36 Got an error from unknown thread, /usr/local/test/mysql-5.5.38/storage/myisam/mi_write.c:226
　　
1612291:32:36 /export/servers/mysql/bin/mysqld: Incorrect key file for table '/export/data/mysql/tmp/#sql_6c04_3.MYI'; try to repair it
　　
1612291:32:36 Got an error from unknown thread, /usr/local/test/mysql-5.5.38/storage/myisam/mi_write.c:226
　　
1612291:32:36 /export/servers/mysql/bin/mysqld: Incorrect key file for table '/export/data/mysql/tmp/#sql_6c04_9.MYI'; try to repair it
　　
1612291:32:36 Got an error from unknown thread, /usr/local/test/mysql-5.5.38/storage/myisam/mi_write.c:226
　　
1612291:32:36 Got an error from unknown thread, /usr/local/test/mysql-5.5.38/storage/myisam/mi_write.c:226
　　
1612291:32:36 /export/servers/mysql/bin/mysqld: Incorrect key file for table '/export/data/mysql/tmp/#sql_6c04_5.MYI'; try to repair it
　　
1612291:32:36 Got an error from unknown thread, /usr/local/test/mysql-5.5.38/storage/myisam/mi_write.c:226
　　
1612291:32:36 /export/servers/mysql/bin/mysqld: Incorrect key file for table '/export/data/mysql/tmp/#sql_6c04_6.MYI'; try to repair it
　　
1612291:32:36 Got an error from unknown thread, /usr/local/test/mysql-5.5.38/storage/myisam/mi_write.c:226
　　
1612291:32:36 /export/servers/mysql/bin/mysqld: Incorrect key file for table '/export/data/mysql/tmp/#sql_6c04_1.MYI'; try to repair it
　　
1612291:32:36 Got an error from unknown thread, /usr/local/test/mysql-5.5.38/storage/myisam/mi_write.c:226


页: [1]
查看完整版本: mysql临时表报错