# crash node

**URL:** <https://forums.percona.com/t/crash-node/2540>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [February 27, 2013, 9:47am UTC](https://forums.percona.com/t/crash-node/2540 "2013-02-27T09:47:16Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![masla](https://avatars.discourse-cdn.com/v4/letter/m/d2c977/32.png) [@masla](https://forums.percona.com/u/masla)\
**Post date:** [February 27, 2013, 9:47am UTC](https://forums.percona.com/t/crash-node/2540/1 "2013-02-27T09:47:16Z")

</div>

Hi,  
I have installed percona xtradb cluster on CentOS 6.

Percona-XtraDB-Cluster-server-5.5.28-23.7.369.rhel6.x86\_64  
Percona-XtraDB-Cluster-galera-2.0-1.117.rhel6.x86\_64

There are still problems, whith which I need your help:

During the restore DB with LOAD DATA INFILE

nod options:  
wsrep\_provider=/usr/lib64/libgalera\_smm.so  
wsrep\_sst\_receive\_address=172.31.6.x:3320  
wsrep\_node\_incoming\_address=172.31.6.x  
wsrep\_slave\_threads=2  
wsrep\_cluster\_name=trimethylxanthine  
wsrep\_provider\_options = “gmcast.listen\_addr=tcp://172.31.6.x:3330;”  
wsrep\_sst\_method=rsync  
wsrep\_node\_name=node3330  
wsrep\_max\_ws\_size=4G

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?

---

<div class="post-metadata">

**Author:** ![revin](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/revin/32/824_2.png) [@revin](https://forums.percona.com/u/revin)\
**Post date:** [March 1, 2013, 12:09am UTC](https://forums.percona.com/t/crash-node/2540/2 "2013-03-01T00:09:47Z")

</div>

Can you provide your MySQL error log and/or innodb/global status prior to the crash if you can repeat this?
