[MDEV-10949] innodb_disallow_writes does not work as expected Created: 2016-10-03  Updated: 2018-04-06  Resolved: 2018-02-01

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB, wsrep
Affects Version/s: 10.2.2
Fix Version/s: 10.2.13

Type: Bug Priority: Major
Reporter: Nirbhay Choubey (Inactive) Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Duplicate
is duplicated by MDEV-11035 Restore removed disallow-writes for G... Closed
Relates
relates to MDEV-11035 Restore removed disallow-writes for G... Closed
relates to MDEV-15770 We have three node galera cluster wit... Open

 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



 Comments   
Comment by Nirbhay Choubey (Inactive) [ 2017-01-27 ]

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

Comment by Jan Lindström (Inactive) [ 2018-02-01 ]

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.

Comment by Marko Mäkelä [ 2018-04-06 ]

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.)

Generated at Thu Feb 08 07:46:09 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.