Nextcloud Key is duplicated still after Update
Solved
Nextcloud
-
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
-
@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 )