Advertisement
Advertisement


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?

2008/09/15
1
6
9/15/2008 11:49:08 PM


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

2008/09/15

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

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

quotaoff -a
2018/11/09

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.

2008/09/16

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

2014/05/22