hi
Today there was an OTP Manager update, and since then I have had an error displayed and I would like to correct it. I hardly used this application, so I uninstalled it and deleted the entries in the database which corresponded to OTP Manger but the error persists.
Debian 12
PHP8.2
MariaDB 11.2.3
Apache 2.4
Nextcloud 28.0.4 installation manual ( No docker , No Snap , No A.I.O …)
here are the logs:
{
"system": {
"instanceid": "***REMOVED SENSITIVE VALUE***",
"passwordsalt": "***REMOVED SENSITIVE VALUE***",
"secret": "***REMOVED SENSITIVE VALUE***",
"trusted_domains": [
"127.0.0.1",
"nextcloud.datanetwork.cloud",
"www.nextcloud.datanetwork.cloud"
],
"datadirectory": "***REMOVED SENSITIVE VALUE***",
"dbtype": "mysql",
"version": "28.0.4.1",
"overwrite.cli.url": "https:\/\/nextcloud.datanetwork.cloud",
"dbname": "***REMOVED SENSITIVE VALUE***",
"dbhost": "***REMOVED SENSITIVE VALUE***",
"dbport": "",
"dbtableprefix": "oc_",
"mysql.utf8mb4": true,
"dbuser": "***REMOVED SENSITIVE VALUE***",
"dbpassword": "***REMOVED SENSITIVE VALUE***",
"installed": true,
"default_phone_region": "FR",
"htaccess.RewriteBase": "\/",
"trashbin_retention_obligation": "auto, 30",
"filelocking.enabled": "true",
"knowledgebaseenabled": false,
"activity_expire_days": 7,
"skeletondirectory": "\/var\/www\/extra_nextcloud\/skeleton\/",
"redis": {
"host": "***REMOVED SENSITIVE VALUE***",
"port": "0",
"timeout": "0.0"
},
"memcache.distributed": "\\OC\\Memcache\\Redis",
"memcache.local": "\\OC\\Memcache\\Redis",
"memcache.locking": "\\OC\\Memcache\\Redis",
"mail_smtpmode": "smtp",
"mail_smtpsecure": "ssl",
"mail_sendmailmode": "smtp",
"mail_from_address": "***REMOVED SENSITIVE VALUE***",
"mail_domain": "***REMOVED SENSITIVE VALUE***",
"mail_smtphost": "***REMOVED SENSITIVE VALUE***",
"mail_smtpport": "465",
"mail_smtpauth": 1,
"mail_smtpname": "***REMOVED SENSITIVE VALUE***",
"mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
"updater.release.channel": "stable",
"maintenance_window_start": 1,
"maintenance": false,
"enable_previews": true,
"enabledPreviewProviders": {
"1": "OC\\Preview\\BMP",
"2": "OC\\Preview\\GIF",
"3": "OC\\Preview\\JPEG",
"4": "OC\\Preview\\Krita",
"5": "OC\\Preview\\MarkDown",
"6": "OC\\Preview\\MP3",
"7": "OC\\Preview\\OpenDocument",
"8": "OC\\Preview\\PNG",
"9": "OC\\Preview\\TXT",
"10": "OC\\Preview\\XBitmap",
"11": "OC\\Preview\\Image",
"12": "OC\\Preview\\HEIC",
"13": "OC\\Preview\\TIFF",
"14": "OC\\Preview\\Movie",
"15": "OC\\Preview\\MP4",
"16": "OC\\Preview\\PDF"
},
"preview_max_x": 1024,
"preview_max_y": 1024,
"preview_concurrency_all": 32,
"preview_concurrency_new": 16,
"preview_max_filesize_image": 200,
"preview_max_memory": 1024,
"preview_ffmpeg_path": "\/usr\/bin\/ffmpeg",
"theme": "",
"loglevel": 2,
"defaultapp": ""
}
}
/settings/integrity/failed
Technical information
=====================
The following list covers which files have failed the integrity check. Please read
the previous linked documentation to learn more about the errors and how to fix
them.
Results
=======
- core
- INVALID_HASH
- core/js/mimetypelist.js
Raw output
==========
Array
(
[core] => Array
(
[INVALID_HASH] => Array
(
[core/js/mimetypelist.js] => Array
(
[expected] => 550ab566d30693bfa24ec4b15d9df87731ae8a3be8f79dabf94757e5b8b20eec6e4b678f17af1718297f2872f6b04519eeb024d1dff11947f29da431c7f11201
[current] => 24e6faa4a1361e51ff70027024f41c4b37fdb5f6f347ceb095450ddbde2d0a6b6dd1403be92a912d2889064a9736a9bed89d7dc62470035fc1299d4b977c5f46
)
)
)
)
Error log
root@Lenovo-TS150:~# sudo -u www-data php /var/www/nextcloud/occ integrity:check-core
- INVALID_HASH:
- core/js/mimetypelist.js:
- expected: 550ab566d30693bfa24ec4b15d9df87731ae8a3be8f79dabf94757e5b8b20eec6e4b678f17af1718297f2872f6b04519eeb024d1dff11947f29da431c7f11201
- current: 24e6faa4a1361e51ff70027024f41c4b37fdb5f6f347ceb095450ddbde2d0a6b6dd1403be92a912d2889064a9736a9bed89d7dc62470035fc1299d4b977c5f46
LockWaitTimeoutExceptionAn exception occurred while executing a query: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
1. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.phpLigne 1938
Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert
()
2. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.phpLigne 1880
Doctrine\DBAL\Connection->handleDriverException
()
3. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.phpLigne 1208
Doctrine\DBAL\Connection->convertExceptionDuringQuery
()
4. /var/www/nextcloud/lib/private/DB/Connection.phpLigne 294
Doctrine\DBAL\Connection->executeStatement
()
5. /var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.phpLigne 386
OC\DB\Connection->executeStatement
()
6. /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.phpLigne 280
Doctrine\DBAL\Query\QueryBuilder->execute
()
7. /var/www/nextcloud/lib/private/Files/Cache/Cache.phpLigne 558
OC\DB\QueryBuilder\QueryBuilder->execute
()
8. /var/www/nextcloud/lib/private/Files/Cache/Updater.phpLigne 164
OC\Files\Cache\Cache->remove
()
9. /var/www/nextcloud/lib/private/Files/View.phpLigne 330
OC\Files\Cache\Updater->remove
()
10. /var/www/nextcloud/lib/private/Files/Node/Folder.phpLigne 372
OC\Files\View->rmdir
()
11. /var/www/nextcloud/lib/private/Files/SimpleFS/SimpleFolder.phpLigne 67
OC\Files\Node\Folder->delete
()
12. /var/www/nextcloud/lib/private/Preview/BackgroundCleanupJob.phpLigne 69
OC\Files\SimpleFS\SimpleFolder->delete
()
13. /var/www/nextcloud/lib/public/BackgroundJob/Job.phpLigne 81
OC\Preview\BackgroundCleanupJob->run
()
14. /var/www/nextcloud/lib/public/BackgroundJob/TimedJob.phpLigne 102
OCP\BackgroundJob\Job->start
()
15. /var/www/nextcloud/lib/public/BackgroundJob/TimedJob.phpLigne 92
OCP\BackgroundJob\TimedJob->start
()
16. /var/www/nextcloud/cron.phpLigne 152
OCP\BackgroundJob\TimedJob->execute
()
Causé par ExceptionSQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
---
Entrée brute dans le journal
{
“reqId”: “pnNTtjSotlcJXn9HpF5y”,
“level”: 3,
“time”: “2024-04-10T13:46:16+00:00”,
“remoteAddr”: “”,
“user”: “–”,
“app”: “core”,
“method”: “”,
“url”: “–”,
“message”: “Error while running background job (class: OC\Preview\BackgroundCleanupJob, arguments: )”,
“userAgent”: “–”,
“version”: “28.0.4.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”: 1938,
“function”: “convert”,
“class”: “Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter”,
“type”: “->”
},
{
“file”: “/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php”,
“line”: 1880,
“function”: “handleDriverException”,
“class”: “Doctrine\DBAL\Connection”,
“type”: “->”
},
{
“file”: “/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php”,
“line”: 1208,
“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”: 386,
“function”: “executeStatement”,
“class”: “OC\DB\Connection”,
“type”: “->”
},
{
“file”: “/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php”,
“line”: 280,
“function”: “execute”,
“class”: “Doctrine\DBAL\Query\QueryBuilder”,
“type”: “->”
},
{
“file”: “/var/www/nextcloud/lib/private/Files/Cache/Cache.php”,
“line”: 558,
“function”: “execute”,
“class”: “OC\DB\QueryBuilder\QueryBuilder”,
“type”: “->”
},
{
“file”: “/var/www/nextcloud/lib/private/Files/Cache/Updater.php”,
“line”: 164,
“function”: “remove”,
“class”: “OC\Files\Cache\Cache”,
“type”: “->”
},
{
“file”: “/var/www/nextcloud/lib/private/Files/View.php”,
“line”: 330,
“function”: “remove”,
“class”: “OC\Files\Cache\Updater”,
“type”: “->”
},
{
“file”: “/var/www/nextcloud/lib/private/Files/Node/Folder.php”,
“line”: 372,
“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/BackgroundCleanupJob.php”,
“line”: 69,
“function”: “delete”,
“class”: “OC\Files\SimpleFS\SimpleFolder”,
“type”: “->”
},
{
“file”: “/var/www/nextcloud/lib/public/BackgroundJob/Job.php”,
“line”: 81,
“function”: “run”,
“class”: “OC\Preview\BackgroundCleanupJob”,
“type”: “->”
},
{
“file”: “/var/www/nextcloud/lib/public/BackgroundJob/TimedJob.php”,
“line”: 102,
“function”: “start”,
“class”: “OCP\BackgroundJob\Job”,
“type”: “->”
},
{
“file”: “/var/www/nextcloud/lib/public/BackgroundJob/TimedJob.php”,
“line”: 92,
“function”: “start”,
“class”: “OCP\BackgroundJob\TimedJob”,
“type”: “->”
},
{
“file”: “/var/www/nextcloud/cron.php”,
“line”: 152,
“function”: “execute”,
“class”: “OCP\BackgroundJob\TimedJob”,
“type”: “->”
}
],
“File”: “/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php”,
“Line”: 42,
“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”: 132,
“function”: “new”,
“class”: “Doctrine\DBAL\Driver\PDO\Exception”,
“type”: “::”
},
{
“file”: “/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php”,
“line”: 1202,
“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”: 386,
“function”: “executeStatement”,
“class”: “OC\DB\Connection”,
“type”: “->”
},
{
“file”: “/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php”,
“line”: 280,
“function”: “execute”,
“class”: “Doctrine\DBAL\Query\QueryBuilder”,
“type”: “->”
},
{
“file”: “/var/www/nextcloud/lib/private/Files/Cache/Cache.php”,
“line”: 558,
“function”: “execute”,
“class”: “OC\DB\QueryBuilder\QueryBuilder”,
“type”: “->”
},
{
“file”: “/var/www/nextcloud/lib/private/Files/Cache/Updater.php”,
“line”: 164,
“function”: “remove”,
“class”: “OC\Files\Cache\Cache”,
“type”: “->”
},
{
“file”: “/var/www/nextcloud/lib/private/Files/View.php”,
“line”: 330,
“function”: “remove”,
“class”: “OC\Files\Cache\Updater”,
“type”: “->”
},
{
“file”: “/var/www/nextcloud/lib/private/Files/Node/Folder.php”,
“line”: 372,
“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/BackgroundCleanupJob.php”,
“line”: 69,
“function”: “delete”,
“class”: “OC\Files\SimpleFS\SimpleFolder”,
“type”: “->”
},
{
“file”: “/var/www/nextcloud/lib/public/BackgroundJob/Job.php”,
“line”: 81,
“function”: “run”,
“class”: “OC\Preview\BackgroundCleanupJob”,
“type”: “->”
},
{
“file”: “/var/www/nextcloud/lib/public/BackgroundJob/TimedJob.php”,
“line”: 102,
“function”: “start”,
“class”: “OCP\BackgroundJob\Job”,
“type”: “->”
},
{
“file”: “/var/www/nextcloud/lib/public/BackgroundJob/TimedJob.php”,
“line”: 92,
“function”: “start”,
“class”: “OCP\BackgroundJob\TimedJob”,
“type”: “->”
},
{
“file”: “/var/www/nextcloud/cron.php”,
“line”: 152,
“function”: “execute”,
“class”: “OCP\BackgroundJob\TimedJob”,
“type”: “->”
}
],
“File”: “/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php”,
“Line”: 28,
“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”: 130,
“function”: “execute”,
“class”: “PDOStatement”,
“type”: “->”
},
{
“file”: “/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php”,
“line”: 1202,
“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”: 386,
“function”: “executeStatement”,
“class”: “OC\DB\Connection”,
“type”: “->”
},
{
“file”: “/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php”,
“line”: 280,
“function”: “execute”,
“class”: “Doctrine\DBAL\Query\QueryBuilder”,
“type”: “->”
},
{
“file”: “/var/www/nextcloud/lib/private/Files/Cache/Cache.php”,
“line”: 558,
“function”: “execute”,
“class”: “OC\DB\QueryBuilder\QueryBuilder”,
“type”: “->”
},
{
“file”: “/var/www/nextcloud/lib/private/Files/Cache/Updater.php”,
“line”: 164,
“function”: “remove”,
“class”: “OC\Files\Cache\Cache”,
“type”: “->”
},
{
“file”: “/var/www/nextcloud/lib/private/Files/View.php”,
“line”: 330,
“function”: “remove”,
“class”: “OC\Files\Cache\Updater”,
“type”: “->”
},
{
“file”: “/var/www/nextcloud/lib/private/Files/Node/Folder.php”,
“line”: 372,
“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/BackgroundCleanupJob.php”,
“line”: 69,
“function”: “delete”,
“class”: “OC\Files\SimpleFS\SimpleFolder”,
“type”: “->”
},
{
“file”: “/var/www/nextcloud/lib/public/BackgroundJob/Job.php”,
“line”: 81,
“function”: “run”,
“class”: “OC\Preview\BackgroundCleanupJob”,
“type”: “->”
},
{
“file”: “/var/www/nextcloud/lib/public/BackgroundJob/TimedJob.php”,
“line”: 102,
“function”: “start”,
“class”: “OCP\BackgroundJob\Job”,
“type”: “->”
},
{
“file”: “/var/www/nextcloud/lib/public/BackgroundJob/TimedJob.php”,
“line”: 92,
“function”: “start”,
“class”: “OCP\BackgroundJob\TimedJob”,
“type”: “->”
},
{
“file”: “/var/www/nextcloud/cron.php”,
“line”: 152,
“function”: “execute”,
“class”: “OCP\BackgroundJob\TimedJob”,
“type”: “->”
}
],
“File”: “/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php”,
“Line”: 130
}
},
“message”: “Error while running background job (class: OC\Preview\BackgroundCleanupJob, arguments: )”,
“exception”: ,
“CustomMessage”: “Error while running background job (class: OC\Preview\BackgroundCleanupJob, arguments: )”
},
“id”: “66169dda22e85”
}
Thanks for your help