Author Topic: Getting the dreaded "DISK FULL: Can't start MySQL!"  (Read 516 times)

0 Members and 1 Guest are viewing this topic.

Offline
*****
Getting the dreaded "DISK FULL: Can't start MySQL!"
« on: August 12, 2024, 03:32:32 PM »
@overseer
I remember this being a problem in the past, and I can't remember what the simple fix was.
All log files have already been deleted, and that didn't make a difference.

Multiple AlmaLinux 9 servers with the same config for mirrors, but this one has run out of disk space.
Which is weird.

--

Quote
Warning: mysqli_connect(): (HY000/2002): No such file or directory in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0

Warning: mysqli_connect(): (HY000/2002): No such file or directory in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0

Warning: mysqli_connect(): (HY000/2002): No such file or directory in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0

Warning: mysqli_connect(): (HY000/2002): No such file or directory in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0


DISK FULL: Can't start MySQL!


Warning: mysqli_error() expects exactly 1 parameter, 0 given in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0
Could not connect:

Offline
*****
Re: Getting the dreaded "DISK FULL: Can't start MySQL!"
« Reply #1 on: August 13, 2024, 09:12:38 PM »
I assume you've already gone on a hunt for +500MB files?

Look for a singular very large myisam table (all files) .frm, .MYI, .MYD -- offload or download & delete to free up disk space.

Offline
*****
Re: Getting the dreaded "DISK FULL: Can't start MySQL!"
« Reply #2 on: August 14, 2024, 02:29:04 AM »
Yea, I think the space is getting eating up by rsync.
But I can't find where.

On this mirror server we where running rsync for MariaDB, besides the regular http & https.

Any trick to find only large files?

Code: [Select]
du -hs /*Wasn't much of a help, and couldn't find any rsync.log with find.

What I have wound up doing was deleting the whole MariaDB directory, and am pulling from the master now to rebuild with rsync disabled.

Offline
*
Re: Getting the dreaded "DISK FULL: Can't start MySQL!"
« Reply #3 on: August 14, 2024, 03:20:29 AM »
Code: [Select]
find / -type f -size +500Mcan add in
Code: [Select]
-name "*.ext"

Offline
*****
Re: Getting the dreaded "DISK FULL: Can't start MySQL!"
« Reply #4 on: August 14, 2024, 04:29:51 AM »
I usually use:
Code: [Select]
sudo find / -xdev -type f -size +500Mor
Code: [Select]
du -ahx . | sort -rh | head -5

Offline
*****
Re: Getting the dreaded "DISK FULL: Can't start MySQL!"
« Reply #5 on: August 15, 2024, 05:41:50 PM »
Will try that if it happens again.

To get the mirror back operational, so it can be attacked by script kiddies in India I just deleted and re-imaged the MariaDB repo.

Bringing up a server just for the MariaDB repo mirror in India with AL9 now.
And will see how it does with rsync enabled.

Offline
*****
Re: Getting the dreaded "DISK FULL: Can't start MySQL!"
« Reply #6 on: August 16, 2024, 02:21:46 AM »
Super honeypot! Good idea.

Offline
*****
Re: Getting the dreaded "DISK FULL: Can't start MySQL!"
« Reply #7 on: August 16, 2024, 07:31:46 AM »
Super honeypot! Good idea.

So far out of all the mirrors, the new ones in India are getting hit the hardest.