By using AWS re:Post, you agree to the Terms of Use

Questions tagged with AWS Database Migration Service

Sort by most recent

Browse through the questions and answers listed below or filter and sort to narrow down your results.

AWS DMS Migration task Source MongoDB and Target RDS Postgres

From few week all DMS tasks were successfully running, but now after full loads is completed and ongoing replication starts after few seconds this error comes: ``` Replication task has failed. Reason: Last Error Error reading the database log. Task error notification received from subtask 0, thread 0 [reptask/replicationtask.c:2880] [1020460] Error executing source loop; Stream component failed at subtask 0, component st_0_YF7WZ2RCSVJ5YSNKTAJBYWAUWT3T7WKW4CXV6BA; Stream component 'st_0_YF7WZ2RCSVJ5YSNKTAJBYWAUWT3T7WKW4CXV6BA' terminated [reptask/replicationtask.c:2888] [1020460] Stop Reason FATAL_ERROR Error Level FATAL. ``` Error in Cloud watch logs ``` [SOURCE_CAPTURE ]E: Expected to read 4 operations as part of transaction ' { "lsid": { "id": { "$binary": { "base64": "Gn5w6RP****sSG1w==", "subType": "04" } }, "uid": { "$binary": { "base64": "c5zE0wpKRhgcs6YLEzR******LVUqMjMseoKo=", "subType": "00" } } }, "txnNumber": { "$numberLong": "1" } } ' but read 2 [1020460] (change_streams_capture.c:894) 2022-07-10T12:31:24 [SOURCE_CAPTURE ]E: Expected to read 4 operations as part of transaction '{ "lsid" : { "id" : { "$binary" : { "base64": "Gn5w6DMW*****PsSG1w==", "subType" : "04" } }, "uid" : { "$binary" : { "base64": "c5zE0wpKRhgcs6****8Gynk4RLVUqMjMseoKo=", "subType" : "00" } } }, "txnNumber" : { "$numberLong" : "1"} }' but read 2 [1020460] (change_streams_capture.c:894) ``` ``` [SOURCE_CAPTURE ]I: Destroying mongoc client: '22360472577088' (mongodb_imp.c:1161 Destroying mongoc oplog client: '22360472609024' (mongodb_imp.c:1168) [SOURCE_CAPTURE ]E: Error executing source loop [1020460] (streamcomponent.c:1872) ```
0
answers
0
votes
56
views
asked 3 months ago

DMS giving error while replicating a table

I am doing refactoring from Oracle to postgres. All the tables data migrated from Oracle to postgressql. I am having issue with one table, below error found in postgres log files. Please let me know how to fix this error. 2022-07-05 20:02:07 UTC::@:[4551]:LOG: checkpoint starting: time 2022-07-05 20:02:07 UTC::@:[4551]:LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 1 removed, 0 recycled; write=0.106 s, sync=0.003 s, total=0.148 s; sync files=1, longest=0.003 s, average=0.003 s; distance=65536 kB, estimate=119791 kB 2022-07-05 20:07:07 UTC::@:[4551]:LOG: checkpoint starting: time 2022-07-05 20:07:07 UTC::@:[4551]:LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.106 s, sync=0.003 s, total=0.136 s; sync files=1, longest=0.003 s, average=0.003 s; distance=65536 kB, estimate=114365 kB 2022-07-05 20:09:00 UTC:10.0.0.192(44794):toype@bm:[29897]:ERROR: permission denied for table job_log 2022-07-05 20:09:00 UTC:10.0.0.192(44794):toype@bm:[29897]:CONTEXT: SQL statement "UPDATE central.job_log SET finished = --(CLOCK_TIMESTAMP() AT TIME ZONE COALESCE(CURRENT_SETTING('aws_oracle_ext.tz', TRUE), 'UTC'))::TIMESTAMP(0), current_timestamp, job_state = PJOBSTATUS, task_state = PTASKSTATUS WHERE schema = PSCHEMA AND job_id = PJOB_ID AND finished IS NULL" PL/pgSQL function central.job_logger(text,double precision,text,text,double precision,double precision) line 62 at SQL statement SQL statement "CALL central.job_logger(SESSION_USER, new.job_id, new.job_type, new.requester_id, new.job_state, new.task_state)" PL/pgSQL function "job_trig$job"() line 4 at CALL COPY job, line 1: "33984,"finsum","auto",4,"finsum",4,"<parameter name=\"user\" value=\"NSC\" /><parameter name=\"netId..." 2022-07-05 20:09:00 UTC:10.0.0.192(44794):toype@bm:[29897]:STATEMENT: COPY "toype"."job" FROM STDIN WITH DELIMITER ',' CSV NULL 'attNULL' ESCAPE '\' 2022-07-05 20:12:07 UTC::@:[4551]:LOG: checkpoint starting: time 2022-07-05 20:12:08 UTC::@:[4551]:LOG: checkpoint complete: wrote 12 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=1.212 s, sync=0.004 s, total=1.241 s; sync files=6, longest=0.004 s, average=0.001 s; distance=65558 kB, estimate=109485 kB
0
answers
0
votes
39
views
asked 3 months ago