Nextcloud apache2 -DFOREGROUND

[bluepr0]

Hi!
I’ve recently installed truenas Dragonfish-24.04.2.3 on bare-metal on a Dell R720.

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 to Add missing DB indexes in case it was that with

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

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(

Any ideas?

[bluepr0]

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.

[bluepr0]

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