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 Risposta
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
ESPERTO
con risposta un mese fa
  • 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 :(

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande