Join optimization: estimateMackertLohmanRandIO() expected numPagesColl > 0 with an empty table

XMLWordPrintableJSON

    • Type: Bug
    • Resolution: Duplicate
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Optimization
    • ALL
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      If the base table is empty:

      [js_test:join_costing_invariants] [jsTest] command failed: {
      [js_test:join_costing_invariants] [jsTest] 	"ok" : 0,
      [js_test:join_costing_invariants] [jsTest] 	"errmsg" : "estimateMackertLohmanRandIO() expected numPagesColl > 0",
      [js_test:join_costing_invariants] [jsTest] 	"code" : 11943801,
      [js_test:join_costing_invariants] [jsTest] 	"codeName" : "Location11943801"
      [js_test:join_costing_invariants] [jsTest] } with original command request: {
      [js_test:join_costing_invariants] [jsTest] 	"explain" : {
      [js_test:join_costing_invariants] [jsTest] 		"aggregate" : "no_rows",
      [js_test:join_costing_invariants] [jsTest] 		"pipeline" : [
      [js_test:join_costing_invariants] [jsTest] 			{
      [js_test:join_costing_invariants] [jsTest] 				"$lookup" : {
      [js_test:join_costing_invariants] [jsTest] 					"from" : "many_rows",
      [js_test:join_costing_invariants] [jsTest] 					"localField" : "i_idx",
      [js_test:join_costing_invariants] [jsTest] 					"foreignField" : "i_idx",
      [js_test:join_costing_invariants] [jsTest] 					"as" : "a"
      [js_test:join_costing_invariants] [jsTest] 				}
      [js_test:join_costing_invariants] [jsTest] 			},
      [js_test:join_costing_invariants] [jsTest] 			{
      [js_test:join_costing_invariants] [jsTest] 				"$unwind" : "$a"
      [js_test:join_costing_invariants] [jsTest] 			},
      [js_test:join_costing_invariants] [jsTest] 			{
      [js_test:join_costing_invariants] [jsTest] 				"$lookup" : {
      [js_test:join_costing_invariants] [jsTest] 					"from" : "many_rows",
      [js_test:join_costing_invariants] [jsTest] 					"localField" : "i_idx",
      [js_test:join_costing_invariants] [jsTest] 					"foreignField" : "i_idx",
      [js_test:join_costing_invariants] [jsTest] 					"as" : "b"
      [js_test:join_costing_invariants] [jsTest] 				}
      [j0] {"t":{"$date":"2026-02-20T08:37:19.691+00:00"},"s":"I",  "c":"NETWORK",  "id":22944,   "ctx":"conn9","msg":"Connection ended","attr":{"remote":"127.0.0.1:49290","isLoadBalanced":false,"isPriority":false,"uuid":{"uuid":{"$uuid":"d9ef145f-324d-48ab-b8da-411d2a5b37e5"}},"connectionId":9,"connectionCount":0}}
      [js_test:join_costing_invariants] [jsTest] 			},
      [js_test:join_costing_invariants] [jsTest] 			{
      [js_test:join_costing_invariants] [jsTest] 				"$unwind" : "$b"
      [js_test:join_costing_invariants] [jsTest] 			}
      [js_test:join_costing_invariants] [jsTest] 		],
      [js_test:join_costing_invariants] [jsTest] 		"cursor" : { }
      [js_test:join_costing_invariants] [jsTest] 	},
      [js_test:join_costing_invariants] [jsTest] 	"lsid" : {
      [js_test:join_costing_invariants] [jsTest] 		"id" : UUID("ef517b6a-e97b-4a49-bd84-08ab7322c6c4")
      [js_test:join_costing_invariants] [jsTest] 	},
      [js_test:join_costing_invariants] [jsTest] 	"$traceCtx" : {
      [js_test:join_costing_invariants] [jsTest] 		"traceparent" : "00-42ee0bb8b1804b338f3d972fac2ac2db-6a8f6b189ed04d05-01"
      [js_test:join_costing_invariants] [jsTest] 	}
      [js_test:join_costing_invariants] [jsTest] } on connection: connection to localhost:20000 with errmsg: estimateMackertLohmanRandIO() expected numPagesColl > 0
      

      Let me know if a complete test case is required.

            Assignee:
            Ben Shteinfeld
            Reporter:
            Philip Stoev
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: