Comment 4 for bug 1253537

Revision history for this message
Francisco Bordenave (francisco-bordenave) wrote :

I think --recursion-method=dsn should be ported from pt-table-checksum I have a case (using tungsten replicator) where SHOW PROCESSLIST and SHOW SLAVE HOSTS doesn't work so using --replicate is not working.

Using PTDEBUG=1 throws:

# MasterSlave:6641 21976 Recursion methods: processlist hosts
# MasterSlave:6651 21976 Connected to h=masterxxx.net
# MasterSlave:6660 21976 SELECT @@SERVER_ID
# MasterSlave:6662 21976 Working on server ID 4000
# TableChecksum:4931 21976 SELECT db, tbl, CONCAT(db, '.', tbl) AS `table`, chunk, chunk_index, lower_boundary, upper_boundary, COALESCE(this_cnt-master_cnt, 0) AS cnt_diff, COALESCE(this_crc <> master_crc OR ISNULL(master_crc) <> ISNULL(this_crc), 0) AS crc_diff, this_cnt, master_cnt, this_crc, master_crc FROM finance.cksums_finance_db_server WHERE master_cnt <> this_cnt OR master_crc <> this_crc OR ISNULL(master_crc) <> ISNULL(this_crc)
# MasterSlave:6695 21976 Looking for slaves on h=masterxxx.net using methods processlist hosts
# MasterSlave:6702 21976 Finding slaves with _find_slaves_by_processlist
# MasterSlave:6764 21976 DBI::db=HASH(0x6f4a2b0) SHOW GRANTS FOR CURRENT_USER()
# MasterSlave:6794 21976 DBI::db=HASH(0x6f4a2b0) SHOW PROCESSLIST
# MasterSlave:6702 21976 Finding slaves with _find_slaves_by_hosts
# MasterSlave:6736 21976 DBI::db=HASH(0x6f4a2b0) SHOW SLAVE HOSTS
# MasterSlave:6707 21976 Found 0 slaves
# pt_table_sync:11009 21976 Disconnected dbh DBI::db=HASH(0x6f4a2b0)
# pt_table_sync:11009 21976 Disconnected dbh DBI::db=HASH(0x6f4fbb0)

However pt-table-checksum --replicate-check-only --replicate=percona.cksums reports differences.