Train GraphicClick on the map to explore geographics
 
I need help
FAQ
Emergency
About .
Travel & transport from BBC stories as at 15:15 28 Apr 2024
- Jet with 500 toy giraffe passengers takes flight
- The cargo ship that became an iconic music venue
Read about the forum [here].
Register [here] - it's free.
What do I gain from registering? [here]
 22/05/24 - WWRUG / TransWilts update
02/06/24 - Summer Timetable starts
17/08/24 - Bus to Imber
27/09/25 - 200 years of passenger trains

On this day
28th Apr (1996)
GNER franchise (Sea Containers) starts on ECML (*)

Train RunningCancelled
14:28 Hereford to London Paddington
28/04/24 17:16 Bristol Temple Meads to Severn Beach
28/04/24 18:01 Severn Beach to Bristol Temple Meads
22:10 Taunton to Bristol Temple Meads
Short Run
13:11 Worcester Foregate Street to London Paddington
15:44 London Paddington to Great Malvern
Delayed
10:50 Penzance to Cardiff Central
11:37 London Paddington to Carmarthen
13:51 Warminster to Cardiff Central
PollsThere are no open or recent polls
Abbreviation pageAcronymns and abbreviations
Stn ComparatorStation Comparator
Rail newsNews Now - live rail news feed
Site Style 1 2 3 4
Next departures • Bristol Temple MeadsBath SpaChippenhamSwindonDidcot ParkwayReadingLondon PaddingtonMelksham
Exeter St DavidsTauntonWestburyTrowbridgeBristol ParkwayCardiff CentralOxfordCheltenham SpaBirmingham New Street
April 28, 2024, 15:24:48 *
Welcome, Guest. Please login or register.

Login with username, password and session length
Forgotten your username or password? - get a reminder
Most recently liked subjects
[122] Clan Line - by Clan Line !
[37] access for all at Devon stations report
[36] Who we are - the people behind firstgreatwestern.info
[16] Labour to nationalise railways within five years of coming to ...
[14] Cornish delays
[1] Bonaparte's at Bristol Temple Meads
 
News: A forum for passengers ... with input from rail professionals welcomed too
 
   Home   Help Search Calendar Login Register  
Pages: 1 2 [3] 4 5 6
  Print  
Author Topic: Database issues - occurring occasionally - merged topic for 2015 and 2016  (Read 54714 times)
grahame
Administrator
Hero Member
*****
Posts: 40843



View Profile WWW Email
« Reply #30 on: February 03, 2015, 15:39:09 »

The database we're running with is a far more recent one than the one that the forum software was written with, and there have been a handful of backups and restores which may have included an (accidental) character set change.   The best I can realistically do at this point is say "sorry, folks" about some of the stranger old encoding - too much on my plate to realistically look at sorting it out.   I WILL take a quick look to see if there's a quick fix, but please don't hold your breath.
Logged

Coffee Shop Admin, Acting Chair of Melksham Rail User Group, Option 24/7 Melksham Rep
grahame
Administrator
Hero Member
*****
Posts: 40843



View Profile WWW Email
« Reply #31 on: February 04, 2015, 06:31:37 »

A further follow up ... you will occasionally see the following:

Quote
Connection Problems

Sorry, SMF (Simple Machines Forum - The software we use on this site) was unable to connect to the database. This may be caused by the server being busy. Please try again later.

Usually clears within a couple of minutes / usually caused by the databases being locked for backup.  Playing far safer these days - this is the 'cost' of having a more robust ability to restore in the event of a problem.  Yes, other solutions are available but at the cost of more setup and admin time and perhaps expense.
Logged

Coffee Shop Admin, Acting Chair of Melksham Rail User Group, Option 24/7 Melksham Rep
grahame
Administrator
Hero Member
*****
Posts: 40843



View Profile WWW Email
« Reply #32 on: February 26, 2015, 08:09:31 »

