• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS.

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

Status
Not open for further replies.

kamlegk

New Pleskian
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:
Code:
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
kod błędu.png

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.
 
Last edited:
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.
 
My VPS running normaly. VPS have a lot of free space.
Code:
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.
 
My VPS running normaly. VPS have a lot of free space.
Code:
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.
 
Reply

My VPS running normaly. VPS have a lot of free space.
Code:
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.
 
Reply

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

du -f
Code:
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
Code:
root@vps:~# du -sh /tmp
36K	/tmp

how can I increase the size of tmp?
 
This is the usage not the available space:
Code:
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.
 
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
 
Status
Not open for further replies.
Back
Top