# mysqldump import = deadlock?

**URL:** <https://forums.percona.com/t/mysqldump-import-deadlock/2460>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [August 8, 2012, 9:35am UTC](https://forums.percona.com/t/mysqldump-import-deadlock/2460 "2012-08-08T09:35:47Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![nickdemaster](https://avatars.discourse-cdn.com/v4/letter/n/eada6e/32.png) [@nickdemaster](https://forums.percona.com/u/nickdemaster)\
**Post date:** [August 8, 2012, 9:35am UTC](https://forums.percona.com/t/mysqldump-import-deadlock/2460/1 "2012-08-08T09:35:47Z")

</div>

I have a default install of Percona XtraDB Server version: 5.5.24-log Percona XtraDB Cluster (GPL), wsrep\_23.6.r341.

The environment is 4 node, OEL 5.5 VM with 6GB (4GB allocated to MySQL).

These are the my.cnf variables pertaining to galera:

wsrep\_provider=/usr/lib64/libgalera\_smm.so  
wsrep\_cluster\_address=gcomm://  
wsrep\_slave\_threads=8  
wsrep\_sst\_method=rsync  
wsrep\_cluster\_name=percona\_cluster  
binlog\_format=ROW  
default\_storage\_engine=InnoDB

Anytime I try to import a mysqldump import, no matter the size - from 12MB to 8GB so far, I get a deadlock error and the import stops.

Am I missing something easy here?

---

<div class="post-metadata">

**Author:** ![lefred](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/lefred/32/16885_2.png) [@lefred](https://forums.percona.com/u/lefred)\
**Post date:** [August 14, 2012, 1:47am UTC](https://forums.percona.com/t/mysqldump-import-deadlock/2460/2 "2012-08-14T01:47:30Z")

</div>

Hello,

That should not be a problem, but some remarks:

- check the size of your transaction logs (innodb\_log\_file\_size)
- do you import in one single transaction ?
- you should try to have odd number of nodes (for quorum), but that’s is of course not the problem.

What I would try is:  
perform the import with only one node active and then join the other nodes and let them do their SST.

regards,