Details
-
Bug
-
Resolution: Obsolete
-
Major
-
None
-
None
-
None
-
False
-
False
-
Undefined
-
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