2011-08-24 downtime.

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

Moderators: Richard Cranium, KoolBear, Krom, Lothar

Post Reply
User avatar
Krom
DBB Database Master
DBB Database Master
Posts: 15181
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 » Wed Aug 24, 2011 8:45 pm

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: 10368
Joined: Thu Jun 28, 2001 2:01 am
Location: Earth

Re: Today's downtime.

Post by Spidey » Wed Aug 24, 2011 8:52 pm

Yay!

Good work
.
When Republicans go low...Democrats go even lower.
User avatar
Isaac
DBB Artist
DBB Artist
Posts: 7127
Joined: Mon Aug 01, 2005 8:47 am
Location: Ơ̸̦͇̲̬̭̱̰͎̞͈̣͎͚̳ͬ͋̃̀̇͊͂͋͐ͦ̽ͣ̂ͥ͊̅̀̚͠ B̶͖̯͉̜̰̲̓̔͋̈́ͅ È̯ Y̪̤̼͉̠̙͝

Re: Today's downtime.

Post by Isaac » Wed Aug 24, 2011 9:12 pm

Happy Isaac is successful happy! Thanks guys!
s☼-£♦и̫͍ͥ̍ͪ͌̓͗͡о̡̹̱͊̅ͮ̓̕͢б̧̝̻̪̤̳̜͐̓̉ͤ͢͜ ͙̬͙̆̑ͮ̐ͭ̾̂́͘i̎̌̾̓̽̀̈̓̀҉͉̙̦͎̘̝͕f̻͕͔̘ͣͣ̓͊̿͢͜ ͍͔͈͕̮̫ͣ̆ͮ̊͋/♂6Æ!♪╩"▲L└уͭ̂͐̇҉̴̣̼̞̠̯͓̺̞ф̜̊͌̈́̋̏̐́ц̨͔̮̿̇ ̨̛͖̙͖̖̮̗̱ͩ̆͞ͅа̥͇̞̖͚̟̅͐ͤ͞͠͠э̜̘̩̳̬͔̾ͯ̀ͫ̒̐̿ͅͅг̭̖̀ͦ̒̑ͥ̌ͮͫ͞ё͔̟̃ͬ̾̓͟ё̦̞̙̫͔̩͑̀͂ͯ̄̔̃̑̀͠ͅͅ
User avatar
Jeff250
DBB Master
DBB Master
Posts: 6387
Joined: Sun Sep 05, 1999 2:01 am
Location: ☃☃☃

Re: Today's downtime.

Post by Jeff250 » Wed Aug 24, 2011 9:18 pm

The MySQL conversion has been a long time coming--nice!
User avatar
Isaac
DBB Artist
DBB Artist
Posts: 7127
Joined: Mon Aug 01, 2005 8:47 am
Location: Ơ̸̦͇̲̬̭̱̰͎̞͈̣͎͚̳ͬ͋̃̀̇͊͂͋͐ͦ̽ͣ̂ͥ͊̅̀̚͠ B̶͖̯͉̜̰̲̓̔͋̈́ͅ È̯ Y̪̤̼͉̠̙͝

Re: Today's downtime.

Post by Isaac » Wed Aug 24, 2011 9:26 pm

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
s☼-£♦и̫͍ͥ̍ͪ͌̓͗͡о̡̹̱͊̅ͮ̓̕͢б̧̝̻̪̤̳̜͐̓̉ͤ͢͜ ͙̬͙̆̑ͮ̐ͭ̾̂́͘i̎̌̾̓̽̀̈̓̀҉͉̙̦͎̘̝͕f̻͕͔̘ͣͣ̓͊̿͢͜ ͍͔͈͕̮̫ͣ̆ͮ̊͋/♂6Æ!♪╩"▲L└уͭ̂͐̇҉̴̣̼̞̠̯͓̺̞ф̜̊͌̈́̋̏̐́ц̨͔̮̿̇ ̨̛͖̙͖̖̮̗̱ͩ̆͞ͅа̥͇̞̖͚̟̅͐ͤ͞͠͠э̜̘̩̳̬͔̾ͯ̀ͫ̒̐̿ͅͅг̭̖̀ͦ̒̑ͥ̌ͮͫ͞ё͔̟̃ͬ̾̓͟ё̦̞̙̫͔̩͑̀͂ͯ̄̔̃̑̀͠ͅͅ
Richard Cranium
DBB Supporter
DBB Supporter
Posts: 1438
Joined: Tue Aug 07, 2001 2:01 am

Re: Today's downtime.

Post by Richard Cranium » Wed Aug 24, 2011 11:10 pm

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: 4627
Joined: Sun Nov 25, 2001 3:01 am
Location: Indiana, U.S.A.

Re: Today's downtime.

Post by Sergeant Thorne » Thu Aug 25, 2011 3:58 am

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

Re: Today's downtime.

Post by Foil » Thu Aug 25, 2011 8:28 am

Many thanks to RC and Krom! :D

<Hip! Hip! Hoorah!>
User avatar
Krom
DBB Database Master
DBB Database Master
Posts: 15181
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 » Thu Aug 25, 2011 8:51 am

And the board software update to the latest version is done.
User avatar
Isaac
DBB Artist
DBB Artist
Posts: 7127
Joined: Mon Aug 01, 2005 8:47 am
Location: Ơ̸̦͇̲̬̭̱̰͎̞͈̣͎͚̳ͬ͋̃̀̇͊͂͋͐ͦ̽ͣ̂ͥ͊̅̀̚͠ B̶͖̯͉̜̰̲̓̔͋̈́ͅ È̯ Y̪̤̼͉̠̙͝

Re: 2011-08-24 downtime.

Post by Isaac » Thu Aug 25, 2011 9:00 am

Cool. So the forum is more stable and faster?
s☼-£♦и̫͍ͥ̍ͪ͌̓͗͡о̡̹̱͊̅ͮ̓̕͢б̧̝̻̪̤̳̜͐̓̉ͤ͢͜ ͙̬͙̆̑ͮ̐ͭ̾̂́͘i̎̌̾̓̽̀̈̓̀҉͉̙̦͎̘̝͕f̻͕͔̘ͣͣ̓͊̿͢͜ ͍͔͈͕̮̫ͣ̆ͮ̊͋/♂6Æ!♪╩"▲L└уͭ̂͐̇҉̴̣̼̞̠̯͓̺̞ф̜̊͌̈́̋̏̐́ц̨͔̮̿̇ ̨̛͖̙͖̖̮̗̱ͩ̆͞ͅа̥͇̞̖͚̟̅͐ͤ͞͠͠э̜̘̩̳̬͔̾ͯ̀ͫ̒̐̿ͅͅг̭̖̀ͦ̒̑ͥ̌ͮͫ͞ё͔̟̃ͬ̾̓͟ё̦̞̙̫͔̩͑̀͂ͯ̄̔̃̑̀͠ͅͅ
User avatar
Krom
DBB Database Master
DBB Database Master
Posts: 15181
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 » Thu Aug 25, 2011 9:02 am

Mostly security fixes.
User avatar
Isaac
DBB Artist
DBB Artist
Posts: 7127
Joined: Mon Aug 01, 2005 8:47 am
Location: Ơ̸̦͇̲̬̭̱̰͎̞͈̣͎͚̳ͬ͋̃̀̇͊͂͋͐ͦ̽ͣ̂ͥ͊̅̀̚͠ B̶͖̯͉̜̰̲̓̔͋̈́ͅ È̯ Y̪̤̼͉̠̙͝

Re: 2011-08-24 downtime.

Post by Isaac » Thu Aug 25, 2011 9:53 am

Oh yeah, that's good. There's a lot of crazies out there. Its good we have more security.
s☼-£♦и̫͍ͥ̍ͪ͌̓͗͡о̡̹̱͊̅ͮ̓̕͢б̧̝̻̪̤̳̜͐̓̉ͤ͢͜ ͙̬͙̆̑ͮ̐ͭ̾̂́͘i̎̌̾̓̽̀̈̓̀҉͉̙̦͎̘̝͕f̻͕͔̘ͣͣ̓͊̿͢͜ ͍͔͈͕̮̫ͣ̆ͮ̊͋/♂6Æ!♪╩"▲L└уͭ̂͐̇҉̴̣̼̞̠̯͓̺̞ф̜̊͌̈́̋̏̐́ц̨͔̮̿̇ ̨̛͖̙͖̖̮̗̱ͩ̆͞ͅа̥͇̞̖͚̟̅͐ͤ͞͠͠э̜̘̩̳̬͔̾ͯ̀ͫ̒̐̿ͅͅг̭̖̀ͦ̒̑ͥ̌ͮͫ͞ё͔̟̃ͬ̾̓͟ё̦̞̙̫͔̩͑̀͂ͯ̄̔̃̑̀͠ͅͅ
User avatar
Tunnelcat
DBB Grand Master
DBB Grand Master
Posts: 10682
Joined: Sat Mar 24, 2007 12:32 pm
Location: Corvallis, Oregon, where you don't tan, you rust.

Re: 2011-08-24 downtime.

Post by Tunnelcat » Thu Aug 25, 2011 4:10 pm

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: 4434
Joined: Thu Sep 02, 1999 2:01 am

Re: 2011-08-24 downtime.

Post by snoopy » Fri Aug 26, 2011 1:35 pm

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: 14360
Joined: Sat Apr 09, 2011 8:12 am
Location: Rockland,DE and Parksley, VA

Re: 2011-08-24 downtime.

Post by callmeslick » Sat Aug 27, 2011 6:42 am

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: 9205
Joined: Thu Nov 22, 2001 3:01 am
Location: Beaverton, Oregon USA

Re: 2011-08-24 downtime.

Post by Duper » Sun Aug 28, 2011 5:27 pm

*faint!*

(well done guys!)
Post Reply