DMS - Task stopped with a generic errror message
I started a DMS task last week, and after letting it run for three days, I stopped adding new tables to the process, and when I tried to activate it again, I've received the message:
Last Error Task 'PMZPTPTYYJZGJQLBZCBYC7GSUQMWC2RICPEY6DA' was suspended due to 6 successive unexpected failures Stop Reason FATAL_ERROR Error Level FATAL
Looking at the logs, I found this error message 6x consecutively:
2022-02-14T13:57:39 [DATA_STRUCTURE ]E: SQLite general error. Code <19>, Message <UNIQUE constraint failed: events.identifier, events.eventType, events.detailMessage>.  (at_sqlite.c:525)
What does it mean? Which kind of actions should I take?
Thanks, D-Rao; in that case, we don't have any other error messages. The only one that I found out was the SQLite error message. And also, some tables are not loading correctly and didn't throw an error message either. Do you feel that someone can take a brief look at this?
As I said, try enabling detailed debug logging on some of the components and see if you start seeing any errors in the logs.
You can ignore the SQL Lite error.
And the FATAL error that you saw is pretty generic. Usually, there are more Errors or Warnings attached to it. I would say look for "E:" and "W:" and see if you find any other relevant errors or warnings.
If you did not see any other errors or warnings, and If the task is stopping right away even now, I would advise you to enable Detailed Debug on the components (target_apply, target_load, source_capture, source_unload) which are logged right above this message and see if DMS captures anything more. Please note that detailed debug dumps a lot of logs so make sure the Replication Instance has free storage.
AWS DMS performance degradation until stopped and resumedasked 2 months ago
DMS task stuck in starting for hoursasked a year ago
DMS to OpenSearch decimal problemasked 2 months ago
AWS DMS Issues | Duplicate Tables and SCT Conversion IssueAccepted Answerasked 2 years ago
Task stopped with No supported plugins found on source errorasked 3 years ago
DMS task is creating full row duplicates in targetasked 3 months ago
Fargate: how to stop task after finishingAccepted Answerasked 4 months ago
DMS - Task stopped with a generic errror messageasked 3 months ago
DMS Configuration For Migration From RDS To MariaDB On EC2asked 2 years ago
Force New Task Definition Revision to runasked a month ago