0

pt-table-checksum 3.0.12

mysqld Ver 5.6.41-84.1 for debian-linux-gnu on x86_64 (Percona Server (GPL), Release 84.1, Revision b308619)

Command to run:

pt-table-checksum --no-check-binlog-format --databases <list_of_DB> --tables <list_of_tables>

As a result - endless loop:

MasterSlave:5529 12788 Waited 0 seconds
 pt_table_checksum:12398 12788 SELECT MAX(chunk) FROM `percona`.`checksums` WHERE db='analiz_0' AND tbl='KBK_reesrt_01022019' AND master_crc IS NOT NULL
 pt_table_checksum:12416 12788 Getting last checksum on slave-bide
 pt_table_checksum:12419 12788 slave-bide max chunk: undef
 pt_table_checksum:12472 12788 Sleep 0.25 waiting for chunks
 pt_table_checksum:12416 12788 Getting last checksum on slave-bide
 pt_table_checksum:12419 12788 slave-bide max chunk: undef
 pt_table_checksum:12472 12788 Sleep 0.5 waiting for chunks
 pt_table_checksum:12416 12788 Getting last checksum on slave-bide
 pt_table_checksum:12419 12788 slave-bide max chunk: undef
 pt_table_checksum:12472 12788 Sleep 0.75 waiting for chunks
 pt_table_checksum:12416 12788 Getting last checksum on slave-bide
 pt_table_checksum:12419 12788 slave-bide max chunk: undef
 pt_table_checksum:12472 12788 Sleep 1 waiting for chunks
 pt_table_checksum:12416 12788 Getting last checksum on slave-bide
 pt_table_checksum:12419 12788 slave-bide max chunk: undef
 pt_table_checksum:12472 12788 Sleep 1.25 waiting for chunks

No replica lags are shown in SHOW SLAVE STATUS\G, all I/O running on slave

SELECT MAX(chunk) 
FROM `percona`.`checksums` 
WHERE db='mysql' 
  AND tbl='columns_priv' 
  AND master_crc IS NOT NULL;

on Master and Slave shows:

+------------+
| MAX(chunk) |
+------------+
|       NULL |
+------------+

What is wrong?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.