Got error 122 from storage engine

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

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

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

quotaoff -a

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.

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