Details
-
Bug
-
Resolution: Done
-
Major
-
2.1.3.Final
-
None
-
False
-
None
-
False
Description
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
Attachments
Issue Links
- 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