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

SST xtrabackup-v2 with custom directories

HTF1HTF1 ContributorInactive User Role Beginner
I've created a separate directory for bin&relay logs however xtrabackup-v2 is not able to sync/create them on joiner.
When I disable these options below it works fine, is there a way to exclude this directory (log)?
log-bin = /var/lib/mysql/log/mysql-bin
relay-log = /var/lib/mysql/log/mysql-relay
relay_log_info_file = /var/lib/mysql/log/relay-log.info
slave_load_tmpdir = /var/lib/mysql/log/tmp
WSREP_SST: [INFO] Cleaning the binlog directory /var/lib/mysql/log as well (20140618 20:18:48.611)
find: `/var/lib/mysql/log': No such file or directory
WSREP_SST: [ERROR] Cleanup after exit with status:1 (20140618 20:18:48.618)
WSREP_SST: [INFO] Removing the sst_in_progress file (20140618 20:18:48.622)
2014-06-18 20:18:48 29379 [ERROR] WSREP: Process completed with error: wsrep_sst_xtrabackup-v2 --role 'joiner' --address '$IP' --auth '$USER:$PASSWORD' --datadir '/var/lib/mysql/' --defaults-file '/etc/my.cnf' --parent '29379' '' : 1 (Operation not permitted)
2014-06-18 20:18:48 29379 [ERROR] WSREP: Failed to read uuid:seqno from joiner script.
2014-06-18 20:18:48 29379 [ERROR] WSREP: SST failed: 1 (Operation not permitted)
2014-06-18 20:18:48 29379 [ERROR] Aborting

Comments

  • jomarjomar Entrant Inactive User Role Beginner
    could it be directory ownership issue? I usually create custom directories with no problem.
  • HTF1HTF1 Contributor Inactive User Role Beginner
    jomar wrote: »
    could it be directory ownership issue? I usually create custom directories with no problem.

    I don't think this is a ownership issue:
    # ll -d /var/lib/mysql/log/
    drwxr-xr-x 4 mysql mysql 28 Jun 18 22:01 /var/lib/mysql/log/

    It looks like this directory is removed and then SST process is not able to re-create it?!
    WSREP_SST: [INFO] Proceeding with SST (20140618 21:59:12.713)
    WSREP_SST: [INFO] Cleaning the existing datadir and innodb-data/log directories (20140618 21:59:12.717)
    removed `/var/lib/mysql/log/mysql-bin.000001'
    removed `/var/lib/mysql/log/mysql-bin.index'
    removed directory: `/var/lib/mysql/log'
    removed `/var/lib/mysql/ibdata1'
    removed `/var/lib/mysql/ib_logfile1'
    removed `/var/lib/mysql/ib_logfile0'
    removed `/var/lib/mysql/auto.cnf'
    removed `/var/lib/mysql/mysql.sock'
    WSREP_SST: [INFO] Cleaning the binlog directory /var/lib/mysql/log as well (20140618 21:59:13.127)
    find: `/var/lib/mysql/log': No such file or directory
    WSREP_SST: [ERROR] Cleanup after exit with status:1 (20140618 21:59:13.133)
    WSREP_SST: [INFO] Removing the sst_in_progress file (20140618 21:59:13.137)
    2014-06-18 21:59:13 32344 [ERROR] WSREP: Process completed with error: wsrep_sst_xtrabackup-v2 --role 'joiner' --address '$IP' --auth '$USER:$PASSWORD' --datadir '/var/lib/mysql/' --defaults-file '/etc/my.cnf' --parent '32344' '' : 1 (Operation not permitted)
    2014-06-18 21:59:13 32344 [ERROR] WSREP: Failed to read uuid:seqno from joiner script.
    2014-06-18 21:59:13 32344 [ERROR] WSREP: SST failed: 1 (Operation not permitted)
    2014-06-18 21:59:13 32344 [ERROR] Aborting
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.