[QUESTION]

[christheo03]

I try to replicate the data from my sql to clickhouse .

I replicate a database .The replicator is stuck and loop thru the same data at the same table. The table is just 80 rows but when i select the count of rows of that table in clickhouse it changes every second from 100 to 300 and back every time it changes

[bakwc]

Please provide replicator logs and table structure in mysql (show create table) and data samples. Is it initial replication stuck or realtime replication? Did you configured clickhouse correctly (applying final=true)?

[christheo03]

Its initial replicator and final is set to 1.
[dbrepl mq_mt5_reports1 worker_2 table_mt5_reports 2025-08-26 08:05:22,959 INFO] replicating mt5_reports, replicated 3247 records, primary key: ['Trades\Trading Frequency', 1]
[dbrepl mq_mt5_reports1 worker_13 table_mt5_reports 2025-08-26 08:05:22,959 INFO] replicating mt5_reports, replicated 3259 records, primary key: ['Trades\StopOut Compensations', 1]
[dbrepl mq_mt5_reports1 worker_5 table_mt5_reports 2025-08-26 08:05:22,961 INFO] replicating mt5_reports, replicated 1632 records, primary key: ['Trades\Trade Performance Summary', 1]
[dbrepl mq_mt5_reports1 worker_10 table_mt5_reports 2025-08-26 08:05:22,991 INFO] replicating mt5_reports, replicated 4868 records, primary key: ['Trades\Trade Performance Summary by Country', 1]
[dbrepl mq_mt5_reports1 worker_0 table_mt5_reports 2025-08-26 08:05:23,025 INFO] replicating mt5_reports, replicated 4866 records, primary key: ['Trades\Segregated', 1]
[dbrepl mq_mt5_reports1 worker_14 table_mt5_reports 2025-08-26 08:05:23,061 INFO] replicating mt5_reports, replicated 3247 records, primary key: ['Trades\Credit Facility', 1]
[dbrepl mq_mt5_reports1 worker_1 table_mt5_reports 2025-08-26 08:05:23,125 INFO] replicating mt5_reports, replicated 4881 records, primary key: ['Trades\Trade Performance Summary by Symbol', 1]
[dbrepl mq_mt5_reports1 worker_6 table_mt5_reports 2025-08-26 08:05:23,129 INFO] replicating mt5_reports, replicated 3256 records, primary key: ['Daily\Daily Expert Advisors', 1]
[dbrepl mq_mt5_reports1 worker_7 table_mt5_reports 2025-08-26 08:05:23,156 INFO] replicating mt5_reports, replicated 4873 records, primary key: ['Trades\Trade Accounts Detailed', 1]
[dbrepl mq_mt5_reports1 worker_4 table_mt5_reports 2025-08-26 08:05:23,199 INFO] replicating mt5_reports, replicated 1626 records, primary key: ['Trades\Risk Appetite', 1]
[dbrepl mq_mt5_reports1 worker_11 table_mt5_reports 2025-08-26 08:05:23,228 INFO] replicating mt5_reports, replicated 3253 records, primary key: ['Trades\Trade Transactions', 1]
[dbrepl mq_mt5_reports1 worker_12 table_mt5_reports 2025-08-26 08:05:23,233 INFO] replicating mt5_reports, replicated 4867 records, primary key: ['Trades\Trade Modifications', 1]
[dbrepl mq_mt5_reports1 worker_8 table_mt5_reports 2025-08-26 08:05:23,275 INFO] replicating mt5_reports, replicated 3264 records, primary key: ['Trades\Trade Accounts', 1]
[dbrepl mq_mt5_reports1 worker_3 table_mt5_reports 2025-08-26 08:05:23,305 INFO] replicating mt5_reports, replicated 1619 records, primary key: ['Trades\Summary', 1]
[dbrepl mq_mt5_reports1 worker_9 table_mt5_reports 2025-08-26 08:05:23,339 INFO] replicating mt5_reports, replicated 1629 records, primary key: ['Trades\Daily Reports', 1]
[dbrepl mq_mt5_reports1 worker_15 table_mt5_reports 2025-08-26 08:05:23,366 INFO] replicating mt5_reports, replicated 4863 records, primary key: ['Trades\Positions History', 1]

