Duplicate key value violates unique constraint

cancel
Showing results for 
Search instead for 
Did you mean: 
hhovhann
Member II

Duplicate key value violates unique constraint

Hi guys ,

application start time in my postgres service I get an errors: 

ERROR: table "alf_content_url" does not exist
STATEMENT: DROP TABLE alf_content_url
ERROR: relation "act_ru_task" does not exist at character 22
STATEMENT: select min(id_) from ACT_RU_TASK
ERROR: duplicate key value violates unique constraint "idx_alf_conturl_cr"
DETAIL: Key (content_url_short, content_url_crc)=(d820d8de.bin, 2056292433) already exists.
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)
ERROR: duplicate key value violates unique constraint "idx_alf_conturl_cr"
DETAIL: Key (content_url_short, content_url_crc)=(4d42165b.bin, 4107801061) already exists.
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)
ERROR: duplicate key value violates unique constraint "idx_alf_conturl_cr"
DETAIL: Key (content_url_short, content_url_crc)=(dc51d8d9.bin, 1266258887) already exists.
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)
ERROR: duplicate key value violates unique constraint "idx_alf_conturl_cr"
DETAIL: Key (content_url_short, content_url_crc)=(e7c0e900.bin, 3279841233) already exists.
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)
ERROR: duplicate key value violates unique constraint "idx_alf_lockr_key"
DETAIL: Key (qname_ns_id, qname_localname)=(1, org.alfresco.repo.activities) already exists.
STATEMENT: insert into alf_lock_resource (id, version, qname_ns_id, qname_localname)
values ($1, $2, $3, $4)

any idea ?

regards Hayk Hovhannisyan

1 Reply
kintu_barot
Senior Member

Re: Duplicate key value violates unique constraint