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) created issue -
            nirbhay_c Nirbhay Choubey (Inactive) made changes -
            Field Original Value New Value
            Description {code}
            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)
            {code}             		{code}
            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)
            {code}

            Test case: galera.galera_var_innodb_disallow_writes
            nirbhay_c Nirbhay Choubey (Inactive) made changes -
            nirbhay_c Nirbhay Choubey (Inactive) made changes -
            Fix Version/s 10.2.3 [ 22115 ]
            Resolution Duplicate [ 3 ]
            Status Open [ 1 ] Closed [ 6 ]
            nirbhay_c Nirbhay Choubey (Inactive) made changes -
            Resolution Duplicate [ 3 ]
            Status Closed [ 6 ] Stalled [ 10000 ]
            nirbhay_c Nirbhay Choubey (Inactive) made changes -
            Fix Version/s 10.2 [ 14601 ]
            Fix Version/s 10.2.3 [ 22115 ]
            jplindst Jan Lindström (Inactive) made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            jplindst Jan Lindström (Inactive) made changes -
            issue.field.resolutiondate 2018-02-01 11:38:29.0 2018-02-01 11:38:29.279
            jplindst Jan Lindström (Inactive) made changes -
            Component/s wsrep [ 11500 ]
            Fix Version/s 10.2.13 [ 22910 ]
            Fix Version/s 10.2 [ 14601 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 77654 ] MariaDB v4 [ 151005 ]

            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.