# PXC 8.0.27 - when inserting the data using LOAD DATA INTO TABLE - Nodes are hung

**URL:** <https://forums.percona.com/t/pxc-8-0-27-when-inserting-the-data-using-load-data-into-table-nodes-are-hung/18570>\
**Category:** Percona XtraDB Cluster\
**Tags:** mysql, percona\
**Created:** [November 15, 2022, 5:16pm UTC](https://forums.percona.com/t/pxc-8-0-27-when-inserting-the-data-using-load-data-into-table-nodes-are-hung/18570 "2022-11-15T17:16:38Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![AneeshBabu](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/aneeshbabu/32/1393_2.png) [@AneeshBabu](https://forums.percona.com/u/AneeshBabu)\
**Post date:** [November 15, 2022, 5:16pm UTC](https://forums.percona.com/t/pxc-8-0-27-when-inserting-the-data-using-load-data-into-table-nodes-are-hung/18570/1 "2022-11-15T17:16:38Z")

</div>

Hi there,  
we have 3 node PXC 8.0.27 cluster , when inserting the data using `LOAD DATA INTO TABLE`.  
The nodes are not responding and there in hung state.  
And also data is not replicated to other nodes

Is this expected …?

---

<div class="post-metadata">

**Author:** ![Pep\_Pla](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/pep_pla/32/9735_2.png) [@Pep\_Pla](https://forums.percona.com/u/Pep_Pla)\
**Post date:** [November 15, 2022, 5:40pm UTC](https://forums.percona.com/t/pxc-8-0-27-when-inserting-the-data-using-load-data-into-table-nodes-are-hung/18570/2 "2022-11-15T17:40:04Z")

</div>

Hi @AneeshBabu,

Thank you for your question. Could you provide more information about the data you are loading? How big is the file. Table structure.

From the documentation: [Percona XtraDB Cluster limitations - Percona XtraDB Cluster](https://docs.percona.com/percona-xtradb-cluster/8.0/limitation.html)

> - Maximum allowed transaction size is defined by the [`wsrep_max_ws_rows`](https://docs.percona.com/percona-xtradb-cluster/8.0/wsrep-system-index.html#wsrep_max_ws_rows) and [`wsrep_max_ws_size`](https://docs.percona.com/percona-xtradb-cluster/8.0/wsrep-system-index.html#wsrep_max_ws_size) variables.  
> `LOAD DATA INFILE` processing will commit every 10 000 rows. So large transactions due to `LOAD DATA` will be split to series of small transactions.

What is the value of those variables?

Pep