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

Oracle LogMiner DdlParser Error

XMLWordPrintable

      Hi, I got an error using oracle logmine(1.6 final), I try skip this error by setingĀ database.history.store.only.captured.tables.ddl, but it would occur other error about dmlParser(because table is null). So is Any other way to get the table info?(such as using DatabaseMetadata and not using ddl sql)

      [debezium-oracleconnector-2893f371-db9d-4a91-8532-cb8213e02781-change-event-source-coordinator] ERROR io.debezium.pipeline.ErrorHandler - Producer failure
      io.debezium.text.ParsingException: DDL statement couldn't be parsed. Please open a Jira issue with the statement '
      CREATE TABLE "HR"."COUNTRIES"
      ( "COUNTRY_ID" CHAR(2) CONSTRAINT "COUNTRY_ID_NN" NOT NULL ENABLE,
      "COUNTRY_NAME" VARCHAR2(40),
      "REGION_ID" NUMBER,
      CONSTRAINT "COUNTRY_C_ID_PK" PRIMARY KEY ("COUNTRY_ID") ENABLE,
      SUPPLEMENTAL LOG DATA (ALL) COLUMNS,
      CONSTRAINT "COUNTR_REG_FK" FOREIGN KEY ("REGION_ID")
      REFERENCES "HR"."REGIONS" ("REGION_ID") ENABLE
      ) ORGANIZATION INDEX NOCOMPRESS
      ;'
      mismatched input 'ORGANIZATION' expecting {'AS', ';'}
      at io.debezium.antlr.ParsingErrorListener.syntaxError(ParsingErrorListener.java:43)
      at org.antlr.v4.runtime.ProxyErrorListener.syntaxError(ProxyErrorListener.java:41)
      at org.antlr.v4.runtime.Parser.notifyErrorListeners(Parser.java:544)
      at org.antlr.v4.runtime.DefaultErrorStrategy.reportInputMismatch(DefaultErrorStrategy.java:327)
      at org.antlr.v4.runtime.DefaultErrorStrategy.reportError(DefaultErrorStrategy.java:139)
      at io.debezium.ddl.parser.oracle.generated.PlSqlParser.create_table(PlSqlParser.java:49106)
      at io.debezium.ddl.parser.oracle.generated.PlSqlParser.unit_statement(PlSqlParser.java:2421)
      at io.debezium.connector.oracle.antlr.OracleDdlParser.parseTree(OracleDdlParser.java:68)
      at io.debezium.connector.oracle.antlr.OracleDdlParser.parseTree(OracleDdlParser.java:32)
      at io.debezium.antlr.AntlrDdlParser.parse(AntlrDdlParser.java:82)
      at io.debezium.connector.oracle.antlr.OracleDdlParser.parse(OracleDdlParser.java:63)
      at io.debezium.connector.oracle.OracleSchemaChangeEventEmitter.emitSchemaChangeEvent(OracleSchemaChangeEventEmitter.java:81)
      at io.debezium.pipeline.EventDispatcher.dispatchSchemaChangeEvent(EventDispatcher.java:297)
      at io.debezium.connector.oracle.logminer.LogMinerQueryResultProcessor.dispatchSchemaChangeEventAndGetTableForNewCapturedTable(LogMinerQueryResultProcessor.java:326)
      at io.debezium.connector.oracle.logminer.LogMinerQueryResultProcessor.processResult(LogMinerQueryResultProcessor.java:259)
      at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:187)
      at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:63)
      at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:159)
      at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:122)
      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: org.antlr.v4.runtime.InputMismatchException
      at org.antlr.v4.runtime.DefaultErrorStrategy.sync(DefaultErrorStrategy.java:270)
      at io.debezium.ddl.parser.oracle.generated.PlSqlParser.create_table(PlSqlParser.java:49089)
      ... 18 more

            ccranfor@redhat.com Chris Cranford
            pandacheng58 Cheng Zhang (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: