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
전문가
답변함 한 달 전
  • 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 :(

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