Problem delete document after upgrade Nuxeo 5.4.2 to Nuxeo 5.5

Question

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 Answer

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