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

Relax parsing of Heap and Index organized DDL clauses

XMLWordPrintable

    • False
    • False
    • 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.  

      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"
          }
      }

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

                Created:
                Updated:
                Resolved: