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

DDL ParsingException "mismatched input 'sharing'" for create table syntax.

    XMLWordPrintable

Details

    Description

      Yesterday after we fetched and pulled the latest code from master. 

      It ran several hours and hit this exception.

      version: debezium-connector-oracle-1.6.0-SNAPSHOT

      our oracle DB version: 19c

       

       [2021-05-21 07:26:54,500] ERROR Mining session stopped due to the {} (io.debezium.connector.oracle.logminer.LogMinerHelper:491)
      io.debezium.text.ParsingException: DDL statement couldn't be parsed. Please open a Jira issue with the statement 'create global temporary table sys.ora_temp_1_ds_1550399 sharing=none on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring xmlindex_sel_idx_tbl opt_param('optimizer_inmemory_aware' 'false') no_substrb_pad */"ENTRYUUID", rowid SYS_DS_ALIAS_0 from "IDENTITYDB"."OAUTH2_CLIENT_CHANGE_LOGS" sample ( 10.0000000000) t WHERE 1 = 2;'
      mismatched input 'sharing' expecting {'AS', 'CACHE', 'COLUMN', 'DISABLE', 'ENABLE', 'FILESYSTEM_LIKE_LOGGING', 'FLASHBACK', 'INITRANS', 'LOB', 'LOGGING', 'NESTED', 'NOCACHE', 'NOLOGGING', 'NO', 'NOPARALLEL', 'NOROWDEPENDENCIES', 'OF', 'ON', 'PARALLEL', 'PARTITION', 'PCTFREE', 'PCTUSED', 'RESULT_CACHE', 'ROWDEPENDENCIES', 'ROW', 'SEGMENT', 'STORAGE', 'TABLESPACE', 'VARRAY', 'XMLTYPE', '(', ';'}
       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:49034)
       at io.debezium.ddl.parser.oracle.generated.PlSqlParser.unit_statement(PlSqlParser.java:2416)
       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.processResult(LogMinerQueryResultProcessor.java:166)
       at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:198)
       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:48995)
       ... 16 more
      [2021-05-21 07:26:54,515] ERROR Producer failure (io.debezium.pipeline.ErrorHandler:31)
       
       

       

       

       

       

      Attachments

        Issue Links

          Activity

            People

              ccranfor@redhat.com Chris Cranford
              shiawu John Wu (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: