Author Topic: DB Errors - RESOLVED  (Read 1336 times)

0 Members and 1 Guest are viewing this topic.

Offline OJsDad

  • Crossbowman
  • *
  • Posts: 6355
  • Fighting for Oppressed Individualism
DB Errors - RESOLVED
« on: July 07, 2016, 08:36:13 AM »
Is anyone else seeing a lot of DB errors this morning. 





(admin edit just to update thread title)
« Last Edit: July 09, 2016, 05:43:30 AM by bayonetbrant »
'Here at NASA we all pee the same color.'  Al Harrison from the movie Hidden Figures.


Offline OJsDad

  • Crossbowman
  • *
  • Posts: 6355
  • Fighting for Oppressed Individualism
Re: DB Errors
« Reply #1 on: July 07, 2016, 08:37:35 AM »
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.

Offline bayonetbrant

  • Chief Arrogance Mitigator
  • Musketeer
  • *****
  • Posts: 37049
  • Loitering With Intent
Re: DB Errors
« Reply #2 on: July 07, 2016, 08:38:10 AM »
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

Offline bayonetbrant

  • Chief Arrogance Mitigator
  • Musketeer
  • *****
  • Posts: 37049
  • Loitering With Intent
Re: DB Errors
« Reply #3 on: July 07, 2016, 09:24:31 AM »
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

Offline mirth

  • Tercio
  • ******
  • Posts: 48615
  • Cardboard Harlot
Re: DB Errors
« Reply #4 on: July 07, 2016, 10:02:08 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

Offline bayonetbrant

  • Chief Arrogance Mitigator
  • Musketeer
  • *****
  • Posts: 37049
  • Loitering With Intent
Re: DB Errors
« Reply #5 on: July 09, 2016, 05:42:54 AM »
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

Offline Con

  • Man-at-Arms
  • *****
  • Posts: 1784
Re: DB Errors - RESOLVED
« Reply #6 on: July 09, 2016, 12:56:16 PM »
I hear Mirth has a regular overflow problem maybe he could advise you on what he does?