aadant

@poweroftrue for MySQL, you can take a snapshot via MySQLshell (see python utilities in this project). It takes a consistent snapshot, then you can restore it to CH and just...

Good catch ! I think it is a bug. We should fix this as it is very misleading. The connector should only restart if it is idle (this is a...

See https://github.com/Altinity/clickhouse-sink-connector/issues/380 It is recommended to replicate with a heartbeat table to know if the connector is lagging. If they are no updates, the connector will not update the replica_source_info...

@salisbury-espinosa you can set this as a merge_tree settings in the server config as a workaround.

@subkanthi FYI

Yes I agree it should be zero. You get that it you use the python utilities to dump the data. It is not an issue if the _version is always...

@vpol the error message should be in the log file of course but you can probably check at the CH level. system.query_log where exception != '' You should see it...

@subkanthi could it be related this breaking change in 2.1.0 ? Breaking Changes. The configuration clickhouse.server.database is now deprecated with the multiple database support. By default the source MySQL/postgres database...

This bug will affect schemas with tables with DateTime and Timestamp columns which ... happens.

@subkanthi any progress ?