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

innodb_disallow_writes does not work as expected

Details

    Description

      MariaDB [test]> select @@version;
      		 
      +--------------------------+
      		 
      | @@version                |
      		 
      +--------------------------+
      		 
      | 10.2.3-MariaDB-debug-log |
      		 
      +--------------------------+
      		 
      1 row in set (0.00 sec)
      		 
       
      		 
      MariaDB [test]> create table t1(i int)engine=innodb;
      		 
      Query OK, 0 rows affected (0.05 sec)
      		 
       
      		 
      MariaDB [test]> SET GLOBAL innodb_disallow_writes=ON;
      		 
      Query OK, 0 rows affected (0.00 sec)
      		 
       
      		 
      MariaDB [test]> insert into t1 values(1);
      		 
      Query OK, 1 row affected (0.01 sec)
      		 
       
      		 
      MariaDB [test]> select * from t1;
      		 
      +------+
      		 
      | i    |
      		 
      +------+
      		 
      |    1 |
      		 
      +------+
      		 
      1 row in set (0.00 sec)

      Test case: galera.galera_var_innodb_disallow_writes

      Attachments

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11035 Restore removed disallow-writes for Galera

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11035 Restore removed disallow-writes for Galera

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-15770 We have three node galera cluster with mariadb, bootstrap primary node is running but other two nodes not able to recover the data from first node and crash after some data recover like after recovery 15GB data

          • Major - Major loss of function.
          • Open

          Activity

            Ascending order - Click to sort in descending order
            nirbhay_c Nirbhay Choubey (Inactive) added a comment -

            jplindst Reopening as this issue has re-surfaced. I noticed that 10.2-HEAD is still affected.

            nirbhay_c Nirbhay Choubey (Inactive) added a comment - jplindst Reopening as this issue has re-surfaced. I noticed that 10.2-HEAD is still affected.
            jplindst Jan Lindström (Inactive) added a comment -

            commit 5a9c63ab5535778839de74dfd16837de8b1f7f5e
            Author: Jan Lindström <jan.lindstrom@mariadb.com>
            Date: Thu Feb 1 13:35:03 2018 +0200

            MDEV-10949: innodb_disallow_writes does not work as expected

            Test seems to pass fine.

            jplindst Jan Lindström (Inactive) added a comment - commit 5a9c63ab5535778839de74dfd16837de8b1f7f5e Author: Jan Lindström <jan.lindstrom@mariadb.com> Date: Thu Feb 1 13:35:03 2018 +0200 MDEV-10949 : innodb_disallow_writes does not work as expected Test seems to pass fine.
            marko Marko Mäkelä added a comment -

            As noted in MDEV-11035 and MDEV-15770, something in the Galera rsync snapshot transfer is not working correctly. (The reason why the parameter innodb_disallow_writes exists is the rsync snapshot transfer.)

            marko Marko Mäkelä added a comment - As noted in MDEV-11035 and MDEV-15770 , something in the Galera rsync snapshot transfer is not working correctly. (The reason why the parameter innodb_disallow_writes exists is the rsync snapshot transfer.)

            People

              jplindst Jan Lindström (Inactive)
              nirbhay_c Nirbhay Choubey (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.