search

nextcloud / server

☁️ Nextcloud server, a safe home for all your data
https://nextcloud.com
GNU Affero General Public License v3.0
26.78k stars 4k forks source link

[Bug]: `files:scan-app-data` crashes every time with SQL Deadlock #31078

Closed hcoin closed 1 year ago

hcoin commented 2 years ago

⚠️ This issue respects the following points: ⚠️

Bug description

Even with redis for locking, every time this is run, it fails. 

# sudo -u www-data php occ files:scan-app-data
Scanning AppData for files

Exception during scan: An exception occurred while executing a query: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction
#0 /qflibrary/www/sync.quietfountain.com/3rdparty/doctrine/dbal/src/Connection.php(1780): Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert()
#1 /qflibrary/www/sync.quietfountain.com/3rdparty/doctrine/dbal/src/Connection.php(1719): Doctrine\DBAL\Connection->handleDriverException()
#2 /qflibrary/www/sync.quietfountain.com/3rdparty/doctrine/dbal/src/Connection.php(1067): Doctrine\DBAL\Connection->convertExceptionDuringQuery()
#3 /qflibrary/www/sync.quietfountain.com/lib/private/DB/Connection.php(236): Doctrine\DBAL\Connection->executeQuery()
#4 /qflibrary/www/sync.quietfountain.com/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(345): OC\DB\Connection->executeQuery()
#5 /qflibrary/www/sync.quietfountain.com/lib/private/DB/QueryBuilder/QueryBuilder.php(287): Doctrine\DBAL\Query\QueryBuilder->execute()
#6 /qflibrary/www/sync.quietfountain.com/lib/private/Files/Cache/Cache.php(235): OC\DB\QueryBuilder\QueryBuilder->execute()

Steps to reproduce

Run scan-app-data, watch it fail.

Expected behavior

Not failing.

Installation method

Manual installation

Operating system

Debian/Ubuntu

PHP engine version

PHP 7.4

Web server

Nginx

Database engine version

MariaDB

Is this bug present after an update or on a fresh install?

Updated from a minor version (ex. 22.2.3 to 22.2.4)

Are you using the Nextcloud Server Encryption module?

Encryption is Disabled

What user-backends are you using?

Configuration report

sudo -u www-data php occ config:list system
{
    "system": {
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "localhost",
            "sync.quietfountain.com"
        ],
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "mysql",
        "version": "23.0.0.10",
        "overwrite.cli.url": "https:\/\/sync.quietfountain.com\/",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "",
        "dbtableprefix": "oc_",
        "mysql.utf8mb4": true,
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "default_phone_region": "US",
        "auto_logout": true,
        "lost_password_link": "https:\/\/registry.1.quietfountain.com",
        "htaccess.RewriteBase": "\/",
        "apps_paths": [
            {
                "path": "\/qflibrary\/www\/sync.quietfountain.com\/apps",
                "url": "\/apps",
                "writable": true
            }
        ],
        "tempdirectory": "\/qflibrary\/sync\/nextcloud_temp",
        "gs.enabled": false,
        "gs.federation": "internal",
        "ldapProviderFactory": "OCA\\User_LDAP\\LDAPProviderFactory",
        "sort_groups_by_name": true,
        "mail_smtpmode": "smtp",
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "587",
        "mail_smtptimeout": 30,
        "mail_smtpsecure": "tls",
        "mail_smtpauth": 1,
        "mail_smtpauthtype": "PLAIN",
        "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
        "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "app.mail.accounts.default": {
            "email": "%USERID%@quietfountain.com",
            "imapHost": "mail.quietfountain.com",
            "imapPort": 993,
            "imapUser": "%USERID%",
            "imapSslMode": "ssl",
            "smtpHost": "mail.quietfountain.com",
            "smtpPort": 587,
            "smtpUser": "%USERID%@quietfountain.com",
            "smtpSslMode": "tls"
        },
        "app.mail.imap.timeout": 20,
        "app.mail.smtp.timeout": 20,
        "mail_sendmailmode": "smtp",
        "overwritehost": "sync.quietfountain.com",
        "overwriteprotocol": "https",
        "overwritewebroot": "\/",
        "dbdriveroptions": {
            "1007": "\/qflibrary\/www\/rss_managed\/quietfountain.com\/sync\/HTTP_www.1.quietfountain.com.pem.key",
            "1008": "\/qflibrary\/ssl\/HTTP_www.1.quietfountain.com.pem.crt",
            "1009": "\/qflibrary\/ssl\/ipa-ca.crt",
            "1014": true
        },
        "memcache.local": "\\OC\\Memcache\\APCu",
        "memcache.distributed": "\\OC\\Memcache\\Redis",
        "redis": {
            "host": "***REMOVED SENSITIVE VALUE***",
            "port": 6379
        },
        "memcache.locking": "\\OC\\Memcache\\Redis",
        "maintenance": false,
        "theme": "",
        "loglevel": 0,
        "data-fingerprint": "0f87fa51b2f78bbaf1c201696f2c582c"
    }
}

List of activated Apps

# sudo -u www-data php occ app:list
Enabled:
  - accessibility: 1.9.0
  - activity: 2.15.0
  - calendar: 3.0.5
  - circles: 23.0.0
  - cloud_federation_api: 1.6.0
  - comments: 1.13.0
  - contacts: 4.0.7
  - contactsinteraction: 1.4.0
  - dashboard: 7.3.0
  - dav: 1.21.0
  - deck: 1.6.0
  - federatedfilesharing: 1.13.0
  - federation: 1.13.0
  - files: 1.18.0
  - files_antivirus: 3.2.2
  - files_pdfviewer: 2.4.0
  - files_rightclick: 1.2.0
  - files_sharing: 1.15.0
  - files_trashbin: 1.13.0
  - files_versions: 1.16.0
  - files_videoplayer: 1.12.0
  - firstrunwizard: 2.12.0
  - logreader: 2.8.0
  - lookup_server_connector: 1.11.0
  - mail: 1.11.6
  - maps: 0.1.10
  - nextcloud_announcements: 1.12.0
  - notifications: 2.11.1
  - oauth2: 1.11.0
  - password_policy: 1.13.0
  - photos: 1.5.0
  - privacy: 1.7.0
  - provisioning_api: 1.13.0
  - recommendations: 1.2.0
  - serverinfo: 1.13.0
  - settings: 1.5.0
  - sharebymail: 1.13.0
  - spreed: 13.0.2
  - support: 1.6.0
  - survey_client: 1.11.0
  - systemtags: 1.13.0
  - text: 3.4.0
  - theming: 1.14.0
  - twofactor_backupcodes: 1.12.0
  - updatenotification: 1.13.0
  - user_ldap: 1.13.0
  - user_status: 1.3.1
  - viewer: 1.7.0
  - weather_status: 1.3.0
  - workflowengine: 2.5.0
Disabled:
  - admin_audit
  - encryption
  - files_external

Nextcloud Signing status

No errors have been found.

Nextcloud Logs

...
{"reqId":"U683z2nCCHrI18NriUID","level":0,"time":"2022-02-08T18:44:16+00:00","remoteAddr":"10.12.114.206","user":"hcoin","app":"files_antivirus","method":"PROPFIND","url":"/remote.php/dav/files/hcoin/","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"Mozilla/5.0 (Linux) mirall/3.2.3-0ubuntu1 (Nextcloud, ubuntu-5.13.0-28-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"23.0.0.10"}
{"reqId":"U683z2nCCHrI18NriUID","level":0,"time":"2022-02-08T18:44:16+00:00","remoteAddr":"10.12.114.206","user":"hcoin","app":"maps","method":"PROPFIND","url":"/remote.php/dav/files/hcoin/","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"Mozilla/5.0 (Linux) mirall/3.2.3-0ubuntu1 (Nextcloud, ubuntu-5.13.0-28-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"23.0.0.10"}
{"reqId":"CzsFx2Aep0XpmX7Fuqpc","level":0,"time":"2022-02-08T18:44:16+00:00","remoteAddr":"10.12.114.192","user":"hcoin","app":"files_antivirus","method":"PROPFIND","url":"/remote.php/dav/files/hcoin//InstantUpload/Download/digital%20proof_three%201908_pots.jpg","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.19.0","version":"23.0.0.10"}
{"reqId":"CzsFx2Aep0XpmX7Fuqpc","level":0,"time":"2022-02-08T18:44:16+00:00","remoteAddr":"10.12.114.192","user":"hcoin","app":"maps","method":"PROPFIND","url":"/remote.php/dav/files/hcoin//InstantUpload/Download/digital%20proof_three%201908_pots.jpg","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.19.0","version":"23.0.0.10"}
{"reqId":"YgkV1Vz3tJSq2HUzUGbL","level":0,"time":"2022-02-08T18:44:17+00:00","remoteAddr":"10.12.114.192","user":"hcoin","app":"files_antivirus","method":"GET","url":"/index.php/apps/files/api/v1/thumbnail/256/256/InstantUpload/Download/digital%20proof_three%201908_pots.jpg","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.19.0","version":"23.0.0.10"}
{"reqId":"YgkV1Vz3tJSq2HUzUGbL","level":0,"time":"2022-02-08T18:44:17+00:00","remoteAddr":"10.12.114.192","user":"hcoin","app":"maps","method":"GET","url":"/index.php/apps/files/api/v1/thumbnail/256/256/InstantUpload/Download/digital%20proof_three%201908_pots.jpg","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.19.0","version":"23.0.0.10"}
{"reqId":"kFWbUvciiyxM03S1Ee3d","level":0,"time":"2022-02-08T18:44:19+00:00","remoteAddr":"10.12.114.192","user":"--","app":"files_antivirus","method":"GET","url":"/index.php/204","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.19.0","version":"23.0.0.10"}
{"reqId":"kFWbUvciiyxM03S1Ee3d","level":0,"time":"2022-02-08T18:44:19+00:00","remoteAddr":"10.12.114.192","user":"--","app":"maps","method":"GET","url":"/index.php/204","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.19.0","version":"23.0.0.10"}
{"reqId":"Srb6sySYf9SV3u38ZaEx","level":0,"time":"2022-02-08T18:44:19+00:00","remoteAddr":"10.12.114.192","user":"hcoin","app":"files_antivirus","method":"HEAD","url":"/remote.php/dav/files/hcoin//InstantUpload/Download/digital%20proof_three%201908_pots.jpg","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.19.0","version":"23.0.0.10"}
{"reqId":"Srb6sySYf9SV3u38ZaEx","level":0,"time":"2022-02-08T18:44:19+00:00","remoteAddr":"10.12.114.192","user":"hcoin","app":"maps","method":"HEAD","url":"/remote.php/dav/files/hcoin//InstantUpload/Download/digital%20proof_three%201908_pots.jpg","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.19.0","version":"23.0.0.10"}
{"reqId":"14zabaosZ1rOBUp0aeav","level":0,"time":"2022-02-08T18:44:20+00:00","remoteAddr":"10.12.114.192","user":"hcoin","app":"files_antivirus","method":"PUT","url":"/remote.php/dav/files/hcoin//InstantUpload/Download/digital%20proof_three%201908_pots.jpg","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.19.0","version":"23.0.0.10"}
{"reqId":"14zabaosZ1rOBUp0aeav","level":0,"time":"2022-02-08T18:44:20+00:00","remoteAddr":"10.12.114.192","user":"hcoin","app":"maps","method":"PUT","url":"/remote.php/dav/files/hcoin//InstantUpload/Download/digital%20proof_three%201908_pots.jpg","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.19.0","version":"23.0.0.10"}
{"reqId":"LkEHhcmrHtqSW6SQeubA","level":0,"time":"2022-02-08T18:44:21+00:00","remoteAddr":"10.12.114.192","user":"hcoin","app":"files_antivirus","method":"PROPFIND","url":"/remote.php/dav/files/hcoin//InstantUpload/Download/IMG950449.jpg","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.19.0","version":"23.0.0.10"}
{"reqId":"LkEHhcmrHtqSW6SQeubA","level":0,"time":"2022-02-08T18:44:21+00:00","remoteAddr":"10.12.114.192","user":"hcoin","app":"maps","method":"PROPFIND","url":"/remote.php/dav/files/hcoin//InstantUpload/Download/IMG950449.jpg","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.19.0","version":"23.0.0.10"}
{"reqId":"14zabaosZ1rOBUp0aeav","level":0,"time":"2022-02-08T18:44:21+00:00","remoteAddr":"10.12.114.192","user":"hcoin","app":"files_antivirus","method":"PUT","url":"/remote.php/dav/files/hcoin//InstantUpload/Download/digital%20proof_three%201908_pots.jpg","message":"Response :: stream: OK\n","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.19.0","version":"23.0.0.10"}
{"reqId":"W3hLX62SINZ1Rs0GG1ia","level":0,"time":"2022-02-08T18:44:21+00:00","remoteAddr":"10.12.114.192","user":"hcoin","app":"files_antivirus","method":"GET","url":"/index.php/apps/files/api/v1/thumbnail/256/256/InstantUpload/Download/IMG950449.jpg","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.19.0","version":"23.0.0.10"}
{"reqId":"W3hLX62SINZ1Rs0GG1ia","level":0,"time":"2022-02-08T18:44:21+00:00","remoteAddr":"10.12.114.192","user":"hcoin","app":"maps","method":"GET","url":"/index.php/apps/files/api/v1/thumbnail/256/256/InstantUpload/Download/IMG950449.jpg","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.19.0","version":"23.0.0.10"}
{"reqId":"U55TyFXIW1bpF2Nw0iuo","level":0,"time":"2022-02-08T18:44:22+00:00","remoteAddr":"10.12.114.192","user":"hcoin","app":"files_antivirus","method":"PROPFIND","url":"/remote.php/dav/files/hcoin//InstantUpload/Download/digital%20proof_three%201908_pots.jpg","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.19.0","version":"23.0.0.10"}
{"reqId":"U55TyFXIW1bpF2Nw0iuo","level":0,"time":"2022-02-08T18:44:22+00:00","remoteAddr":"10.12.114.192","user":"hcoin","app":"maps","method":"PROPFIND","url":"/remote.php/dav/files/hcoin//InstantUpload/Download/digital%20proof_three%201908_pots.jpg","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.19.0","version":"23.0.0.10"}
{"reqId":"Vf8rxYSi1PSD3ULEOPcI","level":0,"time":"2022-02-08T18:44:23+00:00","remoteAddr":"10.12.114.192","user":"--","app":"files_antivirus","method":"GET","url":"/index.php/204","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.19.0","version":"23.0.0.10"}
{"reqId":"Vf8rxYSi1PSD3ULEOPcI","level":0,"time":"2022-02-08T18:44:23+00:00","remoteAddr":"10.12.114.192","user":"--","app":"maps","method":"GET","url":"/index.php/204","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.19.0","version":"23.0.0.10"}
{"reqId":"kPghpg71DjjJb48is8Jk","level":0,"time":"2022-02-08T18:44:24+00:00","remoteAddr":"10.12.114.192","user":"hcoin","app":"files_antivirus","method":"HEAD","url":"/remote.php/dav/files/hcoin//InstantUpload/Download/IMG950449.jpg","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.19.0","version":"23.0.0.10"}
{"reqId":"kPghpg71DjjJb48is8Jk","level":0,"time":"2022-02-08T18:44:24+00:00","remoteAddr":"10.12.114.192","user":"hcoin","app":"maps","method":"HEAD","url":"/remote.php/dav/files/hcoin//InstantUpload/Download/IMG950449.jpg","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.19.0","version":"23.0.0.10"}
{"reqId":"GZ9GoiJur6L9wh1Z4Nl0","level":0,"time":"2022-02-08T18:44:24+00:00","remoteAddr":"10.12.114.192","user":"hcoin","app":"files_antivirus","method":"PUT","url":"/remote.php/dav/files/hcoin//InstantUpload/Download/IMG950449.jpg","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.19.0","version":"23.0.0.10"}
{"reqId":"GZ9GoiJur6L9wh1Z4Nl0","level":0,"time":"2022-02-08T18:44:25+00:00","remoteAddr":"10.12.114.192","user":"hcoin","app":"maps","method":"PUT","url":"/remote.php/dav/files/hcoin//InstantUpload/Download/IMG950449.jpg","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.19.0","version":"23.0.0.10"}
{"reqId":"DIqEhZE07m6JGnXfl9hi","level":0,"time":"2022-02-08T18:44:25+00:00","remoteAddr":"10.12.114.192","user":"hcoin","app":"files_antivirus","method":"PROPFIND","url":"/remote.php/dav/files/hcoin//InstantUpload/Download/IMG_2906.jpg","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.19.0","version":"23.0.0.10"}
{"reqId":"DIqEhZE07m6JGnXfl9hi","level":0,"time":"2022-02-08T18:44:25+00:00","remoteAddr":"10.12.114.192","user":"hcoin","app":"maps","method":"PROPFIND","url":"/remote.php/dav/files/hcoin//InstantUpload/Download/IMG_2906.jpg","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.19.0","version":"23.0.0.10"}
{"reqId":"GZ9GoiJur6L9wh1Z4Nl0","level":0,"time":"2022-02-08T18:44:25+00:00","remoteAddr":"10.12.114.192","user":"hcoin","app":"files_antivirus","method":"PUT","url":"/remote.php/dav/files/hcoin//InstantUpload/Download/IMG950449.jpg","message":"Response :: stream: OK\n","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.19.0","version":"23.0.0.10"}
{"reqId":"Qeq7aE6cHtPm4UYGLoqe","level":0,"time":"2022-02-08T18:44:25+00:00","remoteAddr":"10.12.114.192","user":"hcoin","app":"files_antivirus","method":"GET","url":"/index.php/apps/files/api/v1/thumbnail/256/256/InstantUpload/Download/IMG_2906.jpg","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.19.0","version":"23.0.0.10"}
{"reqId":"Qeq7aE6cHtPm4UYGLoqe","level":0,"time":"2022-02-08T18:44:25+00:00","remoteAddr":"10.12.114.192","user":"hcoin","app":"maps","method":"GET","url":"/index.php/apps/files/api/v1/thumbnail/256/256/InstantUpload/Download/IMG_2906.jpg","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.19.0","version":"23.0.0.10"}
{"reqId":"9P0QLbv9pCrN0stQvZNR","level":0,"time":"2022-02-08T18:44:26+00:00","remoteAddr":"10.12.114.192","user":"hcoin","app":"files_antivirus","method":"PROPFIND","url":"/remote.php/dav/files/hcoin//InstantUpload/Download/IMG950449.jpg","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.19.0","version":"23.0.0.10"}
{"reqId":"9P0QLbv9pCrN0stQvZNR","level":0,"time":"2022-02-08T18:44:26+00:00","remoteAddr":"10.12.114.192","user":"hcoin","app":"maps","method":"PROPFIND","url":"/remote.php/dav/files/hcoin//InstantUpload/Download/IMG950449.jpg","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.19.0","version":"23.0.0.10"}
{"reqId":"sSLNvv9OxFA2YSyRV0b8","level":0,"time":"2022-02-08T18:44:27+00:00","remoteAddr":"10.12.114.192","user":"--","app":"files_antivirus","method":"GET","url":"/index.php/204","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.19.0","version":"23.0.0.10"}
{"reqId":"sSLNvv9OxFA2YSyRV0b8","level":0,"time":"2022-02-08T18:44:27+00:00","remoteAddr":"10.12.114.192","user":"--","app":"maps","method":"GET","url":"/index.php/204","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.19.0","version":"23.0.0.10"}
{"reqId":"D9LUhP6BQlVI2M25IcXZ","level":0,"time":"2022-02-08T18:44:28+00:00","remoteAddr":"10.12.114.192","user":"hcoin","app":"files_antivirus","method":"HEAD","url":"/remote.php/dav/files/hcoin//InstantUpload/Download/IMG_2906.jpg","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.19.0","version":"23.0.0.10"}
{"reqId":"D9LUhP6BQlVI2M25IcXZ","level":0,"time":"2022-02-08T18:44:28+00:00","remoteAddr":"10.12.114.192","user":"hcoin","app":"maps","method":"HEAD","url":"/remote.php/dav/files/hcoin//InstantUpload/Download/IMG_2906.jpg","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.19.0","version":"23.0.0.10"}
{"reqId":"fkC6OkgzPAjUlyPCXcsl","level":0,"time":"2022-02-08T18:44:29+00:00","remoteAddr":"10.12.114.192","user":"hcoin","app":"files_antivirus","method":"PUT","url":"/remote.php/dav/files/hcoin//InstantUpload/Download/IMG_2906.jpg","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.19.0","version":"23.0.0.10"}
{"reqId":"fkC6OkgzPAjUlyPCXcsl","level":0,"time":"2022-02-08T18:44:29+00:00","remoteAddr":"10.12.114.192","user":"hcoin","app":"maps","method":"PUT","url":"/remote.php/dav/files/hcoin//InstantUpload/Download/IMG_2906.jpg","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.19.0","version":"23.0.0.10"}
{"reqId":"fkC6OkgzPAjUlyPCXcsl","level":0,"time":"2022-02-08T18:44:29+00:00","remoteAddr":"10.12.114.192","user":"hcoin","app":"files_antivirus","method":"PUT","url":"/remote.php/dav/files/hcoin//InstantUpload/Download/IMG_2906.jpg","message":"Response :: stream: OK\n","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.19.0","version":"23.0.0.10"}
{"reqId":"c2pQOG6ZbUsYL6yDU3BX","level":0,"time":"2022-02-08T18:44:30+00:00","remoteAddr":"10.12.114.192","user":"hcoin","app":"files_antivirus","method":"PROPFIND","url":"/remote.php/dav/files/hcoin//InstantUpload/Download/IMG_2906.jpg","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.19.0","version":"23.0.0.10"}
{"reqId":"c2pQOG6ZbUsYL6yDU3BX","level":0,"time":"2022-02-08T18:44:30+00:00","remoteAddr":"10.12.114.192","user":"hcoin","app":"maps","method":"PROPFIND","url":"/remote.php/dav/files/hcoin//InstantUpload/Download/IMG_2906.jpg","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.19.0","version":"23.0.0.10"}
{"reqId":"7TtnBTilYBfUPFvoJNQj","level":0,"time":"2022-02-08T18:44:31+00:00","remoteAddr":"10.12.114.192","user":"hcoin","app":"files_antivirus","method":"PROPFIND","url":"/remote.php/dav/files/hcoin//InstantUpload/Download/IMG_4102.jpg","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.19.0","version":"23.0.0.10"}
{"reqId":"7TtnBTilYBfUPFvoJNQj","level":0,"time":"2022-02-08T18:44:31+00:00","remoteAddr":"10.12.114.192","user":"hcoin","app":"maps","method":"PROPFIND","url":"/remote.php/dav/files/hcoin//InstantUpload/Download/IMG_4102.jpg","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.19.0","version":"23.0.0.10"}
{"reqId":"8jaHbCXop0DfsLvggY1m","level":0,"time":"2022-02-08T18:44:31+00:00","remoteAddr":"10.12.114.192","user":"hcoin","app":"files_antivirus","method":"GET","url":"/index.php/apps/files/api/v1/thumbnail/256/256/InstantUpload/Download/IMG_4102.jpg","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.19.0","version":"23.0.0.10"}
{"reqId":"8jaHbCXop0DfsLvggY1m","level":0,"time":"2022-02-08T18:44:31+00:00","remoteAddr":"10.12.114.192","user":"hcoin","app":"maps","method":"GET","url":"/index.php/apps/files/api/v1/thumbnail/256/256/InstantUpload/Download/IMG_4102.jpg","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.19.0","version":"23.0.0.10"}
{"reqId":"Sp9mUv2EBPUsEMUPdwZH","level":0,"time":"2022-02-08T18:44:34+00:00","remoteAddr":"10.12.114.192","user":"--","app":"files_antivirus","method":"GET","url":"/index.php/204","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.19.0","version":"23.0.0.10"}
{"reqId":"Sp9mUv2EBPUsEMUPdwZH","level":0,"time":"2022-02-08T18:44:34+00:00","remoteAddr":"10.12.114.192","user":"--","app":"maps","method":"GET","url":"/index.php/204","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.19.0","version":"23.0.0.10"}
{"reqId":"nAzjA23TAc0IhhvO795p","level":0,"time":"2022-02-08T18:44:35+00:00","remoteAddr":"10.12.114.192","user":"hcoin","app":"files_antivirus","method":"HEAD","url":"/remote.php/dav/files/hcoin//InstantUpload/Download/IMG_4102.jpg","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.19.0","version":"23.0.0.10"}
{"reqId":"nAzjA23TAc0IhhvO795p","level":0,"time":"2022-02-08T18:44:35+00:00","remoteAddr":"10.12.114.192","user":"hcoin","app":"maps","method":"HEAD","url":"/remote.php/dav/files/hcoin//InstantUpload/Download/IMG_4102.jpg","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.19.0","version":"23.0.0.10"}
{"reqId":"0X1XPXKt0Vb439dH9q35","level":0,"time":"2022-02-08T18:44:35+00:00","remoteAddr":"10.12.114.192","user":"hcoin","app":"files_antivirus","method":"PUT","url":"/remote.php/dav/files/hcoin//InstantUpload/Download/IMG_4102.jpg","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.19.0","version":"23.0.0.10"}
{"reqId":"0X1XPXKt0Vb439dH9q35","level":0,"time":"2022-02-08T18:44:35+00:00","remoteAddr":"10.12.114.192","user":"hcoin","app":"maps","method":"PUT","url":"/remote.php/dav/files/hcoin//InstantUpload/Download/IMG_4102.jpg","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.19.0","version":"23.0.0.10"}
{"reqId":"0X1XPXKt0Vb439dH9q35","level":0,"time":"2022-02-08T18:44:36+00:00","remoteAddr":"10.12.114.192","user":"hcoin","app":"files_antivirus","method":"PUT","url":"/remote.php/dav/files/hcoin//InstantUpload/Download/IMG_4102.jpg","message":"Response :: stream: OK\n","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.19.0","version":"23.0.0.10"}
{"reqId":"1xEWzFmkoa9J5GgjlSXi","level":0,"time":"2022-02-08T18:44:37+00:00","remoteAddr":"10.12.114.192","user":"hcoin","app":"files_antivirus","method":"PROPFIND","url":"/remote.php/dav/files/hcoin//InstantUpload/Download/IMG_4102.jpg","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.19.0","version":"23.0.0.10"}
{"reqId":"1xEWzFmkoa9J5GgjlSXi","level":0,"time":"2022-02-08T18:44:37+00:00","remoteAddr":"10.12.114.192","user":"hcoin","app":"maps","method":"PROPFIND","url":"/remote.php/dav/files/hcoin//InstantUpload/Download/IMG_4102.jpg","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.19.0","version":"23.0.0.10"}
{"reqId":"eUjczMmGIJKL77ZVgU8J","level":0,"time":"2022-02-08T18:44:48+00:00","remoteAddr":"10.12.114.206","user":"hcoin","app":"user_ldap","method":"PROPFIND","url":"/remote.php/dav/files/hcoin/","message":"initializing paged search for filter (&(&(objectclass=inetorgperson)(memberOf=cn=syncusers,cn=groups,cn=accounts,dc=1,dc=quietfountain,dc=com))(|(uid=Harry Coin)(|(mail=Harry Coin))(cn=Harry Coin))), base cn=users,cn=accounts,dc=1,dc=quietfountain,dc=com, attr [\"entryuuid\",\"nsuniqueid\",\"objectguid\",\"guid\",\"ipauniqueid\",\"dn\",\"uid\",\"samaccountname\",\"memberof\",\"mail\",\"displayname\",\"jpegphoto\",\"thumbnailphoto\"], limit 500, offset 0","userAgent":"Mozilla/5.0 (Linux) mirall/3.2.3-0ubuntu1 (Nextcloud, ubuntu-5.13.0-28-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"23.0.0.10"}
{"reqId":"eUjczMmGIJKL77ZVgU8J","level":0,"time":"2022-02-08T18:44:48+00:00","remoteAddr":"10.12.114.206","user":"hcoin","app":"user_ldap","method":"PROPFIND","url":"/remote.php/dav/files/hcoin/","message":"Ready for a paged search","userAgent":"Mozilla/5.0 (Linux) mirall/3.2.3-0ubuntu1 (Nextcloud, ubuntu-5.13.0-28-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"23.0.0.10"}

Additional info

The above log entries were tail -400 ..nextcloud.log immediately after the error popped up during the scan.

szaimen commented 1 year ago

Hi, please update to 24.0.9 or better 25.0.3 and report back if it fixes the issue. Thank you!

My goal is to add a label like e.g. 25-feedback to this ticket of an up-to-date major Nextcloud version where the bug could be reproduced. However this is not going to work without your help. So thanks for all your effort!

If you don't manage to reproduce the issue in time and the issue gets closed but you can reproduce the issue afterwards, feel free to create a new bug report with up-to-date information by following this link: https://github.com/nextcloud/server/issues/new?assignees=&labels=bug%2C0.+Needs+triage&template=BUG_REPORT.yml&title=%5BBug%5D%3A+