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?

Hi Tiger, I think this is a debug log entry (no error) and shows up when loglevel is set to 0. This vanished by setting loglevel to 2 in the config.php.

It’s the same situation here. Nextcloud 3.0.2 (recently upgraded from 29.0.7) on Ubuntu 24.04.
Email notifications stop working on file upload, modification, and rename.
Please help!

Please check if the cronjob runs. Are there any errors on the administration overwiew page? Please also check the log. Mails are sent on my system but ONLY not on file upload.

I hope, somone will test on his NC >= 30 and give a feedback as mentioned above.

Have exactly same problem. After update to 30.0.0 mail notifications stop working on file created event , but I can see that as activity. On file change, when I upload same file again overwriting existing, mail notifications are sent.
Could you please fix this issue @Nextcloud team?
Or at least give as hint if it going to be fixed at all .

I even try to update today on beta channel latest version. Still not working.

Check everything log for errors, admin general page, Cron Job run it manually everything else is looking great.

Thank you in advance!

Same issue… Updated today on newest beta version and still no luck… Definitely bug on version 30 +. Or may be it is a feature now :slight_smile:

Hello,

I had the same issue.
But in my environment it was resolved ticking the following checkbox:


Until now the first checkbox was enough so I think they added the second checkbox…
Maybe this helps you as well.

1 Like

Hi Folks
I find this error in the log:

{“reqId”:“E7PFTCZJ5dATCx9MUlYA”,“level”:0,“time”:“2024-12-11T10:05:03+00:00”,“remoteAddr”:“removed”,“user”:“removed”,“app”:“no app in context”,“method”:“GET”,“url”:“/ocs/v2.php/apps/notifications/api/v2/notifications”,“message”:“OCA\MailNotifier\Notification\MailNotifier::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 NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36 Edg/131.0.0.0”,“version”:“30.0.2.2”,“data”:}

My Version: Nextcloud Hub 9 (30.0.2)

At the moment I have noticed that when I release an order, the users receive an activity report once.
Afterwards there are no more mails. it doesn’t matter if any notification is activated or not. In addition, the mail does not work even if I try to send something via Flow

Hi Curlie,
this checkbox is set from the beginning on my system. Nevertheless Mails on upload are not sent.

Just a little reminder. The problem still persists. There’s even no push notification shown on file creation for the other users. I checked all options in the notification settings to be sure. Is there any way to check if something goes wrong? I’m on NC 30.0.5 now.