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

Fallback to restart_lsn if confirmed_flush_lsn is not found

XMLWordPrintable

    • Icon: Enhancement Enhancement
    • Resolution: Done
    • Icon: Major Major
    • 0.9.0.CR1
    • None
    • postgresql-connector
    • None

      At the moment, debezium fails against postgres 9.5 when it tries to fetch the state of the slot and it fails to find the "confirmed_flush_lsn" field in the pg_replication_slots tables which was added in PG 9.6. However, "restart_lsn" should work in most cases, put will produce extra duplicates.

      In PG 9.5, we can fall back to restart_lsn and we should still be correct, but with an additional duplication of records on restart against PG 9.5

            [DBZ-1081] Fallback to restart_lsn if confirmed_flush_lsn is not found

            Jiri Pechanec added a comment -

            Released

            Jiri Pechanec added a comment - Released

            Addison Higham (Inactive) added a comment -

            oh yep, correct

            Addison Higham (Inactive) added a comment - oh yep, correct

            Gunnar Morling added a comment -

            While I know dbz doesn't officially support 9.6

            It does support 9.6 FTR (it's one of the versions we test against). But I reckon you meant to say 9.5?

            Gunnar Morling added a comment - While I know dbz doesn't officially support 9.6 It does support 9.6 FTR (it's one of the versions we test against). But I reckon you meant to say 9.5?

            Addison Higham (Inactive) added a comment -

            While I know dbz doesn't officially support 9.6, this is the only issue I found when trying to run against PG 9.5 with wal2json. I am not sure if decoderbufs supports 9.6, but wal2json is still a good option for 9.5 support.

            This commit addresses this bug: https://github.com/debezium/debezium/pull/728

            Addison Higham (Inactive) added a comment - While I know dbz doesn't officially support 9.6, this is the only issue I found when trying to run against PG 9.5 with wal2json. I am not sure if decoderbufs supports 9.6, but wal2json is still a good option for 9.5 support. This commit addresses this bug: https://github.com/debezium/debezium/pull/728

              Unassigned Unassigned
              addisonj Addison Higham (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: