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

Oracle connector missing logfile after oracle generated the log archive

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Major Major
    • under-triaging
    • 2.7.0.Final
    • oracle-connector
    • None
    • False
    • None
    • False

      Bug report

      After Oracle generated the log archive, the connector immediately encountered an exception, Error Message=ORA-01291: missing logfile.

      The problem is not necessary, it happens occasionally

      What Debezium connector do you use and what version?

      2.7.0.Final

      What is the connector configuration?

       

      {
        "name": "relation_cdc_server_1862083316347539458_1860884936367505409",
        "config": {
          "snapshot.locking.mode": "none",
          "connector.class": "io.debezium.connector.oracle.OracleConnector",
          "tasks.max": "1",
          "database.history.kafka.topic": "relation_cdc_server_1862083316347539458_history.DACOO",
          "transforms": "Reroute",
          "log.mining.transaction.retention.ms": "3600000",
          "schema.include.list": "DACOO",
          "log.mining.strategy": "online_catalog",
          "schema.history.internal.store.only.captured.databases.ddl": "true",
          "topic.prefix": "relation_cdc_server_1862083316347539458",
          "transforms.Reroute.topic.replacement": "relation_cdc_server_1862083316347539458_1860884936367505409_all",
          "decimal.handling.mode": "string",
          "schema.history.internal.kafka.topic": "relation_cdc_server_1862083316347539458_history.DACOO",
          "log.mining.archive.log.hours": "1",
          "snapshot.include.collection.list": "80a2239532ef4c2086085745f33f9493",
          "database.dbname": "ORCL",
          "transforms.Reroute.type": "io.debezium.transforms.ByLogicalTableRouter",
          "database.user": "test",
          "database.history.kafka.bootstrap.servers": "11.111.21.24:9092",
          "database.url": "jdbc:oracle:thin:@${hostname}:${port}:${dbname}",
          "database.server.name": "relation_cdc_server_1862083316347539458",
          "heartbeat.interval.ms": "300000",
          "schema.history.internal.kafka.bootstrap.servers": "11.116.213.24:9092",
          "event.processing.failure.handling.mode": "warn",
          "transforms.Reroute.topic.regex": "(.*)",
          "database.port": "1521",
          "column.exclude.list": "",
          "errors.max.retries": "5",
          "log.mining.query.filter.mode": "in",
          "database.connectionTimeZone": "Asia/Shanghai",
          "database.hostname": "10.106.251.194",
          "database.password": "test",
          "name": "relation_cdc_server_1862083316347539458_1860884936367505409",
          "table.include.list": "DACOO.local_test_1112_02",
          "snapshot.mode": "initial",
          "snowflakeId": "1862083316347539458"
        },
        "tasks": [
          {
            "connector": "relation_cdc_server_1862083316347539458_1860884936367505409",
            "task": 0
          }
        ],
        "type": "source"
      }json

       

      What is the captured database version and mode of deployment?

      oracle 11g

      What behavior do you expect?

      The connector is executing normally

      What behavior do you see?

      After Oracle generated the log archive, the connector immediately encountered an exception, Error Message=ORA-01291: missing logfile

      Do you have the connector logs, ideally from start till finish?

      full_log.txt

      error_stack_log.txt

      V_ARCHIVED_LOG_202411290958.csv

       

      How to reproduce the issue using our tutorial deployment?

      Oracle database generates log archives.

      Which use case/requirement will be addressed by the proposed feature?

      The collector collects tables that do not generate data for a long time

       

        1. connector_configuration.txt
          2 kB
        2. connector_log.txt
          477 kB
        3. connector_status-2025-01-06.txt
          4 kB
        4. error_stack_log.txt
          17 kB
        5. full_log.txt
          322 kB
        6. heartbeat_action_query_update_time_2025-01-07_10-59-14.png
          heartbeat_action_query_update_time_2025-01-07_10-59-14.png
          15 kB
        7. image-2024-11-29-10-13-47-554.png
          image-2024-11-29-10-13-47-554.png
          392 kB
        8. image-2024-12-26-15-28-43-960.png
          image-2024-12-26-15-28-43-960.png
          157 kB
        9. image-2024-12-26-15-45-26-024.png
          image-2024-12-26-15-45-26-024.png
          49 kB
        10. kafka_heartbeat_2025-01-07_10-58-18.png
          kafka_heartbeat_2025-01-07_10-58-18.png
          147 kB
        11. kafka_heartbeat_msg.png
          kafka_heartbeat_msg.png
          157 kB
        12. kafka_offset_2025-01-07_10-57-40.png
          kafka_offset_2025-01-07_10-57-40.png
          174 kB
        13. log_archive_time.png
          log_archive_time.png
          39 kB
        14. oracle_log_archive_2025-01-07_11-00-33.png
          oracle_log_archive_2025-01-07_11-00-33.png
          70 kB
        15. time_line_2025-01-07_11-08-00.png
          time_line_2025-01-07_11-08-00.png
          621 kB
        16. V_ARCHIVED_LOG_202411290958.csv
          10 kB

              Unassigned Unassigned
              diumin qiumin xiang
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated: