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

Oracle connector does not attempt restart when ORA-01089 exception is nested

    XMLWordPrintable

Details

    Description

      Bug report

      java.sql.SQLSyntaxErrorException: ORA-04088: error during execution of trigger 'SYS.LOGON_FAILURES_AUDIT'
      ORA-00604: error occurred at recursive SQL level 1
      ORA-01089: immediate shutdown or close in progress - no operations are permitted
      ORA-01089: immediate shutdown or close in progress - no operations are permitted

          at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:630)
          at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:564)
          at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1231)
          at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:772)
          at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:299)
          at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:512)
          at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:163)
          at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:1010)
          at oracle.jdbc.driver.OracleStatement.prepareDefineBufferAndExecute(OracleStatement.java:1271)
          at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1149)
          at oracle.jdbc.driver.OracleStatement.executeSQLSelect(OracleStatement.java:1661)
          at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1470)
          at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3761)
          at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3936)
          at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1102)
          at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.process(AbstractLogMinerEventProcessor.java:184)
          at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:210)
          at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:60)
          at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:174)
          at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:141)
          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)

      What Debezium connector do you use and what version?

      1.9.5

      What is the captured database version and mode of depoyment?

      Oracle 19c

       

      Attachments

        Activity

          People

            vjuranek@redhat.com Vojtech Juranek
            mohamed.icda Mohammed Mohammed (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: