01-19-2018 02:28 PM
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
12-05-2018 12:46 AM
Please refer this thread duplicate key value violates unique constraint "idx_alf_conturl_cr"
Kintu
Explore our Alfresco products with the links below. Use labels to filter content by product module.