Got error 122 from storage engine

Question

Got this from some mysql queries, puzzled since error 122 is usually a 'out of space' error but there's plenty of space left on the server... any ideas?

Answer 1

Error 122 often indicates a "Disk over quota" error. Is it possible disk quotas exist on the server?

Answer 2

No as I said the account has no quota (unlimited) - maybe some other quota I dont know about?

Answer 3

If you got this in IE7 running an AJAX query, there is a known issue with GET requests returning an HTTP 122 error.

(see link for description/example) http://www.codebelay.com/blog/?p=194

Only happens in IE7 (that I know of)

Status Error: 122 Status Message: "IE7 cannot print out that many zeros using Ajax"

Answer 4

are you using innodb tables? if so, you might not have auto-grow turned on and inno can't expand the table space any more.

if these are myisam tables and it only happens on specific tables, i would suspect corruption. do a REPAIR on the tables in question.

Answer 5

The answer: for some reason Mysql had its tmp tables on the /tmp partition which was limited to 100M, and was filled up by eaccelerator cache to 100M even though eaccel is limited to 16M of usage. Very weird, but I just moved eaccel cache elsewhere and problem solved.