Techie / update issues that we were looking at / wondering about a "working weekend" or get-together.  I HAD hoped to suggest a late March date but my personal diary is crammed - and this is in addition to running a hotel and presenting 4 training courses of up to 5 days each during the month.  So we will need to plan for later - looking at June or even August.

Film 4th Westbury
MRDG» (Melksham Railway Development Group - about) 6th Melksham
TWSW» (TravelWatch SouthWest - website) 7th Taunton
((Seed Swap 7th Melksham))
(Dog Walk 14th Melksham)
ACoRP (Association of Community Rail Partnerships) 16th and 17th Nottingham
Visit Wiltshire 18th Salisbury
FGW (First Great Western) Community 19th Bristol
Mayors Reception 20th Melksham
TransWilts Link 21st Melksham
Customer Panel (1st Bus) 24th Bath
Transport Group 27th / 28th Melksham
CIC (Community Interest Company ) board 28th Melksham
RailFuture 11th April Melksham
Logged

Coffee Shop Admin, Acting Chair of Melksham Rail User Group, Option 24/7 Melksham Rep
thetrout
Hero Member
*****
Posts: 2612



View Profile
« Reply #33 on: February 26, 2015, 21:10:55 »

Rule number 188356 of IT... Never do any big changes on Friday 13th... It will end in disaster Lips sealed
Logged

Grin Grin Grin Grin
grahame
Administrator
Hero Member
*****
Posts: 40843



View Profile WWW Email
« Reply #34 on: March 09, 2015, 06:20:20 »

Just a note that I have adjusted some of the scope of backups, and moved some evening work into the early hours. Call it fine tuning; I anticipate little effect will be seen - like a 3 minute improvement in journey time from Bath Spa to London would be useful in the long run, but not noticed by the passengers using the service Grin
Logged

Coffee Shop Admin, Acting Chair of Melksham Rail User Group, Option 24/7 Melksham Rep
grahame
Administrator
Hero Member
*****
Posts: 40843



View Profile WWW Email
« Reply #35 on: May 06, 2015, 13:50:30 »

For some reason - yet to be fully investigated - our database engine quit an hour or two back; I get flagged when there's something like this (it's part of the heartbeat monitor) so knew quite quickly, but the issue was unusual so I've take a while to research it ... doubly frustrating on a very slow and laggy connection, and with two sister just across from me having a flaming argument while I was trying to do it.   Anyway, they came across and apologised for the disturbance and as recompense I send them to the real "Coffee shop" to get me a cup.

I'll follow up further in just a moment - also using this as a test post to check we're properly back
Logged

Coffee Shop Admin, Acting Chair of Melksham Rail User Group, Option 24/7 Melksham Rep
grahame
Administrator
Hero Member
*****
Posts: 40843



View Profile WWW Email
« Reply #36 on: May 06, 2015, 13:57:07 »

OK ... next system checkpoint scheduled in about 20 mins and I'll be back
Logged

Coffee Shop Admin, Acting Chair of Melksham Rail User Group, Option 24/7 Melksham Rep
grahame
Administrator
Hero Member
*****
Posts: 40843



View Profile WWW Email
« Reply #37 on: May 06, 2015, 14:20:25 »

OK ... next system checkpoint scheduled in about 20 mins and I'll be back

Looks ok ...
Logged

Coffee Shop Admin, Acting Chair of Melksham Rail User Group, Option 24/7 Melksham Rep
grahame
Administrator
Hero Member
*****
Posts: 40843



View Profile WWW Email
« Reply #38 on: May 07, 2015, 08:27:40 »

OK ... next system checkpoint scheduled in about 20 mins and I'll be back

Looks ok ...

Spoken a little too soon - a further database unexpected stop about an hour ago; up and running again after what I think may be a fix applied.   However, I still have to be researching issues and this potentially could lead to a period with some frustration as the root cause is hard to find ... and if and when we find it or manage to put in a work around, we won't necessarily know that we have found it!
Logged

Coffee Shop Admin, Acting Chair of Melksham Rail User Group, Option 24/7 Melksham Rep
TaplowGreen
Transport Scholar
Hero Member
******
Posts: 7800



View Profile
« Reply #39 on: May 07, 2015, 11:17:27 »

OK ... next system checkpoint scheduled in about 20 mins and I'll be back

Looks ok ...

Spoken a little too soon - a further database unexpected stop about an hour ago; up and running again after what I think may be a fix applied.   However, I still have to be researching issues and this potentially could lead to a period with some frustration as the root cause is hard to find ... and if and when we find it or manage to put in a work around, we won't necessarily know that we have found it!


Sounds like the signals in the Thames Valley!!! Cheesy
Logged
grahame
Administrator
Hero Member
*****
Posts: 40843



View Profile WWW Email
« Reply #40 on: May 24, 2015, 08:41:05 »

Topics that you have read in the last couple of hours may now be showing up as unread again.
Logged

Coffee Shop Admin, Acting Chair of Melksham Rail User Group, Option 24/7 Melksham Rep
Chris from Nailsea
Administrator
Hero Member
*****
Posts: 17895


I am not railway staff


View Profile Email
« Reply #41 on: May 24, 2015, 20:40:10 »

I read them, but cannot remember whether I've read them before.  Tongue Embarrassed Roll Eyes Shocked Grin
Logged

William Huskisson MP (Member of Parliament) was the first person to be killed by a train while crossing the tracks, in 1830.  Many more have died in the same way since then.  Don't take a chance: stop, look, listen.

"Level crossings are safe, unless they are used in an unsafe manner."  Discuss.
grahame
Administrator
Hero Member
*****
Posts: 40843



View Profile WWW Email
« Reply #42 on: July 09, 2015, 02:59:16 »

Topics that you have read in the last couple of hours may now be showing up as unread again.

Again - anyone who's read topics from 21:30 last night to 02:45 this morning.  (This message doubles up as a test post)
Logged

Coffee Shop Admin, Acting Chair of Melksham Rail User Group, Option 24/7 Melksham Rep
grahame
Administrator
Hero Member
*****
Posts: 40843



View Profile WWW Email
« Reply #43 on: August 02, 2015, 09:09:47 »

Noting some database issues this morning.   I will be looking to fix at around 10:30 when I have a good connection - please note posts, messages etc posted in next 2 hours may be lost.
Logged

Coffee Shop Admin, Acting Chair of Melksham Rail User Group, Option 24/7 Melksham Rep
grahame
Administrator
Hero Member
*****
Posts: 40843



View Profile WWW Email
« Reply #44 on: August 02, 2015, 11:14:00 »

Noting some database issues this morning.   I will be looking to fix at around 10:30 when I have a good connection - please note posts, messages etc posted in next 2 hours may be lost.

Posting to test we're back up.
Logged

Coffee Shop Admin, Acting Chair of Melksham Rail User Group, Option 24/7 Melksham Rep
Do you have something you would like to add to this thread, or would you like to raise a new question at the Coffee Shop? Please [register] (it is free) if you have not done so before, or login (at the top of this page) if you already have an account - we would love to read what you have to say!

You can find out more about how this forum works [here] - that will link you to a copy of the forum agreement that you can read before you join, and tell you very much more about how we operate. We are an independent forum, provided and run by customers of Great Western Railway, for customers of Great Western Railway and we welcome railway professionals as members too, in either a personal or official capacity. Views expressed in posts are not necessarily the views of the operators of the forum.

As well as posting messages onto existing threads, and starting new subjects, members can communicate with each other through personal messages if they wish. And once members have made a certain number of posts, they will automatically be admitted to the "frequent posters club", where subjects not-for-public-domain are discussed; anything from the occasional rant to meetups we may be having ...

 
Pages: 1 2 [3] 4 5 6
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.2 | SMF © 2006-2007, Simple Machines LLC Valid XHTML 1.0! Valid CSS!
This forum is provided by customers of Great Western Railway (formerly First Great Western), and the 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 the content provided by one of our posters contravenes our posting rules (email link to report). Forum hosted by Well House Consultants

Jump to top of pageJump to Forum Home Page