topic Re: Alfresco 3.4.d/e with PostgreSQL and checkout problem in Alfresco Archive

Alfresco 3.4.d/e with PostgreSQL and checkout problem

dkt — Thu, 05 May 2011 15:03:30 GMT

Hello,I am using Alfresco 3.4.d with PostgreSQL 8.4, office 2007 sp2This is the steps to produce an error:1. upload a microsoft word doc file to user home2. allow version tracking in alfresco explorer3. checkout the file in alfresco explorer4. browse the space in CIFS/webdav, you could not replace t

Re: Alfresco 3.4.d/e with PostgreSQL and checkout problem

dkt — Thu, 05 May 2011 17:37:03 GMT

I have more findings, with now Alfresco 3.4.e.
To simplify the case:

Without webdav/office2007/versioning.
When I check out a normal document in alfresco explorer, there is error logged in the postgresql database.

May 6 01:33:02 server5 postgres[27527]: [2-1] ERROR: duplicate key value violates unique constraint "idx_alf_conturl_cr"
May 6 01:33:02 server5 postgres[27527]: [2-2] 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)

Re: Alfresco 3.4.d/e with PostgreSQL and checkout problem

dkt — Thu, 05 May 2011 18:34:06 GMT

I have tried to file a case in the jira, thanks.

http://issues.alfresco.com/jira/browse/ALF-8525