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

ParsingException when adding a new table to an existing oracle connector

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major 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);

      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.

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

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

              Created:
              Updated:
              Resolved: