Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-3151

Final stage of snapshot analyzes tables not present in table.include.list thus stumbles upon unsupported XMLTYPE table

    XMLWordPrintable

    Details

      Description

      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.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              ccranfor Chris Cranford
              Reporter:
              ant0nk Anton Kondratev
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: