[MDEV-7995] DMLs not getting replicated with log-bin=OFF & binlog-format != ROW Created: 2015-04-15  Updated: 2015-04-23  Resolved: 2015-04-23

Status: Closed
Project: MariaDB Server
Component/s: wsrep
Affects Version/s: 5.5.42-galera, 10.0.17-galera
Fix Version/s: 5.5.43-galera, 10.0.19-galera

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


 Description   

DML statements are not getting replicated to other nodes when binlog-format is set to formats other than ROW and binary logging is off.

Node 1:

MariaDB [test]> create table t1(i int) engine=innodb;
Query OK, 0 rows affected (0.39 sec)
 
MariaDB [test]> set @@session.binlog_format=statement;
Query OK, 0 rows affected, 1 warning (0.04 sec)
 
MariaDB [test]> insert into t1 values(1);
Query OK, 1 row affected (0.11 sec)
 
MariaDB [test]> create table t2(i int) engine=innodb;
Query OK, 0 rows affected (0.10 sec)

Node 2:

MariaDB [test]> show tables;
+----------------+
| Tables_in_test |
+----------------+
| t1             |
| t2             |
+----------------+
2 rows in set (0.00 sec)
 
MariaDB [test]> select * from t1;
Empty set (0.00 sec)



 Comments   
Comment by Nirbhay Choubey (Inactive) [ 2015-04-23 ]

http://lists.askmonty.org/pipermail/commits/2015-April/007779.html

Comment by Jan Lindström (Inactive) [ 2015-04-23 ]

Ok to push.

Comment by Nirbhay Choubey (Inactive) [ 2015-04-23 ]

https://github.com/MariaDB/server/commit/581b49dd3d3e2e253812bb24fa881148675320b4

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