General error: 1 Can't create/write to file '/tmp/#sql_200_0.MYI' (Errcode: 28) (Pdo.php:234)

[SebastianK1]

Try to login this morning into plesk via browser.

Error:
ERROR: Zend_Db_Statement_Exception: SQLSTATE[HY000]: General error: 1 Can't create/write to file '/tmp/#sql_200_0.MYI' (Errcode: 28) (Pdo.php:234)


Found this in apache err log:
[Sat Feb 28 07:20:40 2015] [error] (28)No space left on device: mod_fcgid: couldn't bind unix domain socket /var/lib/apache2/fcgid/sock/30700.6397
[Sat Feb 28 07:20:40 2015] [warn] (28)No space left on device: mod_fcgid: spawn process /var/www/cgi-bin/cgi_wrapper/cgi_wrapper error
[Sat Feb 28 07:20:40 2015] [error] (28)No space left on device: mod_fcgid: couldn't bind unix domain socket /var/lib/apache2/fcgid/sock/30700.6398
[Sat Feb 28 07:20:40 2015] [warn] (28)No space left on device: mod_fcgid: spa


>
112 GB free Diskspace
/tmp is there

>
mysqlcheck -A -uadmin -p`cat /etc/psa/.psa.shadow`
all tables OK

>
# mysqladmin -uadmin -p`cat /etc/psa/.psa.shadow` variables | grep -w tmpdir
| tmpdir | /tmp

>
ls -ld /tmp/
drwxrwxrwt 4 root root 12288 Feb 28 07:50 /tmp/




Any hints?

Best,

Sebastian

 

[SebastianK1]

stat /tmp

File: `/tmp'
Size: 12288 Blocks: 24 IO Block: 4096 directory
Device: 54a0b681h/1419818625d Inode: 524436 Links: 4
Access: (1777/drwxrwxrwt) Uid: ( 0/ root) Gid: ( 0/ root)
Access: 2015-02-28 08:11:23.451815229 +0100
Modify: 2015-02-28 07:50:41.581141767 +0100
Change: 2015-02-28 07:50:41.581141767 +0100
Birth: -

 

[abdi]

Been here:
https://talk.plesk.com/threads/erro...-to-file-tmp-sql_cd8_0-myi-errcode-28.303407/

 

[SebastianK1]

thanks! But will not help, I have 112 GB free Diskspace

 

[SebastianK1]

ok, called the provider. Was a problem with the virtual maschine.

Thanks to all,

Sebastian

 

[abdi]

Great,
Am glad you have had it resolved!