It's alive......IT'S ALIVE!!!
-
- Site Admin
- Posts: 1829
- Joined: Tue Apr 14, 2009 9:59 pm
- Orga / RP numbers: 1234
5678
91011 - Location: Ireland
It's alive......IT'S ALIVE!!!
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 .
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
We're back up and running, sorry it took quite so long!
Ciarán
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 .
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
We're back up and running, sorry it took quite so long!
Ciarán
- Dean
- Global Moderator
- Posts: 6116
- Joined: Wed Apr 15, 2009 7:53 am
- Location: Isle of wight
Re: It's alive......IT'S ALIVE!!!
Thank you Ciarán for all your hard work, it is very much appreciated!!
D
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
14 Mitsubishi L200 Trojan
89 Talbot Express 2.0 coach built Auto-trail Chinook
Addicted to Crackanory
-
- 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!!!
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
1998 XM 2.1TD Auto Estate
2000 XM 3.0V6
1972 D Special
-
- Global Moderator
- Posts: 4000
- Joined: Wed Apr 15, 2009 8:29 am
- Location: Charmouth, Dorset
Re: It's alive......IT'S ALIVE!!!
Thanks Ciaran. Thought it was my computer
Peter
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
2008 C5 2.0. Hdi Estate, Red
2008 C5 2.0. Hdi Estate Silver
Located in Charmouth, Dorset
-
- Has changed a sphere or two
- Posts: 287
- Joined: Tue Dec 30, 2014 3:45 pm
- Orga / RP numbers: 4937
Re: It's alive......IT'S ALIVE!!!
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
Sent from my GT-S5830i using Tapatalk 2
-
- Citroen go-to-guy
- Posts: 821
- Joined: Sun Jul 10, 2011 9:10 pm
- Location: Calne, Wiltshire
Re: It's alive......IT'S ALIVE!!!
Cheers, Sounds like working on the XM is the easy option!
Many thanks for all your hard work.
Rob
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!)
2019 Suzuki Vitara AllGrip SZ5 Automatic 1.4 BoosterJet. White
1972 Banham Sprint kit car (Frogeye Sprite replica, really a Mini!)
- 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!!!
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
1995 Citroen XM 2.1TD Auto EXCLUSIVE
- 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!!!
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
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
-
- 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!!!
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;
1995 XM S2 2.1TD SX Manual - RP6464
http://www.hubnut.org" onclick="window.open(this.href);return false;
-
- XM Guru
- Posts: 1854
- Joined: Sun May 13, 2012 9:43 pm
Re: It's alive......IT'S ALIVE!!!
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...