AnsweredAssumed Answered

idx_alf_conturl_cr violated on document creation

Question asked by schorsch on Nov 14, 2017
Latest reply on Mar 12, 2018 by resplin

Hi!

On creation and even on deletion of any document I get a duplicate key exception in the postgresql-database:

### Error updating database. Cause: org.postgresql.util.PSQLException: ERROR: duplicate key violated

Unique-Constraint „idx_alf_conturl_cr“

 

2 calls (apparently retrying):

insert into alf_content_url (id, content_url, content_url_short, content_url_crc, content_size, orphan_time)
          values (?, ?, ?, ?, ?, ?)

 

The documents are being created without errors in Alfresco (due to retrying transaction helper) but where do these exceptions come from?

 

Thank you very much in advance for some hints.

Outcomes