dashboard widget not showing all calendar events

[rcsas]

Steps to reproduce

1. Open nextcloud dashboard
2. Look at the upcoming events dashboard
3. See some events displayed on it
4. Click more events
5. View the same events that are displayed in the dashboard and other previous to some that are displayed in the dashboard

Expected behavior

All events in the calendars should show in the upcoming events dashboard ordered by date

Actual behaviour

Only some events show up in the dashboard.
The missing events are not calendar specific nor recurrent specific.

Some recurrent events of a calendar show up and other recurrent events of the same calendar do not show.

Right now it shows "no more events today", two events for tomorrow and another in 5 days, although there are two events today, one more in 2 days and other two in 4 days, all from the same calendar.

Calendar app version

4.7.16

CalDAV-clients used

DAVx5, Evolution, macOS Calendar

Browser

Chrome 129

Client operating system

Windows 10

Server operating system

Docker on raspberrypi 6.1.0

Web server

Apache

Database engine version

MariaDB

PHP engine version

PHP 8.2

Nextcloud version

29.0.8

Updated from an older installed version or fresh install

Updated from an older version

List of activated apps

Enabled:

• activity: 2.21.1
• bookmarks: 14.2.6
• bruteforcesettings: 2.9.0
• calendar: 4.7.16
• cloud_federation_api: 1.12.0
• contacts: 6.0.0
• dashboard: 7.9.0
• dav: 1.30.1
• drawio: 3.0.3
• federatedfilesharing: 1.19.0
• files: 2.1.1
• files_downloadlimit: 2.0.0
• files_external: 1.21.0
• files_pdfviewer: 2.10.0
• files_reminders: 1.2.0
• files_sharing: 1.21.0
• files_trashbin: 1.19.0
• files_versions: 1.22.0
• forms: 4.3.1
• keeweb: 0.6.20
• logreader: 2.14.0
• lookup_server_connector: 1.17.0
• notes: 4.11.0
• notifications: 2.17.0
• oauth2: 1.17.1
• password_policy: 1.19.0
• phonetrack: 0.8.1
• previewgenerator: 5.6.0
• privacy: 1.13.0
• provisioning_api: 1.19.0
• qownnotesapi: 24.9.0
• recommendations: 2.1.0
• related_resources: 1.4.0
• richdocuments: 8.4.7
• serverinfo: 1.19.0
• settings: 1.12.0
• sharebymail: 1.19.0
• side_menu: 3.13.1
• support: 1.12.0
• tasks: 0.16.1
• theming: 2.4.0
• theming_customcss: 1.17.0
• twofactor_backupcodes: 1.18.0
• twofactor_totp: 11.0.0-dev
• viewer: 2.3.0
• workflowengine: 2.11.0
  Disabled:
• admin_audit: 1.19.0 (installed 1.13.0)
• circles: 29.0.0-dev (installed 23.0.1)
• cms_pico: 1.0.21 (installed 1.0.21)
• comments: 1.19.0 (installed 1.13.0)
• contactsinteraction: 1.10.0 (installed 1.4.0)
• encryption: 2.17.0
• federation: 1.19.0 (installed 1.13.0)
• files_archive: 1.2.3 (installed 1.2.3)
• files_rightclick: 0.15.1 (installed 1.6.0)
• firstrunwizard: 2.18.0 (installed 2.12.0)
• maps: 1.4.0 (installed 1.4.0)
• memories: 7.4.1 (installed 7.4.1)
• nextcloud_announcements: 1.18.0 (installed 1.12.0)
• photos: 2.5.0 (installed 2.0.1)
• polls: 7.2.4 (installed 7.2.4)
• survey_client: 1.17.0 (installed 1.11.0)
• suspicious_login: 7.0.0 (installed 4.3.0)
• systemtags: 1.19.0 (installed 1.13.0)
• text: 3.10.1 (installed 3.4.0)
• unsplash: 3.0.1 (installed 3.0.1)
• updatenotification: 1.19.1 (installed 1.13.0)
• user_ldap: 1.20.0
• user_status: 1.9.0 (installed 1.3.1)
• weather_status: 1.9.0 (installed 1.5.0)

Nextcloud configuration

{
"system": {
"htaccess.RewriteBase": "/",
"memcache.local": "\OC\Memcache\APCu",
"apps_paths": [
{
"path": "/var/www/html/apps",
"url": "/apps",
"writable": false
},
{
"path": "/var/www/html/custom_apps",
"url": "/custom_apps",
"writable": true
}
],
"memcache.distributed": "\OC\Memcache\Redis",
"memcache.locking": "\OC\Memcache\Redis",
"redis": {
"host": "REMOVED SENSITIVE VALUE",
"password": "REMOVED SENSITIVE VALUE",
"port": 6379
},
"instanceid": "REMOVED SENSITIVE VALUE",
"passwordsalt": "REMOVED SENSITIVE VALUE",
"secret": "REMOVED SENSITIVE VALUE",
"trusted_domains": [
"REMOVED SENSITIVE VALUE",
"REMOVED SENSITIVE VALUE",
"REMOVED SENSITIVE VALUE"
],
"datadirectory": "REMOVED SENSITIVE VALUE",
"dbtype": "mysql",
"version": "29.0.8.1",
"overwrite.cli.url": "http://192.168.1.10:8099",
"overwriteprotocol": "https",
"dbname": "REMOVED SENSITIVE VALUE",
"dbhost": "REMOVED SENSITIVE VALUE",
"dbport": "",
"dbtableprefix": "oc_",
"mysql.utf8mb4": true,
"dbuser": "REMOVED SENSITIVE VALUE",
"dbpassword": "REMOVED SENSITIVE VALUE",
"installed": true,
"app_install_overwrite": [
"hancomoffice",
"unsplash"
],
"loglevel": 1,
"maintenance": false,
"maintenance_window_start": 1,
"trashbin_retention_obligation": "auto, 30",
"mail_domain": "REMOVED SENSITIVE VALUE",
"mail_from_address": "REMOVED SENSITIVE VALUE",
"mail_smtpmode": "smtp",
"mail_sendmailmode": "smtp",
"mail_smtpsecure": "ssl",
"mail_smtpauthtype": "LOGIN",
"mail_smtpauth": 1,
"mail_smtphost": "REMOVED SENSITIVE VALUE",
"mail_smtpport": "465",
"mail_smtpname": "REMOVED SENSITIVE VALUE",
"mail_smtppassword": "REMOVED SENSITIVE VALUE",
"theme": "",
"default_phone_region": "PT",
"memories.exiftool": "/var/www/html/custom_apps/memories/bin-ext/exiftool-aarch64-glibc",
"memories.vod.path": "/var/www/html/custom_apps/memories/bin-ext/go-vod-aarch64",
"memories.index.path": "/Photos/Library",
"preview_max_x": 2048,
"preview_max_y": 2048,
"jpeg_quality": 60,
"preview_max_memory": 256,
"enablePreviewProviders": [
"OC\Preview\Image",
"OC\Preview\Movie",
"OC\Preview\MKV",
"OC\Preview\MP4",
"OC\Preview\AVI",
"OC\Preview\mov"
],
"enabledPreviewProviders": [
"OC\Preview\Movie",
"OC\Preview\Image"
],
"memories.vod.ffmpeg": "/usr/bin/ffmpeg",
"memories.vod.ffprobe": "/usr/bin/ffprobe",
"memories.db.triggers.fcu": true
}
}

