can't rebuild index for Alfresco PostgreSQL tables alf_node_properties and alf_node

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

can't rebuild index for Alfresco PostgreSQL tables alf_node_properties and alf_node

Jump to solution

hi,

We are testing the speed of rebuilding index for alf_child_assoc, alf_node_properties and alf_node, but when we run:

 

REINDEX table alf_node_properties;

 

ERROR:

--
-- SQL Error [23505]: ERROR: could not create unique index "alf_node_properties_pkey"
Detail: Key (node_id, qname_id, list_index, locale_id)=(51060016, 28, -1, 1) is duplicated.

REINDEX table alf_node ;

 

ERROR:
SQL Error [23505]: ERROR: could not create unique index "alf_node_pkey"
Detail: Key (id)=(844) is duplicated.

usually the duplicated key can be very wrong in data modelling and any idea on how to get ride of it?

can it be the reason whenever an alfresco query require the IOIN of 2 x tables : alf_node_properties and alf_node, the query will be very slow ?

 

1 Solution

Accepted Solutions
dba100
Active Member II

Re: can't rebuild index for Alfresco PostgreSQL tables alf_node_properties and alf_node

Jump to solution

forget about that, it is the original data not good in condition! I do backup and restoer again and it is good.

View solution in original post

1 Reply
dba100
Active Member II

Re: can't rebuild index for Alfresco PostgreSQL tables alf_node_properties and alf_node

Jump to solution

forget about that, it is the original data not good in condition! I do backup and restoer again and it is good.