Slow status checks on communty crm
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	Eileenmcnaughton
	May 14 2025, 6:50 AM

Description

@Qgil told me the site is slow to load once a day - we addressed this in fundraising by turning off checks that are slow when behind a firewall - ie

@Dwisehaupt
select * FROM civicrm_status_pref WHERE is_active = 0;
+----+-----------+----------------------------------+------------+-----------------+-------+------------+-----------+

domain_id

name

hush_until

ignore_severity

prefs

check_info

is_active

+----+-----------+----------------------------------+------------+-----------------+-------+------------+-----------+

1	1	checkLastCron	NULL	NULL	1546988405
2	1	checkExtensions	NULL	NULL	NULL
10	1	checkResourceUrl	NULL	NULL	NULL
11	1	checkUploadsAreNotAccessible	NULL	NULL	NULL
12	1	checkDirectoriesAreNotBrowseable	NULL	NULL	NULL
13	1	checkVersion	NULL	NULL	NULL

Event Timeline

Eileenmcnaughton created this task.May 14 2025, 6:50 AM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptMay 14 2025, 6:50 AM

Thanks. Right now we have these 4 jobs, all listed as active:

MariaDB [drupal]> select * FROM civicrm_status_pref WHERE is_active != 0;

id	domain_id	name	hush_until	prefs	check_info	is_active
1	1	checkLastCron	NULL	NULL	1747250100	1
2	1	checkPhpVersion	NULL	NULL	NULL	1
3	1	checkOutboundMail	NULL	NULL	NULL	1
4	1	checkDefaultMailbox	NULL	NULL	NULL	1

I could disable them all unless you feel there is some need to keep any of them active.

Dwisehaupt added a project: fundraising-tech-ops.May 14 2025, 7:28 PM

@Dwisehaupt if they are not in the civicrm_status_pref table they are implicitly active. The ones you have are quite likely OK but the ones I pasted are the ones we went out of our way to disable on fundraising - because they try to get info on the other side of the firewall (well checkLastCron is probably cos we run crons a bit differently & might be OK for community crm)

Ah, I see. Yes, there was nothing in the civicrm_status_pref with is_active = 0 either. If the checks are active if they aren't in the table, is there a way to find out what could be running?

I can add the ones listed above that we have disabled on the fundraising instance.

From memory it's a bit hard to find a whole list other than poking in the code - but I expect that list should cover it since it's about he fact it takes too long to time out when trying to access stuff that it is blocked from accessing (e.g doing a ping to civicrm.org to find out the latest release version)

Ok cool. I have updated the values for the ones that I believe make sense for its network posture:

MariaDB [drupal]> select * from civicrm_status_pref;

id	domain_id	name	hush_until	prefs	check_info	is_active
1	1	checkLastCron	NULL	NULL	1747257602	1
2	1	checkPhpVersion	NULL	NULL	NULL	0
3	1	checkOutboundMail	NULL	NULL	NULL	1
4	1	checkDefaultMailbox	NULL	NULL	NULL	1
5	1	checkExtensions	NULL	NULL	NULL	0
6	1	checkResourceUrl	NULL	NULL	NULL	0
7	1	checkVersion	NULL	NULL	NULL	0

We can keep this task open for a week to see if the behavior changes.

Dwisehaupt moved this task from Triage to In Progress on the fundraising-tech-ops board.May 14 2025, 10:04 PM

Thank you very much @Eileenmcnaughton for submitting this report.

@Qgil told me the site is slow to load once a day

To be more precise, in my experience the first time of the day I open a CiviCRM page, it will get stuck. If I click stop in the browser and reload, then it will load the page. Only then, the rest of the day is then fine.

I don't know if this happens only to me or to any Community CRM user the first time of their day loading a CiviCRM page.

@Qgil if the status checks are the cause then they won't affect lower permission users

XenoRyet triaged this task as Medium priority.May 19 2025, 8:22 PM

XenoRyet moved this task from Triage to Chaos Crew Backlog on the Fundraising-Backlog board.

XenoRyet added a project: Fundraising Tech - Chaos Crew.

Jgreen moved this task from In Progress to Up Next on the fundraising-tech-ops board.Aug 20 2025, 7:58 PM

XenoRyet moved this task from Chaos Crew Backlog to Chaos Holding Pen on the Fundraising-Backlog board.Oct 17 2025, 6:15 PM

XenoRyet edited projects, added Fundraising Tech Chaos Holding Pen; removed Fundraising Tech - Chaos Crew.Oct 17 2025, 6:17 PM

Closing this for now. If it is still an issue that needs work or additional investigation, feel free to reopen.

I don't think there was a magical day when it went from "problem" to "no problem" but the fact is that nowadays this isn't an issue for me, neither I have heard complaints.

@Qgil Dallas did make the changes discussed back when he marked it as resolved & we did see a magic change in testing at that time :-) But no-one looped back to the phab

Slow status checks on communty crmClosed, ResolvedPublicActions

Description

Event Timeline

Slow status checks on communty crm
Closed, ResolvedPublic
Actions