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

MySQL & MariaDB Percona XtraDB Cluster 8.x
1

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

2

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

1 Like