Bug #66950 | MYISAM /storage/myisam/ha_myisam error | ||
---|---|---|---|
Submitted: | 24 Sep 2012 19:08 | Modified: | 6 Dec 2012 20:28 |
Reporter: | parox vaniya | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server: Errors | Severity: | S1 (Critical) |
Version: | 5.5.19 | OS: | Linux (EL6) |
Assigned to: | CPU Architecture: | Any | |
Tags: | [ERROR] Got an error from thread_id=535547, /pb2/build/sb_0-4399296-1322060428.48/rpm/BUILD/mysql-5.5.19/mysql-5.5.19/storag |
[24 Sep 2012 19:08]
parox vaniya
[24 Sep 2012 19:42]
MySQL Verification Team
Are you at least checked what is printed in the error log (repair table, out of disk space)?.
[24 Sep 2012 19:45]
parox vaniya
It says out of diskspace. but I always have 2 TB free on the server. Then wats the reason
[24 Sep 2012 19:59]
MySQL Verification Team
What about to repair table, disk space of temp partition your server is quite older test latest version too.
[24 Sep 2012 21:07]
parox vaniya
This is a latest system and the temp has 2TB space how can it be full. I get the repair error on tmp where sorting takes place. /usr/sbin/mysqld: Incorrect key file for table '/opt1/mysql_tmp/#sql_3b64_0.MYI'; try to repair it please suggest.
[6 Dec 2012 20:28]
Sveta Smirnova
Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on how to report a bug at http://bugs.mysql.com/how-to-report.php You can easily fill 2TB of space in temporary directory if use not effective queries which require table scans and/or filesorts which don't fit in memory. Error message is clear about it. Check also value of tmpdir variable to ensure it points to a disk which has enough free space.
[17 Nov 2019 15:46]
mohsen davari
hi i thing you enable myisam_repair_threads disable this and repair your table again and every thing maybe ok i know your post is too old but i have the same error and i do it