Ask Your Question
0

Oracle CDC: got rollback XXX - transaction discarded

asked 2020-05-28 01:15:12 -0500

Mgcobo gravatar image

Hi

I am testing Oracle CDC for a client. The pipeline works when I run for the first time. Afterwards it does not pick up any changes in the source but keeps running and the log shows the following:-

got rollback for 2.19.1880 - transaction discarded

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
1

answered 2020-05-29 16:37:56 -0500

That log entry is harmless as it means that a transaction on the database was rollbacked (e.g. not applied) and therefore it wasn't processed by the origin.

Are there any inserts/updates happening on the Oracle side on the affected tables @Mgcobo ?

edit flag offensive delete link more

Comments

Thank for the reply. Yes there inserts and updates happening in the database. I fixed the issue I had, I was 'force stop' the pipelines before rerunning. Seems like Streamsets keeps the DB connections running and creating multiple sessions to the DB

Mgcobo gravatar imageMgcobo ( 2020-06-01 23:10:01 -0500 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-05-28 01:15:12 -0500

Seen: 35 times

Last updated: May 29