Announcement

Announcement Module
Collapse
No announcement yet.

Constant cluster deadlock during table import

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Constant cluster deadlock during table import

    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,
Working...
X