AWS DMS Fails with "Command failed to load data with exit error code 1"
1
vote
2
answers
10063
views
I am trying to Migrate my Postgresql RDS to Aurora Postgresql using DMS.
All my tasks are failing, and I am unable to understand what can be done to help the tasks progress.
The error from cloud watch logs is
...
2019-05-29T15:05:48 [TASK_MANAGER ]I: Start loading table 'public'.'my_ios_device_table' (Id = 642) by subtask 3. Start load timestamp 00058A081DCF0B40 (replicationtask_util.c:707)
2019-05-29T15:05:48 [SOURCE_UNLOAD ]I: Calculated batch used for UNLOAD size is 1000 rows per fetch. (postgres_endpoint_unload.c:178)
2019-05-29T15:05:48 [SOURCE_UNLOAD ]I: REPLICA IDENTITY information for table 'public'.'my_ios_device_table': Query status='Success' Type='DEFAULT' Description='Old values of the Primary Key columns (if any) will be captured.' (postgres_endpoint_unload.c:191)
2019-05-29T15:05:49 [SOURCE_UNLOAD ]I: Unload finished for table 'public'.'my_ios_device_table' (Id = 642). 1589 rows sent. (streamcomponent.c:3392)
2019-05-29T15:05:49 [TARGET_LOAD ]I: Load finished for table 'public'.'my_ios_device_table' (Id = 642). 1589 rows received. 0 rows skipped. Volume transfered 1558848. (streamcomponent.c:3663)
2019-05-29T15:05:50 [TARGET_LOAD ]E: Command failed to load data with exit error code 1, Command output: (csv_target.c:981)
2019-05-29T15:05:50 [TARGET_LOAD ]E: Failed to wait for previous run (csv_target.c:1578)
2019-05-29T15:05:50 [TARGET_LOAD ]E: Failed to load data from csv file. (odbc_endpoint_imp.c:5648)
2019-05-29T15:05:50 [TARGET_LOAD ]E: Handling End of table 'public'.'my_ios_device_table' loading failed by subtask 3 thread 1 (endpointshell.c:2416)
2019-05-29T15:05:50 [TASK_MANAGER ]W: Table 'public'.'my_ios_device_table' (subtask 3 thread 1) is suspended (replicationtask.c:2356)
...
I have checked the Postgresql Roles, Privileges and even disabled triggers using the
SET session_replication_role = 'replica';
.
I am at my wits end as to why this is failing and how to rectify it.
I am migrating from RDS Postgres 9.5.16 to Aurora Postgres 10.7
Any help is appreciated. Thanks

Asked by gvatreya
(201 rep)
May 29, 2019, 03:58 PM
Last activity: Mar 31, 2025, 08:08 AM
Last activity: Mar 31, 2025, 08:08 AM