AARoads Forum

Meta => Suggestions and Questions => Topic started by: vdeane on March 09, 2024, 09:36:20 PM

Title: Slow Forum
Post by: vdeane on March 09, 2024, 09:36:20 PM
Anyone else noticing that the forum is really slow in the evenings?  I noticed that last night and thought it was odd, but then it happened again tonight.  No problem this afternoon, so it seems to be something specific to the time.
Title: Re: Slow Forum
Post by: Big John on March 09, 2024, 09:43:03 PM
Getting this too.
Title: Re: Slow Forum
Post by: Rothman on March 09, 2024, 09:57:16 PM
Sorta.
Title: Re: Slow Forum
Post by: jlam on March 09, 2024, 09:59:07 PM
Same deal here. A very noticeable difference.
Title: Re: Slow Forum
Post by: Hunty2022 on March 09, 2024, 10:54:04 PM
It's been really slow for me lately. At first I thought it was just bad Wi-Fi, but obviously that isn't it.
Title: Re: Slow Forum
Post by: Jim on March 09, 2024, 11:02:38 PM
Slow server response, occasional SMF DB errors for me in the last 36-48 hours or so.
Title: Re: Slow Forum
Post by: Max Rockatansky on March 09, 2024, 11:14:51 PM
Been like this for me over the last two days.
Title: Re: Slow Forum
Post by: AABattery on March 09, 2024, 11:24:24 PM
I was gonna say I haven't really noticed but right as I clicked the "reply" button it was being a bit slow  :-D
Title: Re: Slow Forum
Post by: LilianaUwU on March 10, 2024, 12:05:38 AM
I haven't noticed any slowdowns because my Canadian internet is already slow.
Title: Re: Slow Forum
Post by: Hot Rod Hootenanny on March 10, 2024, 12:55:34 AM
Thought it was just me.
I guess I qualify for compensation too.  :sombrero:
Title: Re: Slow Forum
Post by: freebrickproductions on March 10, 2024, 03:29:14 AM
I've noticed a bit of slowness here and there for the past little while, but didn't think too much of it.
Title: Re: Slow Forum
Post by: vdeane on March 10, 2024, 02:54:08 PM
Quote from: LilianaUwU on March 10, 2024, 12:05:38 AM
I haven't noticed any slowdowns because my Canadian internet is already slow.
Dial up slow?  I think it took 30 seconds to load threads and boards last night.
Title: Re: Slow Forum
Post by: jlam on March 10, 2024, 03:43:37 PM
The forum speed has noticeably improved on my end. It seems to be back to normal.
Title: Re: Slow Forum
Post by: Rothman on March 10, 2024, 04:51:49 PM
Quote from: jlam on March 10, 2024, 03:43:37 PM
The forum speed has noticeably improved on my end. It seems to be back to normal.
Wait until tonight...
Title: Re: Slow Forum
Post by: jlam on March 10, 2024, 11:38:54 PM
Quote from: Rothman on March 10, 2024, 04:51:49 PM
Quote from: jlam on March 10, 2024, 03:43:37 PM
The forum speed has noticeably improved on my end. It seems to be back to normal.
Wait until tonight...
It is now in that evening/dusk/night time slot, and the forum is still operating at normal speeds on my side.
Title: Re: Slow Forum
Post by: kphoger on March 11, 2024, 10:52:48 AM
In general, every click to a thread nowadays takes longer to load the page than it used to.  Maybe around four or five seconds, I suppose.  Sometimes the [Modify] or [Save] action too.
Title: Re: Slow Forum
Post by: Jim on March 11, 2024, 12:05:13 PM
My observation is that Sunday and today I am seeing behavior much closer to normal than Friday and Saturday, but not back to normal.
Title: Re: Slow Forum
Post by: Hunty2022 on March 11, 2024, 09:04:08 PM
The forum speed is almost back to normal for me now.
Title: Re: Slow Forum
Post by: hotdogPi on March 15, 2024, 10:19:59 AM
It appears to be slow now, and it's before noon.
Title: Re: Slow Forum
Post by: Hunty2022 on March 15, 2024, 11:10:13 AM
It's been really slow to load threads/other stuff on my end for the past ~16 hours (again).
Title: Re: Slow Forum
Post by: MATraveler128 on March 15, 2024, 11:12:04 AM
Very slow for me loading threads also even at home on good Wi-Fi. Posting is about normal speed.
Title: Re: Slow Forum
Post by: CtrlAltDel on March 15, 2024, 11:20:37 AM
Quote from: 1 on March 15, 2024, 10:19:59 AM
It appears to be slow now, and it's before noon.

Same here.
Title: Re: Slow Forum
Post by: Rothman on March 18, 2024, 09:33:25 AM
Forum's just weird for me today.  Very slow when trying to load some threads; search has become intolerably slow...but then this thread just popped up...
Title: Re: Slow Forum
Post by: kphoger on March 19, 2024, 02:10:52 PM
Oh, good grief, this is getting ridiculous.  Google Maps The AARoads forum just fucking sucks now.
Title: Re: Slow Forum
Post by: roadman65 on March 19, 2024, 02:15:24 PM
The search engine was totally unresponsive. Thought it was my pc, but now I'm seeing others experiencing something.
Title: Re: Slow Forum
Post by: kphoger on March 19, 2024, 03:21:52 PM
Quote from: roadman65 on March 19, 2024, 02:15:24 PM
The search engine was totally unresponsive. Thought it was my pc, but now I'm seeing others experiencing something.

The site search engine hasn't been totally unresponsive for me...  But I can hit [Search], get up, heat up a mug of water in the microwave for tea, come back, and it's still spinning its wheels.  I can also hit [Search], duplicate the tab, go to the main forum list, click on a thread (which still takes a while to load), and that thread will pop up before the search is done searching in the original tab.
Title: Re: Slow Forum
Post by: Hunty2022 on March 19, 2024, 05:11:51 PM
Earlier, I tried to use the forum search feature to see if a thread idea I had/have wasn't taken. The first search was a little slow, but it worked. The second one didn't work at all.
Title: Re: Slow Forum
Post by: Scott5114 on March 20, 2024, 01:32:52 AM
I'm baffled as to what might be going on here, because I'm having none of these problems (other than search being slow, which probably has something to do with the databases we had to rebuild after the Tulsa copyright incident.)
Title: Re: Slow Forum
Post by: Max Rockatansky on March 21, 2024, 07:41:43 PM
Seems we are after a break for a day.
Title: Re: Slow Forum
Post by: hotdogPi on March 21, 2024, 07:44:34 PM
Discord seems to say that it was the Russians, not the New Urbanists, at fault. It was simply an overload; they didn't hack anything.
Title: Re: Slow Forum
Post by: Max Rockatansky on March 21, 2024, 07:46:36 PM
Perhaps Russian New Urbanists?
Title: Re: Slow Forum
Post by: Hunty2022 on March 21, 2024, 08:04:17 PM
I say the slow forum issues were the start of the closing of the forum, and that it has something to do with that.

All of the problems are fixed for me now.
Title: Re: Slow Forum
Post by: Alex on March 21, 2024, 09:18:14 PM
I suspect the slowdown problems were the beginning of what led up to Ionos locking the MySQL Database for the forum yesterday morning. I received an email then referencing that the database "has been locked because the workload and number of connections are too high. It will no longer respond to call requests."

They also added "When programming, please also make sure that there is not too much load on the database servers."

It has been quite awhile since the server was last hacked, probably over ten years at this point. This is something different targeting the database. I also searched the file folders for any new files added recently, and found only one that was updated as recently at 7:30 ET. So nothing there.

I mentioned to tech support that this database is for an SMF going back 15 years now and never had a problem like this before. I was hoping to get some idea of what we should be looking for as far as the overwhelming number of call requests, but they didn't suggest anything.

So if the forum slows way down again (which it might given all I did was have them unlock the database), then we'll need to switch it to maintenance mode and figure something out.
Title: Re: Slow Forum
Post by: hotdogPi on March 21, 2024, 09:20:56 PM
If it overloads, is "viewable by logged-in only" an option?
Title: Re: Slow Forum
Post by: JayhawkCO on March 21, 2024, 10:11:11 PM
Quote from: Alex on March 21, 2024, 09:18:14 PM
I suspect the slowdown problems were the beginning of what led up to Ionos locking the MySQL Database for the forum yesterday morning. I received an email then referencing that the database "has been locked because the workload and number of connections are too high. It will no longer respond to call requests."

They also added "When programming, please also make sure that there is not too much load on the database servers."

It has been quite awhile since the server was last hacked, probably over ten years at this point. This is something different targeting the database. I also searched the file folders for any new files added recently, and found only one that was updated as recently at 7:30 ET. So nothing there.

I mentioned to tech support that this database is for an SMF going back 15 years now and never had a problem like this before. I was hoping to get some idea of what we should be looking for as far as the overwhelming number of call requests, but they didn't suggest anything.

So if the forum slows way down again (which it might given all I did was have them unlock the database), then we'll need to switch it to maintenance mode and figure something out.

I can attempt to take a look under the hood if you like. I'm a manager of database administrators. I don't know MySQL, but I know enough to Google my way through.
Title: Re: Slow Forum
Post by: GaryV on March 21, 2024, 10:13:46 PM
Quote from: Max Rockatansky on March 21, 2024, 07:46:36 PM
Perhaps Russian New Urbanists?

Maybe a Finn? Nah, he ain't smart enough.
Title: Re: Slow Forum
Post by: Big John on March 21, 2024, 11:59:03 PM
Quote from: GaryV on March 21, 2024, 10:13:46 PM
Quote from: Max Rockatansky on March 21, 2024, 07:46:36 PM
Perhaps Russian New Urbanists?

Maybe a Finn? Nah, he ain't smart enough.

mmm......
Title: Re: Slow Forum
Post by: andarcondadont on March 22, 2024, 01:16:32 AM
Quote from: Max Rockatansky on March 21, 2024, 07:41:43 PM
Seems we are after a break for a day.
Oh no, how can I live?! :no:
Title: Re: Slow Forum
Post by: Alex on March 22, 2024, 09:01:05 AM
Quote from: JayhawkCO on March 21, 2024, 10:11:11 PM
I can attempt to take a look under the hood if you like. I'm a manager of database administrators. I don't know MySQL, but I know enough to Google my way through.

Certainly welcome any assistance. Sent you an email.
Title: Re: Slow Forum
Post by: JayhawkCO on March 22, 2024, 09:08:45 AM
Quote from: Alex on March 22, 2024, 09:01:05 AM
Quote from: JayhawkCO on March 21, 2024, 10:11:11 PM
I can attempt to take a look under the hood if you like. I'm a manager of database administrators. I don't know MySQL, but I know enough to Google my way through.

Certainly welcome any assistance. Sent you an email.

Didn't receive anything. Looked in spam too. I'll PM you with my email address.
Title: Re: Slow Forum
Post by: Alex on March 22, 2024, 10:09:51 AM
Quote from: JayhawkCO on March 22, 2024, 09:08:45 AM
Quote from: Alex on March 22, 2024, 09:01:05 AM
Quote from: JayhawkCO on March 21, 2024, 10:11:11 PM
I can attempt to take a look under the hood if you like. I'm a manager of database administrators. I don't know MySQL, but I know enough to Google my way through.

Certainly welcome any assistance. Sent you an email.

Didn't receive anything. Looked in spam too. I'll PM you with my email address.

So much for the option to email someone from your profile on SMF. Unless the email associated with your account is not up to date.
Can take this discussion to a PM. Otherwise after two hours I have made zero headway on how to deal with this flood attack.
Title: Re: Slow Forum
Post by: vdeane on March 22, 2024, 12:21:50 PM
It seems to be getting this way again - even got a "connection problems" error once.  Time for maintenance mode or logged-in only?
Title: Re: Slow Forum
Post by: Alex on March 22, 2024, 02:35:44 PM
Quote from: vdeane on March 22, 2024, 12:21:50 PM
It seems to be getting this way again - even got a "connection problems" error once.  Time for maintenance mode or logged-in only?

I may have found the source of the problem, or at least part of the source. There is an error with depreciated code associated with Load.php, one of the core SMF files, that is triggering up to 25 times every 2 minutes. Looking at the logs, 1,000 errors over a two hour period this afternoon alone.
Title: Re: Slow Forum
Post by: Rothman on March 22, 2024, 03:26:37 PM
A grenade should do the trick.
Title: Re: Slow Forum
Post by: rickmastfan67 on March 23, 2024, 02:43:05 AM
Quote from: Alex on March 22, 2024, 10:09:51 AM
Quote from: JayhawkCO on March 22, 2024, 09:08:45 AM
Quote from: Alex on March 22, 2024, 09:01:05 AM
Quote from: JayhawkCO on March 21, 2024, 10:11:11 PM
I can attempt to take a look under the hood if you like. I'm a manager of database administrators. I don't know MySQL, but I know enough to Google my way through.

Certainly welcome any assistance. Sent you an email.

Didn't receive anything. Looked in spam too. I'll PM you with my email address.

So much for the option to email someone from your profile on SMF. Unless the email associated with your account is not up to date.
Can take this discussion to a PM. Otherwise after two hours I have made zero headway on how to deal with this flood attack.

That feature is currently broken due to a recent update on the backend.  Hopefully that will be back when we go to the 2.1.x branch.
Title: Re: Slow Forum
Post by: roadman65 on April 06, 2024, 06:30:35 PM
I've had twice today a message that read "time out on session"when I tried to post in a thread.
Title: Re: Slow Forum
Post by: hotdogPi on April 06, 2024, 06:32:57 PM
I've had no connection issues at all since the upgrade. No slow forum. No server connection issues. No false positive 15-second cooldown. No parked domain page instead of a forum.

Searching in a thread is still broken.
Title: Re: Slow Forum
Post by: Rothman on April 07, 2024, 12:26:06 AM
No issues for me.
Title: Re: Slow Forum
Post by: hotdogPi on April 10, 2024, 11:19:22 AM
Update: The "parked domain" issue has not been fixed, although it's not really a problem since reloading the page after a few seconds always fixes it.
Title: Re: Slow Forum
Post by: vdeane on April 14, 2024, 03:37:15 PM
I've noticed some slowness creep in today along with occasional page load fails.  That said, this isn't a forum issue, but rather a site-wide issue, since the main home page does it too.
Title: Re: Slow Forum
Post by: Roadgeekteen on April 18, 2024, 12:00:25 PM
It's running quite slow for me as well.
Title: Re: Slow Forum
Post by: Rothman on April 18, 2024, 10:45:46 PM
Forum's fine.
Title: Re: Slow Forum
Post by: Alex on April 19, 2024, 07:54:23 AM
Quote from: Roadgeekteen on April 18, 2024, 12:00:25 PMIt's running quite slow for me as well.

The main site has been sluggish all week, so that may be factoring into issues here.

Looks like another call to Ionos is in order...  :banghead:
Title: Re: Slow Forum
Post by: Scott5114 on April 20, 2024, 01:15:49 AM
IONOS = Infernal Owners of Non-Operational Servers