Go Back   RedCafe.net > Miscellaneous > Admin/Mod Help Forum

Reply
 
Thread Tools
Old 26th July 2011, 16:57   #1 (permalink)
Fallible Super Being
 
Join Date: Jun 1999
Location: Dublin
Posts: 7,205
...and we're back

After a ridiculously long stretch of downtime, we have successfully resolved a hardware fault with the database server and rolled back the database to a backup from approx midnight on Saturday. Obviously this means everything posted since then has been lost, but given the amount of data corruption in the database, it was the safest option.

I can't apologise enough for this downtime. It has been a hugely frustrating couple of days. What should have been a relatively straight forward move of server hardware from one data centre to another turned into a bit of a nightmare.

Hopefully now everything is back to normal and we can forget this ever happened As ever, you guys are my best eyes and ears so if you come across any odd behaviour - error pages, double posts etc - please post here and I'll investigate. The more detail you can provide about the problem the better.

Thanks again for your patience. Hopefully this is the last time we have such a lengthy outage.

Update:
So I spoke to soon. Obviously we're still having a lot of problems, error pages, double posts. We're actively looking into it and hopefully a solution is not far away.

Update 2:
I think we've tracked down the problem, a rogue database query that was using the wrong index which lead to long running queries that would eventually block all the database threads. As ever, can people please let me know if things are working better now - specifically when it comes to posting and editing posts. Thanks.
Niall is offline   Reply With Quote
Old 26th July 2011, 17:10   #2 (permalink)
First Team Regular
 
Join Date: May 2007
Location: Using location as a tagline: because I'm just not cool enough to have my own.
Posts: 18,585
First post back!
SharkyMcShark is offline   Reply With Quote
Old 26th July 2011, 17:10   #3 (permalink)
Reserve Team Player
 
Join Date: Nov 2009
Posts: 4,968
Thanks for the work / effort in getting my addiction back up.
Shimo is offline   Reply With Quote
Old 26th July 2011, 17:10   #4 (permalink)
Reserve Team Player
 
Join Date: Nov 2005
Location: We all love United
Posts: 4,621
Get in!
SATA is offline   Reply With Quote
Old 26th July 2011, 17:11   #5 (permalink)
Wobbles like a massive pair of tits
 
Join Date: Apr 2007
Posts: 13,227
...aaaaanndddd breaaatthhhheeee.
MikeUpNorth is offline   Reply With Quote
Old 26th July 2011, 17:15   #6 (permalink)
Billy no mates and im shit at Halo
 
Join Date: Nov 2000
Location: Billy fuckin no mate, thats me!!!
Posts: 5,094
I have come to realize I have a serious problem with my addiction to this site.
Billy Blaggs is offline   Reply With Quote
Old 26th July 2011, 17:16   #7 (permalink)
Brewlio's fugly sister
 
Join Date: Nov 2006
Location: Why don't we just kill Badger?
Posts: 27,680
I'm getting the 'Canae take the strain' message when I try to quick reply.
Brophs is offline   Reply With Quote
Old 26th July 2011, 17:31   #8 (permalink)
WR
Formerly Wayne_Rooney
 
Join Date: Sep 2009
Location: SM: Milwall
Posts: 8,807
Testing
WR is online now   Reply With Quote
Old 26th July 2011, 17:31   #9 (permalink)
Observant
 
Join Date: Jun 2001
Location: MG was wearing a lovely dress and I talked her out of it!
Posts: 93,068
Well, that went as well as could be expected!
WeasteDevil is offline   Reply With Quote
Old 26th July 2011, 17:36   #10 (permalink)
Reserve Team Player
 
Join Date: Jun 2010
Posts: 2,100
Send a message via AIM to OneToAnother
I'm getting the canae.... whenever I try to get on anything but this thread.
OneToAnother is offline   Reply With Quote
Old 26th July 2011, 17:38   #11 (permalink)
Reserve Team Player
 
Join Date: Mar 2011
Location: Scotland
Posts: 839
still lots of 'canae take the strain' messages and has been very difficult to post any replies, but thanks for bringing the caf back to us! I was going through withdrawal!
humdinger is offline   Reply With Quote
Old 26th July 2011, 17:38   #12 (permalink)
Brewlio's fugly sister
 
Join Date: Nov 2006
Location: Why don't we just kill Badger?
Posts: 27,680
Yeah, almost nothing's working for me without having to try about twenty times.
Brophs is offline   Reply With Quote
Old 26th July 2011, 17:44   #13 (permalink)
 
Join Date: Dec 2007
Location: Fucker shits
Posts: 40,557
I'm scared.
Solius is online now   Reply With Quote
Old 26th July 2011, 17:44   #14 (permalink)
First Team Regular
 
Join Date: Oct 2004
Posts: 19,325
Sadly, still not operating properly though. Not on AppleMac laptop.
032Devil is offline   Reply With Quote
Old 26th July 2011, 17:57   #15 (permalink)
Nicest fella on the Caf and Newbie of the Year 2011
 
Join Date: Oct 2010
Location: The Divided Kingdom
Posts: 11,918
It's too late - I've decided to support Athletico Fray Bentos instead.
SteveJ is offline   Reply With Quote
Old 26th July 2011, 18:45   #16 (permalink)
Reserve Team Player
 
Join Date: Feb 2007
Posts: 1,898
I just got 2 really productive full days of work done. It was horrible.
brad-dyrak is offline   Reply With Quote
Old 26th July 2011, 18:47   #17 (permalink)
Booooooooooo!!
 
Join Date: Aug 2010
Location: None.
Posts: 7,183
Working now???
alastair is online now   Reply With Quote
Old 26th July 2011, 18:48   #18 (permalink)
Spit and Polish
 
Join Date: Feb 2006
Location: 'Sometimes you look in a field and you see a cow and you think it's a better cow than the one you've got in your own field. It's a fact, right? And it never really works out that way. It’s probably the same cow and not as good as your own cow.'
Posts: 9,133
Finally, I'm tired of wanking...
Maciek is offline   Reply With Quote
Old 26th July 2011, 18:49   #19 (permalink)
WR
Formerly Wayne_Rooney
 
Join Date: Sep 2009
Location: SM: Milwall
Posts: 8,807
I just got a message telling me to wait 30 seconds between posts, even though it was 30 odd minutes since my last
WR is online now   Reply With Quote
Old 26th July 2011, 18:56   #20 (permalink)
Reserve Team Player
 
Join Date: Oct 2007
Location: Reykjavik, Iceland
Posts: 775
mustaine is offline   Reply With Quote
Old 26th July 2011, 19:01   #21 (permalink)
"Resident cricket authority"
 
Join Date: Dec 2003
Location: <Insert something funny here>
Posts: 19,571
sadfdffd
crappycraperson is offline   Reply With Quote
Old 26th July 2011, 20:09   #22 (permalink)
Nicest fella on the Caf and Newbie of the Year 2011
 
Join Date: Oct 2010
Location: The Divided Kingdom
Posts: 11,918
A poster named Mr Anderson requested that I post his PM to me in this thread:

Quote:
Since you posted in the "we're back" thread, I'm unable to with either quick reply, or advanced methods, in any thread. I keep getting the message "you cant post in the same thread within 30 seconds, please try again in 15 seconds". But no post is published.
SteveJ is offline   Reply With Quote
Old 26th July 2011, 20:25   #23 (permalink)
Left Back in the changing room
 
Join Date: Jun 2006
Location: On the Edge
Posts: 2,774
You don't know what you got till it's gone
Classy Cannon is offline   Reply With Quote
Old 26th July 2011, 20:28   #24 (permalink)
First Team Regular
 
Join Date: Jan 2009
Location: Gaz. Is a Mewling Quim.
Posts: 19,519
She Canae take the strain lots.
phelans shorts is offline   Reply With Quote
Old 26th July 2011, 20:29   #25 (permalink)
Reserve Team Player
 
Join Date: Jun 2008
Location: Quit yo jibba jabba... you aint hurt!
Posts: 2,751
Its still fucked though
Stookie is offline   Reply With Quote
Old 26th July 2011, 20:29   #26 (permalink)
First Team Regular
 
Join Date: Jan 2009
Location: Gaz. Is a Mewling Quim.
Posts: 19,519
She Canae take the strain lots.
phelans shorts is offline   Reply With Quote
Old 26th July 2011, 20:29   #27 (permalink)
Left Back in the changing room
 
Join Date: Jun 2006
Location: On the Edge
Posts: 2,774
You don't know what you got till it's gone...got Scotty though
Classy Cannon is offline   Reply With Quote
Old 26th July 2011, 20:29   #28 (permalink)
Reserve Team Player
 
Join Date: Jun 2008
Location: Quit yo jibba jabba... you aint hurt!
Posts: 2,751
Its still fucked though
Stookie is offline   Reply With Quote
Old 26th July 2011, 20:30   #29 (permalink)
First Team Regular
 
Join Date: Jan 2009
Location: Gaz. Is a Mewling Quim.
Posts: 19,519
She Canae take the strain lots.
phelans shorts is offline   Reply With Quote
Old 26th July 2011, 20:32   #30 (permalink)
First Team Sub
 
Join Date: Aug 2009
Location: Old Trafford
Posts: 5,298
Our forum is still sick. He doesn't seem to like the new hardware..

But at least it's better than yesterday..

Why was this change necessary??
Danny1982 is online now   Reply With Quote
Old 26th July 2011, 21:13   #31 (permalink)
Fallible Super Being
 
Join Date: Jun 1999
Location: Dublin
Posts: 7,205
Quote:
Originally Posted by Danny1982 View Post
Our forum is still sick. He doesn't seem to like the new hardware..

But at least it's better than yesterday..

Why was this change necessary??
Out of necessity the server hardware had to be moved to a new data centre. We also added a new database server at the same time and it's having a few, shall we say, teething problems
Niall is offline   Reply With Quote
Old 26th July 2011, 21:14   #32 (permalink)
First Team Sub
 
Join Date: Aug 2009
Location: "Liverpool couldn't win the league with Torres up front, Gerrard behind and Mascherano and Alonso in midfield. They aren't gonna win it with this shower of shit. " - Peterstorey
Posts: 5,961
I've missed the caf, I automatically open it along with Facebook and I was getting transfer news withdrawls
Lynk is online now   Reply With Quote
Old 26th July 2011, 21:17   #33 (permalink)
KM
First Team Regular
 
Join Date: Sep 2008
Location: Q.P.R
Posts: 14,853
The loading times are much better now.
KM is offline   Reply With Quote
Old 26th July 2011, 21:24   #34 (permalink)
Magic Meat
 
Join Date: Mar 2006
Location: Viva La Soviet Union
Posts: 16,916
Send a message via Skype™ to Burndogg
Translates as:


Niall spilt a pot noodle on the server
Burndogg is offline   Reply With Quote
Old 26th July 2011, 21:36   #35 (permalink)
Top
Admin
 
Join Date: Oct 2005
Location: Denmark
Posts: 23,555
It works very well now.

Jinx.
Top is offline   Reply With Quote
Old 26th July 2011, 21:38   #36 (permalink)
Attention Whoring Common Crow
 
Join Date: Jun 2004
Location: Red till i'm dead..
Posts: 30,978
I was suffering withdrawal symptoms like everyone else. Hope the Caf is back for real now.

Edit: It's working stupendously well again!
Raven Blade is offline   Reply With Quote
Old 26th July 2011, 21:41   #37 (permalink)
KM
First Team Regular
 
Join Date: Sep 2008
Location: Q.P.R
Posts: 14,853
It's back to the best!
KM is offline   Reply With Quote
Old 26th July 2011, 21:41   #38 (permalink)
Wants to be more like Top
 
Join Date: Oct 2001
Location: RIP Sydney Youngblood, who died in a tragic go-karting accident in 2007. RIP my cat 2001-09. iRIP Steve Cunting Jobs
Posts: 42,368
I've started a new forum, if anyone's interested PM Top.
Spoony Youngblood is offline   Reply With Quote
Old 26th July 2011, 21:42   #39 (permalink)
Fallible Super Being
 
Join Date: Jun 1999
Location: Dublin
Posts: 7,205
Quote:
Originally Posted by spoony youngblood View Post
i've started a new forum, if anyone's interested pm top.
traitor!!!!

Niall is offline   Reply With Quote
Old 26th July 2011, 21:44   #40 (permalink)
WR
Formerly Wayne_Rooney
 
Join Date: Sep 2009
Location: SM: Milwall
Posts: 8,807
Everything works good now.
WR is online now   Reply With Quote
Reply

Thread Tools

 


All times are GMT +1. The time now is 14:47.

Back to top


Search Engine Optimization by vBSEO