Comment 1 for bug 1443847

Revision history for this message
Nilnandan Joshi (nilnandan-joshi) wrote :

Confirmed. While running pt-table-checksum, if slave server will be stopped. It gives error. Timeout variable for this can be helpful.

nilnandan@desktop:~$ pt-table-checksum --user=root --password=msandbox --socket=/tmp/mysql_sandbox20886.sock --recursion-method dsn=h=localhost,D=percona,t=dsns --no-check-binlog-format --check-interval=10 TS ERRORS DIFFS ROWS CHUNKS SKIPPED TIME TABLE
04-28T12:19:57 0 0 0 1 0 0.006 mysql.columns_priv
04-28T12:19:57 0 0 0 1 0 0.004 mysql.db
04-28T12:19:57 0 0 0 1 0 0.005 mysql.event
04-28T12:19:57 0 0 0 1 0 0.004 mysql.func
04-28T12:19:57 0 0 40 1 0 0.005 mysql.help_category
04-28T12:19:57 0 0 485 1 0 0.257 mysql.help_keyword
04-28T12:19:58 0 0 1090 1 0 0.258 mysql.help_relation
04-28T12:19:58 0 0 533 1 0 0.263 mysql.help_topic
04-28T12:19:58 0 0 0 1 0 0.006 mysql.ndb_binlog_index
04-28T12:19:58 0 1 1 1 0 0.004 mysql.plugin
04-28T12:19:58 0 0 0 1 0 0.006 mysql.proc
04-28T12:19:58 0 0 0 1 0 0.003 mysql.procs_priv
04-28T12:19:58 0 0 2 1 0 0.006 mysql.proxies_priv
04-28T12:19:58 0 0 0 1 0 0.005 mysql.servers
04-28T12:19:58 0 0 0 1 0 0.005 mysql.tables_priv
04-28T12:19:58 0 0 0 1 0 0.006 mysql.time_zone
04-28T12:19:58 0 0 0 1 0 0.004 mysql.time_zone_leap_second
04-28T12:19:58 0 0 0 1 0 0.004 mysql.time_zone_name
04-28T12:19:58 0 0 0 1 0 0.005 mysql.time_zone_transition
04-28T12:19:58 0 0 0 1 0 0.006 mysql.time_zone_transition_type
04-28T12:19:58 0 0 8 1 0 0.006 mysql.user
04-28T12:19:58 0 1 1 1 0 0.006 percona.dsns
Replica desktop is stopped. Waiting.
04-28T12:20:16 Fatal error checksumming table test.nil: Lost connection to replica desktop while attempting to get its lag (DBI connect(';host=localhost;mysql_socket=/tmp/mysql_sandbox20887.sock;mysql_read_default_group=client','msandbox',...) failed: Can't connect to local MySQL server through socket '/tmp/mysql_sandbox20887.sock' (2) at /usr/bin/pt-table-checksum line 1576.) at /usr/bin/pt-table-checksum line 9695.

04-28T12:20:16 1 0 7570408 10 0 18.446 test.nil
nilnandan@desktop:~$