Nextcloud Notifications not sending mail on file creation

Nextcloud version (eg, 29.0.5): 30.0.0
Operating system and version (eg, Ubuntu 24.04): ‘Debian 12’
Apache or nginx version (eg, Apache 2.4.25): ‘Apache 2.4.62’
PHP version (eg, 8.3): ‘8.2’

The issue you are facing:
Since update to 30.0.0 Mail notifications about created files in shared folder are not sent. Notifications about new shared folders and the test mail are sent correctly.

Is this the first time you’ve seen this error? (Y/N): Y

Steps to replicate it:

  1. Create a folder and share it to another user or group
  2. Another user uploads some file
  3. Mail is not sent

The output of your Nextcloud log in Admin > Logging:

follows later, Logging Site freezes if all loglevels activated, there are only "info" and "fehlerbehebung" ones, no critical errors

The output of your config.php file in /path/to/nextcloud (make sure you remove any identifiable information!):

<?php
$CONFIG = array (
  'instanceid' => '****',
  'passwordsalt' => '****',
  'secret' => '****',
  'trusted_domains' =>
  array (
    0 => '192.168.1.15',
    1 => 'domain1.de',
    2 => '127.0.40.15',
    3 => 'public ip',
    4 => 'cloud.domain2.de',
  ),
  'memcache.local' => '\\OC\\Memcache\\APCu',
  'memcache.locking' => '\\OC\\Memcache\\Redis',
  'memcache.distributed' => '\\OC\\Memcache\\Redis',
  'datadirectory' => '/media/data/nextcloud/data',
  'dbtype' => 'mysql',
  'version' => '30.0.0.14',
  'overwrite.cli.url' => 'https://cloud.domain2.de',
  'dbname' => 'db_nextcloud',
  'dbhost' => 'localhost',
  'dbport' => '',
  'dbtableprefix' => 'oc_',
  'mysql.utf8mb4' => true,
  'dbuser' => 'nextcloud',
  'dbpassword' => '****',
  'installed' => true,
  'theme' => '',
  'loglevel' => 0,
  'maintenance' => false,
  'mail_smtpmode' => 'smtp',
  'mail_sendmailmode' => 'smtp',
  'mail_smtpauthtype' => 'NTLM',
  'mail_from_address' => 'nextcloud',
  'mail_domain' => 'domain2.de',
  'default_language' => 'de_DE',
  'default_locale' => 'de_DE',
  'mail_smtphost' => '192.168.185.206',
  'updater.release.channel' => 'stable',
  'default_phone_region' => 'DE',
  'overwritehost' => 'cloud.domain2.de',
  'skeletondirectory' => '',
  'redis' =>
  array (
    'host' => 'localhost',
    'port' => 6379,
  ),
  'mail_smtpport' => '587',
  'mail_smtpauth' => 1,
  'mail_smtpname' => 'user\\ad',
  'mail_smtppassword' => '****',
  'mail_smtpstreamoptions' =>
  array (
    'ssl' =>
    array (
      'allow_self_signed' => true,
      'verify_peer' => false,
      'verify_peer_name' => false,
    ),
  ),
  'trusted_proxies' =>
  array (
    0 => '127.0.0.1',
    1 => '::1',
    2 => '192.168.1.1',
    3 => '192.168.1.15',
  ),
  'maintenance_window_start' =>
  array (
    'maintenance_window_start' => 1,
  ),
  'app_install_overwrite' =>
  array (
    0 => 'tasks',
  ),
  'has_rebuilt_cache' => true,
);

Output errors in nextcloud.log in /var/www/ or as admin user in top right menu, filtering for errors. Use a pastebin service if necessary.

follows later
Is there a simple way to remove user and IP information from the log?

This could be a related problem to this one: Nextcloud.log is running full, and fileshare mails wont be sended

No mail notification is sent when a file/folder is shared by mail (not with another internal user).

Unfortunately I do not seem to find a relevant fix in the 30.0.1 RC1 release notes.

I Updated to 30.0.1 RC2 and the problem still persists. Mails on creating a share are sent but not on file modification.

I’ve downloaded the log. Since it is over 6MB in size I’ll paste the most occuring parts here:

{"reqId":"uybeSq0y83LJYBlwzeG3","level":0,"time":"2024-10-14T12:00:56+00:00","remoteAddr":"***removed***","user":"***removed***","app":"app_api","method":"GET","url":"/ocs/v2.php/apps/notifications/api/v2/notifications?format=json","message":"ExApp \"files_sharing\" not found.","userAgent":"Mozilla/5.0 (Windows) mirall/3.9.0stable-Win64 (build 20230613) (Nextcloud, windows-10.0.20348 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.1.1","data":{"app":"app_api"}}
{"reqId":"uybeSq0y83LJYBlwzeG3","level":0,"time":"2024-10-14T12:00:56+00:00","remoteAddr":"***removed***","user":"***removed***","app":"no app in context","method":"GET","url":"/ocs/v2.php/apps/notifications/api/v2/notifications?format=json","message":"OCA\\AppAPI\\Notifications\\ExAppNotifier::prepare() threw \\InvalidArgumentException which is deprecated. Throw \\OCP\\Notification\\UnknownNotificationException when the notification is not known to your notifier and otherwise handle all \\InvalidArgumentException yourself.","userAgent":"Mozilla/5.0 (Windows) mirall/3.9.0stable-Win64 (build 20230613) (Nextcloud, windows-10.0.20348 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.1.1","data":[]}
{"reqId":"uybeSq0y83LJYBlwzeG3","level":0,"time":"2024-10-14T12:00:56+00:00","remoteAddr":"***removed***","user":"***removed***","app":"no app in context","method":"GET","url":"/ocs/v2.php/apps/notifications/api/v2/notifications?format=json","message":"OCA\\Calendar\\Notification\\Notifier::prepare() threw \\InvalidArgumentException which is deprecated. Throw \\OCP\\Notification\\UnknownNotificationException when the notification is not known to your notifier and otherwise handle all \\InvalidArgumentException yourself.","userAgent":"Mozilla/5.0 (Windows) mirall/3.9.0stable-Win64 (build 20230613) (Nextcloud, windows-10.0.20348 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.1.1","data":[]}
{"reqId":"uybeSq0y83LJYBlwzeG3","level":0,"time":"2024-10-14T12:00:56+00:00","remoteAddr":"***removed***","user":"***removed***","app":"no app in context","method":"GET","url":"/ocs/v2.php/apps/notifications/api/v2/notifications?format=json","message":"OCA\\Circles\\Notification\\Notifier::prepare() threw \\InvalidArgumentException which is deprecated. Throw \\OCP\\Notification\\UnknownNotificationException when the notification is not known to your notifier and otherwise handle all \\InvalidArgumentException yourself.","userAgent":"Mozilla/5.0 (Windows) mirall/3.9.0stable-Win64 (build 20230613) (Nextcloud, windows-10.0.20348 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.1.1","data":[]}
{"reqId":"uybeSq0y83LJYBlwzeG3","level":0,"time":"2024-10-14T12:00:56+00:00","remoteAddr":"***removed***","user":"***removed***","app":"no app in context","method":"GET","url":"/ocs/v2.php/apps/notifications/api/v2/notifications?format=json","message":"OCA\\Mail\\Notification\\Notifier::prepare() threw \\InvalidArgumentException which is deprecated. Throw \\OCP\\Notification\\UnknownNotificationException when the notification is not known to your notifier and otherwise handle all \\InvalidArgumentException yourself.","userAgent":"Mozilla/5.0 (Windows) mirall/3.9.0stable-Win64 (build 20230613) (Nextcloud, windows-10.0.20348 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.1.1","data":[]}
{"reqId":"uybeSq0y83LJYBlwzeG3","level":0,"time":"2024-10-14T12:00:56+00:00","remoteAddr":"***removed***","user":"***removed***","app":"no app in context","method":"GET","url":"/ocs/v2.php/apps/notifications/api/v2/notifications?format=json","message":"OCA\\NextcloudAnnouncements\\Notification\\Notifier::prepare() threw \\InvalidArgumentException which is deprecated. Throw \\OCP\\Notification\\UnknownNotificationException when the notification is not known to your notifier and otherwise handle all \\InvalidArgumentException yourself.","userAgent":"Mozilla/5.0 (Windows) mirall/3.9.0stable-Win64 (build 20230613) (Nextcloud, windows-10.0.20348 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.1.1","data":[]}
{"reqId":"uybeSq0y83LJYBlwzeG3","level":0,"time":"2024-10-14T12:00:56+00:00","remoteAddr":"***removed***","user":"***removed***","app":"no app in context","method":"GET","url":"/ocs/v2.php/apps/notifications/api/v2/notifications?format=json","message":"OCA\\Richdocuments\\Notification\\Notifier::prepare() threw \\InvalidArgumentException which is deprecated. Throw \\OCP\\Notification\\UnknownNotificationException when the notification is not known to your notifier and otherwise handle all \\InvalidArgumentException yourself.","userAgent":"Mozilla/5.0 (Windows) mirall/3.9.0stable-Win64 (build 20230613) (Nextcloud, windows-10.0.20348 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.1.1","data":[]}
{"reqId":"uybeSq0y83LJYBlwzeG3","level":0,"time":"2024-10-14T12:00:56+00:00","remoteAddr":"***removed***","user":"***removed***","app":"no app in context","method":"GET","url":"/ocs/v2.php/apps/notifications/api/v2/notifications?format=json","message":"OCA\\Text\\Notification\\Notifier::prepare() threw \\InvalidArgumentException which is deprecated. Throw \\OCP\\Notification\\UnknownNotificationException when the notification is not known to your notifier and otherwise handle all \\InvalidArgumentException yourself.","userAgent":"Mozilla/5.0 (Windows) mirall/3.9.0stable-Win64 (build 20230613) (Nextcloud, windows-10.0.20348 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.1.1","data":[]}
{"reqId":"uybeSq0y83LJYBlwzeG3","level":0,"time":"2024-10-14T12:00:56+00:00","remoteAddr":"***removed***","user":"***removed***","app":"activity","method":"GET","url":"/ocs/v2.php/apps/notifications/api/v2/notifications?format=json","message":"OCA\\Settings\\Activity\\GroupProvider::parse() threw \\InvalidArgumentException which is deprecated. Throw \\OCP\\Activity\\Exceptions\\UnknownActivityException when the event is not known to your provider and otherwise handle all \\InvalidArgumentException yourself.","userAgent":"Mozilla/5.0 (Windows) mirall/3.9.0stable-Win64 (build 20230613) (Nextcloud, windows-10.0.20348 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.1.1","data":{"app":"activity"}}
{"reqId":"uybeSq0y83LJYBlwzeG3","level":0,"time":"2024-10-14T12:00:56+00:00","remoteAddr":"***removed***","user":"***removed***","app":"activity","method":"GET","url":"/ocs/v2.php/apps/notifications/api/v2/notifications?format=json","message":"OCA\\Settings\\Activity\\Provider::parse() threw \\InvalidArgumentException which is deprecated. Throw \\OCP\\Activity\\Exceptions\\UnknownActivityException when the event is not known to your provider and otherwise handle all \\InvalidArgumentException yourself.","userAgent":"Mozilla/5.0 (Windows) mirall/3.9.0stable-Win64 (build 20230613) (Nextcloud, windows-10.0.20348 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.1.1","data":{"app":"activity"}}
{"reqId":"uybeSq0y83LJYBlwzeG3","level":0,"time":"2024-10-14T12:00:56+00:00","remoteAddr":"***removed***","user":"***removed***","app":"activity","method":"GET","url":"/ocs/v2.php/apps/notifications/api/v2/notifications?format=json","message":"OCA\\Settings\\Activity\\SecurityProvider::parse() threw \\InvalidArgumentException which is deprecated. Throw \\OCP\\Activity\\Exceptions\\UnknownActivityException when the event is not known to your provider and otherwise handle all \\InvalidArgumentException yourself.","userAgent":"Mozilla/5.0 (Windows) mirall/3.9.0stable-Win64 (build 20230613) (Nextcloud, windows-10.0.20348 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.1.1","data":{"app":"activity"}}
{"reqId":"uybeSq0y83LJYBlwzeG3","level":0,"time":"2024-10-14T12:00:56+00:00","remoteAddr":"***removed***","user":"***removed***","app":"activity","method":"GET","url":"/ocs/v2.php/apps/notifications/api/v2/notifications?format=json","message":"OCA\\Files\\Activity\\FavoriteProvider::parse() threw \\InvalidArgumentException which is deprecated. Throw \\OCP\\Activity\\Exceptions\\UnknownActivityException when the event is not known to your provider and otherwise handle all \\InvalidArgumentException yourself.","userAgent":"Mozilla/5.0 (Windows) mirall/3.9.0stable-Win64 (build 20230613) (Nextcloud, windows-10.0.20348 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.1.1","data":{"app":"activity"}}
{"reqId":"uybeSq0y83LJYBlwzeG3","level":0,"time":"2024-10-14T12:00:56+00:00","remoteAddr":"***removed***","user":"***removed***","app":"activity","method":"GET","url":"/ocs/v2.php/apps/notifications/api/v2/notifications?format=json","message":"OCA\\Files\\Activity\\Provider::parse() threw \\InvalidArgumentException which is deprecated. Throw \\OCP\\Activity\\Exceptions\\UnknownActivityException when the event is not known to your provider and otherwise handle all \\InvalidArgumentException yourself.","userAgent":"Mozilla/5.0 (Windows) mirall/3.9.0stable-Win64 (build 20230613) (Nextcloud, windows-10.0.20348 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.1.1","data":{"app":"activity"}}
{"reqId":"uybeSq0y83LJYBlwzeG3","level":0,"time":"2024-10-14T12:00:56+00:00","remoteAddr":"***removed***","user":"***removed***","app":"activity","method":"GET","url":"/ocs/v2.php/apps/notifications/api/v2/notifications?format=json","message":"OCA\\Circles\\Activity\\Provider::parse() threw \\InvalidArgumentException which is deprecated. Throw \\OCP\\Activity\\Exceptions\\UnknownActivityException when the event is not known to your provider and otherwise handle all \\InvalidArgumentException yourself.","userAgent":"Mozilla/5.0 (Windows) mirall/3.9.0stable-Win64 (build 20230613) (Nextcloud, windows-10.0.20348 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.1.1","data":{"app":"activity"}}
{"reqId":"uybeSq0y83LJYBlwzeG3","level":0,"time":"2024-10-14T12:00:56+00:00","remoteAddr":"***removed***","user":"***removed***","app":"activity","method":"GET","url":"/ocs/v2.php/apps/notifications/api/v2/notifications?format=json","message":"OCA\\Comments\\Activity\\Provider::parse() threw \\InvalidArgumentException which is deprecated. Throw \\OCP\\Activity\\Exceptions\\UnknownActivityException when the event is not known to your provider and otherwise handle all \\InvalidArgumentException yourself.","userAgent":"Mozilla/5.0 (Windows) mirall/3.9.0stable-Win64 (build 20230613) (Nextcloud, windows-10.0.20348 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.1.1","data":{"app":"activity"}}
{"reqId":"uybeSq0y83LJYBlwzeG3","level":0,"time":"2024-10-14T12:00:56+00:00","remoteAddr":"***removed***","user":"***removed***","app":"activity","method":"GET","url":"/ocs/v2.php/apps/notifications/api/v2/notifications?format=json","message":"OCA\\DAV\\CalDAV\\Activity\\Provider\\Calendar::parse() threw \\InvalidArgumentException which is deprecated. Throw \\OCP\\Activity\\Exceptions\\UnknownActivityException when the event is not known to your provider and otherwise handle all \\InvalidArgumentException yourself.","userAgent":"Mozilla/5.0 (Windows) mirall/3.9.0stable-Win64 (build 20230613) (Nextcloud, windows-10.0.20348 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.1.1","data":{"app":"activity"}}
{"reqId":"uybeSq0y83LJYBlwzeG3","level":0,"time":"2024-10-14T12:00:56+00:00","remoteAddr":"***removed***","user":"***removed***","app":"activity","method":"GET","url":"/ocs/v2.php/apps/notifications/api/v2/notifications?format=json","message":"OCA\\DAV\\CalDAV\\Activity\\Provider\\Event::parse() threw \\InvalidArgumentException which is deprecated. Throw \\OCP\\Activity\\Exceptions\\UnknownActivityException when the event is not known to your provider and otherwise handle all \\InvalidArgumentException yourself.","userAgent":"Mozilla/5.0 (Windows) mirall/3.9.0stable-Win64 (build 20230613) (Nextcloud, windows-10.0.20348 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.1.1","data":{"app":"activity"}}
{"reqId":"uybeSq0y83LJYBlwzeG3","level":0,"time":"2024-10-14T12:00:56+00:00","remoteAddr":"***removed***","user":"***removed***","app":"activity","method":"GET","url":"/ocs/v2.php/apps/notifications/api/v2/notifications?format=json","message":"OCA\\DAV\\CalDAV\\Activity\\Provider\\Todo::parse() threw \\InvalidArgumentException which is deprecated. Throw \\OCP\\Activity\\Exceptions\\UnknownActivityException when the event is not known to your provider and otherwise handle all \\InvalidArgumentException yourself.","userAgent":"Mozilla/5.0 (Windows) mirall/3.9.0stable-Win64 (build 20230613) (Nextcloud, windows-10.0.20348 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.1.1","data":{"app":"activity"}}
{"reqId":"uybeSq0y83LJYBlwzeG3","level":0,"time":"2024-10-14T12:00:56+00:00","remoteAddr":"***removed***","user":"***removed***","app":"activity","method":"GET","url":"/ocs/v2.php/apps/notifications/api/v2/notifications?format=json","message":"OCA\\DAV\\CardDAV\\Activity\\Provider\\Addressbook::parse() threw \\InvalidArgumentException which is deprecated. Throw \\OCP\\Activity\\Exceptions\\UnknownActivityException when the event is not known to your provider and otherwise handle all \\InvalidArgumentException yourself.","userAgent":"Mozilla/5.0 (Windows) mirall/3.9.0stable-Win64 (build 20230613) (Nextcloud, windows-10.0.20348 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.1.1","data":{"app":"activity"}}
{"reqId":"uybeSq0y83LJYBlwzeG3","level":0,"time":"2024-10-14T12:00:56+00:00","remoteAddr":"***removed***","user":"***removed***","app":"activity","method":"GET","url":"/ocs/v2.php/apps/notifications/api/v2/notifications?format=json","message":"OCA\\DAV\\CardDAV\\Activity\\Provider\\Card::parse() threw \\InvalidArgumentException which is deprecated. Throw \\OCP\\Activity\\Exceptions\\UnknownActivityException when the event is not known to your provider and otherwise handle all \\InvalidArgumentException yourself.","userAgent":"Mozilla/5.0 (Windows) mirall/3.9.0stable-Win64 (build 20230613) (Nextcloud, windows-10.0.20348 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.1.1","data":{"app":"activity"}}
{"reqId":"uybeSq0y83LJYBlwzeG3","level":0,"time":"2024-10-14T12:00:56+00:00","remoteAddr":"***removed***","user":"***removed***","app":"activity","method":"GET","url":"/ocs/v2.php/apps/notifications/api/v2/notifications?format=json","message":"OCA\\Files_Sharing\\Activity\\Providers\\Downloads::parse() threw \\InvalidArgumentException which is deprecated. Throw \\OCP\\Activity\\Exceptions\\UnknownActivityException when the event is not known to your provider and otherwise handle all \\InvalidArgumentException yourself.","userAgent":"Mozilla/5.0 (Windows) mirall/3.9.0stable-Win64 (build 20230613) (Nextcloud, windows-10.0.20348 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.1.1","data":{"app":"activity"}}
{"reqId":"uybeSq0y83LJYBlwzeG3","level":0,"time":"2024-10-14T12:00:56+00:00","remoteAddr":"***removed***","user":"***removed***","app":"activity","method":"GET","url":"/ocs/v2.php/apps/notifications/api/v2/notifications?format=json","message":"OCA\\Files_Sharing\\Activity\\Providers\\Groups::parse() threw \\InvalidArgumentException which is deprecated. Throw \\OCP\\Activity\\Exceptions\\UnknownActivityException when the event is not known to your provider and otherwise handle all \\InvalidArgumentException yourself.","userAgent":"Mozilla/5.0 (Windows) mirall/3.9.0stable-Win64 (build 20230613) (Nextcloud, windows-10.0.20348 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.1.1","data":{"app":"activity"}}
{"reqId":"uybeSq0y83LJYBlwzeG3","level":0,"time":"2024-10-14T12:00:56+00:00","remoteAddr":"***removed***","user":"***removed***","app":"activity","method":"GET","url":"/ocs/v2.php/apps/notifications/api/v2/notifications?format=json","message":"OCA\\Files_Sharing\\Activity\\Providers\\PublicLinks::parse() threw \\InvalidArgumentException which is deprecated. Throw \\OCP\\Activity\\Exceptions\\UnknownActivityException when the event is not known to your provider and otherwise handle all \\InvalidArgumentException yourself.","userAgent":"Mozilla/5.0 (Windows) mirall/3.9.0stable-Win64 (build 20230613) (Nextcloud, windows-10.0.20348 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.1.1","data":{"app":"activity"}}
{"reqId":"uybeSq0y83LJYBlwzeG3","level":0,"time":"2024-10-14T12:00:56+00:00","remoteAddr":"***removed***","user":"***removed***","app":"activity","method":"GET","url":"/ocs/v2.php/apps/notifications/api/v2/notifications?format=json","message":"OCA\\Files_Sharing\\Activity\\Providers\\RemoteShares::parse() threw \\InvalidArgumentException which is deprecated. Throw \\OCP\\Activity\\Exceptions\\UnknownActivityException when the event is not known to your provider and otherwise handle all \\InvalidArgumentException yourself.","userAgent":"Mozilla/5.0 (Windows) mirall/3.9.0stable-Win64 (build 20230613) (Nextcloud, windows-10.0.20348 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.1.1","data":{"app":"activity"}}
{"reqId":"uybeSq0y83LJYBlwzeG3","level":0,"time":"2024-10-14T12:00:56+00:00","remoteAddr":"***removed***","user":"***removed***","app":"activity","method":"GET","url":"/ocs/v2.php/apps/notifications/api/v2/notifications?format=json","message":"OCA\\ShareByMail\\Activity::parse() threw \\InvalidArgumentException which is deprecated. Throw \\OCP\\Activity\\Exceptions\\UnknownActivityException when the event is not known to your provider and otherwise handle all \\InvalidArgumentException yourself.","userAgent":"Mozilla/5.0 (Windows) mirall/3.9.0stable-Win64 (build 20230613) (Nextcloud, windows-10.0.20348 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.1.1","data":{"app":"activity"}}
{"reqId":"uybeSq0y83LJYBlwzeG3","level":0,"time":"2024-10-14T12:00:56+00:00","remoteAddr":"***removed***","user":"***removed***","app":"activity","method":"GET","url":"/ocs/v2.php/apps/notifications/api/v2/notifications?format=json","message":"OCA\\SystemTags\\Activity\\Provider::parse() threw \\InvalidArgumentException which is deprecated. Throw \\OCP\\Activity\\Exceptions\\UnknownActivityException when the event is not known to your provider and otherwise handle all \\InvalidArgumentException yourself.","userAgent":"Mozilla/5.0 (Windows) mirall/3.9.0stable-Win64 (build 20230613) (Nextcloud, windows-10.0.20348 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.1.1","data":{"app":"activity"}}
{"reqId":"uybeSq0y83LJYBlwzeG3","level":0,"time":"2024-10-14T12:00:56+00:00","remoteAddr":"***removed***","user":"***removed***","app":"activity","method":"GET","url":"/ocs/v2.php/apps/notifications/api/v2/notifications?format=json","message":"OCA\\TwoFactorBackupCodes\\Activity\\Provider::parse() threw \\InvalidArgumentException which is deprecated. Throw \\OCP\\Activity\\Exceptions\\UnknownActivityException when the event is not known to your provider and otherwise handle all \\InvalidArgumentException yourself.","userAgent":"Mozilla/5.0 (Windows) mirall/3.9.0stable-Win64 (build 20230613) (Nextcloud, windows-10.0.20348 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.1.1","data":{"app":"activity"}}
{"reqId":"uybeSq0y83LJYBlwzeG3","level":0,"time":"2024-10-14T12:00:56+00:00","remoteAddr":"***removed***","user":"***removed***","app":"no app in context","method":"GET","url":"/ocs/v2.php/apps/notifications/api/v2/notifications?format=json","message":"OCA\\NotifyPush\\Listener::prepare() threw \\InvalidArgumentException which is deprecated. Throw \\OCP\\Notification\\UnknownNotificationException when the notification is not known to your notifier and otherwise handle all \\InvalidArgumentException yourself.","userAgent":"Mozilla/5.0 (Windows) mirall/3.9.0stable-Win64 (build 20230613) (Nextcloud, windows-10.0.20348 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.1.1","data":[]}
{"reqId":"YZBHO10FI6obe4wFFdVs","level":0,"time":"2024-10-14T12:00:16+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT `fileid` FROM `*PREFIX*filecache` WHERE (`storage` = :dcValue1) AND (`path_hash` = :dcValue2)","userAgent":"--","version":"30.0.1.1","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `fileid` FROM `*PREFIX*filecache` WHERE (`storage` = :dcValue1) AND (`path_hash` = :dcValue2)","Code":0,"Trace":[{"file":"/var/www/html/nextcloud/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":289,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/ExtendedQueryBuilder.php","line":285,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/ExtendedQueryBuilder.php","line":53,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\ExtendedQueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/Cache/Cache.php","line":471,"function":"execute","class":"OC\\DB\\QueryBuilder\\ExtendedQueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/Cache/Cache.php","line":489,"function":"getId","class":"OC\\Files\\Cache\\Cache","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/Cache/Updater.php","line":238,"function":"getParentId","class":"OC\\Files\\Cache\\Cache","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/Cache/Updater.php","line":148,"function":"correctParentStorageMtime","class":"OC\\Files\\Cache\\Updater","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/View.php","line":265,"function":"remove","class":"OC\\Files\\Cache\\Updater","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/View.php","line":1148,"function":"removeUpdate","class":"OC\\Files\\View","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/View.php","line":286,"function":"basicOperation","class":"OC\\Files\\View","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/Node/Folder.php","line":374,"function":"rmdir","class":"OC\\Files\\View","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/SimpleFS/SimpleFolder.php","line":48,"function":"delete","class":"OC\\Files\\Node\\Folder","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Preview/BackgroundCleanupJob.php","line":52,"function":"delete","class":"OC\\Files\\SimpleFS\\SimpleFolder","type":"->"},{"file":"/var/www/html/nextcloud/lib/public/BackgroundJob/Job.php","line":61,"function":"run","class":"OC\\Preview\\BackgroundCleanupJob","type":"->"},{"file":"/var/www/html/nextcloud/lib/public/BackgroundJob/TimedJob.php","line":83,"function":"start","class":"OCP\\BackgroundJob\\Job","type":"->"},{"file":"/var/www/html/nextcloud/lib/public/BackgroundJob/TimedJob.php","line":73,"function":"start","class":"OCP\\BackgroundJob\\TimedJob","type":"->"},{"file":"/var/www/html/nextcloud/cron.php","line":162,"function":"execute","class":"OCP\\BackgroundJob\\TimedJob","type":"->"}],"File":"/var/www/html/nextcloud/lib/private/DB/Connection.php","Line":402,"message":"dirty table reads: SELECT `fileid` FROM `*PREFIX*filecache` WHERE (`storage` = :dcValue1) AND (`path_hash` = :dcValue2)","tables":["oc_appconfig","oc_jobs","oc_user_status","oc_notifications_settings","oc_filecache","oc_notes_meta","oc_filecache_extended","oc_files_metadata","oc_files_metadata_index"],"reads":["oc_filecache"],"exception":{},"CustomMessage":"dirty table reads: SELECT `fileid` FROM `*PREFIX*filecache` WHERE (`storage` = :dcValue1) AND (`path_hash` = :dcValue2)"}}
{"reqId":"YZBHO10FI6obe4wFFdVs","level":0,"time":"2024-10-14T12:00:16+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT `path` FROM `*PREFIX*filecache` WHERE (`storage` = :dcValue1) AND (`fileid` = :dcValue2)","userAgent":"--","version":"30.0.1.1","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `path` FROM `*PREFIX*filecache` WHERE (`storage` = :dcValue1) AND (`fileid` = :dcValue2)","Code":0,"Trace":[{"file":"/var/www/html/nextcloud/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":289,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/ExtendedQueryBuilder.php","line":285,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/ExtendedQueryBuilder.php","line":53,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\ExtendedQueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/Cache/Cache.php","line":1098,"function":"execute","class":"OC\\DB\\QueryBuilder\\ExtendedQueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/Cache/Cache.php","line":393,"function":"getPathById","class":"OC\\Files\\Cache\\Cache","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/Cache/Updater.php","line":244,"function":"update","class":"OC\\Files\\Cache\\Cache","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/nextcloud/lib/private/Files/Cache/Updater.php","line":148,"function":"correctParentStorageMtime","class":"OC\\Files\\Cache\\Updater","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/View.php","line":265,"function":"remove","class":"OC\\Files\\Cache\\Updater","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/View.php","line":1148,"function":"removeUpdate","class":"OC\\Files\\View","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/View.php","line":286,"function":"basicOperation","class":"OC\\Files\\View","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/Node/Folder.php","line":374,"function":"rmdir","class":"OC\\Files\\View","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/SimpleFS/SimpleFolder.php","line":48,"function":"delete","class":"OC\\Files\\Node\\Folder","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Preview/BackgroundCleanupJob.php","line":52,"function":"delete","class":"OC\\Files\\SimpleFS\\SimpleFolder","type":"->"},{"file":"/var/www/html/nextcloud/lib/public/BackgroundJob/Job.php","line":61,"function":"run","class":"OC\\Preview\\BackgroundCleanupJob","type":"->"},{"file":"/var/www/html/nextcloud/lib/public/BackgroundJob/TimedJob.php","line":83,"function":"start","class":"OCP\\BackgroundJob\\Job","type":"->"},{"file":"/var/www/html/nextcloud/lib/public/BackgroundJob/TimedJob.php","line":73,"function":"start","class":"OCP\\BackgroundJob\\TimedJob","type":"->"},{"file":"/var/www/html/nextcloud/cron.php","line":162,"function":"execute","class":"OCP\\BackgroundJob\\TimedJob","type":"->"}],"File":"/var/www/html/nextcloud/lib/private/DB/Connection.php","Line":402,"message":"dirty table reads: SELECT `path` FROM `*PREFIX*filecache` WHERE (`storage` = :dcValue1) AND (`fileid` = :dcValue2)","tables":["oc_appconfig","oc_jobs","oc_user_status","oc_notifications_settings","oc_filecache","oc_notes_meta","oc_filecache_extended","oc_files_metadata","oc_files_metadata_index"],"reads":["oc_filecache"],"exception":{},"CustomMessage":"dirty table reads: SELECT `path` FROM `*PREFIX*filecache` WHERE (`storage` = :dcValue1) AND (`fileid` = :dcValue2)"}}
{"reqId":"YZBHO10FI6obe4wFFdVs","level":0,"time":"2024-10-14T12:00:16+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT `filecache`.`fileid`, `storage`, `path`, `path_hash`, `filecache`.`parent`, `filecache`.`name`, `mimetype`, `mimepart`, `size`, `mtime`, `storage_mtime`, `encrypted`, `etag`, `filecache`.`permissions`, `checksum`, `unencrypted_size`, `metadata_etag`, `creation_time`, `upload_time`, `meta`.`json` AS `meta_json`, `meta`.`sync_token` AS `meta_sync_token` FROM `*PREFIX*filecache` `filecache` LEFT JOIN `*PREFIX*filecache_extended` `fe` ON `filecache`.`fileid` = `fe`.`fileid` LEFT JOIN `*PREFIX*files_metadata` `meta` ON `filecache`.`fileid` = `meta`.`file_id` WHERE (`path_hash` = :dcValue1) AND (`storage` = :dcValue2)","userAgent":"--","version":"30.0.1.1","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `filecache`.`fileid`, `storage`, `path`, `path_hash`, `filecache`.`parent`, `filecache`.`name`, `mimetype`, `mimepart`, `size`, `mtime`, `storage_mtime`, `encrypted`, `etag`, `filecache`.`permissions`, `checksum`, `unencrypted_size`, `metadata_etag`, `creation_time`, `upload_time`, `meta`.`json` AS `meta_json`, `meta`.`sync_token` AS `meta_sync_token` FROM `*PREFIX*filecache` `filecache` LEFT JOIN `*PREFIX*filecache_extended` `fe` ON `filecache`.`fileid` = `fe`.`fileid` LEFT JOIN `*PREFIX*files_metadata` `meta` ON `filecache`.`fileid` = `meta`.`file_id` WHERE (`path_hash` = :dcValue1) AND (`storage` = :dcValue2)","Code":0,"Trace":[{"file":"/var/www/html/nextcloud/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":289,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/ExtendedQueryBuilder.php","line":285,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/ExtendedQueryBuilder.php","line":53,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\ExtendedQueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/Cache/Cache.php","line":130,"function":"execute","class":"OC\\DB\\QueryBuilder\\ExtendedQueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/View.php","line":1301,"function":"get","class":"OC\\Files\\Cache\\Cache","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/View.php","line":1348,"function":"getCacheEntry","class":"OC\\Files\\View","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/Node/Root.php","line":183,"function":"getFileInfo","class":"OC\\Files\\View","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/Node/LazyFolder.php","line":141,"function":"get","class":"OC\\Files\\Node\\Root","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/AppData/AppData.php","line":114,"function":"get","class":"OC\\Files\\Node\\LazyFolder","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Preview/Storage/Root.php","line":30,"function":"getFolder","class":"OC\\Files\\AppData\\AppData","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Preview/BackgroundCleanupJob.php","line":51,"function":"getFolder","class":"OC\\Preview\\Storage\\Root","type":"->"},{"file":"/var/www/html/nextcloud/lib/public/BackgroundJob/Job.php","line":61,"function":"run","class":"OC\\Preview\\BackgroundCleanupJob","type":"->"},{"file":"/var/www/html/nextcloud/lib/public/BackgroundJob/TimedJob.php","line":83,"function":"start","class":"OCP\\BackgroundJob\\Job","type":"->"},{"file":"/var/www/html/nextcloud/lib/public/BackgroundJob/TimedJob.php","line":73,"function":"start","class":"OCP\\BackgroundJob\\TimedJob","type":"->"},{"file":"/var/www/html/nextcloud/cron.php","line":162,"function":"execute","class":"OCP\\BackgroundJob\\TimedJob","type":"->"}],"File":"/var/www/html/nextcloud/lib/private/DB/Connection.php","Line":402,"message":"dirty table reads: SELECT `filecache`.`fileid`, `storage`, `path`, `path_hash`, `filecache`.`parent`, `filecache`.`name`, `mimetype`, `mimepart`, `size`, `mtime`, `storage_mtime`, `encrypted`, `etag`, `filecache`.`permissions`, `checksum`, `unencrypted_size`, `metadata_etag`, `creation_time`, `upload_time`, `meta`.`json` AS `meta_json`, `meta`.`sync_token` AS `meta_sync_token` FROM `*PREFIX*filecache` `filecache` LEFT JOIN `*PREFIX*filecache_extended` `fe` ON `filecache`.`fileid` = `fe`.`fileid` LEFT JOIN `*PREFIX*files_metadata` `meta` ON `filecache`.`fileid` = `meta`.`file_id` WHERE (`path_hash` = :dcValue1) AND (`storage` = :dcValue2)","tables":["oc_appconfig","oc_jobs","oc_user_status","oc_notifications_settings","oc_filecache","oc_notes_meta","oc_filecache_extended","oc_files_metadata","oc_files_metadata_index"],"reads":["oc_filecache","oc_filecache_extended","oc_files_metadata"],"exception":{},"CustomMessage":"dirty table reads: SELECT `filecache`.`fileid`, `storage`, `path`, `path_hash`, `filecache`.`parent`, `filecache`.`name`, `mimetype`, `mimepart`, `size`, `mtime`, `storage_mtime`, `encrypted`, `etag`, `filecache`.`permissions`, `checksum`, `unencrypted_size`, `metadata_etag`, `creation_time`, `upload_time`, `meta`.`json` AS `meta_json`, `meta`.`sync_token` AS `meta_sync_token` FROM `*PREFIX*filecache` `filecache` LEFT JOIN `*PREFIX*filecache_extended` `fe` ON `filecache`.`fileid` = `fe`.`fileid` LEFT JOIN `*PREFIX*files_metadata` `meta` ON `filecache`.`fileid` = `meta`.`file_id` WHERE (`path_hash` = :dcValue1) AND (`storage` = :dcValue2)"}}
{"reqId":"YZBHO10FI6obe4wFFdVs","level":0,"time":"2024-10-14T12:00:16+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT `filecache`.`fileid`, `storage`, `path`, `path_hash`, `filecache`.`parent`, `filecache`.`name`, `mimetype`, `mimepart`, `size`, `mtime`, `storage_mtime`, `encrypted`, `etag`, `filecache`.`permissions`, `checksum`, `unencrypted_size`, `metadata_etag`, `creation_time`, `upload_time`, `meta`.`json` AS `meta_json`, `meta`.`sync_token` AS `meta_sync_token` FROM `*PREFIX*filecache` `filecache` LEFT JOIN `*PREFIX*filecache_extended` `fe` ON `filecache`.`fileid` = `fe`.`fileid` LEFT JOIN `*PREFIX*files_metadata` `meta` ON `filecache`.`fileid` = `meta`.`file_id` WHERE (`path_hash` = :dcValue1) AND (`storage` = :dcValue2)","userAgent":"--","version":"30.0.1.1","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `filecache`.`fileid`, `storage`, `path`, `path_hash`, `filecache`.`parent`, `filecache`.`name`, `mimetype`, `mimepart`, `size`, `mtime`, `storage_mtime`, `encrypted`, `etag`, `filecache`.`permissions`, `checksum`, `unencrypted_size`, `metadata_etag`, `creation_time`, `upload_time`, `meta`.`json` AS `meta_json`, `meta`.`sync_token` AS `meta_sync_token` FROM `*PREFIX*filecache` `filecache` LEFT JOIN `*PREFIX*filecache_extended` `fe` ON `filecache`.`fileid` = `fe`.`fileid` LEFT JOIN `*PREFIX*files_metadata` `meta` ON `filecache`.`fileid` = `meta`.`file_id` WHERE (`path_hash` = :dcValue1) AND (`storage` = :dcValue2)","Code":0,"Trace":[{"file":"/var/www/html/nextcloud/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":289,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/ExtendedQueryBuilder.php","line":285,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/ExtendedQueryBuilder.php","line":53,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\ExtendedQueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/Cache/Cache.php","line":130,"function":"execute","class":"OC\\DB\\QueryBuilder\\ExtendedQueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/Cache/Updater.php","line":144,"function":"get","class":"OC\\Files\\Cache\\Cache","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/View.php","line":265,"function":"remove","class":"OC\\Files\\Cache\\Updater","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/View.php","line":1148,"function":"removeUpdate","class":"OC\\Files\\View","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/View.php","line":286,"function":"basicOperation","class":"OC\\Files\\View","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/Node/Folder.php","line":374,"function":"rmdir","class":"OC\\Files\\View","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/SimpleFS/SimpleFolder.php","line":48,"function":"delete","class":"OC\\Files\\Node\\Folder","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Preview/BackgroundCleanupJob.php","line":52,"function":"delete","class":"OC\\Files\\SimpleFS\\SimpleFolder","type":"->"},{"file":"/var/www/html/nextcloud/lib/public/BackgroundJob/Job.php","line":61,"function":"run","class":"OC\\Preview\\BackgroundCleanupJob","type":"->"},{"file":"/var/www/html/nextcloud/lib/public/BackgroundJob/TimedJob.php","line":83,"function":"start","class":"OCP\\BackgroundJob\\Job","type":"->"},{"file":"/var/www/html/nextcloud/lib/public/BackgroundJob/TimedJob.php","line":73,"function":"start","class":"OCP\\BackgroundJob\\TimedJob","type":"->"},{"file":"/var/www/html/nextcloud/cron.php","line":162,"function":"execute","class":"OCP\\BackgroundJob\\TimedJob","type":"->"}],"File":"/var/www/html/nextcloud/lib/private/DB/Connection.php","Line":402,"message":"dirty table reads: SELECT `filecache`.`fileid`, `storage`, `path`, `path_hash`, `filecache`.`parent`, `filecache`.`name`, `mimetype`, `mimepart`, `size`, `mtime`, `storage_mtime`, `encrypted`, `etag`, `filecache`.`permissions`, `checksum`, `unencrypted_size`, `metadata_etag`, `creation_time`, `upload_time`, `meta`.`json` AS `meta_json`, `meta`.`sync_token` AS `meta_sync_token` FROM `*PREFIX*filecache` `filecache` LEFT JOIN `*PREFIX*filecache_extended` `fe` ON `filecache`.`fileid` = `fe`.`fileid` LEFT JOIN `*PREFIX*files_metadata` `meta` ON `filecache`.`fileid` = `meta`.`file_id` WHERE (`path_hash` = :dcValue1) AND (`storage` = :dcValue2)","tables":["oc_appconfig","oc_jobs","oc_user_status","oc_notifications_settings","oc_filecache","oc_notes_meta","oc_filecache_extended","oc_files_metadata","oc_files_metadata_index"],"reads":["oc_filecache","oc_filecache_extended","oc_files_metadata"],"exception":{},"CustomMessage":"dirty table reads: SELECT `filecache`.`fileid`, `storage`, `path`, `path_hash`, `filecache`.`parent`, `filecache`.`name`, `mimetype`, `mimepart`, `size`, `mtime`, `storage_mtime`, `encrypted`, `etag`, `filecache`.`permissions`, `checksum`, `unencrypted_size`, `metadata_etag`, `creation_time`, `upload_time`, `meta`.`json` AS `meta_json`, `meta`.`sync_token` AS `meta_sync_token` FROM `*PREFIX*filecache` `filecache` LEFT JOIN `*PREFIX*filecache_extended` `fe` ON `filecache`.`fileid` = `fe`.`fileid` LEFT JOIN `*PREFIX*files_metadata` `meta` ON `filecache`.`fileid` = `meta`.`file_id` WHERE (`path_hash` = :dcValue1) AND (`storage` = :dcValue2)"}}
{"reqId":"YZBHO10FI6obe4wFFdVs","level":0,"time":"2024-10-14T12:00:16+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT `filecache`.`fileid`, `storage`, `path`, `path_hash`, `filecache`.`parent`, `filecache`.`name`, `mimetype`, `mimepart`, `size`, `mtime`, `storage_mtime`, `encrypted`, `etag`, `filecache`.`permissions`, `checksum`, `unencrypted_size`, `metadata_etag`, `creation_time`, `upload_time`, `meta`.`json` AS `meta_json`, `meta`.`sync_token` AS `meta_sync_token` FROM `*PREFIX*filecache` `filecache` LEFT JOIN `*PREFIX*filecache_extended` `fe` ON `filecache`.`fileid` = `fe`.`fileid` LEFT JOIN `*PREFIX*files_metadata` `meta` ON `filecache`.`fileid` = `meta`.`file_id` WHERE (`path_hash` = :dcValue1) AND (`storage` = :dcValue2)","userAgent":"--","version":"30.0.1.1","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `filecache`.`fileid`, `storage`, `path`, `path_hash`, `filecache`.`parent`, `filecache`.`name`, `mimetype`, `mimepart`, `size`, `mtime`, `storage_mtime`, `encrypted`, `etag`, `filecache`.`permissions`, `checksum`, `unencrypted_size`, `metadata_etag`, `creation_time`, `upload_time`, `meta`.`json` AS `meta_json`, `meta`.`sync_token` AS `meta_sync_token` FROM `*PREFIX*filecache` `filecache` LEFT JOIN `*PREFIX*filecache_extended` `fe` ON `filecache`.`fileid` = `fe`.`fileid` LEFT JOIN `*PREFIX*files_metadata` `meta` ON `filecache`.`fileid` = `meta`.`file_id` WHERE (`path_hash` = :dcValue1) AND (`storage` = :dcValue2)","Code":0,"Trace":[{"file":"/var/www/html/nextcloud/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":289,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/ExtendedQueryBuilder.php","line":285,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/ExtendedQueryBuilder.php","line":53,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\ExtendedQueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/Cache/Cache.php","line":130,"function":"execute","class":"OC\\DB\\QueryBuilder\\ExtendedQueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/Cache/Cache.php","line":519,"function":"get","class":"OC\\Files\\Cache\\Cache","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/Cache/Updater.php","line":146,"function":"remove","class":"OC\\Files\\Cache\\Cache","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/View.php","line":265,"function":"remove","class":"OC\\Files\\Cache\\Updater","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/View.php","line":1148,"function":"removeUpdate","class":"OC\\Files\\View","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/View.php","line":286,"function":"basicOperation","class":"OC\\Files\\View","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/Node/Folder.php","line":374,"function":"rmdir","class":"OC\\Files\\View","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/SimpleFS/SimpleFolder.php","line":48,"function":"delete","class":"OC\\Files\\Node\\Folder","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Preview/BackgroundCleanupJob.php","line":52,"function":"delete","class":"OC\\Files\\SimpleFS\\SimpleFolder","type":"->"},{"file":"/var/www/html/nextcloud/lib/public/BackgroundJob/Job.php","line":61,"function":"run","class":"OC\\Preview\\BackgroundCleanupJob","type":"->"},{"file":"/var/www/html/nextcloud/lib/public/BackgroundJob/TimedJob.php","line":83,"function":"start","class":"OCP\\BackgroundJob\\Job","type":"->"},{"file":"/var/www/html/nextcloud/lib/public/BackgroundJob/TimedJob.php","line":73,"function":"start","class":"OCP\\BackgroundJob\\TimedJob","type":"->"},{"file":"/var/www/html/nextcloud/cron.php","line":162,"function":"execute","class":"OCP\\BackgroundJob\\TimedJob","type":"->"}],"File":"/var/www/html/nextcloud/lib/private/DB/Connection.php","Line":402,"message":"dirty table reads: SELECT `filecache`.`fileid`, `storage`, `path`, `path_hash`, `filecache`.`parent`, `filecache`.`name`, `mimetype`, `mimepart`, `size`, `mtime`, `storage_mtime`, `encrypted`, `etag`, `filecache`.`permissions`, `checksum`, `unencrypted_size`, `metadata_etag`, `creation_time`, `upload_time`, `meta`.`json` AS `meta_json`, `meta`.`sync_token` AS `meta_sync_token` FROM `*PREFIX*filecache` `filecache` LEFT JOIN `*PREFIX*filecache_extended` `fe` ON `filecache`.`fileid` = `fe`.`fileid` LEFT JOIN `*PREFIX*files_metadata` `meta` ON `filecache`.`fileid` = `meta`.`file_id` WHERE (`path_hash` = :dcValue1) AND (`storage` = :dcValue2)","tables":["oc_appconfig","oc_jobs","oc_user_status","oc_notifications_settings","oc_filecache","oc_notes_meta","oc_filecache_extended","oc_files_metadata","oc_files_metadata_index"],"reads":["oc_filecache","oc_filecache_extended","oc_files_metadata"],"exception":{},"CustomMessage":"dirty table reads: SELECT `filecache`.`fileid`, `storage`, `path`, `path_hash`, `filecache`.`parent`, `filecache`.`name`, `mimetype`, `mimepart`, `size`, `mtime`, `storage_mtime`, `encrypted`, `etag`, `filecache`.`permissions`, `checksum`, `unencrypted_size`, `metadata_etag`, `creation_time`, `upload_time`, `meta`.`json` AS `meta_json`, `meta`.`sync_token` AS `meta_sync_token` FROM `*PREFIX*filecache` `filecache` LEFT JOIN `*PREFIX*filecache_extended` `fe` ON `filecache`.`fileid` = `fe`.`fileid` LEFT JOIN `*PREFIX*files_metadata` `meta` ON `filecache`.`fileid` = `meta`.`file_id` WHERE (`path_hash` = :dcValue1) AND (`storage` = :dcValue2)"}}
{"reqId":"YZBHO10FI6obe4wFFdVs","level":0,"time":"2024-10-14T12:00:16+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT `filecache`.`fileid`, `storage`, `path`, `path_hash`, `filecache`.`parent`, `filecache`.`name`, `mimetype`, `mimepart`, `size`, `mtime`, `storage_mtime`, `encrypted`, `etag`, `filecache`.`permissions`, `checksum`, `unencrypted_size`, `metadata_etag`, `creation_time`, `upload_time`, `meta`.`json` AS `meta_json`, `meta`.`sync_token` AS `meta_sync_token` FROM `*PREFIX*filecache` `filecache` LEFT JOIN `*PREFIX*filecache_extended` `fe` ON `filecache`.`fileid` = `fe`.`fileid` LEFT JOIN `*PREFIX*files_metadata` `meta` ON `filecache`.`fileid` = `meta`.`file_id` WHERE (`filecache`.`parent` = :dcValue1) AND (`storage` = :dcValue2) ORDER BY `name` ASC","userAgent":"--","version":"30.0.1.1","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `filecache`.`fileid`, `storage`, `path`, `path_hash`, `filecache`.`parent`, `filecache`.`name`, `mimetype`, `mimepart`, `size`, `mtime`, `storage_mtime`, `encrypted`, `etag`, `filecache`.`permissions`, `checksum`, `unencrypted_size`, `metadata_etag`, `creation_time`, `upload_time`, `meta`.`json` AS `meta_json`, `meta`.`sync_token` AS `meta_sync_token` FROM `*PREFIX*filecache` `filecache` LEFT JOIN `*PREFIX*filecache_extended` `fe` ON `filecache`.`fileid` = `fe`.`fileid` LEFT JOIN `*PREFIX*files_metadata` `meta` ON `filecache`.`fileid` = `meta`.`file_id` WHERE (`filecache`.`parent` = :dcValue1) AND (`storage` = :dcValue2) ORDER BY `name` ASC","Code":0,"Trace":[{"file":"/var/www/html/nextcloud/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":289,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/ExtendedQueryBuilder.php","line":285,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/ExtendedQueryBuilder.php","line":53,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\ExtendedQueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/Cache/Cache.php","line":208,"function":"execute","class":"OC\\DB\\QueryBuilder\\ExtendedQueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/Cache/Cache.php","line":557,"function":"getFolderContentsById","class":"OC\\Files\\Cache\\Cache","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/Cache/Cache.php","line":535,"function":"removeChildren","class":"OC\\Files\\Cache\\Cache","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/Cache/Updater.php","line":146,"function":"remove","class":"OC\\Files\\Cache\\Cache","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/View.php","line":265,"function":"remove","class":"OC\\Files\\Cache\\Updater","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/View.php","line":1148,"function":"removeUpdate","class":"OC\\Files\\View","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/View.php","line":286,"function":"basicOperation","class":"OC\\Files\\View","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/Node/Folder.php","line":374,"function":"rmdir","class":"OC\\Files\\View","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/SimpleFS/SimpleFolder.php","line":48,"function":"delete","class":"OC\\Files\\Node\\Folder","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Preview/BackgroundCleanupJob.php","line":52,"function":"delete","class":"OC\\Files\\SimpleFS\\SimpleFolder","type":"->"},{"file":"/var/www/html/nextcloud/lib/public/BackgroundJob/Job.php","line":61,"function":"run","class":"OC\\Preview\\BackgroundCleanupJob","type":"->"},{"file":"/var/www/html/nextcloud/lib/public/BackgroundJob/TimedJob.php","line":83,"function":"start","class":"OCP\\BackgroundJob\\Job","type":"->"},{"file":"/var/www/html/nextcloud/lib/public/BackgroundJob/TimedJob.php","line":73,"function":"start","class":"OCP\\BackgroundJob\\TimedJob","type":"->"},{"file":"/var/www/html/nextcloud/cron.php","line":162,"function":"execute","class":"OCP\\BackgroundJob\\TimedJob","type":"->"}],"File":"/var/www/html/nextcloud/lib/private/DB/Connection.php","Line":402,"message":"dirty table reads: SELECT `filecache`.`fileid`, `storage`, `path`, `path_hash`, `filecache`.`parent`, `filecache`.`name`, `mimetype`, `mimepart`, `size`, `mtime`, `storage_mtime`, `encrypted`, `etag`, `filecache`.`permissions`, `checksum`, `unencrypted_size`, `metadata_etag`, `creation_time`, `upload_time`, `meta`.`json` AS `meta_json`, `meta`.`sync_token` AS `meta_sync_token` FROM `*PREFIX*filecache` `filecache` LEFT JOIN `*PREFIX*filecache_extended` `fe` ON `filecache`.`fileid` = `fe`.`fileid` LEFT JOIN `*PREFIX*files_metadata` `meta` ON `filecache`.`fileid` = `meta`.`file_id` WHERE (`filecache`.`parent` = :dcValue1) AND (`storage` = :dcValue2) ORDER BY `name` ASC","tables":["oc_appconfig","oc_jobs","oc_user_status","oc_notifications_settings","oc_filecache","oc_notes_meta","oc_filecache_extended","oc_files_metadata","oc_files_metadata_index"],"reads":["oc_filecache","oc_filecache_extended","oc_files_metadata"],"exception":{},"CustomMessage":"dirty table reads: SELECT `filecache`.`fileid`, `storage`, `path`, `path_hash`, `filecache`.`parent`, `filecache`.`name`, `mimetype`, `mimepart`, `size`, `mtime`, `storage_mtime`, `encrypted`, `etag`, `filecache`.`permissions`, `checksum`, `unencrypted_size`, `metadata_etag`, `creation_time`, `upload_time`, `meta`.`json` AS `meta_json`, `meta`.`sync_token` AS `meta_sync_token` FROM `*PREFIX*filecache` `filecache` LEFT JOIN `*PREFIX*filecache_extended` `fe` ON `filecache`.`fileid` = `fe`.`fileid` LEFT JOIN `*PREFIX*files_metadata` `meta` ON `filecache`.`fileid` = `meta`.`file_id` WHERE (`filecache`.`parent` = :dcValue1) AND (`storage` = :dcValue2) ORDER BY `name` ASC"}}
{"reqId":"azeodQ6GD4j7oyDX0ncG","level":0,"time":"2024-10-14T12:00:53+00:00","remoteAddr":"***removed***","user":"***removed***","app":"no app in context","method":"PROPFIND","url":"/remote.php/dav/files/***removed***/***removed***","message":"dirty table reads: SELECT `filecache`.`fileid`, `storage`, `path`, `path_hash`, `filecache`.`parent`, `filecache`.`name`, `mimetype`, `mimepart`, `size`, `mtime`, `storage_mtime`, `encrypted`, `etag`, `filecache`.`permissions`, `checksum`, `unencrypted_size`, `metadata_etag`, `creation_time`, `upload_time`, `meta`.`json` AS `meta_json`, `meta`.`sync_token` AS `meta_sync_token` FROM `*PREFIX*filecache` `filecache` LEFT JOIN `*PREFIX*filecache_extended` `fe` ON `filecache`.`fileid` = `fe`.`fileid` LEFT JOIN `*PREFIX*files_metadata` `meta` ON `filecache`.`fileid` = `meta`.`file_id` WHERE (`path_hash` = :dcValue1) AND (`storage` = :dcValue2)","userAgent":"Mozilla/5.0 (Windows) mirall/3.9.0stable-Win64 (build 20230613) (Nextcloud, windows-10.0.20348 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.1.1","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `filecache`.`fileid`, `storage`, `path`, `path_hash`, `filecache`.`parent`, `filecache`.`name`, `mimetype`, `mimepart`, `size`, `mtime`, `storage_mtime`, `encrypted`, `etag`, `filecache`.`permissions`, `checksum`, `unencrypted_size`, `metadata_etag`, `creation_time`, `upload_time`, `meta`.`json` AS `meta_json`, `meta`.`sync_token` AS `meta_sync_token` FROM `*PREFIX*filecache` `filecache` LEFT JOIN `*PREFIX*filecache_extended` `fe` ON `filecache`.`fileid` = `fe`.`fileid` LEFT JOIN `*PREFIX*files_metadata` `meta` ON `filecache`.`fileid` = `meta`.`file_id` WHERE (`path_hash` = :dcValue1) AND (`storage` = :dcValue2)","Code":0,"Trace":[{"file":"/var/www/html/nextcloud/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":289,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/ExtendedQueryBuilder.php","line":285,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/ExtendedQueryBuilder.php","line":53,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\ExtendedQueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/Cache/Cache.php","line":130,"function":"execute","class":"OC\\DB\\QueryBuilder\\ExtendedQueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/Cache/Wrapper/CacheWrapper.php","line":70,"function":"get","class":"OC\\Files\\Cache\\Cache","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/View.php","line":1318,"function":"get","class":"OC\\Files\\Cache\\Wrapper\\CacheWrapper","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/View.php","line":1348,"function":"getCacheEntry","class":"OC\\Files\\View","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/Directory.php","line":177,"function":"getFileInfo","class":"OC\\Files\\View","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Tree.php","line":95,"function":"getChild","class":"OCA\\DAV\\Connector\\Sabre\\Directory","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":971,"function":"getNodeForPath","class":"Sabre\\DAV\\Tree","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":1662,"function":"getPropertiesIteratorForPath","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":1647,"function":"writeMultiStatus","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php","line":346,"function":"generateMultiStatus","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"httpPropFind","class":"Sabre\\DAV\\CorePlugin","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":472,"function":"emit","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/Server.php","line":43,"function":"invokeMethod","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Server.php","line":370,"function":"start","class":"OCA\\DAV\\Connector\\Sabre\\Server","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/appinfo/v2/remote.php","line":19,"function":"exec","class":"OCA\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/remote.php","line":146,"args":["/var/www/html/nextcloud/apps/dav/appinfo/v2/remote.php"],"function":"require_once"}],"File":"/var/www/html/nextcloud/lib/private/DB/Connection.php","Line":402,"message":"dirty table reads: SELECT `filecache`.`fileid`, `storage`, `path`, `path_hash`, `filecache`.`parent`, `filecache`.`name`, `mimetype`, `mimepart`, `size`, `mtime`, `storage_mtime`, `encrypted`, `etag`, `filecache`.`permissions`, `checksum`, `unencrypted_size`, `metadata_etag`, `creation_time`, `upload_time`, `meta`.`json` AS `meta_json`, `meta`.`sync_token` AS `meta_sync_token` FROM `*PREFIX*filecache` `filecache` LEFT JOIN `*PREFIX*filecache_extended` `fe` ON `filecache`.`fileid` = `fe`.`fileid` LEFT JOIN `*PREFIX*files_metadata` `meta` ON `filecache`.`fileid` = `meta`.`file_id` WHERE (`path_hash` = :dcValue1) AND (`storage` = :dcValue2)","tables":["oc_filecache"],"reads":["oc_filecache","oc_filecache_extended","oc_files_metadata"],"exception":{},"CustomMessage":"dirty table reads: SELECT `filecache`.`fileid`, `storage`, `path`, `path_hash`, `filecache`.`parent`, `filecache`.`name`, `mimetype`, `mimepart`, `size`, `mtime`, `storage_mtime`, `encrypted`, `etag`, `filecache`.`permissions`, `checksum`, `unencrypted_size`, `metadata_etag`, `creation_time`, `upload_time`, `meta`.`json` AS `meta_json`, `meta`.`sync_token` AS `meta_sync_token` FROM `*PREFIX*filecache` `filecache` LEFT JOIN `*PREFIX*filecache_extended` `fe` ON `filecache`.`fileid` = `fe`.`fileid` LEFT JOIN `*PREFIX*files_metadata` `meta` ON `filecache`.`fileid` = `meta`.`file_id` WHERE (`path_hash` = :dcValue1) AND (`storage` = :dcValue2)"}}
{"reqId":"azeodQ6GD4j7oyDX0ncG","level":0,"time":"2024-10-14T12:00:53+00:00","remoteAddr":"***removed***","user":"***removed***","app":"no app in context","method":"PROPFIND","url":"/remote.php/dav/files/***removed***/***removed***","message":"dirty table reads: SELECT `filecache`.`fileid`, `storage`, `path`, `path_hash`, `filecache`.`parent`, `filecache`.`name`, `mimetype`, `mimepart`, `size`, `mtime`, `storage_mtime`, `encrypted`, `etag`, `filecache`.`permissions`, `checksum`, `unencrypted_size`, `metadata_etag`, `creation_time`, `upload_time`, `meta`.`json` AS `meta_json`, `meta`.`sync_token` AS `meta_sync_token` FROM `*PREFIX*filecache` `filecache` LEFT JOIN `*PREFIX*filecache_extended` `fe` ON `filecache`.`fileid` = `fe`.`fileid` LEFT JOIN `*PREFIX*files_metadata` `meta` ON `filecache`.`fileid` = `meta`.`file_id` WHERE (`filecache`.`parent` = :dcValue1) AND (`storage` = :dcValue2) ORDER BY `name` ASC","userAgent":"Mozilla/5.0 (Windows) mirall/3.9.0stable-Win64 (build 20230613) (Nextcloud, windows-10.0.20348 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.1.1","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `filecache`.`fileid`, `storage`, `path`, `path_hash`, `filecache`.`parent`, `filecache`.`name`, `mimetype`, `mimepart`, `size`, `mtime`, `storage_mtime`, `encrypted`, `etag`, `filecache`.`permissions`, `checksum`, `unencrypted_size`, `metadata_etag`, `creation_time`, `upload_time`, `meta`.`json` AS `meta_json`, `meta`.`sync_token` AS `meta_sync_token` FROM `*PREFIX*filecache` `filecache` LEFT JOIN `*PREFIX*filecache_extended` `fe` ON `filecache`.`fileid` = `fe`.`fileid` LEFT JOIN `*PREFIX*files_metadata` `meta` ON `filecache`.`fileid` = `meta`.`file_id` WHERE (`filecache`.`parent` = :dcValue1) AND (`storage` = :dcValue2) ORDER BY `name` ASC","Code":0,"Trace":[{"file":"/var/www/html/nextcloud/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":289,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/ExtendedQueryBuilder.php","line":285,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/ExtendedQueryBuilder.php","line":53,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\ExtendedQueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/Cache/Cache.php","line":208,"function":"execute","class":"OC\\DB\\QueryBuilder\\ExtendedQueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/Cache/Wrapper/CacheWrapper.php","line":97,"function":"getFolderContentsById","class":"OC\\Files\\Cache\\Cache","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/View.php","line":1439,"function":"getFolderContentsById","class":"OC\\Files\\Cache\\Wrapper\\CacheWrapper","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/Node/Folder.php","line":81,"function":"getDirectoryContent","class":"OC\\Files\\View","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Share20/DefaultShareProvider.php","line":647,"function":"getDirectoryListing","class":"OC\\Files\\Node\\Folder","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Share20/Manager.php","line":1121,"function":"getSharesInFolder","class":"OC\\Share20\\DefaultShareProvider","type":"->"},{"function":"OC\\Share20\\{closure}","class":"OC\\Share20\\Manager","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/nextcloud/lib/private/Share20/Manager.php","line":1120,"function":"array_reduce"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/SharesPlugin.php","line":121,"function":"getSharesInFolder","class":"OC\\Share20\\Manager","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/SharesPlugin.php","line":185,"function":"getSharesFolder","class":"OCA\\DAV\\Connector\\Sabre\\SharesPlugin","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"handleGetProperties","class":"OCA\\DAV\\Connector\\Sabre\\SharesPlugin","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":1052,"function":"emit","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":984,"function":"getPropertiesByNode","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":1662,"function":"getPropertiesIteratorForPath","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":1647,"function":"writeMultiStatus","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php","line":346,"function":"generateMultiStatus","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"httpPropFind","class":"Sabre\\DAV\\CorePlugin","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":472,"function":"emit","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/Server.php","line":43,"function":"invokeMethod","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Server.php","line":370,"function":"start","class":"OCA\\DAV\\Connector\\Sabre\\Server","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/appinfo/v2/remote.php","line":19,"function":"exec","class":"OCA\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/remote.php","line":146,"args":["/var/www/html/nextcloud/apps/dav/appinfo/v2/remote.php"],"function":"require_once"}],"File":"/var/www/html/nextcloud/lib/private/DB/Connection.php","Line":402,"message":"dirty table reads: SELECT `filecache`.`fileid`, `storage`, `path`, `path_hash`, `filecache`.`parent`, `filecache`.`name`, `mimetype`, `mimepart`, `size`, `mtime`, `storage_mtime`, `encrypted`, `etag`, `filecache`.`permissions`, `checksum`, `unencrypted_size`, `metadata_etag`, `creation_time`, `upload_time`, `meta`.`json` AS `meta_json`, `meta`.`sync_token` AS `meta_sync_token` FROM `*PREFIX*filecache` `filecache` LEFT JOIN `*PREFIX*filecache_extended` `fe` ON `filecache`.`fileid` = `fe`.`fileid` LEFT JOIN `*PREFIX*files_metadata` `meta` ON `filecache`.`fileid` = `meta`.`file_id` WHERE (`filecache`.`parent` = :dcValue1) AND (`storage` = :dcValue2) ORDER BY `name` ASC","tables":["oc_filecache"],"reads":["oc_filecache","oc_filecache_extended","oc_files_metadata"],"exception":{},"CustomMessage":"dirty table reads: SELECT `filecache`.`fileid`, `storage`, `path`, `path_hash`, `filecache`.`parent`, `filecache`.`name`, `mimetype`, `mimepart`, `size`, `mtime`, `storage_mtime`, `encrypted`, `etag`, `filecache`.`permissions`, `checksum`, `unencrypted_size`, `metadata_etag`, `creation_time`, `upload_time`, `meta`.`json` AS `meta_json`, `meta`.`sync_token` AS `meta_sync_token` FROM `*PREFIX*filecache` `filecache` LEFT JOIN `*PREFIX*filecache_extended` `fe` ON `filecache`.`fileid` = `fe`.`fileid` LEFT JOIN `*PREFIX*files_metadata` `meta` ON `filecache`.`fileid` = `meta`.`file_id` WHERE (`filecache`.`parent` = :dcValue1) AND (`storage` = :dcValue2) ORDER BY `name` ASC"}}
{"reqId":"azeodQ6GD4j7oyDX0ncG","level":0,"time":"2024-10-14T12:00:53+00:00","remoteAddr":"***removed***","user":"***removed***","app":"no app in context","method":"PROPFIND","url":"/remote.php/dav/files/***removed***/***removed***","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` 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) OR (`share_type` = :dcValue4) OR (`share_type` = :dcValue5)) AND ((`uid_owner` = :dcValue6) OR (`uid_initiator` = :dcValue7)) AND ((`f`.`parent` = :dcValue8) OR (`f`.`fileid` IN (:chunk))) ORDER BY `id` ASC","userAgent":"Mozilla/5.0 (Windows) mirall/3.9.0stable-Win64 (build 20230613) (Nextcloud, windows-10.0.20348 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.1.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` 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) OR (`share_type` = :dcValue4) OR (`share_type` = :dcValue5)) AND ((`uid_owner` = :dcValue6) OR (`uid_initiator` = :dcValue7)) AND ((`f`.`parent` = :dcValue8) OR (`f`.`fileid` IN (:chunk))) ORDER BY `id` ASC","Code":0,"Trace":[{"file":"/var/www/html/nextcloud/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":289,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Share20/DefaultShareProvider.php","line":676,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Share20/Manager.php","line":1121,"function":"getSharesInFolder","class":"OC\\Share20\\DefaultShareProvider","type":"->"},{"function":"OC\\Share20\\{closure}","class":"OC\\Share20\\Manager","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/nextcloud/lib/private/Share20/Manager.php","line":1120,"function":"array_reduce"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/SharesPlugin.php","line":121,"function":"getSharesInFolder","class":"OC\\Share20\\Manager","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/SharesPlugin.php","line":185,"function":"getSharesFolder","class":"OCA\\DAV\\Connector\\Sabre\\SharesPlugin","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"handleGetProperties","class":"OCA\\DAV\\Connector\\Sabre\\SharesPlugin","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":1052,"function":"emit","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":984,"function":"getPropertiesByNode","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":1662,"function":"getPropertiesIteratorForPath","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":1647,"function":"writeMultiStatus","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php","line":346,"function":"generateMultiStatus","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"httpPropFind","class":"Sabre\\DAV\\CorePlugin","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":472,"function":"emit","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/Server.php","line":43,"function":"invokeMethod","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Server.php","line":370,"function":"start","class":"OCA\\DAV\\Connector\\Sabre\\Server","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/appinfo/v2/remote.php","line":19,"function":"exec","class":"OCA\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/remote.php","line":146,"args":["/var/www/html/nextcloud/apps/dav/appinfo/v2/remote.php"],"function":"require_once"}],"File":"/var/www/html/nextcloud/lib/private/DB/Connection.php","Line":402,"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` 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) OR (`share_type` = :dcValue4) OR (`share_type` = :dcValue5)) AND ((`uid_owner` = :dcValue6) OR (`uid_initiator` = :dcValue7)) AND ((`f`.`parent` = :dcValue8) OR (`f`.`fileid` IN (:chunk))) ORDER BY `id` ASC","tables":["oc_filecache"],"reads":["oc_share","oc_filecache"],"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` 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) OR (`share_type` = :dcValue4) OR (`share_type` = :dcValue5)) AND ((`uid_owner` = :dcValue6) OR (`uid_initiator` = :dcValue7)) AND ((`f`.`parent` = :dcValue8) OR (`f`.`fileid` IN (:chunk))) ORDER BY `id` ASC"}}
{"reqId":"azeodQ6GD4j7oyDX0ncG","level":0,"time":"2024-10-14T12:00:53+00:00","remoteAddr":"***removed***","user":"***removed***","app":"no app in context","method":"PROPFIND","url":"/remote.php/dav/files/***removed***/***removed***","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`.`parent` = :dcValue6) ORDER BY `id` ASC","userAgent":"Mozilla/5.0 (Windows) mirall/3.9.0stable-Win64 (build 20230613) (Nextcloud, windows-10.0.20348 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.1.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`.`parent` = :dcValue6) ORDER BY `id` ASC","Code":0,"Trace":[{"file":"/var/www/html/nextcloud/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":289,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":266,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/apps/federatedfilesharing/lib/FederatedShareProvider.php","line":586,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Share20/Manager.php","line":1121,"function":"getSharesInFolder","class":"OCA\\FederatedFileSharing\\FederatedShareProvider","type":"->"},{"function":"OC\\Share20\\{closure}","class":"OC\\Share20\\Manager","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/nextcloud/lib/private/Share20/Manager.php","line":1120,"function":"array_reduce"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/SharesPlugin.php","line":121,"function":"getSharesInFolder","class":"OC\\Share20\\Manager","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/SharesPlugin.php","line":185,"function":"getSharesFolder","class":"OCA\\DAV\\Connector\\Sabre\\SharesPlugin","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"handleGetProperties","class":"OCA\\DAV\\Connector\\Sabre\\SharesPlugin","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":1052,"function":"emit","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":984,"function":"getPropertiesByNode","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":1662,"function":"getPropertiesIteratorForPath","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":1647,"function":"writeMultiStatus","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php","line":346,"function":"generateMultiStatus","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"httpPropFind","class":"Sabre\\DAV\\CorePlugin","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":472,"function":"emit","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/Server.php","line":43,"function":"invokeMethod","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Server.php","line":370,"function":"start","class":"OCA\\DAV\\Connector\\Sabre\\Server","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/appinfo/v2/remote.php","line":19,"function":"exec","class":"OCA\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/remote.php","line":146,"args":["/var/www/html/nextcloud/apps/dav/appinfo/v2/remote.php"],"function":"require_once"}],"File":"/var/www/html/nextcloud/lib/private/DB/Connection.php","Line":402,"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`.`parent` = :dcValue6) 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`.`parent` = :dcValue6) ORDER BY `id` ASC"}}
{"reqId":"azeodQ6GD4j7oyDX0ncG","level":0,"time":"2024-10-14T12:00:53+00:00","remoteAddr":"***removed***","user":"***removed***","app":"no app in context","method":"PROPFIND","url":"/remote.php/dav/files/***removed***/***removed***","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`.`parent` = :dcValue6) ORDER BY `id` ASC","userAgent":"Mozilla/5.0 (Windows) mirall/3.9.0stable-Win64 (build 20230613) (Nextcloud, windows-10.0.20348 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.1.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`.`parent` = :dcValue6) ORDER BY `id` ASC","Code":0,"Trace":[{"file":"/var/www/html/nextcloud/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":289,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/html/nextcloud/apps/sharebymail/lib/ShareByMailProvider.php","line":1145,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Share20/Manager.php","line":1121,"function":"getSharesInFolder","class":"OCA\\ShareByMail\\ShareByMailProvider","type":"->"},{"function":"OC\\Share20\\{closure}","class":"OC\\Share20\\Manager","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/nextcloud/lib/private/Share20/Manager.php","line":1120,"function":"array_reduce"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/SharesPlugin.php","line":121,"function":"getSharesInFolder","class":"OC\\Share20\\Manager","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/SharesPlugin.php","line":185,"function":"getSharesFolder","class":"OCA\\DAV\\Connector\\Sabre\\SharesPlugin","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"handleGetProperties","class":"OCA\\DAV\\Connector\\Sabre\\SharesPlugin","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":1052,"function":"emit","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":984,"function":"getPropertiesByNode","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":1662,"function":"getPropertiesIteratorForPath","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":1647,"function":"writeMultiStatus","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php","line":346,"function":"generateMultiStatus","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"httpPropFind","class":"Sabre\\DAV\\CorePlugin","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":472,"function":"emit","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/Server.php","line":43,"function":"invokeMethod","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Server.php","line":370,"function":"start","class":"OCA\\DAV\\Connector\\Sabre\\Server","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/appinfo/v2/remote.php","line":19,"function":"exec","class":"OCA\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/remote.php","line":146,"args":["/var/www/html/nextcloud/apps/dav/appinfo/v2/remote.php"],"function":"require_once"}],"File":"/var/www/html/nextcloud/lib/private/DB/Connection.php","Line":402,"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`.`parent` = :dcValue6) 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`.`parent` = :dcValue6) ORDER BY `id` ASC"}}
{"reqId":"azeodQ6GD4j7oyDX0ncG","level":0,"time":"2024-10-14T12:00:53+00:00","remoteAddr":"***removed***","user":"***removed***","app":"no app in context","method":"PROPFIND","url":"/remote.php/dav/files/***removed***/***removed***","message":"Calling OCP\\DB\\QueryBuilder\\IQueryBuilder::orX without parameters is deprecated and will throw soon.","userAgent":"Mozilla/5.0 (Windows) mirall/3.9.0stable-Win64 (build 20230613) (Nextcloud, windows-10.0.20348 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.1.1","exception":{"Exception":"Exception","Message":"No parameters in call to OC\\DB\\QueryBuilder\\ExpressionBuilder\\ExpressionBuilder::orX","Code":0,"Trace":[{"file":"/var/www/html/nextcloud/apps/circles/lib/Tools/Db/ExtendedQueryBuilder.php","line":488,"function":"orX","class":"OC\\DB\\QueryBuilder\\ExpressionBuilder\\ExpressionBuilder","type":"->"},{"file":"/var/www/html/nextcloud/apps/circles/lib/Tools/Db/ExtendedQueryBuilder.php","line":325,"function":"exprLimitNull","class":"OCA\\Circles\\Tools\\Db\\ExtendedQueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/apps/circles/lib/Db/ShareWrapperRequest.php","line":397,"function":"limitNull","class":"OCA\\Circles\\Tools\\Db\\ExtendedQueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/apps/circles/lib/Service/ShareWrapperService.php","line":269,"function":"getSharesInFolder","class":"OCA\\Circles\\Db\\ShareWrapperRequest","type":"->"},{"file":"/var/www/html/nextcloud/apps/circles/lib/ShareByCircleProvider.php","line":372,"function":"getSharesInFolder","class":"OCA\\Circles\\Service\\ShareWrapperService","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Share20/Manager.php","line":1121,"function":"getSharesInFolder","class":"OCA\\Circles\\ShareByCircleProvider","type":"->"},{"function":"OC\\Share20\\{closure}","class":"OC\\Share20\\Manager","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/nextcloud/lib/private/Share20/Manager.php","line":1120,"function":"array_reduce"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/SharesPlugin.php","line":121,"function":"getSharesInFolder","class":"OC\\Share20\\Manager","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/SharesPlugin.php","line":185,"function":"getSharesFolder","class":"OCA\\DAV\\Connector\\Sabre\\SharesPlugin","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"handleGetProperties","class":"OCA\\DAV\\Connector\\Sabre\\SharesPlugin","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":1052,"function":"emit","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":984,"function":"getPropertiesByNode","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":1662,"function":"getPropertiesIteratorForPath","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":1647,"function":"writeMultiStatus","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php","line":346,"function":"generateMultiStatus","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"httpPropFind","class":"Sabre\\DAV\\CorePlugin","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":472,"function":"emit","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/Server.php","line":43,"function":"invokeMethod","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Server.php","line":370,"function":"start","class":"OCA\\DAV\\Connector\\Sabre\\Server","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/appinfo/v2/remote.php","line":19,"function":"exec","class":"OCA\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/remote.php","line":146,"args":["/var/www/html/nextcloud/apps/dav/appinfo/v2/remote.php"],"function":"require_once"}],"File":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/ExpressionBuilder/ExpressionBuilder.php","Line":87,"message":"Calling OCP\\DB\\QueryBuilder\\IQueryBuilder::orX without parameters is deprecated and will throw soon.","exception":{},"CustomMessage":"Calling OCP\\DB\\QueryBuilder\\IQueryBuilder::orX without parameters is deprecated and will throw soon."}}
{"reqId":"azeodQ6GD4j7oyDX0ncG","level":0,"time":"2024-10-14T12:00:53+00:00","remoteAddr":"***removed***","user":"***removed***","app":"no app in context","method":"PROPFIND","url":"/remote.php/dav/files/***removed***/***removed***","message":"dirty table reads: SELECT `r`.`id`, `r`.`share_type`, `r`.`share_with`, `r`.`uid_owner`, `r`.`uid_initiator`, `r`.`parent`, `r`.`item_type`, `r`.`item_source`, `r`.`item_target`, `r`.`file_source`, `r`.`file_target`, `r`.`permissions`, `r`.`attributes`, `r`.`stime`, `r`.`accepted`, `r`.`expiration`, `r`.`token`, `r`.`mail_send`, `r_b_d`.`circle_id` AS `r_b_d_circle_id`, `r_b_d`.`member_id` AS `r_b_d_member_id`, `r_b_d`.`single_id` AS `r_b_d_single_id`, `r_b_d`.`user_id` AS `r_b_d_user_id`, `r_b_d`.`instance` AS `r_b_d_instance`, `r_b_d`.`user_type` AS `r_b_d_user_type`, `r_b_d`.`level` AS `r_b_d_level`, `r_b_d`.`status` AS `r_b_d_status`, `r_b_d`.`note` AS `r_b_d_note`, `r_b_d`.`contact_id` AS `r_b_d_contact_id`, `r_b_d`.`cached_name` AS `r_b_d_cached_name`, `r_b_d`.`cached_update` AS `r_b_d_cached_update`, `r_b_d`.`contact_meta` AS `r_b_d_contact_meta`, `r_b_d`.`joined` AS `r_b_d_joined`, `r_s`.`fileid` AS `r_s_fileid`, `r_s`.`path` AS `r_s_path`, `r_s`.`permissions` AS `r_s_permissions`, `r_s`.`storage` AS `r_s_storage`, `r_s`.`path_hash` AS `r_s_path_hash`, `r_s`.`parent` AS `r_s_parent`, `r_s`.`name` AS `r_s_name`, `r_s`.`mimetype` AS `r_s_mimetype`, `r_s`.`mimepart` AS `r_s_mimepart`, `r_s`.`size` AS `r_s_size`, `r_s`.`mtime` AS `r_s_mtime`, `r_s`.`storage_mtime` AS `r_s_storage_mtime`, `r_s`.`encrypted` AS `r_s_encrypted`, `r_s`.`unencrypted_size` AS `r_s_unencrypted_size`, `r_s`.`etag` AS `r_s_etag`, `r_s`.`checksum` AS `r_s_checksum`, `r_s_t`.`id` AS `r_s_t_id` FROM `*PREFIX*share` `r` LEFT JOIN `*PREFIX*circles_circle` `r_b` ON `r_b`.`unique_id` = `r`.`share_with` LEFT JOIN `*PREFIX*filecache` `r_s` ON `r`.`file_source` = `r_s`.`fileid` LEFT JOIN `*PREFIX*circles_member` `r_b_d` ON (`r_b_d`.`circle_id` = `r_b`.`unique_id`) AND (`r_b_d`.`level` = :dcValue2) LEFT JOIN `*PREFIX*storages` `r_s_t` ON `r_s`.`storage` = `r_s_t`.`numeric_id` WHERE (`r`.`share_type` = :dcValue1) AND ((`r`.`uid_owner` = :dcValue3) OR (`r`.`uid_initiator` = :dcValue4)) AND (`r_s`.`parent` = :dcValue5) AND (`r`.`parent` IS NULL)","userAgent":"Mozilla/5.0 (Windows) mirall/3.9.0stable-Win64 (build 20230613) (Nextcloud, windows-10.0.20348 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.1.1","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `r`.`id`, `r`.`share_type`, `r`.`share_with`, `r`.`uid_owner`, `r`.`uid_initiator`, `r`.`parent`, `r`.`item_type`, `r`.`item_source`, `r`.`item_target`, `r`.`file_source`, `r`.`file_target`, `r`.`permissions`, `r`.`attributes`, `r`.`stime`, `r`.`accepted`, `r`.`expiration`, `r`.`token`, `r`.`mail_send`, `r_b_d`.`circle_id` AS `r_b_d_circle_id`, `r_b_d`.`member_id` AS `r_b_d_member_id`, `r_b_d`.`single_id` AS `r_b_d_single_id`, `r_b_d`.`user_id` AS `r_b_d_user_id`, `r_b_d`.`instance` AS `r_b_d_instance`, `r_b_d`.`user_type` AS `r_b_d_user_type`, `r_b_d`.`level` AS `r_b_d_level`, `r_b_d`.`status` AS `r_b_d_status`, `r_b_d`.`note` AS `r_b_d_note`, `r_b_d`.`contact_id` AS `r_b_d_contact_id`, `r_b_d`.`cached_name` AS `r_b_d_cached_name`, `r_b_d`.`cached_update` AS `r_b_d_cached_update`, `r_b_d`.`contact_meta` AS `r_b_d_contact_meta`, `r_b_d`.`joined` AS `r_b_d_joined`, `r_s`.`fileid` AS `r_s_fileid`, `r_s`.`path` AS `r_s_path`, `r_s`.`permissions` AS `r_s_permissions`, `r_s`.`storage` AS `r_s_storage`, `r_s`.`path_hash` AS `r_s_path_hash`, `r_s`.`parent` AS `r_s_parent`, `r_s`.`name` AS `r_s_name`, `r_s`.`mimetype` AS `r_s_mimetype`, `r_s`.`mimepart` AS `r_s_mimepart`, `r_s`.`size` AS `r_s_size`, `r_s`.`mtime` AS `r_s_mtime`, `r_s`.`storage_mtime` AS `r_s_storage_mtime`, `r_s`.`encrypted` AS `r_s_encrypted`, `r_s`.`unencrypted_size` AS `r_s_unencrypted_size`, `r_s`.`etag` AS `r_s_etag`, `r_s`.`checksum` AS `r_s_checksum`, `r_s_t`.`id` AS `r_s_t_id` FROM `*PREFIX*share` `r` LEFT JOIN `*PREFIX*circles_circle` `r_b` ON `r_b`.`unique_id` = `r`.`share_with` LEFT JOIN `*PREFIX*filecache` `r_s` ON `r`.`file_source` = `r_s`.`fileid` LEFT JOIN `*PREFIX*circles_member` `r_b_d` ON (`r_b_d`.`circle_id` = `r_b`.`unique_id`) AND (`r_b_d`.`level` = :dcValue2) LEFT JOIN `*PREFIX*storages` `r_s_t` ON `r_s`.`storage` = `r_s_t`.`numeric_id` WHERE (`r`.`share_type` = :dcValue1) AND ((`r`.`uid_owner` = :dcValue3) OR (`r`.`uid_initiator` = :dcValue4)) AND (`r_s`.`parent` = :dcValue5) AND (`r`.`parent` IS NULL)","Code":0,"Trace":[{"file":"/var/www/html/nextcloud/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":289,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":266,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/apps/circles/lib/Tools/Db/ExtendedQueryBuilder.php","line":1031,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/apps/circles/lib/Tools/Db/ExtendedQueryBuilder.php","line":927,"function":"getRows","class":"OCA\\Circles\\Tools\\Db\\ExtendedQueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/apps/circles/lib/Db/ShareWrapperRequestBuilder.php","line":100,"function":"asItems","class":"OCA\\Circles\\Tools\\Db\\ExtendedQueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/apps/circles/lib/Db/ShareWrapperRequest.php","line":399,"function":"getItemsFromRequest","class":"OCA\\Circles\\Db\\ShareWrapperRequestBuilder","type":"->"},{"file":"/var/www/html/nextcloud/apps/circles/lib/Service/ShareWrapperService.php","line":269,"function":"getSharesInFolder","class":"OCA\\Circles\\Db\\ShareWrapperRequest","type":"->"},{"file":"/var/www/html/nextcloud/apps/circles/lib/ShareByCircleProvider.php","line":372,"function":"getSharesInFolder","class":"OCA\\Circles\\Service\\ShareWrapperService","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Share20/Manager.php","line":1121,"function":"getSharesInFolder","class":"OCA\\Circles\\ShareByCircleProvider","type":"->"},{"function":"OC\\Share20\\{closure}","class":"OC\\Share20\\Manager","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/nextcloud/lib/private/Share20/Manager.php","line":1120,"function":"array_reduce"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/SharesPlugin.php","line":121,"function":"getSharesInFolder","class":"OC\\Share20\\Manager","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/SharesPlugin.php","line":185,"function":"getSharesFolder","class":"OCA\\DAV\\Connector\\Sabre\\SharesPlugin","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"handleGetProperties","class":"OCA\\DAV\\Connector\\Sabre\\SharesPlugin","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":1052,"function":"emit","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":984,"function":"getPropertiesByNode","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":1662,"function":"getPropertiesIteratorForPath","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":1647,"function":"writeMultiStatus","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php","line":346,"function":"generateMultiStatus","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"httpPropFind","class":"Sabre\\DAV\\CorePlugin","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":472,"function":"emit","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/Server.php","line":43,"function":"invokeMethod","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Server.php","line":370,"function":"start","class":"OCA\\DAV\\Connector\\Sabre\\Server","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/appinfo/v2/remote.php","line":19,"function":"exec","class":"OCA\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/remote.php","line":146,"args":["/var/www/html/nextcloud/apps/dav/appinfo/v2/remote.php"],"function":"require_once"}],"File":"/var/www/html/nextcloud/lib/private/DB/Connection.php","Line":402,"message":"dirty table reads: SELECT `r`.`id`, `r`.`share_type`, `r`.`share_with`, `r`.`uid_owner`, `r`.`uid_initiator`, `r`.`parent`, `r`.`item_type`, `r`.`item_source`, `r`.`item_target`, `r`.`file_source`, `r`.`file_target`, `r`.`permissions`, `r`.`attributes`, `r`.`stime`, `r`.`accepted`, `r`.`expiration`, `r`.`token`, `r`.`mail_send`, `r_b_d`.`circle_id` AS `r_b_d_circle_id`, `r_b_d`.`member_id` AS `r_b_d_member_id`, `r_b_d`.`single_id` AS `r_b_d_single_id`, `r_b_d`.`user_id` AS `r_b_d_user_id`, `r_b_d`.`instance` AS `r_b_d_instance`, `r_b_d`.`user_type` AS `r_b_d_user_type`, `r_b_d`.`level` AS `r_b_d_level`, `r_b_d`.`status` AS `r_b_d_status`, `r_b_d`.`note` AS `r_b_d_note`, `r_b_d`.`contact_id` AS `r_b_d_contact_id`, `r_b_d`.`cached_name` AS `r_b_d_cached_name`, `r_b_d`.`cached_update` AS `r_b_d_cached_update`, `r_b_d`.`contact_meta` AS `r_b_d_contact_meta`, `r_b_d`.`joined` AS `r_b_d_joined`, `r_s`.`fileid` AS `r_s_fileid`, `r_s`.`path` AS `r_s_path`, `r_s`.`permissions` AS `r_s_permissions`, `r_s`.`storage` AS `r_s_storage`, `r_s`.`path_hash` AS `r_s_path_hash`, `r_s`.`parent` AS `r_s_parent`, `r_s`.`name` AS `r_s_name`, `r_s`.`mimetype` AS `r_s_mimetype`, `r_s`.`mimepart` AS `r_s_mimepart`, `r_s`.`size` AS `r_s_size`, `r_s`.`mtime` AS `r_s_mtime`, `r_s`.`storage_mtime` AS `r_s_storage_mtime`, `r_s`.`encrypted` AS `r_s_encrypted`, `r_s`.`unencrypted_size` AS `r_s_unencrypted_size`, `r_s`.`etag` AS `r_s_etag`, `r_s`.`checksum` AS `r_s_checksum`, `r_s_t`.`id` AS `r_s_t_id` FROM `*PREFIX*share` `r` LEFT JOIN `*PREFIX*circles_circle` `r_b` ON `r_b`.`unique_id` = `r`.`share_with` LEFT JOIN `*PREFIX*filecache` `r_s` ON `r`.`file_source` = `r_s`.`fileid` LEFT JOIN `*PREFIX*circles_member` `r_b_d` ON (`r_b_d`.`circle_id` = `r_b`.`unique_id`) AND (`r_b_d`.`level` = :dcValue2) LEFT JOIN `*PREFIX*storages` `r_s_t` ON `r_s`.`storage` = `r_s_t`.`numeric_id` WHERE (`r`.`share_type` = :dcValue1) AND ((`r`.`uid_owner` = :dcValue3) OR (`r`.`uid_initiator` = :dcValue4)) AND (`r_s`.`parent` = :dcValue5) AND (`r`.`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 `r`.`id`, `r`.`share_type`, `r`.`share_with`, `r`.`uid_owner`, `r`.`uid_initiator`, `r`.`parent`, `r`.`item_type`, `r`.`item_source`, `r`.`item_target`, `r`.`file_source`, `r`.`file_target`, `r`.`permissions`, `r`.`attributes`, `r`.`stime`, `r`.`accepted`, `r`.`expiration`, `r`.`token`, `r`.`mail_send`, `r_b_d`.`circle_id` AS `r_b_d_circle_id`, `r_b_d`.`member_id` AS `r_b_d_member_id`, `r_b_d`.`single_id` AS `r_b_d_single_id`, `r_b_d`.`user_id` AS `r_b_d_user_id`, `r_b_d`.`instance` AS `r_b_d_instance`, `r_b_d`.`user_type` AS `r_b_d_user_type`, `r_b_d`.`level` AS `r_b_d_level`, `r_b_d`.`status` AS `r_b_d_status`, `r_b_d`.`note` AS `r_b_d_note`, `r_b_d`.`contact_id` AS `r_b_d_contact_id`, `r_b_d`.`cached_name` AS `r_b_d_cached_name`, `r_b_d`.`cached_update` AS `r_b_d_cached_update`, `r_b_d`.`contact_meta` AS `r_b_d_contact_meta`, `r_b_d`.`joined` AS `r_b_d_joined`, `r_s`.`fileid` AS `r_s_fileid`, `r_s`.`path` AS `r_s_path`, `r_s`.`permissions` AS `r_s_permissions`, `r_s`.`storage` AS `r_s_storage`, `r_s`.`path_hash` AS `r_s_path_hash`, `r_s`.`parent` AS `r_s_parent`, `r_s`.`name` AS `r_s_name`, `r_s`.`mimetype` AS `r_s_mimetype`, `r_s`.`mimepart` AS `r_s_mimepart`, `r_s`.`size` AS `r_s_size`, `r_s`.`mtime` AS `r_s_mtime`, `r_s`.`storage_mtime` AS `r_s_storage_mtime`, `r_s`.`encrypted` AS `r_s_encrypted`, `r_s`.`unencrypted_size` AS `r_s_unencrypted_size`, `r_s`.`etag` AS `r_s_etag`, `r_s`.`checksum` AS `r_s_checksum`, `r_s_t`.`id` AS `r_s_t_id` FROM `*PREFIX*share` `r` LEFT JOIN `*PREFIX*circles_circle` `r_b` ON `r_b`.`unique_id` = `r`.`share_with` LEFT JOIN `*PREFIX*filecache` `r_s` ON `r`.`file_source` = `r_s`.`fileid` LEFT JOIN `*PREFIX*circles_member` `r_b_d` ON (`r_b_d`.`circle_id` = `r_b`.`unique_id`) AND (`r_b_d`.`level` = :dcValue2) LEFT JOIN `*PREFIX*storages` `r_s_t` ON `r_s`.`storage` = `r_s_t`.`numeric_id` WHERE (`r`.`share_type` = :dcValue1) AND ((`r`.`uid_owner` = :dcValue3) OR (`r`.`uid_initiator` = :dcValue4)) AND (`r_s`.`parent` = :dcValue5) AND (`r`.`parent` IS NULL)"}}
{"reqId":"azeodQ6GD4j7oyDX0ncG","level":0,"time":"2024-10-14T12:00:53+00:00","remoteAddr":"***removed***","user":"***removed***","app":"no app in context","method":"PROPFIND","url":"/remote.php/dav/files/***removed***/***removed***","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` FROM `*PREFIX*share` `s` INNER JOIN `*PREFIX*filecache` `f` ON `s`.`file_source` = `f`.`fileid` WHERE ((`s`.`item_type` = :dcValue1) OR (`s`.`item_type` = :dcValue2)) AND (`s`.`share_type` = :dcValue3) AND ((`s`.`uid_owner` = :dcValue4) OR (`s`.`uid_initiator` = :dcValue5)) AND (`f`.`storage` = :dcValue6) AND (`f`.`parent` = :dcValue7) ORDER BY `s`.`id` ASC","userAgent":"Mozilla/5.0 (Windows) mirall/3.9.0stable-Win64 (build 20230613) (Nextcloud, windows-10.0.20348 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.1.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` FROM `*PREFIX*share` `s` INNER JOIN `*PREFIX*filecache` `f` ON `s`.`file_source` = `f`.`fileid` WHERE ((`s`.`item_type` = :dcValue1) OR (`s`.`item_type` = :dcValue2)) AND (`s`.`share_type` = :dcValue3) AND ((`s`.`uid_owner` = :dcValue4) OR (`s`.`uid_initiator` = :dcValue5)) AND (`f`.`storage` = :dcValue6) AND (`f`.`parent` = :dcValue7) ORDER BY `s`.`id` ASC","Code":0,"Trace":[{"file":"/var/www/html/nextcloud/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":289,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/html/nextcloud/apps/spreed/lib/Share/RoomShareProvider.php","line":542,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Share20/Manager.php","line":1121,"function":"getSharesInFolder","class":"OCA\\Talk\\Share\\RoomShareProvider","type":"->"},{"function":"OC\\Share20\\{closure}","class":"OC\\Share20\\Manager","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/nextcloud/lib/private/Share20/Manager.php","line":1120,"function":"array_reduce"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/SharesPlugin.php","line":121,"function":"getSharesInFolder","class":"OC\\Share20\\Manager","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/SharesPlugin.php","line":185,"function":"getSharesFolder","class":"OCA\\DAV\\Connector\\Sabre\\SharesPlugin","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"handleGetProperties","class":"OCA\\DAV\\Connector\\Sabre\\SharesPlugin","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":1052,"function":"emit","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":984,"function":"getPropertiesByNode","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":1662,"function":"getPropertiesIteratorForPath","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":1647,"function":"writeMultiStatus","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php","line":346,"function":"generateMultiStatus","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"httpPropFind","class":"Sabre\\DAV\\CorePlugin","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":472,"function":"emit","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/Server.php","line":43,"function":"invokeMethod","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Server.php","line":370,"function":"start","class":"OCA\\DAV\\Connector\\Sabre\\Server","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/appinfo/v2/remote.php","line":19,"function":"exec","class":"OCA\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/remote.php","line":146,"args":["/var/www/html/nextcloud/apps/dav/appinfo/v2/remote.php"],"function":"require_once"}],"File":"/var/www/html/nextcloud/lib/private/DB/Connection.php","Line":402,"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` FROM `*PREFIX*share` `s` INNER JOIN `*PREFIX*filecache` `f` ON `s`.`file_source` = `f`.`fileid` WHERE ((`s`.`item_type` = :dcValue1) OR (`s`.`item_type` = :dcValue2)) AND (`s`.`share_type` = :dcValue3) AND ((`s`.`uid_owner` = :dcValue4) OR (`s`.`uid_initiator` = :dcValue5)) AND (`f`.`storage` = :dcValue6) AND (`f`.`parent` = :dcValue7) ORDER BY `s`.`id` ASC","tables":["oc_filecache"],"reads":["oc_share","oc_filecache"],"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` FROM `*PREFIX*share` `s` INNER JOIN `*PREFIX*filecache` `f` ON `s`.`file_source` = `f`.`fileid` WHERE ((`s`.`item_type` = :dcValue1) OR (`s`.`item_type` = :dcValue2)) AND (`s`.`share_type` = :dcValue3) AND ((`s`.`uid_owner` = :dcValue4) OR (`s`.`uid_initiator` = :dcValue5)) AND (`f`.`storage` = :dcValue6) AND (`f`.`parent` = :dcValue7) ORDER BY `s`.`id` ASC"}}
{"reqId":"azeodQ6GD4j7oyDX0ncG","level":0,"time":"2024-10-14T12:00:53+00:00","remoteAddr":"***removed***","user":"***removed***","app":"no app in context","method":"PROPFIND","url":"/remote.php/dav/files/***removed***/***removed***","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.9.0stable-Win64 (build 20230613) (Nextcloud, windows-10.0.20348 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.1.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":"/var/www/html/nextcloud/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":289,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":266,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Share20/DefaultShareProvider.php","line":882,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Share20/Manager.php","line":1216,"function":"getSharedWith","class":"OC\\Share20\\DefaultShareProvider","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/SharesPlugin.php","line":102,"function":"getSharedWith","class":"OC\\Share20\\Manager","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/SharesPlugin.php","line":151,"function":"getShare","class":"OCA\\DAV\\Connector\\Sabre\\SharesPlugin","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/SharesPlugin.php","line":192,"function":"getShares","class":"OCA\\DAV\\Connector\\Sabre\\SharesPlugin","type":"->"},{"file":"/var/www/html/nextcloud/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":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/SharesPlugin.php","line":191,"function":"handle","class":"Sabre\\DAV\\PropFind","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"handleGetProperties","class":"OCA\\DAV\\Connector\\Sabre\\SharesPlugin","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":1052,"function":"emit","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":984,"function":"getPropertiesByNode","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":1662,"function":"getPropertiesIteratorForPath","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":1647,"function":"writeMultiStatus","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php","line":346,"function":"generateMultiStatus","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"httpPropFind","class":"Sabre\\DAV\\CorePlugin","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":472,"function":"emit","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/Server.php","line":43,"function":"invokeMethod","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Server.php","line":370,"function":"start","class":"OCA\\DAV\\Connector\\Sabre\\Server","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/appinfo/v2/remote.php","line":19,"function":"exec","class":"OCA\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/remote.php","line":146,"args":["/var/www/html/nextcloud/apps/dav/appinfo/v2/remote.php"],"function":"require_once"}],"File":"/var/www/html/nextcloud/lib/private/DB/Connection.php","Line":402,"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"}}
{"reqId":"azeodQ6GD4j7oyDX0ncG","level":0,"time":"2024-10-14T12:00:53+00:00","remoteAddr":"***removed***","user":"***removed***","app":"no app in context","method":"PROPFIND","url":"/remote.php/dav/files/***removed***/***removed***","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 (`file_source` = :dcValue1) AND (`share_type` = :dcValue2) AND (`share_with` IN (:dcValue3)) AND ((`item_type` = :dcValue4) OR (`item_type` = :dcValue5)) ORDER BY `s`.`id` ASC","userAgent":"Mozilla/5.0 (Windows) mirall/3.9.0stable-Win64 (build 20230613) (Nextcloud, windows-10.0.20348 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.1.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 (`file_source` = :dcValue1) AND (`share_type` = :dcValue2) AND (`share_with` IN (:dcValue3)) AND ((`item_type` = :dcValue4) OR (`item_type` = :dcValue5)) ORDER BY `s`.`id` ASC","Code":0,"Trace":[{"file":"/var/www/html/nextcloud/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":289,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":266,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Share20/DefaultShareProvider.php","line":946,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Share20/Manager.php","line":1216,"function":"getSharedWith","class":"OC\\Share20\\DefaultShareProvider","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/SharesPlugin.php","line":102,"function":"getSharedWith","class":"OC\\Share20\\Manager","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/SharesPlugin.php","line":151,"function":"getShare","class":"OCA\\DAV\\Connector\\Sabre\\SharesPlugin","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/SharesPlugin.php","line":192,"function":"getShares","class":"OCA\\DAV\\Connector\\Sabre\\SharesPlugin","type":"->"},{"file":"/var/www/html/nextcloud/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":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/SharesPlugin.php","line":191,"function":"handle","class":"Sabre\\DAV\\PropFind","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"handleGetProperties","class":"OCA\\DAV\\Connector\\Sabre\\SharesPlugin","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":1052,"function":"emit","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":984,"function":"getPropertiesByNode","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":1662,"function":"getPropertiesIteratorForPath","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":1647,"function":"writeMultiStatus","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php","line":346,"function":"generateMultiStatus","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"httpPropFind","class":"Sabre\\DAV\\CorePlugin","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":472,"function":"emit","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/Server.php","line":43,"function":"invokeMethod","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Server.php","line":370,"function":"start","class":"OCA\\DAV\\Connector\\Sabre\\Server","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/appinfo/v2/remote.php","line":19,"function":"exec","class":"OCA\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/remote.php","line":146,"args":["/var/www/html/nextcloud/apps/dav/appinfo/v2/remote.php"],"function":"require_once"}],"File":"/var/www/html/nextcloud/lib/private/DB/Connection.php","Line":402,"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 (`file_source` = :dcValue1) AND (`share_type` = :dcValue2) AND (`share_with` IN (:dcValue3)) AND ((`item_type` = :dcValue4) OR (`item_type` = :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 (`file_source` = :dcValue1) AND (`share_type` = :dcValue2) AND (`share_with` IN (:dcValue3)) AND ((`item_type` = :dcValue4) OR (`item_type` = :dcValue5)) ORDER BY `s`.`id` ASC"}}
{"reqId":"azeodQ6GD4j7oyDX0ncG","level":0,"time":"2024-10-14T12:00:53+00:00","remoteAddr":"***removed***","user":"***removed***","app":"no app in context","method":"PROPFIND","url":"/remote.php/dav/files/***removed***/***removed***","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 (`s`.`file_source` = :dcValue1) AND (`s`.`share_type` = :dcValue2) AND (`s`.`share_with` IN (:dcValue3)) AND ((`s`.`item_type` = :dcValue4) OR (`s`.`item_type` = :dcValue5)) ORDER BY `s`.`id` ASC","userAgent":"Mozilla/5.0 (Windows) mirall/3.9.0stable-Win64 (build 20230613) (Nextcloud, windows-10.0.20348 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.1.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 (`s`.`file_source` = :dcValue1) AND (`s`.`share_type` = :dcValue2) AND (`s`.`share_with` IN (:dcValue3)) AND ((`s`.`item_type` = :dcValue4) OR (`s`.`item_type` = :dcValue5)) ORDER BY `s`.`id` ASC","Code":0,"Trace":[{"file":"/var/www/html/nextcloud/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":289,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/html/nextcloud/apps/spreed/lib/Share/RoomShareProvider.php","line":823,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Share20/Manager.php","line":1216,"function":"getSharedWith","class":"OCA\\Talk\\Share\\RoomShareProvider","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/SharesPlugin.php","line":102,"function":"getSharedWith","class":"OC\\Share20\\Manager","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/SharesPlugin.php","line":151,"function":"getShare","class":"OCA\\DAV\\Connector\\Sabre\\SharesPlugin","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/SharesPlugin.php","line":192,"function":"getShares","class":"OCA\\DAV\\Connector\\Sabre\\SharesPlugin","type":"->"},{"file":"/var/www/html/nextcloud/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":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/SharesPlugin.php","line":191,"function":"handle","class":"Sabre\\DAV\\PropFind","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"handleGetProperties","class":"OCA\\DAV\\Connector\\Sabre\\SharesPlugin","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":1052,"function":"emit","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":984,"function":"getPropertiesByNode","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":1662,"function":"getPropertiesIteratorForPath","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":1647,"function":"writeMultiStatus","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php","line":346,"function":"generateMultiStatus","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"httpPropFind","class":"Sabre\\DAV\\CorePlugin","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":472,"function":"emit","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/Server.php","line":43,"function":"invokeMethod","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Server.php","line":370,"function":"start","class":"OCA\\DAV\\Connector\\Sabre\\Server","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/appinfo/v2/remote.php","line":19,"function":"exec","class":"OCA\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/remote.php","line":146,"args":["/var/www/html/nextcloud/apps/dav/appinfo/v2/remote.php"],"function":"require_once"}],"File":"/var/www/html/nextcloud/lib/private/DB/Connection.php","Line":402,"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 (`s`.`file_source` = :dcValue1) AND (`s`.`share_type` = :dcValue2) AND (`s`.`share_with` IN (:dcValue3)) AND ((`s`.`item_type` = :dcValue4) OR (`s`.`item_type` = :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 (`s`.`file_source` = :dcValue1) AND (`s`.`share_type` = :dcValue2) AND (`s`.`share_with` IN (:dcValue3)) AND ((`s`.`item_type` = :dcValue4) OR (`s`.`item_type` = :dcValue5)) ORDER BY `s`.`id` ASC"}}
{"reqId":"azeodQ6GD4j7oyDX0ncG","level":0,"time":"2024-10-14T12:00:53+00:00","remoteAddr":"***removed***","user":"***removed***","app":"no app in context","method":"PROPFIND","url":"/remote.php/dav/files/***removed***/***removed***","message":"Calling OCP\\DB\\QueryBuilder\\IQueryBuilder::orX without parameters is deprecated and will throw soon.","userAgent":"Mozilla/5.0 (Windows) mirall/3.9.0stable-Win64 (build 20230613) (Nextcloud, windows-10.0.20348 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.1.1","exception":{"Exception":"Exception","Message":"No parameters in call to OC\\DB\\QueryBuilder\\ExpressionBuilder\\ExpressionBuilder::orX","Code":0,"Trace":[{"file":"/var/www/html/nextcloud/apps/circles/lib/Tools/Db/ExtendedQueryBuilder.php","line":488,"function":"orX","class":"OC\\DB\\QueryBuilder\\ExpressionBuilder\\ExpressionBuilder","type":"->"},{"file":"/var/www/html/nextcloud/apps/circles/lib/Tools/Db/ExtendedQueryBuilder.php","line":325,"function":"exprLimitNull","class":"OCA\\Circles\\Tools\\Db\\ExtendedQueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/apps/circles/lib/Db/ShareWrapperRequest.php","line":351,"function":"limitNull","class":"OCA\\Circles\\Tools\\Db\\ExtendedQueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/apps/circles/lib/Service/ShareWrapperService.php","line":253,"function":"getSharesBy","class":"OCA\\Circles\\Db\\ShareWrapperRequest","type":"->"},{"file":"/var/www/html/nextcloud/apps/circles/lib/ShareByCircleProvider.php","line":435,"function":"getSharesBy","class":"OCA\\Circles\\Service\\ShareWrapperService","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Share20/Manager.php","line":1149,"function":"getSharesBy","class":"OCA\\Circles\\ShareByCircleProvider","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/SharesPlugin.php","line":92,"function":"getSharesBy","class":"OC\\Share20\\Manager","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/SharesPlugin.php","line":151,"function":"getShare","class":"OCA\\DAV\\Connector\\Sabre\\SharesPlugin","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/SharesPlugin.php","line":192,"function":"getShares","class":"OCA\\DAV\\Connector\\Sabre\\SharesPlugin","type":"->"},{"file":"/var/www/html/nextcloud/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":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/SharesPlugin.php","line":191,"function":"handle","class":"Sabre\\DAV\\PropFind","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"handleGetProperties","class":"OCA\\DAV\\Connector\\Sabre\\SharesPlugin","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":1052,"function":"emit","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":984,"function":"getPropertiesByNode","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":1662,"function":"getPropertiesIteratorForPath","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":1647,"function":"writeMultiStatus","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php","line":346,"function":"generateMultiStatus","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"httpPropFind","class":"Sabre\\DAV\\CorePlugin","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":472,"function":"emit","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/Server.php","line":43,"function":"invokeMethod","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Server.php","line":370,"function":"start","class":"OCA\\DAV\\Connector\\Sabre\\Server","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/appinfo/v2/remote.php","line":19,"function":"exec","class":"OCA\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/remote.php","line":146,"args":["/var/www/html/nextcloud/apps/dav/appinfo/v2/remote.php"],"function":"require_once"}],"File":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/ExpressionBuilder/ExpressionBuilder.php","Line":87,"message":"Calling OCP\\DB\\QueryBuilder\\IQueryBuilder::orX without parameters is deprecated and will throw soon.","exception":{},"CustomMessage":"Calling OCP\\DB\\QueryBuilder\\IQueryBuilder::orX without parameters is deprecated and will throw soon."}}
{"reqId":"azeodQ6GD4j7oyDX0ncG","level":0,"time":"2024-10-14T12:00:53+00:00","remoteAddr":"***removed***","user":"***removed***","app":"no app in context","method":"PROPFIND","url":"/remote.php/dav/files/***removed***/***removed***","message":"dirty table reads: SELECT `name`, `p`.`propertypath`, `p`.`propertyname`, `p`.`propertyvalue`, `p`.`valuetype` FROM `*PREFIX*filecache` `f` LEFT JOIN `*PREFIX*properties` `p` ON `p`.`propertypath` = CONCAT(:dcValue1, `f`.`name`) WHERE (`parent` = :dcValue2) AND (`p`.`userid` = :dcValue3)","userAgent":"Mozilla/5.0 (Windows) mirall/3.9.0stable-Win64 (build 20230613) (Nextcloud, windows-10.0.20348 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.1.1","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `name`, `p`.`propertypath`, `p`.`propertyname`, `p`.`propertyvalue`, `p`.`valuetype` FROM `*PREFIX*filecache` `f` LEFT JOIN `*PREFIX*properties` `p` ON `p`.`propertypath` = CONCAT(:dcValue1, `f`.`name`) WHERE (`parent` = :dcValue2) AND (`p`.`userid` = :dcValue3)","Code":0,"Trace":[{"file":"/var/www/html/nextcloud/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":289,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/DAV/CustomPropertiesBackend.php","line":377,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/DAV/CustomPropertiesBackend.php","line":241,"function":"cacheDirectory","class":"OCA\\DAV\\DAV\\CustomPropertiesBackend","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/PropertyStorage/Plugin.php","line":84,"function":"propFind","class":"OCA\\DAV\\DAV\\CustomPropertiesBackend","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"propFind","class":"Sabre\\DAV\\PropertyStorage\\Plugin","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":1052,"function":"emit","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":984,"function":"getPropertiesByNode","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":1662,"function":"getPropertiesIteratorForPath","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":1647,"function":"writeMultiStatus","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php","line":346,"function":"generateMultiStatus","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"httpPropFind","class":"Sabre\\DAV\\CorePlugin","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":472,"function":"emit","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/Server.php","line":43,"function":"invokeMethod","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Server.php","line":370,"function":"start","class":"OCA\\DAV\\Connector\\Sabre\\Server","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/appinfo/v2/remote.php","line":19,"function":"exec","class":"OCA\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/remote.php","line":146,"args":["/var/www/html/nextcloud/apps/dav/appinfo/v2/remote.php"],"function":"require_once"}],"File":"/var/www/html/nextcloud/lib/private/DB/Connection.php","Line":402,"message":"dirty table reads: SELECT `name`, `p`.`propertypath`, `p`.`propertyname`, `p`.`propertyvalue`, `p`.`valuetype` FROM `*PREFIX*filecache` `f` LEFT JOIN `*PREFIX*properties` `p` ON `p`.`propertypath` = CONCAT(:dcValue1, `f`.`name`) WHERE (`parent` = :dcValue2) AND (`p`.`userid` = :dcValue3)","tables":["oc_filecache"],"reads":["oc_filecache","oc_properties"],"exception":{},"CustomMessage":"dirty table reads: SELECT `name`, `p`.`propertypath`, `p`.`propertyname`, `p`.`propertyvalue`, `p`.`valuetype` FROM `*PREFIX*filecache` `f` LEFT JOIN `*PREFIX*properties` `p` ON `p`.`propertypath` = CONCAT(:dcValue1, `f`.`name`) WHERE (`parent` = :dcValue2) AND (`p`.`userid` = :dcValue3)"}}
{"reqId":"azeodQ6GD4j7oyDX0ncG","level":0,"time":"2024-10-14T12:00:53+00:00","remoteAddr":"***removed***","user":"***removed***","app":"no app in context","method":"PROPFIND","url":"/remote.php/dav/files/***removed***/***removed***","message":"dirty table reads: SELECT `filecache`.`fileid`, `storage`, `path`, `path_hash`, `filecache`.`parent`, `filecache`.`name`, `mimetype`, `mimepart`, `size`, `mtime`, `storage_mtime`, `encrypted`, `etag`, `filecache`.`permissions`, `checksum`, `unencrypted_size`, `metadata_etag`, `creation_time`, `upload_time`, `meta`.`json` AS `meta_json`, `meta`.`sync_token` AS `meta_sync_token` FROM `*PREFIX*filecache` `filecache` LEFT JOIN `*PREFIX*filecache_extended` `fe` ON `filecache`.`fileid` = `fe`.`fileid` LEFT JOIN `*PREFIX*files_metadata` `meta` ON `filecache`.`fileid` = `meta`.`file_id` WHERE (`filecache`.`parent` = :dcValue1) AND (`storage` = :dcValue2) ORDER BY `name` ASC","userAgent":"Mozilla/5.0 (Windows) mirall/3.9.0stable-Win64 (build 20230613) (Nextcloud, windows-10.0.20348 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.1.1","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `filecache`.`fileid`, `storage`, `path`, `path_hash`, `filecache`.`parent`, `filecache`.`name`, `mimetype`, `mimepart`, `size`, `mtime`, `storage_mtime`, `encrypted`, `etag`, `filecache`.`permissions`, `checksum`, `unencrypted_size`, `metadata_etag`, `creation_time`, `upload_time`, `meta`.`json` AS `meta_json`, `meta`.`sync_token` AS `meta_sync_token` FROM `*PREFIX*filecache` `filecache` LEFT JOIN `*PREFIX*filecache_extended` `fe` ON `filecache`.`fileid` = `fe`.`fileid` LEFT JOIN `*PREFIX*files_metadata` `meta` ON `filecache`.`fileid` = `meta`.`file_id` WHERE (`filecache`.`parent` = :dcValue1) AND (`storage` = :dcValue2) ORDER BY `name` ASC","Code":0,"Trace":[{"file":"/var/www/html/nextcloud/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":289,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/ExtendedQueryBuilder.php","line":285,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/ExtendedQueryBuilder.php","line":53,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\ExtendedQueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/Cache/Cache.php","line":208,"function":"execute","class":"OC\\DB\\QueryBuilder\\ExtendedQueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/Cache/Wrapper/CacheWrapper.php","line":97,"function":"getFolderContentsById","class":"OC\\Files\\Cache\\Cache","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/View.php","line":1439,"function":"getFolderContentsById","class":"OC\\Files\\Cache\\Wrapper\\CacheWrapper","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/Node/Folder.php","line":81,"function":"getDirectoryContent","class":"OC\\Files\\View","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/Directory.php","line":223,"function":"getDirectoryListing","class":"OC\\Files\\Node\\Folder","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Tree.php","line":218,"function":"getChildren","class":"OCA\\DAV\\Connector\\Sabre\\Directory","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":900,"function":"getChildren","class":"Sabre\\DAV\\Tree","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":982,"function":"generatePathNodes","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":1662,"function":"getPropertiesIteratorForPath","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":1647,"function":"writeMultiStatus","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php","line":346,"function":"generateMultiStatus","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"httpPropFind","class":"Sabre\\DAV\\CorePlugin","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":472,"function":"emit","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/Server.php","line":43,"function":"invokeMethod","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Server.php","line":370,"function":"start","class":"OCA\\DAV\\Connector\\Sabre\\Server","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/appinfo/v2/remote.php","line":19,"function":"exec","class":"OCA\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/remote.php","line":146,"args":["/var/www/html/nextcloud/apps/dav/appinfo/v2/remote.php"],"function":"require_once"}],"File":"/var/www/html/nextcloud/lib/private/DB/Connection.php","Line":402,"message":"dirty table reads: SELECT `filecache`.`fileid`, `storage`, `path`, `path_hash`, `filecache`.`parent`, `filecache`.`name`, `mimetype`, `mimepart`, `size`, `mtime`, `storage_mtime`, `encrypted`, `etag`, `filecache`.`permissions`, `checksum`, `unencrypted_size`, `metadata_etag`, `creation_time`, `upload_time`, `meta`.`json` AS `meta_json`, `meta`.`sync_token` AS `meta_sync_token` FROM `*PREFIX*filecache` `filecache` LEFT JOIN `*PREFIX*filecache_extended` `fe` ON `filecache`.`fileid` = `fe`.`fileid` LEFT JOIN `*PREFIX*files_metadata` `meta` ON `filecache`.`fileid` = `meta`.`file_id` WHERE (`filecache`.`parent` = :dcValue1) AND (`storage` = :dcValue2) ORDER BY `name` ASC","tables":["oc_filecache"],"reads":["oc_filecache","oc_filecache_extended","oc_files_metadata"],"exception":{},"CustomMessage":"dirty table reads: SELECT `filecache`.`fileid`, `storage`, `path`, `path_hash`, `filecache`.`parent`, `filecache`.`name`, `mimetype`, `mimepart`, `size`, `mtime`, `storage_mtime`, `encrypted`, `etag`, `filecache`.`permissions`, `checksum`, `unencrypted_size`, `metadata_etag`, `creation_time`, `upload_time`, `meta`.`json` AS `meta_json`, `meta`.`sync_token` AS `meta_sync_token` FROM `*PREFIX*filecache` `filecache` LEFT JOIN `*PREFIX*filecache_extended` `fe` ON `filecache`.`fileid` = `fe`.`fileid` LEFT JOIN `*PREFIX*files_metadata` `meta` ON `filecache`.`fileid` = `meta`.`file_id` WHERE (`filecache`.`parent` = :dcValue1) AND (`storage` = :dcValue2) ORDER BY `name` ASC"}}
{"reqId":"qHQKdO7Z5xUB7Xx5W37F","level":0,"time":"2024-10-14T12:00:55+00:00","remoteAddr":"***removed***","user":"***removed***","app":"no app in context","method":"POST","url":"/index.php/apps/notify_push/pre_auth","message":"OCA\\NotifyPush\\Controller\\AuthController::preAuth uses the @NoAdminRequired annotation and should use the #[OCP\\AppFramework\\Http\\Attribute\\NoAdminRequired] attribute instead","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36","version":"30.0.1.1","data":[]}
{"reqId":"qHQKdO7Z5xUB7Xx5W37F","level":0,"time":"2024-10-14T12:00:55+00:00","remoteAddr":"***removed***","user":"***removed***","app":"no app in context","method":"POST","url":"/index.php/apps/notify_push/pre_auth","message":"OCA\\NotifyPush\\Controller\\AuthController::preAuth uses the @NoAdminRequired annotation and should use the #[OCP\\AppFramework\\Http\\Attribute\\NoAdminRequired] attribute instead","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36","version":"30.0.1.1","data":[]}
{"reqId":"qHQKdO7Z5xUB7Xx5W37F","level":0,"time":"2024-10-14T12:00:55+00:00","remoteAddr":"***removed***","user":"***removed***","app":"no app in context","method":"POST","url":"/index.php/apps/notify_push/pre_auth","message":"OCA\\NotifyPush\\Controller\\AuthController::preAuth uses the @NoCSRFRequired annotation and should use the #[OCP\\AppFramework\\Http\\Attribute\\NoCSRFRequired] attribute instead","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36","version":"30.0.1.1","data":[]}
{"reqId":"qHQKdO7Z5xUB7Xx5W37F","level":0,"time":"2024-10-14T12:00:55+00:00","remoteAddr":"***removed***","user":"***removed***","app":"no app in context","method":"POST","url":"/index.php/apps/notify_push/pre_auth","message":"OCA\\NotifyPush\\Controller\\AuthController::preAuth uses the @NoCSRFRequired annotation and should use the #[OCP\\AppFramework\\Http\\Attribute\\NoCSRFRequired] attribute instead","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36","version":"30.0.1.1","data":[]}
{"reqId":"VhtZyDb1KP33QPCXAPuh","level":0,"time":"2024-10-14T12:00:56+00:00","remoteAddr":"***removed***","user":"***removed***","app":"dav","method":"GET","url":"/ocs/v2.php/apps/user_status/api/v1/user_status?format=json","message":"No calendar events found for status check","userAgent":"Mozilla/5.0 (Windows) mirall/3.9.0stable-Win64 (build 20230613) (Nextcloud, windows-10.0.20348 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.1.1","data":{"app":"dav","user":"***removed***"}}

I’ve seen that loglevel was on 0. I changed it to 2. Now no log entry is created when a file is uploaded or modified and no Mail is sent. I updated to 30.0.1 stable.

shared a folder → received activity mail
uploaded a file → no mail

Can I check somehow if an email is triggered e.g. in the database?

EDIT: As the user who should receive the notification I logged in and checked the activity page. There the notifications are shown. BUT: I also activates push notifications. They show exactly the same behavior (no notification for file change).

EDIT2: Updated PHP to 8.3, no change

See

(in German)

(in English)

The problem started after updating to NC 30.0.0. Before the update it worked perfectly. I’ve tested on another cloud which also is updated to 30.0.1 and the notifications also don’t work. Can you confirm mail notifications on your NC30 on file change are working?

I did further tests. Mails on file change are sent correctly but NOT on file creation, upload or deletion. I cleared the opcache. Nothing has changed Cronjob is running successfully every 5 minutes. The notification workflow app is no alternative for me as we have hundreds of users which have to manually add a workflow rule. The mail notification worked without that prior to 30.0.0

same problem, how to resolve?