# Pt-table-checksum can't start/

**URL:** <https://forums.percona.com/t/pt-table-checksum-cant-start/25765>\
**Category:** Percona Toolkit\
**Created:** [October 9, 2023, 7:51am UTC](https://forums.percona.com/t/pt-table-checksum-cant-start/25765 "2023-10-09T07:51:34Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![yyu0378](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/yyu0378/32/13190_2.png) [@yyu0378](https://forums.percona.com/u/yyu0378)\
**Post date:** [October 9, 2023, 7:51am UTC](https://forums.percona.com/t/pt-table-checksum-cant-start/25765/1 "2023-10-09T07:51:34Z")

</div>

pt-tables-checksum: 3.5.5  
mysql server: 5.7.25  
command: pt-table-checksum --no-check-replication-filter --recursion-method=hosts --databases=xxxx S=/var/run/mysqld/mysqld.sock,u=root,p=xxxxx  
but just show like this

* * *

Waiting to check replicas for differences: 0% 00:00 remain  
Waiting to check replicas for differences: 0% 00:00 remain  
Waiting to check replicas for differences: 0% 00:00 remain

then i add PTDEBUG=1 show like this

* * *

# pt\_table\_checksum:12593 2924260 Sleep 1.25 waiting for chunks

# pt\_table\_checksum:12537 2924260 Getting last checksum on node2

# pt\_table\_checksum:12540 2924260 node2 max chunk: undef

# pt\_table\_checksum:12593 2924260 Sleep 1.25 waiting for chunks

# pt\_table\_checksum:12537 2924260 Getting last checksum on node2

# pt\_table\_checksum:12540 2924260 node2 max chunk: undef

# pt\_table\_checksum:12593 2924260 Sleep 1.25 waiting for chunks

# pt\_table\_checksum:12537 2924260 Getting last checksum on node2

# pt\_table\_checksum:12540 2924260 node2 max chunk: undef

# pt\_table\_checksum:12593 2924260 Sleep 1.25 waiting for chunks

# pt\_table\_checksum:12537 2924260 Getting last checksum on node2

# pt\_table\_checksum:12540 2924260 node2 max chunk: undef

# pt\_table\_checksum:12593 2924260 Sleep 1.25 waiting for chunks

* * *

I don’t understand what is max chunk on node2?  
node2 is mysql slave server,so i check document for mysql or percona toolkits,  
can’t which is def max chunk?

---

<div class="post-metadata">

**Author:** ![Mauricio\_Cacho](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mauricio_cacho/32/5859_2.png) [@Mauricio\_Cacho](https://forums.percona.com/u/Mauricio_Cacho)\
**Post date:** [October 10, 2023, 1:13am UTC](https://forums.percona.com/t/pt-table-checksum-cant-start/25765/2 "2023-10-10T01:13:37Z")

</div>

Hi @yyu0378

Since you’re using `--recursion-method=hosts` it will try to check all the replicas that this command shows:

`SHOW SLAVE HOSTS;`

Please see the replicas shown in the output and confirm you are able to connect to that IP from the same server where you’re running the command.

---

<div class="post-metadata">

**Author:** ![yyu0378](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/yyu0378/32/13190_2.png) [@yyu0378](https://forums.percona.com/u/yyu0378)\
**Post date:** [October 10, 2023, 1:29am UTC](https://forums.percona.com/t/pt-table-checksum-cant-start/25765/3 "2023-10-10T01:29:02Z")

</div>

## yes.I can connect slave server by hostname SHOW SLAVE HOSTS; command can get slave hosts,like this

## | Server\_id | Host | Port | Master\_id | Slave\_UUID | ±----------±------±-----±----------±-------------------------------------+ | 2 | node2 | 3306 | 1 | 73e5d4f5-666e-11ee-89e3-00505697151d

## when use PTDEUG=1,get this log

$DBD::mysql::VERSION: 4.050 $DBI::VERSION: 1.643

# MasterSlave:5589 3882868 DBI::db=HASH(0x56005eb2a9c8) SHOW MASTER STATUS

# MasterSlave:5593 3882868 Position=51068858 Binlog\_Do\_DB= Executed\_Gtid\_Set= Binlog\_Ignore\_DB=mysql File=mysql-bin.000003

# MasterSlave:5533 3882868 DBI::db=HASH(0x56005eabe838) SHOW SLAVE STATUS

# VersionParser:4351 3882868 VersionParser got a dbh, trying to get the version

# VersionParser:4399 3882868 InnoDB support: DEFAULT

# VersionParser:4411 3882868 InnoDB version: 5.7.25

# MasterSlave:5630 3882868 DBI::db=HASH(0x56005eabe838) SELECT MASTER\_POS\_WAIT(‘mysql-bin.000003’, 51068858, 60 )

# MasterSlave:5636 3882868 Result of waiting: 1

# MasterSlave:5637 3882868 Waited 1 seconds

# Active dbh: DBI::db=HASH(0x56005eb2a9c8)

# Active sth: DBI::st=HASH(0x56005ee52fe0) SHOW MASTER STATUS

# pt\_table\_checksum:12519 3882868 SELECT MAX(chunk) FROM `percona`.`checksums` WHERE db=‘staging’ AND tbl=‘acq\_acquire\_event’ AND master\_crc IS NOT NULL

# pt\_table\_checksum:12537 3882868 Getting last checksum on node2

# pt\_table\_checksum:12540 3882868 node2 max chunk: undef

# pt\_table\_checksum:12593 3882868 Sleep 0.25 waiting for chunks

# pt\_table\_checksum:12537 3882868 Getting last checksum on node2

# pt\_table\_checksum:12540 3882868 node2 max chunk: undef

# pt\_table\_checksum:12593 3882868 Sleep 0.5 waiting for chunks

# pt\_table\_checksum:12537 3882868 Getting last checksum on node2

# pt\_table\_checksum:12540 3882868 node2 max chunk: undef

* * *

there is SHOW SALVE STATUS,get mysql version is 2.5.7-25,so i not sure this version is get from slave service.