Error logging in Can't create/write to file '/tmp/#sql_cd8_0.MYI' (Errcode: 28)

[shortlc]

When logging in to Panel I get the following error:

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

Additionally, an exception has occurred while trying to report this error: Zend_Db_Statement_Exception
SQLSTATE[HY000]: General error: 1 Can't create/write to file '/tmp/#sql_cd8_0.MYI' (Errcode: 28) (Pdo.php:234)

I cannot login via FTP either. The /tmp directory is chmod 1777 and have about 16gb a space left on the VPS.

I have Panel psa 11.5.30 build 115130819.13 - CentOS 6 .3.8.13

Please help!

 

[IgorG]

What about owners of /tmp?

It should be:

# stat /tmp
File: `/tmp'
Size: 16384 Blocks: 32 IO Block: 4096 directory
Device: 1ch/28d Inode: 61860724 Links: 3
Access: (1777/drwxrwxrwt) Uid: ( 0/ root) Gid: ( 0/ root)

 

[abdi]

Also ensure that /tmp is not just an independent partition (& full).

 

[shortlc]

What about owners of /tmp?

It should be:

# stat /tmp
File: `/tmp'
Size: 16384 Blocks: 32 IO Block: 4096 directory
Device: 1ch/28d Inode: 61860724 Links: 3
Access: (1777/drwxrwxrwt) Uid: ( 0/ root) Gid: ( 0/ root)

# stat /tmp
File: `/tmp'
Size: 12288 Blocks: 24 IO Block: 4096 directory
Device: 801h/2049d Inode: 131073 Links: 4
Access: (1777/drwxrwxrwt) Uid: ( 0/ root) Gid: ( 0/ root)

 

[shortlc]

Also ensure that /tmp is not just an independent partition (& full).

I'm am new to ssh commands, so can you explain how I can check this?

 

[IgorG]

Check that /tmp is correct tmpdir for your MySQL server with

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

 

[shortlc]

Check that /tmp is correct tmpdir for your MySQL server with

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

Result:

| tmpdir                                  | /tmp                                                                                      |

 

[IgorG]

Check that you have:

# ls -ld /tmp/
drwxrwxrwt 3 root root 16384 May 22 16:55 /tmp/

and delete all files from /tmp/

 

[shortlc]

Check that you have:

# ls -ld /tmp/
drwxrwxrwt 3 root root 16384 May 22 16:55 /tmp/

and delete all files from /tmp/

I get:

drwxrwxrwt 3 root root 12288 May 22 13:18 /tmp/

No files in /tmp

 

[shortlc]

I have restarted the VPS, now I have received about 6 emails at the beginning of every hour:

From: [email protected]
Subject: Cron <root@vps21157> /usr/local/psa/admin/bin/php -c '/usr/local/psa/admin/conf/php.ini' -dauto_prepend_file=sdk.php '/usr/local/psa/admin/plib/modules/plesk-mobile/scripts/push_worker.php'

Email: 2014-05-22T17:10:01+02:00 ERR (3) [panel]: SQLSTATE[HY000]: General error: 1 Can't create/write to file '/tmp/#sql_2200_0.MYI' (Errcode: 28):
0: Pdo.php:234
Zend_Db_Statement_Pdo->_execute(array)
1: Statement.php:300
Zend_Db_Statement->execute(array)
2: Abstract.php:479
Zend_Db_Adapter_Abstract->query(string 'DESCRIBE `Modules`', array)
3: Abstract.php:238
Zend_Db_Adapter_Pdo_Abstract->query(string 'DESCRIBE `Modules`', array)
4: Mysql.php:19
Db_Adapter_Pdo_Mysql->query(string 'DESCRIBE `Modules`')
5: Mysql.php:169
Zend_Db_Adapter_Pdo_Mysql->describeTable(string 'Modules', NULL null)
6: Abstract.php:835
Zend_Db_Table_Abstract->_setupMetadata()
7: Abstract.php:874
Zend_Db_Table_Abstract->_setupPrimaryKey()
8: Abstract.php:982
Zend_Db_Table_Abstract->info()
9: Select.php:100
Zend_Db_Table_Select->setTable(object of type Db_Table_Broker_Modules)
10: Select.php:78
Zend_Db_Table_Select->__construct(object of type Db_Table_Broker_Modules)
11: Abstract.php:1018
Zend_Db_Table_Abstract->select()
12: Abstract.php:1331
Zend_Db_Table_Abstract->fetchAll(string '`name` = 'plesk-mobile'')
13: Abstract.php:140
Db_Table_Abstract->findByField(string 'name', string 'plesk-mobile')
14: Abstract.php:152
Db_Table_Abstract->findOneByField(string 'name', string 'plesk-mobile')
15: Context.php:28
pm_Context::init(string 'plesk-mobile')
16: bootstrap.php:16
require_once(string '/usr/local/psa/admin/plib/modules/plesk-mobile/bootstrap.php')
17: push_worker.php:11
ERROR: Zend_Db_Statement_Exception: SQLSTATE[HY000]: General error: 1 Can't create/write to file '/tmp/#sql_2200_0.MYI' (Errcode: 28) (Pdo.php:234)





I am still having the problem logging in and the cron issue I have posted here: http://forum.parallels.com/showthre...emon-error-emails-continually-sent-every-hour

 

[IgorG]

Do you have SElinux enabled?

 

[shortlc]

Do you have SElinux enabled?

Yes, unbeknown to me it is enabled, but i don't require it. Can I disable it? And how?

 

[IgorG]

Disable SELinux with

# setenforce 0

 

[IgorG]

Looks like the reason of this issue lack of free inodes on filesystem. Increase this resource for your VPS.

 

[shortlc]

Disable SELinux with

# setenforce 0

Done

Looks like the reason of this issue lack of free inodes on filesystem. Increase this resource for your VPS.

Can I increase the limit of inodes? If so how?

 

[IgorG]

Is it Virtuozzo VPS? In this case inodes can be increased for this VPS only from Virtuozzo hardware node by server administrator. Or delete all extra files and directories from your VPS.

 

[shortlc]

Is it Virtuozzo VPS? In this case inodes can be increased for this VPS only from Virtuozzo hardware node by server administrator. Or delete all extra files and directories from your VPS.

No virtuozzo. What uneccessary files can be deleted? Logs etc and where to find them?

 

[IgorG]

What uneccessary files can be deleted?

It is up to you. You know better which users data may be deleted or not.