Plesk shows SQLSTATE[HY000] [2002] No such file or directory: General error: 1 Can't create/write to file '/tmp/#sql_de3_0.MYI' (Errcode: 13)

Follow

Comments

4 comments

  • Avatar
    Daniel Omine

    #######################

    Today i received this error by email

    subject: Cron <root@username_omitted> /usr/lib64/sa/sa2 -A

    /usr/lib64/sa/sa2: line 52: /var/log/sa//sar20: No space left on device

    #######################

     

    #######################

    I'm trying to access the Plesk panel but the login page is not accessible. The following error is displayed:

    ERROR: Plesk\Exception\Database: DB query failed: SQLSTATE[HY000]: General error: 1 Can't create/write to file '/var/tmp/#sql_49f_0.MAI' (Errcode: 28), query was: DESCRIBE `sessions`

    Additionally, an exception has occurred while trying to report this error: Zend_Exception
    No entry is registered for key &#039;translate&#039; (Mysql.php:53)

    Search for related Knowledge Base articles

    #######################

     

    #######################
    I executed the command:
    ls -ld /var/tmp

    Returns:

    drwxrwxrwt. 14 root root 4096 Nov 20 03:18 /var/tmp

    #######################

     

    #######################

     ls -l /var/tmp

    Returns:

    drwxr-xr-x 2 abrt abrt 4096 Aug 24 18:19 abrt
    drwx------ 3 root root 4096 Nov 4 21:42 systemd-private-xxxxxxxxxx-dovecot.service-M90IJF
    drwx------ 3 root root 4096 Nov 4 23:17 systemd-private-xxxxxxxxxx-httpd.service-ZicHIR
    drwx------ 3 root root 4096 Nov 4 21:42 systemd-private-xxxxxxxxxx-mariadb.service-KL8Oep
    drwx------ 3 root root 4096 Nov 4 21:42 systemd-private-xxxxxxxxxx-plesk-php56-fpm.service-uwDJIu
    drwx------ 3 root root 4096 Nov 4 21:42 systemd-private-xxxxxxxxxx-plesk-php70-fpm.service-0b3ygL
    drwx------ 3 root root 4096 Nov 4 21:42 systemd-private-xxxxxxxxxx-plesk-php71-fpm.service-8bqMdA
    drwx------ 3 root root 4096 Nov 2 03:41 systemd-private-yyyyyyyyyyy-httpd.service-pcRaBS
    drwx------ 3 root root 4096 Sep 17 03:34 systemd-private-yyyyyyyyyyy-mariadb.service-mKKWjt
    drwx------ 3 root root 4096 Nov 2 03:40 systemd-private-yyyyyyyyyyy-plesk-php56-fpm.service-LNNGnI
    drwx------ 3 root root 4096 Nov 2 03:40 systemd-private-yyyyyyyyyyy-plesk-php70-fpm.service-ef8CHn
    drwx------ 3 root root 4096 Nov 2 03:40 systemd-private-yyyyyyyyyyy-plesk-php71-fpm.service-v677Iv

    #######################

     

     

    I'm still mitigating the problem.
    I don't know any solution.

  • Avatar
    Konstantin Annikov

    Hello, 

    From the error provided I see that no space left on Hard Disk: 
    ...
    /usr/lib64/sa/sa2: line 52: /var/log/sa//sar20: No space left on device
    ...

    So, please clean up disk space and start mysql service. 

    You can make sure that there is free disk space by executing the following command in ssh console: 

    # df -h

  • Avatar
    Daniel Omine (Edited )

    I solved.

    The problem wasn't the disk space.

    The disk has 480GB (SSD), only 16GB used.

    The problem was inodes 100% used.

    I found a folder with over 880k files. 

    I deleted all that files and solved the problem.

    The files was generated by PHP Session configured to created the files in a custom location.

     Useful commands to find the folder with unusual number of files:

    for i in /*; do echo $i; find $i |wc -l; done

    Example, if find something weird in /var/log/

    for i in /var/log/*; do echo $i; find $i |wc -l; done

    And repeat the command , just changing the path until find the folder.


     

     

  • Avatar
    Artyom Baranov

    @Daniel Omine,

    Hello! thank you for sharing this information with us.

    I suppose the following article may be helpful too: Unable to start psa service: No space left on device or Disk quota exceeded

Please sign in to leave a comment.

Have more questions? Submit a request