An example of this is a join that is spilling followed by a sort (or aggregate) that also spills.
These queries use memory very ineffective causing many of them to fail. The blocking
operator starts accumulating memory and over time, the streaming operator will have none left (it is streaming so therefore gives up memory as it processes). As streaming operator eventually has too little memory to repartition and fails.
We need coordination within an query.
Increase mem_limit for query or reduce query size (by processing only a subset of data at a time).