Author Topic: Connection problems not resolved  (Read 25961 times)

0 Members and 1 Guest are viewing this topic.

Re: Connection problems not resolved
« Reply #30 on: October 14, 2024, 12:37:01 PM »

Offline Kernewek

  • Antoine Walker
  • ****
  • Posts: 4478
  • Tommy Points: 283
  • International Superstar
Hey everyone: this is hopefully improved now. An Amazon forced upgrade hosed all of our historical database settings and it's been a bit of rediscovery of what's required to keep things stable. Basically the forum software is greedy with database connections even though many of them do very little, so you don't need a huge server... just a specific setup. If you see those "SMF error" type messages, that's what is going on.

Unfortunately there's not much budget to scale with brute force, but I'm reasonably certain the same old tricks apply and we'll be humming along before long.
Still seeing trouble this morning but, as you say, 5xx errors so it kind of is what it is from a bandwidth perspective.
Man had always assumed that he was more intelligent than dolphins because he had achieved so much--the wheel, New York, wars and so on--whilst all the dolphins had ever done was muck about in the water having a good time.

But conversely, the dolphins had always believed that they were far more intelligent than man--for precisely the same reason.

Re: Connection problems not resolved
« Reply #31 on: October 21, 2024, 10:53:56 AM »

Offline FLCeltsFan

  • Kendrick Perkins #1 Fan
  • Author
  • Rajon Rondo
  • *****
  • Posts: 5426
  • Tommy Points: 11941
  • Marcus Smart Fan!
