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 :(

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南