# WSREP: skipping FK key append

**URL:** <https://forums.percona.com/t/wsrep-skipping-fk-key-append/2471>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [September 12, 2012, 10:38am UTC](https://forums.percona.com/t/wsrep-skipping-fk-key-append/2471 "2012-09-12T10:38:45Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![azigui](https://avatars.discourse-cdn.com/v4/letter/a/cab0a1/32.png) [@azigui](https://forums.percona.com/u/azigui)\
**Post date:** [September 12, 2012, 10:38am UTC](https://forums.percona.com/t/wsrep-skipping-fk-key-append/2471/1 "2012-09-12T10:38:45Z")

</div>

Hi,

Can you tell me what is it this problem in my error log ?  
120912 17:33:20 [ERROR] WSREP: FK key set failed: 11  
WSREP: FK key append failed  
WSREP: FK key len exceeded 0 4294967295 3500  
120912 17:33:20 [ERROR] WSREP: FK key set failed: 11  
WSREP: FK key append failed  
WSREP: FK key len exceeded 0 4294967295 3500  
120912 17:33:20 [ERROR] WSREP: FK key set failed: 11  
WSREP: FK key append failed  
WSREP: FK key len exceeded 0 4294967295 3500  
120912 17:33:20 [ERROR] WSREP: FK key set failed: 11  
WSREP: FK key append failed  
WSREP: FK key len exceeded 0 4294967295 3500  
120912 17:33:20 [ERROR] WSREP: FK key set failed: 11  
WSREP: FK key append failed  
WSREP: FK key len exceeded 0 4294967295 3500  
120912 17:33:20 [ERROR] WSREP: FK key set failed: 11  
WSREP: FK key append failed…  
WSREP: skipping FK key append  
WSREP: skipping FK key append  
WSREP: skipping FK key append  
WSREP: skipping FK key append  
WSREP: skipping FK key append  
WSREP: skipping FK key append  
WSREP: skipping FK key append  
WSREP: skipping FK key append…

This happen when I want to insert records from database installed on MySQL Server standard to an other database installed on PXC. This is not installed on the same machine.

Best regards

Azigui

---

<div class="post-metadata">

**Author:** ![undead](https://avatars.discourse-cdn.com/v4/letter/u/b3f665/32.png) [@undead](https://forums.percona.com/u/undead)\
**Post date:** [September 13, 2012, 6:57am UTC](https://forums.percona.com/t/wsrep-skipping-fk-key-append/2471/2 "2012-09-13T06:57:44Z")

</div>

hello  
i have the same problem. how can i fix it?  
Thanks!

---

<div class="post-metadata">

**Author:** ![azigui](https://avatars.discourse-cdn.com/v4/letter/a/cab0a1/32.png) [@azigui](https://forums.percona.com/u/azigui)\
**Post date:** [September 17, 2012, 8:57am UTC](https://forums.percona.com/t/wsrep-skipping-fk-key-append/2471/3 "2012-09-17T08:57:39Z")

</div>

I fix the problem.  
I disable wsrep\_causal\_reads variable in my.cnf