"LockWaitTimeoutException" error in log

ā„¹ļø Support šŸ“¦ Appliances (Docker, Snappy, VM, NCP, AIO)
1

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!

2

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.