Percona Server moved to https://jira.percona.com/projects/PS

  1. Bug #1308016
  2. Comment #13

Comment 13 for bug 1308016

Revision history for this message
Raghavendra D Prabhu (raghavendra-prabhu) wrote : Re: Duplicate UK values can be replicated under concurrent workload with READ-COMMITTED

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.