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

Transaction END marker in change event - Postgres connector

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Not a Bug
    • Icon: Major Major
    • None
    • 1.9.5.Final
    • postgresql-connector
    • None
    • False
    • Hide

      None

      Show
      None
    • False

      https://debezium.io/documentation/reference/stable/connectors/postgresql.html#postgresql-transaction-metadata

      Is there any way to identify transaction end marker from change data event itself instead of looking at transaction metadata events separately?

      As per the documentation in "Change data event enrichment" section, it mentions below sample:

      {
        "before": null,
        "after": {
          "pk": "2",
          "aa": "1"
        },
        "source": {
         ...
        },
        "op": "c",
        "ts_ms": "1580390884335",
        "transaction": {
          "id": "571:53195832",
          "total_order": "1",
          "data_collection_order": "1"
        }
      } 

      But, how do we identify if transaction is end looking at the change event like above ? Please suggest.

      Note: We do not want to use transaction metadata events for some other reason and hence the ask.

       

       

              Unassigned Unassigned
              suhanth94 Suhanth Boddu (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: