Details
-
Bug
-
Status: On Hold
-
Low
-
Resolution: Unresolved
-
None
-
None
Description
**Reported in Launchpad by Roman Vynar last update 13-03-2013 16:21:16
PT 2.1.7
pt-table-checksum writes "Waiting for the --replicate table to replicate to some.host.com" errors forever without any timeout or max check attempts.
Say I have the following in processlist:
814095 repl db1:36772 NULL Binlog Dump 883714 Has sent all binlog to slave; waiting for binlog to be updated NULL
820633 repl db2:36321 NULL Binlog Dump 875287 Has sent all binlog to slave; waiting for binlog to be updated NULL
823574 repl db4:35662 NULL Binlog Dump 871764 Has sent all binlog to slave; waiting for binlog to be updated NULL
994242 user1 db4:40468 NULL Binlog Dump 434446 Has sent all binlog to slave; waiting for binlog to be updated NULL
First 3 are slaves but the fourth process is binlog puller that backups binlogs.
In my case checksumming never runs as it waits forever for db4 - but it's not actually a slave - so the tool should timeout or have some max attempts like for connect.
"Waiting for the --replicate table to replicate to some.host.com" were written more than 24 hrs and I had to kill it.
I would like to avoid using DSN table because the script should have some threshold on the operation it can't do.