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