Skip to content

Row count is not displayed in ADMIN SHOW DDL JOBS #59897

Description

@tangenta

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)

b500d9e

Metadata

Metadata

Assignees

Labels

affects-8.5This bug affects the 8.5.x(LTS) versions.component/ddlThis issue is related to DDL of TiDB.severity/majortype/bugThe issue is confirmed as a bug.

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions