AdamKatzDev
AdamKatzDev
@aadant is there a complete solution for this issue? A script for Clickhouse or MySQL that keep the triggers in a synced state? For some removing cascade operations is not...
It is likely that this code will cause race conditions (e.g. records inserted/updated/removed in an order that is different from binlog), you will have to implement per topic locks to...
@IlyaTsoi I couldn't figure out the moment when the version column is generated, version correctness itself might depend on the order records are processed. There is also an issue caused...
@IlyaTsoi if you are correct then this version control won't work for very hot data. https://clickhouse.com/docs/en/engines/table-engines/mergetree-family/replacingmergetree >If two inserted rows have the same version number, the last inserted row is...
@aadant >@IlyaTsoi @AdamKatzDev for the MySQL case the version is increasing as it contains a snowflakeID + a counter coming from the GTID. So it looks like it is safe...
Thank you for swift responses, folks. @subkanthi >My guess is that the Xmx settings did not get applied. you can do a ps -ef in the docker container and check...
I was able to load the dump, had to update the script a bit though. Still, I wish there was a way to create snapshots. As was mentioned before, that...
@aadant thanks for providing the info, I was able to transfer the dump and turn on the connector. I haven't tested much except updates but it looks promising. @subkanthi I...
@subkanthi I've made a heap dump using `jmap` from the application running with `-xmx5G` limit at the moment it started stalling. Eclipse MAT shows there are ~1.4M `ClickHouseStruct` objects stored....
@aadant I've figured out how to run the image with increased memory constraints and it acts similar to the JAR file, i.e. stalls but a bit later. If you are...