Slow forum

Discuss issues and requests related with the forum software
User avatar
nnnik
Posts: 4475
Joined: 30 Sep 2013, 01:01
Location: Germany

Re: Slow forum

24 Feb 2020, 06:30

Tank had issues with the database before - did you check that @joedf
Recommends AHK Studio
just me
Posts: 7402
Joined: 02 Oct 2013, 08:51
Location: Germany

Re: Slow forum

24 Feb 2020, 09:23

Mmmh, feels as if bot throttling is enabled by default. :(
User avatar
joedf
Posts: 7792
Joined: 29 Sep 2013, 17:08
Facebook: J0EDF
Google: +joedf
GitHub: joedf
Location: Canada
Contact:

Re: Slow forum

24 Feb 2020, 09:56

I am not super clear on what scripts are running, but... from my last communication with tank, we both think it might a rogue php script or something...
I tried disabling the obvious anti-spam/bot scripts I could find but that didn't work...
If nothing works, we might have to start off with a fresh copy of phpbb, or perhaps an update... not sure. :think:

No fun, since this is just not viable. Forums are unusable like this... :/
swagfag
Posts: 4070
Joined: 11 Jan 2017, 17:59

Re: Slow forum

24 Feb 2020, 12:19

joedf wrote:
24 Feb 2020, 09:56
Forums are unusable
indeed
TAC109
Posts: 595
Joined: 02 Oct 2013, 19:41
Location: New Zealand

Re: Slow forum

24 Feb 2020, 16:17

The last time this happened @tank fixed it by sorting out the database.
My scripts:-
XRef - Produces Cross Reference lists for scripts
ReClip - A Text Reformatting and Clip Management utility
User avatar
kczx3
Posts: 1195
Joined: 06 Oct 2015, 21:39

Re: Slow forum

24 Feb 2020, 17:59

I can’t imagine that we need to start all over or an update to fix this. I’d offer to help though I have no access and no knowledge of the current system setup.
User avatar
joedf
Posts: 7792
Joined: 29 Sep 2013, 17:08
Facebook: J0EDF
Google: +joedf
GitHub: joedf
Location: Canada
Contact:

Re: Slow forum

24 Feb 2020, 20:19

I've managed to narrow it down to this specific line:
https://github.com/phpbb/phpbb/blob/c2c5c20c319d397948218b4c342fb146bf15040b/phpBB/common.php#L115

using the following simple snippet

Code: Select all

$start_time = microtime(TRUE);
// line to benchmark here ...
$end_time = microtime(TRUE);
echo $end_time - $start_time;
I've determined that this line cause a rather consistent 20 second lag.
I added $phpbb_container_builder->without_cache(); and the increased to 40.002 seconds.

The lag is consistently 20 seconds for me whether it's my speedy internet at home or somewhat slower network at work...

TLDR: This might be caused by parameters or throttling related to the DB.
User avatar
joedf
Posts: 7792
Joined: 29 Sep 2013, 17:08
Facebook: J0EDF
Google: +joedf
GitHub: joedf
Location: Canada
Contact:

Re: Slow forum

24 Feb 2020, 21:00

Update: Pretty certain this is mysql related. Manually connecting to the DB using shell access with
$ mysql -uUSERNAME -pPASS -hHOST [--port=Port] DB_Name
Leads to an 18-20 second lag till the prompt shows:
mysql>
User avatar
joedf
Posts: 7792
Joined: 29 Sep 2013, 17:08
Facebook: J0EDF
Google: +joedf
GitHub: joedf
Location: Canada
Contact:

Re: Slow forum

24 Feb 2020, 21:13

Update: talked to tank. so not exactly a DB issue, possibly some networking issue. We are narrowing the problem down.

Sorry for any inconvenience. Trying to keep people up to date. :+1:
TAC109
Posts: 595
Joined: 02 Oct 2013, 19:41
Location: New Zealand

Re: Slow forum

24 Feb 2020, 21:42

Good man, @joedf!
My scripts:-
XRef - Produces Cross Reference lists for scripts
ReClip - A Text Reformatting and Clip Management utility
User avatar
kczx3
Posts: 1195
Joined: 06 Oct 2015, 21:39

Re: Slow forum

25 Feb 2020, 09:04

joedf wrote:
24 Feb 2020, 21:13
Update: talked to tank. so not exactly a DB issue, possibly some networking issue. We are narrowing the problem down.

Sorry for any inconvenience. Trying to keep people up to date. :+1:
Thanks for the updates and good investigation! It is much appreciated. Do you get any useful output by appending the --verbose flag? Where is the database hosted?
User avatar
joedf
Posts: 7792
Joined: 29 Sep 2013, 17:08
Facebook: J0EDF
Google: +joedf
GitHub: joedf
Location: Canada
Contact:

Re: Slow forum

25 Feb 2020, 11:05

No bueno. no error messages. The black out possibly caused some kind of net interface issue. :/
gregster
Posts: 5371
Joined: 30 Sep 2013, 06:48

Re: Slow forum

25 Feb 2020, 11:07

What I see in working through long lists of approval requests multiple times in recent days is that apparently new users (or with low post count) apparently don't realize that their post or request already got through. So they end up double- or triple-posting and/or requesting approval 5 to 15 times until they seem to be able to see one of their posts.

"Normal" users don't seem to be affected. Not sure, if this is of any use for trouble-shooting... might not be a reason for, but another consequence of the current problems.
User avatar
kczx3
Posts: 1195
Joined: 06 Oct 2015, 21:39

Re: Slow forum

25 Feb 2020, 11:49

Silly question but what about rebooting both the app and database servers?
User avatar
joedf
Posts: 7792
Joined: 29 Sep 2013, 17:08
Facebook: J0EDF
Google: +joedf
GitHub: joedf
Location: Canada
Contact:

Re: Slow forum

25 Feb 2020, 14:50

@gregster
Very true and annoying. :s

@kczx3
We have tried that with all servers. Talked with tank, we took this as an opportunity to upgrade the server with more memory and disk space. :thumbup:
burque505
Posts: 1396
Joined: 22 Jan 2017, 19:37

Re: Slow forum

25 Feb 2020, 18:05

I just went to www.hardenize.com and got this report for www.autohotkey.com (also tried www.autohotkey.com/boards, same report).
(I'm trying to attach a 17kb screenshot, but it's not working. I'll try again. EDIT: Attachments will not load. RE-EDIT: Oops! It just took four minutes to load, but it did load.)
https problems.PNG
https problems.PNG (17.12 KiB) Viewed 2815 times
HTTPS

Web sites need to use encryption to help their visitors know they're in the right place, as well as provide confidentiality and content integrity. Sites that don't support HTTPS may expose sensitive data and have their pages modified and subverted.
There are issues with this site's HTTPS configuration.
For all sites VERY IMPORTANT medium EFFORT
User avatar
kczx3
Posts: 1195
Joined: 06 Oct 2015, 21:39

Re: Slow forum

25 Feb 2020, 18:18

I don’t think https has anything to do with the slowness
User avatar
lmstearn
Posts: 345
Joined: 11 Aug 2016, 02:32
GitHub: lmstearn
Contact:

Re: Slow forum

26 Feb 2020, 02:47

There was a MySql general error 2002 around 3 hours ago. There's 75 answers to that thread for pleasurable reading. :HeHe: Disk space is a common culprit.
The answer to this thread has a some clues if there were ever an IPV6 issue- it's most likely something to do with MySql- here's a typical thread which doesn't make for much light reading either. Good luck! :)
:arrow: itros "ylbbub eht tuO kaerB" a ni kcuts m'I pleH
User avatar
joedf
Posts: 7792
Joined: 29 Sep 2013, 17:08
Facebook: J0EDF
Google: +joedf
GitHub: joedf
Location: Canada
Contact:

Re: Slow forum

26 Feb 2020, 10:09

Thanks lmstearn, We've already tried and checked these. We think part the problem might have been on DigitalOcean's end.
We plan on migrating datacenters. :+1:
User avatar
kczx3
Posts: 1195
Joined: 06 Oct 2015, 21:39

Re: Slow forum

26 Feb 2020, 10:45

joedf wrote:
26 Feb 2020, 10:09
Thanks lmstearn, We've already tried and checked these. We think part the problem might have been on DigitalOcean's end.
We plan on migrating datacenters. :+1:
Obviously, this is in your guys' hands. And maybe there's info you have that we don't. But migrating datacenters seems like a pretty ballsy move in hopes that it fixes this ghost of a problem. Please make sure to communicate any downtime's associated with this.

Return to “Forum Issues”

Who is online

Users browsing this forum: No registered users and 3 guests