Interner Serverfehler - Auswertung log Datei

Guten Tag,

ich habe mein nextclod auf einem Debian 10 vServer am laufen, was bislang auch wunderbar funktionierte. Gestern ist mir beim Kopieren von Daten die Disk Quota an seine Grenze gestoßen. Demnach konnte ich nix mehr auf den Server hochladen. Das habe ich beseitigt, Speicherplatz ist wieder vorhanden. Leider kann ich mich seit dem nicht mehr am nextcloud anmelden. Ich erhalte einen internen Serverfehler. Folgende Hinweise gibt die Logdatei:

{“reqId”:“Q4HB08CVA9KqSOBhHrCT”,“level”:3,“time”:“2021-02-15T08:50:59+00:00”,“remoteAddr”:“77.78.190.236”,“user”:"–",“app”:“index”,“method”:“GET”,“url”:"/nextcloud/",“message”:{“Exception”:“Doctrine\DBAL\Exception\ConnectionException”,“Message”:“An exception occurred while executing ‘DELETE FROM oc_preferences WHERE userid = ? AND appid = ? AND configkey = ?’ with params [“admin”, “login_token”, “S6rbhkutGV4H5UXF8jCNcYbABBNFJa9O”]:\n\nSQLSTATE[42000]: Syntax error or access violation: 1142 DELETE command denied to user ‘user_db1’@‘localhost’ for table ‘oc_preferences’”,“Code”:0,“Trace”:[{“file”:"/home/users/user/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php",“line”:169,“function”:“convertException”,“class”:“Doctrine\DBAL\Driver\AbstractMySQLDriver”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php",“line”:145,“function”:“wrapException”,“class”:“Doctrine\DBAL\DBALException”,“type”:"::"},{“file”:"/home/users/user/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php",“line”:1063,“function”:“driverExceptionDuringQuery”,“class”:“Doctrine\DBAL\DBALException”,“type”:"::"},{“file”:"/home/users/user/www/nextcloud/lib/private/DB/Connection.php",“line”:214,“function”:“executeUpdate”,“class”:“Doctrine\DBAL\Connection”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/lib/private/AllConfig.php",“line”:355,“function”:“executeUpdate”,“class”:“OC\DB\Connection”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/lib/private/User/Session.php",“line”:858,“function”:“deleteUserValue”,“class”:“OC\AllConfig”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/lib/base.php",“line”:1057,“function”:“loginWithCookie”,“class”:“OC\User\Session”,“type”:"->",“args”:["*** sensitive parameters replaced "]},{“file”:"/home/users/user/www/nextcloud/lib/base.php",“line”:996,“function”:“handleLogin”,“class”:“OC”,“type”:"::"},{“file”:"/home/users/user/www/nextcloud/index.php",“line”:37,“function”:“handleRequest”,“class”:“OC”,“type”:"::"}],“File”:"/home/users/user/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php",“Line”:93,“Previous”:{“Exception”:“Doctrine\DBAL\Driver\PDOException”,“Message”:“SQLSTATE[42000]: Syntax error or access violation: 1142 DELETE command denied to user ‘user_db1’@‘localhost’ for table ‘oc_preferences’”,“Code”:“42000”,“Trace”:[{“file”:"/home/users/user/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php",“line”:1056,“function”:“execute”,“class”:“Doctrine\DBAL\Driver\PDOStatement”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/lib/private/DB/Connection.php",“line”:214,“function”:“executeUpdate”,“class”:“Doctrine\DBAL\Connection”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/lib/private/AllConfig.php",“line”:355,“function”:“executeUpdate”,“class”:“OC\DB\Connection”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/lib/private/User/Session.php",“line”:858,“function”:“deleteUserValue”,“class”:“OC\AllConfig”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/lib/base.php",“line”:1057,“function”:“loginWithCookie”,“class”:“OC\User\Session”,“type”:"->",“args”:[" sensitive parameters replaced "]},{“file”:"/home/users/user/www/nextcloud/lib/base.php",“line”:996,“function”:“handleLogin”,“class”:“OC”,“type”:"::"},{“file”:"/home/users/user/www/nextcloud/index.php",“line”:37,“function”:“handleRequest”,“class”:“OC”,“type”:"::"}],“File”:"/home/users/user/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php",“Line”:119,“Previous”:{“Exception”:“PDOException”,“Message”:“SQLSTATE[42000]: Syntax error or access violation: 1142 DELETE command denied to user ‘user_db1’@‘localhost’ for table ‘oc_preferences’”,“Code”:“42000”,“Trace”:[{“file”:"/home/users/user/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php",“line”:117,“function”:“execute”,“class”:“PDOStatement”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php",“line”:1056,“function”:“execute”,“class”:“Doctrine\DBAL\Driver\PDOStatement”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/lib/private/DB/Connection.php",“line”:214,“function”:“executeUpdate”,“class”:“Doctrine\DBAL\Connection”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/lib/private/AllConfig.php",“line”:355,“function”:“executeUpdate”,“class”:“OC\DB\Connection”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/lib/private/User/Session.php",“line”:858,“function”:“deleteUserValue”,“class”:“OC\AllConfig”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/lib/base.php",“line”:1057,“function”:“loginWithCookie”,“class”:“OC\User\Session”,“type”:"->",“args”:[" sensitive parameters replaced ***"]},{“file”:"/home/users/user/www/nextcloud/lib/base.php",“line”:996,“function”:“handleLogin”,“class”:“OC”,“type”:"::"},{“file”:"/home/users/user/www/nextcloud/index.php",“line”:37,“function”:“handleRequest”,“class”:“OC”,“type”:"::"}],“File”:"/home/users/user/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php",“Line”:117}},“CustomMessage”:"–"},“userAgent”:“Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.150 Safari/537.36 Edg/88.0.705.68”,“version”:“19.0.1.1”}

{“reqId”:“Q4HB08CVA9KqSOBhHrCT”,“level”:3,“time”:“2021-02-15T08:50:59+00:00”,“remoteAddr”:“77.78.190.236”,“user”:"–",“app”:“no app in context”,“method”:“GET”,“url”:"/nextcloud/",“message”:{“Exception”:“Symfony\Component\Routing\Exception\RouteNotFoundException”,“Message”:“Unable to generate a URL for the named route “calendar.view.index” as such route does not exist.”,“Code”:0,“Trace”:[{“file”:"/home/users/user/www/nextcloud/lib/private/Route/Router.php",“line”:338,“function”:“generate”,“class”:“Symfony\Component\Routing\Generator\UrlGenerator”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/lib/private/URLGenerator.php",“line”:83,“function”:“generate”,“class”:“OC\Route\Router”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/lib/private/NavigationManager.php",“line”:294,“function”:“linkToRoute”,“class”:“OC\URLGenerator”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/lib/private/NavigationManager.php",“line”:115,“function”:“init”,“class”:“OC\NavigationManager”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/apps/theming/lib/ThemingDefaults.php",“line”:183,“function”:“getAll”,“class”:“OC\NavigationManager”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/lib/private/legacy/OC_Defaults.php",“line”:263,“function”:“getShortFooter”,“class”:“OCA\Theming\ThemingDefaults”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/lib/public/Defaults.php",“line”:169,“function”:“getLongFooter”,“class”:“OC_Defaults”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/core/templates/layout.guest.php",“line”:55,“function”:“getLongFooter”,“class”:“OCP\Defaults”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/lib/private/Template/Base.php",“line”:178,“args”:["/home/users/user/www/nextcloud/core/templates/layout.guest.php"],“function”:“include”},{“file”:"/home/users/user/www/nextcloud/lib/private/Template/Base.php",“line”:150,“function”:“load”,“class”:“OC\Template\Base”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/lib/private/legacy/OC_Template.php",“line”:182,“function”:“fetchPage”,“class”:“OC\Template\Base”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/lib/private/legacy/OC_Template.php",“line”:213,“function”:“fetchPage”,“class”:“OC_Template”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/lib/private/Template/Base.php",“line”:132,“function”:“fetchPage”,“class”:“OC_Template”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/lib/private/legacy/OC_Template.php",“line”:334,“function”:“printPage”,“class”:“OC\Template\Base”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/index.php",“line”:63,“function”:“printExceptionErrorPage”,“class”:“OC_Template”,“type”:"::"}],“File”:"/home/users/user/www/nextcloud/3rdparty/symfony/routing/Generator/UrlGenerator.php",“Line”:143,“CustomMessage”:"–"},“userAgent”:“Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.150 Safari/537.36 Edg/88.0.705.68”,“version”:“19.0.1.1”}

{“reqId”:“Q4HB08CVA9KqSOBhHrCT”,“level”:3,“time”:“2021-02-15T08:50:59+00:00”,“remoteAddr”:“77.78.190.236”,“user”:"–",“app”:“no app in context”,“method”:“GET”,“url”:"/nextcloud/",“message”:{“Exception”:“Symfony\Component\Routing\Exception\RouteNotFoundException”,“Message”:“Unable to generate a URL for the named route “forms.page.index” as such route does not exist.”,“Code”:0,“Trace”:[{“file”:"/home/users/user/www/nextcloud/lib/private/Route/Router.php",“line”:338,“function”:“generate”,“class”:“Symfony\Component\Routing\Generator\UrlGenerator”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/lib/private/URLGenerator.php",“line”:83,“function”:“generate”,“class”:“OC\Route\Router”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/lib/private/NavigationManager.php",“line”:294,“function”:“linkToRoute”,“class”:“OC\URLGenerator”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/lib/private/NavigationManager.php",“line”:115,“function”:“init”,“class”:“OC\NavigationManager”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/apps/theming/lib/ThemingDefaults.php",“line”:183,“function”:“getAll”,“class”:“OC\NavigationManager”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/lib/private/legacy/OC_Defaults.php",“line”:263,“function”:“getShortFooter”,“class”:“OCA\Theming\ThemingDefaults”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/lib/public/Defaults.php",“line”:169,“function”:“getLongFooter”,“class”:“OC_Defaults”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/core/templates/layout.guest.php",“line”:55,“function”:“getLongFooter”,“class”:“OCP\Defaults”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/lib/private/Template/Base.php",“line”:178,“args”:["/home/users/user/www/nextcloud/core/templates/layout.guest.php"],“function”:“include”},{“file”:"/home/users/user/www/nextcloud/lib/private/Template/Base.php",“line”:150,“function”:“load”,“class”:“OC\Template\Base”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/lib/private/legacy/OC_Template.php",“line”:182,“function”:“fetchPage”,“class”:“OC\Template\Base”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/lib/private/legacy/OC_Template.php",“line”:213,“function”:“fetchPage”,“class”:“OC_Template”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/lib/private/Template/Base.php",“line”:132,“function”:“fetchPage”,“class”:“OC_Template”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/lib/private/legacy/OC_Template.php",“line”:334,“function”:“printPage”,“class”:“OC\Template\Base”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/index.php",“line”:63,“function”:“printExceptionErrorPage”,“class”:“OC_Template”,“type”:"::"}],“File”:"/home/users/user/www/nextcloud/3rdparty/symfony/routing/Generator/UrlGenerator.php",“Line”:143,“CustomMessage”:"–"},“userAgent”:“Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.150 Safari/537.36 Edg/88.0.705.68”,“version”:“19.0.1.1”}

{“reqId”:“Q4HB08CVA9KqSOBhHrCT”,“level”:3,“time”:“2021-02-15T08:50:59+00:00”,“remoteAddr”:“77.78.190.236”,“user”:"–",“app”:“no app in context”,“method”:“GET”,“url”:"/nextcloud/",“message”:{“Exception”:“Symfony\Component\Routing\Exception\RouteNotFoundException”,“Message”:“Unable to generate a URL for the named route “passwords.page.index” as such route does not exist.”,“Code”:0,“Trace”:[{“file”:"/home/users/user/www/nextcloud/lib/private/Route/Router.php",“line”:338,“function”:“generate”,“class”:“Symfony\Component\Routing\Generator\UrlGenerator”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/lib/private/URLGenerator.php",“line”:83,“function”:“generate”,“class”:“OC\Route\Router”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/lib/private/NavigationManager.php",“line”:294,“function”:“linkToRoute”,“class”:“OC\URLGenerator”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/lib/private/NavigationManager.php",“line”:115,“function”:“init”,“class”:“OC\NavigationManager”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/apps/theming/lib/ThemingDefaults.php",“line”:183,“function”:“getAll”,“class”:“OC\NavigationManager”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/lib/private/legacy/OC_Defaults.php",“line”:263,“function”:“getShortFooter”,“class”:“OCA\Theming\ThemingDefaults”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/lib/public/Defaults.php",“line”:169,“function”:“getLongFooter”,“class”:“OC_Defaults”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/core/templates/layout.guest.php",“line”:55,“function”:“getLongFooter”,“class”:“OCP\Defaults”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/lib/private/Template/Base.php",“line”:178,“args”:["/home/users/user/www/nextcloud/core/templates/layout.guest.php"],“function”:“include”},{“file”:"/home/users/user/www/nextcloud/lib/private/Template/Base.php",“line”:150,“function”:“load”,“class”:“OC\Template\Base”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/lib/private/legacy/OC_Template.php",“line”:182,“function”:“fetchPage”,“class”:“OC\Template\Base”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/lib/private/legacy/OC_Template.php",“line”:213,“function”:“fetchPage”,“class”:“OC_Template”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/lib/private/Template/Base.php",“line”:132,“function”:“fetchPage”,“class”:“OC_Template”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/lib/private/legacy/OC_Template.php",“line”:334,“function”:“printPage”,“class”:“OC\Template\Base”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/index.php",“line”:63,“function”:“printExceptionErrorPage”,“class”:“OC_Template”,“type”:"::"}],“File”:"/home/users/user/www/nextcloud/3rdparty/symfony/routing/Generator/UrlGenerator.php",“Line”:143,“CustomMessage”:"–"},“userAgent”:“Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.150 Safari/537.36 Edg/88.0.705.68”,“version”:“19.0.1.1”}

{“reqId”:“Q4HB08CVA9KqSOBhHrCT”,“level”:3,“time”:“2021-02-15T08:50:59+00:00”,“remoteAddr”:“77.78.190.236”,“user”:"–",“app”:“no app in context”,“method”:“GET”,“url”:"/nextcloud/",“message”:{“Exception”:“Symfony\Component\Routing\Exception\RouteNotFoundException”,“Message”:“Unable to generate a URL for the named route “photos.page.index” as such route does not exist.”,“Code”:0,“Trace”:[{“file”:"/home/users/user/www/nextcloud/lib/private/Route/Router.php",“line”:338,“function”:“generate”,“class”:“Symfony\Component\Routing\Generator\UrlGenerator”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/lib/private/URLGenerator.php",“line”:83,“function”:“generate”,“class”:“OC\Route\Router”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/lib/private/NavigationManager.php",“line”:294,“function”:“linkToRoute”,“class”:“OC\URLGenerator”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/lib/private/NavigationManager.php",“line”:115,“function”:“init”,“class”:“OC\NavigationManager”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/apps/theming/lib/ThemingDefaults.php",“line”:183,“function”:“getAll”,“class”:“OC\NavigationManager”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/lib/private/legacy/OC_Defaults.php",“line”:263,“function”:“getShortFooter”,“class”:“OCA\Theming\ThemingDefaults”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/lib/public/Defaults.php",“line”:169,“function”:“getLongFooter”,“class”:“OC_Defaults”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/core/templates/layout.guest.php",“line”:55,“function”:“getLongFooter”,“class”:“OCP\Defaults”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/lib/private/Template/Base.php",“line”:178,“args”:["/home/users/user/www/nextcloud/core/templates/layout.guest.php"],“function”:“include”},{“file”:"/home/users/user/www/nextcloud/lib/private/Template/Base.php",“line”:150,“function”:“load”,“class”:“OC\Template\Base”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/lib/private/legacy/OC_Template.php",“line”:182,“function”:“fetchPage”,“class”:“OC\Template\Base”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/lib/private/legacy/OC_Template.php",“line”:213,“function”:“fetchPage”,“class”:“OC_Template”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/lib/private/Template/Base.php",“line”:132,“function”:“fetchPage”,“class”:“OC_Template”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/lib/private/legacy/OC_Template.php",“line”:334,“function”:“printPage”,“class”:“OC\Template\Base”,“type”:"->"},{“file”:"/home/users/user/www/nextcloud/index.php",“line”:63,“function”:“printExceptionErrorPage”,“class”:“OC_Template”,“type”:"::"}],“File”:"/home/users/user/www/nextcloud/3rdparty/symfony/routing/Generator/UrlGenerator.php",“Line”:143,“CustomMessage”:"–"},“userAgent”:“Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.150 Safari/537.36 Edg/88.0.705.68”,“version”:“19.0.1.1”}

Soll es daran liegen?

DELETE command denied to user ‘user_db1’@‘localhost’ for table ‘oc_preferences’",“Code”:0,“Trace”:

Der Datenbankserver läuft, an den Nutzerrechten wurde nix geändert. Und ein volles Disk-Quota kann doch keine Folgewirkungen auf die Datenbank haben, oder?

Guido