GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

SST xtrabackup-v2 with custom directories

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

  • SST xtrabackup-v2 with custom directories

    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

  • #2
    could it be directory ownership issue? I usually create custom directories with no problem.

    Comment


    • #3
      Originally posted by jomar View Post
      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

      Comment

      Working...
      X