Error message: Can't create/write to file '/tmp - after overflow /tmp

[kamlegk]

Hi,

I have problem with my Panel Plesk on VPS server on Debian Linux.
Recently overflowed the partition /tmp which has 1.4 GB. Web access to panel plesk and websites did not work.
I cleaned /tmp using command "rm *.*" on tmp catalog.

After these changes my websites work but in panel I get this error:

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

Message	SQLSTATE[HY000]: General error: 1 Can't create/write to file '/tmp/#sql_1bdb_0.MYI' (Errcode: 28)
File	 Pdo.php
Line	234
Type	Zend_Db_Statement_Exception

Always I work as root. I also noticed that I do not have rights to create any file as root.

Please for help.
I greet.

 

[Faris Raouf]

Check to make sure your VPS has not been started in some sort of read-only mode. As root, you MUST be able to create files (if there is space on the filesystem)

In addition, make sure /tmp exists (make sure you did not delete /tmp itself).

Check ownership and permissions on /tmp (root:root, and 1777 but BE CAREFUL -- I DON'T KNOW DEBIAN and playing with permissions on /tmp is dangerous if I've given you the wrong suggestion. So contact your VPS provider for assistance as they will know what/how/where/etc and will be able to tell you exactly what you need to do.

But seriously -- if you cannot create files as root, something is very wrong. Contact your VPS provider for help.

 

[kamlegk]

My VPS running normaly. VPS have a lot of free space.

root@vps:~# df -h
System plików  rozm. użyte dost. %uż. zamont. na
rootfs           48G   19G   27G  41% /
/dev/root        48G   19G   27G  41% /
devtmpfs        2,5G     0  2,5G   0% /dev
tmpfs           496M  252K  496M   1% /run
tmpfs           5,0M     0  5,0M   0% /run/lock
tmpfs           1,4G     0  1,4G   0% /dev/shm

Catalog /tmp is exist, owner is root, chmod has 777.

I observed behavior my user when I log in with ssh. Operational efficiency is random. once I can create the file, again I can not. Identical situation I have on the web or FTP client. When I send my request again it working good. Sometimes I have to do it once, sometimes more.

 

[kamlegk]

My VPS running normaly. VPS have a lot of free space.

root@vps:~# df -h
System plików  rozm. użyte dost. %uż. zamont. na
rootfs           48G   19G   27G  41% /
/dev/root        48G   19G   27G  41% /
devtmpfs        2,5G     0  2,5G   0% /dev
tmpfs           496M  252K  496M   1% /run
tmpfs           5,0M     0  5,0M   0% /run/lock
tmpfs           1,4G     0  1,4G   0% /dev/shm

Catalog /tmp is exist, owner is root, chmod has 777.

I observed behavior my user when I log in with ssh. Operational efficiency is random. once I can create the file, again I can not. Identical situation I have on the web or FTP client. When I send my request again it working good. Sometimes I have to do it once, sometimes more.

 

[kamlegk]

Reply

My VPS running normaly. VPS have a lot of free space.

root@vps:~# df -h
System plików  rozm. użyte dost. %uż. zamont. na
rootfs           48G   19G   27G  41% /
/dev/root        48G   19G   27G  41% /
devtmpfs        2,5G     0  2,5G   0% /dev
tmpfs           496M  252K  496M   1% /run
tmpfs           5,0M     0  5,0M   0% /run/lock
tmpfs           1,4G     0  1,4G   0% /dev/shm

Catalog /tmp is exist, owner is root, chmod has 777.

I observed behavior my user when I log in with ssh. Operational efficiency is random. once I can create the file, again I can not. Identical situation I have on the web or FTP client. When I send my request again it working good. Sometimes I have to do it once, sometimes more.

 

[kamlegk]

Reply

I noticed that I don't have free space on catalog /tmp

du -f

root@vps:~# df -h
System plików  rozm. użyte dost. %uż. zamont. na
rootfs           48G   20G   26G  43% /
/dev/root        48G   20G   26G  43% /
devtmpfs        2,5G     0  2,5G   0% /dev
tmpfs           496M  248K  496M   1% /run
tmpfs           5,0M     0  5,0M   0% /run/lock
tmpfs           1,4G     0  1,4G   0% /dev/shm

du -sh /tmp

root@vps:~# du -sh /tmp
36K	/tmp

how can I increase the size of tmp?

 

[kamlegk]

Please for fast reply,

Thanks

 

[Jeff Huckaby]

This is the usage not the available space:

root@vps:~# du -sh /tmp
36K	/tmp

You will usually get that SQL error when:

• Database corruption has happen (not a common issue).
• The partition containing /tmp is full
• The filesystem has gone read-only

Sometimes temporary files can build up on the server an fill up the space. An errcode of 28 is typically a disk is out of space issue.

If problems persist, you may want to reboot and run a fsck on your file system.

 

[kamlegk]

My problem is solved.

I have obtained the maximum limit I-NODE in file system.

answer gave me the command df -i

Thanks for help