Problem delete document after upgrade Nuxeo 5.4.2 to Nuxeo 5.5

[Romain_FRANCE]

We can't delete document since we've upgrade nuxeo 5.4.2 to 5.5 (DataBase Oracle 10G). It doesn't work anymore with Nuxeo GUI, API Java or REST API.

It seems that this request (operated bi Nuxeo) is very slow :

SELECT "HIERARCHY"."ID", "HIERARCHY"."PARENTID", "HIERARCHY"."PRIMARYTYPE", "HIERARCHY"."ISPROPERTY", "PROXIES"."VERSIONABLEID", "PROXIES"."TARGETID" FROM "HIERARCHY" LEFT JOIN "PROXIES" ON "HIERARCHY"."ID" = "PROXIES"."ID" WHERE EXISTS(SELECT :"SYS_B_0" FROM ancestors WHERE hierarchy_id = "HIERARCHY"."ID" AND :1 MEMBER OF ancestors)

[ben_ · Accepted solution]

Hi,

Thanks for reporting this regression, I have created the following ticket to track this problem:

https://jira.nuxeo.com/browse/NXP-8668

You can use the ticket for reporting additional information.

Regards.

ben