nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

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)

Find more posts tagged with

Alfresco Content Services

Comments

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