Comment 8 for bug 1314854

Revision history for this message
Przemek (pmalkowski) wrote :

Cannot reproduce using PXC 5.6.15 + Galera 3.5:

parallel-ssh -P -h 3nodes56.pssh -x "-i /home/przemyslaw.malkowski/.vagrant.d/insecure_private_key -oStrictHostKeyChecking=no" 'sudo /root/test.sh 1 100 1'
[1] 08:50:33 [SUCCESS] vagrant@127.0.0.1:2222
[2] 08:50:33 [SUCCESS] vagrant@127.0.0.1:2203
[3] 08:50:33 [SUCCESS] vagrant@127.0.0.1:2202

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.