Main Menu

DB Errors - RESOLVED

Started by OJsDad, July 07, 2016, 09:36:13 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

OJsDad

Is anyone else seeing a lot of DB errors this morning. 





(admin edit just to update thread title)
'Here at NASA we all pee the same color.'  Al Harrison from the movie Hidden Figures.

OJsDad

NM.  I was able to finally get the front page to load and see the message there now.
'Here at NASA we all pee the same color.'  Al Harrison from the movie Hidden Figures.

bayonetbrant

We've been trying to update / correct some errors with the database on 7/7/16.  Posts made between 0630 - 1000 EDT might have disappeared.  We're trying to stabilize things now.
The key to surviving this site is to not say something which ends up as someone's tag line - Steelgrave

"their citizens (all of them counted as such) glorified their mythology of 'rights'...and lost track of their duties. No nation, so constituted, can endure." Robert Heinlein, Starship Troopers

bayonetbrant

Update as of 07 July 2016, 1120 EDT

Our host is having an issue with their MySQL configurations on an entire spate of servers and is busy trying to fix it. It's affecting several hundred sites (at least) and not just us. They're supposed to notify us when its fixed, but it might get fixed long before they get around to emailing/calling us.
The key to surviving this site is to not say something which ends up as someone's tag line - Steelgrave

"their citizens (all of them counted as such) glorified their mythology of 'rights'...and lost track of their duties. No nation, so constituted, can endure." Robert Heinlein, Starship Troopers

mirth

Quote from: bayonetbrant on July 07, 2016, 09:38:10 AM
Posts made between 0630 - 1000 EDT might have disappeared.

My posts! My beuatiful posts!
"45 minutes of pooping Tribbles being juggled by a drunken Horta would be better than Season 1 of TNG." - SirAndrewD

"you don't look at the mantelpiece when you're poking the fire" - Bawb

"Can't 'un' until you 'pre', son." - Gus

bayonetbrant

Final update:

For DBs that got up to a certain size, our host had an overflow server where they'd move the DBs.  Ours got over that size b/c one of our log files somehow ended up exploding to a ridiculously-huge size (separate issue that we need to figure out).

That overflow server had a problem with the way the underlying SQL app was configured, and that configuration was causing errors for everyone who was on that server, not just us.  So there were several hundred people affected, but the host hasn't told anyone why the configuration was wrong (probably on legal advice).

After some poking around, it looks like there were no posts that were lost, but there was a period of time during which not a lot of people could reliably get into - and stay on - the forums to even try to submit a post.  But since we didn't need to roll back out DB at all, nothing was lost.
The key to surviving this site is to not say something which ends up as someone's tag line - Steelgrave

"their citizens (all of them counted as such) glorified their mythology of 'rights'...and lost track of their duties. No nation, so constituted, can endure." Robert Heinlein, Starship Troopers

Con

I hear Mirth has a regular overflow problem maybe he could advise you on what he does?