Nextcloud after large file upload --> Processing data bar doesn't disappear

Hey guys,

I’ve successfully installed manually nextcloud 23 with MariaDB 10.5, php8 on my raspberry pi 4 4gb.
I’m running a reverse proxy on another server, which provides security.

Everything is running fine so far, but after I’m uploading large folders (over 10gb), it stucks in the “data being processed” bar. I don’t get an error, after I’m reloading the site the bar disappears.

Has anyone an idea, how to fix that?

Error in Logs:
Doctrine\DBAL\Exception\DeadlockException: An exception occurred while executing a query: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction

  1. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php - line 1780: Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert()
  2. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php - line 1719: Doctrine\DBAL\Connection->handleDriverException()
  3. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php - line 1173: Doctrine\DBAL\Connection->convertExceptionDuringQuery()
  4. /var/www/nextcloud/lib/private/DB/Connection.php - line 267: Doctrine\DBAL\Connection->executeStatement()
  5. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php - line 354: OC\DB\Connection->executeStatement()
  6. /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 287: Doctrine\DBAL\Query\QueryBuilder->execute()
  7. /var/www/nextcloud/lib/private/Files/Cache/Cache.php - line 379: OC\DB\QueryBuilder\QueryBuilder->execute()
  8. /var/www/nextcloud/lib/private/Files/Cache/Updater.php - line 256: OC\Files\Cache\Cache->update("*** sensiti … *")
  9. /var/www/nextcloud/lib/private/Files/Cache/Updater.php - line 138: OC\Files\Cache\Updater->correctParentStorageMtime()
  10. /var/www/nextcloud/lib/private/Files/View.php - line 323: OC\Files\Cache\Updater->update("*** sensiti … *")
  11. /var/www/nextcloud/lib/private/Files/View.php - line 1186: OC\Files\View->writeUpdate()
  12. /var/www/nextcloud/lib/private/Files/View.php - line 271: OC\Files\View->basicOperation()
  13. /var/www/nextcloud/apps/dav/lib/Connector/Sabre/Directory.php - line 188: OC\Files\View->mkdir()
  14. /var/www/nextcloud/apps/dav/lib/Upload/UploadHome.php - line 51: OCA\DAV\Connector\Sabre\Directory->createDirectory()
  15. /var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php - line 1210: OCA\DAV\Upload\UploadHome->createDirectory()
  16. /var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php - line 560: Sabre\DAV\Server->createCollection()
  17. /var/www/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php - line 89: Sabre\DAV\CorePlugin->httpMkcol()
  18. /var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php - line 472: Sabre\DAV\Server->emit()
  19. /var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php - line 253: Sabre\DAV\Server->invokeMethod()
  20. /var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php - line 321: Sabre\DAV\Server->start()
  21. /var/www/nextcloud/apps/dav/lib/Server.php - line 339: Sabre\DAV\Server->exec()
  22. /var/www/nextcloud/apps/dav/appinfo/v2/remote.php - line 35: OCA\DAV\Server->exec()
  23. /var/www/nextcloud/remote.php - line 166: require_once("/var/www/ne … p")

Verursacht durch Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction

  1. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php - line 94: Doctrine\DBAL\Driver\PDO\Exception::new()
  2. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php - line 1163: Doctrine\DBAL\Driver\PDO\Statement->execute()
  3. /var/www/nextcloud/lib/private/DB/Connection.php - line 267: Doctrine\DBAL\Connection->executeStatement()
  4. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php - line 354: OC\DB\Connection->executeStatement()
  5. /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 287: Doctrine\DBAL\Query\QueryBuilder->execute()
  6. /var/www/nextcloud/lib/private/Files/Cache/Cache.php - line 379: OC\DB\QueryBuilder\QueryBuilder->execute()
  7. /var/www/nextcloud/lib/private/Files/Cache/Updater.php - line 256: OC\Files\Cache\Cache->update("*** sensiti … *")
  8. /var/www/nextcloud/lib/private/Files/Cache/Updater.php - line 138: OC\Files\Cache\Updater->correctParentStorageMtime()
  9. /var/www/nextcloud/lib/private/Files/View.php - line 323: OC\Files\Cache\Updater->update("*** sensiti … *")
  10. /var/www/nextcloud/lib/private/Files/View.php - line 1186: OC\Files\View->writeUpdate()
  11. /var/www/nextcloud/lib/private/Files/View.php - line 271: OC\Files\View->basicOperation()
  12. /var/www/nextcloud/apps/dav/lib/Connector/Sabre/Directory.php - line 188: OC\Files\View->mkdir()
  13. /var/www/nextcloud/apps/dav/lib/Upload/UploadHome.php - line 51: OCA\DAV\Connector\Sabre\Directory->createDirectory()
  14. /var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php - line 1210: OCA\DAV\Upload\UploadHome->createDirectory()
  15. /var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php - line 560: Sabre\DAV\Server->createCollection()
  16. /var/www/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php - line 89: Sabre\DAV\CorePlugin->httpMkcol()
  17. /var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php - line 472: Sabre\DAV\Server->emit()
  18. /var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php - line 253: Sabre\DAV\Server->invokeMethod()
  19. /var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php - line 321: Sabre\DAV\Server->start()
  20. /var/www/nextcloud/apps/dav/lib/Server.php - line 339: Sabre\DAV\Server->exec()
  21. /var/www/nextcloud/apps/dav/appinfo/v2/remote.php - line 35: OCA\DAV\Server->exec()
  22. /var/www/nextcloud/remote.php - line 166: require_once("/var/www/ne … p")

Verursacht durch PDOException: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction

  1. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php - line 92: PDOStatement->execute()
  2. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php - line 1163: Doctrine\DBAL\Driver\PDO\Statement->execute()
  3. /var/www/nextcloud/lib/private/DB/Connection.php - line 267: Doctrine\DBAL\Connection->executeStatement()
  4. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php - line 354: OC\DB\Connection->executeStatement()
  5. /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 287: Doctrine\DBAL\Query\QueryBuilder->execute()
  6. /var/www/nextcloud/lib/private/Files/Cache/Cache.php - line 379: OC\DB\QueryBuilder\QueryBuilder->execute()
  7. /var/www/nextcloud/lib/private/Files/Cache/Updater.php - line 256: OC\Files\Cache\Cache->update("*** sensiti … *")
  8. /var/www/nextcloud/lib/private/Files/Cache/Updater.php - line 138: OC\Files\Cache\Updater->correctParentStorageMtime()
  9. /var/www/nextcloud/lib/private/Files/View.php - line 323: OC\Files\Cache\Updater->update("*** sensiti … *")
  10. /var/www/nextcloud/lib/private/Files/View.php - line 1186: OC\Files\View->writeUpdate()
  11. /var/www/nextcloud/lib/private/Files/View.php - line 271: OC\Files\View->basicOperation()
  12. /var/www/nextcloud/apps/dav/lib/Connector/Sabre/Directory.php - line 188: OC\Files\View->mkdir()
  13. /var/www/nextcloud/apps/dav/lib/Upload/UploadHome.php - line 51: OCA\DAV\Connector\Sabre\Directory->createDirectory()
  14. /var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php - line 1210: OCA\DAV\Upload\UploadHome->createDirectory()
  15. /var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php - line 560: Sabre\DAV\Server->createCollection()
  16. /var/www/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php - line 89: Sabre\DAV\CorePlugin->httpMkcol()
  17. /var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php - line 472: Sabre\DAV\Server->emit()
  18. /var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php - line 253: Sabre\DAV\Server->invokeMethod()
  19. /var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php - line 321: Sabre\DAV\Server->start()
  20. /var/www/nextcloud/apps/dav/lib/Server.php - line 339: Sabre\DAV\Server->exec()
  21. /var/www/nextcloud/apps/dav/appinfo/v2/remote.php - line 35: OCA\DAV\Server->exec()
  22. /var/www/nextcloud/remote.php - line 166: require_once("/var/www/ne … p")

Thanks for your help!
Best,
Alex