I've been having problems posting the game threads all preseason.  Last night I couldn't get in at all.  I hope the problem gets fixed soon or I may not be able to get the game threads up.  :(

Re: Connection problems not resolved
« Reply #32 on: October 21, 2024, 03:58:04 PM »

Offline Goldstar88

  • Ed Macauley
  • ***********
  • Posts: 11972
  • Tommy Points: 1577
I've been having problems posting the game threads all preseason.  Last night I couldn't get in at all.  I hope the problem gets fixed soon or I may not be able to get the game threads up.  :(

  :-\
Quoting Nick from the now locked Ime thread:
Quote
At some point you have to blame the performance on the court on the players on the court. Every loss is not the coach's fault and every win isn't because of the players.

Re: Connection problems not resolved
« Reply #33 on: November 16, 2024, 12:56:16 PM »

Offline SparzWizard

  • Kevin Garnett
  • *****************
  • Posts: 17564
  • Tommy Points: 1054
Anybody still getting these timed out pages from time to time?

Like I'd make a post and then it would say "Page cannot be displayed" something along those lines.  Then I'd refresh and try again every 5 seconds and then in 2 minutes it works. But then said reply/post goes through and I'd click on another thread and it won't display.


#IJM (Idiot Joe Mazzulla)
I am the Master of Panic.

Re: Connection problems not resolved
« Reply #34 on: November 16, 2024, 01:03:32 PM »

Offline Silas

  • 2020 CelticsStrong Draft Guru
  • Ed Macauley
  • ***********
  • Posts: 11698
  • Tommy Points: 1999
Reading different threads and posting is still a major problem for me.  It's on and off and when on it's seems much slower than in the past.  I have no problems with other sites that I visit, just CelticsStrong.
I've lived through some terrible things in my life, some of which actually happened.   -  Mark Twain

Re: Connection problems not resolved
« Reply #35 on: November 16, 2024, 02:51:57 PM »

Offline Who

  • James Naismith
  • *********************************
  • Posts: 49758
  • Tommy Points: 2473
Reading different threads and posting is still a major problem for me.  It's on and off and when on it's seems much slower than in the past.  I have no problems with other sites that I visit, just CelticsStrong.

Same here.

Re: Connection problems not resolved
« Reply #36 on: November 16, 2024, 04:40:38 PM »

Offline Goldstar88

  • Ed Macauley
  • ***********
  • Posts: 11972
  • Tommy Points: 1577
Yep. Sometimes the page gets stuck/doesn?t load and refreshing doesn?t seem to help.
Quoting Nick from the now locked Ime thread:
Quote
At some point you have to blame the performance on the court on the players on the court. Every loss is not the coach's fault and every win isn't because of the players.

Re: Connection problems not resolved
« Reply #37 on: November 16, 2024, 08:21:22 PM »

Offline jpotter33

  • James Naismith
  • *********************************
  • Posts: 49959
  • Tommy Points: 3060
Yep, same here. Still getting the message that says something like "the page can't handle this request at this time" every so often. It last for awhile then goes away.
Recovering Joe Skeptic.

Re: Connection problems not resolved
« Reply #38 on: November 16, 2024, 10:22:10 PM »

Offline Phantom255x

  • Walter Brown
  • ********************************
  • Posts: 32812
  • Tommy Points: 3162
  • On To Banner 19!
Yeah sometimes I just can't get into the site anymore. Logging in is fine but actually entering the site I get a similar message as others above^
"Tough times never last, but tough people do." - Robert H. Schuller

Re: Connection problems not resolved
« Reply #39 on: November 18, 2024, 04:42:42 AM »

Offline Kernewek

  • Antoine Walker
  • ****
  • Posts: 4478
  • Tommy Points: 283
  • International Superstar
I don't know about everyone else, but I'm getting 503 errors from time to time - that's usually server overload, basically a bandwidth issue.
Man had always assumed that he was more intelligent than dolphins because he had achieved so much--the wheel, New York, wars and so on--whilst all the dolphins had ever done was muck about in the water having a good time.

But conversely, the dolphins had always believed that they were far more intelligent than man--for precisely the same reason.

Re: Connection problems not resolved
« Reply #40 on: November 22, 2024, 08:21:17 AM »

Online Roy H.

  • Forums Manager
  • James Naismith
  • *********************************
  • Posts: 60878
  • Tommy Points: -25540
  • Bo Knows: Joe Don't Know Diddley
I can't access my PMs.  I get the following error:

Quote
Query execution was interrupted, maximum statement execution time exceeded
File: /var/app/current/Sources/PersonalMessage.php
Line: 728

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0.15, while your database is at version 2.0.2. The above error might possibly go away if you execute the latest version of upgrade.php.


I'M THE SILVERBACK GORILLA IN THIS MOTHER——— AND DON'T NONE OF YA'LL EVER FORGET IT!@ 34 minutes

Re: Connection problems not resolved
« Reply #41 on: November 22, 2024, 05:37:37 PM »

Offline byennie

  • Webmaster
  • Jim Loscutoff
  • **
  • Posts: 2594
  • Tommy Points: 3043
I can't access my PMs.  I get the following error:

Quote
Query execution was interrupted, maximum statement execution time exceeded
File: /var/app/current/Sources/PersonalMessage.php
Line: 728

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0.15, while your database is at version 2.0.2. The above error might possibly go away if you execute the latest version of upgrade.php.

Thanks for reporting. One of the fixes I put in recently was having our database refuse any query > 10 seconds long. Not ideal but keeps problematic pages from affecting the whole site. If PMs are triggering it that's good to know and I'll see if I can figure out why.

One option might be archiving PMs before a certain date.

Does this happen consistently as soon as you access your PMs, or is it more intermittent / happens while viewing older messages etc?

Re: Connection problems not resolved
« Reply #42 on: November 22, 2024, 05:55:31 PM »

Online Roy H.

  • Forums Manager
  • James Naismith
  • *********************************
  • Posts: 60878
  • Tommy Points: -25540
  • Bo Knows: Joe Don't Know Diddley
I can't access my PMs.  I get the following error:

Quote
Query execution was interrupted, maximum statement execution time exceeded
File: /var/app/current/Sources/PersonalMessage.php
Line: 728

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0.15, while your database is at version 2.0.2. The above error might possibly go away if you execute the latest version of upgrade.php.

Thanks for reporting. One of the fixes I put in recently was having our database refuse any query > 10 seconds long. Not ideal but keeps problematic pages from affecting the whole site. If PMs are triggering it that's good to know and I'll see if I can figure out why.

One option might be archiving PMs before a certain date.

Does this happen consistently as soon as you access your PMs, or is it more intermittent / happens while viewing older messages etc?

The only time I've noticed it was today. I saw there was a new PM, and tried to retrieve it, but got the error message..


I'M THE SILVERBACK GORILLA IN THIS MOTHER——— AND DON'T NONE OF YA'LL EVER FORGET IT!@ 34 minutes