Database issue..unable to remove entry

Virtualmin
1

ubuntu 20.04 LTS. I had a client account hit quota and it caused some relaly weird sql issues. I ma now trying to gt the account cleared out of mysql. All of the files are deleted but somwewhere inside of mysql it thinks the db is around. here’s the error i am getting now trying to clean out the database:

Failed to drop databases : SQL select count(*) from wp_commentmeta failed : Tablespace is missing for table rotzbrickandblock.wp_commentmeta.

I’ve been looking around on the machine and i cannot find any remaining files so it appears to be stuck somewhere inside of mysql itself. any ideas?

2

i had to log into the mysql root shell and use the command drop database if exists name of db; and mysql FINALLY has forgotten the db…:slight_smile:

3

here’s my postmortem on things. NOt blaming virt i think the system barfed in a weird way once the disk quota go overloaded. hopefully this helps someone else if they ever hit something weird like this:
https://etc-md.com/2021/09/23/when-a-hosting-client-exposes-a-bug-and-takes-your-server-offline/

4

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.