Inconsistent memory tracking for SortExec #2155
Description
Describe the bug
We have moved requesters' memory tracking method in #1691:
Consumers push their memory usage to MemoryManager. No more pull from MemoryManagers for usage updates.
Inconsistency memory tracking exists for SortExec, which may cause incorrect total memory accounting in the memory manager, and potentially block other requesters' running when we have more than one requester.