Announcement

Announcement Module
Collapse
No announcement yet.

crash node

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

  • crash node

    Hi,
    I have installed percona xtradb cluster on CentOS 6.

    Percona-XtraDB-Cluster-server-5.5.28-23.7.369.rhel6.x86_64
    Percona-XtraDB-Cluster-galera-2.0-1.117.rhel6.x86_64

    There are still problems, whith which I need your help:

    During the restore DB with LOAD DATA INFILE

    nod options:
    wsrep_provider=/usr/lib64/libgalera_smm.so
    wsrep_sst_receive_address=172.31.6.x:3320
    wsrep_node_incoming_address=172.31.6.x
    wsrep_slave_threads=2
    wsrep_cluster_name=trimethylxanthine
    wsrep_provider_options = "gmcast.listen_addr=tcp://172.31.6.x:3330;"
    wsrep_sst_method=rsync
    wsrep_node_name=node3330
    wsrep_max_ws_size=4G

    if transaction is bigger than 4G, it will end and these two messages
    will be displayed and node always crashed:
    ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock;
    try restarting transaction
    ERROR 2013 (HY000) at line 1: Lost connection to MySQL server during query


    Sometimes it happens during the smaller transaction, too:
    ERROR 1047 (08S01) at line 1: Unknown command
    When I run the same command later again, it will be processed.

    Could you give me an advise, what can be wrong, please?

  • #2
    Can you provide your MySQL error log and/or innodb/global status prior to the crash if you can repeat this?
    Our documentation has a lot of answers about common questions on Percona software, have you checked there before posting that question here? http://www.percona.com/forums/core/i...lies/smile.png

    Join us at the annual Percona Live MySQL Users Conference - http://www.percona.com/live/mysql-conference-2014/

    Comment

    Working...
    X