SUNDAY JULY 23 - MAINTENANCE NOTICE

Discuss site matters here

Moderators: FishPants, ooRip

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

SUNDAY JULY 23 - MAINTENANCE NOTICE

Post by FishPants » Sun Jul 23, 2017 10:28 am

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: 4232
Joined: Fri Oct 15, 2004 1:38 pm
Location: Canada

Re: SUNDAY JULY 23 - MAINTENANCE NOTICE

Post by FishPants » Sun Jul 23, 2017 10:19 pm

Testing..
No.

User avatar
Isgrimnur
Posts: 51570
Joined: Sun Oct 15, 2006 12:29 am
Location: Dallas, TX
Contact:

Re: SUNDAY JULY 23 - MAINTENANCE NOTICE

Post by Isgrimnur » Sun Jul 23, 2017 10:23 pm

B+
Silver - 6k

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

Re: SUNDAY JULY 23 - MAINTENANCE NOTICE

Post by FishPants » Sun Jul 23, 2017 10:24 pm

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: 33067
Joined: Thu Oct 14, 2004 10:46 pm
Location: Ottawa, ON

Re: SUNDAY JULY 23 - MAINTENANCE NOTICE

Post by GreenGoo » Sun Jul 23, 2017 10:27 pm

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

Thanks for your efforts though!

User avatar
Isgrimnur
Posts: 51570
Joined: Sun Oct 15, 2006 12:29 am
Location: Dallas, TX
Contact:

Re: SUNDAY JULY 23 - MAINTENANCE NOTICE

Post by Isgrimnur » Sun Jul 23, 2017 10:28 pm

Joking aside, we appreciate the hard work to keep us together in our little backwater burgh.
Silver - 6k

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

Re: SUNDAY JULY 23 - MAINTENANCE NOTICE

Post by FishPants » Sun Jul 23, 2017 10:30 pm

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: 36577
Joined: Sat Jan 01, 2005 1:11 am

Re: SUNDAY JULY 23 - MAINTENANCE NOTICE

Post by Daehawk » Sun Jul 23, 2017 11:15 pm

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.
GroovAtroN, stop asking
I guess Ray Butts has ate his last pancake.
http://steamcommunity.com/id/daehawk

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

Re: SUNDAY JULY 23 - MAINTENANCE NOTICE

Post by FishPants » Sun Jul 23, 2017 11:17 pm

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: 9268
Joined: Wed Feb 08, 2006 12:51 pm
Location: Brooklyn

Re: SUNDAY JULY 23 - MAINTENANCE NOTICE

Post by AWS260 » Mon Jul 24, 2017 10:07 am

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?
2 Kings 2:24

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

Re: SUNDAY JULY 23 - MAINTENANCE NOTICE

Post by FishPants » Mon Jul 24, 2017 10:08 am

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: 4232
Joined: Fri Oct 15, 2004 1:38 pm
Location: Canada

Re: SUNDAY JULY 23 - MAINTENANCE NOTICE

Post by FishPants » Mon Jul 24, 2017 10:11 am

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: 4232
Joined: Fri Oct 15, 2004 1:38 pm
Location: Canada

Re: SUNDAY JULY 23 - MAINTENANCE NOTICE

Post by FishPants » Mon Jul 24, 2017 10:19 am

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: 13783
Joined: Fri Mar 04, 2005 11:43 pm
Location: Dallas-ish

Re: SUNDAY JULY 23 - MAINTENANCE NOTICE

Post by coopasonic » Mon Jul 24, 2017 11:07 am

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

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

Re: SUNDAY JULY 23 - MAINTENANCE NOTICE

Post by FishPants » Mon Jul 24, 2017 11:44 am

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: 56821
Joined: Tue Oct 12, 2004 11:26 pm

Re: SUNDAY JULY 23 - MAINTENANCE NOTICE

Post by LordMortis » Mon Jul 24, 2017 12:15 pm

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: 4232
Joined: Fri Oct 15, 2004 1:38 pm
Location: Canada

Re: SUNDAY JULY 23 - MAINTENANCE NOTICE

Post by FishPants » Mon Jul 24, 2017 1:59 pm

Search indexing is done, should be fine now?
No.

User avatar
stessier
Posts: 22205
Joined: Tue Dec 21, 2004 12:30 pm
Location: SC

Re: SUNDAY JULY 23 - MAINTENANCE NOTICE

Post by stessier » Mon Jul 24, 2017 2:02 pm

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
Running 2015: 2036.13 miles

User avatar
Rip
Posts: 25447
Joined: Tue Oct 12, 2004 9:34 pm
Location: Cajun Country!
Contact:

Re: SUNDAY JULY 23 - MAINTENANCE NOTICE

Post by Rip » Mon Jul 24, 2017 2:19 pm

Awesome, more Trump for everyone.

:ninja:

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

Re: SUNDAY JULY 23 - MAINTENANCE NOTICE

Post by Daehawk » Mon Jul 24, 2017 9:18 pm

Seems gooder again yeehhaaaa. :) And Thanks a bunch and sorry for the work.
---------------------------------------------
I am Dyslexic of Borg, prepare to have your ass laminated.
GroovAtroN, stop asking
I guess Ray Butts has ate his last pancake.
http://steamcommunity.com/id/daehawk

Post Reply