[Bug]: Can't update to 28.0.0 since migration 28000Date20230906104802 fails

[jurgenhaas]

⚠️ This issue respects the following points: ⚠️

• This is a bug, not a question or a configuration/webserver/proxy issue.
• This issue is not already reported on Github OR Nextcloud Community Forum (I've searched it).
• Nextcloud Server is up to date. See Maintenance and Release Schedule for supported versions.
• I agree to follow Nextcloud's Code of Conduct.

Bug description

After update to 28.0.0 and while running occ upgrade, we get this output:

Setting log level to debug
Updating database schema
Exception: Database error when running migration 28000Date20230906104802 for app core
Index name "nid" for table "oc_social_3_stream" collides with the constraint on table "oc_social_3_cache_actor".
Update failed
Maintenance mode is kept active
Resetting log level

Steps to reproduce

1. Update to 28.0.0
2. Run occ upgrade

Expected behavior

The upgrade should succeed.

Installation method

Community Manual installation with Archive

Nextcloud Server version

28

Operating system

Debian/Ubuntu

PHP engine version

PHP 8.1

Web server

Apache (supported)

Database engine version

MariaDB

Is this bug present after an update or on a fresh install?

Upgraded to a MAJOR version (ex. 22 to 23)

Are you using the Nextcloud Server Encryption module?

Encryption is Disabled

What user-backends are you using?

• Default user-backend (database)
• LDAP/ Active Directory
• SSO - SAML
• Other

Configuration report

No response

List of activated Apps

No response

Nextcloud Signing status

No response

Nextcloud Logs

No response

Additional info

No response

[jurgenhaas]

As a workaround and since I had not used social a lot other than for testing, I disabled the social app - which didn't resolve the problem yet - so I also deleted all the related tables:

drop table oc_social_3_action;
drop table oc_social_3_actor;
drop table oc_social_3_cache_actor;
drop table oc_social_3_cache_doc;
drop table oc_social_3_client;
drop table oc_social_3_follow;
drop table oc_social_3_hashtag;
drop table oc_social_3_instance;
drop table oc_social_3_req_queue;
drop table oc_social_3_stream;
drop table oc_social_3_stream_act;
drop table oc_social_3_stream_dest;
drop table oc_social_3_stream_queue;
drop table oc_social_3_stream_tag;

Now I can at least finalize the update and get back to my nextcloud instance.

[joshtrichards]

That migration doesn't have anything to do with the social app though so that's.... weird. 🤔

server/core/Migrations/Version28000Date20230906104802.php

Line 38 in c734a18

class Version28000Date20230906104802 extends SimpleMigrationStep {

Also, those table names for the social app don't look quite right: I'd expect oc_social_action not oc_social_3_action.

https://github.com/nextcloud/social/blob/master/lib/Migration/Version1000Date20230217000002.php

It also looks like the latest Social version (0.6.1) in the appstore was released back in June so I'm skeptical it's really NC28 ready.

[joshtrichards]

Also similar to #41253 reported earlier with the beta.

And a similar report on the forum (which, in this case, was for these same tables):

https://help.nextcloud.com/t/update-error-after-upgrading-from-nc-27-to-28beta/173532/3

[joshtrichards]

Duplicate of #41253

Let's consolidate there.

[dewomser]

I have dropped all
tables with oc_social_3*
After that nextcloud installs and launch.
Funfact: At Social App no config and toots are lost . It seems working.