[FR] Le serveur est incapable d'exécuter votre requête - problème avec sqlite3

Stedewa · April 1, 2024, 8:12pm

Bonjour,

Une fois logué, j’ai un message :

Erreur interne du serveur

Le serveur est incapable d’exécuter votre requête.

Si cela se reproduit, veuillez envoyer les détails techniques ci-dessous à l’administrateur du serveur.

Le fichier journal du serveur peut fournir plus de renseignements.

Renseignements techniques

Adresse distante : 188...***

ID de la demande : ZgsPg*************AAADw

Dans nextcloud.log je vois :

“An exception occurred while executing a query: SQLSTATE[HY000]: General error: 11 database disk image is malformed”,“userAgent”:"Mozilla/5.0 …

Y a-t-il qqch qui me permettent de débloquer la situation ? (Je crois que je vais passer à MySql pour cette instance de NextCloud dans les meilleurs délais… mais avant y a-t-il qqch à faire ?

Mon config.php:

<?php $CONFIG = array ( 'instanceid' => '*******', 'passwordsalt' => '********', 'secret' => '************', 'trusted_domains' => array ( 0 => '*********', ), 'datadirectory' => '/home/****/nc/data', 'dbtype' => 'sqlite3', 'version' => '28.0.3.2', 'overwrite.cli.url' => 'https://********/nc', 'installed' => true, 'theme' => '', 'loglevel' => 2, 'maintenance' => false, 'updater.secret' => '***********', );

Je ne suis pas un monstre expert, plutôt un admin lambda de quelques install nextcloud … donc merci d’être indulgent et patient

Merci d’avance!

vincen · April 2, 2024, 6:24am

Euh comment tu as fait pour installer NC avec sqlite ? il supporte uniquement MySQL/MariaDB, PostgreSQL et Oracle. Dans tous les cais faire tourner un NC avec une db sqlite n’est pas la meilleure des idées à mon avis !
Tu peux tenter (en arrêtant d’abord le serveur web ou en mettant NC en mode maintenance) une réparation de ta db sqlite pour voir si tu peux la récupérer. Dans le cas contraire tu seras bon pour réinstaller de propre le NC avec un vrai système de base de données

Stedewa · April 2, 2024, 6:53am

Merci du retour!
C’est en installant NC qu’il m’a mis d’office sqlite … pour d’autres instances, j’ai réussi à bien paramétrer Mysql lors de l’installation NC.
Mettre un vrai système de base de données, je vais m’y employer dès que je peux sur cette installation problématique !
Mais en attendant, j’aimerais faire revivre 2min au moins mon install…
Je n’ai accès que depuis mon mobile Android… J’ai un formulaire d’inscription en ligne qui fonctionne pour les personnes non connectées… (lien non public), j’arrive à récupérer le tableau des inscriptions. Une fois ces inscriptions closes (8.4.24) je ferai le grand nettoyage…
Mais si une option me permet de réparer ma base sqlite entre temps, je suis bien entendu preneur!
Merci!

Stedewa · April 2, 2024, 6:59am

Il semble y avoir un problème depuis le 27 mars, dans le nextcloud.log j’ai une ligne :

{“reqId”:“ZgR0eO7sllBdXuH29A6qXwAAAA8”,“level”:3,“time”:“2024-03-27T19:33:13+00:00”,“remoteAddr”:“178.******.105”,“user”:“******73”,“app”:“webdav”,“method”:“PROPFIND”,“url”:“/nc/remote.php/dav/files/******73/”,“message”:“SQLSTATE[HY000]: General error: 1 cannot rollback - no transaction is active”,“userAgent”:“Mozilla/5.0 (Windows) mirall/3.12.2stable-Win64 (build 20240320) (Nextcloud, windows-10.0.22631 ClientArchitecture: x86_64 OsArchitecture: x86_64)”,“version”:“28.0.3.2”,“exception”:{“Exception”:“Doctrine\DBAL\Driver\PDO\PDOException”,“Message”:“SQLSTATE[HY000]: General error: 1 cannot rollback - no transaction is active”,“Code”:“HY000”,“Trace”:[{“file”:“/home/******nc/3rdparty/doctrine/dbal/src/Driver/PDO/Connection.php”,“line”:137,“function”:“new”,“class”:“Doctrine\DBAL\Driver\PDO\PDOException”,“type”:“::”,“args”:[[“PDOException”,[“HY000”,1,“cannot rollback - no transaction is active”]]]},{“file”:“/home/******nc/3rdparty/doctrine/dbal/src/Connection.php”,“line”:1516,“function”:“rollBack”,“class”:“Doctrine\DBAL\Driver\PDO\Connection”,“type”:“->”,“args”:},{“file”:“/home/******nc/lib/private/DB/ConnectionAdapter.php”,“line”:162,“function”:“rollBack”,“class”:“Doctrine\DBAL\Connection”,“type”:“->”,“args”:},{“file”:“/home/******nc/lib/private/Files/Config/UserMountCache.php”,“line”:138,“function”:“rollBack”,“class”:“OC\DB\ConnectionAdapter”,“type”:“->”,“args”:},{“file”:“/home/******nc/lib/private/Files/SetupManager.php”,“line”:297,“function”:“registerMounts”,“class”:“OC\Files\Config\UserMountCache”,“type”:“->”,“args”:[[“OC\User\User”],[[“OC\Files\Mount\HomeMountPoint”]],[“OC\Files\Mount\CacheMountProvider”,“OCA\Files_Sharing\MountProvider”,“OCA\Files_Sharing\External\MountProvider”]]},{“file”:“/home/******nc/lib/private/Files/SetupManager.php”,“line”:221,“function”:“afterUserFullySetup”,“class”:“OC\Files\SetupManager”,“type”:“->”,“args”:[[“OC\User\User”],]},{“file”:“/home/******nc/lib/private/Files/SetupManager.php”,“line”:392,“function”:“setupForUser”,“class”:“OC\Files\SetupManager”,“type”:“->”,“args”:[[“OC\User\User”]]},{“file”:“/home/******nc/lib/private/Files/Mount/Manager.php”,“line”:97,“function”:“setupForPath”,“class”:“OC\Files\SetupManager”,“type”:“->”,“args”:[“/******73/files”]},{“file”:“/home/******nc/lib/private/Files/View.php”,“line”:1370,“function”:“find”,“class”:“OC\Files\Mount\Manager”,“type”:“->”,“args”:[“/******73/files”]},{“file”:“/home/******nc/lib/private/Files/Node/Root.php”,“line”:203,“function”:“getFileInfo”,“class”:“OC\Files\View”,“type”:“->”,“args”:[“/******73/files”,false]},{“file”:“/home/******nc/lib/private/Files/Node/LazyUserFolder.php”,“line”:47,“function”:“get”,“class”:“OC\Files\Node\Root”,“type”:“->”,“args”:[“/***73/files"]},{“function”:“OC\Files\Node\{closure}”,“class”:“OC\Files\Node\LazyUserFolder”,“type”:“->”,“args”:[" sensitive parameters replaced ***”]},{“file”:“/home/******nc/lib/private/Files/Node/LazyFolder.php”,“line”:70,“function”:“call_user_func”,“args”:[[“Closure”]]},{“file”:“/home/******nc/lib/private/Files/Node/LazyFolder.php”,“line”:84,“function”:“getRealFolder”,“class”:“OC\Files\Node\LazyFolder”,“type”:“->”,“args”:},{“file”:“/home/******nc/lib/private/Files/Node/LazyFolder.php”,“line”:260,“function”:“__call”,“class”:“OC\Files\Node\LazyFolder”,“type”:“->”,“args”:[“getEtag”,]},{“file”:“/home/******nc/apps/dav/lib/Connector/Sabre/Node.php”,“line”:208,“function”:“getEtag”,“class”:“OC\Files\Node\LazyFolder”,“type”:“->”,“args”:},{“file”:“/home/******nc/apps/dav/lib/Connector/Sabre/FilesPlugin.php”,“line”:335,“function”:“getETag”,“class”:“OCA\DAV\Connector\Sabre\Node”,“type”:“->”,“args”:},{“file”:“/home/***nc/3rdparty/sabre/dav/lib/DAV/PropFind.php",“line”:95,“function”:“OCA\DAV\Connector\Sabre\{closure}”,“class”:“OCA\DAV\Connector\Sabre\FilesPlugin”,“type”:“->”,“args”:[" sensitive parameters replaced ***”]},{“file”:“/home/******nc/apps/dav/lib/Connector/Sabre/FilesPlugin.php”,“line”:334,“function”:“handle”,“class”:“Sabre\DAV\PropFind”,“type”:“->”,“args”:[“{DAV:}getetag”,[“Closure”]]},{“file”:“/home/******nc/3rdparty/sabre/event/lib/WildcardEmitterTrait.php”,“line”:89,“function”:“handleGetProperties”,“class”:“OCA\DAV\Connector\Sabre\FilesPlugin”,“type”:“->”,“args”:[[“Sabre\DAV\PropFind”],[“OCA\DAV\Files\FilesHome”]]},{“file”:“/home/******nc/3rdparty/sabre/dav/lib/DAV/Server.php”,“line”:1052,“function”:“emit”,“class”:“Sabre\DAV\Server”,“type”:“->”,“args”:[“propFind”,[[“Sabre\DAV\PropFind”],[“OCA\DAV\Files\FilesHome”]]]},{“file”:“/home/******nc/3rdparty/sabre/dav/lib/DAV/Server.php”,“line”:984,“function”:“getPropertiesByNode”,“class”:“Sabre\DAV\Server”,“type”:“->”,“args”:[[“Sabre\DAV\PropFind”],[“OCA\DAV\Files\FilesHome”]]},{“file”:“/home/******nc/3rdparty/sabre/dav/lib/DAV/Server.php”,“line”:1662,“function”:“getPropertiesIteratorForPath”,“class”:“Sabre\DAV\Server”,“type”:“->”,“args”:[“files/******73”,[“{DAV:}getetag”],0]},{“file”:“/home/******nc/3rdparty/sabre/dav/lib/DAV/Server.php”,“line”:1647,“function”:“writeMultiStatus”,“class”:“Sabre\DAV\Server”,“type”:“->”,“args”:[[“Sabre\Xml\Writer”,,“/nc/remote.php/dav/”,[“d”,“s”,“oc”,“nc”],],[“Generator”],false]},{“file”:“/home/******nc/3rdparty/sabre/dav/lib/DAV/CorePlugin.php”,“line”:346,“function”:“generateMultiStatus”,“class”:“Sabre\DAV\Server”,“type”:“->”,“args”:[[“Generator”],false]},{“file”:“/home/******nc/3rdparty/sabre/event/lib/WildcardEmitterTrait.php”,“line”:89,“function”:“httpPropFind”,“class”:“Sabre\DAV\CorePlugin”,“type”:“->”,“args”:[[“Sabre\HTTP\Request”],[“Sabre\HTTP\Response”]]},{“file”:“/home/******nc/3rdparty/sabre/dav/lib/DAV/Server.php”,“line”:472,“function”:“emit”,“class”:“Sabre\DAV\Server”,“type”:“->”,“args”:[“method:PROPFIND”,[[“Sabre\HTTP\Request”],[“Sabre\HTTP\Response”]]]},{“file”:“/home/******nc/3rdparty/sabre/dav/lib/DAV/Server.php”,“line”:253,“function”:“invokeMethod”,“class”:“Sabre\DAV\Server”,“type”:“->”,“args”:[[“Sabre\HTTP\Request”],[“Sabre\HTTP\Response”]]},{“file”:“/home/******nc/3rdparty/sabre/dav/lib/DAV/Server.php”,“line”:321,“function”:“start”,“class”:“Sabre\DAV\Server”,“type”:“->”,“args”:},{“file”:“/home/******nc/apps/dav/lib/Server.php”,“line”:373,“function”:“exec”,“class”:“Sabre\DAV\Server”,“type”:“->”,“args”:},{“file”:“/home/******nc/apps/dav/appinfo/v2/remote.php”,“line”:35,“function”:“exec”,“class”:“OCA\DAV\Server”,“type”:“->”,“args”:},{“file”:“/home/******nc/remote.php”,“line”:172,“args”:[“/home/******nc/apps/dav/appinfo/v2/remote.php”],“function”:“require_once”}],“File”:“/home/******nc/3rdparty/doctrine/dbal/src/Driver/PDO/PDOException.php”,“Line”:20,“Previous”:{“Exception”:“PDOException”,“Message”:“SQLSTATE[HY000]: General error: 1 cannot rollback - no transaction is active”,“Code”:“HY000”,“Trace”:[{“file”:“/home/******nc/3rdparty/doctrine/dbal/src/Driver/PDO/Connection.php”,“line”:135,“function”:“rollBack”,“class”:“PDO”,“type”:“->”,“args”:},{“file”:“/home/******nc/3rdparty/doctrine/dbal/src/Connection.php”,“line”:1516,“function”:“rollBack”,“class”:“Doctrine\DBAL\Driver\PDO\Connection”,“type”:“->”,“args”:},{“file”:“/home/******nc/lib/private/DB/ConnectionAdapter.php”,“line”:162,“function”:“rollBack”,“class”:“Doctrine\DBAL\Connection”,“type”:“->”,“args”:},{“file”:“/home/******nc/lib/private/Files/Config/UserMountCache.php”,“line”:138,“function”:“rollBack”,“class”:“OC\DB\ConnectionAdapter”,“type”:“->”,“args”:},{“file”:“/home/******nc/lib/private/Files/SetupManager.php”,“line”:297,“function”:“registerMounts”,“class”:“OC\Files\Config\UserMountCache”,“type”:“->”,“args”:[[“OC\User\User”],[[“OC\Files\Mount\HomeMountPoint”]],[“OC\Files\Mount\CacheMountProvider”,“OCA\Files_Sharing\MountProvider”,“OCA\Files_Sharing\External\MountProvider”]]},{“file”:“/home/******nc/lib/private/Files/SetupManager.php”,“line”:221,“function”:“afterUserFullySetup”,“class”:“OC\Files\SetupManager”,“type”:“->”,“args”:[[“OC\User\User”],]},{“file”:“/home/******nc/lib/private/Files/SetupManager.php”,“line”:392,“function”:“setupForUser”,“class”:“OC\Files\SetupManager”,“type”:“->”,“args”:[[“OC\User\User”]]},{“file”:“/home/******nc/lib/private/Files/Mount/Manager.php”,“line”:97,“function”:“setupForPath”,“class”:“OC\Files\SetupManager”,“type”:“->”,“args”:[“/******73/files”]},{“file”:“/home/******nc/lib/private/Files/View.php”,“line”:1370,“function”:“find”,“class”:“OC\Files\Mount\Manager”,“type”:“->”,“args”:[“/******73/files”]},{“file”:“/home/******nc/lib/private/Files/Node/Root.php”,“line”:203,“function”:“getFileInfo”,“class”:“OC\Files\View”,“type”:“->”,“args”:[“/******73/files”,false]},{“file”:“/home/******nc/lib/private/Files/Node/LazyUserFolder.php”,“line”:47,“function”:“get”,“class”:“OC\Files\Node\Root”,“type”:“->”,“args”:[“/***73/files"]},{“function”:“OC\Files\Node\{closure}”,“class”:“OC\Files\Node\LazyUserFolder”,“type”:“->”,“args”:[" sensitive parameters replaced ***”]},{“file”:“/home/******nc/lib/private/Files/Node/LazyFolder.php”,“line”:70,“function”:“call_user_func”,“args”:[[“Closure”]]},{“file”:“/home/******nc/lib/private/Files/Node/LazyFolder.php”,“line”:84,“function”:“getRealFolder”,“class”:“OC\Files\Node\LazyFolder”,“type”:“->”,“args”:},{“file”:“/home/******nc/lib/private/Files/Node/LazyFolder.php”,“line”:260,“function”:“__call”,“class”:“OC\Files\Node\LazyFolder”,“type”:“->”,“args”:[“getEtag”,]},{“file”:“/home/******nc/apps/dav/lib/Connector/Sabre/Node.php”,“line”:208,“function”:“getEtag”,“class”:“OC\Files\Node\LazyFolder”,“type”:“->”,“args”:},{“file”:“/home/******nc/apps/dav/lib/Connector/Sabre/FilesPlugin.php”,“line”:335,“function”:“getETag”,“class”:“OCA\DAV\Connector\Sabre\Node”,“type”:“->”,“args”:},{“file”:“/home/***nc/3rdparty/sabre/dav/lib/DAV/PropFind.php",“line”:95,“function”:“OCA\DAV\Connector\Sabre\{closure}”,“class”:“OCA\DAV\Connector\Sabre\FilesPlugin”,“type”:“->”,“args”:[" sensitive parameters replaced ***”]},{“file”:“/home/******nc/apps/dav/lib/Connector/Sabre/FilesPlugin.php”,“line”:334,“function”:“handle”,“class”:“Sabre\DAV\PropFind”,“type”:“->”,“args”:[“{DAV:}getetag”,[“Closure”]]},{“file”:“/home/******nc/3rdparty/sabre/event/lib/WildcardEmitterTrait.php”,“line”:89,“function”:“handleGetProperties”,“class”:“OCA\DAV\Connector\Sabre\FilesPlugin”,“type”:“->”,“args”:[[“Sabre\DAV\PropFind”],[“OCA\DAV\Files\FilesHome”]]},{“file”:“/home/******nc/3rdparty/sabre/dav/lib/DAV/Server.php”,“line”:1052,“function”:“emit”,“class”:“Sabre\DAV\Server”,“type”:“->”,“args”:[“propFind”,[[“Sabre\DAV\PropFind”],[“OCA\DAV\Files\FilesHome”]]]},{“file”:“/home/******nc/3rdparty/sabre/dav/lib/DAV/Server.php”,“line”:984,“function”:“getPropertiesByNode”,“class”:“Sabre\DAV\Server”,“type”:“->”,“args”:[[“Sabre\DAV\PropFind”],[“OCA\DAV\Files\FilesHome”]]},{“file”:“/home/******nc/3rdparty/sabre/dav/lib/DAV/Server.php”,“line”:1662,“function”:“getPropertiesIteratorForPath”,“class”:“Sabre\DAV\Server”,“type”:“->”,“args”:[“files/******73”,[“{DAV:}getetag”],0]},{“file”:“/home/******nc/3rdparty/sabre/dav/lib/DAV/Server.php”,“line”:1647,“function”:“writeMultiStatus”,“class”:“Sabre\DAV\Server”,“type”:“->”,“args”:[[“Sabre\Xml\Writer”,,“/nc/remote.php/dav/”,[“d”,“s”,“oc”,“nc”],],[“Generator”],false]},{“file”:“/home/******nc/3rdparty/sabre/dav/lib/DAV/CorePlugin.php”,“line”:346,“function”:“generateMultiStatus”,“class”:“Sabre\DAV\Server”,“type”:“->”,“args”:[[“Generator”],false]},{“file”:“/home/******nc/3rdparty/sabre/event/lib/WildcardEmitterTrait.php”,“line”:89,“function”:“httpPropFind”,“class”:“Sabre\DAV\CorePlugin”,“type”:“->”,“args”:[[“Sabre\HTTP\Request”],[“Sabre\HTTP\Response”]]},{“file”:“/home/******nc/3rdparty/sabre/dav/lib/DAV/Server.php”,“line”:472,“function”:“emit”,“class”:“Sabre\DAV\Server”,“type”:“->”,“args”:[“method:PROPFIND”,[[“Sabre\HTTP\Request”],[“Sabre\HTTP\Response”]]]},{“file”:“/home/******nc/3rdparty/sabre/dav/lib/DAV/Server.php”,“line”:253,“function”:“invokeMethod”,“class”:“Sabre\DAV\Server”,“type”:“->”,“args”:[[“Sabre\HTTP\Request”],[“Sabre\HTTP\Response”]]},{“file”:“/home/******nc/3rdparty/sabre/dav/lib/DAV/Server.php”,“line”:321,“function”:“start”,“class”:“Sabre\DAV\Server”,“type”:“->”,“args”:},{“file”:“/home/******nc/apps/dav/lib/Server.php”,“line”:373,“function”:“exec”,“class”:“Sabre\DAV\Server”,“type”:“->”,“args”:},{“file”:“/home/******nc/apps/dav/appinfo/v2/remote.php”,“line”:35,“function”:“exec”,“class”:“OCA\DAV\Server”,“type”:“->”,“args”:},{“file”:“/home/******nc/remote.php”,“line”:172,“args”:[“/home/******nc/apps/dav/appinfo/v2/remote.php”],“function”:“require_once”}],“File”:“/home/******nc/3rdparty/doctrine/dbal/src/Driver/PDO/Connection.php”,“Line”:135},“message”:“SQLSTATE[HY000]: General error: 1 cannot rollback - no transaction is active”,“exception”:{“errorInfo”:[“HY000”,1,“cannot rollback - no transaction is active”]},“CustomMessage”:“SQLSTATE[HY000]: General error: 1 cannot rollback - no transaction is active”}}