Duplicate key value violates unique constraint

[doge]

Hello, on a new AIO install, using recommended installation on a new Ubuntu Proxmox VM, i have many erros in my database log.

How to purge enormous log ? (20mo unreadable log)
How to repair this ?

I tryed this :
sudo docker exec --user www-data -it nextcloud-aio-nextcloud php occ maintenance:repair

But still have errors and growing logs.

Best regards

Possiby related to my other message :
New install, errors in the logs - Features & apps / notes - Nextcloud community

[szaimen]

Hi, this sounds like Issues · nextcloud/server · GitHub

[doge]

A installed Memories and Recognize, to auto-tag wallpaper collection with automatic tags.
Probably Memories or Recognize in the tagging process, sends insert requests to the database every second and fills database log.

I tryed to delete content in the oc_systemtag_object_mapping_pkey table, and restart tagging process.
But errors continue to fill the database log.

ERROR: duplicate key value violates unique constraint “oc_systemtag_object_mapping_pkey”
DETAIL: Key (objecttype, objectid, systemtagid)=(files, 112177, 34) already exists.
CEST [1789] STATEMENT: INSERT INTO “oc_systemtag_object_mapping” (“objectid”, “objecttype”, “systemtagid”) VALUES($1, $2, $3)

Did not find a solution after serching Github and this forum yet.

Enabling recognize app gives PostgreSQL unique constraint violation errors

database log filled with errors every second