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

io.debezium.text.ParsingException: DDL statement couldn't be parsed

    XMLWordPrintable

Details

    • False
    • None
    • False

    Description

      org.apache.kafka.connect.errors.ConnectException: An exception occurred in the change event producer. This connector will be stopped.
              at io.debezium.pipeline.ErrorHandler.setProducerThrowable(ErrorHandler.java:50)
              at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:199)
              at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:59)
              at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:174)
              at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:141)
              at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:109)
              at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
              at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
              at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
              at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
              at java.base/java.lang.Thread.run(Thread.java:829)
      Caused by: Multiple parsing errors
      io.debezium.text.ParsingException: DDL statement couldn't be parsed. Please open a Jira issue with the statement ' create table "DVSADM".CMP3$58238005  nocompress tablespace "DVS_PROOF" nologging lob (VALUE) store as (tablespace "DVS_PROOF" enable storage in row nocache nologging) as select /*+ DYNAMIC_SAMPLING(0) FULL("DVSADM"."DVS_ARCHIVE") */ *  from "DVSADM"."DVS_ARCHIVE"  sample block( 6.734) mytab ;'
      no viable alternative at input '(VALUE) store as (tablespace "DVS_PROOF"'
      io.debezium.text.ParsingException: DDL statement couldn't be parsed. Please open a Jira issue with the statement ' create table "DVSADM".CMP3$58238005  nocompress tablespace "DVS_PROOF" nologging lob (VALUE) store as (tablespace "DVS_PROOF" enable storage in row nocache nologging) as select /*+ DYNAMIC_SAMPLING(0) FULL("DVSADM"."DVS_ARCHIVE") */ *  from "DVSADM"."DVS_ARCHIVE"  sample block( 6.734) mytab ;'
      mismatched input 'VALUE' expecting {'SELECT', '('}
      io.debezium.text.ParsingException: DDL statement couldn't be parsed. Please open a Jira issue with the statement ' create table "DVSADM".CMP3$58238005  nocompress tablespace "DVS_PROOF" nologging lob (VALUE) store as (tablespace "DVS_PROOF" enable storage in row nocache nologging) as select /*+ DYNAMIC_SAMPLING(0) FULL("DVSADM"."DVS_ARCHIVE") */ *  from "DVSADM"."DVS_ARCHIVE"  sample block( 6.734) mytab ;'
      extraneous input 'as' expecting ...................

      Attachments

        Activity

          People

            anmohant Anisha Mohanty
            mohamed.icda Mohammed Mohammed
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: