Forum outage 05/07/2016

Forum News, Announcements and any issues you're having with the forum

Moderator: myglaren

Post Reply
User avatar
xantia_v6
Forum Admin Team
Posts: 9053
Joined: 09 Nov 2005, 22:03
Location: France or NewZealand
Lexia Available: Yes
My Cars: -
1997 Citroen Xantia V6 (France)
1999 Citroen XM V6 ES9 (France)
2011 Peugeot 308 CC THP 155 (NZ)
1975 Jaguar XJ-S pre-HE (NZ)
x 825

Forum outage 05/07/2016

Post by xantia_v6 »

The forum has been down for a couple of hours due to a database cache file corruption.

I don't know what caused it, and I have only taken the minimal steps to rebuild the cache at this time.

If the problem recurs, I will need to do a more complete cleaning of the database itself, but would rather not do that today.
User avatar
CitroJim
A very naughty boy
Posts: 49526
Joined: 30 Apr 2005, 23:33
Location: Paggers
My Cars: Bluebell the AX, Polly the C3 Picasso, Pix the Nissan Pixo, Propel the duathlon bike, TCR Pro the road bike and Fuji the TT bike...
x 6160
Contact:

Re: Forum outage 05/07/2015

Post by CitroJim »

Mike, a big thanks for all your hard work on this today, excellent work..

I guess I was very lucky when a similar problem happened yesterday afternoon and I was able to get away with just restarting the daemon!
Jim

Runner, cyclist, time triallist, duathlete, Citroen AX fan and the CCC Citroenian 'From A to Z' Columnist...
User avatar
xantia_v6
Forum Admin Team
Posts: 9053
Joined: 09 Nov 2005, 22:03
Location: France or NewZealand
Lexia Available: Yes
My Cars: -
1997 Citroen Xantia V6 (France)
1999 Citroen XM V6 ES9 (France)
2011 Peugeot 308 CC THP 155 (NZ)
1975 Jaguar XJ-S pre-HE (NZ)
x 825

Re: Forum outage 05/07/2015

Post by xantia_v6 »

I took the forum down again for some more maintenance. I have now 'cleaned' the database data files.

Lets see if it behaves itself.
User avatar
GiveMeABreak
Forum Admin Team
Posts: 37005
Joined: 15 Sep 2015, 19:38
Location: West Wales
My Cars: C3 Aircross SUV HDi Flair Peperoncino Red (The Chili Hornet)
C5 X7 2.0 HDi Exclusive Mativoire Beige (The Golden Hornet)
C3 1.6 HDi Exclusive Aluminium Grey (The Silver Hornet)
C5 MK II 2.0 HDi Exclusive Obsidian Black
C5 MK I 2.0 HDi SX Wicked Red
Xantia S2 2.0 HDi SX Hermes Red
C15 Romahome White
XM 2.0 Turbo Prestige Emerald Green Pearlescent
XM 2.0 Turbo Prestige Polar White
XM 2.0 SX Polar White
CX 20 Polar White
GS 1220 Geranium Red
CX 2.4 Prestige C-Matic Nevada Beige
GS 1000 Cedreat Yellow
x 5646

Re: Forum outage 05/07/2015

Post by GiveMeABreak »

xantia_v6 wrote:The forum has been down for a couple of hours due to a database cache file corruption.
I don't know what caused it, and I have only taken the minimal steps to rebuild the cache at this time.
If the problem recurs, I will need to do a more complete cleaning of the database itself, but would rather not do that today.
Aahh back up - ignore email Jim - just noted the Thread Title says 5/7/2015 Mike :-D
Please Don't PM Me For Technical Help

Marc
User avatar
xantia_v6
Forum Admin Team
Posts: 9053
Joined: 09 Nov 2005, 22:03
Location: France or NewZealand
Lexia Available: Yes
My Cars: -
1997 Citroen Xantia V6 (France)
1999 Citroen XM V6 ES9 (France)
2011 Peugeot 308 CC THP 155 (NZ)
1975 Jaguar XJ-S pre-HE (NZ)
x 825

Re: Forum outage 05/07/2016

Post by xantia_v6 »

I have not restored the wiki yet, as I have some other maintenance to do on that tomorrow (or Thursday).
Hell Razor5543
Donor 2023
Posts: 13727
Joined: 01 Apr 2012, 09:47
Location: Reading
My Cars: C5 Mk2 VTX+ estate.
x 2993

Re: Forum outage 05/07/2016

Post by Hell Razor5543 »

Erm, I lost access to the forum for about an hour just now.
James
ex BX 1.9
ex Xantia 2.0HDi SX
ex Xantia 2.0HDi LX
Ex C5 2.0HDi VTR
Ex C5 2.0HDi VTR

C5 2.2HDi VTX+
Yes, I am paranoid, but am I paranoid ENOUGH?
Out amongst the stars, looking for a world of my own!
User avatar
GiveMeABreak
Forum Admin Team
Posts: 37005
Joined: 15 Sep 2015, 19:38
Location: West Wales
My Cars: C3 Aircross SUV HDi Flair Peperoncino Red (The Chili Hornet)
C5 X7 2.0 HDi Exclusive Mativoire Beige (The Golden Hornet)
C3 1.6 HDi Exclusive Aluminium Grey (The Silver Hornet)
C5 MK II 2.0 HDi Exclusive Obsidian Black
C5 MK I 2.0 HDi SX Wicked Red
Xantia S2 2.0 HDi SX Hermes Red
C15 Romahome White
XM 2.0 Turbo Prestige Emerald Green Pearlescent
XM 2.0 Turbo Prestige Polar White
XM 2.0 SX Polar White
CX 20 Polar White
GS 1220 Geranium Red
CX 2.4 Prestige C-Matic Nevada Beige
GS 1000 Cedreat Yellow
x 5646

Re: Forum outage 05/07/2016

Post by GiveMeABreak »

xantia_v6 wrote:I have not restored the wiki yet, as I have some other maintenance to do on that tomorrow (or Thursday).
Wasn't being picky Mike re the 2015 in the thread - just went there to see if there were any issues and initially thought it was an older post until I saw Jim's post dated 5/7/16! :wink:
Please Don't PM Me For Technical Help

Marc
User avatar
xantia_v6
Forum Admin Team
Posts: 9053
Joined: 09 Nov 2005, 22:03
Location: France or NewZealand
Lexia Available: Yes
My Cars: -
1997 Citroen Xantia V6 (France)
1999 Citroen XM V6 ES9 (France)
2011 Peugeot 308 CC THP 155 (NZ)
1975 Jaguar XJ-S pre-HE (NZ)
x 825

Re: Forum outage 05/07/2016

Post by xantia_v6 »

The server was still having issues this morning, but I think I found a problem relating to a (semi-) automatic software upgrade of the database service that happened last week. I have reverted to the old version of that package, and crossed my fingers.
User avatar
CitroJim
A very naughty boy
Posts: 49526
Joined: 30 Apr 2005, 23:33
Location: Paggers
My Cars: Bluebell the AX, Polly the C3 Picasso, Pix the Nissan Pixo, Propel the duathlon bike, TCR Pro the road bike and Fuji the TT bike...
x 6160
Contact:

Re: Forum outage 05/07/2016

Post by CitroJim »

Thanks Mike, excellent :D
xantia_v6 wrote:and crossed my fingers.
Mine are too, plus everything else!
Jim

Runner, cyclist, time triallist, duathlete, Citroen AX fan and the CCC Citroenian 'From A to Z' Columnist...
Gibbo2286
(Donor 2020)
Posts: 7171
Joined: 08 Jun 2011, 18:04
Location: GL15***
My Cars: 2006 C5 2.0 Litre HDI VTR Automatic Estate.(now sold on)
Currently Renault Zoe 2014 ZE
x 2500

Re: Forum outage 05/07/2016

Post by Gibbo2286 »

I don't know if this helps but it's what came up this morning when I tried to log in.


General Error

SQL ERROR [ mysqli ]

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) [2002]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
Man is, by nature, a lazy beast, he does not need twice encouraging to do nothing.
User avatar
xantia_v6
Forum Admin Team
Posts: 9053
Joined: 09 Nov 2005, 22:03
Location: France or NewZealand
Lexia Available: Yes
My Cars: -
1997 Citroen Xantia V6 (France)
1999 Citroen XM V6 ES9 (France)
2011 Peugeot 308 CC THP 155 (NZ)
1975 Jaguar XJ-S pre-HE (NZ)
x 825

Re: Forum outage 05/07/2016

Post by xantia_v6 »

Yes, that was the symptom of the database service randomly crashing and restarting itself.
The version that was installed by the software updater last week was definitely wrong, so I hope that it will now be stable again.
Hell Razor5543
Donor 2023
Posts: 13727
Joined: 01 Apr 2012, 09:47
Location: Reading
My Cars: C5 Mk2 VTX+ estate.
x 2993

Re: Forum outage 05/07/2016

Post by Hell Razor5543 »

Obviously that database was a final product from the Rover factories, if it could crash by itself. I had that error a few times as well. If you have a Citroen version installed do make sure to leave one small problem in it, otherwise it will get confused with being fully functional and crash anyway. :-D
James
ex BX 1.9
ex Xantia 2.0HDi SX
ex Xantia 2.0HDi LX
Ex C5 2.0HDi VTR
Ex C5 2.0HDi VTR

C5 2.2HDi VTX+
Yes, I am paranoid, but am I paranoid ENOUGH?
Out amongst the stars, looking for a world of my own!
User avatar
CitroJim
A very naughty boy
Posts: 49526
Joined: 30 Apr 2005, 23:33
Location: Paggers
My Cars: Bluebell the AX, Polly the C3 Picasso, Pix the Nissan Pixo, Propel the duathlon bike, TCR Pro the road bike and Fuji the TT bike...
x 6160
Contact:

Re: Forum outage 05/07/2016

Post by CitroJim »

Hell Razor5543 wrote:Obviously that database was a final product from the Rover factories, if it could crash by itself. I had that error a few times as well. If you have a Citroen version installed do make sure to leave one small problem in it, otherwise it will get confused with being fully functional and crash anyway. :-D
:lol:

MySQL is definitey a Citroen database as when it works it is brilliant but when it doesn't it can be a bit or a ********* :wink:

Luckily the not working time is often very, very small. That differentiates it from a Rover... That's Microsoft SQL Server :twisted:

I know only too well - it's how I earn my money....
Jim

Runner, cyclist, time triallist, duathlete, Citroen AX fan and the CCC Citroenian 'From A to Z' Columnist...
Post Reply