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.
** Also affects: percona-server
Importance: Undecided
Status: New
** Also affects: percona-server/5.5
Importance: Undecided
Status: New
** Also affects: percona-server/5.6
Importance: Undecided
Status: New
--
You received this bug notification because you are a member of Ubuntu
Server/Client Support Team, which is subscribed to MySQL.
Matching subscriptions: Ubuntu Server/Client Support Team
https://bugs.launchpad.net/bugs/1308016
Title:
Duplicate UK values can be replicated under concurrent workload with
READ-COMMITTED
To manage notifications about this bug go to:
https://bugs.launchpad.net/codership-mysql/+bug/1308016/+subscriptions
--
Mailing list: https://launchpad.net/~enterprise-support
Post to : [email protected]
Unsubscribe : https://launchpad.net/~enterprise-support
More help : https://help.launchpad.net/ListHelp
