The Wikipedia Review: A forum for discussion and criticism of Wikipedia
Wikipedia Review Op-Ed Pages

Welcome, Guest! ( Log In | Register )

 
Reply to this topicStart new topic
> It worked!, Maintenance completed
Somey
post Thu 29th November 2007, 3:14am
Post #1


Can't actually moderate (or even post)
*********

Group: Moderators
Posts: 11,815
Joined: Sat 17th Jun 2006, 7:47pm
From: Dreamland
Member No.: 275



I know this is probably terrible timing, but we're going to have to do some database maintenance. Basically I'm going to download a backup, do some stuff with it, and then restore it, starting about 15 minutes from the time I post this... I don't know how long the restore will take, because it's a pretty big database and it all has to be uploaded at DSL speeds, but I suspect it'll be at least an hour, maybe two. (Doubtful it'll be any more than that.)

So, if you were about to post something, it might be a good idea to write it in a local text editor for now, so you don't lose it!

Technically I wouldn't have to take the board offline for this, but any posts made during the process would be lost, and that just seems wrong somehow.
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
Somey
post Thu 29th November 2007, 6:01am
Post #2


Can't actually moderate (or even post)
*********

Group: Moderators
Posts: 11,815
Joined: Sat 17th Jun 2006, 7:47pm
From: Dreamland
Member No.: 275



OK, that didn't go so well...

We might have to try this again tomorrow night, folks. I hate it when this happens!
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
Somey
post Thu 29th November 2007, 7:26am
Post #3


Can't actually moderate (or even post)
*********

Group: Moderators
Posts: 11,815
Joined: Sat 17th Jun 2006, 7:47pm
From: Dreamland
Member No.: 275



Um, just to add a little more detail to the foregoing, it looks like the board database is hugely bloated with "spider log" entries, so much so that it apparently prevented the restore process from completing. These things make up almost 2/3rds of the whole database! Sheesh... So maybe this is all Google's fault after all...

I knew they'd be involved, somehow. As if the billions of dollars weren't enough, they just had to go and do that too. angry.gif
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
Somey
post Fri 30th November 2007, 3:52am
Post #4


Can't actually moderate (or even post)
*********

Group: Moderators
Posts: 11,815
Joined: Sat 17th Jun 2006, 7:47pm
From: Dreamland
Member No.: 275



Hmm... I've given this some additional thought (I know, how can someone with no brain do such a thing) and I think we're going to hold off on the second attempt to fix the database until tomorrow night.

As it turns out, there are two problems - the aforementioned over-bloated spider_logs table, and also an odd bit of otherwise-harmless PHP code, stored in one of the settings tables somewhere, which is causing the restore procedure to fail. So I just have to unpack the backup, fix those things, and then repack it before restoring it. It'll take a bit longer, but hopefully nobody will mind too much...

Sheez, I dunno, maybe none of this is worth it... Still, let's assume that tomorrow night (it's about 10 PM right now where I am) we'll give this another shot, and with any luck, aftre that we'll have a nice clean packed database that can handle just about any amount of traffic the world throws at it.

By the way, did I mention that I'm an optimist...?
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
Somey
post Sat 1st December 2007, 2:59am
Post #5


Can't actually moderate (or even post)
*********

Group: Moderators
Posts: 11,815
Joined: Sat 17th Jun 2006, 7:47pm
From: Dreamland
Member No.: 275



OK folks. right now it's about 9 PM my time, or 3 AM UTC, or 2 PM in Sydney. We're going to try this again in half an hour... My plan is that it'll work this-a-way:

9:30 PM - board will go offline
10:00 PM - board homepage will be replaced with a temporary static HTML page
11:00 PM - database restored, board back online, everything hopefully back to normal

With any luck, I can get the database fixed, re-uploaded and restored in about 30 minutes - but I don't want to make any promises, guarantees, etc.

Sorry again for the inconvenience, folks! wink.gif
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
Somey
post Sat 1st December 2007, 4:14am
Post #6


Can't actually moderate (or even post)
*********

Group: Moderators
Posts: 11,815
Joined: Sat 17th Jun 2006, 7:47pm
From: Dreamland
Member No.: 275



Seems to have worked!

Yippee! smiling.gif

Well then - back to your regularly-scheduled "attack site," same attack-time, same attack-channel...
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
Herschelkrustofsky
post Sat 1st December 2007, 7:50am
Post #7


Member
*********

Group: Members
Posts: 5,199
Joined: Tue 18th Apr 2006, 12:05pm
From: Kalifornia
Member No.: 130

WP user page - talk
check - contribs



After all this, you deserve a raise.
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
guy
post Sat 1st December 2007, 7:55am
Post #8


Postmaster General
*********

Group: Inactive
Posts: 4,294
Joined: Mon 27th Feb 2006, 8:52pm
From: London
Member No.: 23



At least a barnstar

FORUM Image
User is offlineProfile CardPM
Go to the top of the page
+Quote Post

Reply to this topicStart new topic
2 User(s) are reading this topic (2 Guests and 0 Anonymous Users)
0 Members:

 

-   Lo-Fi Version Time is now: 23rd 10 17, 1:34pm