2.1.5 Error "Incorrect key file for table..."

MrCanadian

Hello everyone,

When a comment is being typed out on my forum, and the auto-save kicks in (or at the very least at the same time, coincidentally), sometimes this error pops up:

Incorrect key file for table '/mysql-tmp/#sql_2031_0.MYI'; try to repair it|Gdn_Database|Query|show columns from GDN_User

Is something broken within my database? Is there anything I can do to fix this?

Thanks for your time and help.

peregrine

see

http://stackoverflow.com/questions/11805793/incorrect-key-file-for-table-tmp-sql-3c51-0-myi-try-to-repair-it

and google it. you might see other answers on mysql sites

you could also use the stop autodraft plugin which might mitigate things perhaps.

P.S. - thanks for voting here. really appreciate that you did that. bonus point for you. wish more people would follow in your footsteps instead of being apathetic.

http://vanillaforums.org/discussion/28401/vanilla-awards-for-best-community-developed-plugin-theme-and-application

peregrine

also see:

http://www.mysqlperformancetuning.com/a-fix-for-incorrect-key-file-for-table-mysql

http://stackoverflow.com/questions/2011050/mysql-126-incorrect-key-file-for-table

http://stackoverflow.com/questions/19003106/mysql-error-126-incorrect-key-file-for-table

report back when you have a solution.

MrCanadian

@peregrine said:
also see:

http://www.mysqlperformancetuning.com/a-fix-for-incorrect-key-file-for-table-mysql

http://stackoverflow.com/questions/2011050/mysql-126-incorrect-key-file-for-table

http://stackoverflow.com/questions/19003106/mysql-error-126-incorrect-key-file-for-table

report back when you have a solution.

Thanks for the direction. I'll comb through those suggestions and see if I can muster a solution.

[Addition:] I think I'll go with the deactivation of auto saving. Seems the simplest and prevents me from having to fiddle with a (very likely sensative) database. Thanks!

R_J

Generally I would favor solving a problem than ignoring the symptoms, but that's completely up to you.

Here is an alternative to simply disabling drafts: http://vanillaforums.org/addon/localdrafts-plugin
It replaces the standard Vanilla drafting mechanism with HTML5 local storage drafts.

peregrine

@MrCanadian

as r_j says you have a problem, you might as well solve it, ask your host. and check if you have enough file space in tmpdir folders, etc.

if i didn't see the other stack exchange comments, i was originally going to see try to run utility structure, then run phpmyadmin repair and optimize the tables.

http://dev.mysql.com/doc/refman/5.0/en/temporary-files.html

MrCanadian

I ultimately went with the "stop autodraft" plugin, and haven't seen the error since.

Everything seems to be working smoothly now. Thanks for the great plug-in suggestion!