Error message

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
User avatar
Exclusive
Registered User
Posts: 421
Joined: Mon Jun 25, 2018 1:33 pm

Re: Error message

Post by Exclusive » Tue Oct 08, 2019 8:48 pm

hrp402 wrote:
Tue Oct 08, 2019 12:45 am
Hi there, I'm another user of the forum and am helping figure out this issue. File ownership and permissions are all correct and the site was previously working. As far as I know no changes have been made to the site recently.

The last time we had issues, it was with the cache and we even had issues deleting the files out of the cache directory. But I just deleted them and I didn't run into a stuck file this time. And it didn't clear up the issue either.

I think I agree with you Exclusive that this is a host issue. This is a shared server if I'm not mistaken. What would you suggest if they push back on it being their issue?
The very first mistake we do in our hosting account is installing phpBB software from cPanel, It is always advisable to download it from the phpBB official site and install it to the directory you want your forum to be because, many web hosting severs sometime do an auto update to the software once there is a new release without the owner's consent, to avoid this don't install phpBB directly from cPanel (I was once a victim/out of experience).

Since it is a shared hosting account, it is possible that your forum is consuming a lot the server's resource, therefore queries are causing high usage. If your database requests are very long, please optimize MYSQL queries on your site, or you can setup remote database on another server. Since the current usage is not fit for Shared Hosting, you can also choose to move to a VPS Hosting or you could decide to move to another provider of your choice, but before this, you need to contact your host in regards to the issues you're facing if there could be any possible solution by them, they should know or tell better.
Use Search Button to get Instant Results | Follow Forum Rules
Avoid Spams in the forum to prevent banning the offending account. | ⟿ Visit My Awesome phpBB Forum! ⬳

Get The Best Web Hosting | ✔ Buy Cheap Domain Names

Jestcoyote
Registered User
Posts: 43
Joined: Sun Jul 07, 2013 5:58 am
Location: Omaha, NE
Name: Mark
Contact:

Re: Error message

Post by Jestcoyote » Tue Oct 08, 2019 11:28 pm

Guests

Jestcoyote
Registered User
Posts: 43
Joined: Sun Jul 07, 2013 5:58 am
Location: Omaha, NE
Name: Mark
Contact:

Re: Error message

Post by Jestcoyote » Tue Oct 08, 2019 11:35 pm

And now I can't get to Bluehost's support page.

User avatar
JoshyPHP
Code Contributor
Posts: 1046
Joined: Mon Jul 11, 2011 12:28 am

Re: Error message

Post by JoshyPHP » Wed Oct 09, 2019 1:04 am

I see at least 3 different issues in this topic:
  1. phpBB 3.2.2 is outdated. Update it now before doing anything else.
  2. If you have hundreds of anonymous users from the same IP range, you should look into what they're doing. If their user-agent shows they're a bot, then create a bot entry for it. If they spoof their user-agent, you might as well ban their IP range.
  3. The errors from that log look like a server issue/misconfiguration and therefore not something a shared user can fix. Disregard if you're actually on a VPS.
I wrote the thing that does BBCodes in 3.2.

hrp402
Registered User
Posts: 6
Joined: Sat Apr 14, 2018 1:19 am

Re: Error message

Post by hrp402 » Fri Oct 25, 2019 12:07 am

So it appears that maybe this issue is due to the database. I'm seeing a lot of failed connection.

Code: Select all

			Conn #	ø / hr	%
Max. conc conn		108	---	---
Failed attempts		4,607	116.78	0.30%
Aborted			1,968	49.88	0.13%
I also see a lot of table scanning going on. Select full joins is at 159.5 k and Handler read rnd next is at 9.7 G.

Has anyone else experienced this? My thought is that we should add indexes based on what columns are being used for joins and filters. That would certainly reduce the table scans and hopefully stop the failed and aborted connections.

My main concern with doing this is why is the database not already properly indexed? Is this normal or did something go wrong a long time ago (say a database update during an upgrade)?

User avatar
JoshyPHP
Code Contributor
Posts: 1046
Joined: Mon Jul 11, 2011 12:28 am

Re: Error message

Post by JoshyPHP » Fri Oct 25, 2019 12:53 am

Without the slow query log you won't really know whether there's an issue with any requests. Do you have access to the slow query log?

There are other things that should probably take priority, e.g.:
  • Make sure you have the latest version of phpBB.
  • Same with a recent version of PHP (7.2.x)
  • Enable Opcache, even if it's only using the file-based storage.
  • Convert tables to InnoDB.
  • Disable all extensions and see if it immediately fixes the 500 errors.
I wrote the thing that does BBCodes in 3.2.

hrp402
Registered User
Posts: 6
Joined: Sat Apr 14, 2018 1:19 am

Re: Error message

Post by hrp402 » Fri Oct 25, 2019 1:04 am

JoshyPHP wrote:
Fri Oct 25, 2019 12:53 am
Without the slow query log you won't really know whether there's an issue with any requests. Do you have access to the slow query log?

There are other things that should probably take priority, e.g.:
  • Make sure you have the latest version of phpBB.
  • Same with a recent version of PHP (7.2.x)
  • Enable Opcache, even if it's only using the file-based storage.
  • Convert tables to InnoDB.
  • Disable all extensions and see if it immediately fixes the 500 errors.
Not that I have seen. But this may just be a red herring. I was watching the monitor in phpMyAdmin and the number of connections were not that high when the issue was actively occurring.

I started looking into other things and I noticed our traffic is WAY up this month:

October: 9,092,736
September: 4,243,638
August: 2,009,238
July: 1,918,919
June: 703,865

It has been rising the last few months but then doubled the last two months. We do not have that many members to account for that increase. I downloaded the access logs and noticed a LOT of 159.138.*.* IPs, which I tracked to Huawei HongKong Clouds. We are a community based around the city of Omaha, NE. We should not have that much (or really any) foreign traffic.

I blocked 159.138.0.0-159.138.255.255 in cPanel and so far things are running much better.

User avatar
MarkDHamill
Registered User
Posts: 3943
Joined: Fri Aug 02, 2002 12:36 am
Location: Florence, MA USA
Contact:

Re: Error message

Post by MarkDHamill » Fri Oct 25, 2019 3:58 pm

I have a client with BlueHost with similar issues. We've tried a number of strategies. Ideally this traffic would be deflected away from your domain before it ever hits it. If you don't want to get ANY traffic from countries that are spamming you, like China, a cloud service that filters out these countries for you might help. For example, if you have Cloudflare you can change your .htaccess file to block certain countries.

https://support.cloudflare.com/hc/en-us ... cation-do-

I have been working on a filter by country extension. It's not ready for prime time yet, being Beta, but when released it will help address issues like these.

viewtopic.php?f=456&t=2513016
Get the latest versions of my Digests and Smartfeed extensions.
Need phpBB services or a phpBB consultant? I offer most phpBB services.

Post Reply

Return to “[3.2.x] Support Forum”