Lock all roots when moving namespace
Lock on root ancestor instead of the results of the CTE