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

      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.

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

              Created:
              Updated:
              Resolved: