-
Bug
-
Resolution: Duplicate
-
Minor
-
None
-
None
-
None
-
False
-
False
-
Undefined
-
I've wired Debezium Postgres connector and I can see the data is flowing through. All fields are working correctly (including jsonb), but all my ltree fields (I have 3 in my test table) that are coming out as null. I can see in Debezium's Postgres connector documentation that ltree is supported.
Running in AWS with RDS Postgres 11.8 + MSK Kafka 2.7.0. Kafka Connect (kafka_2.13-2.7.0) & Debezium 1.4 are running in an ec2 instance.
ccranfor@redhat.com suggested that I turned on debug logging for `io.debezium` and I got the following output:
[2021-02-15 13:34:41,269] DEBUG Unknown column type ltree for column path – ignoring (io.debezium.connector.postgresql.connection.AbstractColumnValue:201) [2021-02-15 13:34:41,269] DEBUG Unknown column type ltree for column path – ignoring (io.debezium.connector.postgresql.connection.AbstractColumnValue:201)
As suggested this indicates that include.unknown.datatypes is set to false.
However, no such warning is shown when I have a normal log level.
After setting the said property, I can see ltree columns are flowing through.
- is duplicated by
-
DBZ-6524 [PostgreSQL] LTree data is not being captured by streaming
- Closed