debezium-server-iceberg icon indicating copy to clipboard operation
debezium-server-iceberg copied to clipboard

Published 20 hours ago • verified publisher icon memiiso

long running transaction(s) are active. prompt in oracle db

Open GOVINDARAMTEKKAR97 opened this issue 1 year ago • 2 comments

Hi @ismailsimsek , I have successfully able to cdc through oracle database through debezium and iceberg and get parquet files into s3 bucket. But while updating the data in tables I am getting prompt that is

##Offset SCN 4724827 has not changed in 25 mining session iterations. This indicates long running transaction(s) are active. Commit SCNs {1=5263894}.

I am not getting this prompt resulting can not get data in when I update data in tables. Can you help me on this issue Regards, Govinda

image

GOVINDARAMTEKKAR97 avatar Jul 18 '24 11:07 GOVINDARAMTEKKAR97