# Ignore unique key violation errors (1062) in multiwrite setup (slave\_skip\_errors?)

**URL:** <https://forums.percona.com/t/ignore-unique-key-violation-errors-1062-in-multiwrite-setup-slave-skip-errors/3437>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [April 30, 2014, 3:54am UTC](https://forums.percona.com/t/ignore-unique-key-violation-errors-1062-in-multiwrite-setup-slave-skip-errors/3437 "2014-04-30T03:54:44Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![kartoffelheinz](https://avatars.discourse-cdn.com/v4/letter/k/dbc845/32.png) [@kartoffelheinz](https://forums.percona.com/u/kartoffelheinz)\
**Post date:** [April 30, 2014, 3:54am UTC](https://forums.percona.com/t/ignore-unique-key-violation-errors-1062-in-multiwrite-setup-slave-skip-errors/3437/1 "2014-04-30T03:54:44Z")

</div>

We have a 3-node xtradb 5.6 cluster doing multiwrites. From time to time, it happens that two nodes try to insert into a unique column at the same time, making the losing node inconstitent and having it dropped from the cluster. As a sidenote, a simple restart is rarely enough to bringt it back online with IST, most times a restart directly triggers SST, but after that, it errors out with innodb log failures and we have to delete data-directory and do another full SST. That seems to be some kind of bug or misconfiguration, but that got nothing to do with my question, I guess.

We would like to avoid these errors altogether, since the inserts into that table are not that important. With mysql master-slave replication, there is slave-skip-errors=1062 - is there an equivalent for xtradb cluster replication?

---

<div class="post-metadata">

**Author:** ![przemek](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/przemek/32/3_2.png) [@przemek](https://forums.percona.com/u/przemek)\
**Post date:** [April 30, 2014, 6:22am UTC](https://forums.percona.com/t/ignore-unique-key-violation-errors-1062-in-multiwrite-setup-slave-skip-errors/3437/2 "2014-04-30T06:22:50Z")

</div>

You may be experiencing this bug:  
[url][https://bugs.launchpad.net/codership-mysql/+bug/1308016[/url]](https://bugs.launchpad.net/codership-mysql/+bug/1308016%5B/url%5D)

And no, at the moment there is no such equivalent at the time, as galera based cluster’s priority goal is to guard against inconsistency.

---

<div class="post-metadata">

**Author:** ![kartoffelheinz](https://avatars.discourse-cdn.com/v4/letter/k/dbc845/32.png) [@kartoffelheinz](https://forums.percona.com/u/kartoffelheinz)\
**Post date:** [April 30, 2014, 3:04pm UTC](https://forums.percona.com/t/ignore-unique-key-violation-errors-1062-in-multiwrite-setup-slave-skip-errors/3437/3 "2014-04-30T15:04:00Z")

</div>

Thanks for your reply.

You might be right, the bug description sounds familiar. Do you know when there will be a fixed version available?