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

Snapshot causes ORA-08181 exception

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 1.4.1.Final
    • 1.4.0.Final
    • oracle-connector
    • None

    Description

      DB:

      docker pull store/oracle/database-enterprise:12.2.0.1

      Install instant client with scripts
      https://github.com/debezium/debezium-examples/tree/master/tutorial:

      set DEBEZIUM_VERSION=1.4
docker-compose -f docker-compose-oracle.yaml up --build

      Add network:

      docker network connect --alias ODB tutorial_default ODB

      The following exception is caught in the logs:

      connect_1 | 2021-01-15 16:07:46,037 ERROR || Producer failure [io.debezium.pipeline.ErrorHandler]
connect_1 | java.lang.RuntimeException: java.sql.SQLException: ORA-08181: specified number is not a valid system change number
connect_1 | ORA-06512: at "SYS.SCN_TO_TIMESTAMP", line 1

connect_1 | ... 6 more
connect_1 | Caused by: Error : 8181, Position : 25, Sql = SELECT 1 FROM DUAL WHERE SCN_TO_TIMESTAMP(0) = SCN_TO_TIMESTAMP(3143773), OriginalSql = SELECT 1 FROM DUAL WHERE SCN_TO_TIMESTAMP(0) = SCN_TO_TIMESTAMP(3143773), Error Msg = ORA-08181: specified number is not a valid system change number
connect_1 | ORA-06512: at "SYS.SCN_TO_TIMESTAMP", line 1
connect_1 |
connect_1 | at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:1145)
connect_1 | ... 16 more

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: