Hi, I’m trying to find why one of my aggregation is choking the server on 5.0.18 but is working fine on 5.0.13 (the issue was discovered after yesterday’s upgrade and fixed today by downgrading).
I’m using Java (reactive) driver, latest version. No changes were applied to indexes.
From my initial match, I’m doing 2 lookups using a $match and $eq with a variable. One of the lookup has a sub-lookup using the basic form (local/foreign field).
i.e. Collection A → Collection B and Collection C matching indexed fields of B and C from a variable of A. Then Collection C → D using the simple form on a indexed field of D.
It jumps from a sub-sec. query to choking one CPU for minutes.
My current guess is that the 2 $match using a variable from A are not using the indexes on B/C anymore…