[dbrepl mq_mt5_reports1 worker_13 table_mt5_reports 2025-08-26 08:08:22,991 INFO] replicating mt5_reports, replicated 11763 records, primary key: ['Trades\StopOut Compensations', 1]
[dbrepl mq_mt5_reports1 worker_2 table_mt5_reports 2025-08-26 08:08:23,036 INFO] touch binlog /home/user/binlog/mq_mt5_reports1
[dbrepl mq_mt5_reports1 worker_10 table_mt5_reports 2025-08-26 08:08:23,036 INFO] replicating mt5_reports, replicated 17576 records, primary key: ['Trades\Trade Performance Summary by Country', 1]
[dbrepl mq_mt5_reports1 worker_2 table_mt5_reports 2025-08-26 08:08:23,037 INFO] replicating mt5_reports, replicated 11739 records, primary key: ['Trades\Trading Frequency', 1]
[dbrepl mq_mt5_reports1 worker_13 table_mt5_reports 2025-08-26 08:08:23,042 INFO] touch binlog /home/user/binlog/mq_mt5_reports1
[dbrepl mq_mt5_reports1 worker_5 table_mt5_reports 2025-08-26 08:08:23,047 INFO] touch binlog /home/user/binlog/mq_mt5_reports1
[dbrepl mq_mt5_reports1 worker_5 table_mt5_reports 2025-08-26 08:08:23,048 INFO] replicating mt5_reports, replicated 5897 records, primary key: ['Trades\Trade Performance Summary', 1]
[dbrepl mq_mt5_reports1 worker_10 table_mt5_reports 2025-08-26 08:08:23,072 INFO] touch binlog /home/user/binlog/mq_mt5_reports1
[dbrepl mq_mt5_reports1 worker_14 table_mt5_reports 2025-08-26 08:08:23,081 INFO] replicating mt5_reports, replicated 11745 records, primary key: ['Trades\Credit Facility', 1]
[dbrepl mq_mt5_reports1 worker_0 table_mt5_reports 2025-08-26 08:08:23,124 INFO] touch binlog /home/user/binlog/mq_mt5_reports1
[dbrepl mq_mt5_reports1 worker_0 table_mt5_reports 2025-08-26 08:08:23,125 INFO] replicating mt5_reports, replicated 17568 records, primary key: ['Trades\Segregated', 1]
[dbrepl mq_mt5_reports1 worker_14 table_mt5_reports 2025-08-26 08:08:23,154 INFO] touch binlog /home/user/binlog/mq_mt5_reports1
[dbrepl mq_mt5_reports1 worker_1 table_mt5_reports 2025-08-26 08:08:23,217 INFO] touch binlog /home/user/binlog/mq_mt5_reports1
[dbrepl mq_mt5_reports1 worker_1 table_mt5_reports 2025-08-26 08:08:23,218 INFO] replicating mt5_reports, replicated 17634 records, primary key: ['Trades\Trade Performance Summary by Symbol', 1]
[dbrepl mq_mt5_reports1 worker_7 table_mt5_reports 2025-08-26 08:08:23,256 INFO] touch binlog /home/user/binlog/mq_mt5_reports1
[dbrepl mq_mt5_reports1 worker_7 table_mt5_reports 2025-08-26 08:08:23,256 INFO] replicating mt5_reports, replicated 17629 records, primary key: ['Trades\Trade Accounts Detailed', 1]
[dbrepl mq_mt5_reports1 worker_6 table_mt5_reports 2025-08-26 08:08:23,272 INFO] touch binlog /home/user/binlog/mq_mt5_reports1
[dbrepl mq_mt5_reports1 worker_6 table_mt5_reports 2025-08-26 08:08:23,272 INFO] replicating mt5_reports, replicated 11786 records, primary key: ['Daily\Daily Expert Advisors', 1]
[dbrepl mq_mt5_reports1 worker_11 table_mt5_reports 2025-08-26 08:08:23,276 INFO] touch binlog /home/user/binlog/mq_mt5_reports1
[dbrepl mq_mt5_reports1 worker_12 table_mt5_reports 2025-08-26 08:08:23,276 INFO] replicating mt5_reports, replicated 17602 records, primary key: ['Trades\Trade Modifications', 1]
[dbrepl mq_mt5_reports1 worker_11 table_mt5_reports 2025-08-26 08:08:23,277 INFO] replicating mt5_reports, replicated 11717 records, primary key: ['Trades\Trade Transactions', 1]
[dbrepl mq_mt5_reports1 worker_4 table_mt5_reports 2025-08-26 08:08:23,295 INFO] touch binlog /home/user/binlog/mq_mt5_reports1
[dbrepl mq_mt5_reports1 worker_4 table_mt5_reports 2025-08-26 08:08:23,296 INFO] replicating mt5_reports, replicated 5875 records, primary key: ['Trades\Risk Appetite', 1]
[dbrepl mq_mt5_reports1 worker_12 table_mt5_reports 2025-08-26 08:08:23,311 INFO] touch binlog /home/user/binlog/mq_mt5_reports1
[dbrepl mq_mt5_reports1 worker_3 table_mt5_reports 2025-08-26 08:08:23,331 INFO] touch binlog /home/user/binlog/mq_mt5_reports1
[dbrepl mq_mt5_reports1 worker_8 table_mt5_reports 2025-08-26 08:08:23,349 INFO] touch binlog /home/user/binlog/mq_mt5_reports1
[dbrepl mq_mt5_reports1 worker_8 table_mt5_reports 2025-08-26 08:08:23,350 INFO] replicating mt5_reports, replicated 11790 records, primary key: ['Trades\Trade Accounts', 1]
[dbrepl mq_mt5_reports1 worker_3 table_mt5_reports 2025-08-26 08:08:23,375 INFO] replicating mt5_reports, replicated 5873 records, primary key: ['Trades\Summary', 1]
[dbrepl mq_mt5_reports1 worker_9 table_mt5_reports 2025-08-26 08:08:23,393 INFO] touch binlog /home/user/binlog/mq_mt5_reports1
[dbrepl mq_mt5_reports1 worker_9 table_mt5_reports 2025-08-26 08:08:23,393 INFO] replicating mt5_reports, replicated 5876 records, primary key: ['Trades\Daily Reports', 1]
[dbrepl mq_mt5_reports1 worker_15 table_mt5_reports 2025-08-26 08:08:23,424 INFO] touch binlog /home/user/binlog/mq_mt5_reports1
[dbrepl mq_mt5_reports1 worker_15 table_mt5_reports 2025-08-26 08:08:23,425 INFO] replicating mt5_reports, replicated 17517 records, primary key: ['Trades\Positions History', 1]

The table is only 80 rows . The replicator only shows those 2 outputs over and over again