NC creates high CPU load and DB-errors since update to 19.0.2

ℹ️ Support
1

Nextcloud version (eg, 18.0.2): 19.0.2
Operating system and version (eg, Ubuntu 20.04):

Debian 10 with Kernel 4.19.0-10-amd64 x86_64

Apache or nginx version (eg, Apache 2.4.25): Apache Version 2.4.38
PHP version (eg, 7.1): 7.3.21-1+0~20200807.66+debian10~1.gbp18a1c2

The issue you are facing:

Since the update to 19.0.2 on the 27th august, I have an incredible increase in the CPU-load on my server.
After looking for it’s origin I fond that it is produced by mysql / mariaDB, running an task from NC over and over, which is the following command:

SELECT `filecache`.`fileid`, `storage`, `path`, `path_hash`, `filecache`.`parent`, `name`, `mimetype`, `mimepart`, `size`, `mtime`, `storage_mtime`, `encrypted`, `etag`, `permissions`, `checksum`, `metadata_etag`, `creation_time`, `upload_time` FROM `oc_filecache` `filecache` LEFT JOIN `oc_filecache_extended` `fe` ON `filecache`.`fileid` = `fe`.`fileid` WHERE (`storage` = 2) AND (`name` COLLATE utf8mb4_general_ci LIKE '88095ADABC6D2343F9EEF6508747ED7755E4524D.v%.d1588190729')

Also the second highest load is aproduced by the NC cron.php execution.
So I guess that there is some bug in the update lettiing the DB run a command which never finishes and creates dozens of errors.

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

Steps to replicate it:

  1. Update to 19.0.2 i guess, there seems to be no actual trigger

The output of your Nextcloud log in Admin > Logging:

{"reqId":"gOLUH3HtemIbFsYmd5rK","level":3,"time":"2020-08-30T14:19:48+00:00","remoteAddr":"","user":"--","app":"PHP","method":"","url":"--","message":"unlink(/opt/nextcloud/data/bogatkaj/files_trashbin/files/6F77339B467BD82B3A79AE61AF90BF057DC8A7B8.d1588190687): No such file or directory at /var/www/html/nextcloud/lib/private/Files/Storage/Local.php#283","userAgent":"--","version":"19.0.2.2","id":"5f4bb67545024"}
{"reqId":"wKv4wZazRm3YXLUowE8N","level":3,"time":"2020-08-30T14:16:58+00:00","remoteAddr":"","user":"--","app":"PHP","method":"","url":"--","message":"unlink(/opt/nextcloud/data/bogatkaj/files_trashbin/files/6E1DABB56432E6B7F251645928E4FD0F3B4AF300.d1588190685): No such file or directory at /var/www/html/nextcloud/lib/private/Files/Storage/Local.php#283","userAgent":"--","version":"19.0.2.2","id":"5f4bb6754503e"}

[...] FOLLOWED BY MANY IDENTICAL [...]

{"reqId":"wKv4wZazRm3YXLUowE8N","level":3,"time":"2020-08-30T14:01:55+00:00","remoteAddr":"","user":"--","app":"PHP","method":"","url":"--","message":"filesize(): stat failed for /opt/nextcloud/data/bogatkaj/files_trashbin/files/673D2518587EC06DEDE9039BF9789ADAEFE4F6FC.d1588190677 at /var/www/html/nextcloud/lib/private/Files/Storage/Local.php#224","userAgent":"--","version":"19.0.2.2","id":"5f4bb6754515b"}
 [...] Three errors, which will be posted seperatly because of their length [...]
{"reqId":"oMXiQqRYhAV9I1heY9x4","level":3,"time":"2020-08-30T13:22:59+00:00","remoteAddr":"","user":"--","app":"PHP","method":"","url":"--","message":"unlink(/opt/nextcloud/data/bogatkaj/files_trashbin/files/4EDD684C3323DCDFEAD7779ED288F7E383951F57.d1588190651): No such file or directory at /var/www/html/nextcloud/lib/private/Files/Storage/Local.php#283","userAgent":"--","version":"19.0.2.2","id":"5f4bb6754b70b"}

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

<?php
$CONFIG = array (
  'instanceid' => '*******',
  'passwordsalt' => '********',
  'secret' => '*******',
  'trusted_domains' => 
  array (
    0 => '127.0.0.1',
    1 => '*********',
    2 => '********',
  ),
  'datadirectory' => '/opt/nextcloud/data',
  'dbtype' => 'mysql',
  'version' => '19.0.2.2',
  'overwrite.cli.url' => 'http://127.0.0.1/nextcloud',
  'dbname' => 'nextcloud',
  'dbhost' => 'localhost',
  'dbport' => '',
  'dbtableprefix' => 'oc_',
  'mysql.utf8mb4' => true,
  'dbuser' => '********',
  'dbpassword' => '**********',
  'installed' => true,
  'memcache.local' => '\\OC\\Memcache\\APCu',
  'default_language' => 'de',
  'default_locale' => 'de_DE',
  'mail_smtpmode' => 'smtp',
  'mail_smtpsecure' => 'tls',
  'mail_sendmailmode' => 'smtp',
  'mail_from_address' => '****',
  'mail_domain' => '*****.***',
  'mail_smtphost' => 'smtp.**********.de',
  'mail_smtpport' => '587',
  'maintenance' => false,
  'theme' => '',
  'loglevel' => 2,
  'logdateformat' => 'F d, Y H:i:s',
  'mail_smtpauthtype' => 'LOGIN',
  'mail_smtpauth' => 1,
  'mail_smtpname' => '*******',
  'mail_smtppassword' => '*********',
  'twofactor_enforced' => 'false',
  'twofactor_enforced_groups' => 
  array (
    0 => '******',
  ),
  'twofactor_enforced_excluded_groups' => 
  array (
  ),
);

The output of your Apache/nginx/system log in /var/log/____:

[Sun Aug 30 00:00:09.956343 2020] [core:notice] [pid 616] AH00094: Command line: '/usr/sbin/apache2'
[Sun Aug 30 02:47:07.162213 2020] [php7:notice] [pid 2976] [client 185.125.36.55:41189] PHP Notice:  PDO::__construct(): send of 144 bytes failed with errno=32 Broken pipe in /var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php on line 27
[Sun Aug 30 02:48:16.427453 2020] [php7:notice] [pid 3181] [client 185.125.36.55:40563] PHP Notice:  PDO::__construct(): send of 144 bytes failed with errno=32 Broken pipe in /var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php on line 27
[Sun Aug 30 11:36:24.815623 2020] [core:alert] [pid 3641] [client 103.210.201.238:64021] /var/www/html/nextcloud/.htaccess: php_value not allowed here
[Sun Aug 30 11:36:25.509134 2020] [core:alert] [pid 4180] [client 103.210.201.238:53442] /var/www/html/nextcloud/.htaccess: php_value not allowed here
[Sun Aug 30 11:36:25.916452 2020] [core:alert] [pid 6148] [client 103.210.201.238:62605] /var/www/html/nextcloud/.htaccess: php_value not allowed here
[Sun Aug 30 11:36:26.574402 2020] [core:alert] [pid 4221] [client 103.210.201.238:51064] /var/www/html/nextcloud/.htaccess: php_value not allowed here
[Sun Aug 30 11:36:27.040928 2020] [core:alert] [pid 3635] [client 103.210.201.238:59060] /var/www/html/nextcloud/.htaccess: php_value not allowed here
[Sun Aug 30 15:26:42.950698 2020] [mpm_prefork:notice] [pid 649] AH00163: Apache/2.4.38 (Debian) OpenSSL/1.1.1g configured -- resuming normal operations
[Sun Aug 30 15:26:42.951229 2020] [core:notice] [pid 649] AH00094: Command line: '/usr/sbin/apache2'
2

Here the errors which are to long to cover them in the first post
all three are identical:

{"reqId":"v08puZ85OU8w4P6iXPkN","level":4,"time":"2020-08-30T13:51:40+00:00","remoteAddr":"192.168.11.160","user":"bogatkaj","app":"webdav","method":"DELETE","url":"/remote.php/dav/files/bogatkaj/Sync/Python%20Projekte/***SENSITIVE***/FF-profiles/cache2/entries/08B9044D178E32EA3AC194442B6DB9485EA1B445","message":{"Exception":"Doctrine\\DBAL\\Exception\\LockWaitTimeoutException","Message":"An exception occurred while executing 'UPDATE `oc_filecache` SET `size` = ? WHERE (`fileid` = ?) AND ((`size` <> ?) OR (`size` IS NULL))' with params [1044814235, 64288, 1044814235]:\n\nSQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction","Code":0,"Trace":[{"file":"/var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php","line":169,"function":"convertException","class":"Doctrine\\DBAL\\Driver\\AbstractMySQLDriver","type":"->","args":["An exception occurred while executing 'UPDATE `oc_filecache` SET `size` = ? WHERE (`fileid` = ?) AND ((`size` <> ?) OR (`size` IS NULL))' with params [1044814235, 64288, 1044814235]:\n\nSQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction",{"errorInfo":["HY000",1205,"Lock wait timeout exceeded; try restarting transaction"],"__class__":"Doctrine\\DBAL\\Driver\\PDOException"}]},{"file":"/var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php","line":145,"function":"wrapException","class":"Doctrine\\DBAL\\DBALException","type":"::","args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDOMySql\\Driver"},{"errorInfo":["HY000",1205,"Lock wait timeout exceeded; try restarting transaction"],"__class__":"Doctrine\\DBAL\\Driver\\PDOException"},"An exception occurred while executing 'UPDATE `oc_filecache` SET `size` = ? WHERE (`fileid` = ?) AND ((`size` <> ?) OR (`size` IS NULL))' with params [1044814235, 64288, 1044814235]:\n\nSQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction"]},{"file":"/var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php","line":1063,"function":"driverExceptionDuringQuery","class":"Doctrine\\DBAL\\DBALException","type":"::","args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDOMySql\\Driver"},{"errorInfo":["HY000",1205,"Lock wait timeout exceeded; try restarting transaction"],"__class__":"Doctrine\\DBAL\\Driver\\PDOException"},"UPDATE `oc_filecache` SET `size` = ? WHERE (`fileid` = ?) AND ((`size` <> ?) OR (`size` IS NULL))",{"1":1044814235,"2":"*** sensitive parameter replaced ***","3":1044814235}]},{"file":"/var/www/html/nextcloud/lib/private/DB/Connection.php","line":214,"function":"executeUpdate","class":"Doctrine\\DBAL\\Connection","type":"->","args":["UPDATE `oc_filecache` SET `size` = ? WHERE (`fileid` = ?) AND ((`size` <> ?) OR (`size` IS NULL))",[1044814235,"*** sensitive parameter replaced ***",1044814235],[2,1,2]]},{"file":"/var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php","line":203,"function":"executeUpdate","class":"OC\\DB\\Connection","type":"->","args":["UPDATE `oc_filecache` SET `size` = :dcValue3 WHERE (`fileid` = :dcValue1) AND ((`size` <> :dcValue2) OR (`size` IS NULL))",{"dcValue1":"*** sensitive parameter replaced ***","dcValue2":1044814235,"dcValue3":1044814235},{"dcValue1":1,"dcValue2":2,"dcValue3":2}]},{"file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":216,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/nextcloud/lib/private/Files/Cache/Cache.php","line":363,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/nextcloud/lib/private/Files/Cache/Cache.php","line":898,"function":"update","class":"OC\\Files\\Cache\\Cache","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/nextcloud/lib/private/Files/Cache/HomeCache.php","line":43,"function":"calculateFolderSize","class":"OC\\Files\\Cache\\Cache","type":"->","args":["files/Sync/Python Projekte/***SENSITIVE***/FF-profiles/cache2/entries",{"__class__":"OC\\Files\\Cache\\CacheEntry"}]},{"file":"/var/www/html/nextcloud/lib/private/Files/Cache/Cache.php","line":830,"function":"calculateFolderSize","class":"OC\\Files\\Cache\\HomeCache","type":"->","args":["files/Sync/Python Projekte/***SENSITIVE***/FF-profiles/cache2/entries",null]},{"file":"/var/www/html/nextcloud/lib/private/Files/Cache/Cache.php","line":842,"function":"correctFolderSize","class":"OC\\Files\\Cache\\Cache","type":"->","args":["files/Sync/Python Projekte/***SENSITIVE***/FF-profiles/cache2/entries"]},{"file":"/var/www/html/nextcloud/lib/private/Files/Cache/Wrapper/CacheWrapper.php","line":254,"function":"correctFolderSize","class":"OC\\Files\\Cache\\Cache","type":"->","args":["files/Sync/Python Projekte/***SENSITIVE***/FF-profiles/cache2/entries/08B9044D178E32EA3AC194442B6DB9485EA1B445",null,false]},{"file":"/var/www/html/nextcloud/lib/private/Files/Cache/Updater.php","line":217,"function":"correctFolderSize","class":"OC\\Files\\Cache\\Wrapper\\CacheWrapper","type":"->","args":["files/Sync/Python Projekte/***SENSITIVE***/FF-profiles/cache2/entries/08B9044D178E32EA3AC194442B6DB9485EA1B445"]},{"file":"/var/www/html/nextcloud/apps/files_trashbin/lib/Trashbin.php","line":289,"function":"renameFromStorage","class":"OC\\Files\\Cache\\Updater","type":"->","args":[{"mountPoint":"/bogatkaj/","cache":null,"scanner":{"__class__":"OC\\Files\\Cache\\Scanner"},"watcher":null,"propagator":null,"updater":{"__class__":"OC\\Files\\Cache\\Updater"},"__class__":"OCA\\FilesAccessControl\\StorageWrapper"},"files/Sync/Python Projekte/***SENSITIVE***/FF-profiles/cache2/entries/08B9044D178E32EA3AC194442B6DB9485EA1B445","files_trashbin/files/08B9044D178E32EA3AC194442B6DB9485EA1B445.d1598795448"]},{"file":"/var/www/html/nextcloud/apps/files_trashbin/lib/Trash/LegacyTrashBackend.php","line":108,"function":"move2trash","class":"OCA\\Files_Trashbin\\Trashbin","type":"::","args":["Sync/Python Projekte/***SENSITIVE***/FF-profiles/cache2/entries/08B9044D178E32EA3AC194442B6DB9485EA1B445"]},{"file":"/var/www/html/nextcloud/apps/files_trashbin/lib/Trash/TrashManager.php","line":103,"function":"moveToTrash","class":"OCA\\Files_Trashbin\\Trash\\LegacyTrashBackend","type":"->","args":[{"cache":null,"scanner":null,"watcher":null,"propagator":null,"updater":null,"__class__":"OCA\\Files_Trashbin\\Storage"},"files/Sync/Python Projekte/***SENSITIVE***/FF-profiles/cache2/entries/08B9044D178E32EA3AC194442B6DB9485EA1B445"]},{"file":"/var/www/html/nextcloud/apps/files_trashbin/lib/Storage.php","line":192,"function":"moveToTrash","class":"OCA\\Files_Trashbin\\Trash\\TrashManager","type":"->","args":[{"cache":null,"scanner":null,"watcher":null,"propagator":null,"updater":null,"__class__":"OCA\\Files_Trashbin\\Storage"},"files/Sync/Python Projekte/***SENSITIVE***/FF-profiles/cache2/entries/08B9044D178E32EA3AC194442B6DB9485EA1B445"]},{"file":"/var/www/html/nextcloud/apps/files_trashbin/lib/Storage.php","line":99,"function":"doDelete","class":"OCA\\Files_Trashbin\\Storage","type":"->","args":["files/Sync/Python Projekte/***SENSITIVE***/FF-profiles/cache2/entries/08B9044D178E32EA3AC194442B6DB9485EA1B445","unlink"]},{"file":"/var/www/html/nextcloud/apps/files_accesscontrol/lib/StorageWrapper.php","line":287,"function":"unlink","class":"OCA\\Files_Trashbin\\Storage","type":"->","args":["files/Sync/Python Projekte/***SENSITIVE***/FF-profiles/cache2/entries/08B9044D178E32EA3AC194442B6DB9485EA1B445"]},{"file":"/var/www/html/nextcloud/lib/private/Files/View.php","line":1161,"function":"unlink","class":"OCA\\FilesAccessControl\\StorageWrapper","type":"->","args":["files/Sync/Python Projekte/***SENSITIVE***/FF-profiles/cache2/entries/08B9044D178E32EA3AC194442B6DB9485EA1B445"]},{"file":"/var/www/html/nextcloud/lib/private/Files/View.php","line":718,"function":"basicOperation","class":"OC\\Files\\View","type":"->","args":["unlink","/Sync/Python Projekte/***SENSITIVE***/FF-profiles/cache2/entries/08B9044D178E32EA3AC194442B6DB9485EA1B445",["delete"]]},{"file":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/File.php","line":455,"function":"unlink","class":"OC\\Files\\View","type":"->","args":["/Sync/Python Projekte/***SENSITIVE***/FF-profiles/cache2/entries/08B9044D178E32EA3AC194442B6DB9485EA1B445"]},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Tree.php","line":183,"function":"delete","class":"OCA\\DAV\\Connector\\Sabre\\File","type":"->","args":[]},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php","line":295,"function":"delete","class":"Sabre\\DAV\\Tree","type":"->","args":["files/bogatkaj/Sync/Python Projekte/***SENSITIVE***/FF-profiles/cache2/entries/08B9044D178E32EA3AC194442B6DB9485EA1B445"]},{"file":"/var/www/html/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"httpDelete","class":"Sabre\\DAV\\CorePlugin","type":"->","args":[{"__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":474,"function":"emit","class":"Sabre\\DAV\\Server","type":"->","args":["method:DELETE",[{"__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]]},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":251,"function":"invokeMethod","class":"Sabre\\DAV\\Server","type":"->","args":[{"__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":319,"function":"start","class":"Sabre\\DAV\\Server","type":"->","args":[]},{"file":"/var/www/html/nextcloud/apps/dav/lib/Server.php","line":320,"function":"exec","class":"Sabre\\DAV\\Server","type":"->","args":[]},{"file":"/var/www/html/nextcloud/apps/dav/appinfo/v2/remote.php","line":35,"function":"exec","class":"OCA\\DAV\\Server","type":"->","args":[]},{"file":"/var/www/html/nextcloud/remote.php","line":167,"args":["/var/www/html/nextcloud/apps/dav/appinfo/v2/remote.php"],"function":"require_once"}],"File":"/var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php","Line":36,"Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDOException","Message":"SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction","Code":"HY000","Trace":[{"file":"/var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php","line":1054,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDOStatement","type":"->","args":[]},{"file":"/var/www/html/nextcloud/lib/private/DB/Connection.php","line":214,"function":"executeUpdate","class":"Doctrine\\DBAL\\Connection","type":"->","args":["UPDATE `oc_filecache` SET `size` = ? WHERE (`fileid` = ?) AND ((`size` <> ?) OR (`size` IS NULL))",[1044814235,"*** sensitive parameter replaced ***",1044814235],[2,1,2]]},{"file":"/var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php","line":203,"function":"executeUpdate","class":"OC\\DB\\Connection","type":"->","args":["UPDATE `oc_filecache` SET `size` = :dcValue3 WHERE (`fileid` = :dcValue1) AND ((`size` <> :dcValue2) OR (`size` IS NULL))",{"dcValue1":"*** sensitive parameter replaced ***","dcValue2":1044814235,"dcValue3":1044814235},{"dcValue1":1,"dcValue2":2,"dcValue3":2}]},{"file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":216,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/nextcloud/lib/private/Files/Cache/Cache.php","line":363,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/nextcloud/lib/private/Files/Cache/Cache.php","line":898,"function":"update","class":"OC\\Files\\Cache\\Cache","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/nextcloud/lib/private/Files/Cache/HomeCache.php","line":43,"function":"calculateFolderSize","class":"OC\\Files\\Cache\\Cache","type":"->","args":["files/Sync/Python Projekte/***SENSITIVE***/FF-profiles/cache2/entries",{"__class__":"OC\\Files\\Cache\\CacheEntry"}]},{"file":"/var/www/html/nextcloud/lib/private/Files/Cache/Cache.php","line":830,"function":"calculateFolderSize","class":"OC\\Files\\Cache\\HomeCache","type":"->","args":["files/Sync/Python Projekte/***SENSITIVE***/FF-profiles/cache2/entries",null]},{"file":"/var/www/html/nextcloud/lib/private/Files/Cache/Cache.php","line":842,"function":"correctFolderSize","class":"OC\\Files\\Cache\\Cache","type":"->","args":["files/Sync/Python Projekte/***SENSITIVE***/FF-profiles/cache2/entries"]},{"file":"/var/www/html/nextcloud/lib/private/Files/Cache/Wrapper/CacheWrapper.php","line":254,"function":"correctFolderSize","class":"OC\\Files\\Cache\\Cache","type":"->","args":["files/Sync/Python Projekte/***SENSITIVE***/FF-profiles/cache2/entries/08B9044D178E32EA3AC194442B6DB9485EA1B445",null,false]},{"file":"/var/www/html/nextcloud/lib/private/Files/Cache/Updater.php","line":217,"function":"correctFolderSize","class":"OC\\Files\\Cache\\Wrapper\\CacheWrapper","type":"->","args":["files/Sync/Python Projekte/***SENSITIVE***/FF-profiles/cache2/entries/08B9044D178E32EA3AC194442B6DB9485EA1B445"]},{"file":"/var/www/html/nextcloud/apps/files_trashbin/lib/Trashbin.php","line":289,"function":"renameFromStorage","class":"OC\\Files\\Cache\\Updater","type":"->","args":[{"mountPoint":"/bogatkaj/","cache":null,"scanner":{"__class__":"OC\\Files\\Cache\\Scanner"},"watcher":null,"propagator":null,"updater":{"__class__":"OC\\Files\\Cache\\Updater"},"__class__":"OCA\\FilesAccessControl\\StorageWrapper"},"files/Sync/Python Projekte/***SENSITIVE***/FF-profiles/cache2/entries/08B9044D178E32EA3AC194442B6DB9485EA1B445","files_trashbin/files/08B9044D178E32EA3AC194442B6DB9485EA1B445.d1598795448"]},{"file":"/var/www/html/nextcloud/apps/files_trashbin/lib/Trash/LegacyTrashBackend.php","line":108,"function":"move2trash","class":"OCA\\Files_Trashbin\\Trashbin","type":"::","args":["Sync/Python Projekte/***SENSITIVE***/FF-profiles/cache2/entries/08B9044D178E32EA3AC194442B6DB9485EA1B445"]},{"file":"/var/www/html/nextcloud/apps/files_trashbin/lib/Trash/TrashManager.php","line":103,"function":"moveToTrash","class":"OCA\\Files_Trashbin\\Trash\\LegacyTrashBackend","type":"->","args":[{"cache":null,"scanner":null,"watcher":null,"propagator":null,"updater":null,"__class__":"OCA\\Files_Trashbin\\Storage"},"files/Sync/Python Projekte/***SENSITIVE***/FF-profiles/cache2/entries/08B9044D178E32EA3AC194442B6DB9485EA1B445"]},{"file":"/var/www/html/nextcloud/apps/files_trashbin/lib/Storage.php","line":192,"function":"moveToTrash","class":"OCA\\Files_Trashbin\\Trash\\TrashManager","type":"->","args":[{"cache":null,"scanner":null,"watcher":null,"propagator":null,"updater":null,"__class__":"OCA\\Files_Trashbin\\Storage"},"files/Sync/Python Projekte/***SENSITIVE***/FF-profiles/cache2/entries/08B9044D178E32EA3AC194442B6DB9485EA1B445"]},{"file":"/var/www/html/nextcloud/apps/files_trashbin/lib/Storage.php","line":99,"function":"doDelete","class":"OCA\\Files_Trashbin\\Storage","type":"->","args":["files/Sync/Python Projekte/***SENSITIVE***/FF-profiles/cache2/entries/08B9044D178E32EA3AC194442B6DB9485EA1B445","unlink"]},{"file":"/var/www/html/nextcloud/apps/files_accesscontrol/lib/StorageWrapper.php","line":287,"function":"unlink","class":"OCA\\Files_Trashbin\\Storage","type":"->","args":["files/Sync/Python Projekte/***SENSITIVE***/FF-profiles/cache2/entries/08B9044D178E32EA3AC194442B6DB9485EA1B445"]},{"file":"/var/www/html/nextcloud/lib/private/Files/View.php","line":1161,"function":"unlink","class":"OCA\\FilesAccessControl\\StorageWrapper","type":"->","args":["files/Sync/Python Projekte/***SENSITIVE***/FF-profiles/cache2/entries/08B9044D178E32EA3AC194442B6DB9485EA1B445"]},{"file":"/var/www/html/nextcloud/lib/private/Files/View.php","line":718,"function":"basicOperation","class":"OC\\Files\\View","type":"->","args":["unlink","/Sync/Python Projekte/***SENSITIVE***/FF-profiles/cache2/entries/08B9044D178E32EA3AC194442B6DB9485EA1B445",["delete"]]},{"file":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/File.php","line":455,"function":"unlink","class":"OC\\Files\\View","type":"->","args":["/Sync/Python Projekte/***SENSITIVE***/FF-profiles/cache2/entries/08B9044D178E32EA3AC194442B6DB9485EA1B445"]},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Tree.php","line":183,"function":"delete","class":"OCA\\DAV\\Connector\\Sabre\\File","type":"->","args":[]},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php","line":295,"function":"delete","class":"Sabre\\DAV\\Tree","type":"->","args":["files/bogatkaj/Sync/Python Projekte/***SENSITIVE***/FF-profiles/cache2/entries/08B9044D178E32EA3AC194442B6DB9485EA1B445"]},{"file":"/var/www/html/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"httpDelete","class":"Sabre\\DAV\\CorePlugin","type":"->","args":[{"__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":474,"function":"emit","class":"Sabre\\DAV\\Server","type":"->","args":["method:DELETE",[{"__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]]},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":251,"function":"invokeMethod","class":"Sabre\\DAV\\Server","type":"->","args":[{"__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":319,"function":"start","class":"Sabre\\DAV\\Server","type":"->","args":[]},{"file":"/var/www/html/nextcloud/apps/dav/lib/Server.php","line":320,"function":"exec","class":"Sabre\\DAV\\Server","type":"->","args":[]},{"file":"/var/www/html/nextcloud/apps/dav/appinfo/v2/remote.php","line":35,"function":"exec","class":"OCA\\DAV\\Server","type":"->","args":[]},{"file":"/var/www/html/nextcloud/remote.php","line":167,"args":["/var/www/html/nextcloud/apps/dav/appinfo/v2/remote.php"],"function":"require_once"}],"File":"/var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php","Line":119,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction","Code":"HY000","Trace":[{"file":"/var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php","line":117,"function":"execute","class":"PDOStatement","type":"->","args":[null]},{"file":"/var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php","line":1054,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDOStatement","type":"->","args":[]},{"file":"/var/www/html/nextcloud/lib/private/DB/Connection.php","line":214,"function":"executeUpdate","class":"Doctrine\\DBAL\\Connection","type":"->","args":["UPDATE `oc_filecache` SET `size` = ? WHERE (`fileid` = ?) AND ((`size` <> ?) OR (`size` IS NULL))",[1044814235,"*** sensitive parameter replaced ***",1044814235],[2,1,2]]},{"file":"/var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php","line":203,"function":"executeUpdate","class":"OC\\DB\\Connection","type":"->","args":["UPDATE `oc_filecache` SET `size` = :dcValue3 WHERE (`fileid` = :dcValue1) AND ((`size` <> :dcValue2) OR (`size` IS NULL))",{"dcValue1":"*** sensitive parameter replaced ***","dcValue2":1044814235,"dcValue3":1044814235},{"dcValue1":1,"dcValue2":2,"dcValue3":2}]},{"file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":216,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/nextcloud/lib/private/Files/Cache/Cache.php","line":363,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/nextcloud/lib/private/Files/Cache/Cache.php","line":898,"function":"update","class":"OC\\Files\\Cache\\Cache","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/nextcloud/lib/private/Files/Cache/HomeCache.php","line":43,"function":"calculateFolderSize","class":"OC\\Files\\Cache\\Cache","type":"->","args":["files/Sync/Python Projekte/***SENSITIVE***/FF-profiles/cache2/entries",{"__class__":"OC\\Files\\Cache\\CacheEntry"}]},{"file":"/var/www/html/nextcloud/lib/private/Files/Cache/Cache.php","line":830,"function":"calculateFolderSize","class":"OC\\Files\\Cache\\HomeCache","type":"->","args":["files/Sync/Python Projekte/***SENSITIVE***/FF-profiles/cache2/entries",null]},{"file":"/var/www/html/nextcloud/lib/private/Files/Cache/Cache.php","line":842,"function":"correctFolderSize","class":"OC\\Files\\Cache\\Cache","type":"->","args":["files/Sync/Python Projekte/***SENSITIVE***/FF-profiles/cache2/entries"]},{"file":"/var/www/html/nextcloud/lib/private/Files/Cache/Wrapper/CacheWrapper.php","line":254,"function":"correctFolderSize","class":"OC\\Files\\Cache\\Cache","type":"->","args":["files/Sync/Python Projekte/***SENSITIVE***/FF-profiles/cache2/entries/08B9044D178E32EA3AC194442B6DB9485EA1B445",null,false]},{"file":"/var/www/html/nextcloud/lib/private/Files/Cache/Updater.php","line":217,"function":"correctFolderSize","class":"OC\\Files\\Cache\\Wrapper\\CacheWrapper","type":"->","args":["files/Sync/Python Projekte/***SENSITIVE***/FF-profiles/cache2/entries/08B9044D178E32EA3AC194442B6DB9485EA1B445"]},{"file":"/var/www/html/nextcloud/apps/files_trashbin/lib/Trashbin.php","line":289,"function":"renameFromStorage","class":"OC\\Files\\Cache\\Updater","type":"->","args":[{"mountPoint":"/bogatkaj/","cache":null,"scanner":{"__class__":"OC\\Files\\Cache\\Scanner"},"watcher":null,"propagator":null,"updater":{"__class__":"OC\\Files\\Cache\\Updater"},"__class__":"OCA\\FilesAccessControl\\StorageWrapper"},"files/Sync/Python Projekte/***SENSITIVE***/FF-profiles/cache2/entries/08B9044D178E32EA3AC194442B6DB9485EA1B445","files_trashbin/files/08B9044D178E32EA3AC194442B6DB9485EA1B445.d1598795448"]},{"file":"/var/www/html/nextcloud/apps/files_trashbin/lib/Trash/LegacyTrashBackend.php","line":108,"function":"move2trash","class":"OCA\\Files_Trashbin\\Trashbin","type":"::","args":["Sync/Python Projekte/***SENSITIVE***/FF-profiles/cache2/entries/08B9044D178E32EA3AC194442B6DB9485EA1B445"]},{"file":"/var/www/html/nextcloud/apps/files_trashbin/lib/Trash/TrashManager.php","line":103,"function":"moveToTrash","class":"OCA\\Files_Trashbin\\Trash\\LegacyTrashBackend","type":"->","args":[{"cache":null,"scanner":null,"watcher":null,"propagator":null,"updater":null,"__class__":"OCA\\Files_Trashbin\\Storage"},"files/Sync/Python Projekte/***SENSITIVE***/FF-profiles/cache2/entries/08B9044D178E32EA3AC194442B6DB9485EA1B445"]},{"file":"/var/www/html/nextcloud/apps/files_trashbin/lib/Storage.php","line":192,"function":"moveToTrash","class":"OCA\\Files_Trashbin\\Trash\\TrashManager","type":"->","args":[{"cache":null,"scanner":null,"watcher":null,"propagator":null,"updater":null,"__class__":"OCA\\Files_Trashbin\\Storage"},"files/Sync/Python Projekte/***SENSITIVE***/FF-profiles/cache2/entries/08B9044D178E32EA3AC194442B6DB9485EA1B445"]},{"file":"/var/www/html/nextcloud/apps/files_trashbin/lib/Storage.php","line":99,"function":"doDelete","class":"OCA\\Files_Trashbin\\Storage","type":"->","args":["files/Sync/Python Projekte/***SENSITIVE***/FF-profiles/cache2/entries/08B9044D178E32EA3AC194442B6DB9485EA1B445","unlink"]},{"file":"/var/www/html/nextcloud/apps/files_accesscontrol/lib/StorageWrapper.php","line":287,"function":"unlink","class":"OCA\\Files_Trashbin\\Storage","type":"->","args":["files/Sync/Python Projekte/***SENSITIVE***/FF-profiles/cache2/entries/08B9044D178E32EA3AC194442B6DB9485EA1B445"]},{"file":"/var/www/html/nextcloud/lib/private/Files/View.php","line":1161,"function":"unlink","class":"OCA\\FilesAccessControl\\StorageWrapper","type":"->","args":["files/Sync/Python Projekte/***SENSITIVE***/FF-profiles/cache2/entries/08B9044D178E32EA3AC194442B6DB9485EA1B445"]},{"file":"/var/www/html/nextcloud/lib/private/Files/View.php","line":718,"function":"basicOperation","class":"OC\\Files\\View","type":"->","args":["unlink","/Sync/Python Projekte/***SENSITIVE***/FF-profiles/cache2/entries/08B9044D178E32EA3AC194442B6DB9485EA1B445",["delete"]]},{"file":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/File.php","line":455,"function":"unlink","class":"OC\\Files\\View","type":"->","args":["/Sync/Python Projekte/***SENSITIVE***/FF-profiles/cache2/entries/08B9044D178E32EA3AC194442B6DB9485EA1B445"]},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Tree.php","line":183,"function":"delete","class":"OCA\\DAV\\Connector\\Sabre\\File","type":"->","args":[]},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php","line":295,"function":"delete","class":"Sabre\\DAV\\Tree","type":"->","args":["files/bogatkaj/Sync/Python Projekte/***SENSITIVE***/FF-profiles/cache2/entries/08B9044D178E32EA3AC194442B6DB9485EA1B445"]},{"file":"/var/www/html/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"httpDelete","class":"Sabre\\DAV\\CorePlugin","type":"->","args":[{"__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":474,"function":"emit","class":"Sabre\\DAV\\Server","type":"->","args":["method:DELETE",[{"__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]]},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":251,"function":"invokeMethod","class":"Sabre\\DAV\\Server","type":"->","args":[{"__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":319,"function":"start","class":"Sabre\\DAV\\Server","type":"->","args":[]},{"file":"/var/www/html/nextcloud/apps/dav/lib/Server.php","line":320,"function":"exec","class":"Sabre\\DAV\\Server","type":"->","args":[]},{"file":"/var/www/html/nextcloud/apps/dav/appinfo/v2/remote.php","line":35,"function":"exec","class":"OCA\\DAV\\Server","type":"->","args":[]},{"file":"/var/www/html/nextcloud/remote.php","line":167,"args":["/var/www/html/nextcloud/apps/dav/appinfo/v2/remote.php"],"function":"require_once"}],"File":"/var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php","Line":117}},"CustomMessage":"--"},"userAgent":"Mozilla/5.0 (Windows) mirall/2.6.4stable-Win64 (build 20200303) (Nextcloud)","version":"19.0.2.2","id":"5f4bb675458aa"}
3

Well, it seems like I found a way to solve the problem or at least the “symptom”.
After taking a closer look to the logs I found that there is some problem with some particular files.

After deleting the contents of the oc_files_lock table (because they were locked for some reason), deleting them and running files:scan everything seems to work quite normal again.

Maybe this helps aomeone having the same problem some day.

NG
Jan-Niklas

1 Like