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

Postgres connector fails with array columns

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: 0.5.1
    • Fix Version/s: 0.5.2
    • Component/s: postgresql-connector
    • Labels:
      None
    • Environment:

      Using Debezium Docker images + Embedded Engine client running on OSX with Java 1.8

    • Steps to Reproduce:
      Hide

      1. Create a database table with an array column and a complex type, e.g:

      create table test_arrays
      (
      	array_col bigint[] default '{}'::bigint[]
      )
       
      2. Start Debezium (in my case I used the embedded engine but I doubt it will be any different if I use Kafka Connect).
      

      Show
      1. Create a database table with an array column and a complex type, e.g: create table test_arrays ( array_col bigint[] default '{}'::bigint[] )   2. Start Debezium (in my case I used the embedded engine but I doubt it will be any different if I use Kafka Connect).

      Description

      All my Postgres array columns result in Debezium reporting the following on startup:

      2017-07-11 23:48:35,220 WARN Postgres|localhost|records-snapshot-producer Unexpected JDBC type '2003' for column 'array_col' that will be ignored [io.debezium.relational.TableSchemaBuilder]

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  jarym Em Em
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: