Mail-App "Bereitstellung aufheben und Einstellungen löschen" ohne Funktion

Hallo,
seit Nextcloud 21 habe ich auf zwei Nextcloud-Instanzen (VM von hanssonit.se, und Univention Server 4.4) das Problem, dass ich in den “Einstellungen” - “Groupware” aus Versehen “Neue Einstellungen hinzufügen” angeklickt hatte.

Jetzt existieren diese Einstellungen, in der Nextcloud-Datenbank “oc_mail_accounts” sind jetzt 10 “tote” Einträge mit “domain.com”, teilweise auch von deaktivierten Benutzerkonten.

Klicke ich in den Nextcloud-Einstellungen auf den Schalter “Bereitstellung aufheben und Einstellungen löschen”, erhalte ich eine Fehlermeldung:
“Fehler beim Löschen und Aufheben der Bereitstellung von Konten für “*””

Auch inerhalb der Mail-App kann ich das Konto nicht löschen.

nextcloud.log:

{“reqId”:“DrFBMNTTYk7pUvqhnhOb”,“level”:3,“time”:“2021-09-15T14:35:12+00:00”,“remoteAddr”:“79.194.182.103”,“user”:“Administrator”,“app”:“index”,“method”:“DELETE”,“url”:"/nextcloud/apps/mail/api/settings/provisioning/1",“message”:{“Exception”:“Doctrine\DBAL\Exception\DriverException”,“Message”:“An exception occurred while executing a query: SQLSTATE[22P02]: Invalid text representation: 7 FEHLER: ung\u00fcltige Eingabesyntax f\u00fcr ganze Zahl: \u00bbt\u00ab”,“Code”:7,“Trace”:[{“file”:"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",“line”:1728,“function”:“convert”,“class”:“Doctrine\DBAL\Driver\API\PostgreSQL\ExceptionConverter”,“type”:"->"},{“file”:"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",“line”:1667,“function”:“handleDriverException”,“class”:“Doctrine\DBAL\Connection”,“type”:"->"},{“file”:"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",“line”:1146,“function”:“convertExceptionDuringQuery”,“class”:“Doctrine\DBAL\Connection”,“type”:"->"},{“file”:"/var/www/html/lib/private/DB/Connection.php",“line”:257,“function”:“executeStatement”,“class”:“Doctrine\DBAL\Connection”,“type”:"->"},{“file”:"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php",“line”:213,“function”:“executeStatement”,“class”:“OC\DB\Connection”,“type”:"->"},{“file”:"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php",“line”:287,“function”:“execute”,“class”:“Doctrine\DBAL\Query\QueryBuilder”,“type”:"->"},{“file”:"/var/www/html/apps/mail/lib/Db/MailAccountMapper.php",“line”:140,“function”:“execute”,“class”:“OC\DB\QueryBuilder\QueryBuilder”,“type”:"->"},{“file”:"/var/www/html/apps/mail/lib/Service/Provisioning/Manager.php",“line”:185,“function”:“deleteProvisionedAccounts”,“class”:“OCA\Mail\Db\MailAccountMapper”,“type”:"->"},{“file”:"/var/www/html/apps/mail/lib/Controller/SettingsController.php",“line”:85,“function”:“deprovision”,“class”:“OCA\Mail\Service\Provisioning\Manager”,“type”:"->"},{“file”:"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",“line”:218,“function”:“deprovision”,“class”:“OCA\Mail\Controller\SettingsController”,“type”:"->"},{“file”:"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",“line”:127,“function”:“executeController”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->"},{“file”:"/var/www/html/lib/private/AppFramework/App.php",“line”:157,“function”:“dispatch”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->"},{“file”:"/var/www/html/lib/private/Route/Router.php",“line”:302,“function”:“main”,“class”:“OC\AppFramework\App”,“type”:"::"},{“file”:"/var/www/html/lib/base.php",“line”:993,“function”:“match”,“class”:“OC\Route\Router”,“type”:"->"},{“file”:"/var/www/html/index.php",“line”:37,“function”:“handleRequest”,“class”:“OC”,“type”:"::"}],“File”:"/var/www/html/3rdparty/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php",“Line”:83,“Previous”:{“Exception”:“Doctrine\DBAL\Driver\PDO\Exception”,“Message”:“SQLSTATE[22P02]: Invalid text representation: 7 FEHLER: ung\u00fcltige Eingabesyntax f\u00fcr ganze Zahl: \u00bbt\u00ab”,“Code”:7,“Trace”:[{“file”:"/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",“line”:84,“function”:“new”,“class”:“Doctrine\DBAL\Driver\PDO\Exception”,“type”:"::"},{“file”:"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",“line”:1136,“function”:“execute”,“class”:“Doctrine\DBAL\Driver\PDO\Statement”,“type”:"->"},{“file”:"/var/www/html/lib/private/DB/Connection.php",“line”:257,“function”:“executeStatement”,“class”:“Doctrine\DBAL\Connection”,“type”:"->"},{“file”:"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php",“line”:213,“function”:“executeStatement”,“class”:“OC\DB\Connection”,“type”:"->"},{“file”:"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php",“line”:287,“function”:“execute”,“class”:“Doctrine\DBAL\Query\QueryBuilder”,“type”:"->"},{“file”:"/var/www/html/apps/mail/lib/Db/MailAccountMapper.php",“line”:140,“function”:“execute”,“class”:“OC\DB\QueryBuilder\QueryBuilder”,“type”:"->"},{“file”:"/var/www/html/apps/mail/lib/Service/Provisioning/Manager.php",“line”:185,“function”:“deleteProvisionedAccounts”,“class”:“OCA\Mail\Db\MailAccountMapper”,“type”:"->"},{“file”:"/var/www/html/apps/mail/lib/Controller/SettingsController.php",“line”:85,“function”:“deprovision”,“class”:“OCA\Mail\Service\Provisioning\Manager”,“type”:"->"},{“file”:"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",“line”:218,“function”:“deprovision”,“class”:“OCA\Mail\Controller\SettingsController”,“type”:"->"},{“file”:"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",“line”:127,“function”:“executeController”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->"},{“file”:"/var/www/html/lib/private/AppFramework/App.php",“line”:157,“function”:“dispatch”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->"},{“file”:"/var/www/html/lib/private/Route/Router.php",“line”:302,“function”:“main”,“class”:“OC\AppFramework\App”,“type”:"::"},{“file”:"/var/www/html/lib/base.php",“line”:993,“function”:“match”,“class”:“OC\Route\Router”,“type”:"->"},{“file”:"/var/www/html/index.php",“line”:37,“function”:“handleRequest”,“class”:“OC”,“type”:"::"}],“File”:"/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php",“Line”:26,“Previous”:{“Exception”:“PDOException”,“Message”:“SQLSTATE[22P02]: Invalid text representation: 7 FEHLER: ung\u00fcltige Eingabesyntax f\u00fcr ganze Zahl: \u00bbt\u00ab”,“Code”:“22P02”,“Trace”:[{“file”:"/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",“line”:82,“function”:“execute”,“class”:“PDOStatement”,“type”:"->"},{“file”:"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",“line”:1136,“function”:“execute”,“class”:“Doctrine\DBAL\Driver\PDO\Statement”,“type”:"->"},{“file”:"/var/www/html/lib/private/DB/Connection.php",“line”:257,“function”:“executeStatement”,“class”:“Doctrine\DBAL\Connection”,“type”:"->"},{“file”:"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php",“line”:213,“function”:“executeStatement”,“class”:“OC\DB\Connection”,“type”:"->"},{“file”:"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php",“line”:287,“function”:“execute”,“class”:“Doctrine\DBAL\Query\QueryBuilder”,“type”:"->"},{“file”:"/var/www/html/apps/mail/lib/Db/MailAccountMapper.php",“line”:140,“function”:“execute”,“class”:“OC\DB\QueryBuilder\QueryBuilder”,“type”:"->"},{“file”:"/var/www/html/apps/mail/lib/Service/Provisioning/Manager.php",“line”:185,“function”:“deleteProvisionedAccounts”,“class”:“OCA\Mail\Db\MailAccountMapper”,“type”:"->"},{“file”:"/var/www/html/apps/mail/lib/Controller/SettingsController.php",“line”:85,“function”:“deprovision”,“class”:“OCA\Mail\Service\Provisioning\Manager”,“type”:"->"},{“file”:"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",“line”:218,“function”:“deprovision”,“class”:“OCA\Mail\Controller\SettingsController”,“type”:"->"},{“file”:"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",“line”:127,“function”:“executeController”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->"},{“file”:"/var/www/html/lib/private/AppFramework/App.php",“line”:157,“function”:“dispatch”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->"},{“file”:"/var/www/html/lib/private/Route/Router.php",“line”:302,“function”:“main”,“class”:“OC\AppFramework\App”,“type”:"::"},{“file”:"/var/www/html/lib/base.php",“line”:993,“function”:“match”,“class”:“OC\Route\Router”,“type”:"->"},{“file”:"/var/www/html/index.php",“line”:37,“function”:“handleRequest”,“class”:“OC”,“type”:"::"}],“File”:"/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",“Line”:82}},“CustomMessage”:"–"},“userAgent”:“Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:92.0) Gecko/20100101 Firefox/92.0”,“version”:“21.0.4.1”}

Zum System:
Univention Corporate Server 4.4.8

  • Debian GNU/Linux 9 (stretch)
  • PostgreSQL 9.6.23
  • Apache 2.4
  • PHP 7.0.33-0+deb9u11
  • Nextcloud 21.0.4
  • 8GB RAM
    in einer Virtual Box-Umgebung unter Windows 10

Das zweite System mit dem gleichen Problem:

  • Ubuntu Server 20.04 LTS 64-bit
  • Apache 2.4
  • PostgreSQL 12
  • PHP-FPM 7.4
  • Linux Kernel: 5.4
  • Nextcloud 22.1.1
  • 16GB RAM
    vor-konfigurierte VM von hanssonit.se
    in einer VM-Ware ESXi-Umgebung

Meine Fragen:

  1. Wie kann ich die 10 “toten” Mailaccounts los werden - die nextcloud.log läuft permanent mit Fehlermeldungen voll.
  2. Kann ich alternativ die 10 “toten” Accounts mit “@domain.com” einfach in der Nextcloud-Datenbank “oc_mail_accounts” löschen?
  3. Wie kann ich die Bereitstellung aufheben? - Löschen der Mail-App ist genauso unwirksam, wie Löschpapier bei einem Feuer - bringt nix, denn nach einer Neuinstallation ist das Problem wieder da.

Push nach einer Woche

Noch einmal Push

Immer noch keiner eine Idee?

Solved in english Thread concerning the same topic