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

ParsingException when adding a new table to an existing oracle connector

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 1.9.0.CR1
    • 1.9.0.Beta1
    • oracle-connector
    • None
    • False
    • None
    • False
    • Hide

      I used the debezium/connect:1.9 docker image.

      1. Install connector with only the signaling table in the "table.include.list".

      curl -i -X POST -H "Accept:application/json" -H "Content-Type:application/json" localhost:8083/connectors/ -d@connector1.json

      2. Delete connector

      curl -i -X DELETE -H "Accept:application/json" localhost:8083/connectors/ora_con

      3. Add the same connector again with an extra table in the "table.include.list".

      curl -i -X POST -H "Accept:application/json" -H "Content-Type:application/json" localhost:8083/connectors/ -d@connector2.json

      4. Insert data into new table

      INSERT INTO MYUSER.ITEMS (id, name, description, cost) VALUES (1, 'name', 'description', 2);
      Show
      I used the debezium/connect:1.9 docker image. 1. Install connector with only the signaling table in the "table.include.list" . curl -i -X POST -H "Accept:application/json" -H "Content-Type:application/json" localhost:8083/connectors/ -d@connector1.json 2. Delete connector curl -i -X DELETE -H "Accept:application/json" localhost:8083/connectors/ora_con 3. Add the same connector again with an extra table in the "table.include.list". curl -i -X POST -H "Accept:application/json" -H "Content-Type:application/json" localhost:8083/connectors/ -d@connector2.json 4. Insert data into new table INSERT INTO MYUSER.ITEMS (id, name, description, cost) VALUES (1, 'name' , 'description' , 2);

    Description

      When adding a new table to an existing oracle connector a ParsingException is thrown as soon as data is inserted to the newly added table.

       

      io.debezium.text.ParsingException: DDL statement couldn't be parsed. Please open a Jira issue with the statement '
  CREATE TABLE "MYUSER"."ITEMS" 
   (    "ID" NUMBER(4,0) GENERATED BY DEFAULT ON NULL AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 101 CACHE 20 NOORDER  NOCYCLE  NOKEEP  NOSCALE  NOT NULL ENABLE, 
    "NAME" VARCHAR2(255) NOT NULL ENABLE, 
    "DESCRIPTION" VARCHAR2(512), 
    "COST" FLOAT(126), 
     PRIMARY KEY ("ID")
  USING INDEX  ENABLE, 
     SUPPLEMENTAL LOG DATA (ALL) COLUMNS
   ) ;'mismatched input 'MINVALUE' expecting {')', ','}

       

      However, if the table is part of the initial connector configuration everything works fine. So the problem seems not to be related to the create table statement.

      I have created another issue (DBZ-4834). It might be related. It has a different error but basically the same steps to reproduce.

      I've attached the trace log and the connector configurations.

      Attachments

        1. ddl.log
          12.71 MB
        2. connector2.json
          0.8 kB
        3. connector1.json
          0.8 kB

        Activity

          People

            ccranfor@redhat.com Chris Cranford
            hendrik.luedemann Hendrik Lüdemann (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: