Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-6492

MariaDB Galera Cluster cant use rsync sst

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.0.12-galera
    • 10.0.13-galera
    • None
    • ubuntu 14.04
      lxc

    Description

      wsrep_sst_rsync can't be used.

      Jul 27 01:38:25 mgc_1 mysqld: 140727  1:38:25 [Note] WSREP: Tables flushed.
      		 
      Jul 27 01:38:25 mgc_1 mysqld: 140727  1:38:25 [Warning] WSREP: error executing 'SET GLOBAL innodb_disallow_writes=1': 1193 (Unknown system variable 'innodb_disallow_writes'). Was mysqld built wi
      		 
      th --with-innodb-disallow-writes ?
      		 
      Jul 27 01:38:25 mgc_1 mysqld: 140727  1:38:25 [ERROR] WSREP: Failed to disallow InnoDB writes
      		 
      Jul 27 01:39:08 mgc_1 mysqld: tail: »mysqld-bin.index“ kann nicht zum Lesen geöffnet werden: Datei oder Verzeichnis nicht gefunden
      		 
      Jul 27 01:39:08 mgc_1 mysqld: 140727  1:39:08 [ERROR] WSREP: Failed to read from: wsrep_sst_rsync --role 'donor' --address '10.0.3.110:4444/rsync_sst' --auth '(null)' --socket '/var/run/mysqld/m
      		 
      ysqld.sock' --datadir '/var/lib/mysql/' --defaults-file '/etc/mysql/my.cnf'  --binlog 'mysqld-bin' --gtid '061d9f9a-145a-11e4-b219-2b644d4c7e86:0'
      		 
      Jul 27 01:39:08 mgc_1 mysqld: 140727  1:39:08 [ERROR] WSREP: Process completed with error: wsrep_sst_rsync --role 'donor' --address '10.0.3.110:4444/rsync_sst' --auth '(null)' --socket '/var/run
      		 
      /mysqld/mysqld.sock' --datadir '/var/lib/mysql/' --defaults-file '/etc/mysql/my.cnf'  --binlog 'mysqld-bin' --gtid '061d9f9a-145a-11e4-b219-2b644d4c7e86:0': 1 (Operation not permitted)
      		 
      Jul 27 01:39:08 mgc_1 mysqld: 140727  1:39:08 [Warning] WSREP: error executing 'SET GLOBAL innodb_disallow_writes=0': 1193 (Unknown system variable 'innodb_disallow_writes'). Was mysqld built wi
      		 
      th --with-innodb-disallow-writes ?
      		 
      Jul 27 01:39:08 mgc_1 mysqld: 140727  1:39:08 [ERROR] WSREP: Failed to disallow InnoDB writes
      		 
      Jul 27 01:39:08 mgc_1 mysqld: 140727  1:39:08 [Note] WSREP: resuming provider at 25

      And yes there is no support for innodb_disallow_writes

      ariaDB [(none)]> SET GLOBAL innodb_disallow_writes=1;
      		 
      ERROR 1193 (HY000): Unknown system variable 'innodb_disallow_writes'

      So every sst using "flush tables" is going to fail

      Attachments

        Activity

          Transition Time In Source Status Execution Times
          Nirbhay Choubey (Inactive) made transition -
          Open In Progress
          		1d 17h 21m 1
          Nirbhay Choubey (Inactive) made transition -
          In Progress In Review
          		3d 2h 55m 1
          Jan Lindström (Inactive) made transition -
          In Review Stalled
          		14h 52m 1
          Nirbhay Choubey (Inactive) made transition -
          Stalled Closed
          		12h 49m 1

          People

            nirbhay_c Nirbhay Choubey (Inactive)
            erkules erkan yanar
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.