SUNDAY JULY 23 - MAINTENANCE NOTICE

Discuss site matters here

Moderators: FishPants, ooRip

Post Reply
User avatar
FishPants
Server WhOOre
Posts: 4658
Joined: Fri Oct 15, 2004 1:38 pm
Location: Canada

SUNDAY JULY 23 - MAINTENANCE NOTICE

Post by FishPants »

I'm doing some stuff on the server, so if it stops responding, or sending off the odd error don't be alarmed.. It's just me one handed server admining... Doing some testing on board software upgrades etc, but at times I will need to pull a snapshot from here which may bog things down.
Last edited by FishPants on Sun Jul 23, 2017 10:18 pm, edited 1 time in total.
No.
User avatar
FishPants
Server WhOOre
Posts: 4658
Joined: Fri Oct 15, 2004 1:38 pm
Location: Canada

Re: SUNDAY JULY 23 - MAINTENANCE NOTICE

Post by FishPants »

Testing..
No.
User avatar
Isgrimnur
Posts: 82085
Joined: Sun Oct 15, 2006 12:29 am
Location: Chookity pok
Contact:

Re: SUNDAY JULY 23 - MAINTENANCE NOTICE

Post by Isgrimnur »

B+
It's almost as if people are the problem.
User avatar
FishPants
Server WhOOre
Posts: 4658
Joined: Fri Oct 15, 2004 1:38 pm
Location: Canada

Re: SUNDAY JULY 23 - MAINTENANCE NOTICE

Post by FishPants »

Isgrimnur wrote:B+
Sounds about right.. Sorry for the server lag, was moving another DB around and figured it's getting too late.. just killed it. I need sleep, but I'm kinda stoked about the speed of recovery. That's good stuff.
No.
User avatar
GreenGoo
Posts: 42239
Joined: Thu Oct 14, 2004 10:46 pm
Location: Ottawa, ON

Re: SUNDAY JULY 23 - MAINTENANCE NOTICE

Post by GreenGoo »

Sorry you had to spend some of your Sunday working on the site.

Thanks for your efforts though!
User avatar
Isgrimnur
Posts: 82085
Joined: Sun Oct 15, 2006 12:29 am
Location: Chookity pok
Contact:

Re: SUNDAY JULY 23 - MAINTENANCE NOTICE

Post by Isgrimnur »

Joking aside, we appreciate the hard work to keep us together in our little backwater burgh.
It's almost as if people are the problem.
User avatar
FishPants
Server WhOOre
Posts: 4658
Joined: Fri Oct 15, 2004 1:38 pm
Location: Canada

Re: SUNDAY JULY 23 - MAINTENANCE NOTICE

Post by FishPants »

Isgrimnur wrote:Joking aside, we appreciate the hard work to keep us together in our little backwater burgh.
Clearly what I was doing today caused it.. just not sure what.. I took a mysqldump of the site as a precaution (!!) before I did anything, then was poking around in other databases unrelated to this place. Not sure how that hosed the DB here, and logs weren't helpful.

Anyways a restore seemed to have chased the board goblins away. But come August, my wife and kids are away on a fabulous trip -- I'll be upgrading the board and sulking with my labradors (they sulk all the time).
No.
User avatar
Daehawk
Posts: 63524
Joined: Sat Jan 01, 2005 1:11 am

Re: SUNDAY JULY 23 - MAINTENANCE NOTICE

Post by Daehawk »

Really sorry FP. When I posted earlier about the failures I didn't mean for you to just jump in on Sunday. But after you started I couldn't post to say not to worry with it today.

Sorry mate. But thank you for that you did.
--------------------------------------------
I am Dyslexic of Borg, prepare to have your ass laminated.
I guess Ray Butts has ate his last pancake.
http://steamcommunity.com/id/daehawk
"Has high IQ. Refuses to apply it"
User avatar
FishPants
Server WhOOre
Posts: 4658
Joined: Fri Oct 15, 2004 1:38 pm
Location: Canada

Re: SUNDAY JULY 23 - MAINTENANCE NOTICE

Post by FishPants »

Daehawk wrote:Really sorry FP. When I posted earlier about the failures I didn't mean for you to just jump in on Sunday. But after you started I couldn't post to say not to worry with it today.

Sorry mate. But thank you for that you did.
Nah I'm glad you did.. I turned off the admin block, board came up -- I saw topics and moved on. Never ran into that before when you click a topic title and it tells you it doesn't exist anymore (yet the database showed all the posts/data). Weird.
No.
User avatar
AWS260
Posts: 12663
Joined: Wed Feb 08, 2006 12:51 pm
Location: Brooklyn

