[Bug]: LockWaitTimeoutException SQLSTATE[HY000]

⚠️ This issue respects the following points: ⚠️

• This is a bug, not a question or a configuration/webserver/proxy issue.
• This issue is not already reported on Github OR Nextcloud Community Forum (I've searched it).
• Nextcloud Server is up to date. See Maintenance and Release Schedule for supported versions.
• I agree to follow Nextcloud's Code of Conduct.

Bug description

Hi,
i had this in my error log and i don't understand why and from where it came.

[files] Fehler: Error while trying to scan mount as /USER_A/files/Easyjob/:An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction von ? von -- um 03.02.2025, 23:21:10

Steps to reproduce

i don't know

Expected behavior

no errors

Nextcloud Server version

30

Operating system

Debian/Ubuntu

PHP engine version

PHP 8.2

Web server

Apache (supported)

Database engine version

MariaDB

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

Updated from a MINOR version (ex. 32.0.1 to 32.0.2)

Are you using the Nextcloud Server Encryption module?

Encryption is Disabled

What user-backends are you using?

• Default user-backend (database)
• LDAP/ Active Directory
• SSO - SAML
• Other

Configuration report

{
    "system": {
        "htaccess.RewriteBase": "\/",
        "htaccess.IgnoreFrontController": true,
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "remember_login_cookie_lifetime": 1296000,
        "session_lifetime": 86400,
        "maintenance_window_start": 1,
        "trusted_domains": [
            "example.cloud",
            "xxx.xxx.xxx.xxx"
        ],
        "trusted_proxies": "***REMOVED SENSITIVE VALUE***",
        "forwarded_for_headers": [
            "HTTP_X_FORWARDED",
            "HTTP_FORWARDED_FOR"
        ],
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "mysql",
        "version": "30.0.5.1",
        "overwritehost": "example.cloud",
        "overwrite.cli.url": "https:\/\/example.cloud",
        "overwriteprotocol": "https",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "3306",
        "dbtableprefix": "oc_",
        "mysql.utf8mb4": true,
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "memcache.distributed": "\\OC\\Memcache\\Redis",
        "memcache.local": "\\OC\\Memcache\\APCu",
        "memcache.locking": "\\OC\\Memcache\\Redis",
        "redis": {
            "host": "***REMOVED SENSITIVE VALUE***",
            "port": 6379,
            "timeout": 0
        },
        "share_folder": "\/Freigaben\/",
        "default_phone_region": "DE",
        "mail_smtpmode": "smtp",
        "mail_smtpsecure": "ssl",
        "mail_sendmailmode": "smtp",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpauthtype": "LOGIN",
        "mail_smtpauth": 1,
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "465",
        "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
        "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
        "ldapProviderFactory": "OCA\\User_LDAP\\LDAPProviderFactory",
        "default_language": "de",
        "default_locale": "de_DE",
        "maintenance": false,
        "theme": "",
        "log_type": "file",
        "logfile": "data\/nextcloud.log",
        "loglevel": 3,
        "log_query": false,
        "logdateformat": "F d, Y H:i:s",
        "data-fingerprint": "e44d43c3e65df6adac8a7438fbd32141",
        "enforce_theme": "",
        "enable_previews": true,
        "enabledPreviewProviders": [
            "OC\\Preview\\TXT",
            "OC\\Preview\\MarkDown",
            "OC\\Preview\\OpenDocument",
            "OC\\Preview\\PDF",
            "OC\\Preview\\MSOffice2003",
            "OC\\Preview\\MSOfficeDoc",
            "OC\\Preview\\HEIC",
            "OC\\Preview\\Image",
            "OC\\Preview\\Photoshop",
            "OC\\Preview\\TIFF",
            "OC\\Preview\\SVG",
            "OC\\Preview\\Font",
            "OC\\Preview\\MP3",
            "OC\\Preview\\Movie",
            "OC\\Preview\\MKV",
            "OC\\Preview\\MP4",
            "OC\\Preview\\AVI",
            "OC\\Preview\\ARW",
            "OC\\Preview\\PNG",
            "OC\\Preview\\JPEG",
            "OC\\Preview\\GIF",
            "OC\\Preview\\BMP",
            "OC\\Preview\\XBitmap",
            "OC\\Preview\\MSOffice2007",
            "OC\\Preview\\Imaginary",
            "OC\\Preview\\MD",
            "OC\\Preview\\Illustrator",
            "OC\\Preview\\Postscript",
            "OC\\Preview\\StarOffice",
            "OC\\Preview\\EMF",
            "OC\\Preview\\Krita"
        ],
        "preview_imaginary_url": "***REMOVED SENSITIVE VALUE***",
        "preview_libreoffice_path": "\/usr\/bin\/libreoffice",
        "preview_ffmpeg_path": "\/usr\/bin\/ffmpeg",
        "preview_max_x": 512,
        "preview_max_y": 512,
        "preview_max_filesize_image": 50,
        "preview_max_memory": 128,
        "activity_expire_days": 14,
        "trashbin_retention_obligation": "auto",
        "login_form_autocomplete": true,
        "simpleSignUpLink.shown": false,
        "session_relaxed_expiry": true,
        "session_keepalive": true,
        "versions_retention_obligation": "auto",
        "minimum.supported.desktop.version": "3.15.3",
        "allow_local_remote_servers": true,
        "forbidden_filenames": [
            ".htaccess",
            "#recycle",
            ".Trash-1000",
            "._sync*",
            "@eaDir",
            ".htaccess",
            "Thumbs.db",
            ".DS_Store"
        ],
        "forbidden_filename_characters": [
            "<",
            ">",
            ":",
            "\"",
            "|",
            "?",
            "*",
            "\\",
            "\/",
            "~$"
        ],
        "forbidden_filename_extensions": [
            " ",
            ".",
            ".filepart",
            ".part",
            ".lck",
            ".lnk",
            ".~lst"
        ],
        "forbidden_filename_basenames": [
            "con",
            "prn",
            "aux",
            "nul",
            "com0",
            "com1",
            "com2",
            "com3",
            "com4",
            "com5",
            "com6",
            "com7",
            "com8",
            "com9",
            "com\u00b9",
            "com\u00b2",
            "com\u00b3",
            "lpt0",
            "lpt1",
            "lpt2",
            "lpt3",
            "lpt4",
            "lpt5",
            "lpt6",
            "lpt7",
            "lpt8",
            "lpt9",
            "lpt\u00b9",
            "lpt\u00b2",
            "lpt\u00b3"
        ],
        "auth.bruteforce.protection.enabled": true
    }
}

List of activated Apps

Enabled:
  - activity: 3.0.0
  - analytics: 5.2.4
  - app_api: 4.0.5
  - bookmarks: 15.0.5
  - bruteforcesettings: 3.0.0
  - calendar: 5.0.9
  - calendar_resource_management: 0.8.0
  - circles: 30.0.0
  - cloud_federation_api: 1.13.0
  - comments: 1.20.1
  - contacts: 6.1.3
  - dashboard: 7.10.0
  - dav: 1.31.1
  - drawio: 3.0.3
  - external: 5.5.2
  - federatedfilesharing: 1.20.0
  - federation: 1.20.0
  - files: 2.2.0
  - files_antivirus: 5.6.1
  - files_automatedtagging: 1.20.0
  - files_external: 1.22.0
  - files_pdfviewer: 3.0.0
  - files_reminders: 1.3.0
  - files_retention: 1.19.0
  - files_sharing: 1.22.0
  - files_trashbin: 1.20.1
  - files_versions: 1.23.0
  - firstrunwizard: 3.0.0
  - forms: 4.3.5
  - guests: 4.1.0
  - impersonate: 1.17.1
  - integration_giphy: 2.0.1
  - logreader: 3.0.0
  - lookup_server_connector: 1.18.0
  - mail: 4.1.2
  - memegen: 1.1.1
  - notifications: 3.0.0
  - notify_push: 1.0.0
  - oauth2: 1.18.1
  - password_policy: 2.0.0
  - passwords: 2024.12.21
  - phonetrack: 0.8.2
  - photos: 3.0.2
  - polls: 7.2.9
  - previewgenerator: 5.7.0
  - privacy: 2.0.0
  - provisioning_api: 1.20.0
  - quota_warning: 1.20.0
  - related_resources: 1.5.0
  - richdocuments: 8.5.3
  - serverinfo: 2.0.0
  - settings: 1.13.0
  - sharebymail: 1.20.0
  - sharereview: 1.3.3
  - side_menu: 4.0.1
  - spreed: 20.1.3
  - systemtags: 1.20.0
  - terms_of_service: 4.1.0
  - text: 4.1.0
  - theming: 2.5.0
  - theming_customcss: 1.18.0
  - translate: 2.2.0
  - twofactor_backupcodes: 1.19.0
  - updatenotification: 1.20.0
  - user_ldap: 1.21.0
  - user_status: 1.10.0
  - viewer: 3.0.0
  - webhook_listeners: 1.1.0-dev
  - workflow_ocr: 1.30.1
  - workflowengine: 2.12.0
Disabled:
  - admin_audit: 1.20.0 (installed 1.20.0)
  - contactsinteraction: 1.11.0 (installed 1.6.0)
  - encryption: 2.18.0
  - files_downloadlimit: 3.0.0 (installed 1.1.0)
  - nextcloud_announcements: 2.0.0 (installed 1.12.0)
  - recommendations: 3.0.0 (installed 1.2.0)
  - support: 2.0.0 (installed 1.6.0)
  - survey_client: 2.0.0 (installed 1.11.0)
  - suspicious_login: 8.0.0
  - twofactor_nextcloud_notification: 4.0.0
  - twofactor_totp: 12.0.0-dev
  - weather_status: 1.10.0 (installed 1.3.0)

Nextcloud Signing status

No errors have been found.

Nextcloud Logs

{"reqId":"COCvPCFitDJ53X6tUppn","level":3,"time":"2025-02-03T21:46:29+00:00","remoteAddr":"","user":"--","app":"files","method":"","url":"--","message":"Error while trying to scan mount as /USER_A/files/Easyjob/:An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction","userAgent":"--","version":"30.0.5.1","exception":{"Exception":"Doctrine\\DBAL\\Exception\\LockWaitTimeoutException","Message":"An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction","Code":1205,"Trace":[{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1939,"function":"convert","class":"Doctrine\\DBAL\\Driver\\API\\MySQL\\ExceptionConverter","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1881,"function":"handleDriverException","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1213,"function":"convertExceptionDuringQuery","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php","line":292,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/DB/Connection.php","line":462,"function":"executeStatement","class":"Doctrine\\DBAL\\Connections\\PrimaryReadReplicaConnection","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/DB/ConnectionAdapter.php","line":67,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":306,"function":"executeStatement","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/DB/QueryBuilder/ExtendedQueryBuilder.php","line":289,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/DB/QueryBuilder/ExtendedQueryBuilder.php","line":55,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\ExtendedQueryBuilder","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/Files/Cache/Cache.php","line":358,"function":"execute","class":"OC\\DB\\QueryBuilder\\ExtendedQueryBuilder","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/Files/Cache/Scanner.php","line":281,"function":"update","class":"OC\\Files\\Cache\\Cache","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/Files/Cache/Scanner.php","line":217,"function":"addToCache","class":"OC\\Files\\Cache\\Scanner","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/Files/Cache/Scanner.php","line":329,"function":"scanFile","class":"OC\\Files\\Cache\\Scanner","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/Files/Cache/Scanner.php","line":598,"function":"scan","class":"OC\\Files\\Cache\\Scanner","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/Files/Cache/Scanner.php","line":610,"function":"OC\\Files\\Cache\\{closure}","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/Files/Cache/Scanner.php","line":597,"function":"runBackgroundScanJob","class":"OC\\Files\\Cache\\Scanner","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/Files/Utils/Scanner.php","line":163,"function":"backgroundScan","class":"OC\\Files\\Cache\\Scanner","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/apps/files/lib/BackgroundJob/ScanFiles.php","line":60,"function":"backgroundScan","class":"OC\\Files\\Utils\\Scanner","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/apps/files/lib/BackgroundJob/ScanFiles.php","line":143,"function":"runScanner","class":"OCA\\Files\\BackgroundJob\\ScanFiles","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/public/BackgroundJob/Job.php","line":61,"function":"run","class":"OCA\\Files\\BackgroundJob\\ScanFiles","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/public/BackgroundJob/TimedJob.php","line":88,"function":"start","class":"OCP\\BackgroundJob\\Job","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/public/BackgroundJob/TimedJob.php","line":75,"function":"start","class":"OCP\\BackgroundJob\\TimedJob","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/cron.php","line":162,"function":"execute","class":"OCP\\BackgroundJob\\TimedJob","type":"->"}],"File":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php","Line":42,"Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDO\\Exception","Message":"SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction","Code":1205,"Trace":[{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":132,"function":"new","class":"Doctrine\\DBAL\\Driver\\PDO\\Exception","type":"::"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1207,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php","line":292,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/DB/Connection.php","line":462,"function":"executeStatement","class":"Doctrine\\DBAL\\Connections\\PrimaryReadReplicaConnection","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/DB/ConnectionAdapter.php","line":67,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":306,"function":"executeStatement","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/DB/QueryBuilder/ExtendedQueryBuilder.php","line":289,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/DB/QueryBuilder/ExtendedQueryBuilder.php","line":55,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\ExtendedQueryBuilder","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/Files/Cache/Cache.php","line":358,"function":"execute","class":"OC\\DB\\QueryBuilder\\ExtendedQueryBuilder","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/Files/Cache/Scanner.php","line":281,"function":"update","class":"OC\\Files\\Cache\\Cache","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/Files/Cache/Scanner.php","line":217,"function":"addToCache","class":"OC\\Files\\Cache\\Scanner","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/Files/Cache/Scanner.php","line":329,"function":"scanFile","class":"OC\\Files\\Cache\\Scanner","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/Files/Cache/Scanner.php","line":598,"function":"scan","class":"OC\\Files\\Cache\\Scanner","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/Files/Cache/Scanner.php","line":610,"function":"OC\\Files\\Cache\\{closure}","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/Files/Cache/Scanner.php","line":597,"function":"runBackgroundScanJob","class":"OC\\Files\\Cache\\Scanner","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/Files/Utils/Scanner.php","line":163,"function":"backgroundScan","class":"OC\\Files\\Cache\\Scanner","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/apps/files/lib/BackgroundJob/ScanFiles.php","line":60,"function":"backgroundScan","class":"OC\\Files\\Utils\\Scanner","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/apps/files/lib/BackgroundJob/ScanFiles.php","line":143,"function":"runScanner","class":"OCA\\Files\\BackgroundJob\\ScanFiles","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/public/BackgroundJob/Job.php","line":61,"function":"run","class":"OCA\\Files\\BackgroundJob\\ScanFiles","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/public/BackgroundJob/TimedJob.php","line":88,"function":"start","class":"OCP\\BackgroundJob\\Job","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/public/BackgroundJob/TimedJob.php","line":75,"function":"start","class":"OCP\\BackgroundJob\\TimedJob","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/cron.php","line":162,"function":"execute","class":"OCP\\BackgroundJob\\TimedJob","type":"->"}],"File":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php","Line":28,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction","Code":"HY000","Trace":[{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":130,"function":"execute","class":"PDOStatement","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1207,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php","line":292,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/DB/Connection.php","line":462,"function":"executeStatement","class":"Doctrine\\DBAL\\Connections\\PrimaryReadReplicaConnection","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/DB/ConnectionAdapter.php","line":67,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":306,"function":"executeStatement","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/DB/QueryBuilder/ExtendedQueryBuilder.php","line":289,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/DB/QueryBuilder/ExtendedQueryBuilder.php","line":55,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\ExtendedQueryBuilder","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/Files/Cache/Cache.php","line":358,"function":"execute","class":"OC\\DB\\QueryBuilder\\ExtendedQueryBuilder","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/Files/Cache/Scanner.php","line":281,"function":"update","class":"OC\\Files\\Cache\\Cache","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/Files/Cache/Scanner.php","line":217,"function":"addToCache","class":"OC\\Files\\Cache\\Scanner","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/Files/Cache/Scanner.php","line":329,"function":"scanFile","class":"OC\\Files\\Cache\\Scanner","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/Files/Cache/Scanner.php","line":598,"function":"scan","class":"OC\\Files\\Cache\\Scanner","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/Files/Cache/Scanner.php","line":610,"function":"OC\\Files\\Cache\\{closure}","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/Files/Cache/Scanner.php","line":597,"function":"runBackgroundScanJob","class":"OC\\Files\\Cache\\Scanner","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/Files/Utils/Scanner.php","line":163,"function":"backgroundScan","class":"OC\\Files\\Cache\\Scanner","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/apps/files/lib/BackgroundJob/ScanFiles.php","line":60,"function":"backgroundScan","class":"OC\\Files\\Utils\\Scanner","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/apps/files/lib/BackgroundJob/ScanFiles.php","line":143,"function":"runScanner","class":"OCA\\Files\\BackgroundJob\\ScanFiles","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/public/BackgroundJob/Job.php","line":61,"function":"run","class":"OCA\\Files\\BackgroundJob\\ScanFiles","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/public/BackgroundJob/TimedJob.php","line":88,"function":"start","class":"OCP\\BackgroundJob\\Job","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/public/BackgroundJob/TimedJob.php","line":75,"function":"start","class":"OCP\\BackgroundJob\\TimedJob","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/cron.php","line":162,"function":"execute","class":"OCP\\BackgroundJob\\TimedJob","type":"->"}],"File":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","Line":130}},"message":"Error while trying to scan mount as /USER_A/files/Easyjob/:An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction","exception":[],"CustomMessage":"Error while trying to scan mount as /USER_A/files/Easyjob/:An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction"},"id":"67a14090dd67f"}
{"reqId":"COCvPCFitDJ53X6tUppn","level":2,"time":"2025-02-03T21:46:33+00:00","remoteAddr":"","user":"--","app":"files","method":"","url":"--","message":"User USER_A still has unscanned files after running background scan, background scan might be stopped prematurely","userAgent":"--","version":"30.0.5.1","data":{"app":"files"},"id":"67a14090dd5ef"}
{"reqId":"RL91U6EhnaNNiDyiWt17","level":3,"time":"2025-02-03T21:57:59+00:00","remoteAddr":"","user":"--","app":"files","method":"","url":"--","message":"Error while trying to scan mount as /USER_A/files/Easyjob/:An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction","userAgent":"--","version":"30.0.5.1","exception":{"Exception":"Doctrine\\DBAL\\Exception\\LockWaitTimeoutException","Message":"An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction","Code":1205,"Trace":[{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1939,"function":"convert","class":"Doctrine\\DBAL\\Driver\\API\\MySQL\\ExceptionConverter","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1881,"function":"handleDriverException","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1213,"function":"convertExceptionDuringQuery","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php","line":292,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/DB/Connection.php","line":462,"function":"executeStatement","class":"Doctrine\\DBAL\\Connections\\PrimaryReadReplicaConnection","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/DB/ConnectionAdapter.php","line":67,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":306,"function":"executeStatement","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/DB/QueryBuilder/ExtendedQueryBuilder.php","line":289,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/DB/QueryBuilder/ExtendedQueryBuilder.php","line":55,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\ExtendedQueryBuilder","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/Files/Cache/Cache.php","line":358,"function":"execute","class":"OC\\DB\\QueryBuilder\\ExtendedQueryBuilder","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/Files/Cache/Scanner.php","line":281,"function":"update","class":"OC\\Files\\Cache\\Cache","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/Files/Cache/Scanner.php","line":217,"function":"addToCache","class":"OC\\Files\\Cache\\Scanner","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/Files/Cache/Scanner.php","line":329,"function":"scanFile","class":"OC\\Files\\Cache\\Scanner","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/Files/Cache/Scanner.php","line":598,"function":"scan","class":"OC\\Files\\Cache\\Scanner","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/Files/Cache/Scanner.php","line":610,"function":"OC\\Files\\Cache\\{closure}","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/Files/Cache/Scanner.php","line":597,"function":"runBackgroundScanJob","class":"OC\\Files\\Cache\\Scanner","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/Files/Utils/Scanner.php","line":163,"function":"backgroundScan","class":"OC\\Files\\Cache\\Scanner","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/apps/files/lib/BackgroundJob/ScanFiles.php","line":60,"function":"backgroundScan","class":"OC\\Files\\Utils\\Scanner","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/apps/files/lib/BackgroundJob/ScanFiles.php","line":143,"function":"runScanner","class":"OCA\\Files\\BackgroundJob\\ScanFiles","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/public/BackgroundJob/Job.php","line":61,"function":"run","class":"OCA\\Files\\BackgroundJob\\ScanFiles","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/public/BackgroundJob/TimedJob.php","line":88,"function":"start","class":"OCP\\BackgroundJob\\Job","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/public/BackgroundJob/TimedJob.php","line":75,"function":"start","class":"OCP\\BackgroundJob\\TimedJob","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/cron.php","line":162,"function":"execute","class":"OCP\\BackgroundJob\\TimedJob","type":"->"}],"File":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php","Line":42,"Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDO\\Exception","Message":"SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction","Code":1205,"Trace":[{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":132,"function":"new","class":"Doctrine\\DBAL\\Driver\\PDO\\Exception","type":"::"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1207,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php","line":292,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/DB/Connection.php","line":462,"function":"executeStatement","class":"Doctrine\\DBAL\\Connections\\PrimaryReadReplicaConnection","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/DB/ConnectionAdapter.php","line":67,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":306,"function":"executeStatement","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/DB/QueryBuilder/ExtendedQueryBuilder.php","line":289,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/DB/QueryBuilder/ExtendedQueryBuilder.php","line":55,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\ExtendedQueryBuilder","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/Files/Cache/Cache.php","line":358,"function":"execute","class":"OC\\DB\\QueryBuilder\\ExtendedQueryBuilder","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/Files/Cache/Scanner.php","line":281,"function":"update","class":"OC\\Files\\Cache\\Cache","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/Files/Cache/Scanner.php","line":217,"function":"addToCache","class":"OC\\Files\\Cache\\Scanner","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/Files/Cache/Scanner.php","line":329,"function":"scanFile","class":"OC\\Files\\Cache\\Scanner","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/Files/Cache/Scanner.php","line":598,"function":"scan","class":"OC\\Files\\Cache\\Scanner","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/Files/Cache/Scanner.php","line":610,"function":"OC\\Files\\Cache\\{closure}","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/Files/Cache/Scanner.php","line":597,"function":"runBackgroundScanJob","class":"OC\\Files\\Cache\\Scanner","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/Files/Utils/Scanner.php","line":163,"function":"backgroundScan","class":"OC\\Files\\Cache\\Scanner","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/apps/files/lib/BackgroundJob/ScanFiles.php","line":60,"function":"backgroundScan","class":"OC\\Files\\Utils\\Scanner","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/apps/files/lib/BackgroundJob/ScanFiles.php","line":143,"function":"runScanner","class":"OCA\\Files\\BackgroundJob\\ScanFiles","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/public/BackgroundJob/Job.php","line":61,"function":"run","class":"OCA\\Files\\BackgroundJob\\ScanFiles","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/public/BackgroundJob/TimedJob.php","line":88,"function":"start","class":"OCP\\BackgroundJob\\Job","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/public/BackgroundJob/TimedJob.php","line":75,"function":"start","class":"OCP\\BackgroundJob\\TimedJob","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/cron.php","line":162,"function":"execute","class":"OCP\\BackgroundJob\\TimedJob","type":"->"}],"File":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php","Line":28,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction","Code":"HY000","Trace":[{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":130,"function":"execute","class":"PDOStatement","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1207,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php","line":292,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/DB/Connection.php","line":462,"function":"executeStatement","class":"Doctrine\\DBAL\\Connections\\PrimaryReadReplicaConnection","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/DB/ConnectionAdapter.php","line":67,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":306,"function":"executeStatement","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/DB/QueryBuilder/ExtendedQueryBuilder.php","line":289,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/DB/QueryBuilder/ExtendedQueryBuilder.php","line":55,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\ExtendedQueryBuilder","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/Files/Cache/Cache.php","line":358,"function":"execute","class":"OC\\DB\\QueryBuilder\\ExtendedQueryBuilder","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/Files/Cache/Scanner.php","line":281,"function":"update","class":"OC\\Files\\Cache\\Cache","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/Files/Cache/Scanner.php","line":217,"function":"addToCache","class":"OC\\Files\\Cache\\Scanner","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/Files/Cache/Scanner.php","line":329,"function":"scanFile","class":"OC\\Files\\Cache\\Scanner","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/Files/Cache/Scanner.php","line":598,"function":"scan","class":"OC\\Files\\Cache\\Scanner","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/Files/Cache/Scanner.php","line":610,"function":"OC\\Files\\Cache\\{closure}","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/Files/Cache/Scanner.php","line":597,"function":"runBackgroundScanJob","class":"OC\\Files\\Cache\\Scanner","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/Files/Utils/Scanner.php","line":163,"function":"backgroundScan","class":"OC\\Files\\Cache\\Scanner","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/apps/files/lib/BackgroundJob/ScanFiles.php","line":60,"function":"backgroundScan","class":"OC\\Files\\Utils\\Scanner","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/apps/files/lib/BackgroundJob/ScanFiles.php","line":143,"function":"runScanner","class":"OCA\\Files\\BackgroundJob\\ScanFiles","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/public/BackgroundJob/Job.php","line":61,"function":"run","class":"OCA\\Files\\BackgroundJob\\ScanFiles","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/public/BackgroundJob/TimedJob.php","line":88,"function":"start","class":"OCP\\BackgroundJob\\Job","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/public/BackgroundJob/TimedJob.php","line":75,"function":"start","class":"OCP\\BackgroundJob\\TimedJob","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/cron.php","line":162,"function":"execute","class":"OCP\\BackgroundJob\\TimedJob","type":"->"}],"File":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","Line":130}},"message":"Error while trying to scan mount as /USER_A/files/Easyjob/:An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction","exception":[],"CustomMessage":"Error while trying to scan mount as /USER_A/files/Easyjob/:An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction"},"id":"67a14090dd5e4"}
{"reqId":"YY4pQDWcemL1TakzjfnJ","level":3,"time":"2025-02-03T22:10:37+00:00","remoteAddr":"","user":"--","app":"core","method":"","url":"--","message":"Error while running background job OCA\\Files\\BackgroundJob\\DeleteOrphanedItems (id: 30983, arguments: null)","userAgent":"--","version":"30.0.5.1","exception":{"Exception":"OC\\DB\\Exceptions\\DbalException","Message":"An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction","Code":1205,"Trace":[{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/DB/ConnectionAdapter.php","line":69,"function":"wrap","class":"OC\\DB\\Exceptions\\DbalException","type":"::"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":306,"function":"executeStatement","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/apps/files/lib/BackgroundJob/DeleteOrphanedItems.php","line":88,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/apps/files/lib/BackgroundJob/DeleteOrphanedItems.php","line":140,"function":"cleanUp","class":"OCA\\Files\\BackgroundJob\\DeleteOrphanedItems","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/apps/files/lib/BackgroundJob/DeleteOrphanedItems.php","line":40,"function":"cleanSystemTags","class":"OCA\\Files\\BackgroundJob\\DeleteOrphanedItems","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/public/BackgroundJob/Job.php","line":61,"function":"run","class":"OCA\\Files\\BackgroundJob\\DeleteOrphanedItems","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/public/BackgroundJob/TimedJob.php","line":88,"function":"start","class":"OCP\\BackgroundJob\\Job","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/public/BackgroundJob/TimedJob.php","line":75,"function":"start","class":"OCP\\BackgroundJob\\TimedJob","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/cron.php","line":162,"function":"execute","class":"OCP\\BackgroundJob\\TimedJob","type":"->"}],"File":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/DB/Exceptions/DbalException.php","Line":54,"Previous":{"Exception":"Doctrine\\DBAL\\Exception\\LockWaitTimeoutException","Message":"An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction","Code":1205,"Trace":[{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1939,"function":"convert","class":"Doctrine\\DBAL\\Driver\\API\\MySQL\\ExceptionConverter","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1881,"function":"handleDriverException","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1213,"function":"convertExceptionDuringQuery","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php","line":292,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/DB/Connection.php","line":462,"function":"executeStatement","class":"Doctrine\\DBAL\\Connections\\PrimaryReadReplicaConnection","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/DB/ConnectionAdapter.php","line":67,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":306,"function":"executeStatement","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/apps/files/lib/BackgroundJob/DeleteOrphanedItems.php","line":88,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/apps/files/lib/BackgroundJob/DeleteOrphanedItems.php","line":140,"function":"cleanUp","class":"OCA\\Files\\BackgroundJob\\DeleteOrphanedItems","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/apps/files/lib/BackgroundJob/DeleteOrphanedItems.php","line":40,"function":"cleanSystemTags","class":"OCA\\Files\\BackgroundJob\\DeleteOrphanedItems","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/public/BackgroundJob/Job.php","line":61,"function":"run","class":"OCA\\Files\\BackgroundJob\\DeleteOrphanedItems","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/public/BackgroundJob/TimedJob.php","line":88,"function":"start","class":"OCP\\BackgroundJob\\Job","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/public/BackgroundJob/TimedJob.php","line":75,"function":"start","class":"OCP\\BackgroundJob\\TimedJob","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/cron.php","line":162,"function":"execute","class":"OCP\\BackgroundJob\\TimedJob","type":"->"}],"File":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php","Line":42,"Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDO\\Exception","Message":"SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction","Code":1205,"Trace":[{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":132,"function":"new","class":"Doctrine\\DBAL\\Driver\\PDO\\Exception","type":"::"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1207,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php","line":292,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/DB/Connection.php","line":462,"function":"executeStatement","class":"Doctrine\\DBAL\\Connections\\PrimaryReadReplicaConnection","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/DB/ConnectionAdapter.php","line":67,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":306,"function":"executeStatement","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/apps/files/lib/BackgroundJob/DeleteOrphanedItems.php","line":88,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/apps/files/lib/BackgroundJob/DeleteOrphanedItems.php","line":140,"function":"cleanUp","class":"OCA\\Files\\BackgroundJob\\DeleteOrphanedItems","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/apps/files/lib/BackgroundJob/DeleteOrphanedItems.php","line":40,"function":"cleanSystemTags","class":"OCA\\Files\\BackgroundJob\\DeleteOrphanedItems","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/public/BackgroundJob/Job.php","line":61,"function":"run","class":"OCA\\Files\\BackgroundJob\\DeleteOrphanedItems","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/public/BackgroundJob/TimedJob.php","line":88,"function":"start","class":"OCP\\BackgroundJob\\Job","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/public/BackgroundJob/TimedJob.php","line":75,"function":"start","class":"OCP\\BackgroundJob\\TimedJob","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/cron.php","line":162,"function":"execute","class":"OCP\\BackgroundJob\\TimedJob","type":"->"}],"File":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php","Line":28,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction","Code":"HY000","Trace":[{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":130,"function":"execute","class":"PDOStatement","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1207,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php","line":292,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/DB/Connection.php","line":462,"function":"executeStatement","class":"Doctrine\\DBAL\\Connections\\PrimaryReadReplicaConnection","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/DB/ConnectionAdapter.php","line":67,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":306,"function":"executeStatement","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/apps/files/lib/BackgroundJob/DeleteOrphanedItems.php","line":88,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/apps/files/lib/BackgroundJob/DeleteOrphanedItems.php","line":140,"function":"cleanUp","class":"OCA\\Files\\BackgroundJob\\DeleteOrphanedItems","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/apps/files/lib/BackgroundJob/DeleteOrphanedItems.php","line":40,"function":"cleanSystemTags","class":"OCA\\Files\\BackgroundJob\\DeleteOrphanedItems","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/public/BackgroundJob/Job.php","line":61,"function":"run","class":"OCA\\Files\\BackgroundJob\\DeleteOrphanedItems","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/public/BackgroundJob/TimedJob.php","line":88,"function":"start","class":"OCP\\BackgroundJob\\Job","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/lib/public/BackgroundJob/TimedJob.php","line":75,"function":"start","class":"OCP\\BackgroundJob\\TimedJob","type":"->"},{"file":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/cron.php","line":162,"function":"execute","class":"OCP\\BackgroundJob\\TimedJob","type":"->"}],"File":"/var/www/vhosts/example.cloud/httpdocs/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","Line":130}}},"message":"Error while running background job OCA\\Files\\BackgroundJob\\DeleteOrphanedItems (id: 30983, arguments: null)","exception":[],"CustomMessage":"Error while running background job OCA\\Files\\BackgroundJob\\DeleteOrphanedItems (id: 30983, arguments: null)"},"id":"67a14090dd4a3"}

Additional info

the mountpoint is only one smb storages of our nextcloud we use the save credentials in database from user to login there.
But it is only this user with the problem.

Start with the lock-timeout trace in lib/private/DB/Connection.php and the files mount scan reported for /USER_A/files/Easyjob/. Determine which query and concurrent operation cause the MariaDB timeout, then verify the behavior with a reproducible scan scenario. Done means the scan no longer produces the reported LockWaitTimeoutException without introducing new database errors.