Doctrine\DBAL\Exception\LockWaitTimeoutException: An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction

[AndyXheli]

Nextcloud 21.0.2
Apache2
Redis
PHP 8

Nextcloud log (data/nextcloud.log)

Nextcloud log

{"reqId":"5JqX9NPzO0nJhxTEyGGc","level":3,"time":"2021-06-28T01:42:55+00:00","remoteAddr":"1.1.2.1","user":"admin","app":"index","method":"GET","url":"/core/preview?fileId=665284&c=ca563091bf053aa9359470fafd644b94&x=500&y=500&forceIcon=0&a=0","message":{"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/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1728,"function":"convert","class":"Doctrine\\DBAL\\Driver\\API\\MySQL\\ExceptionConverter","type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1667,"function":"handleDriverException","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1146,"function":"convertExceptionDuringQuery","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/Connection.php","line":257,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":213,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":287,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/Cache/Cache.php","line":377,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/Cache/Wrapper/CacheWrapper.php","line":141,"function":"update","class":"OC\\Files\\Cache\\Cache","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/lib/private/Files/Cache/Updater.php","line":257,"function":"update","class":"OC\\Files\\Cache\\Wrapper\\CacheWrapper","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/lib/private/Files/Cache/Updater.php","line":139,"function":"correctParentStorageMtime","class":"OC\\Files\\Cache\\Updater","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/View.php","line":324,"function":"update","class":"OC\\Files\\Cache\\Updater","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/lib/private/Files/View.php","line":1187,"function":"writeUpdate","class":"OC\\Files\\View","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/View.php","line":707,"function":"basicOperation","class":"OC\\Files\\View","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/Node/Folder.php","line":201,"function":"file_put_contents","class":"OC\\Files\\View","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/SimpleFS/NewSimpleFile.php","line":134,"function":"newFile","class":"OC\\Files\\Node\\Folder","type":"->"},{"file":"/var/www/nextcloud/lib/private/Preview/Generator.php","line":436,"function":"putContent","class":"OC\\Files\\SimpleFS\\NewSimpleFile","type":"->"},{"file":"/var/www/nextcloud/lib/private/Preview/Generator.php","line":186,"function":"generatePreview","class":"OC\\Preview\\Generator","type":"->"},{"file":"/var/www/nextcloud/lib/private/Preview/Generator.php","line":109,"function":"generatePreviews","class":"OC\\Preview\\Generator","type":"->"},{"file":"/var/www/nextcloud/lib/private/PreviewManager.php","line":190,"function":"getPreview","class":"OC\\Preview\\Generator","type":"->"},{"file":"/var/www/nextcloud/core/Controller/PreviewController.php","line":170,"function":"getPreview","class":"OC\\PreviewManager","type":"->"},{"file":"/var/www/nextcloud/core/Controller/PreviewController.php","line":143,"function":"fetchPreview","class":"OC\\Core\\Controller\\PreviewController","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":218,"function":"getPreviewByFileId","class":"OC\\Core\\Controller\\PreviewController","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":127,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/App.php","line":157,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/Route/Router.php","line":302,"function":"main","class":"OC\\AppFramework\\App","type":"::"},{"file":"/var/www/nextcloud/lib/base.php","line":993,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/var/www/nextcloud/index.php","line":37,"function":"handleRequest","class":"OC","type":"::"}],"File":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php","Line":40,"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/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":84,"function":"new","class":"Doctrine\\DBAL\\Driver\\PDO\\Exception","type":"::"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1136,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/Connection.php","line":257,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":213,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":287,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/Cache/Cache.php","line":377,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/Cache/Wrapper/CacheWrapper.php","line":141,"function":"update","class":"OC\\Files\\Cache\\Cache","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/lib/private/Files/Cache/Updater.php","line":257,"function":"update","class":"OC\\Files\\Cache\\Wrapper\\CacheWrapper","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/lib/private/Files/Cache/Updater.php","line":139,"function":"correctParentStorageMtime","class":"OC\\Files\\Cache\\Updater","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/View.php","line":324,"function":"update","class":"OC\\Files\\Cache\\Updater","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/lib/private/Files/View.php","line":1187,"function":"writeUpdate","class":"OC\\Files\\View","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/View.php","line":707,"function":"basicOperation","class":"OC\\Files\\View","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/Node/Folder.php","line":201,"function":"file_put_contents","class":"OC\\Files\\View","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/SimpleFS/NewSimpleFile.php","line":134,"function":"newFile","class":"OC\\Files\\Node\\Folder","type":"->"},{"file":"/var/www/nextcloud/lib/private/Preview/Generator.php","line":436,"function":"putContent","class":"OC\\Files\\SimpleFS\\NewSimpleFile","type":"->"},{"file":"/var/www/nextcloud/lib/private/Preview/Generator.php","line":186,"function":"generatePreview","class":"OC\\Preview\\Generator","type":"->"},{"file":"/var/www/nextcloud/lib/private/Preview/Generator.php","line":109,"function":"generatePreviews","class":"OC\\Preview\\Generator","type":"->"},{"file":"/var/www/nextcloud/lib/private/PreviewManager.php","line":190,"function":"getPreview","class":"OC\\Preview\\Generator","type":"->"},{"file":"/var/www/nextcloud/core/Controller/PreviewController.php","line":170,"function":"getPreview","class":"OC\\PreviewManager","type":"->"},{"file":"/var/www/nextcloud/core/Controller/PreviewController.php","line":143,"function":"fetchPreview","class":"OC\\Core\\Controller\\PreviewController","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":218,"function":"getPreviewByFileId","class":"OC\\Core\\Controller\\PreviewController","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":127,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/App.php","line":157,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/Route/Router.php","line":302,"function":"main","class":"OC\\AppFramework\\App","type":"::"},{"file":"/var/www/nextcloud/lib/base.php","line":993,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/var/www/nextcloud/index.php","line":37,"function":"handleRequest","class":"OC","type":"::"}],"File":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php","Line":26,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction","Code":"HY000","Trace":[{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":82,"function":"execute","class":"PDOStatement","type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1136,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/Connection.php","line":257,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":213,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":287,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/Cache/Cache.php","line":377,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/Cache/Wrapper/CacheWrapper.php","line":141,"function":"update","class":"OC\\Files\\Cache\\Cache","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/lib/private/Files/Cache/Updater.php","line":257,"function":"update","class":"OC\\Files\\Cache\\Wrapper\\CacheWrapper","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/lib/private/Files/Cache/Updater.php","line":139,"function":"correctParentStorageMtime","class":"OC\\Files\\Cache\\Updater","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/View.php","line":324,"function":"update","class":"OC\\Files\\Cache\\Updater","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/lib/private/Files/View.php","line":1187,"function":"writeUpdate","class":"OC\\Files\\View","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/View.php","line":707,"function":"basicOperation","class":"OC\\Files\\View","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/Node/Folder.php","line":201,"function":"file_put_contents","class":"OC\\Files\\View","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/SimpleFS/NewSimpleFile.php","line":134,"function":"newFile","class":"OC\\Files\\Node\\Folder","type":"->"},{"file":"/var/www/nextcloud/lib/private/Preview/Generator.php","line":436,"function":"putContent","class":"OC\\Files\\SimpleFS\\NewSimpleFile","type":"->"},{"file":"/var/www/nextcloud/lib/private/Preview/Generator.php","line":186,"function":"generatePreview","class":"OC\\Preview\\Generator","type":"->"},{"file":"/var/www/nextcloud/lib/private/Preview/Generator.php","line":109,"function":"generatePreviews","class":"OC\\Preview\\Generator","type":"->"},{"file":"/var/www/nextcloud/lib/private/PreviewManager.php","line":190,"function":"getPreview","class":"OC\\Preview\\Generator","type":"->"},{"file":"/var/www/nextcloud/core/Controller/PreviewController.php","line":170,"function":"getPreview","class":"OC\\PreviewManager","type":"->"},{"file":"/var/www/nextcloud/core/Controller/PreviewController.php","line":143,"function":"fetchPreview","class":"OC\\Core\\Controller\\PreviewController","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":218,"function":"getPreviewByFileId","class":"OC\\Core\\Controller\\PreviewController","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":127,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/App.php","line":157,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/Route/Router.php","line":302,"function":"main","class":"OC\\AppFramework\\App","type":"::"},{"file":"/var/www/nextcloud/lib/base.php","line":993,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/var/www/nextcloud/index.php","line":37,"function":"handleRequest","class":"OC","type":"::"}],"File":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","Line":82}},"CustomMessage":"--"},"userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.114 Safari/537.36","version":"21.0.2.1","id":"60d929d946398"}

[szaimen]

Does this happen on NC22.1.0 with PHP7.4, too?

[AndyXheli]

@szaimen Yes it dose.

[level420]

Occurs for me running the nextcloud:21.0.4-fpm image from docker hub in a docker stack which has php 7.4.22 on board.
The crucial sql statement seems to be:

UPDATE `oc_filecache` 
SET `checksum` = ?, `parent` = ?, `permissions` = ? 
WHERE (`fileid` = ?) AND (((`checksum` <> ?) OR (`checksum` IS NULL)) OR 
((`parent` <> ?) OR (`parent` IS NULL)) OR ((`permissions` <> ?) OR (`permissions` IS NULL)))

[AndyXheli]

Still an issue on NC 22.2.0

[AndyXheli]

Still an issue on NC 23.0.1

[NCC1701G]

It is still an issue on NC 23.0.3.
Please fix it in NC 24.

Log:
{"reqId":"xqcJMrtK7HwwKuIhwNtA","level":3,"time":"2022-03-30T20:25:01+02:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction","userAgent":"--","version":"23.0.3.2","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/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1780,"function":"convert","class":"Doctrine\\DBAL\\Driver\\API\\MySQL\\ExceptionConverter","type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1719,"function":"handleDriverException","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1173,"function":"convertExceptionDuringQuery","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/Connection.php","line":270,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":354,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":287,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/lib/private/BackgroundJob/JobList.php","line":219,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/cron.php","line":144,"function":"getNext","class":"OC\\BackgroundJob\\JobList","type":"->"}],"File":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php","Line":40,"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/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":94,"function":"new","class":"Doctrine\\DBAL\\Driver\\PDO\\Exception","type":"::"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1163,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/Connection.php","line":270,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":354,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":287,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/lib/private/BackgroundJob/JobList.php","line":219,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/cron.php","line":144,"function":"getNext","class":"OC\\BackgroundJob\\JobList","type":"->"}],"File":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php","Line":26,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction","Code":"HY000","Trace":[{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":92,"function":"execute","class":"PDOStatement","type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1163,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/Connection.php","line":270,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":354,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":287,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/lib/private/BackgroundJob/JobList.php","line":219,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/cron.php","line":144,"function":"getNext","class":"OC\\BackgroundJob\\JobList","type":"->"}],"File":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","Line":92}},"CustomMessage":"--"},"id":"6248b85f96dd3"}

[smooth-baking-powder]

Same in 23.0.5 while files:scan

Exception during scan: An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
#0 /var/www/nextcloud/lib/private/DB/ConnectionAdapter.php(109): OC\DB\Exceptions\DbalException::wrap()
#1 /var/www/nextcloud/lib/private/Lock/DBLockingProvider.php(139): OC\DB\ConnectionAdapter->insertIgnoreConflict()
#2 /var/www/nextcloud/lib/private/Lock/DBLockingProvider.php(185): OC\Lock\DBLockingProvider->initLockField()
#3 /var/www/nextcloud/lib/private/Files/Storage/Common.php(753): OC\Lock\DBLockingProvider->acquireLock()
#4 /var/www/nextcloud/lib/private/Files/Storage/Wrapper/Wrapper.php(610): OC\Files\Storage\Common->acquireLock()
#5 /var/www/nextcloud/lib/private/Files/Storage/Wrapper/Wrapper.php(610): OC\Files\Storage\Wrapper\Wrapper->acquireLock()
#6 /var/www/nextcloud/lib/private/Files/Storage/Wrapper/Wrapper.php(610): OC\Files\Storage\Wrapper\Wrapper->acquireLock()
#7 /var/www/nextcloud/lib/private/Files/Cache/Scanner.php(150): OC\Files\Storage\Wrapper\Wrapper->acquireLock()
#8 /var/www/nextcloud/lib/private/Files/Cache/Scanner.php(439): OC\Files\Cache\Scanner->scanFile()
#9 /var/www/nextcloud/lib/private/Files/Cache/Scanner.php(391): OC\Files\Cache\Scanner->handleChildren()
#10 /var/www/nextcloud/lib/private/Files/Cache/Scanner.php(394): OC\Files\Cache\Scanner->scanChildren()
#11 /var/www/nextcloud/lib/private/Files/Cache/Scanner.php(343): OC\Files\Cache\Scanner->scanChildren()
#12 /var/www/nextcloud/lib/private/Files/Utils/Scanner.php(258): OC\Files\Cache\Scanner->scan()
#13 /var/www/nextcloud/apps/files/lib/Command/Scan.php(143): OC\Files\Utils\Scanner->scan()
#14 /var/www/nextcloud/apps/files/lib/Command/Scan.php(199): OCA\Files\Command\Scan->scanFiles()
#15 /var/www/nextcloud/3rdparty/symfony/console/Command/Command.php(255): OCA\Files\Command\Scan->execute()
#16 /var/www/nextcloud/core/Command/Base.php(168): Symfony\Component\Console\Command\Command->run()
#17 /var/www/nextcloud/3rdparty/symfony/console/Application.php(1009): OC\Core\Command\Base->run()
#18 /var/www/nextcloud/3rdparty/symfony/console/Application.php(273): Symfony\Component\Console\Application->doRunCommand()
#19 /var/www/nextcloud/3rdparty/symfony/console/Application.php(149): Symfony\Component\Console\Application->doRun()
#20 /var/www/nextcloud/lib/private/Console/Application.php(211): Symfony\Component\Console\Application->run()
#21 /var/www/nextcloud/console.php(99): OC\Console\Application->run()
#22 /var/www/nextcloud/occ(11): require_once('/var/www/nextcl...')
#23 {main}
+---------+-------+--------------+
| Folders | Files | Elapsed time |
+---------+-------+--------------+
| 58      | 289   | 00:00:53     |
+---------+-------+--------------+

Redis Server File Locking is online.

[bill-mcgonigle]

I haven't seen this in a few days, but FWIW:

MariaDB [nextcloud]> DELETE FROM `oc_share` WHERE `item_type` in ('file', 'folder') AND NOT EXISTS (SELECT `fileid` FROM `oc_filecache` WHERE `file_source` = `fileid`)
    -> ;
Query OK, 0 rows affected (0.001 sec)

{
   "userAgent" : "--",
   "level" : 3,
   "method" : "",
   "user" : "--",
   "reqId" : "8WR6EicLjPK0uaQi4LVp",
   "exception" : {
      "Line" : 71,
      "Message" : "An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction",
      "Exception" : "OC\\DB\\Exceptions\\DbalException",
      "Trace" : [
         {
            "type" : "::",
            "line" : 77,
            "class" : "OC\\DB\\Exceptions\\DbalException",
            "file" : "/var/www/nextcloud/lib/private/DB/ConnectionAdapter.php",
            "function" : "wrap",
            "args" : [
               {
                  "__class__" : "Doctrine\\DBAL\\Exception\\LockWaitTimeoutException"
               }
            ]
         },
         {
            "args" : [
               "DELETE FROM `*PREFIX*share` WHERE `item_type` in ('file', 'folder') AND NOT EXISTS (SELECT `fileid` FROM `*PREFIX*filecache` WHERE `file_source` = `fileid`)"
            ],
            "function" : "executeUpdate",
            "file" : "/var/www/nextcloud/apps/files_sharing/lib/DeleteOrphanedSharesJob.php",
            "class" : "OC\\DB\\ConnectionAdapter",
            "line" : 62,
            "type" : "->"
         },
         {
            "class" : "OCA\\Files_Sharing\\DeleteOrphanedSharesJob",
            "file" : "/var/www/nextcloud/lib/private/BackgroundJob/Job.php",
            "line" : 51,
            "type" : "->",
            "args" : [
               null
            ],
            "function" : "run"
         },
         {
            "args" : [
               {
                  "__class__" : "OC\\BackgroundJob\\JobList"
               },
               {
                  "__class__" : "OC\\Log"
               }
            ],
            "function" : "execute",
            "class" : "OC\\BackgroundJob\\Job",
            "file" : "/var/www/nextcloud/lib/private/BackgroundJob/TimedJob.php",
            "line" : 58,
            "type" : "->"
         },
         {
            "type" : "->",
            "line" : 150,
            "class" : "OC\\BackgroundJob\\TimedJob",
            "file" : "/var/www/nextcloud/cron.php",
            "function" : "execute",
            "args" : [
               {
                  "__class__" : "OC\\BackgroundJob\\JobList"
               },
               {
                  "__class__" : "OC\\Log"
               }
            ]
         }
      ],
      "Code" : 1205,
      "Previous" : {
         "Line" : 40,
         "Message" : "An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction",
         "Exception" : "Doctrine\\DBAL\\Exception\\LockWaitTimeoutException",
         "Trace" : [
            {
               "args" : [
                  {
                     "__class__" : "Doctrine\\DBAL\\Driver\\PDO\\Exception"
                  },
                  {
                     "__class__" : "Doctrine\\DBAL\\Query"
                  }
               ],
               "function" : "convert",
               "class" : "Doctrine\\DBAL\\Driver\\API\\MySQL\\ExceptionConverter",
               "file" : "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
               "line" : 1780,
               "type" : "->"
            },
            {
               "function" : "handleDriverException",
               "args" : [
                  {
                     "__class__" : "Doctrine\\DBAL\\Driver\\PDO\\Exception"
                  },
                  {
                     "__class__" : "Doctrine\\DBAL\\Query"
                  }
               ],
               "line" : 1719,
               "class" : "Doctrine\\DBAL\\Connection",
               "file" : "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
               "type" : "->"
            },
            {
               "function" : "convertExceptionDuringQuery",
               "args" : [
                  {
                     "__class__" : "Doctrine\\DBAL\\Driver\\PDO\\Exception"
                  },
                  "DELETE FROM `oc_share` WHERE `item_type` in ('file', 'folder') AND NOT EXISTS (SELECT `fileid` FROM `oc_filecache` WHERE `file_source` = `fileid`)",
                  [],
                  []
               ],
               "line" : 1173,
               "file" : "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
               "class" : "Doctrine\\DBAL\\Connection",
               "type" : "->"
            },
            {
               "class" : "Doctrine\\DBAL\\Connection",
               "file" : "/var/www/nextcloud/lib/private/DB/Connection.php",
               "line" : 270,
               "type" : "->",
               "args" : [
                  "DELETE FROM `oc_share` WHERE `item_type` in ('file', 'folder') AND NOT EXISTS (SELECT `fileid` FROM `oc_filecache` WHERE `file_source` = `fileid`)",
                  [],
                  []
               ],
               "function" : "executeStatement"
            },
            {
               "type" : "->",
               "file" : "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
               "class" : "OC\\DB\\Connection",
               "line" : 1799,
               "args" : [
                  "DELETE FROM `oc_share` WHERE `item_type` in ('file', 'folder') AND NOT EXISTS (SELECT `fileid` FROM `oc_filecache` WHERE `file_source` = `fileid`)",
                  [],
                  []
               ],
               "function" : "executeStatement"
            },
            {
               "function" : "executeUpdate",
               "args" : [
                  "DELETE FROM `oc_share` WHERE `item_type` in ('file', 'folder') AND NOT EXISTS (SELECT `fileid` FROM `oc_filecache` WHERE `file_source` = `fileid`)",
                  [],
                  []
               ],
               "line" : 248,
               "class" : "Doctrine\\DBAL\\Connection",
               "file" : "/var/www/nextcloud/lib/private/DB/Connection.php",
               "type" : "->"
            },
            {
               "line" : 75,
               "class" : "OC\\DB\\Connection",
               "file" : "/var/www/nextcloud/lib/private/DB/ConnectionAdapter.php",
               "type" : "->",
               "function" : "executeUpdate",
               "args" : [
                  "DELETE FROM `oc_share` WHERE `item_type` in ('file', 'folder') AND NOT EXISTS (SELECT `fileid` FROM `oc_filecache` WHERE `file_source` = `fileid`)",
                  [],
                  []
               ]
            },
            {
               "type" : "->",
               "line" : 62,
               "file" : "/var/www/nextcloud/apps/files_sharing/lib/DeleteOrphanedSharesJob.php",
               "class" : "OC\\DB\\ConnectionAdapter",
               "function" : "executeUpdate",
               "args" : [
                  "DELETE FROM `*PREFIX*share` WHERE `item_type` in ('file', 'folder') AND NOT EXISTS (SELECT `fileid` FROM `*PREFIX*filecache` WHERE `file_source` = `fileid`)"
               ]
            },
            {
               "class" : "OCA\\Files_Sharing\\DeleteOrphanedSharesJob",
               "file" : "/var/www/nextcloud/lib/private/BackgroundJob/Job.php",
               "line" : 51,
               "type" : "->",
               "args" : [
                  null
               ],
               "function" : "run"
            },
            {
               "args" : [
                  {
                     "__class__" : "OC\\BackgroundJob\\JobList"
                  },
                  {
                     "__class__" : "OC\\Log"
                  }
               ],
               "function" : "execute",
               "type" : "->",
               "class" : "OC\\BackgroundJob\\Job",
               "file" : "/var/www/nextcloud/lib/private/BackgroundJob/TimedJob.php",
               "line" : 58
            },
            {
               "line" : 150,
               "class" : "OC\\BackgroundJob\\TimedJob",
               "file" : "/var/www/nextcloud/cron.php",
               "type" : "->",
               "function" : "execute",
               "args" : [
                  {
                     "__class__" : "OC\\BackgroundJob\\JobList"
                  },
                  {
                     "__class__" : "OC\\Log"
                  }
               ]
            }
         ],
         "Previous" : {
            "Trace" : [
               {
                  "file" : "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Connection.php",
                  "class" : "Doctrine\\DBAL\\Driver\\PDO\\Exception",
                  "line" : 50,
                  "type" : "::",
                  "args" : [
                     {
                        "__class__" : "PDOException",
                        "errorInfo" : [
                           "HY000",
                           1205,
                           "Lock wait timeout exceeded; try restarting transaction"
                        ]
                     }
                  ],
                  "function" : "new"
               },
               {
                  "type" : "->",
                  "class" : "Doctrine\\DBAL\\Driver\\PDO\\Connection",
                  "file" : "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
                  "line" : 1171,
                  "args" : [
                     "DELETE FROM `oc_share` WHERE `item_type` in ('file', 'folder') AND NOT EXISTS (SELECT `fileid` FROM `oc_filecache` WHERE `file_source` = `fileid`)"
                  ],
                  "function" : "exec"
               },
               {
                  "type" : "->",
                  "line" : 270,
                  "file" : "/var/www/nextcloud/lib/private/DB/Connection.php",
                  "class" : "Doctrine\\DBAL\\Connection",
                  "function" : "executeStatement",
                  "args" : [
                     "DELETE FROM `oc_share` WHERE `item_type` in ('file', 'folder') AND NOT EXISTS (SELECT `fileid` FROM `oc_filecache` WHERE `file_source` = `fileid`)",
                     [],
                     []
                  ]
               },
               {
                  "function" : "executeStatement",
                  "args" : [
                     "DELETE FROM `oc_share` WHERE `item_type` in ('file', 'folder') AND NOT EXISTS (SELECT `fileid` FROM `oc_filecache` WHERE `file_source` = `fileid`)",
                     [],
                     []
                  ],
                  "line" : 1799,
                  "file" : "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
                  "class" : "OC\\DB\\Connection",
                  "type" : "->"
               },
               {
                  "function" : "executeUpdate",
                  "args" : [
                     "DELETE FROM `oc_share` WHERE `item_type` in ('file', 'folder') AND NOT EXISTS (SELECT `fileid` FROM `oc_filecache` WHERE `file_source` = `fileid`)",
                     [],
                     []
                  ],
                  "type" : "->",
                  "line" : 248,
                  "file" : "/var/www/nextcloud/lib/private/DB/Connection.php",
                  "class" : "Doctrine\\DBAL\\Connection"
               },
               {
                  "line" : 75,
                  "file" : "/var/www/nextcloud/lib/private/DB/ConnectionAdapter.php",
                  "class" : "OC\\DB\\Connection",
                  "type" : "->",
                  "function" : "executeUpdate",
                  "args" : [
                     "DELETE FROM `oc_share` WHERE `item_type` in ('file', 'folder') AND NOT EXISTS (SELECT `fileid` FROM `oc_filecache` WHERE `file_source` = `fileid`)",
                     [],
                     []
                  ]
               },
               {
                  "function" : "executeUpdate",
                  "args" : [
                     "DELETE FROM `*PREFIX*share` WHERE `item_type` in ('file', 'folder') AND NOT EXISTS (SELECT `fileid` FROM `*PREFIX*filecache` WHERE `file_source` = `fileid`)"
                  ],
                  "type" : "->",
                  "line" : 62,
                  "class" : "OC\\DB\\ConnectionAdapter",
                  "file" : "/var/www/nextcloud/apps/files_sharing/lib/DeleteOrphanedSharesJob.php"
               },
               {
                  "args" : [
                     null
                  ],
                  "function" : "run",
                  "type" : "->",
                  "file" : "/var/www/nextcloud/lib/private/BackgroundJob/Job.php",
                  "class" : "OCA\\Files_Sharing\\DeleteOrphanedSharesJob",
                  "line" : 51
               },
               {
                  "line" : 58,
                  "class" : "OC\\BackgroundJob\\Job",
                  "file" : "/var/www/nextcloud/lib/private/BackgroundJob/TimedJob.php",
                  "type" : "->",
                  "function" : "execute",
                  "args" : [
                     {
                        "__class__" : "OC\\BackgroundJob\\JobList"
                     },
                     {
                        "__class__" : "OC\\Log"
                     }
                  ]
               },
               {
                  "file" : "/var/www/nextcloud/cron.php",
                  "class" : "OC\\BackgroundJob\\TimedJob",
                  "line" : 150,
                  "type" : "->",
                  "args" : [
                     {
                        "__class__" : "OC\\BackgroundJob\\JobList"
                     },
                     {
                        "__class__" : "OC\\Log"
                     }
                  ],
                  "function" : "execute"
               }
            ],
            "Previous" : {
               "Trace" : [
                  {
                     "type" : "->",
                     "class" : "PDO",
                     "file" : "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Connection.php",
                     "line" : 44,
                     "args" : [
                        "DELETE FROM `oc_share` WHERE `item_type` in ('file', 'folder') AND NOT EXISTS (SELECT `fileid` FROM `oc_filecache` WHERE `file_source` = `fileid`)"
                     ],
                     "function" : "exec"
                  },
                  {
                     "type" : "->",
                     "file" : "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
                     "class" : "Doctrine\\DBAL\\Driver\\PDO\\Connection",
                     "line" : 1171,
                     "args" : [
                        "DELETE FROM `oc_share` WHERE `item_type` in ('file', 'folder') AND NOT EXISTS (SELECT `fileid` FROM `oc_filecache` WHERE `file_source` = `fileid`)"
                     ],
                     "function" : "exec"
                  },
                  {
                     "line" : 270,
                     "class" : "Doctrine\\DBAL\\Connection",
                     "file" : "/var/www/nextcloud/lib/private/DB/Connection.php",
                     "type" : "->",
                     "function" : "executeStatement",
                     "args" : [
                        "DELETE FROM `oc_share` WHERE `item_type` in ('file', 'folder') AND NOT EXISTS (SELECT `fileid` FROM `oc_filecache` WHERE `file_source` = `fileid`)",
                        [],
                        []
                     ]
                  },
                  {
                     "type" : "->",
                     "line" : 1799,
                     "file" : "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
                     "class" : "OC\\DB\\Connection",
                     "function" : "executeStatement",
                     "args" : [
                        "DELETE FROM `oc_share` WHERE `item_type` in ('file', 'folder') AND NOT EXISTS (SELECT `fileid` FROM `oc_filecache` WHERE `file_source` = `fileid`)",
                        [],
                        []
                     ]
                  },
                  {
                     "line" : 248,
                     "class" : "Doctrine\\DBAL\\Connection",
                     "file" : "/var/www/nextcloud/lib/private/DB/Connection.php",
                     "type" : "->",
                     "function" : "executeUpdate",
                     "args" : [
                        "DELETE FROM `oc_share` WHERE `item_type` in ('file', 'folder') AND NOT EXISTS (SELECT `fileid` FROM `oc_filecache` WHERE `file_source` = `fileid`)",
                        [],
                        []
                     ]
                  },
                  {
                     "line" : 75,
                     "file" : "/var/www/nextcloud/lib/private/DB/ConnectionAdapter.php",
                     "class" : "OC\\DB\\Connection",
                     "type" : "->",
                     "function" : "executeUpdate",
                     "args" : [
                        "DELETE FROM `oc_share` WHERE `item_type` in ('file', 'folder') AND NOT EXISTS (SELECT `fileid` FROM `oc_filecache` WHERE `file_source` = `fileid`)",
                        [],
                        []
                     ]
                  },
                  {
                     "line" : 62,
                     "class" : "OC\\DB\\ConnectionAdapter",
                     "file" : "/var/www/nextcloud/apps/files_sharing/lib/DeleteOrphanedSharesJob.php",
                     "type" : "->",
                     "function" : "executeUpdate",
                     "args" : [
                        "DELETE FROM `*PREFIX*share` WHERE `item_type` in ('file', 'folder') AND NOT EXISTS (SELECT `fileid` FROM `*PREFIX*filecache` WHERE `file_source` = `fileid`)"
                     ]
                  },
                  {
                     "type" : "->",
                     "file" : "/var/www/nextcloud/lib/private/BackgroundJob/Job.php",
                     "class" : "OCA\\Files_Sharing\\DeleteOrphanedSharesJob",
                     "line" : 51,
                     "args" : [
                        null
                     ],
                     "function" : "run"
                  },
                  {
                     "line" : 58,
                     "file" : "/var/www/nextcloud/lib/private/BackgroundJob/TimedJob.php",
                     "class" : "OC\\BackgroundJob\\Job",
                     "type" : "->",
                     "function" : "execute",
                     "args" : [
                        {
                           "__class__" : "OC\\BackgroundJob\\JobList"
                        },
                        {
                           "__class__" : "OC\\Log"
                        }
                     ]
                  },
                  {
                     "function" : "execute",
                     "args" : [
                        {
                           "__class__" : "OC\\BackgroundJob\\JobList"
                        },
                        {
                           "__class__" : "OC\\Log"
                        }
                     ],
                     "type" : "->",
                     "line" : 150,
                     "class" : "OC\\BackgroundJob\\TimedJob",
                     "file" : "/var/www/nextcloud/cron.php"
                  }
               ],
               "Code" : "HY000",
               "Line" : 44,
               "File" : "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Connection.php",
               "Message" : "SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction",
               "Exception" : "PDOException"
            },
            "Code" : 1205,
            "Line" : 26,
            "Message" : "SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction",
            "Exception" : "Doctrine\\DBAL\\Driver\\PDO\\Exception",
            "File" : "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php"
         },
         "Code" : 1205,
         "File" : "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php"
      },
      "File" : "/var/www/nextcloud/lib/private/DB/Exceptions/DbalException.php",
      "CustomMessage" : "Error while running background job (class: OCA\\Files_Sharing\\DeleteOrphanedSharesJob, arguments: )"
   },
   "app" : "core",
   "remoteAddr" : "",
   "version" : "23.0.4.1",
   "message" : "Error while running background job (class: OCA\\Files_Sharing\\DeleteOrphanedSharesJob, arguments: )",
   "url" : "--",
   "time" : "2022-06-08T02:30:52+00:00"
}

[AndyXheli]

NC 24.0.2

{"reqId":"u0vvD2zEbX286kpspque","level":2,"time":"2022-07-06T15:26:56+00:00","remoteAddr":"1.1.1.1","user":"admin","app":"appstoreFetcher","method":"GET","url":"/settings/apps","message":"An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.0.0 Safari/537.36","version":"24.0.2.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/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1780,"function":"convert","class":"Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter","type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1719,"function":"handleDriverException","class":"Doctrine\DBAL\Connection","type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1173,"function":"convertExceptionDuringQuery","class":"Doctrine\DBAL\Connection","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/Connection.php","line":294,"function":"executeStatement","class":"Doctrine\DBAL\Connection","type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":354,"function":"executeStatement","class":"OC\DB\Connection","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":281,"function":"execute","class":"Doctrine\DBAL\Query\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/Cache/Cache.php","line":547,"function":"execute","class":"OC\DB\QueryBuilder\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/Cache/Updater.php","line":159,"function":"remove","class":"OC\Files\Cache\Cache","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/View.php","line":363,"function":"remove","class":"OC\Files\Cache\Updater","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/Node/Folder.php","line":388,"function":"rmdir","class":"OC\Files\View","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/SimpleFS/SimpleFolder.php","line":67,"function":"delete","class":"OC\Files\Node\Folder","type":"->"},{"file":"/var/www/nextcloud/lib/private/Preview/Watcher.php","line":65,"function":"delete","class":"OC\Files\SimpleFS\SimpleFolder","type":"->"},{"file":"/var/www/nextcloud/lib/private/Preview/Watcher.php","line":54,"function":"deleteNode","class":"OC\Preview\Watcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/Preview/WatcherConnector.php","line":63,"function":"postWrite","class":"OC\Preview\Watcher","type":"->"},{"function":"OC\Preview\{closure}","class":"OC\Preview\WatcherConnector","type":"->","args":["*** sensitive parameters replaced "]},{"file":"/var/www/nextcloud/lib/private/Hooks/EmitterTrait.php","line":106,"function":"call_user_func_array"},{"file":"/var/www/nextcloud/lib/private/Hooks/PublicEmitter.php","line":40,"function":"emit","class":"OC\Hooks\BasicEmitter","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/Node/Root.php","line":143,"function":"emit","class":"OC\Hooks\PublicEmitter","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/Node/Node.php","line":117,"function":"emit","class":"OC\Files\Node\Root","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/Node/File.php","line":75,"function":"sendHooks","class":"OC\Files\Node\Node","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/SimpleFS/SimpleFile.php","line":108,"function":"putContent","class":"OC\Files\Node\File","type":"->"},{"file":"/var/www/nextcloud/lib/private/App/AppStore/Fetcher/Fetcher.php","line":203,"function":"putContent","class":"OC\Files\SimpleFS\SimpleFile","type":"->"},{"file":"/var/www/nextcloud/lib/private/App/AppStore/Fetcher/AppFetcher.php","line":188,"function":"get","class":"OC\App\AppStore\Fetcher\Fetcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/Installer.php","line":422,"function":"get","class":"OC\App\AppStore\Fetcher\AppFetcher","type":"->"},{"file":"/var/www/nextcloud/apps/settings/lib/Controller/AppSettingsController.php","line":151,"function":"isUpdateAvailable","class":"OC\Installer","type":"->"},{"file":"/var/www/nextcloud/apps/settings/lib/Controller/AppSettingsController.php","line":134,"function":"getAppsWithUpdates","class":"OCA\Settings\Controller\AppSettingsController","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":225,"function":"viewApps","class":"OCA\Settings\Controller\AppSettingsController","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":133,"function":"executeController","class":"OC\AppFramework\Http\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/App.php","line":172,"function":"dispatch","class":"OC\AppFramework\Http\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/Route/Router.php","line":298,"function":"main","class":"OC\AppFramework\App","type":"::"},{"file":"/var/www/nextcloud/lib/base.php","line":1023,"function":"match","class":"OC\Route\Router","type":"->"},{"file":"/var/www/nextcloud/index.php","line":36,"function":"handleRequest","class":"OC","type":"::"}],"File":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php","Line":40,"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/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":94,"function":"new","class":"Doctrine\DBAL\Driver\PDO\Exception","type":"::"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1163,"function":"execute","class":"Doctrine\DBAL\Driver\PDO\Statement","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/Connection.php","line":294,"function":"executeStatement","class":"Doctrine\DBAL\Connection","type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":354,"function":"executeStatement","class":"OC\DB\Connection","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":281,"function":"execute","class":"Doctrine\DBAL\Query\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/Cache/Cache.php","line":547,"function":"execute","class":"OC\DB\QueryBuilder\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/Cache/Updater.php","line":159,"function":"remove","class":"OC\Files\Cache\Cache","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/View.php","line":363,"function":"remove","class":"OC\Files\Cache\Updater","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/Node/Folder.php","line":388,"function":"rmdir","class":"OC\Files\View","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/SimpleFS/SimpleFolder.php","line":67,"function":"delete","class":"OC\Files\Node\Folder","type":"->"},{"file":"/var/www/nextcloud/lib/private/Preview/Watcher.php","line":65,"function":"delete","class":"OC\Files\SimpleFS\SimpleFolder","type":"->"},{"file":"/var/www/nextcloud/lib/private/Preview/Watcher.php","line":54,"function":"deleteNode","class":"OC\Preview\Watcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/Preview/WatcherConnector.php","line":63,"function":"postWrite","class":"OC\Preview\Watcher","type":"->"},{"function":"OC\Preview\{closure}","class":"OC\Preview\WatcherConnector","type":"->","args":[" sensitive parameters replaced "]},{"file":"/var/www/nextcloud/lib/private/Hooks/EmitterTrait.php","line":106,"function":"call_user_func_array"},{"file":"/var/www/nextcloud/lib/private/Hooks/PublicEmitter.php","line":40,"function":"emit","class":"OC\Hooks\BasicEmitter","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/Node/Root.php","line":143,"function":"emit","class":"OC\Hooks\PublicEmitter","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/Node/Node.php","line":117,"function":"emit","class":"OC\Files\Node\Root","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/Node/File.php","line":75,"function":"sendHooks","class":"OC\Files\Node\Node","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/SimpleFS/SimpleFile.php","line":108,"function":"putContent","class":"OC\Files\Node\File","type":"->"},{"file":"/var/www/nextcloud/lib/private/App/AppStore/Fetcher/Fetcher.php","line":203,"function":"putContent","class":"OC\Files\SimpleFS\SimpleFile","type":"->"},{"file":"/var/www/nextcloud/lib/private/App/AppStore/Fetcher/AppFetcher.php","line":188,"function":"get","class":"OC\App\AppStore\Fetcher\Fetcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/Installer.php","line":422,"function":"get","class":"OC\App\AppStore\Fetcher\AppFetcher","type":"->"},{"file":"/var/www/nextcloud/apps/settings/lib/Controller/AppSettingsController.php","line":151,"function":"isUpdateAvailable","class":"OC\Installer","type":"->"},{"file":"/var/www/nextcloud/apps/settings/lib/Controller/AppSettingsController.php","line":134,"function":"getAppsWithUpdates","class":"OCA\Settings\Controller\AppSettingsController","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":225,"function":"viewApps","class":"OCA\Settings\Controller\AppSettingsController","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":133,"function":"executeController","class":"OC\AppFramework\Http\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/App.php","line":172,"function":"dispatch","class":"OC\AppFramework\Http\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/Route/Router.php","line":298,"function":"main","class":"OC\AppFramework\App","type":"::"},{"file":"/var/www/nextcloud/lib/base.php","line":1023,"function":"match","class":"OC\Route\Router","type":"->"},{"file":"/var/www/nextcloud/index.php","line":36,"function":"handleRequest","class":"OC","type":"::"}],"File":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php","Line":26,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction","Code":"HY000","Trace":[{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":92,"function":"execute","class":"PDOStatement","type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1163,"function":"execute","class":"Doctrine\DBAL\Driver\PDO\Statement","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/Connection.php","line":294,"function":"executeStatement","class":"Doctrine\DBAL\Connection","type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":354,"function":"executeStatement","class":"OC\DB\Connection","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":281,"function":"execute","class":"Doctrine\DBAL\Query\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/Cache/Cache.php","line":547,"function":"execute","class":"OC\DB\QueryBuilder\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/Cache/Updater.php","line":159,"function":"remove","class":"OC\Files\Cache\Cache","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/View.php","line":363,"function":"remove","class":"OC\Files\Cache\Updater","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/Node/Folder.php","line":388,"function":"rmdir","class":"OC\Files\View","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/SimpleFS/SimpleFolder.php","line":67,"function":"delete","class":"OC\Files\Node\Folder","type":"->"},{"file":"/var/www/nextcloud/lib/private/Preview/Watcher.php","line":65,"function":"delete","class":"OC\Files\SimpleFS\SimpleFolder","type":"->"},{"file":"/var/www/nextcloud/lib/private/Preview/Watcher.php","line":54,"function":"deleteNode","class":"OC\Preview\Watcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/Preview/WatcherConnector.php","line":63,"function":"postWrite","class":"OC\Preview\Watcher","type":"->"},{"function":"OC\Preview\{closure}","class":"OC\Preview\WatcherConnector","type":"->","args":[" sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/lib/private/Hooks/EmitterTrait.php","line":106,"function":"call_user_func_array"},{"file":"/var/www/nextcloud/lib/private/Hooks/PublicEmitter.php","line":40,"function":"emit","class":"OC\Hooks\BasicEmitter","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/Node/Root.php","line":143,"function":"emit","class":"OC\Hooks\PublicEmitter","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/Node/Node.php","line":117,"function":"emit","class":"OC\Files\Node\Root","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/Node/File.php","line":75,"function":"sendHooks","class":"OC\Files\Node\Node","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/SimpleFS/SimpleFile.php","line":108,"function":"putContent","class":"OC\Files\Node\File","type":"->"},{"file":"/var/www/nextcloud/lib/private/App/AppStore/Fetcher/Fetcher.php","line":203,"function":"putContent","class":"OC\Files\SimpleFS\SimpleFile","type":"->"},{"file":"/var/www/nextcloud/lib/private/App/AppStore/Fetcher/AppFetcher.php","line":188,"function":"get","class":"OC\App\AppStore\Fetcher\Fetcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/Installer.php","line":422,"function":"get","class":"OC\App\AppStore\Fetcher\AppFetcher","type":"->"},{"file":"/var/www/nextcloud/apps/settings/lib/Controller/AppSettingsController.php","line":151,"function":"isUpdateAvailable","class":"OC\Installer","type":"->"},{"file":"/var/www/nextcloud/apps/settings/lib/Controller/AppSettingsController.php","line":134,"function":"getAppsWithUpdates","class":"OCA\Settings\Controller\AppSettingsController","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":225,"function":"viewApps","class":"OCA\Settings\Controller\AppSettingsController","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":133,"function":"executeController","class":"OC\AppFramework\Http\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/App.php","line":172,"function":"dispatch","class":"OC\AppFramework\Http\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/Route/Router.php","line":298,"function":"main","class":"OC\AppFramework\App","type":"::"},{"file":"/var/www/nextcloud/lib/base.php","line":1023,"function":"match","class":"OC\Route\Router","type":"->"},{"file":"/var/www/nextcloud/index.php","line":36,"function":"handleRequest","class":"OC","type":"::"}],"File":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","Line":92}},"CustomMessage":"An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction"},"id":"62c5a9cce6c25"}