err: sync load stats timeout

[apollodafoni]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

CREATE TABLE t1 (a int, b int, c int);
CREATE TABLE t2 (a int, b int, c int);
CREATE TABLE t3 (a int, b int, c int);
CREATE TABLE t4 (a int, b int, c int);
INSERT INTO t1 VALUES (1,3,0), (2,2,0), (3,2,0);
INSERT INTO t2 VALUES (3,3,0), (4,2,0), (5,3,0);
INSERT INTO t3 VALUES (1,2,0), (2,2,0);
INSERT INTO t4 VALUES (3,2,0), (4,2,0);
CREATE INDEX idx_b ON t2(b);
SELECT t2.a,t2.b,t3.a,t3.b,t4.a,t4.b
  FROM (t3,t4)
       LEFT JOIN
       (t1,t2)
       ON t3.a=1 AND t3.b=t2.b AND t2.b=t4.b order by 1, 2, 3, 4, 5;

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

query success

3. What did you see instead (Required)

err: Warning 1105: sync load stats timeout

4. What is your TiDB version? (Required)

Release Version: v8.4.0-alpha-331-g1455d45729
Edition: Community
Git Commit Hash: 1455d45
Git Branch: HEAD
UTC Build Time: 2024-10-08 08:06:42
GoVersion: go1.23.0
Race Enabled: false
Check Table Before Drop: false
Store: tikv

[apollodafoni]

/assign @hawkingrei
/severity major