Percona Toolkit moved to https://jira.percona.com/projects/PT

  1. Bug #1080765
  2. Comment #4

Comment 4 for bug 1080765

Revision history for this message
Rob Wagner (rjwagner-dba) wrote :

I have a simpler test case that may help. I ran pt-table-checksum against 5 empty tables that are persistently empty (i.e., no DML occurs against these tables). I repeatedly ran pt-table-checksum until a difference was identified by the tool. I will upload the PTDEBUG output shortly (note line 953 identifies a difference in table AO_563AEE_ACTIVITY_ENTITY, though this table is empty on both the master and slave.

The following is relevant to this new test:

Tool version = pt-table-checksum 2.1.7
Command line = /sso/sfw/percona/bin/pt-table-checksum --user=root --password=hidden --chunk-size-limit=50.0 --replicate-check --recursion-method=DSN=D=percona,t=dsns_ssodb03 --databases=vsp_jira_current --tables=AO_563AEE_ACTIVITY_ENTITY,AO_563AEE_ACTOR_ENTITY,AO_563AEE_MEDIA_LINK_ENTITY,AO_563AEE_OBJECT_ENTITY,AO_563AEE_TARGET_ENTITY --no-check-replication-filters --no-check-binlog-format --replicate=percona.checksums_ssodb03 > bug2.txt 2>&1