Error in Plesk: SQLSTAT[HY]: General Error: Got Error 122 "internal (unspecified) error in handler" from storage engine

Created:

2017-07-21 04:48:51 UTC

Modified:

2017-08-16 15:41:32 UTC

1

Was this article helpful?


Have more questions?

Submit a request

Error in Plesk: SQLSTAT[HY]: General Error: Got Error 122 "internal (unspecified) error in handler" from storage engine

Applicable to:

  • Plesk for Linux

Symptoms

The following error is shown in Plesk:

PLESK_INFO: SQLSTAT[HY]: General Error: Got Error 122 "internal (unspecified) error in handler" from storage engine

Cause

MySQL bug in proper error reporting https://github.com/facebook/mysql-5.6/issues/456

Incorrect permissions on /tmp folder or insufficient disk space.

Resolution

Connect to the server using SSH .

Set correct permissions on /tmp folder and make sure that it is enough disk space and inodes:

# chmod 1777 /tmp

# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/ploop20693p1 9.8G 2.9G 6.4G 31% /
devtmpfs 1.0G 0 1.0G 0% /dev
tmpfs 1.0G 0 1.0G 0% /dev/shm
tmpfs 1.0G 140K 1.0G 1% /run
tmpfs 1.0G 0 1.0G 0% /sys/fs/cgroup
tmpfs 205M 0 205M 0% /run/user/0

# df -i
Filesystem Inodes IUsed IFree IUse% Mounted on
/dev/ploop20693p1 655360 136705 518655 21% /
devtmpfs 262144 65 262079 1% /dev
tmpfs 262144 1 262143 1% /dev/shm
tmpfs 262144 194 261950 1% /run
tmpfs 262144 10 262134 1% /sys/fs/cgroup
tmpfs 262144 1 262143 1% /run/user/0

Have more questions? Submit a request
Please sign in to leave a comment.