Constant cluster deadlock during table import

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

Hi,

I have 1 single table that make trouble for me when exported from node1 on one XtraDB cluster to another node1 on another XtraDB cluster:

  1. mysqldump -uusr -ppwd sessions > sessions.sql,
  2. scp to new node1 on completely new cluste
  3. mysql sessions < sessions.sql
    result: ERROR 1213 (40001) at line 40: Deadlock found when trying to get lock; try restarting transaction

I can see that inside sessions.sql file, there is a “,lock table sessions write” - which should be UNsupported on Galera generaly… not sure if that is the problem ?

Table definition is folowing:

CREATE TABLE sessions (
id varchar(255) COLLATE utf8_bin NOT NULL,
data text COLLATE utf8_bin,
last_action_time timestamp NULL DEFAULT NULL,
expire timestamp NULL DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Any help would be very appriciated…

Regards,