nextcloud / server

☁️ Nextcloud server, a safe home for all your data
https://nextcloud.com
GNU Affero General Public License v3.0
27.38k stars 4.07k forks source link

[Bug]: OCA\DAV\BackgroundJob\RefreshWebcalJob takes way too long in cronjob and huge binlogs #40814

Open MiningPickaxe opened 1 year ago

MiningPickaxe commented 1 year ago

⚠️ This issue respects the following points: ⚠️

Bug description

During the cronjob run there is excessive load on the database, the cron run takes about 10 minutes. I also generate 100-200mb of binlogs per minute.

When checking the oc_jobs table to see what takes so long this is the output:

MariaDB [nextcloud]> select * from oc_jobs;
+-------+-----------------------------------------------------------------+----------------------------------------------------------------+------------+--------------+-------------+--------------------+----------------------------------+----------------+
| id    | class                                                           | argument                                                       | last_run   | last_checked | reserved_at | execution_duration | argument_hash                    | time_sensitive |
+-------+-----------------------------------------------------------------+----------------------------------------------------------------+------------+--------------+-------------+--------------------+----------------------------------+----------------+
|     1 | OCA\Activity\BackgroundJob\EmailNotification                    | null                                                           | 1641761479 |   1696722302 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
|     2 | OCA\Activity\BackgroundJob\ExpireActivities                     | null                                                           | 1641762120 |   1696722302 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
|     3 | OCA\Activity\BackgroundJob\DigestMail                           | null                                                           | 1641762141 |   1696722302 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
|     4 | OCA\Text\Cron\Cleanup                                           | null                                                           | 1696720426 |   1696720426 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
|     5 | OCA\WorkflowEngine\BackgroundJobs\Rotate                        | null                                                           | 1696710301 |   1696720426 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
|     6 | OCA\NextcloudAnnouncements\Cron\Crawler                         | null                                                           | 1696685101 |   1696719761 |           0 |                  1 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
|     7 | OCA\ContactsInteraction\BackgroundJob\CleanupJob                | null                                                           | 1696714202 |   1696719761 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              0 |
|     8 | OCA\Files_Versions\BackgroundJob\ExpireVersions                 | null                                                           | 1696719761 |   1696719761 |           0 |                  2 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
|     9 | OCA\Federation\SyncJob                                          | null                                                           | 1696715102 |   1696719763 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
|    10 | OCA\UserStatus\BackgroundJob\ClearOldStatusesBackgroundJob      | null                                                           | 1696719763 |   1696719763 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
|    11 | OCA\Circles\Cron\Maintenance                                    | null                                                           | 1696719763 |   1696719763 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
|    12 | OCA\DAV\BackgroundJob\CleanupDirectLinksJob                     | null                                                           | 1696714802 |   1696719763 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              0 |
|    13 | OCA\DAV\BackgroundJob\UpdateCalendarResourcesRoomsBackgroundJob | null                                                           | 1696716602 |   1696719763 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
|    14 | OCA\DAV\BackgroundJob\CleanupInvitationTokenJob                 | null                                                           | 1696714802 |   1696719763 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              0 |
|    15 | OCA\DAV\BackgroundJob\EventReminderJob                          | null                                                           | 1696719763 |   1696719763 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
|    16 | OCA\DAV\BackgroundJob\CalendarRetentionJob                      | null                                                           | 1696710901 |   1696719763 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
|    17 | OCA\Files_Sharing\DeleteOrphanedSharesJob                       | null                                                           | 1696719763 |   1696719763 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
|    18 | OCA\Files_Sharing\ExpireSharesJob                               | null                                                           | 1696714802 |   1696719763 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              0 |
|    19 | OCA\Files_Sharing\BackgroundJob\FederatedSharesDiscoverJob      | null                                                           | 1696714802 |   1696719763 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
|    20 | OCA\Files_Trashbin\BackgroundJob\ExpireTrash                    | null                                                           | 1696719763 |   1696719763 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
|    21 | OCA\UpdateNotification\Notification\BackgroundJob               | null                                                           | 1696714802 |   1696719763 |           0 |                 35 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
|    22 | OCA\Notifications\BackgroundJob\GenerateUserSettings            | null                                                           | 1696716302 |   1696719763 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
|    23 | OCA\Notifications\BackgroundJob\SendNotificationMails           | null                                                           | 1696719763 |   1696719763 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
|    24 | OCA\Support\BackgroundJobs\CheckSubscription                    | null                                                           | 1696719763 |   1696719763 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
|    25 | OCA\Files\BackgroundJob\ScanFiles                               | null                                                           | 1696719763 |   1696719763 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
|    26 | OCA\Files\BackgroundJob\DeleteOrphanedItems                     | null                                                           | 1696716302 |   1696719763 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
|    27 | OCA\Files\BackgroundJob\CleanupFileLocks                        | null                                                           | 1696719763 |   1696719763 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
|    28 | OCA\Files\BackgroundJob\CleanupDirectEditingTokens              | null                                                           | 1696719763 |   1696719763 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
|    29 | OCA\ServerInfo\Jobs\UpdateStorageStats                          | null                                                           | 1696719763 |   1696719763 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
|    30 | OC\Authentication\Token\DefaultTokenCleanupJob                  | null                                                           | 1653777902 |   1696732501 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
|    31 | OC\Log\Rotate                                                   | null                                                           | 1696720305 |   1696720305 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
|    32 | OC\Preview\BackgroundCleanupJob                                 | null                                                           | 1696720305 |   1696720305 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
|    34 | OCA\Calendar\BackgroundJob\CleanUpOutdatedBookingsJob           | null                                                           | 1696716302 |   1696719763 |           0 |                  1 | 37a6259cc0c1dae299a7866489dff0bd |              0 |
|    35 | OCA\Deck\Cron\DeleteCron                                        | null                                                           | 1696716303 |   1696719763 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              0 |
|    36 | OCA\Deck\Cron\ScheduledNotifications                            | null                                                           | 1696719763 |   1696719763 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
|    37 | OCA\Deck\Cron\CardDescriptionActivity                           | null                                                           | 1696719763 |   1696719763 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
|    38 | OCA\GroupFolders\BackgroundJob\ExpireGroupVersions              | null                                                           | 1696716303 |   1696719763 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
|    39 | OCA\Mail\BackgroundJob\CleanupJob                               | null                                                           | 1696716303 |   1696719763 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              0 |
|    40 | OCA\Talk\BackgroundJob\ExpireSignalingMessage                   | null                                                           | 1696719763 |   1696719763 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
|    41 | OCA\Talk\BackgroundJob\RemoveEmptyRooms                         | null                                                           | 1696719763 |   1696719763 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              0 |
|    42 | OCA\Talk\BackgroundJob\ResetAssignedSignalingServer             | null                                                           | 1696719763 |   1696719763 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
|    44 | OCA\Talk\BackgroundJob\CheckHostedSignalingServer               | null                                                           | 1696716303 |   1696719763 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
|    45 | OCA\Talk\BackgroundJob\CheckMatterbridges                       | null                                                           | 1696719763 |   1696719763 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
|   186 | OCA\Appointments\Cron\Reminders                                 | null                                                           | 1642020902 |   1696754101 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
|   212 | OCA\AdminAudit\BackgroundJobs\Rotate                            | null                                                           | 1696719763 |   1696719763 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
|   217 | OCA\Polls\Cron\NotificationCron                                 | null                                                           | 1696719763 |   1696719763 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
|   218 | OCA\Polls\Cron\JanitorCron                                      | null                                                           | 1696716303 |   1696719763 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
|   219 | OCA\Polls\Cron\AutoReminderCron                                 | null                                                           | 1696719763 |   1696719763 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
|   946 | OCA\PhoneTrack\Cron\AutoExport                                  | null                                                           | 1642352109 |   1696732501 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
|  1783 | OCA\Contacts\Cron\SocialUpdateRegistration                      | null                                                           | 1696559101 |   1696719763 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              0 |
|  3718 | OCA\Mail\BackgroundJob\SyncJob                                  | {"accountId":1}                                                | 1696716303 |   1696719763 |           0 |                  3 | 562423afc287d53e27bc1d34fbc41ce5 |              1 |
|  3719 | OCA\Mail\BackgroundJob\TrainImportanceClassifierJob             | {"accountId":1}                                                | 1696716306 |   1696719763 |           0 |                  0 | 562423afc287d53e27bc1d34fbc41ce5 |              0 |
|  3960 | OCA\Mail\BackgroundJob\SyncJob                                  | {"accountId":2}                                                | 1696716306 |   1696719763 |           0 |                  2 | ef33fafb0b9077ce575d122c006ecdfe |              1 |
|  3961 | OCA\Mail\BackgroundJob\TrainImportanceClassifierJob             | {"accountId":2}                                                | 1696716308 |   1696719763 |           0 |                  0 | ef33fafb0b9077ce575d122c006ecdfe |              0 |
|  9822 | OCA\Bookmarks\BackgroundJobs\CrawlJob                           | null                                                           | 1648471809 |   1696732817 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
|  9823 | OCA\Bookmarks\BackgroundJobs\FileCacheGCJob                     | null                                                           | 1648471809 |   1696732817 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
| 12290 | OCA\News\Cron\UpdaterJob                                        | null                                                           | 1677696052 |   1696754101 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
| 14777 | OCA\UpdateNotification\ResetTokenBackgroundJob                  | null                                                           | 1696719763 |   1696719763 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
| 15714 | OC\Core\BackgroundJobs\CleanupLoginFlowV2                       | null                                                           | 1696720305 |   1696720305 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
| 15715 | OC\Security\Bruteforce\CleanupJob                               | null                                                           | 1696716308 |   1696720305 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              0 |
| 15813 | OCA\Mail\BackgroundJob\SyncJob                                  | {"accountId":6}                                                | 1696716308 |   1696719763 |           0 |                  3 | a24308c81fa9d50ad05d869894220cba |              1 |
| 15814 | OCA\Mail\BackgroundJob\TrainImportanceClassifierJob             | {"accountId":6}                                                | 1696716311 |   1696719763 |           0 |                  0 | a24308c81fa9d50ad05d869894220cba |              0 |
| 15839 | OCA\Collectives\BackgroundJob\ExpirePageVersions                | null                                                           | 1696716311 |   1696719763 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              0 |
| 15840 | OCA\Collectives\BackgroundJob\PurgeObsoleteCollectives          | null                                                           | 1655483102 |   1696732817 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              0 |
| 15841 | OCA\Collectives\BackgroundJob\PurgeObsoletePages                | null                                                           | 1696702802 |   1696719763 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              0 |
| 16005 | OCA\Bookmarks\BackgroundJobs\BackupJob                          | null                                                           | 1648471809 |   1696732817 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
| 16006 | OCA\Bookmarks\BackgroundJobs\ExtractFromNotesJob                | null                                                           | 1648471809 |   1696732817 |           0 |                  2 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
| 16226 | OCA\Mail\BackgroundJob\OutboxWorkerJob                          | null                                                           | 1696719763 |   1696719763 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
| 16227 | OCA\GroupFolders\BackgroundJob\ExpireGroupTrash                 | null                                                           | 1696716311 |   1696719763 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
| 16233 | OCA\DAV\BackgroundJob\RefreshWebcalJob                          | {"principaluri":"principals\/users\/AUsernameHereICensored","uri":"1"} | 1696719763 |   1696719763 |           0 |                542 | 6dffbf62c9024d437a597a3384ad6898 |              1 |
| 16586 | OCA\Collectives\BackgroundJob\IndexCollectives                  | null                                                           | 1696720305 |   1696720305 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
| 19588 | OC\Authentication\Token\TokenCleanupJob                         | null                                                           | 1696716311 |   1696720305 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              0 |
| 20141 | OCA\Files\BackgroundJob\DeleteExpiredOpenLocalEditor            | null                                                           | 1696680002 |   1696720305 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              0 |
| 20146 | OCA\Mail\BackgroundJob\PreviewEnhancementProcessingJob          | {"accountId":1}                                                | 1696720305 |   1696720305 |           0 |                  0 | 562423afc287d53e27bc1d34fbc41ce5 |              1 |
| 20147 | OCA\Mail\BackgroundJob\PreviewEnhancementProcessingJob          | {"accountId":2}                                                | 1696720305 |   1696720305 |           0 |                  0 | ef33fafb0b9077ce575d122c006ecdfe |              1 |
| 20148 | OCA\Mail\BackgroundJob\PreviewEnhancementProcessingJob          | {"accountId":6}                                                | 1696720305 |   1696720305 |           0 |                  0 | a24308c81fa9d50ad05d869894220cba |              1 |
| 20149 | OCA\Mail\BackgroundJob\IMipMessageJob                           | null                                                           | 1696720305 |   1696720305 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
| 20151 | OCA\Talk\BackgroundJob\ExpireChatMessages                       | null                                                           | 1696720305 |   1696720305 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
| 20639 | OCA\Collectives\BackgroundJob\ExpirePageTrash                   | null                                                           | 1696720305 |   1696720305 |           0 |                  0 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
| 20653 | OCA\Onlyoffice\Cron\EditorsCheck                                | null                                                           | 1696698902 |   1696720305 |           0 |                  2 | 37a6259cc0c1dae299a7866489dff0bd |              1 |
+-------+-----------------------------------------------------------------+----------------------------------------------------------------+------------+--------------+-------------+--------------------+----------------------------------+----------------+
80 rows in set (0.000 sec)

The time needed for the RefreshWebcalJob seems to be extremly high. There are also constantly high writes to the mariadb binlogs:

root@www01:/var/log/mysql# ls -lht
total 4.7G
-rw-rw---- 1 mysql adm  93M Oct  8 01:33 mariadb-bin.193926
-rw-rw---- 1 mysql adm 101M Oct  8 01:32 mariadb-bin.193925
-rw-rw---- 1 mysql adm 1.6K Oct  8 01:32 mariadb-bin.index
-rw-rw---- 1 mysql adm 101M Oct  8 01:31 mariadb-bin.193924
-rw-rw---- 1 mysql adm 101M Oct  8 01:30 mariadb-bin.193923
-rw-rw---- 1 mysql adm 101M Oct  8 01:30 mariadb-bin.193922
-rw-rw---- 1 mysql adm 101M Oct  8 01:29 mariadb-bin.193921
-rw-rw---- 1 mysql adm 101M Oct  8 01:28 mariadb-bin.193920
-rw-rw---- 1 mysql adm 101M Oct  8 01:27 mariadb-bin.193919
-rw-rw---- 1 mysql adm 101M Oct  8 01:26 mariadb-bin.193918
-rw-rw---- 1 mysql adm 101M Oct  8 01:25 mariadb-bin.193917
-rw-rw---- 1 mysql adm 101M Oct  8 01:25 mariadb-bin.193916
-rw-rw---- 1 mysql adm 101M Oct  8 01:24 mariadb-bin.193915
-rw-rw---- 1 mysql adm 101M Oct  8 01:23 mariadb-bin.193914
-rw-rw---- 1 mysql adm 110M Oct  8 01:22 mariadb-bin.193913
-rw-rw---- 1 mysql adm 101M Oct  8 01:22 mariadb-bin.193912
-rw-rw---- 1 mysql adm 101M Oct  8 01:21 mariadb-bin.193911
-rw-rw---- 1 mysql adm 101M Oct  8 01:20 mariadb-bin.193910
-rw-rw---- 1 mysql adm 101M Oct  8 01:19 mariadb-bin.193909
-rw-rw---- 1 mysql adm 101M Oct  8 01:18 mariadb-bin.193908
-rw-rw---- 1 mysql adm 101M Oct  8 01:17 mariadb-bin.193907
-rw-rw---- 1 mysql adm 101M Oct  8 01:16 mariadb-bin.193906
-rw-rw---- 1 mysql adm 101M Oct  8 01:15 mariadb-bin.193905
-rw-rw---- 1 mysql adm 101M Oct  8 01:14 mariadb-bin.193904
-rw-rw---- 1 mysql adm 101M Oct  8 01:13 mariadb-bin.193903
-rw-rw---- 1 mysql adm 101M Oct  8 01:11 mariadb-bin.193902
-rw-rw---- 1 mysql adm 101M Oct  8 01:10 mariadb-bin.193901
-rw-rw---- 1 mysql adm 101M Oct  8 01:10 mariadb-bin.193900
-rw-rw---- 1 mysql adm 101M Oct  8 01:09 mariadb-bin.193899
-rw-rw---- 1 mysql adm 101M Oct  8 01:03 mariadb-bin.193898

I needed to set up a cronjob that purges the old bin logs regularly to keep up with the amount of logs generated and not make the system explode instantly.

Steps to reproduce

I don't really know how to reproduce this, it just happens on my server when running the sudo -u www-data php -f /var/www/nextcloud/cron.php

Expected behavior

I would expect the cron to run in a reasonable amount of time (which it did when first setting it up, I don't know when it got worse).

Installation method

None

Nextcloud Server version

25

Operating system

None

PHP engine version

None

Web server

None

Database engine version

None

Is this bug present after an update or on a fresh install?

None

Are you using the Nextcloud Server Encryption module?

None

What user-backends are you using?

Configuration report

{
    "system": {
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "localhost",
            "nc.SomeDomainICensored.com"
        ],
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "mysql",
        "version": "25.0.12.0",
        "overwrite.cli.url": "https:\/\/nc.SomeDomainICensored.com\/",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "",
        "dbtableprefix": "oc_",
        "mysql.utf8mb4": true,
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "htaccess.RewriteBase": "\/",
        "activity_expire_days": 14,
        "auth.bruteforce.protection.enabled": true,
        "blacklisted_files": [
            ".htaccess",
            "Thumbs.db",
            "thumbs.db"
        ],
        "cron_log": true,
        "default_phone_region": "DE",
        "default_locale": "de",
        "default_language": "de",
        "enable_previews": true,
        "enabledPreviewProviders": [
            "OC\\Preview\\PNG",
            "OC\\Preview\\JPEG",
            "OC\\Preview\\GIF",
            "OC\\Preview\\BMP",
            "OC\\Preview\\XBitmap",
            "OC\\Preview\\Movie",
            "OC\\Preview\\MP3",
            "OC\\Preview\\TXT",
            "OC\\Preview\\MarkDown",
            "OC\\Preview\\OpenDocument",
            "OC\\Preview\\Krita",
            "OC\\Preview\\HEIC",
            "OC\\Preview\\TIFF"
        ],
        "preview_max_memory": 128,
        "filesystem_check_changes": 0,
        "filelocking.enabled": "true",
        "integrity.check.disabled": false,
        "knowledgebaseenabled": true,
        "logfile": "\/mnt\/storagebox_sshfs\/nextcloud_data\/nextcloud.log",
        "logtimezone": "Europe\/Berlin",
        "log_rotate_size": 104857600,
        "maintenance": false,
        "memcache.local": "\\OC\\Memcache\\APCu",
        "memcache.locking": "\\OC\\Memcache\\Redis",
        "overwriteprotocol": "https",
        "preview_max_x": 1920,
        "preview_max_y": 1200,
        "preview_max_scale_factor": 1,
        "redis": {
            "host": "***REMOVED SENSITIVE VALUE***",
            "port": 0,
            "dbindex": 0,
            "timeout": 1.5
        },
        "trashbin_retention_obligation": "auto, 14",
        "updater.release.channel": "stable",
        "trusted_proxies": "***REMOVED SENSITIVE VALUE***",
        "remember_login_cookie_lifetime": "1800",
        "simpleSignUpLink.shown": false,
        "versions_retention_obligation": "auto, 365",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpmode": "smtp",
        "mail_sendmailmode": "smtp",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "25",
        "loglevel": 1,
        "theme": "",
        "app_install_overwrite": [
            "camerarawpreviews"
        ],
        "updater.secret": "***REMOVED SENSITIVE VALUE***"
    }
}

List of activated Apps

Enabled:
  - admin_audit: 1.15.0
  - auto_groups: 1.5.2
  - calendar: 4.5.2
  - camerarawpreviews: 0.8.2
  - circles: 25.0.0
  - cloud_federation_api: 1.8.0
  - collectives: 2.8.2
  - comments: 1.15.0
  - contacts: 5.4.2
  - contactsinteraction: 1.6.0
  - dashboard: 7.5.0
  - dav: 1.24.0
  - deck: 1.8.6
  - event_update_notification: 2.2.0
  - federatedfilesharing: 1.15.0
  - federation: 1.15.0
  - files: 1.20.1
  - files_automatedtagging: 1.15.3
  - files_pdfviewer: 2.6.0
  - files_rightclick: 1.4.0
  - files_sharing: 1.17.0
  - files_trashbin: 1.15.0
  - files_versions: 1.18.0
  - firstrunwizard: 2.14.0
  - groupfolders: 13.1.6
  - imageconverter: 1.3.5
  - logreader: 2.10.0
  - lookup_server_connector: 1.13.0
  - mail: 2.2.8
  - nextcloud_announcements: 1.14.0
  - notes: 4.8.1
  - notifications: 2.13.1
  - notify_push: 0.6.3
  - oauth2: 1.13.1
  - onlyoffice: 7.9.0
  - password_policy: 1.15.0
  - polls: 5.3.2
  - privacy: 1.9.0
  - provisioning_api: 1.15.0
  - ransomware_protection: 1.14.0
  - recommendations: 1.4.0
  - related_resources: 1.0.4
  - serverinfo: 1.15.0
  - settings: 1.7.0
  - sharebymail: 1.15.0
  - side_menu: 3.10.3
  - spreed: 15.0.8
  - support: 1.8.0
  - survey_client: 1.13.0
  - systemtags: 1.15.0
  - tasks: 0.15.0
  - text: 3.6.0
  - theming: 2.0.1
  - twofactor_backupcodes: 1.14.0
  - updatenotification: 1.15.0
  - user_status: 1.5.0
  - viewer: 1.9.0
  - weather_status: 1.5.0
  - workflowengine: 2.7.0
Disabled:
  - activity: 2.15.0
  - appointments: 1.15.3
  - bookmarks: 12.1.0
  - bruteforcesettings
  - encryption
  - files_external
  - integration_google: 1.0.9
  - news: 23.0.0
  - photos: 1.5.0
  - suspicious_login
  - twofactor_totp
  - user_ldap

Nextcloud Signing status

No errors have been found.

Nextcloud Logs

No response

Additional info

No response

joshtrichards commented 1 year ago

Are you the only user or do you have other users on your server? The biggest variable that plays a role probably in this job run is driven by your environment's users' external calendar subscriptions:

https://docs.nextcloud.com/server/latest/user_manual/en/groupware/calendar.html#subscribe-to-a-calendar https://docs.nextcloud.com/server/latest/admin_manual/groupware/calendar.html#subscriptions

Do you Nextcloud logs contain any notable entries during the period of these job runs?

joshtrichards commented 1 year ago

Related enhancement request: #36849 (just noting for future reference)