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

DDL ParsingException on alter table

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 1.6.0.Beta2
    • 1.6.0.Beta1
    • oracle-connector
    • None

    Description

      Hi ccranfor@redhat.com we did a fetch on latest master build on Sat morning (May 22nd) to pick up the fix https://issues.redhat.com/browse/DBZ-3549.

      It ran almost 2 days , and hit this new exception. 

       

      [2021-05-24 08:00:11,847] ERROR Mining session stopped due to the {} (io.debezium.connector.oracle.logminer.LogMinerHelper:491)[2021-05-24 08:00:11,847] ERROR Mining session stopped due to the {} (io.debezium.connector.oracle.logminer.LogMinerHelper:491) io.debezium.text.ParsingException: Trying to alter table IDBTSTXHA.WEBEX.COM.SYS.ORA_TEMP_2_DS_1581017, which does not exist. Query: alter table sys.ora_temp_2_ds_1581017 parallel 8;         at io.debezium.connector.oracle.antlr.listener.AlterTableParserListener.enterAlter_table(AlterTableParserListener.java:66)         at io.debezium.ddl.parser.oracle.generated.PlSqlParser$Alter_tableContext.enterRule(PlSqlParser.java:63924)         at io.debezium.antlr.ProxyParseTreeListenerUtil.delegateEnterRule(ProxyParseTreeListenerUtil.java:46)         at io.debezium.connector.oracle.antlr.listener.OracleDdlParserListener.enterEveryRule(OracleDdlParserListener.java:46)         at org.antlr.v4.runtime.tree.ParseTreeWalker.enterRule(ParseTreeWalker.java:41)         at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:25)         at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:28)         at io.debezium.antlr.AntlrDdlParser.parse(AntlrDdlParser.java:87)         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) [2021-05-24 08:00:11,848] ERROR Producer failure (io.debezium.pipeline.ErrorHandler:31) io.debezium.text.ParsingException: Trying to alter table IDBTSTXHA.WEBEX.COM.SYS.ORA_TEMP_2_DS_1581017, which does not exist. Query: alter table sys.ora_temp_2_ds_1581017 parallel 8;         at io.debezium.connector.oracle.antlr.listener.AlterTableParserListener.enterAlter_table(AlterTableParserListener.java:66)         at io.debezium.ddl.parser.oracle.generated.PlSqlParser$Alter_tableContext.enterRule(PlSqlParser.java:63924)         at io.debezium.antlr.ProxyParseTreeListenerUtil.delegateEnterRule(ProxyParseTreeListenerUtil.java:46)         at io.debezium.connector.oracle.antlr.listener.OracleDdlParserListener.enterEveryRule(OracleDdlParserListener.java:46)         at org.antlr.v4.runtime.tree.ParseTreeWalker.enterRule(ParseTreeWalker.java:41)         at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:25)         at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:28)
       

       

       

       

       

      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: