"LockWaitTimeoutException" error in log

Hi all,

I am getting errors in the log that I haven’t seen before - popped up after upgrading to NC19 (to be honest, it was a mistake, wanted to upgrade to nc18.0.5…). I don’t understand what it’s connected to?

[core] Error: Doctrine\DBAL\Exception\LockWaitTimeoutException: An exception occurred while executing ‘DELETE FROM oc_file_locks WHERE ttl < ?’ with params [1591591202]:

SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction at <>

  1. /var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 169
    Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException(“An exception oc … n”, Doctrine\DBAL\Dr … ]})
  2. /var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 145
    Doctrine\DBAL\DBALException::wrapException(Doctrine\DBAL\Driver\PDOMySql\Driver {}, Doctrine\DBAL\Dr … ]}, “An exception oc … n”)
  3. /var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php line 1063
    Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Doctrine\DBAL\Driver\PDOMySql\Driver {}, Doctrine\DBAL\Dr … ]}, “DELETE FROM `oc … ?”, {1: 1591591202})
  4. /var/www/html/lib/private/DB/Connection.php line 214
    Doctrine\DBAL\Connection->executeUpdate(“DELETE FROM `oc … ?”, [1591591202], [])
  5. /var/www/html/lib/private/Lock/DBLockingProvider.php line 279
    OC\DB\Connection->executeUpdate(“DELETE FROM `oc … ?”, [1591591202])
  6. /var/www/html/apps/files/lib/BackgroundJob/CleanupFileLocks.php line 58
    OC\Lock\DBLockingProvider->cleanExpiredLocks()
  7. /var/www/html/lib/private/BackgroundJob/Job.php line 62
    OCA\Files\BackgroundJob\CleanupFileLocks->run(null)
  8. /var/www/html/lib/private/BackgroundJob/TimedJob.php line 57
    OC\BackgroundJob\Job->execute(OC\BackgroundJob\JobList {}, OC\Log {})
  9. /var/www/html/cron.php line 126
    OC\BackgroundJob\TimedJob->execute(OC\BackgroundJob\JobList {}, OC\Log {})

at 2020-06-08T04:40:53+00:00

Big thanks in advance!

I restore a backup and went back to 18. But might be good to keep it here if someone else run into the same issue.