Great Western Coffee Shop

Sideshoots - associated subjects => News, Help and Assistance => Topic started by: grahame on July 30, 2017, 10:05:09



Title: Major database outage
Post by: grahame on July 30, 2017, 10:05:09
At about 5 to 8 this morning, our database server crashed badly; I am still looking in to what happened.

I have re-installed the MySQL server and data from backups and currently testing.   I don't think that any posts were lost.

Will report back later with an analysis ... stopping now for breakfast  ;D



Title: Re: Major database outage
Post by: Pb_devon on July 30, 2017, 10:53:29
Thanks grahame....treat yourself to an extra sausage😉


Title: Re: Major database outage
Post by: TaplowGreen on July 30, 2017, 11:00:13
Thanks grahame....treat yourself to an extra sausage😉

Hear Hear! 😃


Title: Re: Major database outage
Post by: GBM on July 30, 2017, 11:05:29
Thanks grahame....treat yourself to an extra sausage😉

Hear Hear! 😃

Two extra black pudding portions as well  :D


Title: Re: Major database outage
Post by: grahame on July 30, 2017, 13:10:53
As part of the restoration, my original blog from 7th September 2005 to 13th March 2009 is back online via http://www.savethetrain.org.uk/isay.html

Most interesting to look back

17th August 2008 (http://www.savethetrain.org.uk/melkshamrailway/257_Preserved_Railways_a_look_forward.html)

Quote
A handful of ideas

Swanage - extend service to Wareham; add regular trains to provide genuine public transport service along with heritage traffic. If slam-doors are safe for a preserved line, surely they're even safer for the regular user that the line would build up?

Minehead - extend regular service to Taunton.

Didcot - to be the base for a tourist (and I'm looking at tourist from overseas too here!) service from Oxford to Salisbury.

All three of the above are seriously extending the "season" - and I am going so far as suggesting a week-round, year-round operation. That could also apply to Kingswear, where there's an argument for an extension to Newton Abbot, giving a single-change London connection from Kingswear and Churston-for-Brixham.

1st September 2007 (http://www.savethetrain.org.uk/melkshamrailway/216_How_to_fill_platforms_and_railway_company_coffers_too.html)

Quote
How to fill platforms, and railway company coffers too!

Give us the trains .... and we'll turn this:

(http://www.wellho.net/pix/turnthis.jpg) into this: (http://www.wellho.net/pix/intothis.jpg)

Two West Wiltshire stations, each serving towns with a population of between 20 and 30 thousand. The biggest difference? One has two trains a DAY each way, and the other has two trains an HOUR each way.

The road network of West Wiltshire is not suitable for longer distance journeys between North and South - and only a huge investment would improve this. What's the point im making that huge investment when there's a perfectly good railway corridor that's underutilised and that people WOULD use.

7th November 2006 (http://www.savethetrain.org.uk/melkshamrailway/174_End_of_term_don_t_care.html)

Quote
End of term - don't care

This Monday morning on the Transwilts started with a cancellation - the very first return trip of the week failed to make it, making this (already) the third week out of four that we've suffered cancellations - and we have so few trains anyway that even one round trip cancelled is already a service that's 3.5% down on what it should be - more that twice the objective that's set by the Department for Transport for the operator. Oh - in two of the past weeks, the cancellation rate was around the 10% mark.

This evening, I'll be attending the talk in Trowbridge by the DfT's guy in the South West - the one who's job it is, as I understand it, to represent the region / area to Central government. If I've understood his role correctly, he clearly failed to get out point across strongly enough for it to have any effect on the service's future - decimated next month - and I fear that we'll not get any great sensible change of heart tonight.

It rather seems that the Department for Transport and First Great Western have washed their hands of the TransWilts, and Melksham, and would like us to just fade away. "It's the easiet train for us to cancel" said a First correspondent recently - "we don't care about this service" would have been another way of putting it, perhaps.

Times are far, far better now ... but it does feel sometimes as if there are still vestiges of the old setup reflected in that last quotation.   This morning, 4 cancellations were showing for today on the TransWilts, and none at all at that time across the rest of the GWR network. We still have work to do - although we work far better in partnership than purely in protest these days.



Title: Re: Major database outage
Post by: grahame on July 30, 2017, 18:52:52
All seems to be running sweetly;  my web server load graph shows what a turbulent day it's been!

(http://www.wellho.net/pix/sgr_20170730.jpg)


Title: Re: Major database outage
Post by: grahame on August 13, 2017, 22:45:56
Similar issue tonight ... on its way back [22:45].    Images should correct in next 30 minutes


Title: Re: Major database outage
Post by: grahame on November 10, 2017, 15:21:41
Sorry about the latest outage - images back by 5 p.m. (I hope!)


Title: Database issues
Post by: grahame on November 20, 2017, 08:13:59
Some "stuff" going on at the moment ... investigating.   Sometime occurrences of

Quote
Connection Problems

Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later.

which are also effecting our dynamic backups.  I may knock the forum offline for a couple of short periods during the dy to fix.


Title: Re: Major database outage
Post by: Surrey 455 on December 05, 2017, 21:13:41
Seems to be problems tonight as well. Most pages I try to look at get one of these messages at first. A refresh usually loads the required page.



Title: Re: Major database outage
Post by: grahame on December 05, 2017, 22:06:47
Seems to be problems tonight as well. Most pages I try to look at get one of these messages at first. A refresh usually loads the required page.

Kicking the server ... just landed at my overnight stop:

(http://www.wellho.net/pix/adv17_05a.jpg)


Title: Re: Major database outage
Post by: grahame on December 06, 2017, 06:11:27
I took a further look around - someone drawing so aggressively that it was turning into a denial of service "attack" though - I'm pretty well certain - an unintentional one.


Title: Re: Major database outage
Post by: grahame on January 11, 2018, 00:49:04
Odd issue with one table this evening ... may have it fixed; this is a test post.


Title: Re: Major database outage
Post by: grahame on January 11, 2018, 00:51:51
Odd issue with one table this evening ... may have it fixed; this is a test post.

further testing (please excuse a number of odd posts)


Title: Re: Major database outage
Post by: grahame on January 11, 2018, 00:53:19
Odd issue with one table this evening ... may have it fixed; this is a test post.

further testing (please excuse a number of odd posts)

We (at home) reconfiguring our broadband yesterday / today - grotty day to have to fix stuff; may be a bit slower than usual!


Title: Re: Major database outage
Post by: Chris from Nailsea on January 11, 2018, 02:18:04
Thanks for your updates, and for your continuing work behind the scenes, grahame.  ;)



Title: Re: Major database outage
Post by: eXPassenger on January 11, 2018, 09:32:42
Thanks for your hard work.  Last night I assumed that 'more tables than usual needed updating' and not 'lack of staff due to training'.


Title: Re: Major database outage
Post by: grahame on January 11, 2018, 10:18:38
Thanks for your hard work.  Last night I assumed that 'more tables than usual needed updating' and not 'lack of staff due to training'.

I would say "my pleasure" but actually last night it was just a task that needed to be done!

Last Sunday, I included a couple of slides about The Coffee Shop in the pre-amble to the "effective consultation inputs" session at Didcot - http://www.firstgreatwestern.info/did_20180107.pdf , slides 3 4 and 5.    We are running on "mature" software, and have issues that we've gone far beyond the original intent. The issue last night was more akin to an old 153 having one of those occasional unexpected issues they can have and "sitting down" at the wrong place, at the wrong time, and needing an engineer to go out and fix it.   

Yes - I appreciate I've come up with a much more serious answer than you would have anticipated from the light hearted and positive comment ... you've provided me with an excellent hook onto which to hang a link to that update previously hidden within a presentation.



Title: Re: Major database outage
Post by: ChrisB on January 11, 2018, 10:24:42
GDPR regulations shouldn't affect the Coffeeshop, as I understand it. All members opt-in to whatever service they require from you & email marketing isn't done....


Title: Re: Major database outage
Post by: grahame on January 11, 2018, 10:47:16
GDPR regulations shouldn't affect the Coffeeshop, as I understand it. All members opt-in to whatever service they require from you & email marketing isn't done....

You are probably correct - however, ignorance of the law is no excuse if you break it, so it needs to be checked, with the ICO site suggesting 12 steps are involved in that checking.   I expect I'll find (as you predict) that we can skip most / all of the steps after the "do we need to" one, but that's on my outstanding list and needed to be raised as a risk.


Title: Re: Major database outage
Post by: ChrisB on January 11, 2018, 11:08:02
I've been through some pretty rigourous seminars on this - the coffeeshop is fine as it works currently.


Title: Re: Major database outage
Post by: eXPassenger on January 11, 2018, 11:31:27
Thanks for your hard work.  Last night I assumed that 'more tables than usual needed updating' and not 'lack of staff due to training'.

I would say "my pleasure" but actually last night it was just a task that needed to be done!

......

Yes - I appreciate I've come up with a much more serious answer than you would have anticipated from the light hearted and positive comment ... you've provided me with an excellent hook onto which to hang a link to that update previously hidden within a presentation.



As a retired IT Director I feel your pain on keeping old software running beyond the original design.

On The GDPR front I agree with the comments that, provided you are registered, the coffee shop is fine.


Title: Re: Major database outage
Post by: grahame on January 20, 2018, 20:50:46
Significant outage - restoring backups to checkpoint at 17:48.   As forum was running for (?) a short while after that, some posts may have been lost - sorry.

Images still being restored ... they may take a further 20 minutes


Title: Re: Major database outage
Post by: Chris from Nailsea on January 20, 2018, 20:54:21
Thanks for your update - and your ongoing hard work behind the scenes, grahame.  ;)




This page is printed from the "Coffee Shop" forum at http://gwr.passenger.chat which is provided by a customer of Great Western Railway. Views expressed are those of the individual posters concerned. Visit www.gwr.com for the official Great Western Railway website. Please contact the administrators of this site if you feel that content provided contravenes our posting rules ( see http://railcustomer.info/1761 ). The forum is hosted by Well House Consultants - http://www.wellho.net