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

Check whether auto-commit DML operations trigger transaction buffer commits w/LogMiner

XMLWordPrintable

    • Icon: Task Task
    • Resolution: Duplicate
    • Icon: Major Major
    • None
    • None
    • oracle-connector
    • None
    • False
    • False
    • Undefined

      We need to check whether or not LogMiner requires explicit transaction boundaries.

      A user on Gitter reported using Dbeaver to perform an UPDATE on a table and that it would be auto-committed; however LogMiner never picked up the COMMIT redo log entry and therefore the transaction buffer was never flushed. When the user performed another UPDATE operation wrapping it within an explicit BEGIN/COMMIT wrapper, the DML operations were flushed and available in Kafka.

      The user was on Oracle 12, using default LogMiner configurations, no special strategies.

        1. _v_system_parameter__202011041451.csv
          63 kB
          Anton Kondratev
        2. image-2020-11-04-14-41-59-115.png
          43 kB
          Anton Kondratev
        3. nohup.out
          61 kB
          Anton Kondratev

              ccranfor@redhat.com Chris Cranford
              ccranfor@redhat.com Chris Cranford
              Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: