topic Re: duplicate key value violates unique constraint "idx_alf_conturl_cr" in Alfresco Forum

duplicate key value violates unique constraint "idx_alf_conturl_cr"

anuj — Tue, 05 Jun 2018 15:22:19 GMT

Hi All,i am getting following error while uploading document to alfresco.2018-06-05 11:00:11 IST [alfresco alfresco] 10.10.104.43ERROR: duplicate key value violates unique constraint "idx_alf_conturl_cr"2018-06-05 11:00:11 IST [alfresco alfresco] 10.10.104.43DETAIL: Key (content_url_short, content_u

Re: duplicate key value violates unique constraint "idx_alf_conturl_cr"

angelborroy — Wed, 06 Jun 2018 13:46:06 GMT

This behaviour has been classified by Alfresco as "Not a bug".

Please, refer https://issues.alfresco.com/jira/browse/MNT-17060 for details.

Re: duplicate key value violates unique constraint "idx_alf_conturl_cr"

franck1436 — Fri, 14 Oct 2022 15:49:45 GMT

Hi @angelborroy

I got the same issue with duplicate key error on postgres DB, on each document creation.

As the ticket is not accessible anymore, how can we solved this problem?

 UTC [962] ERROR: duplicate key value violates unique constraint "idx_alf_conturl_cr"

CDT STATEMENT: insert into alf_content_url (id, content_url, content_url_short, content_url_crc, content_size, orphan_time) values ($1, $2, $3, $4, $5, $6)
select * from alf_content_url order by id desc;

We are running Alfresco on docker with this versions from docker-compose :

postgres:13.3
alfresco/alfresco-acs-nginx:3.1.1
alfresco/alfresco-content-repository-community:7.1.1
alfresco/alfresco-search-services:2.0.2.1
alfresco/alfresco-transform-core-aio:2.5.6
alfresco/alfresco-share:7.1.1
alfresco/alfresco-activemq:5.16.1

Thanks in advance

Cordially

Franck