Hi,
i got the overnight Update of my Nextcloud. Now i have the following duplicate Key Error:

Dec 14 10:59:07 => Applying oc_filecache_extended workaround
Dec 14 10:59:07 SELECT 9852
Dec 14 10:59:07 ALTER TABLE
Dec 14 10:59:07 ALTER TABLE
Dec 14 10:59:07 DROP TABLE
Dec 14 10:59:07 Check primary keys.
Dec 14 10:59:08 Adding primary key to the filecache_extended table, this can take some time...

Dec 14 10:59:09 In AbstractPostgreSQLDriver.php line 51:
Dec 14 10:59:09
Dec 14 10:59:09 An exception occurred while executing 'ALTER TABLE oc_filecache_extended AD
Dec 14 10:59:09 D PRIMARY KEY (fileid)':
Dec 14 10:59:09
Dec 14 10:59:09 SQLSTATE[23505]: Unique violation: 7 ERROR: could not create unique index
Dec 14 10:59:09 "oc_filecache_extended_pkey"
Dec 14 10:59:09 DETAIL: Key (fileid)=(35050) is duplicated.

Dec 14 10:59:09 In PDOConnection.php line 83:
Dec 14 10:59:09
Dec 14 10:59:09 SQLSTATE[23505]: Unique violation: 7 ERROR: could not create unique index
Dec 14 10:59:09 "oc_filecache_extended_pkey"
Dec 14 10:59:09 DETAIL: Key (fileid)=(35050) is duplicated.

Dec 14 10:59:09 In PDOConnection.php line 78:
Dec 14 10:59:09
Dec 14 10:59:09 SQLSTATE[23505]: Unique violation: 7 ERROR: could not create unique index
Dec 14 10:59:09 "oc_filecache_extended_pkey"
Dec 14 10:59:09 DETAIL: Key (fileid)=(35050) is duplicated.

Dec 14 10:59:09 db:add-missing-primary-keys

I just did the latest update manualy but i didn't fix anything. Also i tried restarting Cloudron with Nextcloud in Recovery Mode as mentioned in a different Issue.

Cloudron is now 6.0.1 and Nextcloud is now 20.0.3 with the Packaged version v4.8.3

Thanks ahead for your help

Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.

Cloudron Forum

smilebasti