[Bug]: Error migrating from Nextcloud 27 to 28

[csh4rp]

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

When I run the migration for nextcloud from 27 to 28 this error occurs:

Updating database schema

Exception: Database error when running migration 28000Date20231004103301 for app core An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 4025 CONSTRAINT oc_file_metadata.metadata failed for nextcloud.oc_file_metadata

This migrations script seems to be only creating a table, so I'm not sure what's it all about.

Steps to reproduce

1. Changed docker base image to 28-fpm
2. Restarted nextcloud

Expected behavior

Application should be updated

Installation method

None

Nextcloud Server version

28

Operating system

RHEL/CentOS

PHP engine version

None

Web server

Nginx

Database engine version

MariaDB

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

None

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

[csh4rp]

Turns out table file_metadata had stored location as text instead of json from one of mine devices and simply deleting this data that was not in JSON format fixed the issue. Still seems like a bug that either migration did not change it or that it was possible to put it there in the first place.