Nextcloud apache2 -DFOREGROUND High CPU usage

Hi!
I’ve recently installed truenas Dragonfish-24.04.2.3 on bare-metal on a Dell R720 and I’m testing the nextcloud app (official repo)

I’m noticing there’s a process that’s increasing usage every 20-30 min called apache2 -DFOREGROUND

It’s noticeable in the reports graphics

But also looking at htop every few minutes there’s a new one running

I’ve tried doing

su -m www-data -c 'php /var/www/html/occ db:add-missing-indices'
su -m www-data -c 'php /var/www/html/occ db:add-missing-columns'
su -m www-data -c 'php /var/www/html/occ maintenance:repair'

With the latest one, the CPU goes down again, but after a few minutes, it starts to escalate back up again.

For logs I only have this

DriverException
An exception occurred while executing a query: SQLSTATE[42803]: Grouping error: 7 ERROR: column "cr.id" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT "cr".*, "co"."calendardata", "c"."displayname", "c"."... ^
/var/www/html/3rdparty/doctrine/dbal/src/Connection.php
Line 1943
Doctrine\DBAL\Driver\API\PostgreSQL\ExceptionConverter->convert(

I think this is the culprit, and I’m not able to find a way to delete it.

Any ideas?

You have clients connected during this time? And more and more are connecting?
You cronjobs run every how many minutes, does this correspond to the steps in your graph?