You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
so we have to stop the clickhouse-sink-connector with an error and start clickhouse-sink-connector.
"hot reload" is not available and causes an error during runtime
sink | java.sql.SQLException: Missing value for parameter #74 [test2 String]
sink | at com.clickhouse.jdbc.SqlExceptionUtils.clientError(SqlExceptionUtils.java:73) ~[clickhouse-kafka-sink-connector-0.0.9.jar:?]
sink | at com.clickhouse.jdbc.internal.InputBasedPreparedStatement.addBatch(InputBasedPreparedStatement.java:333) ~[clickhouse-kafka-sink-connector-0.0.9.jar:?]
"just stop clickhouse-sink-connector, upgrade schema, and start clickhouse-sink-connector" - doesn't work.
it only works with an error - maybe something is being cached or there is some kind of race condition
Example upgrade schema in postgresql:
ALTERTABLE test ADD COLUMN test2 character varying(50) NOT NULL DEFAULT 'yiii';
pay attention to NOT NULL
at the same time, the schema in the clickhouse itself is updated and a new column appears !
The text was updated successfully, but these errors were encountered:
salisbury-espinosa
changed the title
new fields in the schema (added to the postgres schema) begin to be recognized only after restarting the clickhouse-sink-connector
new fields in the schema (added to the postgres schema) begin to be recognized only after failed and restarting the clickhouse-sink-connectorNov 4, 2024
so we have to stop the
clickhouse-sink-connector
with an error and startclickhouse-sink-connector
."hot reload" is not available and causes an error during runtime
"just stop clickhouse-sink-connector, upgrade schema, and start clickhouse-sink-connector" - doesn't work.
it only works with an error - maybe something is being cached or there is some kind of race condition
Example upgrade schema in postgresql:
pay attention to
NOT NULL
at the same time, the schema in the clickhouse itself is updated and a new column appears !
The text was updated successfully, but these errors were encountered: