While I successfully managed to replicate the error in console, my aggregation worked fine in compass without any index other than default _id. Is the memory constraint for compass different than 100MB limit?
“errmsg”: “Sort exceeded memory limit of 104857600 bytes, but did not opt in to external sorting. Aborting operation. Pass allowDiskUse:true to opt in.”,