same error message “An exception occurred while executing a query: SQLSTATE[42P07]: Duplicate table: 7 ERROR: relation “ts_session” already exists” with nextcloud aio docker version. nextcloud 27
UPDATE:
works fine with nextcloud 26
works fine if you upgrade to nextcloud 27 manually following
(I had to follow the procedure twice as mentioned in the post )
Checking https://yourhost/settings/admin/overview tells to run
php occ db:add-missing-indices
running it makes the error appear again
I had to delete the ts_session index manually in the oc_talk_sessions table
then “php occ db:add-missing-indices” completes without errors
I then recreated the index again manually changing the name to ts_session2 with :
CREATE UNIQUE INDEX “ts_session2” ON “public”.“oc_talk_sessions” USING btree (
“session_id” COLLATE “pg_catalog”.“default” “pg_catalog”.“text_ops” ASC NULLS LAST
);