pt-sync-table does not support multiple replication channels
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
New
|
Undecided
|
Unassigned |
Bug Description
pt-sync-table doesn't know how to handle case when slave has more than 1 master connected.
user@slave1 PTDEBUG=1 pt-table-sync --print --databases my_site --replicate percona.checksums --sync-to-master 'h=127.
percona-toolkit 2.2.17-1
Master MySQL: Percona MySQL 5.7.11-4
Slaves MySQL: Oracle MySQL 5.7.9
Console output:
[skipped]
# TableSyncer:6163 25683 Executing statement on source to lock rows
# TableSyncer:6166 25683 DBI::db=
# Retry:8348 25683 Try 1 of 3
# MasterSlave:6906 25683 DBI::db=
# MasterSlave:6910 25683 Binlog_Do_DB= Position=357679626 Binlog_Ignore_DB= Executed_
# MasterSlave:6935 25683 DBI::db=
# Retry:8354 25683 Try code failed: DBD::mysql::db selectrow_array failed: fetch() without execute() [for Statement "SELECT MASTER_
#
MASTER_POS_WAIT() returned NULL. Verify that the slave is running. Sleeping 10 seconds then retrying 2 more times.
# Retry:8360 25683 Calling wait code
^C
Strace logging:
[skipped]
write(3, ":\0\0\0\3SELECT MASTER_
read(3, "\1\0\0\
write(2, "MASTER_POS_WAIT() returned NULL. Verify that the slave is running. Sleeping 10 seconds then retrying 2 more times.\n", 117) = 117
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/ /jira.percona. com/browse/ PT-1350