Hi,
I've been facing problems with Alfresco, it generates duplicate records like these: ERROR: duplicate key value violates unique constraint "authority";
I still don't know for sure what causes this. The events that are reported to me are when the user tries to copy a folder on one site, either to the same site or to a different site, receiving a message that it was not possible to copy the folder or add a group / user to a site.
I have doubts about the name created for the group, as an example, the user created it uses a nomenclature of @ employees $ Clients #Sectors (ex: @ kopers, $ Coca, # Production)
Below is a reproduction of the LOG:
### SQL: insert into alf_authority (id, version, authority, crc) values (?,?,?,?)
### Cause: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "authority"
Detail: Key (authority, crc) = (GROUP_ & 1ITAT001, 1002961159) already exists.
; SQL []; ERROR: duplicate key value violates unique constraint "authority"
Detail: Key (authority, crc) = (GROUP_ & 1ITAT001, 1002961159) already exists .; nested exception is org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "authority"
Detail: Key (authority, crc) = (GROUP_ & 1ITAT001, 1002961159) already exists.
I am not sure if this could be a bank failure, such as being corrupted or etc.
Can you help me fix this?
