[Bug]: Integrity constraint violation: 1062 Duplicate entry for key 'previews_file_uniq_idx'

[marcelklehr]

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

Since I upgraded to NC33, I noticed a lot of DB errors in the log like such:
An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '5573-1024-768-6-0--1' for key 'previews_file_uniq_idx'
I tried the occ reset commands but it didn't help.

Original issue: nextcloud/recognize#1458

Steps to reproduce

1. Install recognize
2. Let recognize index images using occ recognize:classify (likely the following line fails: https://github.com/nextcloud/recognize/blob/main/lib/Classifiers/Classifier.php#L323)

Expected behavior

Should just work.

Nextcloud Server version

33

Operating system

None

PHP engine version

None

Web server

None

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?

None

What user-backends are you using?

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

Configuration report

List of activated Apps

Nextcloud Signing status

Nextcloud Logs

Additional info

MariaDB 12.2.2

[SystemKeeper]

Hm, I thought that was fixed by #58271

[susnux]

cc @CarlSchwan @artonge