Uploaded image for project: 'Percona Toolkit'
  1. Percona Toolkit
  2. PT-1083

LP #1144759: pt-table-checksum "Waiting for the --replicate table to replicate" forever

Details

    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.

      Attachments

        Activity

          People

            Unassigned Unassigned
            lpjirasync lpjirasync (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Smart Checklist