Skip to content

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

Closed

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

Activity

  1. self-assigned this
    on Mar 4, 2025
  2. changed the title [-]Row count is not displayed in ADMIN SHOW[/-] [+]Row count is not displayed in `ADMIN SHOW DDL JOBS`[/+] on Mar 4, 2025
  3. added a commit that references this issue on Mar 4, 2025
    a6094f7
  4. added a commit that references this issue on May 6, 2025
    d19ae5d
  5. added a commit that references this issue on Jul 15, 2025
    1b753d2
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

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