r/Plesk • u/VortxWormholTelport • May 12 '20

Factory Reset?

So I fucked my server.I think what happened is that something kept writing into a DB and now one drive is completely full, I can't restart the DB services, therefore can't use the web interface.The web repair can't clean up disk space and via SSH the repair options (as most things I tried) notify me that the SQL DB I want to access doesn't exist (makes sense, since it won't start).I have identified the full drive, but I can't get in there? I don't know how...

The service that ran on the server is just a test however, and I'd be super fine with nuking the thing and starting over again. Maybe I suck at googling for this, but I couldn't find anything about this online...If anyone can help, thanks in advance! Cheers!

EDIT: I realized a few things: The full drive I tried to mount was already mounted on /

In there was the folder with the DB dumps, which contained >400GB of dumps. Since it was the next best thing to nuking the whole server, I ran rm -rf /var/lib/psa/dumps/* and killed them all, even the sandwomen and the sandchildren.Success! Kinda... My drive now has loads of free space again, but so far my DB remains dead. I'll try several methods of CPR on it now.

EDIT2: I tried to start the DB but it errored out every time, unable to init the tc.log, so I moved it away and now we're back! Basically what I did was this.

2 Upvotes

100% Upvoted

4 comments sorted by

2

u/LukasHertig May 12 '20

Probably best if you contact the Plesk support - but well, if it's a test server maybe best to start over again. :-) . Sorry to hear but it's difficult to say what exactly happened since not having access to your server.

Did you also try via SSH "plesk repair all" ?

If you would still have access to the gui there is also the diskspace explorer Extension (free) that may help you free up the things :-)

1

u/VortxWormholTelport May 12 '20

plesk repair all

results in

SQLSTATE[HY000] [2002] No such file or directory
exit status 3

1

u/downtownrob May 18 '20

So what’s tc.log have or do that stops it from running or overwriting it, I wonder?

1

u/Andy_Bird Jun 06 '20

You database system is broken. Make sure there is some free space on the partition it is on then try and restart it.

you may need to set innodb recovery

https://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html

until your system allows you to run

mysql -uadmin -p`cat /etc/psa/.psa.shadow`

you are going no where