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

DDL couldn't be parsed: 'analyze table schema.table estimate statistics sample 5 percent;'

XMLWordPrintable

      We are running debezium 1.6 on an Oracle 19c database. Right after the connector switched from snapshot to streaming mode debezium crashed with the following error:

       

      Caused by: io.debezium.text.ParsingException: DDL statement couldn't be parsed. Please open a Jira issue with the statement 'analyze table schema.table estimate statistics sample 5 percent;'

      The analyze statement looks fine to me and I can't spot any issue with the table DDL:

      CREATE TABLE "schema"."table"
( "col1" DATE NOT NULL ENABLE,
"col2" NUMBER(*,0),
"col3" VARCHAR2(70),
"col4" VARCHAR2(70),
"col5" VARCHAR2(8),
"col6" VARCHAR2(1),
"col7" VARCHAR2(250) NOT NULL ENABLE
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 778240 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "DATA" ;

            ccranfor@redhat.com Chris Cranford
            rc.hueber@gmail.com Robin Hueber (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: