@zaccx32 said in All hosts deleted/not showing in host list/groups:
After cleaning that up, a few hosts showed up but most are still missing and our images are not showing up in the GUI either.
While disk space is an important thing and 99% seems a lot in first sight, I don’t think this was causing the issue here. Why? Because we see you have a large disk with still 31 GB shown as free. I find it very strange that you see some hosts now. From the SHOW DATABASES; output you posted I would have guessed the fog DB is fully corrupted now and needs recovery (keeping my fingers crossed it’s still possible).
Also, when trying to access the fog DB today, is cannot be found any more, almost like it is gone.
Now we really need to figure out what’s going wrong with the DB. First of all let us take a look a the DB files on disk, the real basis: ls -al /var/lib/mysql (post a picture here)
As well stop the DB and take a file backup. Then start it up again and check the log:
service mysqld stop cd /root mkdir backup rsync -av /var/lib/mysql backup service mysqld start tail -n 30 /var/log/my*Post a picture of the output from the last command as well. I really hope I got all the commands right for your pretty dated CentOS 6.9 install.