MySQL Bugs: #66950: MYISAM /storage/myisam/ha

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:	None
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

Description:
I am getting the below error now and then on out server and its crashing tables. on DB level I do not see any issue. Please suggest its resolution:

+================================================================
120818  5:31:56 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/opt1/mysql_tmp/#sql_3b64_0.MYI'; try to repair it
120818  5:31:56 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-4399296-1322060428.48/rpm/BUILD/mysql-5.5.19/mysql-5.5.19/storage/myisam/mi_write.c:
223
120818  5:31:57 [ERROR] /usr/sbin/mysqld: Disk is full writing './mysql-bin.004152' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs
delay for server to continue after freeing disk space)
120818  5:31:57 [ERROR] /usr/sbin/mysqld: Retry in 60 secs. Message reprinted in 600 secs
120821 20:35:37 [Note] Start binlog_dump to slave_server(2), pos(mysql-bin.004160, 650361966)
120822 13:08:07 [Note] Start binlog_dump to slave_server(2), pos(mysql-bin.004162, 708739603)
120914 13:10:11 [Note] Start binlog_dump to slave_server(2), pos(mysql-bin.004365, 246296775)
120924 13:15:35 [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/storage/myisam/ha_myisam
.cc:870

How to repeat:
it repeats itself after a few hours.

Are you at least checked what is printed in the error log (repair table, out of disk space)?.

It says out of diskspace. but I always have 2 TB free on the server. Then wats the reason

What about to repair table, disk space of temp partition your server is quite older test latest version too.

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.

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.

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