# Percona-XtraDB-Cluster is not allowing sql dump with LOCK statements

**URL:** <https://forums.percona.com/t/percona-xtradb-cluster-is-not-allowing-sql-dump-with-lock-statements/20510>\
**Category:** Percona XtraDB Cluster\
**Created:** [March 10, 2023, 6:23am UTC](https://forums.percona.com/t/percona-xtradb-cluster-is-not-allowing-sql-dump-with-lock-statements/20510 "2023-03-10T06:23:02Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sreehari](https://avatars.discourse-cdn.com/v4/letter/s/ed8c4c/32.png) [@Sreehari](https://forums.percona.com/u/Sreehari)\
**Post date:** [March 10, 2023, 6:23am UTC](https://forums.percona.com/t/percona-xtradb-cluster-is-not-allowing-sql-dump-with-lock-statements/20510/1 "2023-03-10T06:23:02Z")

</div>

environment: K8  
Percona-XtraDB-Cluster is not allowing sql dump with LOCK statements:  
mysql -h xxxxx -u root -pxxxxx oops\</data/oops.sql  
mysql: [Warning] Using a password on the command line interface can be insecure.  
ERROR 1105 (HY000) at line 41: Percona-XtraDB-Cluster prohibits use of LOCK TABLE/FLUSH TABLE

 WITH READ LOCK/FOR EXPORT with pxc\_strict\_mode = ENFORCING

we have exported the data with --skip-lock-tables option and then tried load the data into Percona-XtraDB-Cluster . Now we are getting dead lock issue . Please help us as how to avoid this issue.

mysql: [Warning] Using a password on the command line interface can be insecure.  
ERROR 1213 (40001) at line 1083: Deadlock found when trying to get lock; try restarting transaction

---

<div class="post-metadata">

**Author:** ![voarsh](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/voarsh/32/6577_2.png) [@voarsh](https://forums.percona.com/u/voarsh)\
**Post date:** [March 10, 2023, 6:49pm UTC](https://forums.percona.com/t/percona-xtradb-cluster-is-not-allowing-sql-dump-with-lock-statements/20510/2 "2023-03-10T18:49:40Z")

</div>

Set pxc\_strict\_mode = PERMISSIVE instead in your my.conf… although, as you know, it’s not recommended.  
Not sure if you’re installed via helm… if you are:  
pxc:

configuration: \>  
[mysqld]  
pxc\_strict\_mode=PERMISSIVE