Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Critical
-
Resolution: Fixed
-
Affects Version/s: 10.5.15, 10.2, 10.3, 10.4, 10.5, 10.6, 10.7, 10.8, 10.9
-
Component/s: Replication
-
Labels:None
-
Environment:linux
Description
I have a master slave setup. And two tables calculate different checksums, while the data seems be in sync.
checksum table A, ASlave extended;
|
Table | Checksum |
A | 1139480600 |
ASlave | 1134561865 |
(select * from ASlave ORDER BY ID ) except (select * from A ORDER BY ID);
|
Empty set (2.461 sec)
(select * from A ORDER BY ID ) except (select * from ASlave ORDER BY ID);
|
|
Empty set (2.418 sec)
Any other command to check for differences in tables?
Attachments
Issue Links
- relates to
-
MDEV-15519 CHECKSUM TABLE gives different results across MariaDB 10.0 and 10.2
-
- Confirmed
-