[Bug]: Integrity constraint violation: 1062 Duplicate entry for key 'previews_file_uniq_idx' #58587
Description
⚠️ 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
- Install recognize
- 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