Updates:

A forum for everyone🌍

Welcome to Dbeda Forum. Please login or sign up.

Dec 23, 2024, 08:17 AM

Login with username, password and session length

Hey buddy! Wanna Explore the Forum? Kindly use the Menu and the icons beneath it...

A forum for everyone🌍

Flash

Database Error: Disk full (/tmp/#sql-temptable-1....) errno: 28 "No space left

Started by Urguy, Sep 08, 2024, 02:30 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Urguy

I get this message in my website's error log, it happens when trying to login. There's usually an error message displayed at the user's end too, telling the user to contact administrator. Although, it gives access upon the second login attempt but the database error message keeps showing up on my error log.

"Database Error: Disk full (/tmp/#sql-temptable-1....MAI); waiting for someone to free some space... (errno: 28 "No space left on device")"


Urguy

Quote from: Congra on Sep 08, 2024, 02:32 PMCheck your database disk, it might be full.
No, it's not. I can share a screenshot with you. My disk is still vary spacious, I currently use way less than the total space.

Shereefah

"(/tmp/#sql-temptable-1....MAI); waiting for someone to free some space... (errno: 28 "No space left on device")"

This seems to be a space error related to the "tmp" folder.
There's usually a temporary file generated automatically by mysql each time you perform an operation, and they are usually named .sql, hence indicating "#sql" in the error displayed.

Ensure you backup first, you can then go to your file manager and check for a folder named "tmp", delete all the .sql files therein, you can also delete other temporary files to clear up more space. Most of the time, they are no big of a deal, the files there are temporary.
La nostalgie de la boue n'est pas la mienne

Urguy

Quote from: Shereefah on Sep 08, 2024, 02:54 PM"(/tmp/#sql-temptable-1....MAI); waiting for someone to free some space... (errno: 28 "No space left on device")"

This seems to be a space error related to the "tmp" folder.
There's usually a temporary file generated automatically by mysql each time you perform an operation, and they are usually named .sql, hence indicating "#sql" in the error displayed.

Ensure you backup first, you can then go to your file manager and check for a folder named "tmp", delete all the .sql files therein, you can also delete other temporary files to clear up more space. Most of the time, they are no big of a deal, the files there are temporary.

Ok, I'll do that now

Urguy

Quote from: Shereefah on Sep 08, 2024, 02:54 PM"(/tmp/#sql-temptable-1....MAI); waiting for someone to free some space... (errno: 28 "No space left on device")"

Go to your file manager and check for a folder named "tmp", delete all the .sql files therein, you can also delete other temporary files to clear up more space.

This did the trick, thanks guys. The website works fine now.


Quick Reply

Name:
Email:
Shortcuts: ALT+S post or ALT+P preview

Similar topics (3)