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

when setting slot.name for postgres connector using wal2json plugin, if any upper case letter in the slot name, the slot name will be created in lower case but causes slotname already exists error

    XMLWordPrintable

Details

    • Bug
    • Resolution: Obsolete
    • Major
    • None
    • None
    • postgresql-connector
    • None
    • False
    • False
    • Undefined
    • Hide

      1. in connector json file, specify:

      "slot.name" = "debeziumSlot2"

      2. when connector starts, it will create the rep slot, then error out saying the said rep slot already exists. in db you can see slot "debeziumslot2" is created but not active. 

      3. clean up everything

      4. change to "slot.name" = "debeziumslot2"

      5. no more errors

      Show
      1. in connector json file, specify: "slot.name" = "debeziumSlot2" 2. when connector starts, it will create the rep slot, then error out saying the said rep slot already exists. in db you can see slot "debeziumslot2" is created but not active.  3. clean up everything 4. change to "slot.name" = "debeziumslot2" 5. no more errors

    Description

      If an upper letter is used in slot.name, the slot name will be created in postgres db with all lower letters. However when connector is started, it doesn't recognize the said slot and kept erroring out saying the said slot already exists and task would fail. 

       

      Sample log:

      2020-09-15 15:31:45,413 INFO Postgres|dbserver1|postgres-connector-task Obtained valid replication slot ReplicationSlot [active=false, latestFlushedLsn=null, catalogXmin=null] [io.debezium.connector.postgresql.connection.PostgresConnection]
      2020-09-15 15:31:45,416 INFO Postgres|dbserver1|postgres-connector-task Creating replication slot with command CREATE_REPLICATION_SLOT debeziumSlotForColumnFilter LOGICAL wal2json [io.debezium.connector.postgresql.connection.PostgresReplicationConnection]
      2020-09-15 15:31:45,439 ERROR Postgres|dbserver1|postgres-connector-task Producer failure [io.debezium.pipeline.ErrorHandler]
      io.debezium.jdbc.JdbcConnectionException: ERROR: replication slot "debeziumslotforcolumnfilter" already exists

      Attachments

        Activity

          People

            ccranfor@redhat.com Chris Cranford
            highlowhighlow P H (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: