DanielCarter-stack commented on issue #10458:
URL: https://github.com/apache/seatunnel/issues/10458#issuecomment-3858263130
<!-- code-pr-reviewer -->
Thanks for reporting this. The issue is an Oracle 11g + ojdbc11 driver
incompatibility in Debezium's SCN gap detection logic, which only runs during
task resume (when `prevEndScn` exists from checkpoint).
Evidence from codebase:
-
`seatunnel-connectors-v2/connector-cdc/connector-cdc-oracle/src/main/java/io/debezium/connector/oracle/logminer/LogMinerStreamingChangeEventSource.java:805,808`
- calls `connection.getScnToTimestamp()` during SCN gap checking
- `docs/en/connectors/source/Oracle-CDC.md:100-104` - documents that "Oracle
11g is not supported"
Your existing `database.oracle.jdbc.timezoneAsRegion=false` doesn't affect
LogMiner's SCN-to-timestamp queries, which fail with ORA-18716 under Oracle 11g
+ ojdbc11-23.9.0.25.07.
**Recommended actions:**
1. Replace `ojdbc11-23.9.0.25.07.jar` with `ojdbc8-19.x` (better aligned
with Oracle 11g)
2. If the issue persists, try disabling SCN gap detection as a workaround:
```json
"log.mining.scn.gap.detection.gap.size.min": "9223372036854775807"
```
Oracle 11g reached EOL in 2020; upgrading to Oracle 19c/21c is recommended
for long-term support.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
