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

Relax parsing of Heap and Index organized DDL clauses

    XMLWordPrintable

Details

    • Hide

      We have several connectors running into the exactly same exception.

      Before this error appeared the connectors run into another error (org.apache.kafka.common.errors.GroupAuthorizationException: Not authorized to access group) which was fixed afterwords. After the fix the connectors were deleted and redeployed with the same name. First, the connectors were running properly for about an hour until we encountered this ParsingException. I don't know if the redeployment has anything to do with this error.  

      Show
      We have several connectors running into the exactly same exception. Before this error appeared the connectors run into another error (org.apache.kafka.common.errors.GroupAuthorizationException: Not authorized to access group) which was fixed afterwords. After the fix the connectors were deleted and redeployed with the same name. First, the connectors were running properly for about an hour until we encountered this ParsingException. I don't know if the redeployment has anything to do with this error.  

    Description

      We run into the ParsingException: DDL statement couldn't be parsed. See attached trace file for detailed message. The TT-table is a temporary table. This table should never be mined by the logger at all.

      The connector is configured as follows:
      {
          "name": "src-ase1-22041",
          "config":

      {         "connector.class": "io.debezium.connector.oracle.OracleConnector",         "key.converter": "io.confluent.connect.avro.AvroConverter",         "key.converter.schema.registry.url": "http://swwkafi01c1.suvanet.ch:8081",         "value.converter": "io.confluent.connect.avro.AvroConverter",         "value.converter.schema.registry.url": "http://swwkafi01c1.suvanet.ch:8081",         "database.url": "jdbc:oracle:thin:@//H50L160.suvanet.ch:1521/ASEI01A.suvanet.ch",         "database.user": "DSL_RO",         "database.password": "ENC[AES256_GCM,data:SX8H8wgaQWvqJw==,iv:D2XO64g455zV27Xo5dJy4TNy+lEzDyFKcgBe/gUBrFY=,tag:wwJz1ylVyYJHbBYtIaer/Q==,type:str]",         "database.dbname": "ASEI01A",         "database.server.name": "ASE1",         "table.include.list": "ASEDBUSR.ABRDVRS,ASEDBUSR.ABRDVRSUNT,ASEDBUSR.ACTIVITY,ASEDBUSR.ADRESSE,ASEDBUSR.ADRESSEROLE,ASEDBUSR.ANTRFRAGENANTW,ASEDBUSR.ARBUN,ASEDBUSR.BANK,ASEDBUSR.BEZIEHUNG,ASEDBUSR.BILANZAUSGLEICH,ASEDBUSR.BUCHSTOFFV,ASEDBUSR.BUCHUNGSTOFF",         "snapshot.fetch.size": "10000",         "event.processing.failure.handling.mode": "fail",         "tombstones.on.delete": true,         "message.key.columns": "ASEDBUSR.ABRDVRS:PKEY;ASEDBUSR.ABRDVRSUNT:PKEY;ASEDBUSR.ACTIVITY:PKEY;ASEDBUSR.ADRESSE:PKEY;ASEDBUSR.ADRESSEROLE:PKEY;ASEDBUSR.ANTRFRAGENANTW:PKEY;ASEDBUSR.ARBUN:PKEY;ASEDBUSR.BANK:PKEY;ASEDBUSR.BEZIEHUNG:PKEY;ASEDBUSR.BILANZAUSGLEICH:PKEY;ASEDBUSR.BUCHSTOFFV:PKEY;ASEDBUSR.BUCHUNGSTOFF:PKEY",         "log.mining.strategy": "online_catalog",         "log.mining.archive.destination.name": "LOG_ARCHIVE_DEST_10",         "lob.enabled": true,         "time.precision.mode": "connect",         "tasks.max": "1",         "database.history.kafka.bootstrap.servers": "swwkafi01.suvanet.ch:9092",         "database.history.kafka.topic": "ase.schema-changes.asedbusr",         "database.history.consumer.security.protocol": "SASL_SSL",         "database.history.producer.security.protocol": "SASL_SSL",         "database.history.consumer.sasl.mechanism": "SCRAM-SHA-512",         "database.history.producer.sasl.mechanism": "SCRAM-SHA-512",         "database.history.consumer.sasl.jaas.config": "ENC[AES256_GCM,data:S0ndo7TOp2KhWyQe1MlaFxN/nPUtM66n66Q2irEqfqpHp3U+8dvFPXPksDrCdAtB5EmoGXwdoQ/ImVZLpXBZ97HJXl1muALnTwFiQB//xFYcab/zOj6JiPoKC0E8t3n0YTDhUsNgiO9MqyH4FmGSgFb6Mg==,iv:I/1ELyacwL8CZWcdVe1O+Ng5wdLMu514DhRSlus8A7k=,tag:K+6lIFDkJSYJN92F9IAHWw==,type:str]",         "database.history.producer.sasl.jaas.config": "ENC[AES256_GCM,data:vyf0G9/CbHUEE+P09d2PXgxnBKpCVgbPHbM9t0tKKKbiWu7au5x/4iCCAeS1V5YTRxGt2E1inSXCl6kA6qFLR5eYWeRt6NY6dJrj0SoPkqUki1ekh5n6Wy+CH2WvoTFOluG/qMfZ/t+peqN6skEJ1Tl95g==,iv:670rbvcYVeKtxCFO3aiJaxNcskZLx9Yd91248m5CZGc=,tag:HyRCBFjS6wtGKEsHZvox2Q==,type:str]",         "transforms": "unwrap",         "transforms.unwrap.type": "io.debezium.transforms.ExtractNewRecordState",         "transforms.unwrap.add.fields": "source.table:META_SRC_TABLENAME,source.ts_ms:META_SRC_TS,op:META_SRC_OP,source.scn:META_SRC_SCN,source.snapshot:META_SRC_SNAPSHOT",         "transforms.unwrap.delete.handling.mode": "rewrite",         "transforms.unwrap.drop.tombstones": false     }

      ,
          "sops": {
              "kms": null,
              "gcp_kms": null,
              "azure_kv": null,
              "hc_vault": null,
              "age": null,
              "lastmodified": "2022-01-31T15:41:07Z",
              "mac": "ENC[AES256_GCM,data:5wKnJVDKMvEkBt59Aa816D3JWvGgwvrLuXo7sLMg/vrKlpIuMHoyInvMkPyebJJ26Jgd9dPiR8+kvXCbApCxsJhqGOtJ6Ufluuint0oBHVK6+DoqqJTw+voF0fKSjPYuZLyuGcQkj5HKmI3TCKnuSvs9ZaxINARqAHKSBJty/X8=,iv:k/pvfDDnpSSbpZ0S00qAZ/SOt3/dvqvPh7OudvP0t5g=,tag:4VyrlAiNBGxE79/NHeBRDw==,type:str]",
              "pgp": [
                 

      {                 "created_at": "2022-01-31T15:40:37Z",                 "enc": "-----BEGIN PGP MESSAGE-----\n\nhQEMA243CXYlIAr3AQf/e3LH81rHhZOAGucef5Wt/JaVmWJLeykh3NZ1FwGf/Nw/\nzjzXi/HyE5l3j8erOiDR5UgCrtrFS44HH9QkS48Z4l+WZ+VnDOEu9/ONokpYQcyZ\n79KcYxPPp2CiAIVfm6VxKtPoxMxoUwIyrewIK6R88TROwBK5mQvsF2ba9bouADJz\ngOP4Vc4CVAgOhtCH0KsUvTUAmORbl3EbM9V4mbEoXGdpYKNcYgzxUlSbVXQO7zdQ\nA0r4G8tmejn7VixgBjisK3ka6wv8YStY89TVavlM6xMyC6ae9kobKlchb35Ak8xs\n4q4a+3va23aOm6BT7HMB70zGfmCelnywoMQ37/8X39JcAaIrqzSBvlUg0K8eap3m\ntlW/5uD/bAV54UYWF/On/1GYQPNAP7UGv3443qj+xbbW7343eHd3+IpR5BAdE5HI\nXDZD+WKBCG8u6pFcDbO8tb3NERQd2fTqakk2A5k=\n=EXmG\n-----END PGP MESSAGE-----\n",                 "fp": "F7067DB106402AABEBEF13F8C6E64E19DC477D85"             }

              ],
              "encrypted_regex": "(database.password|database.history.consumer.sasl.jaas.config|database.history.producer.sasl.jaas.config)",
              "version": "3.7.1"
          }
      }

      Attachments

        Activity

          People

            ccranfor@redhat.com Chris Cranford
            renerh René Rütter
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: