topic Duplicate key value violates unique constraint in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/duplicate-key-value-violates-unique-constraint/m-p/50830#M19399 <HTML><HEAD></HEAD><BODY><P>Hi guys ,</P><P>application start time in my postgres service I get an errors:&nbsp;</P><P></P><P>ERROR: table "alf_content_url" does not exist<BR />STATEMENT: DROP TABLE alf_content_url<BR />ERROR: relation "act_ru_task" does not exist at character 22<BR />STATEMENT: select min(id_) from ACT_RU_TASK<BR />ERROR: duplicate key value violates unique constraint "idx_alf_conturl_cr"<BR />DETAIL: Key (content_url_short, content_url_crc)=(d820d8de.bin, 2056292433) already exists.<BR />STATEMENT: insert into alf_content_url (id, content_url, content_url_short, content_url_crc, content_size, orphan_time)<BR />values ($1, $2, $3, $4, $5, $6)<BR />ERROR: duplicate key value violates unique constraint "idx_alf_conturl_cr"<BR />DETAIL: Key (content_url_short, content_url_crc)=(4d42165b.bin, 4107801061) already exists.<BR />STATEMENT: insert into alf_content_url (id, content_url, content_url_short, content_url_crc, content_size, orphan_time)<BR />values ($1, $2, $3, $4, $5, $6)<BR />ERROR: duplicate key value violates unique constraint "idx_alf_conturl_cr"<BR />DETAIL: Key (content_url_short, content_url_crc)=(dc51d8d9.bin, 1266258887) already exists.<BR />STATEMENT: insert into alf_content_url (id, content_url, content_url_short, content_url_crc, content_size, orphan_time)<BR />values ($1, $2, $3, $4, $5, $6)<BR />ERROR: duplicate key value violates unique constraint "idx_alf_conturl_cr"<BR />DETAIL: Key (content_url_short, content_url_crc)=(e7c0e900.bin, 3279841233) already exists.<BR />STATEMENT: insert into alf_content_url (id, content_url, content_url_short, content_url_crc, content_size, orphan_time)<BR />&nbsp;values ($1, $2, $3, $4, $5, $6)<BR />ERROR: duplicate key value violates unique constraint "idx_alf_lockr_key"<BR />DETAIL: Key (qname_ns_id, qname_localname)=(1, org.alfresco.repo.activities) already exists.<BR />STATEMENT: insert into alf_lock_resource (id, version, qname_ns_id, qname_localname)<BR />values ($1, $2, $3, $4)</P><P></P><P>any idea ?</P><P></P><P>regards Hayk Hovhannisyan</P></BODY></HTML> Fri, 19 Jan 2018 19:28:49 GMT hhovhann 2018-01-19T19:28:49Z Duplicate key value violates unique constraint https://connect.hyland.com/t5/alfresco-forum/duplicate-key-value-violates-unique-constraint/m-p/50830#M19399 Hi guys ,application start time in my postgres service I get an errors:&nbsp;ERROR: table "alf_content_url" does not existSTATEMENT: DROP TABLE alf_content_urlERROR: relation "act_ru_task" does not exist at character 22STATEMENT: select min(id_) from ACT_RU_TASKERROR: duplicate key value violates unique Fri, 19 Jan 2018 19:28:49 GMT https://connect.hyland.com/t5/alfresco-forum/duplicate-key-value-violates-unique-constraint/m-p/50830#M19399 hhovhann 2018-01-19T19:28:49Z Re: Duplicate key value violates unique constraint https://connect.hyland.com/t5/alfresco-forum/duplicate-key-value-violates-unique-constraint/m-p/50831#M19400 <HTML><HEAD></HEAD><BODY><P>Please refer this thread&nbsp;<A href="https://migration33.stage.lithium.com/thread/237348">duplicate key value violates unique constraint "idx_alf_conturl_cr"</A>&nbsp;</P><P></P><P>Kintu</P><P><A href="http://www.contcentric.com" rel="nofollow noopener noreferrer">ContCentric</A></P></BODY></HTML> Wed, 05 Dec 2018 05:46:59 GMT https://connect.hyland.com/t5/alfresco-forum/duplicate-key-value-violates-unique-constraint/m-p/50831#M19400 kintu_barot 2018-12-05T05:46:59Z