Control Web Panel

WebPanel => CentOS 9 Problems => Topic started by: Starburst on August 12, 2024, 03:32:32 PM

Title: Getting the dreaded "DISK FULL: Can't start MySQL!"
Post by: Starburst 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:

Title: Re: Getting the dreaded "DISK FULL: Can't start MySQL!"
Post by: overseer 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.

Title: Re: Getting the dreaded "DISK FULL: Can't start MySQL!"
Post by: Starburst 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.

Title: Re: Getting the dreaded "DISK FULL: Can't start MySQL!"
Post by: BeZazz on August 14, 2024, 03:20:29 AM

Code: [Select]

find / -type f -size +500Mcan add in

Code: [Select]

-name "*.ext"

Title: Re: Getting the dreaded "DISK FULL: Can't start MySQL!"
Post by: overseer 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

Title: Re: Getting the dreaded "DISK FULL: Can't start MySQL!"
Post by: Starburst 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.

Title: Re: Getting the dreaded "DISK FULL: Can't start MySQL!"
Post by: overseer on August 16, 2024, 02:21:46 AM

Super honeypot! Good idea.

Title: Re: Getting the dreaded "DISK FULL: Can't start MySQL!"
Post by: Starburst on August 16, 2024, 07:31:46 AM

Quote from: overseer on August 16, 2024, 02:21:46 AM

Super honeypot! Good idea.

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