topic Re: Permanent deletion of folder always times out -- how can it be avoided? in Nuxeo Forum

Permanent deletion of folder always times out -- how can it be avoided?

Steven_Huwig1 — Fri, 30 May 2014 00:34:07 GMT

Hello,

When I attempt to permanently delete (via the trash) a folder that has thousands of children, the deletion does not complete within the transaction timeout window. The system is waiting for the database to do some kind of work, but the only query running is DELETE FROM "hierarchy" WHERE "id" = $1.

Is there something I can do to avoid such a simple operation taking so long? I am running PostgreSQL 9.3 and have followed the tuning guidelines at http://doc.nuxeo.com/display/public/ADMINDOC/Configuring+PostgreSQL.

I prefer not to make the transaction timeout even longer than it already is, unless that is the only possible fix.

Re: Permanent deletion of folder always times out -- how can it be avoided?

Steven_Huwig1 — Thu, 05 Jun 2014 21:19:03 GMT

This is a consistent problem even on the live servers, with much faster disk than my laptop.

Re: Permanent deletion of folder always times out -- how can it be avoided?

Florent_Guillau — Fri, 06 Jun 2014 11:56:40 GMT

You may try to activate soft-delete. See Deleting Documents.

Re: Permanent deletion of folder always times out -- how can it be avoided?

Steven_Huwig1 — Fri, 06 Jun 2014 15:52:17 GMT

Thank you; this is what I needed. I got so focused on the administrative and database configuration documentation that I forgot to look in the content repository documentation.