I have installed percona xtradb cluster on CentOS 6.
There are still problems, whith which I need your help:
During the restore DB with LOAD DATA INFILE
wsrep_provider_options = “gmcast.listen_addr=tcp://172.31.6.x:3330;”
if transaction is bigger than 4G, it will end and these two messages
will be displayed and node always crashed:
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock;
try restarting transaction
ERROR 2013 (HY000) at line 1: Lost connection to MySQL server during query
Sometimes it happens during the smaller transaction, too:
ERROR 1047 (08S01) at line 1: Unknown command
When I run the same command later again, it will be processed.
Could you give me an advise, what can be wrong, please?