AnsweredAssumed Answered

Alfresco 3.4.d/e with PostgreSQL and checkout problem

Question asked by dkt on May 5, 2011
Latest reply on May 5, 2011 by dkt
Hello,

I am using Alfresco 3.4.d with PostgreSQL 8.4, office 2007 sp2

This is the steps to produce an error:
1. upload a microsoft word doc file to user home
2. allow version tracking in alfresco explorer
3. checkout the file in alfresco explorer
4. browse the space in CIFS/webdav, you could not replace the file (original file, not the working copy)
5. however in webdav, double click the original file (locked one) and microsoft word open the file in webdav
make changes to the doc, save it
The save is successful, it override the webdav read only lock..

6. now the problems come:

there is some log in the postgresql server:
[2-2] STATEMENT:  DROP TABLE alf_content_url
[2-1] ERROR:  duplicate key value violates unique constraint "idx_alf_conturl_cr"
[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)
[3-1] ERROR:  duplicate key value violates unique constraint "idx_alf_conturl_cr"
[3-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)

when user delete the working copy in webdav/CIFS, the file could not be found in their deleted files UI
so some files become operand in the content store, there is no database reference to it

Any comment is welcomed, thank you.

Outcomes