cancel
Showing results for 
Search instead for 
Did you mean: 

Alfresco 3.4.d/e with PostgreSQL and checkout problem

dkt
Champ in-the-making
Champ in-the-making
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.
2 REPLIES 2

dkt
Champ in-the-making
Champ in-the-making
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)

dkt
Champ in-the-making
Champ in-the-making
I have tried to file a case in the jira, thanks.

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