Circles update caused system error

Support intro

Sorry to hear you’re facing problems :slightly_frowning_face:

help.nextcloud.com is for home/non-enterprise users. If you’re running a business, paid support can be accessed via portal.nextcloud.com where we can ensure your business keeps running smoothly.

Nextcloud 17.0.3.1
Ubuntu Server
Apache
PHP 7.3.16

Some or all of the below information will be requested if it isn’t supplied; for fastest response please provide as much as you can :heart:

Nextcloud version (eg, 12.0.2):
Operating system and version (eg, Ubuntu 17.04):
Apache or nginx version (eg, Apache 2.4.25):
PHP version (eg, 7.1):

The issue you are facing:
I was updating APPs, at the update of Circles i got an error… the system reloaded and I can not access anymore vis WEB I/F. Error message below:

I youst want to know how to gain access again to uninstall the APP.

Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'CREATE TABLE oc_circles_links ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, status SMALLINT NOT NULL, circle_id VARCHAR(64) NOT NULL COLLATE BINARY, unique_id VARCHAR(64) DEFAULT NULL COLLATE BINARY, address VARCHAR(128) NOT NULL COLLATE BINARY, token VARCHAR(64) NOT NULL COLLATE BINARY, "key" VARCHAR(64) NOT NULL COLLATE BINARY, creation DATETIME DEFAULT NULL, PRIMARY KEY(id))': SQLSTATE[HY000]: General error: 1 table "oc_circles_links" has more than one primary key

and detailed message

Update vorbereiten

Log-Level auf "debug" gesetzt

Wartungsmodus eingeschaltet

Reparaturschritt: Repair MySQL collation

Reparaturinformation: Not a mysql database -> nothing to do

Reparaturschritt: Repair SQLite autoincrement

Reparaturschritt: Copy data from accounts table when migrating from ownCloud

Reparaturschritt: Drop account terms table when migrating from ownCloud

Das Datenbankschema wird aktualisiert

Datenbank aktualisiert

Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'CREATE TABLE oc_circles_links ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, status SMALLINT NOT NULL, circle_id VARCHAR(64) NOT NULL COLLATE BINARY, unique_id VARCHAR(64) DEFAULT NULL COLLATE BINARY, address VARCHAR(128) NOT NULL COLLATE BINARY, token VARCHAR(64) NOT NULL COLLATE BINARY, "key" VARCHAR(64) NOT NULL COLLATE BINARY, creation DATETIME DEFAULT NULL, PRIMARY KEY(id))': SQLSTATE[HY000]: General error: 1 table "oc_circles_links" has more than one primary key

Is this the first time you’ve seen this error? (Y/N): Y

The output of your Nextcloud log in Admin > Logging:

PASTE HERE

The output of your config.php file in /path/to/nextcloud (make sure you remove any identifiable information!):

<?php
$CONFIG = array (
  'instanceid' => '...',
  'passwordsalt' => '...',
  'secret' => '...',
  'trusted_domains' => 
  array (
    0 => 'thot05.cape-coop.org',
  ),
  'datadirectory' => '/var/www/...coop.org/data',
  'overwrite.cli.url' => 'http://thot05.cape-coop.org',
  'dbtype' => 'sqlite3',
  'version' => '17.0.3.1',
  'logtimezone' => 'UTC',
  'installed' => true,
  'maintenance' => false,
  'theme' => '',
  'loglevel' => 2,
  'updater.secret' => '...',
  'mail_from_address' => '...',
  'mail_smtpmode' => 'smtp',
  'mail_sendmailmode' => 'smtp',
  'mail_domain' => 'cape-coop.org',
  'mail_smtphost' => 'cape-coop.org',
  'mail_smtpport' => '...',
  'mail_smtpauth' => 1,
  'mail_smtpauthtype' => 'LOGIN',
);

The output of your Apache/nginx/system log in /var/log/____:

[Thu Apr 16 15:27:05.929631 2020] [authz_core:error] [pid 9436] [client 79.153.172.99:57172] AH01630: client denied by server configuration: /var/www/vhosts/web139.jasper.kundenserver42.de/httpdocs/thot05.cape-coop.org/config
[Thu Apr 16 15:52:01.286605 2020] [authz_core:error] [pid 21216] [client 79.153.172.99:40968] AH01630: client denied by server configuration: /var/www/vhosts/web139.jasper.kundenserver42.de/httpdocs/thot05.cape-coop.org/config
[Thu Apr 16 16:05:16.679295 2020] [authz_core:error] [pid 15017] [client 79.153.172.99:46198] AH01630: client denied by server configuration: /var/www/vhosts/web139.jasper.kundenserver42.de/httpdocs/thot05.cape-coop.org/config
[Thu Apr 16 16:23:29.644675 2020] [authz_core:error] [pid 6028] [client 79.153.172.99:54538] AH01630: client denied by server configuration: /var/www/vhosts/web139.jasper.kundenserver42.de/httpdocs/thot05.cape-coop.org/config
[Thu Apr 16 17:47:13.502105 2020] [authz_core:error] [pid 7282] [client 79.153.172.99:38090] AH01630: client denied by server configuration: /var/www/vhosts/web139.jasper.kundenserver42.de/httpdocs/thot05.cape-coop.org/config
[Thu Apr 16 17:49:32.140407 2020] [authz_core:error] [pid 20920] [client 79.153.172.99:39386] AH01630: client denied by server configuration: /var/www/vhosts/web139.jasper.kundenserver42.de/httpdocs/thot05.cape-coop.org/config
[Thu Apr 16 17:51:29.847275 2020] [authz_core:error] [pid 16936] [client 79.153.172.99:40450] AH01630: client denied by server configuration: /var/www/vhosts/web139.jasper.kundenserver42.de/httpdocs/thot05.cape-coop.org/config
[Thu Apr 16 18:01:09.622829 2020] [authz_core:error] [pid 23491] [client 79.153.172.99:44798] AH01630: client denied by server configuration: /var/www/vhosts/web139.jasper.kundenserver42.de/httpdocs/thot05.cape-coop.org/config
[Thu Apr 16 18:14:13.819365 2020] [authz_core:error] [pid 10436] [client 79.153.172.99:50398] AH01630: client denied by server configuration: /var/www/vhosts/web139.jasper.kundenserver42.de/httpdocs/thot05.cape-coop.org/config
[Thu Apr 16 18:17:04.568523 2020] [authz_core:error] [pid 17625] [client 79.153.172.99:51864] AH01630: client denied by server configuration: /var/www/vhosts/web139.jasper.kundenserver42.de/httpdocs/thot05.cape-coop.org/config
[Thu Apr 16 18:17:07.528609 2020] [authz_core:error] [pid 8273] [client 79.153.172.99:51896] AH01630: client denied by server configuration: /var/www/vhosts/web139.jasper.kundenserver42.de/httpdocs/thot05.cape-coop.org/config
[Thu Apr 16 18:19:03.332237 2020] [authz_core:error] [pid 10896] [client 79.153.172.99:53210] AH01630: client denied by server configuration: /var/www/vhosts/web139.jasper.kundenserver42.de/httpdocs/thot05.cape-coop.org/config
[Thu Apr 16 18:29:15.641253 2020] [authz_core:error] [pid 9436] [client 79.153.172.99:58294] AH01630: client denied by server configuration: /var/www/vhosts/web139.jasper.kundenserver42.de/httpdocs/thot05.cape-coop.org/config
[Thu Apr 16 20:50:23.356094 2020] [authz_core:error] [pid 21897] [client 79.153.172.99:42492] AH01630: client denied by server configuration: /var/www/vhosts/web139.jasper.kundenserver42.de/httpdocs/thot05.cape-coop.org/config
[Thu Apr 16 21:12:19.256352 2020] [authz_core:error] [pid 21897] [client 79.153.172.99:53304] AH01630: client denied by server configuration: /var/www/vhosts/web139.jasper.kundenserver42.de/httpdocs/thot05.cape-coop.org/config
[Thu Apr 16 21:25:25.695990 2020] [authz_core:error] [pid 5195] [client 79.153.172.99:59094] AH01630: client denied by server configuration: /var/www/vhosts/web139.jasper.kundenserver42.de/httpdocs/thot05.cape-coop.org/config
[Thu Apr 16 21:31:26.607890 2020] [authz_core:error] [pid 8273] [client 83.45.18.69:33310] AH01630: client denied by server configuration: /var/www/vhosts/web139.jasper.kundenserver42.de/httpdocs/thot05.cape-coop.org/config
[Thu Apr 16 21:34:15.280603 2020] [authz_core:error] [pid 6700] [client 83.45.18.69:34792] AH01630: client denied by server configuration: /var/www/vhosts/web139.jasper.kundenserver42.de/httpdocs/thot05.cape-coop.org/config
[Thu Apr 16 21:34:45.327826 2020] [authz_core:error] [pid 5195] [client 83.45.18.69:35168] AH01630: client denied by server configuration: /var/www/vhosts/web139.jasper.kundenserver42.de/httpdocs/thot05.cape-coop.org/config
[Fri Apr 17 00:25:17.994840 2020] [proxy_fcgi:error] [pid 15371] (32)Broken pipe: [client 5.62.41.149:46856] AH01075: Error dispatching request to : (passing brigade to output filters)
[Fri Apr 17 00:26:47.024929 2020] [proxy_fcgi:error] [pid 6022] (32)Broken pipe: [client 5.62.41.149:47826] AH01075: Error dispatching request to : (passing brigade to output filters)
[Fri Apr 17 11:18:01.654700 2020] [authz_core:error] [pid 28154] [client 83.45.18.69:34158] AH01630: client denied by server configuration: /var/www/vhosts/web139.jasper.kundenserver42.de/httpdocs/thot05.cape-coop.org/config
[Fri Apr 17 13:35:08.364496 2020] [proxy_fcgi:error] [pid 7629] (32)Broken pipe: [client 83.45.18.69:43540] AH01075: Error dispatching request to : (passing brigade to output filters)