-
Bug
-
Resolution: Done
-
Major
-
1.5.0.Alpha1
-
None
I'm trying to replicate limited list of tables stated in table.include.list. But during final stage of snapshot I get error:
ERROR Producer failure (io.debezium.pipeline.ErrorHandler:31)ERROR Producer failure (io.debezium.pipeline.ErrorHandler:31)io.debezium.DebeziumException: java.lang.IllegalArgumentException: The column "SYS_NC_OID$" is referenced as PRIMARY KEY, but a matching column is not defined in table "IBS.head590_TAB"! at io.debezium.pipeline.source.AbstractSnapshotChangeEventSource.execute(AbstractSnapshotChangeEventSource.java:82) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:105) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748)Caused by: java.lang.IllegalArgumentException: The column "SYS_NC_OID$" is referenced as PRIMARY KEY, but a matching column is not defined in table "IBS.head590_TAB"! at io.debezium.relational.TableEditorImpl.lambda$updatePrimaryKeys$0(TableEditorImpl.java:105) at java.util.ArrayList.removeIf(ArrayList.java:1415) at io.debezium.relational.TableEditorImpl.updatePrimaryKeys(TableEditorImpl.java:101) at io.debezium.relational.TableEditorImpl.create(TableEditorImpl.java:254) at io.debezium.relational.Tables.lambda$overwriteTable$2(Tables.java:190) at io.debezium.util.FunctionalReadWriteLock.write(FunctionalReadWriteLock.java:84) at io.debezium.relational.Tables.overwriteTable(Tables.java:184) at io.debezium.jdbc.JdbcConnection.readSchema(JdbcConnection.java:1197) at io.debezium.connector.oracle.OracleConnection.readSchema(OracleConnection.java:216) at io.debezium.connector.oracle.OracleSnapshotChangeEventSource.readTableStructure(OracleSnapshotChangeEventSource.java:235) at io.debezium.relational.RelationalSnapshotChangeEventSource.doExecute(RelationalSnapshotChangeEventSource.java:126) at io.debezium.pipeline.source.AbstractSnapshotChangeEventSource.execute(AbstractSnapshotChangeEventSource.java:71) ... 6 more
Table "IBS.head590_TAB" is not listed in table.include.list so I can't understand why it is being analized at all. DDL of the table is:
create table IBS.head590_TAB of XMLTYPE
So I guess there is also a problem with support of XMLTYPE tables.
- is related to
-
-
- Closed
-