clickhouse-sink-connector icon indicating copy to clipboard operation
clickhouse-sink-connector copied to clipboard

Published 20 hours ago • verified publisher icon Altinity

Support when_needed snapshot.mode in postgreSQL

Open subkanthi opened this issue 10 months ago • 4 comments

To support the when_needed snapshot.mode in PostgreSQL, we need to update the debezium version to 2.6.0.

https://debezium.io/documentation/reference/stable/connectors/postgresql.html https://github.com/debezium/debezium/commit/ce1b5d72310f4393f05886b9828a54b4b65bbd64

subkanthi avatar Apr 08 '24 14:04 subkanthi

Debezium 2.6 is failing because of the following error io.debezium.DebeziumException: Unable to create service io.debezium.snapshot.SnapshotterService

subkanthi avatar May 03 '24 17:05 subkanthi

A new configuration variable seems to be added in 2.6.0

 Unable to find minimal snapshot lock mode. Please check your configuration.

subkanthi avatar May 03 '24 17:05 subkanthi

JDBC storage is broken in Debezium 2.6.0

clickhouse-sink-connector-lt_1  | [Sink connector Debezium Event Thread] WARN io.debezium.storage.jdbc.offset.JdbcOffsetBackingStore - Attempt 5 to call 'checking / creating table' failed.

subkanthi avatar May 05 '24 18:05 subkanthi

Moving to 2.2.0 as we have a dependency on Debezium bug resolution.

subkanthi avatar May 06 '24 21:05 subkanthi

Blocked because of debezium bug - https://issues.redhat.com/browse/DBZ-7873

subkanthi avatar May 28 '24 13:05 subkanthi