Search

[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")"

[Congra]

Check your database disk, it might be full.

[Urguy]

Check 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.

[Urguy]

"(/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]

"(/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.