Able to reproduce it with pt-table-sync 2.2.7.
nilnandan@Dell-XPS:~$ PTDEBUG=1 /usr/bin/pt-table-sync --charset utf8 --execute --verbose --function MD5 --database test --tables t1 --sync-to-master h=localhost,u=root,p=msandbox,S=/tmp/mysql_sandbox20083.sock
# ChangeHandler:3461 8393 0 to DELETE # ChangeHandler:3461 8393 1 to REPLACE # ChangeHandler:3539 8393 Make REPLACE # ChangeHandler:3549 8393 Fetching data on dbh DBI::db=HASH(0x1faf640) for REPLACE : SELECT `id`, `name`, `address` FROM `test`.`t1` WHERE `id`='3' LIMIT 1 # ChangeHandler:3401 8393 Wide character in print at /usr/bin/pt-table-sync line 3656. while doing test.t1 on localhost # pt_table_sync:11281 8393 DBI::db=HASH(0x1faf640) SELECT NOW() # pt_table_sync:11283 8393 Server time: 2014-09-10 13:58:20 # 0 0 0 0 0 13:58:20 13:58:20 1 test.t1 # pt_table_sync:11038 8393 Disconnected dbh DBI::db=HASH(0x1fb9398) # pt_table_sync:11038 8393 Disconnected dbh DBI::db=HASH(0x2091760) # pt_table_sync:11038 8393 Disconnected dbh DBI::db=HASH(0x1faf640) # pt_table_sync:11038 8393 Disconnected dbh DBI::db=HASH(0x1faf388) nilnandan@Dell-XPS:~$
But it seems, its warning not error because when I have tried without PTDEBUG just after above command. It ran successfully.
nilnandan@Dell-XPS:~$ pt-table-sync --charset utf8 --execute --verbose --function MD5 --database test --tables t1 --sync-to-master h=localhost,u=root,p=msandbox,S=/tmp/mysql_sandbox20083.sock # Syncing A=utf8,S=/tmp/mysql_sandbox20083.sock,h=localhost,p=...,u=root # DELETE REPLACE INSERT UPDATE ALGORITHM START END EXIT DATABASE.TABLE # 0 1 0 0 Chunk 13:59:51 13:59:51 2 test.t1 nilnandan@Dell-XPS:~$
Even without PTDEBUG, it didn't give any error/warning.
nilnandan@Dell-XPS:~$ pt-table-checksum --user=root --password=msandbox --socket=/tmp/mysql_sandbox20082.sock --recursion-method dsn=D=percona,t=dsns TS ERRORS DIFFS ROWS CHUNKS SKIPPED TIME TABLE 09-10T14:36:43 0 0 100000 5 0 0.625 dbtest.sbtest 09-10T14:36:43 0 0 0 1 0 0.042 mysql.columns_priv 09-10T14:36:43 0 0 0 1 0 0.025 mysql.db 09-10T14:36:43 0 0 0 1 0 0.026 mysql.event 09-10T14:36:43 0 0 0 1 0 0.044 mysql.func 09-10T14:36:43 0 0 40 1 0 0.044 mysql.help_category 09-10T14:36:43 0 0 485 1 0 0.033 mysql.help_keyword 09-10T14:36:43 0 0 1090 1 0 0.046 mysql.help_relation 09-10T14:36:44 0 0 533 1 0 0.046 mysql.help_topic 09-10T14:36:44 0 0 0 1 0 0.045 mysql.ndb_binlog_index 09-10T14:36:44 0 0 0 1 0 0.039 mysql.plugin 09-10T14:36:44 0 0 0 1 0 0.040 mysql.proc 09-10T14:36:44 0 0 0 1 0 0.026 mysql.procs_priv 09-10T14:36:44 0 0 2 1 0 0.042 mysql.proxies_priv 09-10T14:36:44 0 0 0 1 0 0.051 mysql.servers 09-10T14:36:44 0 0 0 1 0 0.048 mysql.tables_priv 09-10T14:36:44 0 0 0 1 0 0.038 mysql.time_zone 09-10T14:36:44 0 0 0 1 0 0.035 mysql.time_zone_leap_second 09-10T14:36:44 0 0 0 1 0 0.035 mysql.time_zone_name 09-10T14:36:44 0 0 0 1 0 0.033 mysql.time_zone_transition 09-10T14:36:44 0 0 0 1 0 0.040 mysql.time_zone_transition_type 09-10T14:36:44 0 0 8 1 0 0.034 mysql.user 09-10T14:36:44 0 0 1 1 0 0.033 percona.dsns 09-10T14:36:44 0 1 5 1 0 0.028 test.t1 nilnandan@Dell-XPS:~$ nilnandan@Dell-XPS:~$ pt-table-sync --charset utf8 --execute --verbose --function MD5 --database test --tables t1 --sync-to-master h=localhost,u=root,p=msandbox,S=/tmp/mysql_sandbox20083.sock # Syncing A=utf8,S=/tmp/mysql_sandbox20083.sock,h=localhost,p=...,u=root # DELETE REPLACE INSERT UPDATE ALGORITHM START END EXIT DATABASE.TABLE # 0 1 0 0 Chunk 14:36:51 14:36:51 2 test.t1 nilnandan@Dell-XPS:~$
Able to reproduce it with pt-table-sync 2.2.7.
nilnandan@ Dell-XPS: ~$ PTDEBUG=1 /usr/bin/ pt-table- sync --charset utf8 --execute --verbose --function MD5 --database test --tables t1 --sync-to-master h=localhost, u=root, p=msandbox, S=/tmp/ mysql_sandbox20 083.sock
# ChangeHandler:3461 8393 0 to DELETE HASH(0x1faf640) for REPLACE : SELECT `id`, `name`, `address` FROM `test`.`t1` WHERE `id`='3' LIMIT 1 pt-table- sync line 3656. while doing test.t1 on localhost HASH(0x1faf640) SELECT NOW() HASH(0x1fb9398) HASH(0x2091760) HASH(0x1faf640) HASH(0x1faf388) Dell-XPS: ~$
# ChangeHandler:3461 8393 1 to REPLACE
# ChangeHandler:3539 8393 Make REPLACE
# ChangeHandler:3549 8393 Fetching data on dbh DBI::db=
# ChangeHandler:3401 8393 Wide character in print at /usr/bin/
# pt_table_sync:11281 8393 DBI::db=
# pt_table_sync:11283 8393 Server time: 2014-09-10 13:58:20
# 0 0 0 0 0 13:58:20 13:58:20 1 test.t1
# pt_table_sync:11038 8393 Disconnected dbh DBI::db=
# pt_table_sync:11038 8393 Disconnected dbh DBI::db=
# pt_table_sync:11038 8393 Disconnected dbh DBI::db=
# pt_table_sync:11038 8393 Disconnected dbh DBI::db=
nilnandan@
But it seems, its warning not error because when I have tried without PTDEBUG just after above command. It ran successfully.
nilnandan@ Dell-XPS: ~$ pt-table-sync --charset utf8 --execute --verbose --function MD5 --database test --tables t1 --sync-to-master h=localhost, u=root, p=msandbox, S=/tmp/ mysql_sandbox20 083.sock S=/tmp/ mysql_sandbox20 083.sock, h=localhost, p=...,u= root Dell-XPS: ~$
# Syncing A=utf8,
# DELETE REPLACE INSERT UPDATE ALGORITHM START END EXIT DATABASE.TABLE
# 0 1 0 0 Chunk 13:59:51 13:59:51 2 test.t1
nilnandan@
Even without PTDEBUG, it didn't give any error/warning.
nilnandan@ Dell-XPS: ~$ pt-table-checksum --user=root --password=msandbox --socket= /tmp/mysql_ sandbox20082. sock --recursion-method dsn=D=percona, t=dsns binlog_ index zone_leap_ second zone_name zone_transition zone_transition _type Dell-XPS: ~$ Dell-XPS: ~$ pt-table-sync --charset utf8 --execute --verbose --function MD5 --database test --tables t1 --sync-to-master h=localhost, u=root, p=msandbox, S=/tmp/ mysql_sandbox20 083.sock S=/tmp/ mysql_sandbox20 083.sock, h=localhost, p=...,u= root Dell-XPS: ~$
TS ERRORS DIFFS ROWS CHUNKS SKIPPED TIME TABLE
09-10T14:36:43 0 0 100000 5 0 0.625 dbtest.sbtest
09-10T14:36:43 0 0 0 1 0 0.042 mysql.columns_priv
09-10T14:36:43 0 0 0 1 0 0.025 mysql.db
09-10T14:36:43 0 0 0 1 0 0.026 mysql.event
09-10T14:36:43 0 0 0 1 0 0.044 mysql.func
09-10T14:36:43 0 0 40 1 0 0.044 mysql.help_category
09-10T14:36:43 0 0 485 1 0 0.033 mysql.help_keyword
09-10T14:36:43 0 0 1090 1 0 0.046 mysql.help_relation
09-10T14:36:44 0 0 533 1 0 0.046 mysql.help_topic
09-10T14:36:44 0 0 0 1 0 0.045 mysql.ndb_
09-10T14:36:44 0 0 0 1 0 0.039 mysql.plugin
09-10T14:36:44 0 0 0 1 0 0.040 mysql.proc
09-10T14:36:44 0 0 0 1 0 0.026 mysql.procs_priv
09-10T14:36:44 0 0 2 1 0 0.042 mysql.proxies_priv
09-10T14:36:44 0 0 0 1 0 0.051 mysql.servers
09-10T14:36:44 0 0 0 1 0 0.048 mysql.tables_priv
09-10T14:36:44 0 0 0 1 0 0.038 mysql.time_zone
09-10T14:36:44 0 0 0 1 0 0.035 mysql.time_
09-10T14:36:44 0 0 0 1 0 0.035 mysql.time_
09-10T14:36:44 0 0 0 1 0 0.033 mysql.time_
09-10T14:36:44 0 0 0 1 0 0.040 mysql.time_
09-10T14:36:44 0 0 8 1 0 0.034 mysql.user
09-10T14:36:44 0 0 1 1 0 0.033 percona.dsns
09-10T14:36:44 0 1 5 1 0 0.028 test.t1
nilnandan@
nilnandan@
# Syncing A=utf8,
# DELETE REPLACE INSERT UPDATE ALGORITHM START END EXIT DATABASE.TABLE
# 0 1 0 0 Chunk 14:36:51 14:36:51 2 test.t1
nilnandan@