Hi,
I'm getting exactly the same results for 5.6.36-82.1 as you listed for 5.6.36-82.0.
mysql> SELECT DISTINCT partner0_.organizationOID AS col_0_0_ FROM mad_partner partner0_ WHERE partner0_.OID IN ( -> 'be067ca5-6cd3-42dc-8a68-a08e9800b195', -> 'dff1ffa7-58c2-46f3-9880-9a02e8e9c8ab', -> '8c1fb1ae-25e2-49f8-bb6a-65b5716d0d2b', -> '7a090a98-08ec-4924-ac1a-d4b45c749cac', -> '83031acb-43cd-4c97-963e-8692a007aba5'); +--------------------------------------+ | col_0_0_ | +--------------------------------------+ | e0f52141-941b-437c-87a5-dff3f4f74999 | +--------------------------------------+ 1 row in set (0.00 sec)
mysql> SELECT DISTINCT partner0_.organizationOID AS col_0_0_ FROM mad_partner partner0_ WHERE partner0_.OID IN ( -> 'dff1ffa7-58c2-46f3-9880-9a02e8e9c8ab', -> '7a090a98-08ec-4924-ac1a-d4b45c749cac', -> 'be067ca5-6cd3-42dc-8a68-a08e9800b195'); +--------------------------------------+ | col_0_0_ | +--------------------------------------+ | e0f52141-941b-437c-87a5-dff3f4f74999 | +--------------------------------------+ 1 row in set (0.00 sec)
mysql> select version(); +-------------+ | version() | +-------------+ | 5.6.36-82.1 | +-------------+ 1 row in set (0.00 sec)
Could you try to reproduce the issue on single server or verify that data is the same on master and slaves with pt-table-checksum: https://www.percona.com/blog/2015/08/12/mysql-replication-primer-with-pt-table-checksum-and-pt-table-sync/
Thanks, Nickolay
Hi,
I'm getting exactly the same results for 5.6.36-82.1 as you listed for 5.6.36-82.0.
mysql> SELECT DISTINCT partner0_ .organizationOI D AS col_0_0_ FROM mad_partner partner0_ WHERE partner0_.OID IN ( 6cd3-42dc- 8a68-a08e9800b1 95', 58c2-46f3- 9880-9a02e8e9c8 ab', 25e2-49f8- bb6a-65b5716d0d 2b', 08ec-4924- ac1a-d4b45c749c ac', 43cd-4c97- 963e-8692a007ab a5'); ------- ------- ------- ------- ----+ ------- ------- ------- ------- ----+ 941b-437c- 87a5-dff3f4f749 99 | ------- ------- ------- ------- ----+
-> 'be067ca5-
-> 'dff1ffa7-
-> '8c1fb1ae-
-> '7a090a98-
-> '83031acb-
+------
| col_0_0_ |
+------
| e0f52141-
+------
1 row in set (0.00 sec)
mysql> SELECT DISTINCT partner0_ .organizationOI D AS col_0_0_ FROM mad_partner partner0_ WHERE partner0_.OID IN ( 58c2-46f3- 9880-9a02e8e9c8 ab', 08ec-4924- ac1a-d4b45c749c ac', 6cd3-42dc- 8a68-a08e9800b1 95'); ------- ------- ------- ------- ----+ ------- ------- ------- ------- ----+ 941b-437c- 87a5-dff3f4f749 99 | ------- ------- ------- ------- ----+
-> 'dff1ffa7-
-> '7a090a98-
-> 'be067ca5-
+------
| col_0_0_ |
+------
| e0f52141-
+------
1 row in set (0.00 sec)
mysql> select version();
+-------------+
| version() |
+-------------+
| 5.6.36-82.1 |
+-------------+
1 row in set (0.00 sec)
Could you try to reproduce the issue on single server or verify that data is the same on master and slaves with pt-table-checksum: https:/ /www.percona. com/blog/ 2015/08/ 12/mysql- replication- primer- with-pt- table-checksum- and-pt- table-sync/
Thanks,
Nickolay