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

Oracle XStream ORA-26876 - Attempting to set low watermark to a value less than current watermark

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Major Major
    • 2.5-backlog
    • 2.3.0.Final
    • oracle-connector
    • None
    • False
    • None
    • False

      Bug report

      Some tables in oracle database have no primary key, but have a unique index.  When Xstream is used to capture changed data, ORA-26876 exception will be reported after running for a period of time.
      The ALL_XSTREAM_OUTBOUND_PROGRESS information in the query database shows that the PROCESSED_LOW_POSITION field value of OUTBOUND SERVER is different from the lcr_position recorded by debezium in the file.  After converting lcr_position to the corresponding scn, it is found that the scn is smaller than the PROCESSED_LOW_SCN obtained from ALL_XSTREAM_OUTBOUND_PROGRESS.  After I replaced the lcr_position value recorded in the file with the queried PROCESSED_LOW_POSITION field value and restarted the debezium connector, the task returned to normal, but the problem continued to be reported after running for some time.  I wonder what might be the cause of this, or does the xstream approach not support capturing change data without a primary key table?

            Unassigned Unassigned
            butioy 柳青 杨
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated: