Not the answer you need?
Register and ask your own question!

WSREP: skipping FK key append

aziguiazigui ContributorCurrent User Role Beginner
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

Comments

  • undeadundead Entrant Inactive User Role Beginner
    hello
    i have the same problem. how can i fix it?
    Thanks!
  • aziguiazigui Contributor Current User Role Beginner
    I fix the problem.
    I disable wsrep_causal_reads variable in my.cnf
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.