[Bug]: OCA\DAV\BackgroundJob\RefreshWebcalJob takes way too long in cronjob and huge binlogs
Open
Nobody has claimed this yet.
0. Needs triage
25-feedback
bug
feature: caldav
performance 🚀
- Dominant language
- PHP
- Stars
- 36.9k
- Forks
- 5.2k
- Avg merge
- 2d 3h
- Merged PRs (30d)
- 713
Description
⚠️ This issue respects the following points: ⚠️
- This is a bug, not a question or a configuration/webserver/proxy issue.
- This issue is not already reported on Github OR Nextcloud Community Forum (I've searched it).
- Nextcloud Server is up to date. See Maintenance and Release Schedule for supported versions.
- I agree to follow Nextcloud's Code of Conduct.
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?
- Default user-backend (database)
- LDAP/ Active Directory
- SSO - SAML
- Other
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
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start at OCA\DAV\BackgroundJob\RefreshWebcalJob, then inspect its cron execution and the oc_jobs records described in the report. Profile the job with MariaDB while measuring runtime and binlog volume; done means the excessive duration and binlog generation are explained and a verified fix is covered by relevant tests.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- mariadb, php
- Domain
- backend, database, performance
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 30/100