pt-table-checksum reports diffs on timestamp columns in 5.5 vs 5.6
Bug #1321297 reported by
Joe
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
Fix Released
|
Medium
|
Frank Cizmich |
Bug Description
When running pt-table-checksum on tables with timestamp columns and replicating from 5.5 to 5.6, differences are reported when the column data actually matches.
It looks like this is because of this line...
http://
If I change that to ...
$result .= '';
No differences are reported.
Related branches
lp:~percona-toolkit-dev/percona-toolkit/ptc-errors-on-slave-with-different-time-zone-1388870
- Daniel Nichter: Needs Fixing
-
Diff: 155 lines (+38/-13)7 files modifiedbin/pt-table-checksum (+3/-3)
lib/RowChecksum.pm (+3/-3)
t/lib/RowChecksum.t (+4/-4)
t/pt-table-checksum/bugs.t (+25/-0)
t/pt-table-checksum/samples/chunkidx004.txt (+1/-1)
t/pt-table-checksum/samples/chunkidx005.txt (+1/-1)
t/pt-table-checksum/samples/n-chunk-index-cols.txt (+1/-1)
Changed in percona-toolkit: | |
status: | Expired → New |
Changed in percona-toolkit: | |
milestone: | none → 2.2.13 |
status: | New → In Progress |
importance: | Undecided → Medium |
assignee: | nobody → Frank Cizmich (frank-cizmich) |
Changed in percona-toolkit: | |
status: | In Progress → Fix Committed |
Changed in percona-toolkit: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
Hi, I have tried to reproduce it with Master(5.5) and Slave (5.6) but unable to found any differences for timestamp column.
Can you please provide exact steps to reproduce it?
Master:
mysql> show create table test \G ******* ******* ****** 1. row ******* ******* ******* ******
*******
Table: test
Create Table: CREATE TABLE `test` (
`id` int(11) DEFAULT NULL,
`name` varchar(10) DEFAULT NULL,
`bdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1
1 row in set (0.00 sec)
mysql> select version(); ------- ------- -----+ ------- ------- -----+ 34.2-rel34. 2-log | ------- ------- -----+
+------
| version() |
+------
| 5.5.36-
+------
1 row in set (0.00 sec)
mysql>
Slave:
mysql> select version();
+----------------+
| version() |
+----------------+
| 5.6.15-rel63.0 |
+----------------+
1 row in set (0.00 sec)
mysql>
nilnandan@ nilnandan- Dell-XPS: ~$ pt-table-checksum --socket= /tmp/mysql_ sandbox5536. sock --recursion- method= DSN=h=localhost ,D=percona, t=dsns --databases=nil nilnandan- Dell-XPS: ~$
TS ERRORS DIFFS ROWS CHUNKS SKIPPED TIME TABLE
08-05T16:03:18 0 0 2904 4 0 0.160 nil.test
nilnandan@