Mongo: Create index or look at query for findMeasurementsOfBoxesStream

[ubergesundheit]

InternalServerError: errmsg: "Sort operation used more than the maximum 33554432 bytes of RAM. Add an index, or specify a smaller limit."

Maybe { sensor_id: 1, createdAt: 1 }

[noerw]

Just for the sake of documentation / clarification:
This missing index causes extreme slowness (30kB/s) for calls to GET /boxes/data with parameters that select measurements older than the latest n uploaded measurements, where n is to be determined.

[mpfeil]

@ubergesundheit question to your initial comment:
the index { sensor_id: 1, createdAt: 1 } caused the error?

[ubergesundheit]

I think the index { sensor_id: 1, createdAt: 1 } could fix the slowness. Be aware though that adding an index without background: true will block the cluster.