flaky test: explain_complex_stats

[0xPoe]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

https://do.pingcap.net/jenkins/blue/organizations/jenkins/pingcap%2Ftidb%2Fghpr_check2/detail/ghpr_check2/30139/pipeline/

time="2025-04-10T16:28:26+08:00" level=error msg="1 tests failed\n"

time="2025-04-10T16:28:26+08:00" level=error msg="run test [explain_complex_stats] err: sql:explain format = 'brief' select gad.id as gid,sdk.id as sid,gad.aid as aid,gad.cm as cm,sdk.dic as dic,sdk.ip as ip, sdk.t as t, gad.p1 as p1, gad.p2 as p2, gad.p3 as p3, gad.p4 as p4, gad.p5 as p5, gad.p6_md5 as p6, gad.p7_md5 as p7, gad.ext as ext, gad.t as gtime from st gad join (select id, aid, pt, dic, ip, t from dd where pt = 'android' and bm = 0 and t > 1478143908) sdk on  gad.aid = sdk.aid and gad.ip = sdk.ip and sdk.t > gad.t where gad.t > 1478143908 and gad.bm = 0 and gad.pt = 'android' group by gad.aid, sdk.dic limit 2500;: failed to run query \n\"explain format = 'brief' select gad.id as gid,sdk.id as sid,gad.aid as aid,gad.cm as cm,sdk.dic as dic,sdk.ip as ip, sdk.t as t, gad.p1 as p1, gad.p2 as p2, gad.p3 as p3, gad.p4 as p4, gad.p5 as p5, gad.p6_md5 as p6, gad.p7_md5 as p7, gad.ext as ext, gad.t as gtime from st gad join (select id, aid, pt, dic, ip, t from dd where pt = 'android' and bm = 0 and t > 1478143908) sdk on  gad.aid = sdk.aid and gad.ip = sdk.ip and sdk.t > gad.t where gad.t > 1478143908 and gad.bm = 0 and gad.pt = 'android' group by gad.aid, sdk.dic limit 2500;\" \n around line 136, \nwe need(3468):\nexplain format = 'brief' select gad.id as gid,sdk.id as sid,gad.aid as aid,gad.cm as cm,sdk.dic as dic,sdk.ip as ip, sdk.t as t, gad.p1 as p1, gad.p2 as p2, gad.p3 as p3, gad.p4 as p4, gad.p5 as p5, gad.p6_md5 as p6, gad.p7_md5 as p7, gad.ext as ext, gad.t as gtime from st gad join (select id, aid, pt, dic, ip, t from dd where pt = 'android' and bm = 0 and t > 1478143908) sdk on  gad.aid = sdk.aid and gad.ip = sdk.ip and sdk.t > gad.t where gad.t > 1478143908 and gad.bm = 0 and gad.pt = 'android' group by gad.aid, sdk.dic limit 2500;\nid\testRows\ttask\taccess object\toperator info\nProjection\t424.00\troot\t\texplain_complex_stats.st.id, explain_complex_stats.dd.id, explain_complex_stats.st.aid, explain_complex_stats.st.cm, explain_complex_stats.dd.dic, explain_complex_stats.dd.ip, explain_complex_stats.dd.t, explain_complex_stats.st.p1, explain_complex_stats.st.p2, explain_complex_stats.st.p3, explain_complex_stats.st.p4, explain_complex_stats.st.p5, explain_complex_stats.st.p6_md5, explain_complex_stats.st.p7_md5, explain_complex_stats.st.ext, explain_complex_stats.st.t\n└─Limit\t424.00\troot\t\toffset:0, count:2500\n  └─HashAgg\t424.00\troot\t\tgroup by:explain_complex_stats.dd.dic, explain_complex_stats.st.aid, funcs:firstrow(explain_complex_stats.st.id)->explain_complex_stats.st.id, funcs:firstrow(explain_complex_stats.st.aid)->explain_complex_stats.st.aid, funcs:firstrow(explain_complex_stats.st.cm)->explain_complex_stats.st.cm, funcs:firstrow(explain_complex_stats.st.p1)->explain_complex_stats.st.p1, funcs:firstrow(explain_complex_stats.st.p2)->explain_complex_stats.st.p2, funcs:firstrow(explain_complex_stats.st.p3)->explain_complex_stats.st.p3, funcs:firstrow(explain_complex_stats.st.p4)->explain_complex_stats.st.p4, funcs:firstrow(explain_complex_stats.st.p5)->explain_complex_stats.st.p5, funcs:firstrow(explain_complex_stats.st.p6_md5)->explain_complex_stats.st.p6_md5, funcs:firstrow(explain_complex_stats.st.p7_md5)->explain_complex_stats.st.p7_md5, funcs:firstrow(explain_complex_stats.st.ext)->explain_complex_stats.st.ext, funcs:firstrow(explain_complex_stats.st.t)->explain_complex_stats.st.t, funcs:firstrow(explain_complex_stats.dd.id)->explain_complex_stats.dd.id, funcs:firstrow(explain_complex_stats.dd.dic)->explain_complex_stats.dd.dic, funcs:firstrow(explain_complex_stats.dd.ip)->explain_complex_stats.dd.ip, funcs:firstrow(explain_complex_stats.dd.t)->explain_complex_stats.dd.t\n    └─HashJoin\t424.00\troot\t\tinner join, equal:[eq(explain_complex_stats.st.aid, explain_complex_stats.dd.aid) eq(explain_complex_stats.st.ip, explain_complex_stats.dd.ip)], other cond:gt(explain_complex_stats.dd.t, explain_complex_stats.st.t)\n      ├─TableReader(Build)\t424.00\troot\t\tdata:Selection\n      │ └─Selection\t424.00\tcop[tikv]\t\teq(explain_complex_stats.st.bm, 0), eq(explain_complex_stats.st.pt, \"android\"), gt(explain_complex_stats.st.t, 1478143908), not(isnull(explain_complex_stats.st.ip))\n      │   └─TableFullScan\t1999.00\tcop[tikv]\ttable:gad\tkeep order:false, stats:partial[t:missing]\n      └─TableReader(Probe)\t450.56\troot\t\tdata:Selection\n        └─Selection\t450.56\tcop[tikv]\t\teq(explain_complex_stats.dd.bm, 0), eq(explain_complex_stats.dd.pt, \"android\"), gt(explain_complex_stats.dd.t, 1478143908), not(isnull(explain_complex_stats.dd.ip)), not(isnull(explain_complex_stats.dd.t))\n          └─TableFullScan\t2000.00\tcop[tikv]\ttable:dd\tkeep order:false, stats:partial[ip:missing, t:missing]\nexplai\nbut got(3468):\nexplain format = 'brief' select gad.id as gid,sdk.id as sid,gad.aid as aid,gad.cm as cm,sdk.dic as dic,sdk.ip as ip, sdk.t as t, gad.p1 as p1, gad.p2 as p2, gad.p3 as p3, gad.p4 as p4, gad.p5 as p5, gad.p6_md5 as p6, gad.p7_md5 as p7, gad.ext as ext, gad.t as gtime from st gad join (select id, aid, pt, dic, ip, t from dd where pt = 'android' and bm = 0 and t > 1478143908) sdk on  gad.aid = sdk.aid and gad.ip = sdk.ip and sdk.t > gad.t where gad.t > 1478143908 and gad.bm = 0 and gad.pt = 'android' group by gad.aid, sdk.dic limit 2500;\nid\testRows\ttask\taccess object\toperator info\nProjection\t424.00\troot\t\texplain_complex_stats.st.id, explain_complex_stats.dd.id, explain_complex_stats.st.aid, explain_complex_stats.st.cm, explain_complex_stats.dd.dic, explain_complex_stats.dd.ip, explain_complex_stats.dd.t, explain_complex_stats.st.p1, explain_complex_stats.st.p2, explain_complex_stats.st.p3, explain_complex_stats.st.p4, explain_complex_stats.st.p5, explain_complex_stats.st.p6_md5, explain_complex_stats.st.p7_md5, explain_complex_stats.st.ext, explain_complex_stats.st.t\n└─Limit\t424.00\troot\t\toffset:0, count:2500\n  └─HashAgg\t424.00\troot\t\tgroup by:explain_complex_stats.dd.dic, explain_complex_stats.st.aid, funcs:firstrow(explain_complex_stats.st.id)->explain_complex_stats.st.id, funcs:firstrow(explain_complex_stats.st.aid)->explain_complex_stats.st.aid, funcs:firstrow(explain_complex_stats.st.cm)->explain_complex_stats.st.cm, funcs:firstrow(explain_complex_stats.st.p1)->explain_complex_stats.st.p1, funcs:firstrow(explain_complex_stats.st.p2)->explain_complex_stats.st.p2, funcs:firstrow(explain_complex_stats.st.p3)->explain_complex_stats.st.p3, funcs:firstrow(explain_complex_stats.st.p4)->explain_complex_stats.st.p4, funcs:firstrow(explain_complex_stats.st.p5)->explain_complex_stats.st.p5, funcs:firstrow(explain_complex_stats.st.p6_md5)->explain_complex_stats.st.p6_md5, funcs:firstrow(explain_complex_stats.st.p7_md5)->explain_complex_stats.st.p7_md5, funcs:firstrow(explain_complex_stats.st.ext)->explain_complex_stats.st.ext, funcs:firstrow(explain_complex_stats.st.t)->explain_complex_stats.st.t, funcs:firstrow(explain_complex_stats.dd.id)->explain_complex_stats.dd.id, funcs:firstrow(explain_complex_stats.dd.dic)->explain_complex_stats.dd.dic, funcs:firstrow(explain_complex_stats.dd.ip)->explain_complex_stats.dd.ip, funcs:firstrow(explain_complex_stats.dd.t)->explain_complex_stats.dd.t\n    └─HashJoin\t424.00\troot\t\tinner join, equal:[eq(explain_complex_stats.st.aid, explain_complex_stats.dd.aid) eq(explain_complex_stats.st.ip, explain_complex_stats.dd.ip)], other cond:gt(explain_complex_stats.dd.t, explain_complex_stats.st.t)\n      ├─TableReader(Build)\t424.00\troot\t\tdata:Selection\n      │ └─Selection\t424.00\tcop[tikv]\t\teq(explain_complex_stats.st.bm, 0), eq(explain_complex_stats.st.pt, \"android\"), gt(explain_complex_stats.st.t, 1478143908), not(isnull(explain_complex_stats.st.ip))\n      │   └─TableFullScan\t1999.00\tcop[tikv]\ttable:gad\tkeep order:false, stats:partial[t:unInitialized]\n      └─TableReader(Probe)\t450.56\troot\t\tdata:Selection\n        └─Selection\t450.56\tcop[tikv]\t\teq(explain_complex_stats.dd.bm, 0), eq(explain_complex_stats.dd.pt, \"android\"), gt(explain_complex_stats.dd.t, 1478143908), not(isnull(explain_complex_stats.dd.ip)), not(isnull(explain_complex_stats.dd.t))\n          └─TableFullScan\t2000.00\tcop[tikv]\ttable:dd\tkeep order:false, stats:partial[ip:missing, t:missing]\n\n"

2. What did you expect to see? (Required)

The stats status is missing.

3. What did you see instead (Required)

The stats status is unInitialized

4. What is your TiDB version? (Required)

master