Replicated DDL `alter table remove partitioning` ERROR

[tenfyzhong]

What did you do?

Replicating from active to passive tidb cluster.

Client is running following qyery on active cluster multiple times:

ALTER TABLE `derived_data` REMOVE PARTITIONING

What did you expect to see?

Replicated successfully.

What did you see instead?

Summary

But, changefeed failed with following error:

Error 1505 (HY000): Partition management on a not partitioned table is not possible

DDL jobs

Upstream:

mysql> admin show ddl jobs 600 where db_name = "user_context_fsg";
+--------+------------------+--------------+---------------------------------+--------------+-----------+----------+-----------+---------------------+---------------------+---------------------+-----------+
| JOB_ID | DB_NAME | TABLE_NAME | JOB_TYPE | SCHEMA_STATE | SCHEMA_ID | TABLE_ID | ROW_COUNT | CREATE_TIME | START_TIME | END_TIME | STATE |
+--------+------------------+--------------+---------------------------------+--------------+-----------+----------+-----------+---------------------+---------------------+---------------------+-----------+
| 486 | user_context_fsg | derived_data | alter table remove partitioning | none | 138 | 270 | 0 | 2025-10-27 18:31:18 | 2025-10-27 19:16:33 | 2025-10-27 19:16:33 | cancelled |
| 478 | user_context_fsg | derived_data | alter table remove partitioning | none | 138 | 270 | 1619929 | 2025-10-27 18:28:41 | 2025-10-27 18:43:36 | 2025-10-27 18:59:45 | synced |
| 392 | user_context_fsg | derived_data | create table | public | 138 | 270 | 0 | 2025-10-16 13:36:56 | 2025-10-16 13:36:56 | 2025-10-16 13:36:56 | synced |
| 324 | user_context_fsg | user_data | create table | public | 138 | 269 | 0 | 2025-10-16 13:36:56 | 2025-10-16 13:36:56 | 2025-10-16 13:36:56 | synced |
| 141 | user_context_fsg | | create schema | public | 138 | 0 | 0 | 2025-10-16 13:36:55 | 2025-10-16 13:36:55 | 2025-10-16 13:36:56 | synced |
+--------+------------------+--------------+---------------------------------+--------------+-----------+----------+-----------+---------------------+---------------------+---------------------+-----------+
5 rows in set (0.04 sec)

Downstream

mysql> admin show ddl jobs 600 where db_name = "user_context_fsg";
+--------+------------------+--------------+---------------------------------+--------------+-----------+----------+-----------+---------------------+---------------------+---------------------+-----------+
| JOB_ID | DB_NAME | TABLE_NAME | JOB_TYPE | SCHEMA_STATE | SCHEMA_ID | TABLE_ID | ROW_COUNT | CREATE_TIME | START_TIME | END_TIME | STATE |
+--------+------------------+--------------+---------------------------------+--------------+-----------+----------+-----------+---------------------+---------------------+---------------------+-----------+
| 445 | user_context_fsg | derived_data | alter table remove partitioning | none | 138 | 338 | 0 | 2025-10-27 19:01:51 | 2025-10-27 19:01:52 | 2025-10-27 19:01:52 | cancelled |
| 443 | user_context_fsg | derived_data | alter table remove partitioning | none | 138 | 338 | 1559881 | 2025-10-27 18:59:48 | 2025-10-27 18:59:49 | 2025-10-27 19:01:51 | synced |
| 392 | user_context_fsg | derived_data | create table | public | 138 | 338 | 0 | 2025-10-16 13:38:14 | 2025-10-16 13:38:14 | 2025-10-16 13:38:14 | synced |
| 216 | user_context_fsg | user_data | create table | public | 138 | 215 | 0 | 2025-10-16 13:37:32 | 2025-10-16 13:37:32 | 2025-10-16 13:37:32 | synced |
| 139 | user_context_fsg | | create schema | public | 138 | 0 | 0 | 2025-10-16 13:37:05 | 2025-10-16 13:37:05 | 2025-10-16 13:37:05 | synced |
+--------+------------------+--------------+---------------------------------+--------------+-----------+----------+-----------+---------------------+---------------------+---------------------+-----------+
5 rows in set (0.06 sec)

### Versions of the cluster

Upstream TiDB cluster version (execute `SELECT tidb_version();` in a MySQL client):

```console
(paste TiDB cluster version here)
v7.5.1

Upstream TiKV version (execute tikv-server --version):

(paste TiKV version here)

TiCDC version (execute cdc version):

(paste TiCDC version here)