-
Bug
-
Resolution: Done
-
Major
-
2.1.3.Final
-
None
-
False
-
None
-
False
Bug report
For bug reports, provide this information, please:
What Debezium connector do you use and what version?
2.1.3.Final
What is the connector configuration?
{
"connector.class": "io.debezium.connector.oracle.OracleConnector",
"schema.history.internal.consumer.sasl.jaas.config": "${secrets:draak/draak-connect-user:sasl.jaas.config}",
"transforms": "FilterFields",
"schema.history.internal.producer.security.protocol": "SASL_SSL",
"schema.history.internal.producer.ssl.truststore.password": "${secrets:draak/draak-cluster-ca-cert:ca.password}",
"signal.data.collection": "AECBOFF3.P1QMS.QMS_DEBEZIUM_SIGNAL",
"heartbeat.topics.prefix": "__debezium-heartbeat",
"key.converter": "org.apache.kafka.connect.json.JsonConverter",
"schema.history.internal.producer.sasl.mechanism": "SCRAM-SHA-512",
"database.dbname": "aecboff3",
"database.user": "${secrets:draak/debezium-credentials:dbz_user}",
"transforms.FilterFields.type": "com.ahold.debezium.connect.transformation.FilterTableFieldsTransformation",
"heartbeat.interval.ms": "30000",
"schema.history.internal.kafka.bootstrap.servers": "${env:KAFKA_CONNECT_BOOTSTRAP_SERVERS}",
"key.converter.schemas.enable": "false",
"value.converter.schema.registry.url": "http://schema-registry-url",
"database.password": "${secrets:draak/debezium-credentials:dbz_password}",
"value.converter.schemas.enable": "false",
"name": "debezium-acc-boff-source",
"schema.history.internal.consumer.sasl.mechanism": "SCRAM-SHA-512",
"schema.history.internal.consumer.ssl.truststore.type": "PKCS12",
"schema.history.internal.producer.sasl.jaas.config": "${secrets:draak/draak-connect-user:sasl.jaas.config}",
"max.batch.size": "20480",
"snapshot.mode": "schema_only",
"schema.history.internal.consumer.security.protocol": "SASL_SSL",
"max.queue.size": "81290",
"incremental.snapshot.chunk.size": "10000",
"tasks.max": "1",
"log.mining.strategy": "redo_log_catalog",
"schema.history.internal.store.only.captured.tables.ddl": "true",
"tombstones.on.delete": "false",
"topic.prefix": "ACC.BOFF",
"decimal.handling.mode": "string",
"schema.history.internal.consumer.ssl.truststore.location": "/opt/kafka/external-configuration/cluster-ca-cert/ca.p12",
"schema.history.internal.kafka.topic": "acc.boff.history-changes",
"transforms.FilterFields.error.mode": "throw_error",
"transforms.FilterFields.cache.expiration.minutes": "60",
"value.converter": "io.confluent.connect.avro.AvroConverter",
"log.mining.transaction.retention.hours": "5",
"transforms.FilterFields.table.exclude.list": "P1QMS.QMS_DEBEZIUM_SIGNAL",
"log.mining.batch.size.max": "500000",
"database.connection.adapter": "logminer",
"database.url": "${secrets:draak/debezium-credentials:boff_url}",
"schema.history.internal.consumer.ssl.truststore.password": "${secrets:draak/draak-cluster-ca-cert:ca.password}",
"schema.history.internal.producer.ssl.truststore.type": "PKCS12",
"transforms.FilterFields.metadata.service.url": "http://metainfo-service",
"schema.name.adjustment.mode": "avro",
"schema.history.internal.producer.ssl.truststore.location": "/opt/kafka/external-configuration/cluster-ca-cert/ca.p12",
"table.include.list": "P1BOFF.BOFF_ACCOUNTING,P1BOFF.BOFF_DELIVERY_RUN,P1BOFF.BOFF_DELIVERY_RUN_ORS_CVRS,P1BOFF.BOFF_LOCATION_DELIVERY,P1BOFF.BOFF_ORDER,P1BOFF.BOFF_ORDER_ITEM_PACKAGING,P1BOFF.BOFF_ORDER_LINE,P1BOFF.BOFF_ORDER_LINE_PROMO,P1BOFF.BOFF_VEHICLE_TYPE,P1EFIN.CHECKSUMS_PAYMENTS,P1QMS.QMS_DEBEZIUM_SIGNAL"
}
What is the captured database version and mode of depoyment?
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.13.0.0.0
What behaviour do you expect?
no errors
What behaviour do you see?
errors in logs - connector stops
Do you see the same behaviour using the latest relesead Debezium version?
Checked only with 2.1.3.Final
Do you have the connector logs, ideally from start till finish?
Attached
- is cloned by
-
DBZ-6555 DDL statement couldn't be parsed - Oracle connector 2.1.3.Final
- Resolved
- links to
-
RHEA-2023:120698 Red Hat build of Debezium 2.3.4 release