duplicate key value violates unique constraint "idx_alf_conturl_cr"

[anuj]

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)

[angelborroy]

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

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

[franck1436]

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