We attempt to find the earliest timestamp in a timeseries collection.

In a usual collection, you can write an aggregation with ascending $sort, $limit 1 and $project steps without issues.

After migrating to a timeseries collection on Atlas, this fails with the following error:

PlanExecutor error during aggregation :: caused by :: BoundedSorter input is too out-of-order: with bound 2024-03-28T19:00:00.000+00:00, did not expect input 2024-03-28T18:04:01.000+00:00

Further observations:

• The sort (aggregation) step works when you invert the sorting (descending).