Repository navigation
Row count is not displayed in ADMIN SHOW DDL JOBS #59897
Copy link
Copy link
Closed
Labels
affects-8.5This bug affects the 8.5.x(LTS) versions.This bug affects the 8.5.x(LTS) versions.component/ddlThis issue is related to DDL of TiDB.This issue is related to DDL of TiDB.severity/majortype/bugThe issue is confirmed as a bug.The issue is confirmed as a bug.
Description
Bug Report
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
set @@global.tidb_ddl_enable_fast_reorg = 1;
set @@global.tidb_enable_dist_task = 1;
set @@global.tidb_cloud_storage_uri = "s3://globalsort?access-key=minioadmin&secret-access-key=minioadmin&endpoint=http://127.0.0.1:9000&force-path-style=true";
mysql> create table t(a int, b int);
Query OK, 0 rows affected (0.05 sec)
mysql> insert into t values (1, 1);
Query OK, 1 row affected (0.00 sec)
mysql> select * from t;
+------+------+
| a | b |
+------+------+
| 1 | 1 |
+------+------+
1 row in set (0.00 sec)
mysql> alter table t add index idx(a);
Query OK, 0 rows affected (2.93 sec)
mysql> admin show ddl jobs 1;
+--------+---------+------------+-----------+--------------+-----------+----------+-----------+----------------------------+----------------------------+----------------------------+--------+--------------------+
| JOB_ID | DB_NAME | TABLE_NAME | JOB_TYPE | SCHEMA_STATE | SCHEMA_ID | TABLE_ID | ROW_COUNT | CREATE_TIME | START_TIME | END_TIME | STATE | COMMENTS |
+--------+---------+------------+-----------+--------------+-----------+----------+-----------+----------------------------+----------------------------+----------------------------+--------+--------------------+
| 112 | test | t | add index | public | 2 | 110 | 0 | 2025-03-04 18:27:52.579000 | 2025-03-04 18:27:52.579000 | 2025-03-04 18:27:55.529000 | synced | ingest, DXF, cloud |
+--------+---------+------------+-----------+--------------+-----------+----------+-----------+----------------------------+----------------------------+----------------------------+--------+--------------------+
1 row in set (0.01 sec)
2. What did you expect to see? (Required)
row_count should not be zero.
3. What did you see instead (Required)
row_count is zero.
4. What is your TiDB version? (Required)
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
affects-8.5This bug affects the 8.5.x(LTS) versions.This bug affects the 8.5.x(LTS) versions.component/ddlThis issue is related to DDL of TiDB.This issue is related to DDL of TiDB.severity/majortype/bugThe issue is confirmed as a bug.The issue is confirmed as a bug.
Activity
[-]Row count is not displayed in ADMIN SHOW[/-][+]Row count is not displayed in `ADMIN SHOW DDL JOBS`[/+]ddl: fix job's row count for global sort (#59898)
ddl: fix job's row count for global sort (pingcap#59898)
ddl: fix job's row count for global sort (#59898) (#62070)