enterprise-support team mailing list archive

[Raghavendra D Prabhu <raghavendra.prabhu@xxxxxxxxxxx>]

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