# pt-table-checksum Not checking replication lag...

**URL:** <https://forums.percona.com/t/pt-table-checksum-not-checking-replication-lag/3087>\
**Category:** Percona Toolkit\
**Created:** [November 14, 2013, 3:02pm UTC](https://forums.percona.com/t/pt-table-checksum-not-checking-replication-lag/3087 "2013-11-14T15:02:16Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![jjengel11](https://avatars.discourse-cdn.com/v4/letter/j/ee7513/32.png) [@jjengel11](https://forums.percona.com/u/jjengel11)\
**Post date:** [November 14, 2013, 3:02pm UTC](https://forums.percona.com/t/pt-table-checksum-not-checking-replication-lag/3087/1 "2013-11-14T15:02:16Z")

</div>

when running pt-table-checksum on a master/slave setup I get this output

Not checking replica lag on hostname because it is a cluster node

there are table differences and the output of the script is not showing the differences. what is that message that is displayed? it is not a cluster node but a slave. I am running this command on the master and it finds the right hostname of the slave but thinks it is a cluster setup???

pt-table-checksum version is 2.1.4 and percona version 5.5.29

my command is : pt-table-checksum -u user -ppassword --databases test

i have also tried : pt-table-checksum -u user -ppassword --databases test --recursion-method dsn=h=host2,P=3306,u=user,p=pword,D=test,t=junk

and i get dbd::mysql::db selectcol\_arrayref failed unknown column ‘dsn’ in field list’ [for Statement "SELECT dsn FROM test.junk order by id

how can i run this tool to show me the differences in the tables? also why does it think the 2nd node is a cluster node and not a slave??

thanks

---

<div class="post-metadata">

**Author:** ![henn9438](https://avatars.discourse-cdn.com/v4/letter/h/d2c977/32.png) [@henn9438](https://forums.percona.com/u/henn9438)\
**Post date:** [January 23, 2014, 6:07am UTC](https://forums.percona.com/t/pt-table-checksum-not-checking-replication-lag/3087/2 "2014-01-23T06:07:47Z")

</div>

Try to run pt-table-checksum with

---

<div class="post-metadata">

**Author:** ![mirfan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mirfan/32/16890_2.png) [@mirfan](https://forums.percona.com/u/mirfan)\
**Post date:** [January 25, 2014, 4:17pm UTC](https://forums.percona.com/t/pt-table-checksum-not-checking-replication-lag/3087/3 "2014-01-25T16:17:37Z")

</div>

Did you tried with latest version of [pt-table-checksum](http://www.percona.com/doc/percona-toolkit/2.2/pt-table-checksum.html) ? You may also want to run with PTDEBUG=1 it will generate lots of debug output and will help to identify problem.  
Moreover, your second command with [–recursion\_method](http://www.percona.com/doc/percona-toolkit/2.2/pt-table-checksum.html#cmdoption-pt-table-checksum--recursion-method) doesn’t seems correct. You need to create dsns table under percona database and create a record for slave with host, username,password under dsn column in dsns table and finally need to mention where the dsn table is and specify master credentials. something like as follows.

```auto

pt-table-checksum --recursion-method=dsn=D=percona,t=dsns --host=127.0.0.1

```

If problem still persists i would suggest to show master and slave my.cnf

---

<div class="post-metadata">

**Author:** ![jjengel11](https://avatars.discourse-cdn.com/v4/letter/j/ee7513/32.png) [@jjengel11](https://forums.percona.com/u/jjengel11)\
**Post date:** [November 6, 2014, 7:41am UTC](https://forums.percona.com/t/pt-table-checksum-not-checking-replication-lag/3087/4 "2014-11-06T07:41:08Z")

</div>

Sorry for the delay in the response. The issue as I recall was because I did install the Percona Cluster software but am not using the database in a cluster but rather just in a master/slave scenario. With Percona Server the commands work. For whatever reason we could not cluster our databases

---

<div class="post-metadata">

**Author:** ![naaptolreport](https://avatars.discourse-cdn.com/v4/letter/n/eb8c5e/32.png) [@naaptolreport](https://forums.percona.com/u/naaptolreport)\
**Post date:** [February 1, 2015, 2:39pm UTC](https://forums.percona.com/t/pt-table-checksum-not-checking-replication-lag/3087/5 "2015-02-01T14:39:36Z")

</div>

Hi

I was using maatkit earlier from long time  
Now i want to migrate to percona toolkit

What is alternative of following command full syntax

./mk-table-checksum h=192.168.58.30,P=3306,u=root,p= h=192.168.58.7,P=3306,u=root,p= -d csp --crc --count --float-precision=6 | ./mk-checksum-filter