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

Snapshot causes ORA-08181 exception

    XMLWordPrintable

    Details

      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

            Assignee:
            ccranfor Chris Cranford
            Reporter:
            ccranfor Chris Cranford
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: