Certification failure for table having unique key

Bug #1259977 reported by Henrik Torelm on 2013-12-11
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Galera
Undecided
Unassigned

Bug Description

Galera cluster (with two nodes) is failing to commit due to certification failure on table having unique key.

Steps to reproduce:

1) Setup Galera cluster (MySQL 5.6 with wsrep patch, galera provider version 2 or 3) on two nodes
2) Create database "test"
3) Load schema and data to the database from "test_2013-11-27.sql"
4) Run query files (different!) simultaneously on both servers

Run at server 1:
mysql -u root test < query101_1.sql

Run at server 2:
mysql -u root test < query102_1.sql

---
Expected: no errors/failures

---
Experienced:
Failure in mysql.err:

2013-11-27 12:37:48 25742 [Note] WSREP: cluster conflict due to certification failure for threads:
2013-11-27 12:37:48 25742 [Note] WSREP: Victim thread:
   THD: 180, mode: local, state: executing, conflict: cert failure, seqno: 722967
   SQL: commit

---
Observations:

Issue (failure) does not appear in following cases:
1) Drop unique key;
2) Run both query files at one of servers (locally, simultaneously).

Note that none of the rows in table are updated from more than one node i.e. same row is not updated from both nodes.
But, same row updated more than once on same node.

Attached instructions to reproduce, schema and testdata

Henrik Torelm (henrik-torelm) wrote :
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers