It's alive......IT'S ALIVE!!!

General information about upcoming maintenance, and other events which affect the forum.
Ciaran
Site Admin
Posts: 1824
Joined: Tue Apr 14, 2009 9:59 pm
Orga / RP numbers: 1234
5678
91011
Location: Ireland

It's alive......IT'S ALIVE!!!

Post by Ciaran » Sat Oct 10, 2015 5:34 pm

Hi guys,

The forum is back online after 6 days downtime.
Sorry for the extended outage, unfortunately what started out as a simple issue grew into a series of problems.

The original database server died last Monday morning. I was expecting this, and had a new server built, ready to replace it.

Unfortunately, when I went to restore the backed up database to the new server, I discovered that there was some internal corruption within many of the data tables, this prevented the database from mounting on the new SQL server.
This corruption has gone back for some time it appears, and as a result all the recent backups had it.

Because of this, there was no option but to manually create new versions of the corrupt tables from scratch and then import the data from the corrupted tables to them. There are well over 100 tables in the database and many of them contain upwards of 100 columns each, so manually mapping and checking the datatypes etc took literally days. This is the reason for the site being down so long.

The upside of this, in a lessons learned kind of way, I've altered the backup scripts to include database consistency checks, so it will check the integrity of the data in the tables rather than blindly backing it up and assuming all is well. You know what they say about 'assume', it makes an ass out of u and me :lol: .

So after all that, the database finally coughed and spluttered into life like a 2.1 on a sub-zero morning, that sound we all know and love :lol:
We're back up and running, sorry it took quite so long!

Ciarán

User avatar
Dean
Global Moderator
Posts: 6116
Joined: Wed Apr 15, 2009 7:53 am
Location: Isle of wight

Re: It's alive......IT'S ALIVE!!!

Post by Dean » Sat Oct 10, 2015 6:13 pm

Thank you Ciarán for all your hard work, it is very much appreciated!!

D
92 Citroen XM Prestige 3.0i Auto R.P5678
14 Mitsubishi L200 Trojan
89 Talbot Express 2.0 coach built Auto-trail Chinook

Addicted to Crackanory

eifion
Knows how to use the parking brake
Posts: 72
Joined: Thu Apr 28, 2011 6:07 pm
Location: North Wales

Re: It's alive......IT'S ALIVE!!!

Post by eifion » Sat Oct 10, 2015 6:25 pm

Blimey, that sounds like a lot of work. Congratulations on getting it all back up and running.
1995 XM 2.5TD (now dead and gone)
1998 XM 2.1TD Auto Estate
2000 XM 3.0V6
1972 D Special

Peter.N.
Global Moderator
Posts: 3999
Joined: Wed Apr 15, 2009 8:29 am
Location: Charmouth, Dorset

Re: It's alive......IT'S ALIVE!!!

Post by Peter.N. » Sat Oct 10, 2015 10:23 pm

Thanks Ciaran. Thought it was my computer ;)

Peter
'96 'N' 2.1 td VSX manual estate White RP6695. Sadly gone
2008 C5 2.0. Hdi Estate, Red
2008 C5 2.0. Hdi Estate Silver


Located in Charmouth, Dorset

Julianw
Has changed a sphere or two
Posts: 284
Joined: Tue Dec 30, 2014 3:45 pm
Orga / RP numbers: 4937

Re: It's alive......IT'S ALIVE!!!

Post by Julianw » Sun Oct 11, 2015 1:07 am

From bitter experience, I know how much work you had to do there. Thanks for all of it!

Sent from my GT-S5830i using Tapatalk 2

cxprestigeauto
Citroen go-to-guy
Posts: 821
Joined: Sun Jul 10, 2011 9:10 pm
Location: Calne, Wiltshire

Re: It's alive......IT'S ALIVE!!!

Post by cxprestigeauto » Sun Oct 11, 2015 7:37 am

Cheers, Sounds like working on the XM is the easy option!

Many thanks for all your hard work.

Rob
1991 XM 2.0 Si auto RP 4903 (12 April 1990) Alpine White
2019 Suzuki Vitara AllGrip SZ5 Automatic 1.4 BoosterJet. White
1972 Banham Sprint kit car (Frogeye Sprite replica, really a Mini!)

User avatar
raynoon
Could do a 2.1 headgasket
Posts: 1128
Joined: Mon Aug 31, 2015 7:38 am
Orga / RP numbers: 6043
Location: Merseyside

Re: It's alive......IT'S ALIVE!!!

Post by raynoon » Sun Oct 11, 2015 7:39 am

Welcome back! And thanks for all the hard work you put in to keep us going! I've had withdrawal symptoms all week!!
1993 Citroen XM 2.1 turboSD auto
1995 Citroen XM 2.1TD Auto EXCLUSIVE

User avatar
White Exec
Citroen God!
Posts: 6642
Joined: Fri Mar 11, 2011 7:38 pm
Orga / RP numbers: RP7165
1996 2.5TD saloon, Exclusive, Polar White
1992 BX19D Millesime, Sable Phenicien
Location: ex-Ealing, Cheshire, W.Sussex & Surrey. Now living in Sayalonga (Malaga, Spain)

Re: It's alive......IT'S ALIVE!!!

Post by White Exec » Sun Oct 11, 2015 7:41 am

Ciaran, thanks for all that hard work in getting things going again. Good to be back up.
Chris
1996 XM 2.5TD Exclusive RP7165 Polar White
1992 BX19D Millesime RP5800 Sable
1989 BX19RD Delage Red Deceased; 1998 ZX 1.9D Avantage auto Triton Green Company car 1998..2001; 2001 Xantia 1.8i auto Wicked Red Company car 2001..2003

dollywobbler
Has changed a sphere or two
Posts: 387
Joined: Sat Feb 15, 2014 12:18 pm
Location: Mid-Wales
Contact:

Re: It's alive......IT'S ALIVE!!!

Post by dollywobbler » Sun Oct 11, 2015 9:08 am

Good work! Gosh I've been missing this place. Your efforts are very much appreciated.
1986 2CV6 Dolly, 1980 Dyane
1995 XM S2 2.1TD SX Manual - RP6464
http://www.hubnut.org" onclick="window.open(this.href);return false;

captainhaddock
XM Guru
Posts: 1854
Joined: Sun May 13, 2012 9:43 pm

Re: It's alive......IT'S ALIVE!!!

Post by captainhaddock » Sun Oct 11, 2015 9:20 am

Hope I wouldn't give up on a XM as I surely would have with such a computer problem ;) Cheers! I'll get ready to throw up some XM related issues...

Post Reply