CODEWITHSUNDEEP
mysql
Michael
Michael

Reputation:

How to solve error 122 from storage engine?

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?

Upvotes: 8

Views: 27588

Answers (5)

Archil
Archil

Reputation: 21

Try to turn off the disk quota using the quotaoff command.

Using the -a flag will turn off all file system quotas.

quotaoff -a

Upvotes: 2

V Solve Enterprise
V Solve Enterprise

Reputation: 1

I resolve this issue by increasing my disk size. try df -h to check whether there are enough disk space on your server.

Upvotes: 0

Michael
Michael

Reputation:

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.

Upvotes: 6

longneck
longneck

Reputation: 293

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.

Upvotes: 1

owenmarshall
owenmarshall

Reputation: 865

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

Upvotes: 4

Related Questions