Remove tables from DMS Replication Task table statistics

0

I have a replication task that reads from a RDS MariaDB database. After the replication task started, some tables were deleted in MariaDB. Even after stopping and resuming the task, I still see the deleted tables in tables statistics. The task is running correctly but the status is "Running with errors" due to two tables having been deleted in MariaDb but still appearing in the table statistics.

This is the original table mappings:

{
    "rules": [
        {
            "rule-type": "selection",
            "rule-id": "1",
            "rule-name": "all",
            "rule-action": "include",
            "object-locator": {
                "schema-name": "schema_name",
                "table-name": "%"
            },
            "parallel-load": null,
            "isAutoSegmentationChecked": false
        }
    ]
}

If I add the deleted tables to the tables mappings as ignored, the warning disappears. This is the updated table mappings:

{
    "rules": [
        {
            "rule-type": "selection",
            "rule-id": "1",
            "rule-name": "all",
            "rule-action": "include",
            "object-locator": {
                "schema-name": "schema_name",
                "table-name": "%"
            },
            "parallel-load": null,
            "isAutoSegmentationChecked": false
        },
        {
            "rule-type": "selection",
            "rule-id": "2",
            "rule-name": "2",
            "object-locator": {
                "schema-name": "schema_name",
                "table-name": "table_deleted_1"
            },
            "rule-action": "exclude"
        },
        {
            "rule-type": "selection",
            "rule-id": "3",
            "rule-name": "3",
            "object-locator": {
                "schema-name": "schema_name",
                "table-name": "table_deleted_2"
            },
            "rule-action": "exclude"
        }
    ]
}

With the above table mappings, the task status changes to "Load complete, replication ongoing" when running. However, the tables still appear in table statistics, and their state is still "Table error". If I revert the changes to the initial table mappings, the task would still run correctly, albeit showing a "Running with errors" status

I would like to remove the tables from table statistics without having to add them to the tables mappings, since they still appear but DMS seems to correctly ignore them. Is this possible?

1回答
1

To remove deleted tables from AWS DMS table statistics:

  1. Stop the replication task.
  2. Reset the table mappings to clear existing mappings.
  3. Re-add only existing tables to the mappings, excluding deleted ones.
  4. Resume the replication task.

This can be done through the AWS DMS console or AWS CLI commands.

profile picture
エキスパート
回答済み 1ヶ月前
  • Hey. Thanks for your answer. I've updated the question with additional information because I had already tried what you seem to suggest and it didn't work :(

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