Nextcloud version (eg, 18.0.2): 18.0.6 Operating system and version (eg, Ubuntu 20.04): Debian 10.4 Apache or nginx version (eg, Apache 2.4.25): Apache/2.4.38 (Debian) PHP version (eg, 7.1): 7.3.14-1~deb10u1 The issue you are facing: CPU has been near 100% for over 24 hours now, on a dedicated…

I finally found time to write a issue on GitHub: Query on oc_filecache uses wrong index - Cron job runs very long opened 09:06PM - 26 Nov 20 UTC (UTC) [JohnWalkerx] JohnWalkerx …

Did you check the database itself for errors/corruption, slow queries and such? oc_filescache is known to be large, but what is the size of database file(s) (in relation to amount of actual handled files in NC and found files in NC data dir)? Also mysqltuner or similar tool can help to check for in…

In my case, it helped recuding the cron frequency from every 5 mins to 15 mins and adding flock to avoid multiple runs in case the previous has not exited: /var/spool/cron/crontabs/www-data: */15 * * * * flock /tmp php -f /var/www/html/cron.php

I’m facing the similar problem. I started using the PreviewGenerator an generated the 32, 64, 256 and 2048 px previews for my 440 GB files (113 GB is my photo libary). With this my oc_filecache table grown to a size of 420 MB. I saw that the cron-job calls this (long running) query, like in your …

Similar problem here. My shared hosting provider complains about excess CPU usage even though I only use Nextcloud for my family with very low usage. I also use PreviewGenerator. Unfortunately not technical enough to give much more info. My hosting provider is threatening to kick me off their servic…

[image] Cron task ScanFiles takes hours to finish ℹ️ Support I am running on 19.0.4 right now, but the problem already started earlier. I assume that it started to appear when upgrading to NC19, but this could also be a false assumption. Anyhow, after reading some threads…

Hey @h3rb3rt , it looks like that your situation (file scan / symlinks) is maybe the same result but a different reason. Also for me it didn’t worked with flock. I had the same issues.

I made some tests at my database why this query is so slow. The short version: For this query the wrong index is used. Longer version: We talk about this query: SELECT `path` FROM nextcloud.oc_filecache WHERE `storage` = 1 AND `size` < 0 ORDER BY `fileid` DESC I asked the MySQL-Server to expla…

Ok, this is a little too much magic for me :wink: Reading this I have no clue how and if I could verify this on my instance at all, but after installed some extended monitoring I see that after the cron starts (still not knowing what it exactly does all the time) the IO to my mounted NFS storage wh…

Multiple topics about long running cron jobs/high CPU usage and pretty much no response from anybody except for the multiple people who are having the problem. Is anyone working on this? While I love Nextcloud, this lack of support/responsiveness impedes Nextcloud’s ability to become a mainstream s…

Thank you ! I just realized a couple weeks ago that my cron.php via webcron was not working anymore. Set up cron and found out that it tends to run endlessly and multiple times. It does eat all of my mariadb server’s cpu on this request… SELECT path FROM oc_filecache WHERE (storage = 879) AND (size …

Nextcloud community

The cron.php tasks run for hours, constant CPU load, queries on oc_filecache

ℹ️ Support

JohnWalker November 26, 2020, 9:08pm 30

I finally found time to write a issue on GitHub:

Background Job ScanFiles triggered via cron.php breaks my system