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

ORA-01086 savepoint never established raised when database history topic cannot be created or does not exist

    XMLWordPrintable

Details

    Description

      When deploying the connector where the Kafka broker does not automatically create the database history topic, the connector will fail with this error:

      io.debezium.DebeziumException: java.sql.SQLException: ORA-01086: savepoint 'DBZ_SCHEMA_SNAPSHOT' never established in this session or is invalid      
      
              at io.debezium.pipeline.source.AbstractSnapshotChangeEventSource.execute(AbstractSnapshotChangeEventSource.java:85)
              at io.debezium.pipeline.ChangeEventSourceCoordinator.doSnapshot(ChangeEventSourceCoordinator.java:155)
              at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:137)
              at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:109)
              at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
              at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
              at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
              at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
              at java.base/java.lang.Thread.run(Thread.java:829)
      Caused by: java.sql.SQLException: ORA-01086: savepoint 'DBZ_SCHEMA_SNAPSHOT' never established in this session or is invalid
      
              at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
              at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
              at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
              at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)
              at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)
              at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)
              at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213)
              at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37)
              at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:896)
              at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119)
              at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1661)
              at oracle.jdbc.driver.OracleStatement.executeLargeUpdate(OracleStatement.java:1626)
              at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1613)
              at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:282)
              at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:4002)
              at io.debezium.connector.oracle.OracleSnapshotChangeEventSource.releaseSchemaSnapshotLocks(OracleSnapshotChangeEventSource.java:123)
              at io.debezium.relational.RelationalSnapshotChangeEventSource.doExecute(RelationalSnapshotChangeEventSource.java:122)
              at io.debezium.pipeline.source.AbstractSnapshotChangeEventSource.execute(AbstractSnapshotChangeEventSource.java:76)
              ... 8 more
      Caused by: Error : 1086, Position : 0, Sql = ROLLBACK TO dbz_schema_snapshot, OriginalSql = ROLLBACK TO dbz_schema_snapshot, Error Msg = ORA-01086: savepoint 'DBZ_SCHEMA_SNAPSHOT' never established in this session or is invalid
      
              at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)
              ... 25 more
      

      If the history topic already exists or if Kafka can create the topic automatically without any problems, this error is avoided.

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: