Not the answer you need?
Register and ask your own question!

xtrabackup SST error

dseiradseira EntrantCurrent User Role Beginner
Hi,

I'm trying the Percona XtraDB Cluster for testing purpose. I've used the wsrep_sst_method with rsync and mysqldump options, and works correctly.

The problem comes when I want to try the xtrabackup method for avoid the blocking tables problem. I don't know why, but the node can't go up, it shows me a failed message. The mysql error log shows the next output:


130307 16:09:09 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 0)130307 16:09:09 [Note] WSREP: State transfer required: Group state: f3200c7c-8737-11e2-0800-b41de5c8e559:0 Local state: 514091b6-8722-11e2-0800-b5722dd612ea:0130307 16:09:09 [Note] WSREP: New cluster view: global state: f3200c7c-8737-11e2-0800-b41de5c8e559:0, view# 6: Primary, number of nodes: 2, my index: 1, protocol version 2130307 16:09:09 [Warning] WSREP: Gap in state sequence. Need state transfer.130307 16:09:11 [Note] WSREP: Running: 'wsrep_sst_xtrabackup --role 'joiner' --address '192.168.8.62' --auth 'root:XXXX' --datadir '/var/lib/mysql/' --defaults-file '/etc/mysql/my.cnf' --parent '2978''130307 16:09:11 [Note] WSREP: Prepared SST request: xtrabackup|192.168.8.62:4444/xtrabackup_sst130307 16:09:11 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.130307 16:09:11 [Note] WSREP: Assign initial position for certification: 0, protocol version: 2130307 16:09:11 [Warning] WSREP: Failed to prepare for incremental state transfer: Local state UUID (514091b6-8722-11e2-0800-b5722dd612ea) does not match group state UUID (f3200c7c-8737-11e2-0800-b41de5c8e559): 1 (Operation not permitted) at galera/src/replicator_str.cpp:prepare_for_IST():442. IST will be unavailable.130307 16:09:11 [Note] WSREP: Node 1 (ip-192-168-8-62) requested state transfer from '*any*'. Selected 0 (ip-192-168-8-38)(SYNCED) as donor.130307 16:09:11 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 0)130307 16:09:11 [Note] WSREP: Requesting state transfer: success, donor: 0tar: Saltando a la siguiente cabeceratar: Exiting with failure status due to previous errorsWSREP_SST: [ERROR] Error while getting st data from donor node: 0, 2 (20130307 16:09:20.072)130307 16:09:20 [ERROR] WSREP: Process completed with error: wsrep_sst_xtrabackup --role 'joiner' --address '192.168.8.62' --auth 'root:XXXX' --datadir '/var/lib/mysql/' --defaults-file '/etc/mysql/my.cnf' --parent '2978': 32 (Broken pipe)130307 16:09:20 [ERROR] WSREP: Failed to read uuid:seqno from joiner script.130307 16:09:20 [ERROR] WSREP: SST failed: 32 (Broken pipe)130307 16:09:20 [ERROR] Aborting130307 16:09:20 [Warning] WSREP: 0 (ip-192-168-8-38): State transfer to 1 (ip-192-168-8-62) failed: -1 (Operation not permitted)130307 16:09:20 [ERROR] WSREP: gcs/src/gcs_group.c:gcs_group_handle_join_msg():719: Will never receive state. Need to abort.</pre>


It shows a problem with tar program and SST failed. I've defined the wsrep_sst_method as xtrabackup and wsrep_sst_auth as root:XXXX.

I don't know which is the problem? Anyone can help me?

Regards.

Comments

  • matrix_uamatrix_ua Entrant Current User Role Beginner
    right to check my.cnf
  • dseiradseira Entrant Current User Role Beginner
    This is my my.cnf:


    [mysqld]server_id=1binlog_format=ROWlog_bin=mysql-binwsrep_cluster_address=gcomm://192.168.8.38,192.168.8.84,192.168.8.62wsrep_provider=/usr/lib/libgalera_smm.sowsrep_cluster_name=xtradbClusterTestwsrep_sst_method=xtrabackupwsrep_sst_auth=root:XXXXwsrep_node_name=ip-192-168-8-38</pre>


    I put the wsrep_sst_auth for authenticate the user correctly but it doesn't work.

    Any idea?
  • umarzukiumarzuki Contributor Current User Role Beginner
    In my case, I had to change sst method to rsync from xtradbackup-v2
  • wagnerbianchiwagnerbianchi Remote DBA Current User Role Patron
    Yes, try wsrep_sst_method=xtrabackup-v2
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.