after extract Zip file 8Gb Error- tmp/#sql_32f3_0.MYI

[shopuser]

I have a problem, after extract a 8Gb File in the Filemanager in Plesk comes to first a messge in the filemanger canot extract the zip file not enough memory. then comes this message:


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

i can read only the normal files, SQL is down.

in the tmp folder are only files with a size from 116kb

 

[IgorG]

Make sure that the /tmp directory is granted full permissions:

# ls -ld /tmp
drwxrwxrwt 4 root root 4096 Jan 31 22:18 /tmp

Restart mysql after fixing permissions.

 

[shopuser]

i try this but this was then :

root@t55555:~# ls -ld /tmp/
drwxrwxrwt 2 root root 4096 Jan 29 18:08 /tmp/
root@t55555:~# service mysqld start
mysqld: unrecognized service

root@t55555:~# ls -ld /tmp
drwxrwxrwt 2 root root 4096 Jan 29 18:08 /tmp
root@t55555:~# chmod 1777 /tmp
root@t55555:~# chmod 1777 /tmp
root@t55555:~# service mysqld start
mysqld: unrecognized service
root@t55555:~# stat /tmp
File: ‘/tmp’
Size: 4096 Blocks: 8 IO Block: 4096 directory
Device: 917dh/37245d Inode: 687341904 Links: 2
Access: (1777/drwxrwxrwt) Uid: ( 0/ root) Gid: ( 0/ root)
Access: 2016-01-26 18:39:29.000000000 +0100
Modify: 2016-01-29 18:08:53.163133424 +0100
Change: 2016-01-29 22:15:07.474249838 +0100
Birth: -

root@t55555:~# mysqladmin -uadmin -p`cat /etc/psa/.psa.shadow` variables | gre p -w tmpdir
| tmpdir | /tmp
|
root@t55555:~# ls -ld /tmp/
drwxrwxrwt 2 root root 4096 Jan 29 18:08 /tmp/

 

[IgorG]

So, mysql is not started? Do you have VPS or standalone server? In case of VPS lack of memory resources can be there. Anyway, mysql logs should be investigated.

 

[shopuser]

i have VPS with 8Gb memory Ram and 500Gb HDD

 

[shopuser]

Today was the same again with a 2gb file in the panel.log from plesk i found this :

Reading package lists...
Warning: not connected 'multiverse' repository section
[2016-02-03 07:38:14] ERR [util_exec] proc_close() failed ['/opt/psa/admin/bin/filemng' 'web1' 'unzip-noclobber' '/var/www/vhosts/web1/httpdocs/media/image/image bis 31 .zip'] with exit code [1]
[2016-02-03 07:39:24] ERR [1] DB query failed:
DESCRIBE `sessions`
Error: SQLSTATE[HY000]: General error: 1 Can't create/write to file '/tmp/#sql_64d_0.MYI' (Errcode: 122)
[2016-02-03 07:39:24] ERR [panel] SQLSTATE[HY000]: General error: 1 Can't create/write to file '/tmp/#sql_64d_0.MYI' (Errcode: 122):
0: /opt/psa/admin/externals/Zend/Db/Statement/Pdo.php:234
Zend_Db_Statement_Pdo->_execute(array)
1: /opt/psa/admin/externals/Zend/Db/Statement.php:300
Zend_Db_Statement->execute(array)
2: /opt/psa/admin/externals/Zend/Db/Adapter/Abstract.php:479
Zend_Db_Adapter_Abstract->query(string 'DESCRIBE `sessions`', array)
3: /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php:238
Zend_Db_Adapter_Pdo_Abstract->query(string 'DESCRIBE `sessions`', array)
4: /opt/psa/admin/plib/Db/Adapter/Pdo/Mysql.php:19
Db_Adapter_Pdo_Mysql->query(string 'DESCRIBE `sessions`')
5: /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Mysql.php:169
Zend_Db_Adapter_Pdo_Mysql->describeTable(string 'sessions', NULL null)
6: /opt/psa/admin/externals/Zend/Db/Table/Abstract.php:835
Zend_Db_Table_Abstract->_setupMetadata()
7: /opt/psa/admin/externals/Zend/Db/Table/Abstract.php:874
Zend_Db_Table_Abstract->_setupPrimaryKey()
8: /opt/psa/admin/externals/Zend/Db/Table/Abstract.php:982
Zend_Db_Table_Abstract->info()
9: /opt/psa/admin/externals/Zend/Db/Table/Select.php:100
Zend_Db_Table_Select->setTable(object of type Plesk\Session\Storage_DbTable_Sessions)
10: /opt/psa/admin/externals/Zend/Db/Table/Select.php:78
Zend_Db_Table_Select->__construct(object of type Plesk\Session\Storage_DbTable_Sessions)
11: /opt/psa/admin/externals/Zend/Db/Table/Abstract.php:1018
Zend_Db_Table_Abstract->select()
12: /opt/psa/admin/plib/Session/Storage/DbTable.php:145
Plesk\Session\Storage_DbTable->removeExpiredSessions()
13: /opt/psa/admin/plib/Application/Web.php:179
Plesk\Application_Web->loadSession()
14: /opt/psa/admin/plib/auth.php:367
AutoPrepend->initUserSession()
15: /opt/psa/admin/plib/auth.php:230
AutoPrepend->run()
16: /opt/psa/admin/plib/auth.php:759
[2016-02-03 07:39:24] ERR [1] SQLSTATE[HY000]: General error: 1 Can't create/write to file '/tmp/#sql_64d_0.MYI' (Errcode: 122)

 

