TiFlash Unable to Delete Table

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: tiflash 一直无法删除表

| username: GreenGuan

After executing alter table xxx set tiflash replica 0;, the table has not disappeared from tiflash_replica. This table has 3 billion records. Should I just wait?

SELECT * FROM information_schema.tiflash_replica;
| TABLE_SCHEMA | TABLE_NAME | TABLE_ID | REPLICA_COUNT | LOCATION_LABELS | AVAILABLE | PROGRESS |
| xxx          | xxx        | 1260     | 2             |                 | 1         | 1        |
2
| username: yilong | Original post link

What are the actual results? Have they been changing constantly?

3
| username: Z六月星星 | Original post link

It should still be syncing.

4
| username: GreenGuan | Original post link

The actual operation results are:
alter table xxx set tiflash replica 0; no response, and the status did not change for a long time
alter table xxx add partition xxxx; successful
alter table xxx set tiflash replica 0; successful

5
| username: Min_Chen | Original post link

Hello, may I know the version? Are there any anomalies in the logs of tidb-server ddl owner and tiflash logs?

6
| username: GreenGuan | Original post link

v5.4.0
There are no exceptions with the DDL owner, otherwise the add partition operation would not succeed.
There are no exceptions in the TiFlash logs.

7
| username: Min_Chen | Original post link

Please check the steps here for troubleshooting, thanks for your effort.

8
| username: system | Original post link

This topic was automatically closed 1 minute after the last reply. No new replies are allowed.