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 Answer
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
EXPERT
answered 6 months ago
  • 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 :(

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions