Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-3998

Fails to replicate all rows when "insert into table select * from" operation performed

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Major Major
    • None
    • 1.6.1.Final
    • oracle-connector
    • None
    • False
    • False
    • Hide

      Insert into table select * from table_like where rownum<101;

      Only 15 rows were replicated to Kafka table topic out of eligible 100 rows.

      Show
      Insert into table select * from table_like where rownum<101; Only 15 rows were replicated to Kafka table topic out of eligible 100 rows.

      We are using Debezium oracle connector 1.6.1 to capture changes from Oracle 12.2 to Kafka. The single insert statements are successfully replicated to Kafka topic but the bulk inserts like 100 rows (insert into table select * from another_table where rownum<101) are not completly replicated to Kafka. We see only 15 out of 100 rows in Kafka topic for such insert statements. 

        1. OUTBOUNDORDER_TMP1.csv
          69 kB
        2. Table_ddl.rtf
          4 kB

              ccranfor@redhat.com Chris Cranford
              dbzusr_sri Sri M (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: