# Debugging error report percona 5.6

**URL:** <https://forums.percona.com/t/debugging-error-report-percona-5-6/3088>\
**Category:** Other MySQL® Questions\
**Created:** [November 15, 2013, 3:17am UTC](https://forums.percona.com/t/debugging-error-report-percona-5-6/3088 "2013-11-15T03:17:23Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![mrboon](https://avatars.discourse-cdn.com/v4/letter/m/a88e57/32.png) [@mrboon](https://forums.percona.com/u/mrboon)\
**Post date:** [November 15, 2013, 3:17am UTC](https://forums.percona.com/t/debugging-error-report-percona-5-6/3088/1 "2013-11-15T03:17:23Z")

</div>

I’m running percona 5.6 on a new centos 6.4 server. Things seem to work OK. I personally only really use InnoDB tables for my databases, but only the standard ‘mysql’ table is in MyISAM format.

I checked the msyql-error.log and saw these messages:

```auto
2013-11-14 10:10:26 9013 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_2335_0.MYI'; try to repair it
2013-11-14 10:10:26 9013 [ERROR] Got an error from unknown thread, /mnt/workspace/percona-server-5.6-rpms/label_exp/centos6-64/target/BUILD/Percona-Server-5.6.14-rel62.0/storage/myisam/mi_write.c:226
2013-11-14 10:10:27 9013 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_2335_2.MYI'; try to repair it
2013-11-14 10:10:27 9013 [ERROR] Got an error from unknown thread, /mnt/workspace/percona-server-5.6-rpms/label_exp/centos6-64/target/BUILD/Percona-Server-5.6.14-rel62.0/storage/myisam/mi_write.c:226
2013-11-14 13:53:33 9013 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_2335_0.MYI'; try to repair it
2013-11-14 13:53:33 9013 [ERROR] Got an error from unknown thread, /mnt/workspace/percona-server-5.6-rpms/label_exp/centos6-64/target/BUILD/Percona-Server-5.6.14-rel62.0/storage/myisam/mi_write.c:226
2013-11-14 15:51:54 9013 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_2335_0.MYI'; try to repair it
2013-11-14 15:51:54 9013 [ERROR] Got an error from unknown thread, /mnt/workspace/percona-server-5.6-rpms/label_exp/centos6-64/target/BUILD/Percona-Server-5.6.14-rel62.0/storage/myisam/mi_write.c:226
2013-11-14 19:39:09 9013 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_2335_0.MYI'; try to repair it
2013-11-14 19:39:09 9013 [ERROR] Got an error from unknown thread, /mnt/workspace/percona-server-5.6-rpms/label_exp/centos6-64/target/BUILD/Percona-Server-5.6.14-rel62.0/storage/myisam/mi_write.c:226
2013-11-15 00:18:24 9013 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_2335_0.MYI'; try to repair it
2013-11-15 00:18:24 9013 [ERROR] Got an error from unknown thread, /mnt/workspace/percona-server-5.6-rpms/label_exp/centos6-64/target/BUILD/Percona-Server-5.6.14-rel62.0/storage/myisam/mi_write.c:226

```

This seems to be relating MyISAM tables, which is then the ‘mysql’ information table.

Any idea what might be causing this?

I checked the /tmp dir, and it has plenty of space available.

---

<div class="post-metadata">

**Author:** ![przemek](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/przemek/32/3_2.png) [@przemek](https://forums.percona.com/u/przemek)\
**Post date:** [November 22, 2013, 5:46pm UTC](https://forums.percona.com/t/debugging-error-report-percona-5-6/3088/2 "2013-11-22T17:46:09Z")

</div>

These tables are temporary tables, either explicit ones created with “create temporary table … engine myisam” or implicit caused by some query. Apparently your MySQL or OS crashed when those (MyISAM) tables were still in use, hence are now corrupted. Removing them should fix the problem.