[IgorG]

Do you have enough free disk space on this server? What sort of errors in mysql log?

 

[shopuser]

Yes :


Last login: Tue Feb 2 22:19:24 2016
root@v55555:~# df -h
Filesystem Size Used Avail Use% Mounted on
/vz/template:/vz/private/v555555/fs 500G 44G 457G 9% /
none 4,0G 4,0K 4,0G 1% /dev
none 4,0K 0 4,0K 0% /sys/fs/cgroup
none 820M 132K 820M 1% /run
none 5,0M 0 5,0M 0% /run/lock
none 4,0G 0 4,0G 0% /run/shm
none 100M 0 100M 0% /run/user

but i canot write to the disk


in the folder var/log is the mysql.log this file have 0 bytes with the date from 2016-02-03 02:53:00
the bug was later 2016-02-03 07:39:00

 

[IgorG]

Do you have SELinux enabled? Check it with

# getenforce

command.

 

[shopuser]

i mean the problem, is that after extract the zip file a script change the main rights from the disk. After the no otfer scipt or user can write to the disk, and teh sql service cannot write a temp file

 

[shopuser]

is see this :
-bash: getenforce: command not found

 

[shopuser]

df -i

/vz/template:/vz/private/v55555555/fs 18446744070462552271 18446744069415604317 10 46947954 100% /46947954 100% /
none 1048576 62 1048514 1% /dev
none 1048576 1 1048575 1% /sys/fs/cgroup
none 1048576 122 1048454 1% /run
none 1048576 33 1048543 1% /run/lock
none 1048576 1 1048575 1% /run/shm
none 1048576 1 1048575 1% /run/user

it looks thank all Inodes full.


what can i do?

 

[IgorG]

Yes, lack of free inodes on VPS is also possible reason of this error. Inodes can be added to VPS only from hardware node side. Ask assistance of system administrator of this server.

 

[shopuser]

Yesterday i delete the last installed user folder, later the i had 20% inodes free

At a other hosting - company with 250GbHDD (with 100Gb free space)i have 12 Mio Inodes free from 16,6Mio fore the main partion

/dev/ffrt55555555 16621568 4229748 12391820 26% /
none 2097152 64 2097088 1% /dev
none 2097152 1 2097151 1% /sys/fs/cgroup
none 2097152 96 2097056 1% /run
none 2097152 189 2096963 1% /run/lock
none 2097152 1 2097151 1% /run/shm
none 2097152 1 2097151 1% /run/user

at this hosting company i have a 500Gb HDD and 455Gb and only 1Mio Inodes for 500GB


/vz/template:/vz/private/v55555/fs 1000000 790219 209781 80% /
none 1048576 62 1048514 1% /dev
none 1048576 1 1048575 1% /sys/fs/cgroup
none 1048576 123 1048453 1% /run
none 1048576 33 1048543 1% /run/lock
none 1048576 1 1048575 1% /run/shm
none 1048576 1 1048575 1% /run/user


i try to make a complete backup from all files and maybe i can format the HDD new with more Inodes

thanks for your help!