pxc2>select count(*) total from tbl_0; select count(*) node1 from tbl_0 where reg_key like 'pxc1%'; select count(*) node2 from tbl_0 where reg_key like 'pxc2%'; select count(*) node3 from tbl_0 where reg_key like 'pxc3%';
+-------+
| total |
+-------+
| 297 |
+-------+
1 row in set (0.00 sec)
+-------+
| node1 |
+-------+
| 99 |
+-------+
1 row in set (0.00 sec)
+-------+
| node2 |
+-------+
| 99 |
+-------+
1 row in set (0.00 sec)
+-------+
| node3 |
+-------+
| 99 |
+-------+
1 row in set (0.00 sec)
Cannot reproduce using PXC 5.6.15 + Galera 3.5:
parallel-ssh -P -h 3nodes56.pssh -x "-i /home/przemysla w.malkowski/ .vagrant. d/insecure_ private_ key -oStrictHostKey Checking= no" 'sudo /root/test.sh 1 100 1' 127.0.0. 1:2222 127.0.0. 1:2203 127.0.0. 1:2202
[1] 08:50:33 [SUCCESS] vagrant@
[2] 08:50:33 [SUCCESS] vagrant@
[3] 08:50:33 [SUCCESS] vagrant@
pxc2>select count(*) total from tbl_0; select count(*) node1 from tbl_0 where reg_key like 'pxc1%'; select count(*) node2 from tbl_0 where reg_key like 'pxc2%'; select count(*) node3 from tbl_0 where reg_key like 'pxc3%';
+-------+
| total |
+-------+
| 297 |
+-------+
1 row in set (0.00 sec)
+-------+
| node1 |
+-------+
| 99 |
+-------+
1 row in set (0.00 sec)
+-------+
| node2 |
+-------+
| 99 |
+-------+
1 row in set (0.00 sec)
+-------+
| node3 |
+-------+
| 99 |
+-------+
1 row in set (0.00 sec)
No deadlocks noted.