cancel
Showing results for 
Search instead for 
Did you mean: 

DB query failed: SQLSTATE[HY000]: General error: 1 Can't create/write to file '/var/tmp/#sql_381_0.M

DB query failed: SQLSTATE[HY000]: General error: 1 Can't create/write to file '/var/tmp/#sql_381_0.M

i have facing the issue now like.


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

 

that's why Magento 1.x admin panel and frontend not working.

admin panel not logged in.

Image_URL

My site is inaccessible. please give me some suggestions on this issue.

or should I need to concern with the hosting provider for this?

Screenshot from 2022-01-04 10-42-18.png

1 REPLY 1

Re: DB query failed: SQLSTATE[HY000]: General error: 1 Can't create/write to file '/var/tmp/#sql_381

The problem can be connected with inodes. Maybe you have too many small files and your inodes are full. You can check inode status with df -i.
Sometimes when this error happens with temp tables:

#126 - Incorrect key file for table '/tmp/#sql_64d_0.MYI'; try to repair it
Or it can be connected with /tmp folder. Please see this answer.

If issue solved, Click Kudos & Accept as Solution.
LitCommerce - The Most Simple & Affordable Multi-channel Selling Tool