You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@nifi.apache.org by GitBox <gi...@apache.org> on 2020/07/22 15:16:40 UTC
[GitHub] [nifi] readl1 edited a comment on pull request #2231: NIFI-4521 MS SQL CDC Processor
readl1 edited a comment on pull request #2231:
URL: https://github.com/apache/nifi/pull/2231#issuecomment-662501066
@patricker @mattyb149 Noticed another issues with the cdc processor. We are getting duplicate records pulled from the processor with the only difference being the extract time. The duplicates are only happening on some inserts (operation 2).
This is for a ~12 hour span
Sensitive column information removed.
{
"tran_begin_time" : "2020-07-22 09:07:29.313",
"tran_end_time" : "2020-07-22 09:07:29.313",
"trans_id" : 3857692447,
"start_lsn" : 750412361278947377,
"seqval" : 750412361278947372,
"operation" : 2,
"update_mask" : 1023,
"EXTRACT_TIME" : "2020-07-22 09:08:14.087"
}
{
"tran_begin_time" : "2020-07-22 09:07:29.313",
"tran_end_time" : "2020-07-22 09:07:29.313",
"trans_id" : 3857692447,
"start_lsn" : 750412361278947377,
"seqval" : 750412361278947372,
"operation" : 2,
"update_mask" : 1023,
"EXTRACT_TIME" : "2020-07-22 09:10:14.480"
}
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org