Jump to content

Recommended Posts

CloudFront attempted to establish a connection with the origin, but either the attempt failed or the origin closed the connection. We can't connect to the server for this app or website at this time. There might be too much traffic or a configuration error. Try again later, or contact the app or website owner.
If you provide content to customers through CloudFront, you can find steps to troubleshoot and help prevent this error by reviewing the CloudFront documentation.

Todays effort via Firefox . Wait a while then seems to connect OK.

Link to post
Share on other sites

After a few days of being quite good it's gone back to how it was, probably get on 50% of the time and get the error message the rest of the time. THis has been ongoing for 49 days now so i make that 67p i've wasted on this place.

Edited by Turkish
Link to post
Share on other sites

I can never load "The Saints" thread listing, always get a CloudFront error. The only way I can view threads is to click (from the homepage) the link to whatever the most recent post is and jump from thread to thread from there. Given that this is the user experience I am amazed people are bothering to post here at all. 

Link to post
Share on other sites
15 hours ago, Saint_Jonny said:

I can never load "The Saints" thread listing, always get a CloudFront error. The only way I can view threads is to click (from the homepage) the link to whatever the most recent post is and jump from thread to thread from there. Given that this is the user experience I am amazed people are bothering to post here at all. 

That’s how I get in but how do you jump from thread to thread?

i can only read whatever the last post was made like you.

Thats not good is it on trying to get on our message board?

Link to post
Share on other sites

Thought Steve may have cracked it but been really bad again the last few days.

Don't know which is more annoying, not being able to get on at all, or getting on but finding no new posts to read since last time you managed to as nobody else has been able to get on either.

 

Link to post
Share on other sites

Cannot get in at all using the mobile, oddly, on the laptop it is really fast if I sign out but slow if I sign in which makes posting a bit of a lottery.

I'm hanging on in there in the hope that the problems get fixed but slowly giving up hope.

Link to post
Share on other sites

I know every involved with the tech side of the site works hard and possibly volentary too but it really has become bad just says bad gateway half time and had been like this for some months now 

Link to post
Share on other sites

It is definitely getting progressively worse. It's fortunate for SaintsWeb that there is practically no competition, as putting this much effort into accessing a website would ordinarily lead to people giving up and going elsewhere.

 

That said, the SaintsFC Reddit sub has been a pretty good alternative of late.

Link to post
Share on other sites
5 hours ago, Weston Super Saint said:

Hope I don't jinx it but whatever change was made yesterday seems to have fixed it - no issues at all right now!

Whisper it quietly, but I've done nothing to the setup for the last few weeks - it's just a weird fluctuation that I can't really explain. There's nothing that seems to actually cause the bad spells, it's not a spike in traffic or anything like that, there's no specific user action that I can see that's taking place, etc.

Summary: dunno.

Power Rangers Reaction GIF

  • Like 2
Link to post
Share on other sites
3 hours ago, stevegrant said:

Whisper it quietly, but I've done nothing to the setup for the last few weeks - it's just a weird fluctuation that I can't really explain. There's nothing that seems to actually cause the bad spells, it's not a spike in traffic or anything like that, there's no specific user action that I can see that's taking place, etc.

Summary: dunno.

Power Rangers Reaction GIF

Carry on doing nothing please - it's going brilliantly. 

Link to post
Share on other sites

finally finished indexing has it? :D

Good performance or not, transient problems are a worry because they are likely to return. I haven't been able to get onto any of the match threads during a game due to the timeouts.

Link to post
Share on other sites
1 hour ago, Plastic said:

finally finished indexing has it? :D

I think that took about 10 days, which is fairly ridiculous :lol:

1 hour ago, Plastic said:

Good performance or not, transient problems are a worry because they are likely to return. I haven't been able to get onto any of the match threads during a game due to the timeouts.

Yeah, I'm under no illusions here - it's entirely possible that the problems we've had will return just as quickly as they've vanished. I'm around 95% certain that the core problem is the database schema and how everything fits together, because the database uses the InnoDB engine but doesn't utilise some of the things InnoDB is especially good at (e.g. foreign keys linking tables together, etc), which makes the database quite inefficient. I suspect there are more writes/updates to the database on every post than should be necessary because of that inefficiency, which then causes a logjam and it spirals out of control. When I put the issue(s) to the Invision developers, they suggested ramping up the memory being allocated to the database, which frankly is a bullshit suggestion. A relatively simple forum structure shouldn't need multiple GBs of RAM being thrown at it in order to simply function at the most basic level. Basically they've engineered it badly and the "best" way to fix it from their perspective is to make the database so powerful that the inefficiencies aren't exposed, because otherwise they might have to admit they've fucked up somewhere along the line.

There's been a new version (4.5) available as of around 4 weeks or so ago, but they're also onto incremental version 4.5.3 already, so there's clearly still a load of issues which I'm going to wait for them to resolve before we upgrade here - frankly, I've no idea how long the upgrade process might take. Knowing how long it took to convert from the old software, and how long that re-indexing process takes, it could be a matter of days... :uhoh:

  • Like 2
Link to post
Share on other sites
37 minutes ago, Manuel said:

Been good for days now.  Is it just me though who can't find a search function anywhere?

I turned it off as I suspect that might have been having a negative impact on the database (bearing in mind that we have more than 2.6 million posts on here from as far back as 2008) - will have a play around with it over the next couple of weeks to see how much it actually gets used. It might be that it gets limited to subscribed users or something along those lines.

  • Like 1
Link to post
Share on other sites
On 24/09/2020 at 12:47, stevegrant said:

I'm around 95% certain that the core problem is the database schema and how everything fits together, because the database uses the InnoDB engine but doesn't utilise some of the things InnoDB is especially good at (e.g. foreign keys linking tables together, etc), which makes the database quite inefficient.

Dev 1: "What are relational databases good at then?"

Dev 2: "Er, relational data?"

Dev 3: "Shall we set up the relations in the database then?"

Dev 1: "Nah, f*ck it, can't be arsed."

And by dev, I mean cowboy... 😒

 

Link to post
Share on other sites
15 hours ago, bpsaint said:

Reckon you’ve cracked it Steve or are you still looking for the root cause?

I'm not actively looking, I've not really got time at the moment anyway, but while it seems stable it seems silly to potentially poke the bear :lol:

I do wonder whether that post re-indexing process might have helped, but it doesn't appear to be an exact science, frustratingly.

Link to post
Share on other sites
31 minutes ago, stevegrant said:

I'm not actively looking, I've not really got time at the moment anyway, but while it seems stable it seems silly to potentially poke the bear :lol:

I do wonder whether that post re-indexing process might have helped, but it doesn't appear to be an exact science, frustratingly.

Is it tempting fate to suggest it's time to lock this thread?

Link to post
Share on other sites
6 hours ago, Wurzel said:

Is it tempting fate to suggest it's time to lock this thread?

Not before I thank Steve for his hard work and perseverance while under fire from some very impatient numpties. 

 

P.S. a bit embarrassing this, but I won't be handing over my fiver until the site accepts PayPal.  Its just the way I prefer to do some things.

 

  • Like 1
Link to post
Share on other sites

You may have noticed there's been a few changes - I've run the upgrade to the latest version. Frustratingly, it seems as though it's knocked out a few settings, particularly with the colour scheme, so I'll be gradually working on bits and pieces when I spot them. If there are any major bugs, please let me know.

  • Like 1
Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

View Terms of service (Terms of Use) and Privacy Policy (Privacy Policy) and Forum Guidelines ({Guidelines})