this_crc is 0 in master and slave , and the table have diff record but pt-table-sync and pt-table-checksums no check out that.
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
Fix Committed
|
Undecided
|
Frank Cizmich |
Bug Description
Master Result:
+------
| TenderID | UnitID | TenderClassific
+------
| 12190 | 17924 | 3 |
| 12190 | 17925 | 3 |
| 12190 | 17926 | 3 |
| 12190 | 17927 | 3 |
| 12191 | 17924 | 2 |
| 12191 | 17925 | 2 |
| 12191 | 17926 | 2 |
| 12191 | 17927 | 2 |
+------
Slave result:
+------
| TenderID | UnitID | TenderClassific
+------
| 12190 | 17924 | 3 |
| 12190 | 17925 | 3 |
| 12190 | 17926 | 3 |
| 12190 | 17927 | 3 |
| 12191 | 17924 | 3 |
| 12191 | 17925 | 3 |
| 12191 | 17926 | 3 |
| 12191 | 17927 | 3 |
+------
Table structure:
Create Table: CREATE TABLE `tender_unit` (
`TenderID` int(10) unsigned NOT NULL DEFAULT '0',
`UnitID` int(10) unsigned NOT NULL DEFAULT '0',
`TenderClassi
PRIMARY KEY (`TenderID`
KEY `UnitID` (`UnitID`),
KEY `TenderClassifi
CONSTRAINT `tender_
CONSTRAINT `tender_
) ENGINE=InnoDB DEFAULT CHARSET=utf8
Command:
pt-table-sync --print --charset=utf8 --no-check-triggers --no-check-slave --no-foreign-
mysql> select COALESCE(
+------+
| crc |
+------+
| 0 |
+------+
checksum result:
+------
| db | tbl | chunk | chunk_time | chunk_index | lower_boundary | upper_boundary | this_crc | this_cnt | master_crc | master_cnt | ts |
+------
| tksing | tender_unit | 1 | 0.09623 | NULL | NULL | NULL | dd3ad519 | 51415 | dd3ad519 | 51415 | 2015-05-13 17:24:19 |
+------
Changed in percona-toolkit: | |
status: | Triaged → Fix Committed |
Hello Damon,
I've tried the sql command on the sample data you provide and the crc does not return 0.
You are trying to sync two independent servers , right? (not master - slave)
If the problem persists, can you please run again and attach PTDEBUG output log file?
(running like this)
PTDEBUG=1 [command] 2> logfile