Web server error log

No response

Log file

{"reqId":"if1C3MkFGUd2WxUgqxiE","level":0,"time":"2024-10-16T12:16:22+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT json, sync_token FROM *PREFIX*files_metadata WHERE file_id = :dcValue1","userAgent":"--","version":"29.0.8.1","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT json, sync_token FROM *PREFIX*files_metadata WHERE file_id = :dcValue1","Code":0,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":344,"function":"executeQuery","class":"OC\DB\Connection","type":"->","args":["SELECT json, sync_token FROM *PREFIX*files_metadata WHERE file_id = :dcValue1",[4973015],[1],null]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":384,"function":"executeQuery","class":"Doctrine\DBAL\Query\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\DBAL\Query\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":293,"function":"execute","class":"OC\DB\QueryBuilder\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/FilesMetadata/Service/MetadataRequestService.php","line":78,"function":"executeQuery","class":"OC\DB\QueryBuilder\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/FilesMetadata/FilesMetadataManager.php","line":141,"function":"getMetadataFromFileId","class":"OC\FilesMetadata\Service\MetadataRequestService","type":"->","args":[4973015]},{"file":"/var/www/html/core/BackgroundJobs/GenerateMetadataJob.php","line":123,"function":"getMetadata","class":"OC\FilesMetadata\FilesMetadataManager","type":"->","args":[4973015,false]},{"file":"/var/www/html/core/BackgroundJobs/GenerateMetadataJob.php","line":109,"function":"scanFolder","class":"OC\Core\BackgroundJobs\GenerateMetadataJob","type":"->","args":[["OC\Files\Node\Folder"]]},{"file":"/var/www/html/core/BackgroundJobs/GenerateMetadataJob.php","line":109,"function":"scanFolder","class":"OC\Core\BackgroundJobs\GenerateMetadataJob","type":"->","args":[["OC\Files\Node\Folder"]]},{"file":"/var/www/html/core/BackgroundJobs/GenerateMetadataJob.php","line":98,"function":"scanFolder","class":"OC\Core\BackgroundJobs\GenerateMetadataJob","type":"->","args":[["OC\Files\Node\LazyUserFolder"]]},{"file":"/var/www/html/core/BackgroundJobs/GenerateMetadataJob.php","line":84,"function":"scanFilesForUser","class":"OC\Core\BackgroundJobs\GenerateMetadataJob","type":"->","args":["teresinha"]},{"file":"/var/www/html/lib/public/BackgroundJob/Job.php","line":80,"function":"run","class":"OC\Core\BackgroundJobs\GenerateMetadataJob","type":"->","args":[null]},{"file":"/var/www/html/lib/public/BackgroundJob/TimedJob.php","line":102,"function":"start","class":"OCP\BackgroundJob\Job","type":"->","args":[["OC\BackgroundJob\JobList"]]},{"file":"/var/www/html/lib/public/BackgroundJob/TimedJob.php","line":92,"function":"start","class":"OCP\BackgroundJob\TimedJob","type":"->","args":[["OC\BackgroundJob\JobList"]]},{"file":"/var/www/html/cron.php","line":177,"function":"execute","class":"OCP\BackgroundJob\TimedJob","type":"->","args":[["OC\BackgroundJob\JobList"]]}],"File":"/var/www/html/lib/private/DB/Connection.php","Line":320,"message":"dirty table reads: SELECT json, sync_token FROM *PREFIX*files_metadata WHERE file_id = :dcValue1","tables":["oc_appconfig","oc_jobs","oc_notes_meta","oc_mounts","oc_filecache","oc_files_versions","oc_phonetrack_points","oc_calendar_appt_bookings","oc_activity","oc_direct_edit","oc_open_local_editor","oc_oauth2_access_tokens","oc_preferences","oc_directlink","oc_calendar_invitations","oc_storages_credentials","oc_calendarchanges","oc_share","oc_login_flow_v2","oc_bruteforce_attempts","oc_authtoken","oc_textprocessing_tasks","oc_text2image_tasks","oc_files_metadata"],"reads":["oc_files_metadata"],"exception":{},"CustomMessage":"dirty table reads: SELECT json, sync_token FROM *PREFIX*files_metadata WHERE file_id = :dcValue1"}}
{"reqId":"if1C3MkFGUd2WxUgqxiE","level":0,"time":"2024-10-16T12:16:22+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT json, sync_token FROM *PREFIX*files_metadata WHERE file_id = :dcValue1","userAgent":"--","version":"29.0.8.1","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT json, sync_token FROM *PREFIX*files_metadata WHERE file_id = :dcValue1","Code":0,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":344,"function":"executeQuery","class":"OC\DB\Connection","type":"->","args":["SELECT json, sync_token FROM *PREFIX*files_metadata WHERE file_id = :dcValue1",[4973015],[1],null]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":384,"function":"executeQuery","class":"Doctrine\DBAL\Query\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\DBAL\Query\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":293,"function":"execute","class":"OC\DB\QueryBuilder\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/FilesMetadata/Service/MetadataRequestService.php","line":78,"function":"executeQuery","class":"OC\DB\QueryBuilder\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/FilesMetadata/FilesMetadataManager.php","line":98,"function":"getMetadataFromFileId","class":"OC\FilesMetadata\Service\MetadataRequestService","type":"->","args":[4973015]},{"file":"/var/www/html/core/BackgroundJobs/GenerateMetadataJob.php","line":126,"function":"refreshMetadata","class":"OC\FilesMetadata\FilesMetadataManager","type":"->","args":[["OC\Files\Node\File"],3]},{"file":"/var/www/html/core/BackgroundJobs/GenerateMetadataJob.php","line":109,"function":"scanFolder","class":"OC\Core\BackgroundJobs\GenerateMetadataJob","type":"->","args":[["OC\Files\Node\Folder"]]},{"file":"/var/www/html/core/BackgroundJobs/GenerateMetadataJob.php","line":109,"function":"scanFolder","class":"OC\Core\BackgroundJobs\GenerateMetadataJob","type":"->","args":[["OC\Files\Node\Folder"]]},{"file":"/var/www/html/core/BackgroundJobs/GenerateMetadataJob.php","line":98,"function":"scanFolder","class":"OC\Core\BackgroundJobs\GenerateMetadataJob","type":"->","args":[["OC\Files\Node\LazyUserFolder"]]},{"file":"/var/www/html/core/BackgroundJobs/GenerateMetadataJob.php","line":84,"function":"scanFilesForUser","class":"OC\Core\BackgroundJobs\GenerateMetadataJob","type":"->","args":["teresinha"]},{"file":"/var/www/html/lib/public/BackgroundJob/Job.php","line":80,"function":"run","class":"OC\Core\BackgroundJobs\GenerateMetadataJob","type":"->","args":[null]},{"file":"/var/www/html/lib/public/BackgroundJob/TimedJob.php","line":102,"function":"start","class":"OCP\BackgroundJob\Job","type":"->","args":[["OC\BackgroundJob\JobList"]]},{"file":"/var/www/html/lib/public/BackgroundJob/TimedJob.php","line":92,"function":"start","class":"OCP\BackgroundJob\TimedJob","type":"->","args":[["OC\BackgroundJob\JobList"]]},{"file":"/var/www/html/cron.php","line":177,"function":"execute","class":"OCP\BackgroundJob\TimedJob","type":"->","args":[["OC\BackgroundJob\JobList"]]}],"File":"/var/www/html/lib/private/DB/Connection.php","Line":320,"message":"dirty table reads: SELECT json, sync_token FROM *PREFIX*files_metadata WHERE file_id = :dcValue1","tables":["oc_appconfig","oc_jobs","oc_notes_meta","oc_mounts","oc_filecache","oc_files_versions","oc_phonetrack_points","oc_calendar_appt_bookings","oc_activity","oc_direct_edit","oc_open_local_editor","oc_oauth2_access_tokens","oc_preferences","oc_directlink","oc_calendar_invitations","oc_storages_credentials","oc_calendarchanges","oc_share","oc_login_flow_v2","oc_bruteforce_attempts","oc_authtoken","oc_textprocessing_tasks","oc_text2image_tasks","oc_files_metadata"],"reads":["oc_files_metadata"],"exception":{},"CustomMessage":"dirty table reads: SELECT json, sync_token FROM *PREFIX*files_metadata WHERE file_id = :dcValue1"}}
{"reqId":"if1C3MkFGUd2WxUgqxiE","level":0,"time":"2024-10-16T12:16:22+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT json, sync_token FROM *PREFIX*files_metadata WHERE file_id = :dcValue1","userAgent":"--","version":"29.0.8.1","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT json, sync_token FROM *PREFIX*files_metadata WHERE file_id = :dcValue1","Code":0,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":344,"function":"executeQuery","class":"OC\DB\Connection","type":"->","args":["SELECT json, sync_token FROM *PREFIX*files_metadata WHERE file_id = :dcValue1",[4973015],[1],null]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":384,"function":"executeQuery","class":"Doctrine\DBAL\Query\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\DBAL\Query\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":293,"function":"execute","class":"OC\DB\QueryBuilder\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/FilesMetadata/Service/MetadataRequestService.php","line":78,"function":"executeQuery","class":"OC\DB\QueryBuilder\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/FilesMetadata/FilesMetadataManager.php","line":98,"function":"getMetadataFromFileId","class":"OC\FilesMetadata\Service\MetadataRequestService","type":"->","args":[4973015]},{"file":"/var/www/html/lib/private/FilesMetadata/FilesMetadataManager.php","line":121,"function":"refreshMetadata","class":"OC\FilesMetadata\FilesMetadataManager","type":"->","args":[["OC\Files\Node\File"],2]},{"file":"/var/www/html/core/BackgroundJobs/GenerateMetadataJob.php","line":126,"function":"refreshMetadata","class":"OC\FilesMetadata\FilesMetadataManager","type":"->","args":[["OC\Files\Node\File"],3]},{"file":"/var/www/html/core/BackgroundJobs/GenerateMetadataJob.php","line":109,"function":"scanFolder","class":"OC\Core\BackgroundJobs\GenerateMetadataJob","type":"->","args":[["OC\Files\Node\Folder"]]},{"file":"/var/www/html/core/BackgroundJobs/GenerateMetadataJob.php","line":109,"function":"scanFolder","class":"OC\Core\BackgroundJobs\GenerateMetadataJob","type":"->","args":[["OC\Files\Node\Folder"]]},{"file":"/var/www/html/core/BackgroundJobs/GenerateMetadataJob.php","line":98,"function":"scanFolder","class":"OC\Core\BackgroundJobs\GenerateMetadataJob","type":"->","args":[["OC\Files\Node\LazyUserFolder"]]},{"file":"/var/www/html/core/BackgroundJobs/GenerateMetadataJob.php","line":84,"function":"scanFilesForUser","class":"OC\Core\BackgroundJobs\GenerateMetadataJob","type":"->","args":["teresinha"]},{"file":"/var/www/html/lib/public/BackgroundJob/Job.php","line":80,"function":"run","class":"OC\Core\BackgroundJobs\GenerateMetadataJob","type":"->","args":[null]},{"file":"/var/www/html/lib/public/BackgroundJob/TimedJob.php","line":102,"function":"start","class":"OCP\BackgroundJob\Job","type":"->","args":[["OC\BackgroundJob\JobList"]]},{"file":"/var/www/html/lib/public/BackgroundJob/TimedJob.php","line":92,"function":"start","class":"OCP\BackgroundJob\TimedJob","type":"->","args":[["OC\BackgroundJob\JobList"]]},{"file":"/var/www/html/cron.php","line":177,"function":"execute","class":"OCP\BackgroundJob\TimedJob","type":"->","args":[["OC\BackgroundJob\JobList"]]}],"File":"/var/www/html/lib/private/DB/Connection.php","Line":320,"message":"dirty table reads: SELECT json, sync_token FROM *PREFIX*files_metadata WHERE file_id = :dcValue1","tables":["oc_appconfig","oc_jobs","oc_notes_meta","oc_mounts","oc_filecache","oc_files_versions","oc_phonetrack_points","oc_calendar_appt_bookings","oc_activity","oc_direct_edit","oc_open_local_editor","oc_oauth2_access_tokens","oc_preferences","oc_directlink","oc_calendar_invitations","oc_storages_credentials","oc_calendarchanges","oc_share","oc_login_flow_v2","oc_bruteforce_attempts","oc_authtoken","oc_textprocessing_tasks","oc_text2image_tasks","oc_files_metadata"],"reads":["oc_files_metadata"],"exception":{},"CustomMessage":"dirty table reads: SELECT json, sync_token FROM *PREFIX*files_metadata WHERE file_id = :dcValue1"}}
{"reqId":"if1C3MkFGUd2WxUgqxiE","level":0,"time":"2024-10-16T12:16:24+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT json, sync_token FROM *PREFIX*files_metadata WHERE file_id = :dcValue1","userAgent":"--","version":"29.0.8.1","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT json, sync_token FROM *PREFIX*files_metadata WHERE file_id = :dcValue1","Code":0,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":344,"function":"executeQuery","class":"OC\DB\Connection","type":"->","args":["SELECT json, sync_token FROM *PREFIX*files_metadata WHERE file_id = :dcValue1",[4995504],[1],null]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":384,"function":"executeQuery","class":"Doctrine\DBAL\Query\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\DBAL\Query\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":293,"function":"execute","class":"OC\DB\QueryBuilder\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/FilesMetadata/Service/MetadataRequestService.php","line":78,"function":"executeQuery","class":"OC\DB\QueryBuilder\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/FilesMetadata/FilesMetadataManager.php","line":141,"function":"getMetadataFromFileId","class":"OC\FilesMetadata\Service\MetadataRequestService","type":"->","args":[4995504]},{"file":"/var/www/html/core/BackgroundJobs/GenerateMetadataJob.php","line":123,"function":"getMetadata","class":"OC\FilesMetadata\FilesMetadataManager","type":"->","args":[4995504,false]},{"file":"/var/www/html/core/BackgroundJobs/GenerateMetadataJob.php","line":109,"function":"scanFolder","class":"OC\Core\BackgroundJobs\GenerateMetadataJob","type":"->","args":[["OC\Files\Node\Folder"]]},{"file":"/var/www/html/core/BackgroundJobs/GenerateMetadataJob.php","line":109,"function":"scanFolder","class":"OC\Core\BackgroundJobs\GenerateMetadataJob","type":"->","args":[["OC\Files\Node\Folder"]]},{"file":"/var/www/html/core/BackgroundJobs/GenerateMetadataJob.php","line":98,"function":"scanFolder","class":"OC\Core\BackgroundJobs\GenerateMetadataJob","type":"->","args":[["OC\Files\Node\LazyUserFolder"]]},{"file":"/var/www/html/core/BackgroundJobs/GenerateMetadataJob.php","line":84,"function":"scanFilesForUser","class":"OC\Core\BackgroundJobs\GenerateMetadataJob","type":"->","args":["teresinha"]},{"file":"/var/www/html/lib/public/BackgroundJob/Job.php","line":80,"function":"run","class":"OC\Core\BackgroundJobs\GenerateMetadataJob","type":"->","args":[null]},{"file":"/var/www/html/lib/public/BackgroundJob/TimedJob.php","line":102,"function":"start","class":"OCP\BackgroundJob\Job","type":"->","args":[["OC\BackgroundJob\JobList"]]},{"file":"/var/www/html/lib/public/BackgroundJob/TimedJob.php","line":92,"function":"start","class":"OCP\BackgroundJob\TimedJob","type":"->","args":[["OC\BackgroundJob\JobList"]]},{"file":"/var/www/html/cron.php","line":177,"function":"execute","class":"OCP\BackgroundJob\TimedJob","type":"->","args":[["OC\BackgroundJob\JobList"]]}],"File":"/var/www/html/lib/private/DB/Connection.php","Line":320,"message":"dirty table reads: SELECT json, sync_token FROM *PREFIX*files_metadata WHERE file_id = :dcValue1","tables":["oc_appconfig","oc_jobs","oc_notes_meta","oc_mounts","oc_filecache","oc_files_versions","oc_phonetrack_points","oc_calendar_appt_bookings","oc_activity","oc_direct_edit","oc_open_local_editor","oc_oauth2_access_tokens","oc_preferences","oc_directlink","oc_calendar_invitations","oc_storages_credentials","oc_calendarchanges","oc_share","oc_login_flow_v2","oc_bruteforce_attempts","oc_authtoken","oc_textprocessing_tasks","oc_text2image_tasks","oc_files_metadata"],"reads":["oc_files_metadata"],"exception":{},"CustomMessage":"dirty table reads: SELECT json, sync_token FROM *PREFIX*files_metadata WHERE file_id = :dcValue1"}}
{"reqId":"if1C3MkFGUd2WxUgqxiE","level":0,"time":"2024-10-16T12:16:24+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT json, sync_token FROM *PREFIX*files_metadata WHERE file_id = :dcValue1","userAgent":"--","version":"29.0.8.1","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT json, sync_token FROM *PREFIX*files_metadata WHERE file_id = :dcValue1","Code":0,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":344,"function":"executeQuery","class":"OC\DB\Connection","type":"->","args":["SELECT json, sync_token FROM *PREFIX*files_metadata WHERE file_id = :dcValue1",[4995504],[1],null]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":384,"function":"executeQuery","class":"Doctrine\DBAL\Query\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\DBAL\Query\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":293,"function":"execute","class":"OC\DB\QueryBuilder\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/FilesMetadata/Service/MetadataRequestService.php","line":78,"function":"executeQuery","class":"OC\DB\QueryBuilder\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/FilesMetadata/FilesMetadataManager.php","line":98,"function":"getMetadataFromFileId","class":"OC\FilesMetadata\Service\MetadataRequestService","type":"->","args":[4995504]},{"file":"/var/www/html/core/BackgroundJobs/GenerateMetadataJob.php","line":126,"function":"refreshMetadata","class":"OC\FilesMetadata\FilesMetadataManager","type":"->","args":[["OC\Files\Node\File"],3]},{"file":"/var/www/html/core/BackgroundJobs/GenerateMetadataJob.php","line":109,"function":"scanFolder","class":"OC\Core\BackgroundJobs\GenerateMetadataJob","type":"->","args":[["OC\Files\Node\Folder"]]},{"file":"/var/www/html/core/BackgroundJobs/GenerateMetadataJob.php","line":109,"function":"scanFolder","class":"OC\Core\BackgroundJobs\GenerateMetadataJob","type":"->","args":[["OC\Files\Node\Folder"]]},{"file":"/var/www/html/core/BackgroundJobs/GenerateMetadataJob.php","line":98,"function":"scanFolder","class":"OC\Core\BackgroundJobs\GenerateMetadataJob","type":"->","args":[["OC\Files\Node\LazyUserFolder"]]},{"file":"/var/www/html/core/BackgroundJobs/GenerateMetadataJob.php","line":84,"function":"scanFilesForUser","class":"OC\Core\BackgroundJobs\GenerateMetadataJob","type":"->","args":["teresinha"]},{"file":"/var/www/html/lib/public/BackgroundJob/Job.php","line":80,"function":"run","class":"OC\Core\BackgroundJobs\GenerateMetadataJob","type":"->","args":[null]},{"file":"/var/www/html/lib/public/BackgroundJob/TimedJob.php","line":102,"function":"start","class":"OCP\BackgroundJob\Job","type":"->","args":[["OC\BackgroundJob\JobList"]]},{"file":"/var/www/html/lib/public/BackgroundJob/TimedJob.php","line":92,"function":"start","class":"OCP\BackgroundJob\TimedJob","type":"->","args":[["OC\BackgroundJob\JobList"]]},{"file":"/var/www/html/cron.php","line":177,"function":"execute","class":"OCP\BackgroundJob\TimedJob","type":"->","args":[["OC\BackgroundJob\JobList"]]}],"File":"/var/www/html/lib/private/DB/Connection.php","Line":320,"message":"dirty table reads: SELECT json, sync_token FROM *PREFIX*files_metadata WHERE file_id = :dcValue1","tables":["oc_appconfig","oc_jobs","oc_notes_meta","oc_mounts","oc_filecache","oc_files_versions","oc_phonetrack_points","oc_calendar_appt_bookings","oc_activity","oc_direct_edit","oc_open_local_editor","oc_oauth2_access_tokens","oc_preferences","oc_directlink","oc_calendar_invitations","oc_storages_credentials","oc_calendarchanges","oc_share","oc_login_flow_v2","oc_bruteforce_attempts","oc_authtoken","oc_textprocessing_tasks","oc_text2image_tasks","oc_files_metadata"],"reads":["oc_files_metadata"],"exception":{},"CustomMessage":"dirty table reads: SELECT json, sync_token FROM *PREFIX*files_metadata WHERE file_id = :dcValue1"}}
{"reqId":"if1C3MkFGUd2WxUgqxiE","level":0,"time":"2024-10-16T12:16:24+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT json, sync_token FROM *PREFIX*files_metadata WHERE file_id = :dcValue1","userAgent":"--","version":"29.0.8.1","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT json, sync_token FROM *PREFIX*files_metadata WHERE file_id = :dcValue1","Code":0,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":344,"function":"executeQuery","class":"OC\DB\Connection","type":"->","args":["SELECT json, sync_token FROM *PREFIX*files_metadata WHERE file_id = :dcValue1",[4995504],[1],null]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":384,"function":"executeQuery","class":"Doctrine\DBAL\Query\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\DBAL\Query\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":293,"function":"execute","class":"OC\DB\QueryBuilder\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/FilesMetadata/Service/MetadataRequestService.php","line":78,"function":"executeQuery","class":"OC\DB\QueryBuilder\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/FilesMetadata/FilesMetadataManager.php","line":98,"function":"getMetadataFromFileId","class":"OC\FilesMetadata\Service\MetadataRequestService","type":"->","args":[4995504]},{"file":"/var/www/html/lib/private/FilesMetadata/FilesMetadataManager.php","line":121,"function":"refreshMetadata","class":"OC\FilesMetadata\FilesMetadataManager","type":"->","args":[["OC\Files\Node\File"],2]},{"file":"/var/www/html/core/BackgroundJobs/GenerateMetadataJob.php","line":126,"function":"refreshMetadata","class":"OC\FilesMetadata\FilesMetadataManager","type":"->","args":[["OC\Files\Node\File"],3]},{"file":"/var/www/html/core/BackgroundJobs/GenerateMetadataJob.php","line":109,"function":"scanFolder","class":"OC\Core\BackgroundJobs\GenerateMetadataJob","type":"->","args":[["OC\Files\Node\Folder"]]},{"file":"/var/www/html/core/BackgroundJobs/GenerateMetadataJob.php","line":109,"function":"scanFolder","class":"OC\Core\BackgroundJobs\GenerateMetadataJob","type":"->","args":[["OC\Files\Node\Folder"]]},{"file":"/var/www/html/core/BackgroundJobs/GenerateMetadataJob.php","line":98,"function":"scanFolder","class":"OC\Core\BackgroundJobs\GenerateMetadataJob","type":"->","args":[["OC\Files\Node\LazyUserFolder"]]},{"file":"/var/www/html/core/BackgroundJobs/GenerateMetadataJob.php","line":84,"function":"scanFilesForUser","class":"OC\Core\BackgroundJobs\GenerateMetadataJob","type":"->","args":["teresinha"]},{"file":"/var/www/html/lib/public/BackgroundJob/Job.php","line":80,"function":"run","class":"OC\Core\BackgroundJobs\GenerateMetadataJob","type":"->","args":[null]},{"file":"/var/www/html/lib/public/BackgroundJob/TimedJob.php","line":102,"function":"start","class":"OCP\BackgroundJob\Job","type":"->","args":[["OC\BackgroundJob\JobList"]]},{"file":"/var/www/html/lib/public/BackgroundJob/TimedJob.php","line":92,"function":"start","class":"OCP\BackgroundJob\TimedJob","type":"->","args":[["OC\BackgroundJob\JobList"]]},{"file":"/var/www/html/cron.php","line":177,"function":"execute","class":"OCP\BackgroundJob\TimedJob","type":"->","args":[["OC\BackgroundJob\JobList"]]}],"File":"/var/www/html/lib/private/DB/Connection.php","Line":320,"message":"dirty table reads: SELECT json, sync_token FROM *PREFIX*files_metadata WHERE file_id = :dcValue1","tables":["oc_appconfig","oc_jobs","oc_notes_meta","oc_mounts","oc_filecache","oc_files_versions","oc_phonetrack_points","oc_calendar_appt_bookings","oc_activity","oc_direct_edit","oc_open_local_editor","oc_oauth2_access_tokens","oc_preferences","oc_directlink","oc_calendar_invitations","oc_storages_credentials","oc_calendarchanges","oc_share","oc_login_flow_v2","oc_bruteforce_attempts","oc_authtoken","oc_textprocessing_tasks","oc_text2image_tasks","oc_files_metadata"],"reads":["oc_files_metadata"],"exception":{},"CustomMessage":"dirty table reads: SELECT json, sync_token FROM *PREFIX*files_metadata WHERE file_id = :dcValue1"}}
{"reqId":"if1C3MkFGUd2WxUgqxiE","level":0,"time":"2024-10-16T12:16:26+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT json, sync_token FROM *PREFIX*files_metadata WHERE file_id = :dcValue1","userAgent":"--","version":"29.0.8.1","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT json, sync_token FROM *PREFIX*files_metadata WHERE file_id = :dcValue1","Code":0,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":344,"function":"executeQuery","class":"OC\DB\Connection","type":"->","args":["SELECT json, sync_token FROM *PREFIX*files_metadata WHERE file_id = :dcValue1",[4990760],[1],null]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":384,"function":"executeQuery","class":"Doctrine\DBAL\Query\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\DBAL\Query\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":293,"function":"execute","class":"OC\DB\QueryBuilder\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/FilesMetadata/Service/MetadataRequestService.php","line":78,"function":"executeQuery","class":"OC\DB\QueryBuilder\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/FilesMetadata/FilesMetadataManager.php","line":141,"function":"getMetadataFromFileId","class":"OC\FilesMetadata\Service\MetadataRequestService","type":"->","args":[4990760]},{"file":"/var/www/html/core/BackgroundJobs/GenerateMetadataJob.php","line":123,"function":"getMetadata","class":"OC\FilesMetadata\FilesMetadataManager","type":"->","args":[4990760,false]},{"file":"/var/www/html/core/BackgroundJobs/GenerateMetadataJob.php","line":109,"function":"scanFolder","class":"OC\Core\BackgroundJobs\GenerateMetadataJob","type":"->","args":[["OC\Files\Node\Folder"]]},{"file":"/var/www/html/core/BackgroundJobs/GenerateMetadataJob.php","line":109,"function":"scanFolder","class":"OC\Core\BackgroundJobs\GenerateMetadataJob","type":"->","args":[["OC\Files\Node\Folder"]]},{"file":"/var/www/html/core/BackgroundJobs/GenerateMetadataJob.php","line":98,"function":"scanFolder","class":"OC\Core\BackgroundJobs\GenerateMetadataJob","type":"->","args":[["OC\Files\Node\LazyUserFolder"]]},{"file":"/var/www/html/core/BackgroundJobs/GenerateMetadataJob.php","line":84,"function":"scanFilesForUser","class":"OC\Core\BackgroundJobs\GenerateMetadataJob","type":"->","args":["teresinha"]},{"file":"/var/www/html/lib/public/BackgroundJob/Job.php","line":80,"function":"run","class":"OC\Core\BackgroundJobs\GenerateMetadataJob","type":"->","args":[null]},{"file":"/var/www/html/lib/public/BackgroundJob/TimedJob.php","line":102,"function":"start","class":"OCP\BackgroundJob\Job","type":"->","args":[["OC\BackgroundJob\JobList"]]},{"file":"/var/www/html/lib/public/BackgroundJob/TimedJob.php","line":92,"function":"start","class":"OCP\BackgroundJob\TimedJob","type":"->","args":[["OC\BackgroundJob\JobList"]]},{"file":"/var/www/html/cron.php","line":177,"function":"execute","class":"OCP\BackgroundJob\TimedJob","type":"->","args":[["OC\BackgroundJob\JobList"]]}],"File":"/var/www/html/lib/private/DB/Connection.php","Line":320,"message":"dirty table reads: SELECT json, sync_token FROM *PREFIX*files_metadata WHERE file_id = :dcValue1","tables":["oc_appconfig","oc_jobs","oc_notes_meta","oc_mounts","oc_filecache","oc_files_versions","oc_phonetrack_points","oc_calendar_appt_bookings","oc_activity","oc_direct_edit","oc_open_local_editor","oc_oauth2_access_tokens","oc_preferences","oc_directlink","oc_calendar_invitations","oc_storages_credentials","oc_calendarchanges","oc_share","oc_login_flow_v2","oc_bruteforce_attempts","oc_authtoken","oc_textprocessing_tasks","oc_text2image_tasks","oc_files_metadata"],"reads":["oc_files_metadata"],"exception":{},"CustomMessage":"dirty table reads: SELECT json, sync_token FROM *PREFIX*files_metadata WHERE file_id = :dcValue1"}}
{"reqId":"if1C3MkFGUd2WxUgqxiE","level":0,"time":"2024-10-16T12:16:26+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT json, sync_token FROM *PREFIX*files_metadata WHERE file_id = :dcValue1","userAgent":"--","version":"29.0.8.1","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT json, sync_token FROM *PREFIX*files_metadata WHERE file_id = :dcValue1","Code":0,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":344,"function":"executeQuery","class":"OC\DB\Connection","type":"->","args":["SELECT json, sync_token FROM *PREFIX*files_metadata WHERE file_id = :dcValue1",[4990760],[1],null]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":384,"function":"executeQuery","class":"Doctrine\DBAL\Query\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\DBAL\Query\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":293,"function":"execute","class":"OC\DB\QueryBuilder\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/FilesMetadata/Service/MetadataRequestService.php","line":78,"function":"executeQuery","class":"OC\DB\QueryBuilder\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/FilesMetadata/FilesMetadataManager.php","line":98,"function":"getMetadataFromFileId","class":"OC\FilesMetadata\Service\MetadataRequestService","type":"->","args":[4990760]},{"file":"/var/www/html/core/BackgroundJobs/GenerateMetadataJob.php","line":126,"function":"refreshMetadata","class":"OC\FilesMetadata\FilesMetadataManager","type":"->","args":[["OC\Files\Node\File"],3]},{"file":"/var/www/html/core/BackgroundJobs/GenerateMetadataJob.php","line":109,"function":"scanFolder","class":"OC\Core\BackgroundJobs\GenerateMetadataJob","type":"->","args":[["OC\Files\Node\Folder"]]},{"file":"/var/www/html/core/BackgroundJobs/GenerateMetadataJob.php","line":109,"function":"scanFolder","class":"OC\Core\BackgroundJobs\GenerateMetadataJob","type":"->","args":[["OC\Files\Node\Folder"]]},{"file":"/var/www/html/core/BackgroundJobs/GenerateMetadataJob.php","line":98,"function":"scanFolder","class":"OC\Core\BackgroundJobs\GenerateMetadataJob","type":"->","args":[["OC\Files\Node\LazyUserFolder"]]},{"file":"/var/www/html/core/BackgroundJobs/GenerateMetadataJob.php","line":84,"function":"scanFilesForUser","class":"OC\Core\BackgroundJobs\GenerateMetadataJob","type":"->","args":["teresinha"]},{"file":"/var/www/html/lib/public/BackgroundJob/Job.php","line":80,"function":"run","class":"OC\Core\BackgroundJobs\GenerateMetadataJob","type":"->","args":[null]},{"file":"/var/www/html/lib/public/BackgroundJob/TimedJob.php","line":102,"function":"start","class":"OCP\BackgroundJob\Job","type":"->","args":[["OC\BackgroundJob\JobList"]]},{"file":"/var/www/html/lib/public/BackgroundJob/TimedJob.php","line":92,"function":"start","class":"OCP\BackgroundJob\TimedJob","type":"->","args":[["OC\BackgroundJob\JobList"]]},{"file":"/var/www/html/cron.php","line":177,"function":"execute","class":"OCP\BackgroundJob\TimedJob","type":"->","args":[["OC\BackgroundJob\JobList"]]}],"File":"/var/www/html/lib/private/DB/Connection.php","Line":320,"message":"dirty table reads: SELECT json, sync_token FROM *PREFIX*files_metadata WHERE file_id = :dcValue1","tables":["oc_appconfig","oc_jobs","oc_notes_meta","oc_mounts","oc_filecache","oc_files_versions","oc_phonetrack_points","oc_calendar_appt_bookings","oc_activity","oc_direct_edit","oc_open_local_editor","oc_oauth2_access_tokens","oc_preferences","oc_directlink","oc_calendar_invitations","oc_storages_credentials","oc_calendarchanges","oc_share","oc_login_flow_v2","oc_bruteforce_attempts","oc_authtoken","oc_textprocessing_tasks","oc_text2image_tasks","oc_files_metadata"],"reads":["oc_files_metadata"],"exception":{},"CustomMessage":"dirty table reads: SELECT json, sync_token FROM *PREFIX*files_metadata WHERE file_id = :dcValue1"}}
{"reqId":"if1C3MkFGUd2WxUgqxiE","level":0,"time":"2024-10-16T12:16:26+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT json, sync_token FROM *PREFIX*files_metadata WHERE file_id = :dcValue1","userAgent":"--","version":"29.0.8.1","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT json, sync_token FROM *PREFIX*files_metadata WHERE file_id = :dcValue1","Code":0,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":344,"function":"executeQuery","class":"OC\DB\Connection","type":"->","args":["SELECT json, sync_token FROM *PREFIX*files_metadata WHERE file_id = :dcValue1",[4990760],[1],null]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":384,"function":"executeQuery","class":"Doctrine\DBAL\Query\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\DBAL\Query\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":293,"function":"execute","class":"OC\DB\QueryBuilder\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/FilesMetadata/Service/MetadataRequestService.php","line":78,"function":"executeQuery","class":"OC\DB\QueryBuilder\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/FilesMetadata/FilesMetadataManager.php","line":98,"function":"getMetadataFromFileId","class":"OC\FilesMetadata\Service\MetadataRequestService","type":"->","args":[4990760]},{"file":"/var/www/html/lib/private/FilesMetadata/FilesMetadataManager.php","line":121,"function":"refreshMetadata","class":"OC\FilesMetadata\FilesMetadataManager","type":"->","args":[["OC\Files\Node\File"],2]},{"file":"/var/www/html/core/BackgroundJobs/GenerateMetadataJob.php","line":126,"function":"refreshMetadata","class":"OC\FilesMetadata\FilesMetadataManager","type":"->","args":[["OC\Files\Node\File"],3]},{"file":"/var/www/html/core/BackgroundJobs/GenerateMetadataJob.php","line":109,"function":"scanFolder","class":"OC\Core\BackgroundJobs\GenerateMetadataJob","type":"->","args":[["OC\Files\Node\Folder"]]},{"file":"/var/www/html/core/BackgroundJobs/GenerateMetadataJob.php","line":109,"function":"scanFolder","class":"OC\Core\BackgroundJobs\GenerateMetadataJob","type":"->","args":[["OC\Files\Node\Folder"]]},{"file":"/var/www/html/core/BackgroundJobs/GenerateMetadataJob.php","line":98,"function":"scanFolder","class":"OC\Core\BackgroundJobs\GenerateMetadataJob","type":"->","args":[["OC\Files\Node\LazyUserFolder"]]},{"file":"/var/www/html/core/BackgroundJobs/GenerateMetadataJob.php","line":84,"function":"scanFilesForUser","class":"OC\Core\BackgroundJobs\GenerateMetadataJob","type":"->","args":["teresinha"]},{"file":"/var/www/html/lib/public/BackgroundJob/Job.php","line":80,"function":"run","class":"OC\Core\BackgroundJobs\GenerateMetadataJob","type":"->","args":[null]},{"file":"/var/www/html/lib/public/BackgroundJob/TimedJob.php","line":102,"function":"start","class":"OCP\BackgroundJob\Job","type":"->","args":[["OC\BackgroundJob\JobList"]]},{"file":"/var/www/html/lib/public/BackgroundJob/TimedJob.php","line":92,"function":"start","class":"OCP\BackgroundJob\TimedJob","type":"->","args":[["OC\BackgroundJob\JobList"]]},{"file":"/var/www/html/cron.php","line":177,"function":"execute","class":"OCP\BackgroundJob\TimedJob","type":"->","args":[["OC\BackgroundJob\JobList"]]}],"File":"/var/www/html/lib/private/DB/Connection.php","Line":320,"message":"dirty table reads: SELECT json, sync_token FROM *PREFIX*files_metadata WHERE file_id = :dcValue1","tables":["oc_appconfig","oc_jobs","oc_notes_meta","oc_mounts","oc_filecache","oc_files_versions","oc_phonetrack_points","oc_calendar_appt_bookings","oc_activity","oc_direct_edit","oc_open_local_editor","oc_oauth2_access_tokens","oc_preferences","oc_directlink","oc_calendar_invitations","oc_storages_credentials","oc_calendarchanges","oc_share","oc_login_flow_v2","oc_bruteforce_attempts","oc_authtoken","oc_textprocessing_tasks","oc_text2image_tasks","oc_files_metadata"],"reads":["oc_files_metadata"],"exception":{},"CustomMessage":"dirty table reads: SELECT json, sync_token FROM *PREFIX*files_metadata WHERE file_id = :dcValue1"}}

Browser log

No response

Additional info

On nextcloud 27, downgrading the calendar app to version 4.4.5 as sugested in #5563 (comment) worked fine.

Since upgrading to nextcloud 29, the downgrade is no longer possible because nextcloud complains that it is not compatible and forces the upgrade

[ralfbgithub]

Same issue with Nextcloud 30.0.4 and Calendar 5.0.8

[ralfbgithub]

Still an issue with Nextcloud 30.0.46and Calendar 5.1.2
Any update?

[rcsas]

I'm a developer, and although I don't program in php, I've looked at the CalendarWidget.php, and tweaked with the $limit and in $TwoWeeks variables in the getItems function with varying results.

It seems to me that the calendar search is truncating the results using the $limit variable, without prior ordering, resulting in discarding more recent events and not showing them in the widget.

Increasing the $limit solves the problem but I don't think that is the best approach to fixing this.
It seems to me that ordering the events by date when filtering using the search function is more appropriate, which avoids loading more than 7 items per calendar, and doesn't discard more recent events.

Unfortunately I don't develop for web neither I have the knowledge to develop the approach I've just mentioned, I don't even know where the calendar search function is defined or if supports ordering.

If someone has the knowledge and availability, at least the analysis is already made.

[kesselb]

Hi @rcsas,

Thanks for your detailed bug report 👍

Your educated guess is correct. We added the ORDER BY primary id a while back to ensure more consistent search results: CalDavBackend.php#L2082-L2084.

The meta issue #53002 contains more information. I assume we will change the ordering to use firstoccurrence.

[beccon4]

I run NC 31.0.8 and Dashboard 7.11.0 - and it is still the same.

[isZYKerman]

Still the same. With NC 32.0.2, Calendar 6.1.0 and Dashboard 7.12.0.
This is a really silly bug for it always makes me to click into the calendar app just to ensure there is REALLY no more classes today. Will it be fixed in a somehow near future?