2011-08-24 downtime.

For questions, special requests, or any complaints concerning the Descent BB.

Moderators: Krom, Lothar, Richard Cranium, KoolBear

Post Reply
User avatar
Krom
DBB Database Master
DBB Database Master
Posts: 16125
Joined: Sun Nov 29, 1998 3:01 am
Location: Camping the energy center. BTW, did you know you can have up to 100 characters in this location box?
Contact:

2011-08-24 downtime.

Post by Krom »

So some of you might have noticed that the board was offline for a bit today, and even after it came back I had disabled it for a short while.

Well, the problem that has been a headache for RC and I for a while, the database log file growing to absurd proportions for no apparent or fixable reason finally reached its limits and mssql refused to serve the board anymore till we manually truncated the log file (which had no negative impact on the board and RC was able to do it from his smart phone). Then this evening I logged into the server and did what I've been meaning to do for quite some time: change the database back-end from the MSSQL server to a MySQL server RC kindly installed specifically for this board.

So on this new back-end, the out of control log file problem should be resolved (although I will be keeping an eye on it for sure). But more importantly MySQL brings a very useful side benefit: fulltext native mysql search indexing. So for the first time in years, the built in search engine on the board works.

TL/DR: SEARCH WORKS AGAIN.

P.S. there might be a minor blip of downtime tomorrow while I update the board software.
User avatar
Spidey
DBB Grand Master
DBB Grand Master
Posts: 10798
Joined: Thu Jun 28, 2001 2:01 am
Location: Earth

Re: Today's downtime.

Post by Spidey »

Yay!

Good work
User avatar
Isaac
DBB Artist
DBB Artist
Posts: 7736
Joined: Mon Aug 01, 2005 8:47 am
Location: 🍕

Re: Today's downtime.

Post by Isaac »

Happy Isaac is successful happy! Thanks guys!
❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉
-⎽__⎽-⎻⎺⎺⎻-⎽__⎽--⎻⎺⎺⎻-★ ·:*¨༺꧁༺ :E ༻꧂༻¨*:·.★-⎽__⎽-⎻⎺⎺⎻-⎽__⎽--⎻⎺⎺⎻-
❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉
User avatar
Jeff250
DBB Master
DBB Master
Posts: 6530
Joined: Sun Sep 05, 1999 2:01 am
Location: ❄️❄️❄️

Re: Today's downtime.

Post by Jeff250 »

The MySQL conversion has been a long time coming--nice!
User avatar
Isaac
DBB Artist
DBB Artist
Posts: 7736
Joined: Mon Aug 01, 2005 8:47 am
Location: 🍕

Re: Today's downtime.

Post by Isaac »

Jeff, I replied to you in the tech forum, but I think the natural internet disaster erased it. It was not insured. I'll have to rewrite it. :P
❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉
-⎽__⎽-⎻⎺⎺⎻-⎽__⎽--⎻⎺⎺⎻-★ ·:*¨༺꧁༺ :E ༻꧂༻¨*:·.★-⎽__⎽-⎻⎺⎺⎻-⎽__⎽--⎻⎺⎺⎻-
❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉
Richard Cranium
DBB Supporter
DBB Supporter
Posts: 1444
Joined: Tue Aug 07, 2001 2:01 am

Re: Today's downtime.

Post by Richard Cranium »

All the kudos go to Krom on this one. Way to go on the DB conversion.
User avatar
Sergeant Thorne
DBB Material Defender
DBB Material Defender
Posts: 4641
Joined: Sun Nov 25, 2001 3:01 am
Location: Indiana, U.S.A.

Re: Today's downtime.

Post by Sergeant Thorne »

Nice!
User avatar
Foil
DBB Material Defender
DBB Material Defender
Posts: 4900
Joined: Tue Nov 23, 2004 3:31 pm
Location: Denver, Colorado, USA
Contact:

Re: Today's downtime.

Post by Foil »

Many thanks to RC and Krom! :D

<Hip! Hip! Hoorah!>
User avatar
Krom
DBB Database Master
DBB Database Master
Posts: 16125
Joined: Sun Nov 29, 1998 3:01 am
Location: Camping the energy center. BTW, did you know you can have up to 100 characters in this location box?
Contact:

Re: 2011-08-24 downtime.

Post by Krom »

And the board software update to the latest version is done.
User avatar
Isaac
DBB Artist
DBB Artist
Posts: 7736
Joined: Mon Aug 01, 2005 8:47 am
Location: 🍕

Re: 2011-08-24 downtime.

Post by Isaac »

Cool. So the forum is more stable and faster?
❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉
-⎽__⎽-⎻⎺⎺⎻-⎽__⎽--⎻⎺⎺⎻-★ ·:*¨༺꧁༺ :E ༻꧂༻¨*:·.★-⎽__⎽-⎻⎺⎺⎻-⎽__⎽--⎻⎺⎺⎻-
❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉
User avatar
Krom
DBB Database Master
DBB Database Master
Posts: 16125
Joined: Sun Nov 29, 1998 3:01 am
Location: Camping the energy center. BTW, did you know you can have up to 100 characters in this location box?
Contact:

Re: 2011-08-24 downtime.

Post by Krom »

Mostly security fixes.
User avatar
Isaac
DBB Artist
DBB Artist
Posts: 7736
Joined: Mon Aug 01, 2005 8:47 am
Location: 🍕

Re: 2011-08-24 downtime.

Post by Isaac »

Oh yeah, that's good. There's a lot of crazies out there. Its good we have more security.
❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉
-⎽__⎽-⎻⎺⎺⎻-⎽__⎽--⎻⎺⎺⎻-★ ·:*¨༺꧁༺ :E ༻꧂༻¨*:·.★-⎽__⎽-⎻⎺⎺⎻-⎽__⎽--⎻⎺⎺⎻-
❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉❉⊱•═•⊰❉⊱•═•⊰❉⊱•═•⊰❉
User avatar
Tunnelcat
DBB Grand Master
DBB Grand Master
Posts: 13691
Joined: Sat Mar 24, 2007 12:32 pm
Location: Pacific Northwest, U.S.A.

Re: 2011-08-24 downtime.

Post by Tunnelcat »

Thanks Krom and everyone else who has worked hard to maintain and upgrade the DBB board. It's getting really polished now. :)
Cat (n.) A bipolar creature which would as soon gouge your eyes out as it would cuddle.
User avatar
snoopy
DBB Benefactor
DBB Benefactor
Posts: 4435
Joined: Thu Sep 02, 1999 2:01 am

Re: 2011-08-24 downtime.

Post by snoopy »

Thanks for the work!
Arch Linux x86-64, Openbox
"We'll just set a new course for that empty region over there, near that blackish, holeish thing. " Zapp Brannigan
User avatar
callmeslick
DBB Grand Master
DBB Grand Master
Posts: 14546
Joined: Sat Apr 09, 2011 8:12 am
Location: Rockland,DE and Parksley, VA

Re: 2011-08-24 downtime.

Post by callmeslick »

good job, and thanks. Folks who do the work to maintain places like this are so valuable!
"The Party told you to reject all evidence of your eyes and ears. It was their final, most essential command."
George Orwell---"1984"
User avatar
Duper
DBB Master
DBB Master
Posts: 9214
Joined: Thu Nov 22, 2001 3:01 am
Location: Beaverton, Oregon USA

Re: 2011-08-24 downtime.

Post by Duper »

*faint!*

(well done guys!)
Post Reply