🔥 connect/connect-cdc-oracle11-source about kafka-docker-playground

[vdesabou]

[2024-02-04 18:01:14,316] ERROR [cdc-oracle11-source|task-1|snapshot-CUSTOMERS] SQL exception:  (io.confluent.connect.oracle.cdc.logging.LogUtils:27)
java.sql.SQLException: ORA-01466: unable to read data - table definition has changed

	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:629)
	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:563)
	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1150)
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:770)
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:298)
	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:497)
	at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:111)
	at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:895)
	at oracle.jdbc.driver.OracleStatement.prepareDefineBufferAndExecute(OracleStatement.java:1171)
	at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1100)
	at oracle.jdbc.driver.OracleStatement.executeSQLSelect(OracleStatement.java:1425)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1308)
	at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:[1712](https://github.com/vdesabou/kafka-docker-playground/actions/runs/7775938928/job/21202538499#step:5:1713))
	at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:393)
	at oracle.ucp.jdbc.proxy.oracle$1ucp$1jdbc$1proxy$1oracle$1StatementProxy$2oracle$1jdbc$1internal$1OracleStatement$$$Proxy.executeQuery(Unknown Source)
	at io.confluent.connect.oracle.cdc.logging.LogUtils.executeQuery(LogUtils.java:25)
	at io.confluent.connect.oracle.cdc.OracleSnapshotGenerator.getRowCountAsOfScn(OracleSnapshotGenerator.java:139)
	at io.confluent.connect.oracle.cdc.OracleSnapshotGenerator.doGenerateSnapshot(OracleSnapshotGenerator.java:161)
	at io.confluent.connect.oracle.cdc.OracleSnapshotGenerator.lambda$generateSnapshot$1(OracleSnapshotGenerator.java:129)
	at io.confluent.connect.utils.retry.RetryPolicy.callWith(RetryPolicy.java:417)
	at io.confluent.connect.utils.retry.RetryPolicy.callWith(RetryPolicy.java:368)
	at io.confluent.connect.oracle.cdc.OracleDatabase.retry(OracleDatabase.java:723)
	at io.confluent.connect.oracle.cdc.OracleSnapshotGenerator.generateSnapshot(OracleSnapshotGenerator.java:127)
	at io.confluent.connect.oracle.cdc.util.RecordQueue.lambda$createLoggingSupplier$0(RecordQueue.java:474)
	at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1700)
	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)
Caused by: Error : 1466, Position : 30, Sql = SELECT count(*) FROM "MYUSER"."CUSTOMERS" AS OF SCN 376890, OriginalSql = SELECT count(*) FROM "MYUSER"."CUSTOMERS" AS OF SCN 376890, Error Msg = ORA-01466: unable to read data - table definition has changed

	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:636)
	... 27 more

[vdesabou]

👍✅ Issue fixed !

👍 CP 7.1.11 🔢 Connector v2.11.1 (📅 release date 2024-02-02) 🕐 2024-02-05 18:55 📄 cdc-oracle11-source.sh 🔗 https://github.com/vdesabou/kafka-docker-playground/actions/runs/7789067253/job/21240053684

👍 CP 7.2.9 🔢 Connector v2.11.1 (📅 release date 2024-02-02) 🕐 2024-02-05 20:03 📄 cdc-oracle11-source.sh 🔗 https://github.com/vdesabou/kafka-docker-playground/actions/runs/7789067253/job/21240067058

👍 CP 7.3.7 🔢 Connector v2.11.1 (📅 release date 2024-02-02) 🕐 2024-02-05 20:56 📄 cdc-oracle11-source.sh 🔗 https://github.com/vdesabou/kafka-docker-playground/actions/runs/7789067253/job/21240074044

👍 CP 7.4.4 🔢 Connector v2.11.1 (📅 release date 2024-02-02) 🕐 2024-02-05 22:01 📄 cdc-oracle11-source.sh 🔗 https://github.com/vdesabou/kafka-docker-playground/actions/runs/7789067253/job/21240081976

👍 CP 7.5.3 🔢 Connector v2.11.1 (📅 release date 2024-02-02) 🕐 2024-02-05 23:12 📄 cdc-oracle11-source.sh 🔗 https://github.com/vdesabou/kafka-docker-playground/actions/runs/7789067253/job/21240090510