duplicate key value violates unique constraint "idx_alf_conturl_cr"

cancel
Showing results for 
Search instead for 
Did you mean: 
anuj
Active Member

duplicate key value violates unique constraint "idx_alf_conturl_cr"

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_url_crc)=(206c376d.bin, 665953804) already exists.
2018-06-05 11:00:11 IST [alfresco alfresco] 10.10.104.43STATEMENT: 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)

2 Replies
angelborroy
Alfresco Employee

Re: duplicate key value violates unique constraint "idx_alf_conturl_cr"

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

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

Hyland Developer Evangelist
franck1436
Member II

Re: duplicate key value violates unique constraint "idx_alf_conturl_cr"

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