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

          is related to

          Bug - A problem that impairs or prevents the functions of the product. DBZ-3057 SQLException for Global temp tables from OracleDatabaseMetaData.getIndexInfo() makes Debezium snapshotting fail

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed

          Activity

            People

              ccranfor@redhat.com Chris Cranford
              ant0nk Anton Kondratev (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: