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

Oracle snapshot retry does not succeed when throwing an ORA-01466 exception

XMLWordPrintable

    • False
    • None
    • False

      As shown here testing on Oracle 19 XStream:

      2025-02-28 10:07:01,644 INFO   OutboxEventRouterIT||test  Starting test io.debezium.connector.oracle.OutboxEventRouterIT#shouldRespectJsonFormatAsString   [io.debezium.connector.oracle.OutboxEventRouterIT]
      2025-02-28 10:07:01,669 INFO   OutboxEventRouterIT||test  Database Version: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
      Version 19.3.0.0.0   [io.debezium.connector.oracle.OracleConnection]
      2025-02-28 10:07:01,669 INFO   OutboxEventRouterIT||test  Loading the custom source info struct maker plugin: io.debezium.connector.oracle.OracleSourceInfoStructMaker   [io.debezium.config.CommonConnectorConfig]
      2025-02-28 10:07:01,711 INFO   OutboxEventRouterIT||engine  Engine state has changed from 'CREATING' to 'INITIALIZING'   [io.debezium.embedded.async.AsyncEmbeddedEngine]
      2025-02-28 10:07:01,711 INFO   OutboxEventRouterIT||engine  Loading the custom source info struct maker plugin: io.debezium.connector.oracle.OracleSourceInfoStructMaker   [io.debezium.config.CommonConnectorConfig]
      2025-02-28 10:07:01,738 INFO   OutboxEventRouterIT||engine  Database Version: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
      Version 19.3.0.0.0   [io.debezium.connector.oracle.OracleConnection]
      2025-02-28 10:07:01,739 INFO   ||  Connection gracefully closed   [io.debezium.jdbc.JdbcConnection]
      2025-02-28 10:07:01,739 INFO   OutboxEventRouterIT||engine  Engine state has changed from 'INITIALIZING' to 'CREATING_TASKS'   [io.debezium.embedded.async.AsyncEmbeddedEngine]
      2025-02-28 10:07:01,740 INFO   OutboxEventRouterIT||engine  Engine state has changed from 'CREATING_TASKS' to 'STARTING_TASKS'   [io.debezium.embedded.async.AsyncEmbeddedEngine]
      2025-02-28 10:07:01,740 INFO   OutboxEventRouterIT||engine  Waiting max. for 90000 ms for individual source tasks to start.   [io.debezium.embedded.async.AsyncEmbeddedEngine]
      2025-02-28 10:07:01,740 INFO   ||  Starting OracleConnectorTask with configuration:
         connector.class = io.debezium.connector.oracle.OracleConnector
         record.processing.shutdown.timeout.ms = 1000
         include.schema.changes = false
         record.processing.order = ORDERED
         schema.history.internal.file.filename = /var/ARTIFACTS/work-oraclemocajh9c/debezium-testing/tmt/plans/oracle/oracle/discover/default-0/tests/target/data/file-schema-history-connect.txt
         snapshot.database.errors.max.retries = 3
         topic.prefix = server1
         offset.storage.file.filename = /var/ARTIFACTS/work-oraclemocajh9c/debezium-testing/tmt/plans/oracle/oracle/discover/default-0/tests/target/data/file-connector-offsets.txt
         record.processing.threads = 
         converters = boolean
         database.out.server.name = dbzxout
         errors.retry.delay.initial.ms = 300
         value.converter = org.apache.kafka.connect.json.JsonConverter
         key.converter = org.apache.kafka.connect.json.JsonConverter
         database.admin.hostname = 0.0.0.0
         database.dbname = ORCLCDB
         database.user = c##dbzuser
         offset.storage = org.apache.kafka.connect.storage.FileOffsetBackingStore
         database.connection.adapter = xstream
         database.pdb.name = ORCLPDB1
         boolean.type = io.debezium.connector.oracle.converters.NumberOneToBooleanConverter
         offset.flush.timeout.ms = 5000
         errors.retry.delay.max.ms = 10000
         database.port = 1521
         offset.flush.interval.ms = 0
         internal.task.management.timeout.ms = 90000
         schema.history.internal = io.debezium.storage.file.history.FileSchemaHistory
         record.processing.with.serial.consumer = false
         errors.max.retries = -1
         database.hostname = 0.0.0.0
         database.password = ********
         name = testing-connector
         table.include.list = DEBEZIUM\.OUTBOX
         snapshot.mode = initial
         [io.debezium.connector.common.BaseSourceTask]
      2025-02-28 10:07:01,740 INFO   ||  Loading the custom source info struct maker plugin: io.debezium.connector.oracle.OracleSourceInfoStructMaker   [io.debezium.config.CommonConnectorConfig]
      2025-02-28 10:07:01,740 INFO   ||  Loading the custom topic naming strategy plugin: io.debezium.schema.SchemaTopicNamingStrategy   [io.debezium.config.CommonConnectorConfig]
      2025-02-28 10:07:01,765 INFO   ||  Database Version: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
      Version 19.3.0.0.0   [io.debezium.connector.oracle.OracleConnection]
      2025-02-28 10:07:01,772 INFO   ||  Oracle MAX_STRING_SIZE is STANDARD   [io.debezium.connector.oracle.OracleConnection]
      2025-02-28 10:07:01,776 INFO   ||  No previous offsets found   [io.debezium.connector.common.BaseSourceTask]
      2025-02-28 10:07:01,801 INFO   ||  Database Version: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
      Version 19.3.0.0.0   [io.debezium.connector.oracle.OracleConnection]
      2025-02-28 10:07:01,804 INFO   ||  Connector started for the first time.   [io.debezium.connector.common.BaseSourceTask]
      2025-02-28 10:07:01,804 INFO   ||  No previous offset found   [io.debezium.connector.oracle.OracleConnectorTask]
      2025-02-28 10:07:01,804 INFO   ||  Requested thread factory for component OracleConnector, id = server1 named = SignalProcessor   [io.debezium.util.Threads]
      2025-02-28 10:07:01,805 INFO   ||  Requested thread factory for component OracleConnector, id = server1 named = change-event-source-coordinator   [io.debezium.util.Threads]
      2025-02-28 10:07:01,805 INFO   ||  Requested thread factory for component OracleConnector, id = server1 named = blocking-snapshot   [io.debezium.util.Threads]
      2025-02-28 10:07:01,805 INFO   ||  Creating thread debezium-oracleconnector-server1-change-event-source-coordinator   [io.debezium.util.Threads]
      2025-02-28 10:07:01,805 INFO   OutboxEventRouterIT||engine  All tasks have started successfully.   [io.debezium.embedded.async.AsyncEmbeddedEngine]
      2025-02-28 10:07:01,805 INFO   OutboxEventRouterIT||engine  Engine state has changed from 'STARTING_TASKS' to 'POLLING_TASKS'   [io.debezium.embedded.async.AsyncEmbeddedEngine]
      2025-02-28 10:07:01,805 INFO   OutboxEventRouterIT||engine  Using io.debezium.embedded.async.ParallelSmtConsumerProcessor processor   [io.debezium.embedded.async.AsyncEmbeddedEngine]
      2025-02-28 10:07:01,805 INFO   Oracle|server1|snapshot  Metrics registered   [io.debezium.pipeline.ChangeEventSourceCoordinator]
      2025-02-28 10:07:01,805 INFO   Oracle|server1|snapshot  Context created   [io.debezium.pipeline.ChangeEventSourceCoordinator]
      2025-02-28 10:07:01,805 INFO   Oracle|server1|snapshot  According to the connector configuration both schema and data will be snapshot.   [io.debezium.relational.RelationalSnapshotChangeEventSource]
      2025-02-28 10:07:01,807 INFO   Oracle|server1|snapshot  Snapshot step 1 - Preparing   [io.debezium.relational.RelationalSnapshotChangeEventSource]
      2025-02-28 10:07:01,807 INFO   Oracle|server1|snapshot  Snapshot step 2 - Determining captured tables   [io.debezium.relational.RelationalSnapshotChangeEventSource]
      2025-02-28 10:07:01,973 INFO   Oracle|server1|snapshot  Adding table ORCLPDB1.DEBEZIUM.OUTBOX to the list of capture schema tables   [io.debezium.relational.RelationalSnapshotChangeEventSource]
      2025-02-28 10:07:01,973 INFO   Oracle|server1|snapshot  Created connection pool with 1 threads   [io.debezium.relational.RelationalSnapshotChangeEventSource]
      2025-02-28 10:07:01,973 INFO   Oracle|server1|snapshot  Snapshot step 3 - Locking captured tables [ORCLPDB1.DEBEZIUM.OUTBOX]   [io.debezium.relational.RelationalSnapshotChangeEventSource]
      2025-02-28 10:07:01,974 INFO   Oracle|server1|snapshot  Snapshot step 4 - Determining snapshot offset   [io.debezium.relational.RelationalSnapshotChangeEventSource]
      2025-02-28 10:07:02,004 INFO   Oracle|server1|snapshot  	Current SCN resolved as 3532351   [io.debezium.connector.oracle.xstream.XStreamAdapter]
      2025-02-28 10:07:02,004 INFO   Oracle|server1|snapshot  Snapshot step 5 - Reading structure of captured tables   [io.debezium.relational.RelationalSnapshotChangeEventSource]
      2025-02-28 10:07:02,004 INFO   Oracle|server1|snapshot  All eligible tables schema should be captured, capturing: [ORCLPDB1.DEBEZIUM.OUTBOX]   [io.debezium.connector.oracle.OracleSnapshotChangeEventSource]
      2025-02-28 10:07:02,019 INFO   Oracle|server1|snapshot  	Registering 'ORCLPDB1.DEBEZIUM.OUTBOX' attributes: object_id=74157, data_object_id=74157   [io.debezium.connector.oracle.OracleConnection]
      2025-02-28 10:07:02,033 INFO   Oracle|server1|snapshot  Snapshot step 6 - Persisting schema history   [io.debezium.relational.RelationalSnapshotChangeEventSource]
      2025-02-28 10:07:02,033 INFO   Oracle|server1|snapshot  Capturing structure of table ORCLPDB1.DEBEZIUM.OUTBOX   [io.debezium.relational.RelationalSnapshotChangeEventSource]
      2025-02-28 10:07:02,151 INFO   Oracle|server1|snapshot  Snapshot step 7 - Snapshotting data   [io.debezium.relational.RelationalSnapshotChangeEventSource]
      2025-02-28 10:07:02,152 INFO   Oracle|server1|snapshot  Creating snapshot worker pool with 1 worker thread(s)   [io.debezium.relational.RelationalSnapshotChangeEventSource]
      2025-02-28 10:07:02,152 INFO   Oracle|server1|snapshot  For table 'ORCLPDB1.DEBEZIUM.OUTBOX' using select statement: 'SELECT "ID", "AGGREGATETYPE", "AGGREGATEID", "TYPE", "PAYLOAD" FROM "DEBEZIUM"."OUTBOX" AS OF SCN 3532351'   [io.debezium.relational.RelationalSnapshotChangeEventSource]
      2025-02-28 10:07:02,152 INFO   ||  Exporting data from table 'ORCLPDB1.DEBEZIUM.OUTBOX' (1 of 1 tables)   [io.debezium.relational.RelationalSnapshotChangeEventSource]
      2025-02-28 10:07:02,156 WARN   ||  Table ORCLPDB1.DEBEZIUM.OUTBOX snapshot failed: ORA-01466: unable to read data - table definition has changed
      , attempting to retry (0 of 3)   [io.debezium.connector.oracle.OracleSnapshotChangeEventSource]
      2025-02-28 10:07:02,156 INFO   ||  Exporting data from table 'ORCLPDB1.DEBEZIUM.OUTBOX' (1 of 1 tables)   [io.debezium.relational.RelationalSnapshotChangeEventSource]
      2025-02-28 10:07:02,157 WARN   ||  Table ORCLPDB1.DEBEZIUM.OUTBOX snapshot failed: ORA-01466: unable to read data - table definition has changed
      , attempting to retry (1 of 3)   [io.debezium.connector.oracle.OracleSnapshotChangeEventSource]
      2025-02-28 10:07:02,157 INFO   ||  Exporting data from table 'ORCLPDB1.DEBEZIUM.OUTBOX' (1 of 1 tables)   [io.debezium.relational.RelationalSnapshotChangeEventSource]
      2025-02-28 10:07:02,159 WARN   ||  Table ORCLPDB1.DEBEZIUM.OUTBOX snapshot failed: ORA-01466: unable to read data - table definition has changed
      , attempting to retry (2 of 3)   [io.debezium.connector.oracle.OracleSnapshotChangeEventSource]
      2025-02-28 10:07:02,159 INFO   ||  Exporting data from table 'ORCLPDB1.DEBEZIUM.OUTBOX' (1 of 1 tables)   [io.debezium.relational.RelationalSnapshotChangeEventSource]
      2025-02-28 10:07:02,160 ERROR  Oracle|server1|snapshot  Error during snapshot   [io.debezium.relational.RelationalSnapshotChangeEventSource]
      java.util.concurrent.ExecutionException: org.apache.kafka.connect.errors.ConnectException: Snapshotting of table ORCLPDB1.DEBEZIUM.OUTBOX failed
      	at java.base/java.util.concurrent.FutureTask.report(FutureTask.java:122)
      	at java.base/java.util.concurrent.FutureTask.get(FutureTask.java:191)
      	at io.debezium.relational.RelationalSnapshotChangeEventSource.createDataEvents(RelationalSnapshotChangeEventSource.java:534)
      	at io.debezium.relational.RelationalSnapshotChangeEventSource.doExecute(RelationalSnapshotChangeEventSource.java:179)
      	at io.debezium.pipeline.source.AbstractSnapshotChangeEventSource.execute(AbstractSnapshotChangeEventSource.java:96)
      	at io.debezium.pipeline.ChangeEventSourceCoordinator.doSnapshot(ChangeEventSourceCoordinator.java:297)
      	at io.debezium.pipeline.ChangeEventSourceCoordinator.doSnapshot(ChangeEventSourceCoordinator.java:281)
      	at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:192)
      	at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:143)
      	at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:572)
      	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317)
      	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
      	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
      	at java.base/java.lang.Thread.run(Thread.java:1583)
      Caused by: org.apache.kafka.connect.errors.ConnectException: Snapshotting of table ORCLPDB1.DEBEZIUM.OUTBOX failed
      	at io.debezium.connector.oracle.OracleSnapshotChangeEventSource.lambda$createDataEventsForTableCallable$1(OracleSnapshotChangeEventSource.java:312)
      	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317)
      	... 5 common frames omitted
      Caused by: java.sql.SQLException: ORA-01466: unable to read data - table definition has changed
      
      	at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:1301)
      	at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:1183)
      	at oracle.jdbc.driver.T2CStatement.executeForDescribe(T2CStatement.java:968)
      	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.OracleStatement.executeQuery(OracleStatement.java:2055)
      	at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:394)
      	at io.debezium.relational.RelationalSnapshotChangeEventSource.resultSetForDataEvents(RelationalSnapshotChangeEventSource.java:670)
      	at io.debezium.relational.RelationalSnapshotChangeEventSource.doCreateDataEventsForTable(RelationalSnapshotChangeEventSource.java:619)
      	at io.debezium.connector.oracle.OracleSnapshotChangeEventSource.lambda$createDataEventsForTableCallable$1(OracleSnapshotChangeEventSource.java:295)
      	... 6 common frames omitted
      Caused by: oracle.jdbc.OracleDatabaseException: ORA-01466: unable to read data - table definition has changed
      
      	at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:1315)
      	... 17 common frames omitted
      2025-02-28 10:07:02,160 INFO   Oracle|server1|snapshot  Snapshot - Final stage   [io.debezium.pipeline.source.AbstractSnapshotChangeEventSource]
      2025-02-28 10:07:02,161 WARN   Oracle|server1|snapshot  Snapshot was not completed successfully , it will be re-executed upon connector restart   [io.debezium.pipeline.source.AbstractSnapshotChangeEventSource]
      2025-02-28 10:07:02,161 ERROR  Oracle|server1|snapshot  Producer failure   [io.debezium.pipeline.ErrorHandler]
      io.debezium.DebeziumException: java.util.concurrent.ExecutionException: org.apache.kafka.connect.errors.ConnectException: Snapshotting of table ORCLPDB1.DEBEZIUM.OUTBOX failed
      	at io.debezium.pipeline.source.AbstractSnapshotChangeEventSource.execute(AbstractSnapshotChangeEventSource.java:105)
      	at io.debezium.pipeline.ChangeEventSourceCoordinator.doSnapshot(ChangeEventSourceCoordinator.java:297)
      	at io.debezium.pipeline.ChangeEventSourceCoordinator.doSnapshot(ChangeEventSourceCoordinator.java:281)
      	at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:192)
      	at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:143)
      	at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:572)
      	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317)
      	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
      	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
      	at java.base/java.lang.Thread.run(Thread.java:1583)
      Caused by: java.util.concurrent.ExecutionException: org.apache.kafka.connect.errors.ConnectException: Snapshotting of table ORCLPDB1.DEBEZIUM.OUTBOX failed
      	at java.base/java.util.concurrent.FutureTask.report(FutureTask.java:122)
      	at java.base/java.util.concurrent.FutureTask.get(FutureTask.java:191)
      	at io.debezium.relational.RelationalSnapshotChangeEventSource.createDataEvents(RelationalSnapshotChangeEventSource.java:534)
      	at io.debezium.relational.RelationalSnapshotChangeEventSource.doExecute(RelationalSnapshotChangeEventSource.java:179)
      	at io.debezium.pipeline.source.AbstractSnapshotChangeEventSource.execute(AbstractSnapshotChangeEventSource.java:96)
      	... 9 common frames omitted
      Caused by: org.apache.kafka.connect.errors.ConnectException: Snapshotting of table ORCLPDB1.DEBEZIUM.OUTBOX failed
      	at io.debezium.connector.oracle.OracleSnapshotChangeEventSource.lambda$createDataEventsForTableCallable$1(OracleSnapshotChangeEventSource.java:312)
      	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317)
      	... 5 common frames omitted
      Caused by: java.sql.SQLException: ORA-01466: unable to read data - table definition has changed
      
      	at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:1301)
      	at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:1183)
      	at oracle.jdbc.driver.T2CStatement.executeForDescribe(T2CStatement.java:968)
      	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.OracleStatement.executeQuery(OracleStatement.java:2055)
      	at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:394)
      	at io.debezium.relational.RelationalSnapshotChangeEventSource.resultSetForDataEvents(RelationalSnapshotChangeEventSource.java:670)
      	at io.debezium.relational.RelationalSnapshotChangeEventSource.doCreateDataEventsForTable(RelationalSnapshotChangeEventSource.java:619)
      	at io.debezium.connector.oracle.OracleSnapshotChangeEventSource.lambda$createDataEventsForTableCallable$1(OracleSnapshotChangeEventSource.java:295)
      	... 6 common frames omitted
      Caused by: oracle.jdbc.OracleDatabaseException: ORA-01466: unable to read data - table definition has changed
      
      	at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:1315)
      	... 17 common frames omitted
      2025-02-28 10:07:02,162 INFO   Oracle|server1|snapshot  Connected metrics set to 'false'   [io.debezium.pipeline.ChangeEventSourceCoordinator]
      2025-02-28 10:07:02,305 ERROR  OutboxEventRouterIT||engine  Engine has failed with    [io.debezium.embedded.async.AsyncEmbeddedEngine]
      java.util.concurrent.ExecutionException: org.apache.kafka.connect.errors.ConnectException: An exception occurred in the change event producer. This connector will be stopped.
      	at java.base/java.util.concurrent.FutureTask.report(FutureTask.java:122)
      	at java.base/java.util.concurrent.FutureTask.get(FutureTask.java:191)
      	at io.debezium.embedded.async.AsyncEmbeddedEngine.runTasksPolling(AsyncEmbeddedEngine.java:489)
      	at io.debezium.embedded.async.AsyncEmbeddedEngine.run(AsyncEmbeddedEngine.java:220)
      	at io.debezium.embedded.async.TestingAsyncEmbeddedEngine.run(TestingAsyncEmbeddedEngine.java:29)
      	at io.debezium.embedded.AbstractConnectorTest.lambda$start$8(AbstractConnectorTest.java:453)
      	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
      	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
      	at java.base/java.lang.Thread.run(Thread.java:1583)
      Caused by: org.apache.kafka.connect.errors.ConnectException: An exception occurred in the change event producer. This connector will be stopped.
      	at io.debezium.pipeline.ErrorHandler.setProducerThrowable(ErrorHandler.java:67)
      	at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:150)
      	at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:572)
      	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317)
      	... 3 common frames omitted
      Caused by: io.debezium.DebeziumException: java.util.concurrent.ExecutionException: org.apache.kafka.connect.errors.ConnectException: Snapshotting of table ORCLPDB1.DEBEZIUM.OUTBOX failed
      	at io.debezium.pipeline.source.AbstractSnapshotChangeEventSource.execute(AbstractSnapshotChangeEventSource.java:105)
      	at io.debezium.pipeline.ChangeEventSourceCoordinator.doSnapshot(ChangeEventSourceCoordinator.java:297)
      	at io.debezium.pipeline.ChangeEventSourceCoordinator.doSnapshot(ChangeEventSourceCoordinator.java:281)
      	at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:192)
      	at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:143)
      	... 5 common frames omitted
      Caused by: java.util.concurrent.ExecutionException: org.apache.kafka.connect.errors.ConnectException: Snapshotting of table ORCLPDB1.DEBEZIUM.OUTBOX failed
      	at java.base/java.util.concurrent.FutureTask.report(FutureTask.java:122)
      	at java.base/java.util.concurrent.FutureTask.get(FutureTask.java:191)
      	at io.debezium.relational.RelationalSnapshotChangeEventSource.createDataEvents(RelationalSnapshotChangeEventSource.java:534)
      	at io.debezium.relational.RelationalSnapshotChangeEventSource.doExecute(RelationalSnapshotChangeEventSource.java:179)
      	at io.debezium.pipeline.source.AbstractSnapshotChangeEventSource.execute(AbstractSnapshotChangeEventSource.java:96)
      	... 9 common frames omitted
      Caused by: org.apache.kafka.connect.errors.ConnectException: Snapshotting of table ORCLPDB1.DEBEZIUM.OUTBOX failed
      	at io.debezium.connector.oracle.OracleSnapshotChangeEventSource.lambda$createDataEventsForTableCallable$1(OracleSnapshotChangeEventSource.java:312)
      	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317)
      	... 5 common frames omitted
      Caused by: java.sql.SQLException: ORA-01466: unable to read data - table definition has changed
      
      	at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:1301)
      	at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:1183)
      	at oracle.jdbc.driver.T2CStatement.executeForDescribe(T2CStatement.java:968)
      	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.OracleStatement.executeQuery(OracleStatement.java:2055)
      	at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:394)
      	at io.debezium.relational.RelationalSnapshotChangeEventSource.resultSetForDataEvents(RelationalSnapshotChangeEventSource.java:670)
      	at io.debezium.relational.RelationalSnapshotChangeEventSource.doCreateDataEventsForTable(RelationalSnapshotChangeEventSource.java:619)
      	at io.debezium.connector.oracle.OracleSnapshotChangeEventSource.lambda$createDataEventsForTableCallable$1(OracleSnapshotChangeEventSource.java:295)
      	... 6 common frames omitted
      Caused by: oracle.jdbc.OracleDatabaseException: ORA-01466: unable to read data - table definition has changed
      
      	at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:1315)
      	... 17 common frames omitted
      2025-02-28 10:07:02,306 INFO   OutboxEventRouterIT||engine  Engine state has changed from 'POLLING_TASKS' to 'STOPPING'   [io.debezium.embedded.async.AsyncEmbeddedEngine]
      

      The retry mechanism should succeed.

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

                Created:
                Updated: