Aggregation Fails (hangs) Since Atlas upgrade from 6.0.6 to 6.0.8

Working with Data
,
2

Hi @Sean_Daniels - Welcome to the community.

It’s definitely interesting that this was able to be reproduced on two Atlas clusters running the same version. In saying so, I am wondering if you could provide the following details to help reproduce this on my end / troubleshoot the cause:

  1. The output of db.collection.explain("executionStats") from the 6.0.6 local instance
  2. The output of db.collection.explain("executionStats") from the 6.0.8 Atlas instance where you are experiencing the hanging aggregation
  3. The "size", "count" and "avgObjSize" from each of the above 2 environments. You can get these using collStats.
  4. Sample document(s) from each of the collections involved in the aggregation.
  1. How long did the aggregation generally run for in the 6.0.6 instance (when it was working).
  1. Have you tried running 6.0.8 locally on this same test environment you’ve mentioned in the above quote to see if that hangs as well? I understand you’ve noted it hangs on the 2 Atlas instances on 6.0.8 but this would just help round things down for troubleshooting purposes.

Please redact any sensitive and personal information before posting here

Look forward to hearing from you.

Regards,
Jason

1 Like