Hi, my log file is massive and it’s full of these “no app in context” lines, literally thousands of them, every few minutes.
I am running 29.0.5 in docker on unraid.
Example of some of the log lines:
{"reqId":"7jCh5ToXQLaHpfq2Igua","level":1,"time":"2024-08-24T10:00:01+00:00","remoteAddr":"","user":"--","app":"OC\\Log\\Rotate","method":"","url":"--","message":"Log file \"/data/nextcloud.log\" was over 104857600 bytes, moved to \"/data/nextcloud.log.1\"","userAgent":"--","version":"29.0.5.1","data":{"app":"OC\\Log\\Rotate"}}
{"reqId":"7jCh5ToXQLaHpfq2Igua","level":0,"time":"2024-08-24T10:00:01+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Finished job OC\\Log\\Rotate (id: 15, arguments: null) in 0 seconds","userAgent":"--","version":"29.0.5.1","data":{"app":"cron"}}
{"reqId":"7jCh5ToXQLaHpfq2Igua","level":0,"time":"2024-08-24T10:00:01+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3) ORDER BY `last_checked` ASC LIMIT 1","userAgent":"--","version":"29.0.5.1","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3) ORDER BY `last_checked` ASC LIMIT 1","Code":0,"Trace":[{"file":"/app/www/public/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":344,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/app/www/public/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":384,"function":"executeQuery","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->"},{"file":"/app/www/public/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->"},{"file":"/app/www/public/lib/private/DB/QueryBuilder/QueryBuilder.php","line":293,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/app/www/public/lib/private/BackgroundJob/JobList.php","line":230,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/app/www/public/cron.php","line":163,"function":"getNext","class":"OC\\BackgroundJob\\JobList","type":"->"}],"File":"/app/www/public/lib/private/DB/Connection.php","Line":320,"message":"dirty table reads: SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3) ORDER BY `last_checked` ASC LIMIT 1","tables":["oc_appconfig","oc_jobs"],"reads":["oc_jobs"],"exception":{},"CustomMessage":"dirty table reads: SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3) ORDER BY `last_checked` ASC LIMIT 1"}}
{"reqId":"7jCh5ToXQLaHpfq2Igua","level":0,"time":"2024-08-24T10:00:01+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"CLI cron call has selected job OCA\\Survey_Client\\BackgroundJobs\\MonthlyReport (id: 17, arguments: null)","userAgent":"--","version":"29.0.5.1","data":{"app":"cron"}}
{"reqId":"7jCh5ToXQLaHpfq2Igua","level":0,"time":"2024-08-24T10:00:01+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3) ORDER BY `last_checked` ASC LIMIT 1","userAgent":"--","version":"29.0.5.1","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3) ORDER BY `last_checked` ASC LIMIT 1","Code":0,"Trace":[{"file":"/app/www/public/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":344,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/app/www/public/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":384,"function":"executeQuery","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->"},{"file":"/app/www/public/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->"},{"file":"/app/www/public/lib/private/DB/QueryBuilder/QueryBuilder.php","line":293,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/app/www/public/lib/private/BackgroundJob/JobList.php","line":230,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/app/www/public/cron.php","line":163,"function":"getNext","class":"OC\\BackgroundJob\\JobList","type":"->"}],"File":"/app/www/public/lib/private/DB/Connection.php","Line":320,"message":"dirty table reads: SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3) ORDER BY `last_checked` ASC LIMIT 1","tables":["oc_appconfig","oc_jobs"],"reads":["oc_jobs"],"exception":{},"CustomMessage":"dirty table reads: SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3) ORDER BY `last_checked` ASC LIMIT 1"}}
and some more:
{"reqId":"cCpCH29UGdorqUIP4c5U","level":0,"time":"2024-08-25T12:45:26+00:00","remoteAddr":"10.1.12.144","user":"timothy","app":"no app in context","method":"PROPFIND","url":"/remote.php/dav/files/timothy/Photography","message":"dirty table reads: SELECT * FROM `*PREFIX*share` `s` INNER JOIN `*PREFIX*filecache` `f` ON `s`.`file_source` = `f`.`fileid` WHERE ((`item_type` = :dcValue1) OR (`item_type` = :dcValue2)) AND (`share_type` = :dcValue3) AND ((`uid_owner` = :dcValue4) OR (`uid_initiator` = :dcValue5)) AND (`f`.`storage` = :dcValue6) AND (`f`.`parent` = :dcValue7) ORDER BY `id` ASC","userAgent":"Mozilla/5.0 (Windows) mirall/3.13.23.12-Win64 (build 20240708) (Nextcloud, windows-10.0.22621 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"29.0.5.1","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT * FROM `*PREFIX*share` `s` INNER JOIN `*PREFIX*filecache` `f` ON `s`.`file_source` = `f`.`fileid` WHERE ((`item_type` = :dcValue1) OR (`item_type` = :dcValue2)) AND (`share_type` = :dcValue3) AND ((`uid_owner` = :dcValue4) OR (`uid_initiator` = :dcValue5)) AND (`f`.`storage` = :dcValue6) AND (`f`.`parent` = :dcValue7) ORDER BY `id` ASC","Code":0,"Trace":[{"file":"/app/www/public/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":344,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/app/www/public/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":384,"function":"executeQuery","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->"},{"file":"/app/www/public/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->"},{"file":"/app/www/public/lib/private/DB/QueryBuilder/QueryBuilder.php","line":293,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/config/www/nextcloud/apps/sharebymail/lib/ShareByMailProvider.php","line":1081,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/app/www/public/lib/private/Share20/Manager.php","line":1237,"function":"getSharesInFolder","class":"OCA\\ShareByMail\\ShareByMailProvider","type":"->"},{"function":"OC\\Share20\\{closure}","class":"OC\\Share20\\Manager","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/app/www/public/lib/private/Share20/Manager.php","line":1236,"function":"array_reduce"},{"file":"/config/www/nextcloud/apps/dav/lib/Connector/Sabre/SharesPlugin.php","line":142,"function":"getSharesInFolder","class":"OC\\Share20\\Manager","type":"->"},{"file":"/config/www/nextcloud/apps/dav/lib/Connector/Sabre/SharesPlugin.php","line":206,"function":"getSharesFolder","class":"OCA\\DAV\\Connector\\Sabre\\SharesPlugin","type":"->"},{"file":"/app/www/public/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"handleGetProperties","class":"OCA\\DAV\\Connector\\Sabre\\SharesPlugin","type":"->"},{"file":"/app/www/public/3rdparty/sabre/dav/lib/DAV/Server.php","line":1052,"function":"emit","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/app/www/public/3rdparty/sabre/dav/lib/DAV/Server.php","line":984,"function":"getPropertiesByNode","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/app/www/public/3rdparty/sabre/dav/lib/DAV/Server.php","line":1662,"function":"getPropertiesIteratorForPath","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/app/www/public/3rdparty/sabre/dav/lib/DAV/Server.php","line":1647,"function":"writeMultiStatus","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/app/www/public/3rdparty/sabre/dav/lib/DAV/CorePlugin.php","line":346,"function":"generateMultiStatus","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/app/www/public/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"httpPropFind","class":"Sabre\\DAV\\CorePlugin","type":"->"},{"file":"/app/www/public/3rdparty/sabre/dav/lib/DAV/Server.php","line":472,"function":"emit","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/app/www/public/3rdparty/sabre/dav/lib/DAV/Server.php","line":253,"function":"invokeMethod","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/app/www/public/3rdparty/sabre/dav/lib/DAV/Server.php","line":321,"function":"start","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/config/www/nextcloud/apps/dav/lib/Server.php","line":385,"function":"exec","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/config/www/nextcloud/apps/dav/appinfo/v2/remote.php","line":35,"function":"exec","class":"OCA\\DAV\\Server","type":"->"},{"file":"/app/www/public/remote.php","line":172,"args":["/config/www/nextcloud/apps/dav/appinfo/v2/remote.php"],"function":"require_once"}],"File":"/app/www/public/lib/private/DB/Connection.php","Line":320,"message":"dirty table reads: SELECT * FROM `*PREFIX*share` `s` INNER JOIN `*PREFIX*filecache` `f` ON `s`.`file_source` = `f`.`fileid` WHERE ((`item_type` = :dcValue1) OR (`item_type` = :dcValue2)) AND (`share_type` = :dcValue3) AND ((`uid_owner` = :dcValue4) OR (`uid_initiator` = :dcValue5)) AND (`f`.`storage` = :dcValue6) AND (`f`.`parent` = :dcValue7) ORDER BY `id` ASC","tables":["oc_filecache"],"reads":["oc_share","oc_filecache"],"exception":{},"CustomMessage":"dirty table reads: SELECT * FROM `*PREFIX*share` `s` INNER JOIN `*PREFIX*filecache` `f` ON `s`.`file_source` = `f`.`fileid` WHERE ((`item_type` = :dcValue1) OR (`item_type` = :dcValue2)) AND (`share_type` = :dcValue3) AND ((`uid_owner` = :dcValue4) OR (`uid_initiator` = :dcValue5)) AND (`f`.`storage` = :dcValue6) AND (`f`.`parent` = :dcValue7) ORDER BY `id` ASC"}}
{"reqId":"cCpCH29UGdorqUIP4c5U","level":0,"time":"2024-08-25T12:45:26+00:00","remoteAddr":"10.1.12.144","user":"timothy","app":"no app in context","method":"PROPFIND","url":"/remote.php/dav/files/timothy/Photography","message":"dirty table reads: SELECT `sh`.`id`, `sh`.`share_type`, `sh`.`share_with`, `sh`.`uid_owner`, `sh`.`uid_initiator`, `sh`.`parent`, `sh`.`item_type`, `sh`.`item_source`, `sh`.`item_target`, `sh`.`file_source`, `sh`.`file_target`, `sh`.`permissions`, `sh`.`attributes`, `sh`.`stime`, `sh`.`accepted`, `sh`.`expiration`, `sh`.`token`, `sh`.`mail_send`, `sh_cc_wn`.`circle_id` AS `sh_cc_wn_circle_id`, `sh_cc_wn`.`member_id` AS `sh_cc_wn_member_id`, `sh_cc_wn`.`single_id` AS `sh_cc_wn_single_id`, `sh_cc_wn`.`user_id` AS `sh_cc_wn_user_id`, `sh_cc_wn`.`instance` AS `sh_cc_wn_instance`, `sh_cc_wn`.`user_type` AS `sh_cc_wn_user_type`, `sh_cc_wn`.`level` AS `sh_cc_wn_level`, `sh_cc_wn`.`status` AS `sh_cc_wn_status`, `sh_cc_wn`.`note` AS `sh_cc_wn_note`, `sh_cc_wn`.`contact_id` AS `sh_cc_wn_contact_id`, `sh_cc_wn`.`cached_name` AS `sh_cc_wn_cached_name`, `sh_cc_wn`.`cached_update` AS `sh_cc_wn_cached_update`, `sh_cc_wn`.`contact_meta` AS `sh_cc_wn_contact_meta`, `sh_cc_wn`.`joined` AS `sh_cc_wn_joined`, `sh_fc`.`fileid` AS `sh_fc_fileid`, `sh_fc`.`path` AS `sh_fc_path`, `sh_fc`.`permissions` AS `sh_fc_permissions`, `sh_fc`.`storage` AS `sh_fc_storage`, `sh_fc`.`path_hash` AS `sh_fc_path_hash`, `sh_fc`.`parent` AS `sh_fc_parent`, `sh_fc`.`name` AS `sh_fc_name`, `sh_fc`.`mimetype` AS `sh_fc_mimetype`, `sh_fc`.`mimepart` AS `sh_fc_mimepart`, `sh_fc`.`size` AS `sh_fc_size`, `sh_fc`.`mtime` AS `sh_fc_mtime`, `sh_fc`.`storage_mtime` AS `sh_fc_storage_mtime`, `sh_fc`.`encrypted` AS `sh_fc_encrypted`, `sh_fc`.`unencrypted_size` AS `sh_fc_unencrypted_size`, `sh_fc`.`etag` AS `sh_fc_etag`, `sh_fc`.`checksum` AS `sh_fc_checksum`, `sh_fc_st`.`id` AS `sh_fc_st_id` FROM `*PREFIX*share` `sh` LEFT JOIN `*PREFIX*circles_circle` `sh_cc` ON `sh_cc`.`unique_id` = `sh`.`share_with` LEFT JOIN `*PREFIX*filecache` `sh_fc` ON `sh`.`file_source` = `sh_fc`.`fileid` LEFT JOIN `*PREFIX*circles_member` `sh_cc_wn` ON (`sh_cc_wn`.`circle_id` = `sh_cc`.`unique_id`) AND (`sh_cc_wn`.`level` = :dcValue2) LEFT JOIN `*PREFIX*storages` `sh_fc_st` ON `sh_fc`.`storage` = `sh_fc_st`.`numeric_id` WHERE (`sh`.`share_type` = :dcValue1) AND ((`sh`.`uid_owner` = :dcValue3) OR (`sh`.`uid_initiator` = :dcValue4)) AND (`sh_fc`.`parent` = :dcValue5) AND (`sh`.`parent` IS NULL)","userAgent":"Mozilla/5.0 (Windows) mirall/3.13.23.12-Win64 (build 20240708) (Nextcloud, windows-10.0.22621 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"29.0.5.1","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `sh`.`id`, `sh`.`share_type`, `sh`.`share_with`, `sh`.`uid_owner`, `sh`.`uid_initiator`, `sh`.`parent`, `sh`.`item_type`, `sh`.`item_source`, `sh`.`item_target`, `sh`.`file_source`, `sh`.`file_target`, `sh`.`permissions`, `sh`.`attributes`, `sh`.`stime`, `sh`.`accepted`, `sh`.`expiration`, `sh`.`token`, `sh`.`mail_send`, `sh_cc_wn`.`circle_id` AS `sh_cc_wn_circle_id`, `sh_cc_wn`.`member_id` AS `sh_cc_wn_member_id`, `sh_cc_wn`.`single_id` AS `sh_cc_wn_single_id`, `sh_cc_wn`.`user_id` AS `sh_cc_wn_user_id`, `sh_cc_wn`.`instance` AS `sh_cc_wn_instance`, `sh_cc_wn`.`user_type` AS `sh_cc_wn_user_type`, `sh_cc_wn`.`level` AS `sh_cc_wn_level`, `sh_cc_wn`.`status` AS `sh_cc_wn_status`, `sh_cc_wn`.`note` AS `sh_cc_wn_note`, `sh_cc_wn`.`contact_id` AS `sh_cc_wn_contact_id`, `sh_cc_wn`.`cached_name` AS `sh_cc_wn_cached_name`, `sh_cc_wn`.`cached_update` AS `sh_cc_wn_cached_update`, `sh_cc_wn`.`contact_meta` AS `sh_cc_wn_contact_meta`, `sh_cc_wn`.`joined` AS `sh_cc_wn_joined`, `sh_fc`.`fileid` AS `sh_fc_fileid`, `sh_fc`.`path` AS `sh_fc_path`, `sh_fc`.`permissions` AS `sh_fc_permissions`, `sh_fc`.`storage` AS `sh_fc_storage`, `sh_fc`.`path_hash` AS `sh_fc_path_hash`, `sh_fc`.`parent` AS `sh_fc_parent`, `sh_fc`.`name` AS `sh_fc_name`, `sh_fc`.`mimetype` AS `sh_fc_mimetype`, `sh_fc`.`mimepart` AS `sh_fc_mimepart`, `sh_fc`.`size` AS `sh_fc_size`, `sh_fc`.`mtime` AS `sh_fc_mtime`, `sh_fc`.`storage_mtime` AS `sh_fc_storage_mtime`, `sh_fc`.`encrypted` AS `sh_fc_encrypted`, `sh_fc`.`unencrypted_size` AS `sh_fc_unencrypted_size`, `sh_fc`.`etag` AS `sh_fc_etag`, `sh_fc`.`checksum` AS `sh_fc_checksum`, `sh_fc_st`.`id` AS `sh_fc_st_id` FROM `*PREFIX*share` `sh` LEFT JOIN `*PREFIX*circles_circle` `sh_cc` ON `sh_cc`.`unique_id` = `sh`.`share_with` LEFT JOIN `*PREFIX*filecache` `sh_fc` ON `sh`.`file_source` = `sh_fc`.`fileid` LEFT JOIN `*PREFIX*circles_member` `sh_cc_wn` ON (`sh_cc_wn`.`circle_id` = `sh_cc`.`unique_id`) AND (`sh_cc_wn`.`level` = :dcValue2) LEFT JOIN `*PREFIX*storages` `sh_fc_st` ON `sh_fc`.`storage` = `sh_fc_st`.`numeric_id` WHERE (`sh`.`share_type` = :dcValue1) AND ((`sh`.`uid_owner` = :dcValue3) OR (`sh`.`uid_initiator` = :dcValue4)) AND (`sh_fc`.`parent` = :dcValue5) AND (`sh`.`parent` IS NULL)","Code":0,"Trace":[{"file":"/app/www/public/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":344,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/app/www/public/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":384,"function":"executeQuery","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->"},{"file":"/app/www/public/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->"},{"file":"/config/www/nextcloud/apps/circles/lib/Tools/Db/ExtendedQueryBuilder.php","line":1051,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/config/www/nextcloud/apps/circles/lib/Tools/Db/ExtendedQueryBuilder.php","line":947,"function":"getRows","class":"OCA\\Circles\\Tools\\Db\\ExtendedQueryBuilder","type":"->"},{"file":"/config/www/nextcloud/apps/circles/lib/Db/ShareWrapperRequestBuilder.php","line":120,"function":"asItems","class":"OCA\\Circles\\Tools\\Db\\ExtendedQueryBuilder","type":"->"},{"file":"/config/www/nextcloud/apps/circles/lib/Db/ShareWrapperRequest.php","line":419,"function":"getItemsFromRequest","class":"OCA\\Circles\\Db\\ShareWrapperRequestBuilder","type":"->"},{"file":"/config/www/nextcloud/apps/circles/lib/Service/ShareWrapperService.php","line":289,"function":"getSharesInFolder","class":"OCA\\Circles\\Db\\ShareWrapperRequest","type":"->"},{"file":"/config/www/nextcloud/apps/circles/lib/ShareByCircleProvider.php","line":395,"function":"getSharesInFolder","class":"OCA\\Circles\\Service\\ShareWrapperService","type":"->"},{"file":"/app/www/public/lib/private/Share20/Manager.php","line":1237,"function":"getSharesInFolder","class":"OCA\\Circles\\ShareByCircleProvider","type":"->"},{"function":"OC\\Share20\\{closure}","class":"OC\\Share20\\Manager","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/app/www/public/lib/private/Share20/Manager.php","line":1236,"function":"array_reduce"},{"file":"/config/www/nextcloud/apps/dav/lib/Connector/Sabre/SharesPlugin.php","line":142,"function":"getSharesInFolder","class":"OC\\Share20\\Manager","type":"->"},{"file":"/config/www/nextcloud/apps/dav/lib/Connector/Sabre/SharesPlugin.php","line":206,"function":"getSharesFolder","class":"OCA\\DAV\\Connector\\Sabre\\SharesPlugin","type":"->"},{"file":"/app/www/public/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"handleGetProperties","class":"OCA\\DAV\\Connector\\Sabre\\SharesPlugin","type":"->"},{"file":"/app/www/public/3rdparty/sabre/dav/lib/DAV/Server.php","line":1052,"function":"emit","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/app/www/public/3rdparty/sabre/dav/lib/DAV/Server.php","line":984,"function":"getPropertiesByNode","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/app/www/public/3rdparty/sabre/dav/lib/DAV/Server.php","line":1662,"function":"getPropertiesIteratorForPath","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/app/www/public/3rdparty/sabre/dav/lib/DAV/Server.php","line":1647,"function":"writeMultiStatus","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/app/www/public/3rdparty/sabre/dav/lib/DAV/CorePlugin.php","line":346,"function":"generateMultiStatus","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/app/www/public/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"httpPropFind","class":"Sabre\\DAV\\CorePlugin","type":"->"},{"file":"/app/www/public/3rdparty/sabre/dav/lib/DAV/Server.php","line":472,"function":"emit","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/app/www/public/3rdparty/sabre/dav/lib/DAV/Server.php","line":253,"function":"invokeMethod","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/app/www/public/3rdparty/sabre/dav/lib/DAV/Server.php","line":321,"function":"start","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/config/www/nextcloud/apps/dav/lib/Server.php","line":385,"function":"exec","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/config/www/nextcloud/apps/dav/appinfo/v2/remote.php","line":35,"function":"exec","class":"OCA\\DAV\\Server","type":"->"},{"file":"/app/www/public/remote.php","line":172,"args":["/config/www/nextcloud/apps/dav/appinfo/v2/remote.php"],"function":"require_once"}],"File":"/app/www/public/lib/private/DB/Connection.php","Line":320,"message":"dirty table reads: SELECT `sh`.`id`, `sh`.`share_type`, `sh`.`share_with`, `sh`.`uid_owner`, `sh`.`uid_initiator`, `sh`.`parent`, `sh`.`item_type`, `sh`.`item_source`, `sh`.`item_target`, `sh`.`file_source`, `sh`.`file_target`, `sh`.`permissions`, `sh`.`attributes`, `sh`.`stime`, `sh`.`accepted`, `sh`.`expiration`, `sh`.`token`, `sh`.`mail_send`, `sh_cc_wn`.`circle_id` AS `sh_cc_wn_circle_id`, `sh_cc_wn`.`member_id` AS `sh_cc_wn_member_id`, `sh_cc_wn`.`single_id` AS `sh_cc_wn_single_id`, `sh_cc_wn`.`user_id` AS `sh_cc_wn_user_id`, `sh_cc_wn`.`instance` AS `sh_cc_wn_instance`, `sh_cc_wn`.`user_type` AS `sh_cc_wn_user_type`, `sh_cc_wn`.`level` AS `sh_cc_wn_level`, `sh_cc_wn`.`status` AS `sh_cc_wn_status`, `sh_cc_wn`.`note` AS `sh_cc_wn_note`, `sh_cc_wn`.`contact_id` AS `sh_cc_wn_contact_id`, `sh_cc_wn`.`cached_name` AS `sh_cc_wn_cached_name`, `sh_cc_wn`.`cached_update` AS `sh_cc_wn_cached_update`, `sh_cc_wn`.`contact_meta` AS `sh_cc_wn_contact_meta`, `sh_cc_wn`.`joined` AS `sh_cc_wn_joined`, `sh_fc`.`fileid` AS `sh_fc_fileid`, `sh_fc`.`path` AS `sh_fc_path`, `sh_fc`.`permissions` AS `sh_fc_permissions`, `sh_fc`.`storage` AS `sh_fc_storage`, `sh_fc`.`path_hash` AS `sh_fc_path_hash`, `sh_fc`.`parent` AS `sh_fc_parent`, `sh_fc`.`name` AS `sh_fc_name`, `sh_fc`.`mimetype` AS `sh_fc_mimetype`, `sh_fc`.`mimepart` AS `sh_fc_mimepart`, `sh_fc`.`size` AS `sh_fc_size`, `sh_fc`.`mtime` AS `sh_fc_mtime`, `sh_fc`.`storage_mtime` AS `sh_fc_storage_mtime`, `sh_fc`.`encrypted` AS `sh_fc_encrypted`, `sh_fc`.`unencrypted_size` AS `sh_fc_unencrypted_size`, `sh_fc`.`etag` AS `sh_fc_etag`, `sh_fc`.`checksum` AS `sh_fc_checksum`, `sh_fc_st`.`id` AS `sh_fc_st_id` FROM `*PREFIX*share` `sh` LEFT JOIN `*PREFIX*circles_circle` `sh_cc` ON `sh_cc`.`unique_id` = `sh`.`share_with` LEFT JOIN `*PREFIX*filecache` `sh_fc` ON `sh`.`file_source` = `sh_fc`.`fileid` LEFT JOIN `*PREFIX*circles_member` `sh_cc_wn` ON (`sh_cc_wn`.`circle_id` = `sh_cc`.`unique_id`) AND (`sh_cc_wn`.`level` = :dcValue2) LEFT JOIN `*PREFIX*storages` `sh_fc_st` ON `sh_fc`.`storage` = `sh_fc_st`.`numeric_id` WHERE (`sh`.`share_type` = :dcValue1) AND ((`sh`.`uid_owner` = :dcValue3) OR (`sh`.`uid_initiator` = :dcValue4)) AND (`sh_fc`.`parent` = :dcValue5) AND (`sh`.`parent` IS NULL)","tables":["oc_filecache"],"reads":["oc_share","oc_circles_circle","oc_filecache","oc_circles_member","oc_storages"],"exception":{},"CustomMessage":"dirty table reads: SELECT `sh`.`id`, `sh`.`share_type`, `sh`.`share_with`, `sh`.`uid_owner`, `sh`.`uid_initiator`, `sh`.`parent`, `sh`.`item_type`, `sh`.`item_source`, `sh`.`item_target`, `sh`.`file_source`, `sh`.`file_target`, `sh`.`permissions`, `sh`.`attributes`, `sh`.`stime`, `sh`.`accepted`, `sh`.`expiration`, `sh`.`token`, `sh`.`mail_send`, `sh_cc_wn`.`circle_id` AS `sh_cc_wn_circle_id`, `sh_cc_wn`.`member_id` AS `sh_cc_wn_member_id`, `sh_cc_wn`.`single_id` AS `sh_cc_wn_single_id`, `sh_cc_wn`.`user_id` AS `sh_cc_wn_user_id`, `sh_cc_wn`.`instance` AS `sh_cc_wn_instance`, `sh_cc_wn`.`user_type` AS `sh_cc_wn_user_type`, `sh_cc_wn`.`level` AS `sh_cc_wn_level`, `sh_cc_wn`.`status` AS `sh_cc_wn_status`, `sh_cc_wn`.`note` AS `sh_cc_wn_note`, `sh_cc_wn`.`contact_id` AS `sh_cc_wn_contact_id`, `sh_cc_wn`.`cached_name` AS `sh_cc_wn_cached_name`, `sh_cc_wn`.`cached_update` AS `sh_cc_wn_cached_update`, `sh_cc_wn`.`contact_meta` AS `sh_cc_wn_contact_meta`, `sh_cc_wn`.`joined` AS `sh_cc_wn_joined`, `sh_fc`.`fileid` AS `sh_fc_fileid`, `sh_fc`.`path` AS `sh_fc_path`, `sh_fc`.`permissions` AS `sh_fc_permissions`, `sh_fc`.`storage` AS `sh_fc_storage`, `sh_fc`.`path_hash` AS `sh_fc_path_hash`, `sh_fc`.`parent` AS `sh_fc_parent`, `sh_fc`.`name` AS `sh_fc_name`, `sh_fc`.`mimetype` AS `sh_fc_mimetype`, `sh_fc`.`mimepart` AS `sh_fc_mimepart`, `sh_fc`.`size` AS `sh_fc_size`, `sh_fc`.`mtime` AS `sh_fc_mtime`, `sh_fc`.`storage_mtime` AS `sh_fc_storage_mtime`, `sh_fc`.`encrypted` AS `sh_fc_encrypted`, `sh_fc`.`unencrypted_size` AS `sh_fc_unencrypted_size`, `sh_fc`.`etag` AS `sh_fc_etag`, `sh_fc`.`checksum` AS `sh_fc_checksum`, `sh_fc_st`.`id` AS `sh_fc_st_id` FROM `*PREFIX*share` `sh` LEFT JOIN `*PREFIX*circles_circle` `sh_cc` ON `sh_cc`.`unique_id` = `sh`.`share_with` LEFT JOIN `*PREFIX*filecache` `sh_fc` ON `sh`.`file_source` = `sh_fc`.`fileid` LEFT JOIN `*PREFIX*circles_member` `sh_cc_wn` ON (`sh_cc_wn`.`circle_id` = `sh_cc`.`unique_id`) AND (`sh_cc_wn`.`level` = :dcValue2) LEFT JOIN `*PREFIX*storages` `sh_fc_st` ON `sh_fc`.`storage` = `sh_fc_st`.`numeric_id` WHERE (`sh`.`share_type` = :dcValue1) AND ((`sh`.`uid_owner` = :dcValue3) OR (`sh`.`uid_initiator` = :dcValue4)) AND (`sh_fc`.`parent` = :dcValue5) AND (`sh`.`parent` IS NULL)"}}
{"reqId":"cCpCH29UGdorqUIP4c5U","level":0,"time":"2024-08-25T12:45:26+00:00","remoteAddr":"10.1.12.144","user":"timothy","app":"no app in context","method":"PROPFIND","url":"/remote.php/dav/files/timothy/Photography","message":"dirty table reads: SELECT `s`.*, `f`.`fileid`, `f`.`path`, `f`.`permissions` as `f_permissions`, `f`.`storage`, `f`.`path_hash`, `f`.`parent` as `f_parent`, `f`.`name`, `f`.`mimetype`, `f`.`mimepart`, `f`.`size`, `f`.`mtime`, `f`.`storage_mtime`, `f`.`encrypted`, `f`.`unencrypted_size`, `f`.`etag`, `f`.`checksum`, `st`.`id` AS `storage_string_id` FROM `*PREFIX*share` `s` LEFT JOIN `*PREFIX*filecache` `f` ON `s`.`file_source` = `f`.`fileid` LEFT JOIN `*PREFIX*storages` `st` ON `f`.`storage` = `st`.`numeric_id` WHERE (`share_type` = :dcValue1) AND (`share_with` = :dcValue2) AND ((`item_type` = :dcValue3) OR (`item_type` = :dcValue4)) AND (`file_source` = :dcValue5) ORDER BY `s`.`id` ASC","userAgent":"Mozilla/5.0 (Windows) mirall/3.13.23.12-Win64 (build 20240708) (Nextcloud, windows-10.0.22621 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"29.0.5.1","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `s`.*, `f`.`fileid`, `f`.`path`, `f`.`permissions` as `f_permissions`, `f`.`storage`, `f`.`path_hash`, `f`.`parent` as `f_parent`, `f`.`name`, `f`.`mimetype`, `f`.`mimepart`, `f`.`size`, `f`.`mtime`, `f`.`storage_mtime`, `f`.`encrypted`, `f`.`unencrypted_size`, `f`.`etag`, `f`.`checksum`, `st`.`id` AS `storage_string_id` FROM `*PREFIX*share` `s` LEFT JOIN `*PREFIX*filecache` `f` ON `s`.`file_source` = `f`.`fileid` LEFT JOIN `*PREFIX*storages` `st` ON `f`.`storage` = `st`.`numeric_id` WHERE (`share_type` = :dcValue1) AND (`share_with` = :dcValue2) AND ((`item_type` = :dcValue3) OR (`item_type` = :dcValue4)) AND (`file_source` = :dcValue5) ORDER BY `s`.`id` ASC","Code":0,"Trace":[{"file":"/app/www/public/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":344,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/app/www/public/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":384,"function":"executeQuery","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->"},{"file":"/app/www/public/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->"},{"file":"/app/www/public/lib/private/Share20/DefaultShareProvider.php","line":951,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/app/www/public/lib/private/Share20/Manager.php","line":1332,"function":"getSharedWith","class":"OC\\Share20\\DefaultShareProvider","type":"->"},{"file":"/config/www/nextcloud/apps/dav/lib/Connector/Sabre/SharesPlugin.php","line":123,"function":"getSharedWith","class":"OC\\Share20\\Manager","type":"->"},{"file":"/config/www/nextcloud/apps/dav/lib/Connector/Sabre/SharesPlugin.php","line":172,"function":"getShare","class":"OCA\\DAV\\Connector\\Sabre\\SharesPlugin","type":"->"},{"file":"/config/www/nextcloud/apps/dav/lib/Connector/Sabre/SharesPlugin.php","line":213,"function":"getShares","class":"OCA\\DAV\\Connector\\Sabre\\SharesPlugin","type":"->"},{"file":"/app/www/public/3rdparty/sabre/dav/lib/DAV/PropFind.php","line":95,"function":"OCA\\DAV\\Connector\\Sabre\\{closure}","class":"OCA\\DAV\\Connector\\Sabre\\SharesPlugin","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/config/www/nextcloud/apps/dav/lib/Connector/Sabre/SharesPlugin.php","line":212,"function":"handle","class":"Sabre\\DAV\\PropFind","type":"->"},{"file":"/app/www/public/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"handleGetProperties","class":"OCA\\DAV\\Connector\\Sabre\\SharesPlugin","type":"->"},{"file":"/app/www/public/3rdparty/sabre/dav/lib/DAV/Server.php","line":1052,"function":"emit","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/app/www/public/3rdparty/sabre/dav/lib/DAV/Server.php","line":984,"function":"getPropertiesByNode","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/app/www/public/3rdparty/sabre/dav/lib/DAV/Server.php","line":1662,"function":"getPropertiesIteratorForPath","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/app/www/public/3rdparty/sabre/dav/lib/DAV/Server.php","line":1647,"function":"writeMultiStatus","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/app/www/public/3rdparty/sabre/dav/lib/DAV/CorePlugin.php","line":346,"function":"generateMultiStatus","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/app/www/public/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"httpPropFind","class":"Sabre\\DAV\\CorePlugin","type":"->"},{"file":"/app/www/public/3rdparty/sabre/dav/lib/DAV/Server.php","line":472,"function":"emit","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/app/www/public/3rdparty/sabre/dav/lib/DAV/Server.php","line":253,"function":"invokeMethod","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/app/www/public/3rdparty/sabre/dav/lib/DAV/Server.php","line":321,"function":"start","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/config/www/nextcloud/apps/dav/lib/Server.php","line":385,"function":"exec","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/config/www/nextcloud/apps/dav/appinfo/v2/remote.php","line":35,"function":"exec","class":"OCA\\DAV\\Server","type":"->"},{"file":"/app/www/public/remote.php","line":172,"args":["/config/www/nextcloud/apps/dav/appinfo/v2/remote.php"],"function":"require_once"}],"File":"/app/www/public/lib/private/DB/Connection.php","Line":320,"message":"dirty table reads: SELECT `s`.*, `f`.`fileid`, `f`.`path`, `f`.`permissions` as `f_permissions`, `f`.`storage`, `f`.`path_hash`, `f`.`parent` as `f_parent`, `f`.`name`, `f`.`mimetype`, `f`.`mimepart`, `f`.`size`, `f`.`mtime`, `f`.`storage_mtime`, `f`.`encrypted`, `f`.`unencrypted_size`, `f`.`etag`, `f`.`checksum`, `st`.`id` AS `storage_string_id` FROM `*PREFIX*share` `s` LEFT JOIN `*PREFIX*filecache` `f` ON `s`.`file_source` = `f`.`fileid` LEFT JOIN `*PREFIX*storages` `st` ON `f`.`storage` = `st`.`numeric_id` WHERE (`share_type` = :dcValue1) AND (`share_with` = :dcValue2) AND ((`item_type` = :dcValue3) OR (`item_type` = :dcValue4)) AND (`file_source` = :dcValue5) ORDER BY `s`.`id` ASC","tables":["oc_filecache"],"reads":["oc_share","oc_filecache","oc_storages"],"exception":{},"CustomMessage":"dirty table reads: SELECT `s`.*, `f`.`fileid`, `f`.`path`, `f`.`permissions` as `f_permissions`, `f`.`storage`, `f`.`path_hash`, `f`.`parent` as `f_parent`, `f`.`name`, `f`.`mimetype`, `f`.`mimepart`, `f`.`size`, `f`.`mtime`, `f`.`storage_mtime`, `f`.`encrypted`, `f`.`unencrypted_size`, `f`.`etag`, `f`.`checksum`, `st`.`id` AS `storage_string_id` FROM `*PREFIX*share` `s` LEFT JOIN `*PREFIX*filecache` `f` ON `s`.`file_source` = `f`.`fileid` LEFT JOIN `*PREFIX*storages` `st` ON `f`.`storage` = `st`.`numeric_id` WHERE (`share_type` = :dcValue1) AND (`share_with` = :dcValue2) AND ((`item_type` = :dcValue3) OR (`item_type` = :dcValue4)) AND (`file_source` = :dcValue5) ORDER BY `s`.`id` ASC"}}