The do_tables configuration is not effective when creating a changefeed in TiCDC

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

Original topic: ticdc创建changefeed时do_tables配置不生效

| username: TiDBer_I4TEFIr8

[TiDB Usage Environment] Test
[TiDB Version] v7.5.0
[Reproduction Path] What operations were performed to encounter the issue
[Encountered Issue: Phenomenon and Impact]

The configuration of do_tables is not effective when creating a task with the following parameters

{
  "changefeed_id": "03fea3dc-58e9-4e82-b21f-cbec6c46c6c4",
  "replica_config": {
    "bdr_mode": false,
    "case_sensitive": false,
    "check_gc_safe_point": false,
    "enable_old_value": false,
    "enable_sync_point": false,
    "filter": {
      "do_tables": [
        {
          "database_name": "test",
          "table_name": "tb_user"
        }
      ]
    },
    "force_replicate": false,
    "ignore_ineligible_table": false,
    "memory_quota": 0,
    "sync_point_interval": "10m",
    "sync_point_retention": "24h"
  },
  "sink_uri": "mysql://root:qq1230.@192.168.1.14:3306",
  "start_ts": 0,
  "target_ts": 0
}

The following image shows the job information retrieved after successful creation
It shows do_tables = null inside

| username: tidb菜鸟一只 | Original post link

Please send the TiCDC Changefeed configuration file.

| username: Daniel-W | Original post link

Take a look at the configuration file; it seems like there might be an issue with the configuration.

| username: zhang_2023 | Original post link

It seems there is an issue with the configuration file.

| username: 小于同学 | Original post link

The configuration is incorrect, right?

| username: TiDBer_I4TEFIr8 | Original post link

There is no changefeed configuration file created. If not specified, does this configuration use the default values?

Also, I have some questions about startts. If startts is set to 0 and cdc restarts, will cdc resend the previously sent data again?

| username: tidb菜鸟一只 | Original post link

It is recommended to use a configuration file. If startts is set to 0 and cdc restarts, cdc will resend the previously sent data again. No, startts is only used when you start cdc. Later, it will record the ts up to which your cdc task has been executed, and it will continue to execute according to your recorded progress.

| username: TiDBer_I4TEFIr8 | Original post link

Okay, thank you.

| username: WalterWj | Original post link

Use config to configure filter rules

| username: TiDBer_嘎嘣脆 | Original post link

This parameter is rarely changed, it’s usually set to the default configuration.

| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.