Loading...

Type: Task
Resolution: Done
Priority: Major
Fix Version/s: 2.6.0.Beta1
Affects Version/s: 2.4.0.Final
Component/s: oracle-connector
Labels:
None

Blocked:
False
Blocked Reason:
None
Ready:
False
Intelligence Requested:
Market:

SFDC Cases Counter:
SFDC Cases Links:

The OracleConnectorIT test shouldHandleParentChildIndexOrganizedTables fails regularly on the testing farm (Oracle 21 LogMiner):

2023-10-25 05:07:34,151 INFO   OracleConnectorIT||test  Starting test io.debezium.connector.oracle.OracleConnectorIT#shouldHandleParentChildIndexOrganizedTables   [io.debezium.connector.oracle.OracleConnectorIT]
2023-10-25 05:07:34,180 INFO   OracleConnectorIT||engine  Loading the custom source info struct maker plugin: io.debezium.connector.oracle.OracleSourceInfoStructMaker   [io.debezium.config.CommonConnectorConfig]
2023-10-25 05:07:34,218 INFO   OracleConnectorIT||engine  Database Version: Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production
Version 21.3.0.0.0   [io.debezium.connector.oracle.OracleConnection]
2023-10-25 05:07:34,219 INFO   ||  Connection gracefully closed   [io.debezium.jdbc.JdbcConnection]
2023-10-25 05:07:34,220 INFO   OracleConnectorIT||engine  Starting OracleConnectorTask with configuration:   [io.debezium.connector.common.BaseSourceTask]
2023-10-25 05:07:34,220 INFO   OracleConnectorIT||engine     log.mining.buffer.drop.on.stop = true   [io.debezium.connector.common.BaseSourceTask]
2023-10-25 05:07:34,220 INFO   OracleConnectorIT||engine     connector.class = io.debezium.connector.oracle.OracleConnector   [io.debezium.connector.common.BaseSourceTask]
2023-10-25 05:07:34,220 INFO   OracleConnectorIT||engine     schema.include.list = DEBEZIUM   [io.debezium.connector.common.BaseSourceTask]
2023-10-25 05:07:34,220 INFO   OracleConnectorIT||engine     log.mining.strategy = online_catalog   [io.debezium.connector.common.BaseSourceTask]
2023-10-25 05:07:34,220 INFO   OracleConnectorIT||engine     include.schema.changes = false   [io.debezium.connector.common.BaseSourceTask]
2023-10-25 05:07:34,220 INFO   OracleConnectorIT||engine     schema.history.internal.file.filename = /var/ARTIFACTS/work-oracle9kqj2th4/debezium-testing/tmt/plans/oracle/oracle/discover/default-0/tests/target/data/file-schema-history-connect.txt   [io.debezium.connector.common.BaseSourceTask]
2023-10-25 05:07:34,220 INFO   OracleConnectorIT||engine     topic.prefix = server1   [io.debezium.connector.common.BaseSourceTask]
2023-10-25 05:07:34,220 INFO   OracleConnectorIT||engine     offset.storage.file.filename = /var/ARTIFACTS/work-oracle9kqj2th4/debezium-testing/tmt/plans/oracle/oracle/discover/default-0/tests/target/data/file-connector-offsets.txt   [io.debezium.connector.common.BaseSourceTask]
2023-10-25 05:07:34,220 INFO   OracleConnectorIT||engine     errors.retry.delay.initial.ms = 300   [io.debezium.connector.common.BaseSourceTask]
2023-10-25 05:07:34,220 INFO   OracleConnectorIT||engine     value.converter = org.apache.kafka.connect.json.JsonConverter   [io.debezium.connector.common.BaseSourceTask]
2023-10-25 05:07:34,220 INFO   OracleConnectorIT||engine     key.converter = org.apache.kafka.connect.json.JsonConverter   [io.debezium.connector.common.BaseSourceTask]
2023-10-25 05:07:34,220 INFO   OracleConnectorIT||engine     database.admin.hostname = 0.0.0.0   [io.debezium.connector.common.BaseSourceTask]
2023-10-25 05:07:34,220 INFO   OracleConnectorIT||engine     database.dbname = ORCLCDB   [io.debezium.connector.common.BaseSourceTask]
2023-10-25 05:07:34,220 INFO   OracleConnectorIT||engine     database.user = c##dbzuser   [io.debezium.connector.common.BaseSourceTask]
2023-10-25 05:07:34,220 INFO   OracleConnectorIT||engine     offset.storage = org.apache.kafka.connect.storage.FileOffsetBackingStore   [io.debezium.connector.common.BaseSourceTask]
2023-10-25 05:07:34,220 INFO   OracleConnectorIT||engine     database.connection.adapter = logminer   [io.debezium.connector.common.BaseSourceTask]
2023-10-25 05:07:34,220 INFO   OracleConnectorIT||engine     database.pdb.name = ORCLPDB1   [io.debezium.connector.common.BaseSourceTask]
2023-10-25 05:07:34,220 INFO   OracleConnectorIT||engine     offset.flush.timeout.ms = 5000   [io.debezium.connector.common.BaseSourceTask]
2023-10-25 05:07:34,220 INFO   OracleConnectorIT||engine     errors.retry.delay.max.ms = 10000   [io.debezium.connector.common.BaseSourceTask]
2023-10-25 05:07:34,220 INFO   OracleConnectorIT||engine     database.port = 1521   [io.debezium.connector.common.BaseSourceTask]
2023-10-25 05:07:34,220 INFO   OracleConnectorIT||engine     offset.flush.interval.ms = 0   [io.debezium.connector.common.BaseSourceTask]
2023-10-25 05:07:34,220 INFO   OracleConnectorIT||engine     schema.history.internal = io.debezium.storage.file.history.FileSchemaHistory   [io.debezium.connector.common.BaseSourceTask]
2023-10-25 05:07:34,220 INFO   OracleConnectorIT||engine     errors.max.retries = -1   [io.debezium.connector.common.BaseSourceTask]
2023-10-25 05:07:34,220 INFO   OracleConnectorIT||engine     database.hostname = 0.0.0.0   [io.debezium.connector.common.BaseSourceTask]
2023-10-25 05:07:34,220 INFO   OracleConnectorIT||engine     log.mining.query.filter.mode = regex   [io.debezium.connector.common.BaseSourceTask]
2023-10-25 05:07:34,220 INFO   OracleConnectorIT||engine     database.password = ********   [io.debezium.connector.common.BaseSourceTask]
2023-10-25 05:07:34,220 INFO   OracleConnectorIT||engine     name = testing-connector   [io.debezium.connector.common.BaseSourceTask]
2023-10-25 05:07:34,220 INFO   OracleConnectorIT||engine     table.include.list = (.)*IOT(.)*   [io.debezium.connector.common.BaseSourceTask]
2023-10-25 05:07:34,220 INFO   OracleConnectorIT||engine  Loading the custom source info struct maker plugin: io.debezium.connector.oracle.OracleSourceInfoStructMaker   [io.debezium.config.CommonConnectorConfig]
2023-10-25 05:07:34,220 INFO   OracleConnectorIT||engine  Loading the custom topic naming strategy plugin: io.debezium.schema.SchemaTopicNamingStrategy   [io.debezium.config.CommonConnectorConfig]
2023-10-25 05:07:34,242 INFO   OracleConnectorIT||engine  Database Version: Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production
Version 21.3.0.0.0   [io.debezium.connector.oracle.OracleConnection]
2023-10-25 05:07:34,243 INFO   OracleConnectorIT||engine  No previous offsets found   [io.debezium.connector.common.BaseSourceTask]
2023-10-25 05:07:34,243 INFO   OracleConnectorIT||engine  Connector started for the first time, database schema history recovery will not be executed   [io.debezium.connector.oracle.OracleConnectorTask]
2023-10-25 05:07:34,243 INFO   OracleConnectorIT||engine  Requested thread factory for connector OracleConnector, id = server1 named = SignalProcessor   [io.debezium.util.Threads]
2023-10-25 05:07:34,244 INFO   OracleConnectorIT||engine  Requested thread factory for connector OracleConnector, id = server1 named = change-event-source-coordinator   [io.debezium.util.Threads]
2023-10-25 05:07:34,244 INFO   OracleConnectorIT||engine  Requested thread factory for connector OracleConnector, id = server1 named = blocking-snapshot   [io.debezium.util.Threads]
2023-10-25 05:07:34,244 INFO   OracleConnectorIT||engine  Creating thread debezium-oracleconnector-server1-change-event-source-coordinator   [io.debezium.util.Threads]
2023-10-25 05:07:34,244 INFO   Oracle|server1|snapshot  Metrics registered   [io.debezium.pipeline.ChangeEventSourceCoordinator]
2023-10-25 05:07:34,244 INFO   Oracle|server1|snapshot  Context created   [io.debezium.pipeline.ChangeEventSourceCoordinator]
2023-10-25 05:07:34,244 INFO   Oracle|server1|snapshot  No previous offset has been found.   [io.debezium.connector.oracle.OracleSnapshotChangeEventSource]
2023-10-25 05:07:34,244 INFO   Oracle|server1|snapshot  According to the connector configuration both schema and data will be snapshot.   [io.debezium.connector.oracle.OracleSnapshotChangeEventSource]
2023-10-25 05:07:34,244 INFO   OracleConnectorIT||engine  SignalProcessor started. Scheduling it every 5000ms   [io.debezium.pipeline.signal.SignalProcessor]
2023-10-25 05:07:34,244 INFO   OracleConnectorIT||engine  Creating thread debezium-oracleconnector-server1-SignalProcessor   [io.debezium.util.Threads]
2023-10-25 05:07:34,245 INFO   Oracle|server1|snapshot  Snapshot step 1 - Preparing   [io.debezium.relational.RelationalSnapshotChangeEventSource]
2023-10-25 05:07:34,245 INFO   Oracle|server1|snapshot  Snapshot step 2 - Determining captured tables   [io.debezium.relational.RelationalSnapshotChangeEventSource]
2023-10-25 05:07:34,356 INFO   Oracle|server1|snapshot  Adding table ORCLPDB1.DEBEZIUM.TRUNCATED_COLUMN_TABLE to the list of capture schema tables   [io.debezium.relational.RelationalSnapshotChangeEventSource]
2023-10-25 05:07:34,356 INFO   Oracle|server1|snapshot  Adding table ORCLPDB1.DEBEZIUM.DT_TABLE to the list of capture schema tables   [io.debezium.relational.RelationalSnapshotChangeEventSource]
2023-10-25 05:07:34,356 INFO   Oracle|server1|snapshot  Adding table ORCLPDB1.DEBEZIUM.TEST_IOT to the list of capture schema tables   [io.debezium.relational.RelationalSnapshotChangeEventSource]
2023-10-25 05:07:34,356 INFO   Oracle|server1|snapshot  Adding table ORCLPDB1.DEBEZIUM.MASKED_HASHED_COLUMN_TABLE to the list of capture schema tables   [io.debezium.relational.RelationalSnapshotChangeEventSource]
2023-10-25 05:07:34,356 INFO   Oracle|server1|snapshot  Adding table ORCLPDB1.DEBEZIUM.CUSTOMER to the list of capture schema tables   [io.debezium.relational.RelationalSnapshotChangeEventSource]
2023-10-25 05:07:34,356 INFO   Oracle|server1|snapshot  Created connection pool with 1 threads   [io.debezium.relational.RelationalSnapshotChangeEventSource]
2023-10-25 05:07:34,356 INFO   Oracle|server1|snapshot  Snapshot step 3 - Locking captured tables [ORCLPDB1.DEBEZIUM.TEST_IOT]   [io.debezium.relational.RelationalSnapshotChangeEventSource]
2023-10-25 05:07:34,358 INFO   Oracle|server1|snapshot  Snapshot step 4 - Determining snapshot offset   [io.debezium.relational.RelationalSnapshotChangeEventSource]
2023-10-25 05:07:35,020 INFO   Oracle|server1|snapshot  	No in-progress transactions will be captured.   [io.debezium.connector.oracle.logminer.LogMinerAdapter]
2023-10-25 05:07:35,021 INFO   ||  Connection gracefully closed   [io.debezium.jdbc.JdbcConnection]
2023-10-25 05:07:35,021 INFO   Oracle|server1|snapshot  Snapshot step 5 - Reading structure of captured tables   [io.debezium.relational.RelationalSnapshotChangeEventSource]
2023-10-25 05:07:35,021 INFO   Oracle|server1|snapshot  All eligible tables schema should be captured, capturing: [ORCLPDB1.DEBEZIUM.CUSTOMER, ORCLPDB1.DEBEZIUM.DT_TABLE, ORCLPDB1.DEBEZIUM.MASKED_HASHED_COLUMN_TABLE, ORCLPDB1.DEBEZIUM.TEST_IOT, ORCLPDB1.DEBEZIUM.TRUNCATED_COLUMN_TABLE]   [io.debezium.connector.oracle.OracleSnapshotChangeEventSource]
2023-10-25 05:07:35,052 INFO   Oracle|server1|snapshot  Snapshot step 6 - Persisting schema history   [io.debezium.relational.RelationalSnapshotChangeEventSource]
2023-10-25 05:07:35,052 INFO   Oracle|server1|snapshot  Capturing structure of table ORCLPDB1.DEBEZIUM.CUSTOMER   [io.debezium.relational.RelationalSnapshotChangeEventSource]
2023-10-25 05:07:35,169 INFO   Oracle|server1|snapshot  Capturing structure of table ORCLPDB1.DEBEZIUM.DT_TABLE   [io.debezium.relational.RelationalSnapshotChangeEventSource]
2023-10-25 05:07:35,251 INFO   Oracle|server1|snapshot  Capturing structure of table ORCLPDB1.DEBEZIUM.MASKED_HASHED_COLUMN_TABLE   [io.debezium.relational.RelationalSnapshotChangeEventSource]
2023-10-25 05:07:35,333 INFO   Oracle|server1|snapshot  Capturing structure of table ORCLPDB1.DEBEZIUM.TEST_IOT   [io.debezium.relational.RelationalSnapshotChangeEventSource]
2023-10-25 05:07:42,833 INFO   Oracle|server1|snapshot  Already applied 4 database changes   [io.debezium.relational.history.SchemaHistoryMetrics]
2023-10-25 05:07:42,833 INFO   Oracle|server1|snapshot  Capturing structure of table ORCLPDB1.DEBEZIUM.TRUNCATED_COLUMN_TABLE   [io.debezium.relational.RelationalSnapshotChangeEventSource]
2023-10-25 05:07:42,919 INFO   Oracle|server1|snapshot  Snapshot step 7 - Snapshotting data   [io.debezium.relational.RelationalSnapshotChangeEventSource]
2023-10-25 05:07:42,919 INFO   Oracle|server1|snapshot  Creating snapshot worker pool with 1 worker thread(s)   [io.debezium.relational.RelationalSnapshotChangeEventSource]
2023-10-25 05:07:42,919 INFO   Oracle|server1|snapshot  For table 'ORCLPDB1.DEBEZIUM.TEST_IOT' using select statement: 'SELECT "ID", "DESCRIPTION" FROM "DEBEZIUM"."TEST_IOT" AS OF SCN 3791659'   [io.debezium.relational.RelationalSnapshotChangeEventSource]
2023-10-25 05:07:42,920 INFO   ||  Exporting data from table 'ORCLPDB1.DEBEZIUM.TEST_IOT' (1 of 1 tables)   [io.debezium.relational.RelationalSnapshotChangeEventSource]
2023-10-25 05:07:42,924 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.TEST_IOT 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:463)
	at io.debezium.relational.RelationalSnapshotChangeEventSource.doExecute(RelationalSnapshotChangeEventSource.java:165)
	at io.debezium.pipeline.source.AbstractSnapshotChangeEventSource.execute(AbstractSnapshotChangeEventSource.java:92)
	at io.debezium.pipeline.ChangeEventSourceCoordinator.doSnapshot(ChangeEventSourceCoordinator.java:253)
	at io.debezium.pipeline.ChangeEventSourceCoordinator.doSnapshot(ChangeEventSourceCoordinator.java:237)
	at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:189)
	at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:137)
	at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
	at java.base/java.lang.Thread.run(Thread.java:833)
