pt-table-sync print update sql for one row of table but they are totally same between master and slave
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
New
|
Undecided
|
Unassigned |
Bug Description
Mysql version : 5.5.32-log MySQL Community Server (GPL)
percona toolkit version : 2.2.11
pt-table-sync --print --charset=utf8 --no-check-triggers --function=MD5 --no-check-slave --no-foreign-
UPDATE `***`.`check_table` SET `docketno`
', `createddate`
mysql> show create table check_table\G;
*******
Table: check_table
Create Table: CREATE TABLE `check_table` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`DocketNo` varchar(36) DEFAULT NULL,
`VisitedUnitN
`TimesheetID` int(10) DEFAULT NULL,
`AH(Total Mins)` int(10) DEFAULT NULL,
`BH(Total Mins)` int(10) DEFAULT NULL,
`AvgManhourPe
`ActivityType` varchar(30) DEFAULT NULL,
`EmployeeID` varchar(255) DEFAULT NULL,
`EmployeeName` varchar(150) DEFAULT NULL,
`BuildingName` varchar(255) DEFAULT NULL,
`CreatedDate` datetime DEFAULT NULL,
`ArrivalDate` datetime DEFAULT NULL,
`BranchID` int(10) DEFAULT NULL,
`StructureID` int(10) DEFAULT NULL,
`OLIYear` int(11) NOT NULL,
`OLIMonth` int(11) NOT NULL,
`OLIDay` int(11) NOT NULL,
`VersionNo` varchar(50) DEFAULT NULL,
`ProcessingDate` date DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `processingDate` (`ProcessingDate`),
KEY `BranchID` (`BranchID`)
) ENGINE=InnoDB AUTO_INCREMENT=
1 row in set (0.00 sec)
ERROR:
No query specified
mysql> desc check_table;
+------
| Field | Type | Null | Key | Default | Extra |
+------
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| DocketNo | varchar(36) | YES | | NULL | |
| VisitedUnitNumber | varchar(100) | YES | | NULL | |
| TimesheetID | int(10) | YES | | NULL | |
| AH(Total Mins) | int(10) | YES | | NULL | |
| BH(Total Mins) | int(10) | YES | | NULL | |
| AvgManhourPerUnit | double | YES | | NULL | |
| ActivityType | varchar(30) | YES | | NULL | |
| EmployeeID | varchar(255) | YES | | NULL | |
| EmployeeName | varchar(150) | YES | | NULL | |
| BuildingName | varchar(255) | YES | | NULL | |
| CreatedDate | datetime | YES | | NULL | |
| ArrivalDate | datetime | YES | | NULL | |
| BranchID | int(10) | YES | MUL | NULL | |
| StructureID | int(10) | YES | | NULL | |
| OLIYear | int(11) | NO | | NULL | |
| OLIMonth | int(11) | NO | | NULL | |
| OLIDay | int(11) | NO | | NULL | |
| VersionNo | varchar(50) | YES | | NULL | |
| ProcessingDate | date | YES | MUL | NULL | |
+------
data in slave:
mysql> select * from check_table where id=396179\G;
*******
id: 396179
DocketNo: 392933
VisitedUnitNumber: 65602496000200001
TimesheetID: 322937
AH(Total Mins): 120
BH(Total Mins): 1020
AvgManhourPerUnit: 6.333333333333333
ActivityType: M
EmployeeID: 226714/78416
EmployeeName: Fatih Aydin/Fatih Akoglu
BuildingName: KERVANSARAY LARA GÜZELOBA TRT KAMPI YANI KUNDU
CreatedDate: 2015-10-19 16:15:04
ArrivalDate: 2015-10-06 09:00:00
BranchID: 914
StructureID: 2
OLIYear: 2015
OLIMonth: 10
OLIDay: 25
VersionNo: TR20151025_P
ProcessingDate: 2015-10-25
1 row in set (0.00 sec)
ERROR:
No query specified
data in master:
mysql> select * from check_table where id=396179\G;
*******
id: 396179
DocketNo: 392933
VisitedUnitNumber: 65602496000200001
TimesheetID: 322937
AH(Total Mins): 120
BH(Total Mins): 1020
AvgManhourPerUnit: 6.333333333333333
ActivityType: M
EmployeeID: 226714/78416
EmployeeName: Fatih Aydin/Fatih Akoglu
BuildingName: KERVANSARAY LARA GÜZELOBA TRT KAMPI YANI KUNDU
CreatedDate: 2015-10-19 16:15:04
ArrivalDate: 2015-10-06 09:00:00
BranchID: 914
StructureID: 2
OLIYear: 2015
OLIMonth: 10
OLIDay: 25
VersionNo: TR20151025_P
ProcessingDate: 2015-10-25
1 row in set (0.00 sec)
ERROR:
No query specified
tags: | added: 21 |
tags: |
added: pt-table-sync removed: 21 |
Hi Alber,
could you try using this option:
--float-precision 5
https:/ /www.percona. com/doc/ percona- toolkit/ 2.2/pt- table-sync. html#cmdoption- pt-table- sync--float- precision
if that doesn't work, could you check if the charset and collation are the same on both tables?
show create table check_table; table'\ G
show table status where Name='check_