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

No warning displayed when include.unknown.datatypes=false and ltree data type found

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Minor Minor
    • None
    • None
    • postgresql-connector
    • 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.

       

              Unassigned Unassigned
              victorhadianto Victor Hadianto (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: