ORA-21560: argument last_position is null, invalid, or out of range
Sagar Kapare
2021-08-02 13:35:09,909 - ERROR [debezium-oracleconnector-dummy-change-event-source-coordinator:i.d.p.ErrorHandler@31] - Producer failure
oracle.streams.StreamsException: ORA-21560: argument last_position is null, invalid, or out of range
at oracle.streams.XStreamOut.XStreamOutAttachNative(Native Method) ~[xstreams.jar:na]
at oracle.streams.XStreamOut.attachInternal(XStreamOut.java:373) ~[xstreams.jar:na]
at oracle.streams.XStreamOut.attach(XStreamOut.java:343) ~[xstreams.jar:na]
at io.debezium.connector.oracle.xstream.XstreamStreamingChangeEventSource.execute(XstreamStreamingChangeEventSource.java:85) ~[debezium-connector-oracle-1.5.2.Final.jar:1.5.2.Final]
at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:152) [debezium-core-1.5.2.Final.jar:1.5.2.Final]
at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:119) [debezium-core-1.5.2.Final.jar:1.5.2.Final]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[na:1.8.0_292]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[na:1.8.0_292]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[na:1.8.0_292]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[na:1.8.0_292]
at java.lang.Thread.run(Thread.java:748) ~[na:1.8.0_292]
2021-08-02 13:35:09,910 - INFO [debezium-oracleconnector-dummy-change-event-source-coordinator:i.d.p.ChangeEventSourceCoordinator@153] - Finished streaming
2021-08-02 13:35:09,910 - INFO [debezium-oracleconnector-dummy-change-event-source-coordinator:i.d.p.m.StreamingChangeEventSourceMetrics@60] - Connected metrics set to 'false'
2021-08-02 13:35:21,360 - INFO [pool-8-thread-1:i.d.c.c.BaseSourceTask@182] - 4096 records sent during previous 00:00:13.788, last recorded offset: {snapshot=true, scn=17560314071108, snapshot_completed=false}
2021-08-02 13:35:22,491 - INFO [pool-8-thread-1:i.d.c.c.BaseSourceTask@238] - Stopping down connector
2021-08-02 13:35:22,499 - INFO [pool-11-thread-1:i.d.j.JdbcConnection@946] - Connection gracefully closed
2021-08-02 13:35:23,503 - WARN [worker-DeltaWorker-0:i.c.d.a.DeltaWorker@276] - Encountered an error. Events will be replayed from the last successful commit.
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:42) ~[na:na]
at io.debezium.connector.oracle.xstream.XstreamStreamingChangeEventSource.execute(XstreamStreamingChangeEventSource.java:112) ~[na:na]
at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:152) ~[na:na]
at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:119) ~[na:na]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[na:1.8.0_292]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[na:1.8.0_292]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[na:1.8.0_292]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[na:1.8.0_292]
at java.lang.Thread.run(Thread.java:748) ~[na:1.8.0_292]
Caused by: oracle.streams.StreamsException: ORA-21560: argument last_position is null, invalid, or out of range
at oracle.streams.XStreamOut.XStreamOutAttachNative(Native Method) ~[na:na]
at oracle.streams.XStreamOut.attachInternal(XStreamOut.java:373) ~[na:na]
at oracle.streams.XStreamOut.attach(XStreamOut.java:343) ~[na:na]
at io.debezium.connector.oracle.xstream.XstreamStreamingChangeEventSource.execute(XstreamStreamingChangeEventSource.java:85) ~[na:na]
Sagar Kapare
2021-08-03 08:33:10,136 - INFO [pool-28-thread-1:i.d.c.c.BaseSourceTask@126] - connector.class = io.debezium.connector.oracle.OracleConnector
2021-08-03 08:33:10,136 - INFO [pool-28-thread-1:i.d.c.c.BaseSourceTask@126] - database.user = xstrmadmin
2021-08-03 08:33:10,136 - INFO [pool-28-thread-1:i.d.c.c.BaseSourceTask@126] - database.dbname = dmdb
2021-08-03 08:33:10,137 - INFO [pool-28-thread-1:i.d.c.c.BaseSourceTask@126] - lcr_position =
2021-08-03 08:33:10,137 - INFO [pool-28-thread-1:i.d.c.c.BaseSourceTask@126] - offset.storage = io.cdap.delta.oracle.OracleConstantOffsetBackingStore
2021-08-03 08:33:10,137 - INFO [pool-28-thread-1:i.d.c.c.BaseSourceTask@126] - database.connection.adapter = xstream
2021-08-03 08:33:10,137 - INFO [pool-28-thread-1:i.d.c.c.BaseSourceTask@126] - database.server.name = dummy
2021-08-03 08:33:10,137 - INFO [pool-28-thread-1:i.d.c.c.BaseSourceTask@126] - database.port = 33000
2021-08-03 08:33:10,137 - INFO [pool-28-thread-1:i.d.c.c.BaseSourceTask@126] - offset.flush.interval.ms = 1000
2021-08-03 08:33:10,137 - INFO [pool-28-thread-1:i.d.c.c.BaseSourceTask@126] - database.serverTimezone = UTC
2021-08-03 08:33:10,137 - INFO [pool-28-thread-1:i.d.c.c.BaseSourceTask@126] - database.hostname = dbhost
2021-08-03 08:33:10,138 - INFO [pool-28-thread-1:i.d.c.c.BaseSourceTask@126] - database.password = ********
2021-08-03 08:33:10,138 - INFO [pool-28-thread-1:i.d.c.c.BaseSourceTask@126] - name = delta
2021-08-03 08:33:10,138 - INFO [pool-28-thread-1:i.d.c.c.BaseSourceTask@126] - database.out.server.name = xout
2021-08-03 08:33:10,138 - INFO [pool-28-thread-1:i.d.c.c.BaseSourceTask@126] - table.include.list = dm.TESTTABLE1
2021-08-03 08:33:10,138 - INFO [pool-28-thread-1:i.d.c.c.BaseSourceTask@126] - snapshot.mode = initial
2021-08-03 08:33:10,138 - INFO [pool-28-thread-1:i.d.c.c.BaseSourceTask@126] - snapshot =
2021-08-03 08:33:10,138 - INFO [pool-28-thread-1:i.d.c.c.BaseSourceTask@126] - database.history = io.cdap.delta.plugin.common.DBSchemaHistory
2021-08-03 08:33:10,139 - INFO [pool-28-thread-1:i.d.c.c.BaseSourceTask@126] - snapshot_completed =
2021-08-03 08:33:10,139 - INFO [pool-28-thread-1:i.d.c.c.BaseSourceTask@126] - scn =
2021-08-03 08:33:10,182 - INFO [pool-28-thread-1:i.d.c.o.OracleConnection@71] - Database Version: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
Thanks and Regards,
Sagar
--
You received this message because you are subscribed to a topic in the Google Groups "debezium" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/debezium/BrdLXcGZuWk/unsubscribe.
To unsubscribe from this group and all its topics, send an email to debezium+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/debezium/c53fcb9f-0d48-4fe1-8e56-da904790402fn%40googlegroups.com.
Sagar Kapare
Chris Cranford
Would you mind opening a Jira issue and including your findings there. Ideally this should have been handled transitively by the connector without needing to specify "internal.database.oracle.version=11". A pull request would also be welcomed if you wanted to contribute, the change would be in XStreamStreamingChangeEventSource#resolvePosVersion where POS_VERSION_V1 would be returned for Oracle 11 and Oracle 12.1 only.
CC
You received this message because you are subscribed to the Google Groups "debezium" group.
To unsubscribe from this group and stop receiving emails from it, send an email to debezium+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/debezium/CANRorfdHaB4vwOmmFCw93N%2B6QsYYZV2hgXovSOV8p0Bqnd9eXQ%40mail.gmail.com.