Caused by: org.apache.kafka.connect.errors.ConnectException: Snapshotting of table ORCLPDB1.DEBEZIUM.TEST_IOT failed
	at io.debezium.relational.RelationalSnapshotChangeEventSource.doCreateDataEventsForTable(RelationalSnapshotChangeEventSource.java:587)
	at io.debezium.relational.RelationalSnapshotChangeEventSource.lambda$createDataEventsForTableCallable$6(RelationalSnapshotChangeEventSource.java:515)
	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
	... 5 common frames omitted
Caused by: java.sql.SQLException: ORA-01466: unable to read data - table definition has changed

	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:1151)
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:771)
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:299)
	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:498)
	at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:112)
	at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:896)
	at oracle.jdbc.driver.OracleStatement.prepareDefineBufferAndExecute(OracleStatement.java:1172)
	at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1101)
	at oracle.jdbc.driver.OracleStatement.executeSQLSelect(OracleStatement.java:1426)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1309)
	at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1713)
	at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:394)
	at io.debezium.relational.RelationalSnapshotChangeEventSource.resultSetForDataEvents(RelationalSnapshotChangeEventSource.java:593)
	at io.debezium.relational.RelationalSnapshotChangeEventSource.doCreateDataEventsForTable(RelationalSnapshotChangeEventSource.java:541)
	... 7 common frames omitted
Caused by: oracle.jdbc.OracleDatabaseException: ORA-01466: unable to read data - table definition has changed

	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:637)
	... 22 common frames omitted
2023-10-25 05:07:42,924 INFO   Oracle|server1|snapshot  Snapshot - Final stage   [io.debezium.pipeline.source.AbstractSnapshotChangeEventSource]
2023-10-25 05:07:42,926 WARN   Oracle|server1|snapshot  Snapshot was not completed successfully, it will be re-executed upon connector restart   [io.debezium.pipeline.source.AbstractSnapshotChangeEventSource]
2023-10-25 05:07:42,926 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.TEST_IOT failed
	at io.debezium.pipeline.source.AbstractSnapshotChangeEventSource.execute(AbstractSnapshotChangeEventSource.java:101)
	at io.debezium.pipeline.ChangeEventSourceCoordinator.doSnapshot(ChangeEventSourceCoordinator.java:253)
	at io.debezium.pipeline.ChangeEventSourceCoordinator.doSnapshot(ChangeEventSourceCoordinator.java:237)
	at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:189)
	at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:137)
	at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
	at java.base/java.lang.Thread.run(Thread.java:833)
Caused by: java.util.concurrent.ExecutionException: org.apache.kafka.connect.errors.ConnectException: Snapshotting of table ORCLPDB1.DEBEZIUM.TEST_IOT 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:463)
	at io.debezium.relational.RelationalSnapshotChangeEventSource.doExecute(RelationalSnapshotChangeEventSource.java:165)
	at io.debezium.pipeline.source.AbstractSnapshotChangeEventSource.execute(AbstractSnapshotChangeEventSource.java:92)
	... 9 common frames omitted
Caused by: org.apache.kafka.connect.errors.ConnectException: Snapshotting of table ORCLPDB1.DEBEZIUM.TEST_IOT failed
	at io.debezium.relational.RelationalSnapshotChangeEventSource.doCreateDataEventsForTable(RelationalSnapshotChangeEventSource.java:587)
	at io.debezium.relational.RelationalSnapshotChangeEventSource.lambda$createDataEventsForTableCallable$6(RelationalSnapshotChangeEventSource.java:515)
	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
	... 5 common frames omitted
Caused by: java.sql.SQLException: ORA-01466: unable to read data - table definition has changed

	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:1151)
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:771)
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:299)
	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:498)
	at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:112)
	at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:896)
	at oracle.jdbc.driver.OracleStatement.prepareDefineBufferAndExecute(OracleStatement.java:1172)
	at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1101)
	at oracle.jdbc.driver.OracleStatement.executeSQLSelect(OracleStatement.java:1426)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1309)
	at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1713)
	at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:394)
	at io.debezium.relational.RelationalSnapshotChangeEventSource.resultSetForDataEvents(RelationalSnapshotChangeEventSource.java:593)
	at io.debezium.relational.RelationalSnapshotChangeEventSource.doCreateDataEventsForTable(RelationalSnapshotChangeEventSource.java:541)
	... 7 common frames omitted
Caused by: oracle.jdbc.OracleDatabaseException: ORA-01466: unable to read data - table definition has changed

	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:637)
	... 22 common frames omitted
2023-10-25 05:07:42,926 INFO   Oracle|server1|snapshot  Connected metrics set to 'false'   [io.debezium.pipeline.ChangeEventSourceCoordinator]
2023-10-25 05:07:43,261 INFO   Oracle|server1|snapshot  Stopping the task and engine   [io.debezium.embedded.EmbeddedEngine]
2023-10-25 05:07:43,261 INFO   Oracle|server1|snapshot  Stopping down connector   [io.debezium.connector.common.BaseSourceTask]
2023-10-25 05:07:43,261 INFO   Oracle|server1|snapshot  SignalProcessor stopped   [io.debezium.pipeline.signal.SignalProcessor]
2023-10-25 05:07:43,267 INFO   ||  Connection gracefully closed   [io.debezium.jdbc.JdbcConnection]
2023-10-25 05:07:43,267 ERROR  Oracle|server1|snapshot  Error while trying to run connector class 'io.debezium.connector.oracle.OracleConnector'   [io.debezium.connector.oracle.OracleConnectorIT]
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:144)
	at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
	at java.base/java.lang.Thread.run(Thread.java:833)
Caused by: io.debezium.DebeziumException: java.util.concurrent.ExecutionException: org.apache.kafka.connect.errors.ConnectException: Snapshotting of table ORCLPDB1.DEBEZIUM.TEST_IOT failed
	at io.debezium.pipeline.source.AbstractSnapshotChangeEventSource.execute(AbstractSnapshotChangeEventSource.java:101)
	at io.debezium.pipeline.ChangeEventSourceCoordinator.doSnapshot(ChangeEventSourceCoordinator.java:253)
	at io.debezium.pipeline.ChangeEventSourceCoordinator.doSnapshot(ChangeEventSourceCoordinator.java:237)
	at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:189)
	at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:137)
	... 5 common frames omitted
Caused by: java.util.concurrent.ExecutionException: org.apache.kafka.connect.errors.ConnectException: Snapshotting of table ORCLPDB1.DEBEZIUM.TEST_IOT 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:463)
	at io.debezium.relational.RelationalSnapshotChangeEventSource.doExecute(RelationalSnapshotChangeEventSource.java:165)
	at io.debezium.pipeline.source.AbstractSnapshotChangeEventSource.execute(AbstractSnapshotChangeEventSource.java:92)
	... 9 common frames omitted
Caused by: org.apache.kafka.connect.errors.ConnectException: Snapshotting of table ORCLPDB1.DEBEZIUM.TEST_IOT failed
	at io.debezium.relational.RelationalSnapshotChangeEventSource.doCreateDataEventsForTable(RelationalSnapshotChangeEventSource.java:587)
	at io.debezium.relational.RelationalSnapshotChangeEventSource.lambda$createDataEventsForTableCallable$6(RelationalSnapshotChangeEventSource.java:515)
	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
	... 5 common frames omitted
Caused by: java.sql.SQLException: ORA-01466: unable to read data - table definition has changed

	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:1151)
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:771)
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:299)
	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:498)
	at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:112)
	at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:896)
	at oracle.jdbc.driver.OracleStatement.prepareDefineBufferAndExecute(OracleStatement.java:1172)
	at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1101)
	at oracle.jdbc.driver.OracleStatement.executeSQLSelect(OracleStatement.java:1426)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1309)
	at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1713)
	at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:394)
	at io.debezium.relational.RelationalSnapshotChangeEventSource.resultSetForDataEvents(RelationalSnapshotChangeEventSource.java:593)
	at io.debezium.relational.RelationalSnapshotChangeEventSource.doCreateDataEventsForTable(RelationalSnapshotChangeEventSource.java:541)
	... 7 common frames omitted
Caused by: oracle.jdbc.OracleDatabaseException: ORA-01466: unable to read data - table definition has changed

	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:637)
	... 22 common frames omitted
2023-10-25 05:08:35,802 INFO   OracleConnectorIT||test  Stopping the connector   [io.debezium.connector.oracle.OracleConnectorIT]
2023-10-25 05:08:35,802 INFO   OracleConnectorIT||test  Interrupting the engine   [io.debezium.connector.oracle.OracleConnectorIT]
2023-10-25 05:08:35,803 INFO   OracleConnectorIT||test  Test io.debezium.connector.oracle.OracleConnectorIT#shouldHandleParentChildIndexOrganizedTables failed   [io.debezium.connector.oracle.OracleConnectorIT]

Details

Description

Attachments

Activity

People

Dates