[Bug]: Error when updating to Nextcloud Version 29: InvalidArgumentException: Index name "share_id_index" for table "oc_onlyoffice_permissions" collides with the constraint on table "oc_federated_reshares".

[ChangnamOfMyr]

⚠️ 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

I tried to update Nextloud to Version 29 via the Nexcloud Webinterface.
Then i got the following Error and the Updater said i should report this Error to this Community.

Update vorbereiten
Log-Level auf "debug" gesetzt
Wartungsmodus eingeschaltet
Reparaturschritt: Repair MySQL collation
Reparaturinformation: All tables already have the correct collation -> nothing to do
Reparaturschritt: Copy data from accounts table when migrating from ownCloud
Reparaturschritt: Drop account terms table when migrating from ownCloud
Das Datenbankschema wird aktualisiert
Datenbank aktualisiert
InvalidArgumentException: Index name "share_id_index" for table "oc_onlyoffice_permissions" collides with the constraint on table "oc_federated_reshares".

I saw a sililar post regarding an upgrade to Version 28 and tried to drop the index from the Database tables but the tables "oc_onlyoffice_permissions" and "oc_federated_reshares" seem to be empty.

Steps to reproduce

1. Go to Nextcloud Settings
2. Click on Update

Expected behavior

Updating successfully to version 29.

Installation method

Community Web installer on a VPS or web space

Nextcloud Server version

28

Operating system

None

PHP engine version

PHP 8.1

Web server

None

Database engine version

MySQL

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?

None

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

This form wants me to add a Configuration report and a list of activated apps, but i dont know how to get them as i dont have admin permissions on the Webserver.
The nextcloud Log is a 300Mb txt file and i cant copy it to this form as the Website crashes when i try to paste it here.

[joshtrichards]

Since this is in the OnlyOffice integration app you'll need to report this to them:

https://github.com/ONLYOFFICE/onlyoffice-nextcloud

It does look like they attempted to replace this overlapping index name, but I see the old one in a prior migration so maybe there's more to it. I didn't look too closely:

https://github.com/search?q=repo%3AONLYOFFICE%2Fonlyoffice-nextcloud%20share_id_index&type=code

This form wants me to add a Configuration report and a list of activated apps, but i dont know how to get them as i dont have admin permissions on the Webserver.

That's fine since we likely won't need them now in this case, but for future reference the easiest way to do this is from the command line via the occ command. See https://docs.nextcloud.com.

[joshtrichards]

Meant to add: If you need help cleaning up the database tables/indexes post a query on the Community Help Forum

[AndreasB92]

Could you maybe tell me in very simple language what I have to do here? I get the same error when I want to update to version 29. I don't even want to use Only Office App and deleted it but I still get that error and can only load previous backups.

[joshtrichards]

@AndreasB92 If you need help cleaning up the database tables/indexes post a query on the Community Help Forum

[p4ck3t0]

Hi @AndreasB92 ,

I had the exact same issue. I resolved it by running the following query against my database (MariaDB):

DROP INDEX share_id_index ON oc_onlyoffice_permissions;

This query, drops the index for table oc_onlyoffice_permissions. Afterwards the migration runs through and everything seems to work.

Hope that helps.