MongoDB | 2644820

Info

A query will fail with a QueryPlanKilled error when a moveCollection operation finishes while the query is being executed. Therefore, since the balancer is scheduling random moveCollection operations in the background, this has caused many tests to fail with this error and that's why we introduced a 6-second yielding delay on every query on the sharding_jscore_passthrough_with_balancer suite under SERVER-88184. However, this delay is not enough for the query_settings_size_limits.js test, which its find duration can be greater than 20 seconds. [j7:s1:prim] | 2024-04-13T08:22:25.926+00:00 I COMMAND 51803 [S] [conn86] "Slow query","attr":{"type":"command","isFromUserConnection":true,"ns":"test.query_settings_size_limits","collectionType":"normal","appName":"MongoDB Shell","queryShapeHash":"FEE5F2ED33041120538210A9B70AE43A7CE28E852912339F95A206BC3A085088","command":{"find":"query_settings_size_limits","filter":{"$or":[{"A0":1},{"A1":1},{"A2":1},{"A3":1},{"A4":1},{"A5":1},{"A6":1},{"A7":1},{"A8":1},{"A9":1},{"A10":1},{"A11":1},{"A12":1},{"A13":1},{"A14":1},{"A15":1},{"A16":1},{"A17":1},{"A18":1},{"A19":1},{"A20":1},{"A21":1},{"A22":1},...},{}]}},"planSummary":"COLLSCAN","planningTimeMicros":2501950,"numYields":1,"queryHash":"C04D8CE7","planCacheKey":"53194B60","queryFramework":"sbe","ok":0,"errMsg":"Executor error during find command: test.query_settings_size_limits :: caused by :: collection dropped. UUID 60bdf051-492d-4574-8ac8-e73e262d7140","errName":"QueryPlanKilled","errCode":175,"reslen":343,"locks":{"Global":{"acquireCount":{"r":2}},"Mutex":{"acquireCount":{"r":4}}},"readConcern":{"level":"local","provenance":"implicitDefault"},"storage":{},"cpuNanos":21731114212,"remote":"127.0.0.1:49602","protocol":"op_msg","workingMillis":22165,"durationMillis":22165,"queues":{"execution":{"admissions":3,"totalTimeQueuedMicros":0},"ingress":{"admissions":1,"totalTimeQueuedMicros":0}}},"truncated":{"command":{"truncated":{"filter":{"truncated":{"$or":{"truncated":{"936":{"truncated":{"A936":{"type":"double","size":8}},"omitted":1}},"omitted":29063}}}},"omitted":10}},"size":{"command":818629} Therefore, we will disable this test when the balancer is active.

Top User Comments

Steps to Reproduce