BuddyPress.org

Hi!
Trying to find the source of sudden weird lag on my large Buddypress website. I noticed this query running very frequently:

# Time: 220408 21:41:46
# User@Host: [removed] @ localhost []
# Thread_id: 337208  Schema: [removed] QC_hit: No
# Query_time: 1.645619  Lock_time: 0.000068  Rows_sent: 0  Rows_examined: 0
# Rows_affected: 0  Bytes_sent: 77
SET timestamp=1649454106;
SELECT DISTINCT a.id  FROM wp_bp_activity a  WHERE  
( 
	( 
		( 
			a.component = 'groups' 
			AND 
			a.item_id IN ( 0 )
		)
 
		AND 
		a.hide_sitewide = 0
	)

)
 AND a.is_spam = 0 AND a.type NOT IN ('activity_comment', 'last_activity') ORDER BY a.date_recorded DESC, a.id DESC LIMIT 0, 16;

Query_time: 1.645619

It always results in nothing. So, where is it coming from and how can I stop it?
Any idea what function is triggering this, I’d be able to even edit the core file just to have it check “if certain params are true, don’t even run this query”

I think it’s killing my site’s performance

Note: I am submitting this again because for some reason my initial post was marked as spam. I’m assuming because I edited it after I submitted it.

What is happening is when I try to make a change to the Components section in BuddyPress settings, I get the infamous “Sorry, you are not allowed to access this page.” when I try to save the settings and the settings do not take effect.

I am able to successfully enable and disable settings on the Options tab.

I have followed all the steps on several sites that talk about sorting this error, including reinstalling WordPress, deactivating all plugins, enabling debugging, using the default theme, regenerating permalinks, etc. etc.

The account has administrator role, and bbp_keymaster capabilities, from my attempt to fix the problem by installing bbPress. Deleting the database and starting over is not an option, even though this is a new site, I already have content.

What is odd is, when I get the error in WordPress, there are no corresponding PHP or Apache errors, and when I enable debugging, no errors are logged.

The only explanation I can come up with is that I have enabled IPv6/dual stack support on my network and it appears that the connection IP from my account isn’t consistent. Sometimes it connects with the IPv4 address, sometimes with the IPv6 address. That’s the only odd thing I can see in the Apache logs.

Site URL: https://displaced.zone

• WordPress Version: 5.8.1
• Directory install in root directory
• Upgraded from WordPress 5.7.1
• WordPress functions properly, other than this one problem
• BuddyPress Version: 9.1.1
• Not upgraded from a previous version
• Other Plugins: BP Better Messages, Comments Like Dislike, Top Bar, WP Cerber Security, WP Mail SMTP
• Theme: NS Minimal with minor css tweaks
• Core files have not been modified in any way
• No custom functions
• bbPress not installed, although I did install it to see if it would fix the problem
• No server error logs, which is weird
• Self hosted on a home network. I’m not a novice at this, I have done this for years, including a previous WordPress website where I had BuddyPress installed in the same environment, and did not have this issue. The only thing that has changed is the IPv6 support.
• Server OS: Debian GNU/Linux, Bullseye, typical LAMP stack
• I have tried both the Legacy and Nouveau BuddyPress themes
• I have made no changes to BuddyPress template files
• The only other information that might have a bearing on this is that I am not running WordPress “The Debian Way”. I have copied all the files, including the symlinked php libraries, out of the Debian file structure and am running them out of a folder in my home directory. Apache is running as that group and user. But again, I have done this for an entire year, successfully, with another website. Running WordPress this way allows me to use the built in WordPress update system, which doesn’t function as expected if you run WordPress “The Debian Way”.