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

Log all rows from LogMiner session logs during LogMiner failures

XMLWordPrintable

      During a LogMiner failure, we currently only log entries from V$LOGMNR_LOGS that have a status value of 4, which represents log files not found. However in many cases, all that is logged is the following:

      ERROR [contact-customer-connector-oracle|task-0] Failed to start a LogMiner mining session with parameters:  (io.debezium.connector.oracle.logminer.LogMinerDatabaseStateWriter) [debezium-oracleconnector-contact-customer-connector-oracle-change-event-source-coordinator]
      ERROR [contact-customer-connector-oracle|task-0] 	SCN: [7795489421829-7795489441829], Required Start SCN: 0, Options: 2088, Status: 0 - N/A
      ERROR [contact-customer-connector-oracle|task-0] No logs were found with a status code of 4.
      

      We should prefer to log all information in this table rather than restricting it by status, in case there are corner cases where the session fails to start and reports non-4 statuses.

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

                Created:
                Updated:
                Resolved: