SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry * for key 'lock_key_index'

[alxdca]

Hi,

I have a fresh docker install running nextcloud 14.0.1 for a small buisiness. Only one windows client set up at this time. At first sync of large folders, I get sevel errors of this type:
Doctrine\DBAL\Exception\UniqueConstraintViolationException: An exception occurred while executing 'INSERT INTO oc_file_locks (key,lock,ttl) SELECT ?,?,? FROM oc_file_locksWHEREkey = ? HAVING COUNT(*) = 0' with params ["files\/0a4cc8c52d8bec8c9d7aa84e89ba24a4", 1, 1539274230, "files\/0a4cc8c52d8bec8c9d7aa84e89ba24a4"]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'files/0a4cc8c52d8bec8c9d7aa84e89ba24a4' for key 'lock_key_index'

During these files sync, I've seen the mysqld process regularly using 100% of a CPU core.

Expected behaviour

First sync of large folders with Windows 10 Client should sync all files without errors

Actual behaviour

Lot of Integrity constraint violation: 1062 Duplicate entry errors

Server configuration

Operating system: Openmediavault + Docker

Web server: Nginx official docker container

Database: Mariadb official docker container
Container created with command: --transaction-isolation=READ-COMMITTED
Binary log disabled

PHP version:

Nextcloud version: Nextcloud official docker container 14.0.1

Updated from an older Nextcloud/ownCloud or fresh install: Fresh install

Where did you install Nextcloud from: Docker image

[nextcloud-bot]

GitMate.io thinks possibly related issues are #1779 (Webdav Calendar Integrity constraint violation: 1062 Duplicate entry), #7389 (Integrity constraint violation: 19 NOT NULL constraint failed: oc_filecache.storage_mtime), #366 (PostgreSQL: violation of constraints), #7446 (Update 12.0.3 12.0.4 SQLSTATE[23000] :Integrity constraint violation), and #6343 (PostgreSQL : duplicate key value violates unique constraint error message).

[MorrisJobke]

Duplicate of #9305