Thread: Server outrages
View Single Post
Old 2020-01-12, 00:14   #561
gd_barnes
 
gd_barnes's Avatar
 
May 2007
Kansas; USA

237638 Posts
Default

A little more info:

I am able to do selects on all of the databases with the exception of the CandidateTestResult table on database prpnet1470. I can do selects on other tables in that one.

So no data will be lost except a small amount on prpnet1470.

But I cannot do any deletes on any table. My suspicion is that no table can be updated in any way...insert, update, or delete. That is why all of the prpnet servers start up just fine but when they try to receive a completed test an SQL error happens.

This begs the question: Why does one corrupt database affect MySQL in total such that other databases cannot be updated?

Last fiddled with by gd_barnes on 2020-01-12 at 00:15
gd_barnes is offline   Reply With Quote