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

innodb_disallow_writes does not work as expected

    XMLWordPrintable

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

            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.