Solved Nextcloud Key is duplicated still after Update

[smilebasti]

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

[girish]

@smilebasti Oh, this new package was intending to fix exactly this issue (https://git.cloudron.io/cloudron/nextcloud-app/-/commit/47070946b19792dab4347751f0d6384c677836a2). Can you please send me a mail to support@cloudron.io, so I can take a look at why it's failing? Thanks!

(cc @nebulon )

[nebulon]

Fixed now with the latest app package.