This bug is still alive, at least for Percona Server.
@Nil,
This bug is not present in single node version of PXC either.
I believe the upstream fix fixed it only for non-replication cases.
With PS master-master replication and writes to one node with 3 parallel sessions of that stored procedure, I can replicate this issue.
2014-11-18 06:11:52 22338 [ERROR] Slave SQL: Could not execute Write_rows event on table sp2.t1; Duplicate entry '0' for key 'a', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log archie-bin.000052, end_log_pos 63335202, Error_code: 1062 2014-11-18 06:11:52 22338 [Warning] Slave: Duplicate entry '0' for key 'a' Error_code: 1062 2014-11-18 06:11:52 22338 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'archie-bin.000052' position 63334974
@Valerii, @Nil,
I suggest further testing with PS and MySQL, and please file upstream bug report if/when required.
This bug is still alive, at least for Percona Server.
@Nil,
This bug is not present in single node version of PXC either.
I believe the upstream fix fixed it only for non-replication cases.
With PS master-master replication and writes to one node with 3 parallel
sessions of that stored procedure, I can replicate this issue.
2014-11-18 06:11:52 22338 [ERROR] Slave SQL: Could not execute Write_rows event on table sp2.t1; Duplicate entry '0' for key 'a', Error_code: 1062; handler error HA_ERR_ FOUND_DUPP_ KEY; the event's master log archie-bin.000052, end_log_pos 63335202, Error_code: 1062
2014-11-18 06:11:52 22338 [Warning] Slave: Duplicate entry '0' for key 'a' Error_code: 1062
2014-11-18 06:11:52 22338 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'archie-bin.000052' position 63334974
@Valerii, @Nil,
I suggest further testing with PS and MySQL, and please file upstream bug report
if/when required.