AdamKatzDev

Results 21 comments of 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...