-
Bug
-
Resolution: Done
-
Major
-
1.9.5.Final, 2.0.0.Beta1
-
None
-
False
-
None
-
False
Bug report
For bug reports, provide this information, please:
The connector throws exception:
DDL statement couldn't be parsed. Please open a Jira issue with the statement 'revoke select on ORDERS from SV_DEBEZIUM_CDC;
What Debezium connector do you use and what version?
1.9.5.Final
What is the connector configuration?
{
"name": "debezium-orders-connector",
"config": {
"connector.class" : "io.debezium.connector.oracle.OracleConnector",
"tasks.max" : "1",
"database.server.name" : "debezium-orders-connector",
"database.hostname" : "db_server_ip",
"database.url": "jdbc:oracle:thin:@db_server_ip:1521:ORCLCDB",
"database.user" : "connector_db_user",
"database.password" : "connector_db_pwd",
"database.dbname" : "ORCLCDB",
"database.connection.adapter" : "logminer",
"log.mining.strategy": "online_catalog",
"lob.enabled": "true",
"database.history.kafka.bootstrap.servers" : "kafka:9092",
"database.history.kafka.topic": "local.db.history-changes",
"snapshot.mode": "schema_only",
"table.include.list": "C##TESTER.ORDERS",
"decimal.handling.mode": "string",
"transforms": "Reroute, RerouteSchemaTopic",
"transforms.Reroute.type": "io.debezium.transforms.ByLogicalTableRouter",
"transforms.Reroute.topic.regex": ".*(.ORDERS)",
"transforms.Reroute.topic.replacement": "local.order-out",
"transforms.RerouteSchemaTopic.type": "io.debezium.transforms.ByLogicalTableRouter",
"transforms.RerouteSchemaTopic.topic.regex": "debezium-orders-connector",
"transforms.RerouteSchemaTopic.topic.replacement": "local.db.schema-changes",
"key.converter": "org.apache.kafka.connect.json.JsonConverter",
"key.converter.schemas.enable": "false",
"value.converter": "io.confluent.connect.avro.AvroConverter",
"value.converter.schema.registry.url": "http://schema-registry:8081",
"value.converter.schemas.enable": "false",
"database.history.store.only.captured.tables.ddl": "true"
}
}
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?
Did not check
Do you have the connector logs, ideally from start till finish?
attached
- account is impacted by
-
DBZ-5614 DDL statement couldn't be parsed. Please open a Jira issue with the statement 'create table test_json_clob(id char(3) primary key, content CLOB CONSTRAINT test_json_clob_ensure_json CHECK (content IS JSON));'
- Closed