Comment 1 for bug 1437775

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

Confirmed.

nilnandan@desktop:~$ pt-table-sync --version
pt-table-sync 2.2.14
nilnandan@desktop:~$

mysql> create table `nil-test` (id int);
Query OK, 0 rows affected (0.02 sec)

nilnandan@desktop:~$ pt-table-sync --user=root --password=msandbox --socket=/tmp/mysql_sandbox20886.sock --replicate=test.nil-test --databases=test --dry-run --print h=localhost
# NOTE: --dry-run does not show if data needs to be synced because it
# does not access, compare or sync data. --dry-run only shows
# the work that would be done.
DBD::mysql::db selectall_arrayref failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-test WHERE master_cnt <> this_cnt OR master_crc <> this_crc OR ISNULL(master_cr' at line 1 [for Statement "SELECT db, tbl, CONCAT(db, '.', tbl) AS `table`, chunk, chunk_index, lower_boundary, upper_boundary, COALESCE(this_cnt-master_cnt, 0) AS cnt_diff, COALESCE(this_crc <> master_crc OR ISNULL(master_crc) <> ISNULL(this_crc), 0) AS crc_diff, this_cnt, master_cnt, this_crc, master_crc FROM test.nil-test WHERE master_cnt <> this_cnt OR master_crc <> this_crc OR ISNULL(master_crc) <> ISNULL(this_crc)"] at /usr/bin/pt-table-sync line 4957.
Issuing rollback() due to DESTROY without explicit disconnect() of DBD::mysql::db handle ;host=localhost;mysql_socket=/tmp/mysql_sandbox20886.sock;mysql_read_default_group=client at /usr/bin/pt-table-sync line 4957.
Issuing rollback() due to DESTROY without explicit disconnect() of DBD::mysql::db handle ;host=localhost;mysql_socket=/tmp/mysql_sandbox20886.sock;mysql_read_default_group=client at /usr/bin/pt-table-sync line 4957.
nilnandan@desktop:~$