[document] OpenOffice files in DMS truncated to 0 bytes when directly edited

[Olivier Dony (Odoo)]

In latest stable there are cases where OpenOffice will somehow cause the file in the DMS to be truncated to 0 bytes.

How to reproduce:
 - have a database with document module installed
 - connect through FTP and push a test .odt file from OpenOffice (I used OOo 3.0)
 - the file is uploaded and file size is correct
 - using FTP integration in you Operating System, connect to the FTP directly from you file explorer (e.g. nautilus in Ubuntu)
 - now double-click on the file in the FTP directory directly to edit it
 - it opens in OOo correctly and you can edit it
 - try to modify and save the file directly in OOo => the save fails with an error message about access rights but at the same time the file is truncated to 0 bytes in the DMS
 - now if you open another FTP client on another machine you will see the file is 0 bytes now

Investigation:
Watching the server log it seems that OOo tries to test/use the write access using APPE instead of STOR, and perhaps there is something wrong in our support of APPE (we replace file instead of append?)
OOo also creates its lock files etc. but that seems to work fine I think, so it should not be related.

[Julian Robbins (joolsr)]

Yes, I noticed this too. It is quite a bad problem, as we're hoping to edit Open Office Documents that are stored and created as Quotes in the DMS

[Julian Robbins (joolsr)]

The lock files which are reqd, are ok, but do tend to look a bit odd on a MS file system, as files starting with a dot arent normally ignored as in Linux.

Is the main issue related to the OOo changes in file locking around version 3, and chaning back to its original behaviour at around version 3.10 OTOH

[Jay Vora (Serpent Consulting Services) (jayvora)]

Duplicate of itself.

[Julian Robbins (joolsr)]

If I'm going to implement OpenERP in my company we are banking on using the DMS with OpenOffice documents. So far this bug was set to be fixed in 5.0.8, then postponed for 5.0.9, then 5.0.10, and now onto 5.0.11

What is holding this work up? This bug was on the list of important bugs to get fixed in 5.0.9 as fa as i remember, so what happened ?

[Julian Robbins (joolsr)]

Why does this keep getting put back ? Firstly 5.0.8, now promised for 5.0.12 Will it ever get fixed ?

[Jay Vora (Serpent Consulting Services) (jayvora)]

Panos,

Can you please mention where has this been fixed?

Thanks.

[xrg (xrg)]

On Thursday 09 December 2010, you wrote:
> Panos,
>
> Can you please mention where has this been fixed?
>
It is in v6. The whole API of the nodes has been refactored, now allowing
attachments to open in "append" mode.

We even have a test at document_ftp/test/document_ftp_test2.yml:58