Re: SUNDAY JULY 23 - MAINTENANCE NOTICE

Post by AWS260 »

FYI, the search function seems to be off. A search for "Trump" only turns up five results, for example. Or maybe I've woken up in an alternate universe where Donald Trump doesn't exist?
User avatar
FishPants
Server WhOOre
Posts: 4658
Joined: Fri Oct 15, 2004 1:38 pm
Location: Canada

Re: SUNDAY JULY 23 - MAINTENANCE NOTICE

Post by FishPants »

AWS260 wrote:FYI, the search function seems to be off. A search for "Trump" only turns up five results, for example. Or maybe I've woken up in an alternate universe where Donald Trump doesn't exist?
Sadly no. Wonder if the search wordlist is borked, I can recreate that.
No.
User avatar
FishPants
Server WhOOre
Posts: 4658
Joined: Fri Oct 15, 2004 1:38 pm
Location: Canada

Re: SUNDAY JULY 23 - MAINTENANCE NOTICE

Post by FishPants »

Deleted the index and recreating it.. Not sure why the database and board are so out of sync. It's going to take a few days to do this, so bear with me.
No.
User avatar
FishPants
Server WhOOre
Posts: 4658
Joined: Fri Oct 15, 2004 1:38 pm
Location: Canada

Re: SUNDAY JULY 23 - MAINTENANCE NOTICE

Post by FishPants »

221 posts per second are being indexed.. I'm not doing the public math on what that means overall time wise, but I'd guess at least 6-8 hours.
No.
User avatar
coopasonic
Posts: 20967
Joined: Fri Mar 04, 2005 11:43 pm
Location: Dallas-ish

Re: SUNDAY JULY 23 - MAINTENANCE NOTICE

Post by coopasonic »

FishPants wrote:221 posts per second are being indexed.. I'm not doing the public math on what that means overall time wise, but I'd guess at least 6-8 hours.
3.11166415284062342885872297637 hours
-Coop
Black Lives Matter
User avatar
FishPants
Server WhOOre
Posts: 4658
Joined: Fri Oct 15, 2004 1:38 pm
Location: Canada

Re: SUNDAY JULY 23 - MAINTENANCE NOTICE

Post by FishPants »

coopasonic wrote:
FishPants wrote:221 posts per second are being indexed.. I'm not doing the public math on what that means overall time wise, but I'd guess at least 6-8 hours.
3.11166415284062342885872297637 hours
We are about halfway now. I think it varies depending on how big the posts are and other load on the system. DB process is chewing up CPU which is good, means it's working -- and most of the DB is held in RAM so it can't get much faster than it is.
No.
User avatar
LordMortis
Posts: 70097
Joined: Tue Oct 12, 2004 11:26 pm

Re: SUNDAY JULY 23 - MAINTENANCE NOTICE

Post by LordMortis »

FishPants wrote:Deleted the index and recreating it.. Not sure why the database and board are so out of sync. It's going to take a few days to do this, so bear with me.
<3 :wub:
User avatar
FishPants
Server WhOOre
Posts: 4658
Joined: Fri Oct 15, 2004 1:38 pm
Location: Canada

Re: SUNDAY JULY 23 - MAINTENANCE NOTICE

Post by FishPants »

Search indexing is done, should be fine now?
No.
User avatar
stessier
Posts: 29816
Joined: Tue Dec 21, 2004 12:30 pm
Location: SC

Re: SUNDAY JULY 23 - MAINTENANCE NOTICE

Post by stessier »

Yes, looks great!
I require a reminder as to why raining arcane destruction is not an appropriate response to all of life's indignities. - Vaarsuvius
Global Steam Wishmaslist Tracking
Running____2014: 1300.55 miles____2015: 2036.13 miles____2016: 1012.75 miles____2017: 1105.82 miles____2018: 1318.91 miles__2019: 2000.00 miles
User avatar
Rip
Posts: 26891
Joined: Tue Oct 12, 2004 9:34 pm
Location: Cajun Country!
Contact:

Re: SUNDAY JULY 23 - MAINTENANCE NOTICE

Post by Rip »

Awesome, more Trump for everyone.

:ninja:
User avatar
Daehawk
Posts: 63524
Joined: Sat Jan 01, 2005 1:11 am

Re: SUNDAY JULY 23 - MAINTENANCE NOTICE

Post by Daehawk »

Seems gooder again yeehhaaaa. :) And Thanks a bunch and sorry for the work.
--------------------------------------------
I am Dyslexic of Borg, prepare to have your ass laminated.
I guess Ray Butts has ate his last pancake.
http://steamcommunity.com/id/daehawk
"Has high IQ. Refuses to apply it"
Post Reply