Comment 2 for bug 1275034

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

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:~$