debugsqlMinor
Ample disk space with error: "1034 Incorrect key file for table 'table_name'; try to repair it"
Viewed 0 times
errorspace1034diskincorrectwithkeyfiletable_namerepair
Problem
I'm attempting to alter a 1.6 GB InnoDB table with the following query:
The query fails with the following error:
Nearly every thread on this topic (SO and elsewhere) suggests that this is due to the tmpdir running out of space.
While this seems to be the problem for many, this doesn't seem to be the case on our system.
I'm totally stuck. Thoughts?
ALTER TABLE `table_name` ADD `field_id` int(11) unsigned DEFAULT NULLThe query fails with the following error:
1034 Incorrect key file for table 'table_name'; try to repair itNearly every thread on this topic (SO and elsewhere) suggests that this is due to the tmpdir running out of space.
While this seems to be the problem for many, this doesn't seem to be the case on our system.
tmpdir is /tmp:/tmp is far from full:I'm totally stuck. Thoughts?
Solution
Well, I'm a big dummy. When I went to check the size of the database via the method requested by @a_vlad, I realized that previously I was checking the free space on
Gah. Executing the command again while tracking the free space on
...and here's the slice of humble pie I'm eating right now:
/tmp on the wrong server.Gah. Executing the command again while tracking the free space on
/tmp on the correct server reveals that lack of free space is, indeed, the problem....and here's the slice of humble pie I'm eating right now:
Context
StackExchange Database Administrators Q#162969, answer score: 7
Revisions (0)
No revisions yet.