[#MDEV-4953] Galera: DELETE from a partitioned table is not replicated

I run a 2-node cluster with the following server command lines:

maria-5.5-galera//sql/mysqld --no-defaults --basedir=maria-5.5-galera/ --datadir=node0/data --lc-messages-dir=maria-5.5-galera//sql/share --character-sets-dir=maria-5.5-galera//sql/share/charsets --tmpdir=node0/tmp --core-file --max-allowed-packet=128Mb --port=19300 --socket=node0/mysql.sock --pid-file=node0/mysql.pid --general-log --general-log-file=node0/mysql.log --wsrep_sst_method=rsync --innodb_autoinc_lock_mode=2 --default-storage-engine=InnoDB --innodb_locks_unsafe_for_binlog=1 --binlog-format=row --wsrep_cluster_address=gcomm://?gmcast.listen_addr=tcp://127.0.0.1:4800 --wsrep-provider=/home/elenst/galera/libgalera_smm.so --log-bin --log-slave-updates

maria-5.5-galera//sql/mysqld --no-defaults --basedir=maria-5.5-galera/ --datadir=node1/data --lc-messages-dir=maria-5.5-galera//sql/share --character-sets-dir=maria-5.5-galera//sql/share/charsets --tmpdir=node1/tmp --core-file --max-allowed-packet=128Mb --port=19301 --socket=node1/mysql.sock --pid-file=node1/mysql.pid --general-log --general-log-file=node1/mysql.log --wsrep_sst_method=rsync --innodb_autoinc_lock_mode=2 --default-storage-engine=InnoDB --innodb_locks_unsafe_for_binlog=1 --binlog-format=row --wsrep_cluster_address=gcomm://127.0.0.1:4800?gmcast.listen_addr=tcp://127.0.0.1:4801 --wsrep-provider=/home/elenst/galera/libgalera_smm.so --log-bin --log-slave-updates

The status shows that the cluster is up and running:

| wsrep_local_state          | 4                                     |

| wsrep_local_state_comment  | Synced                                |

| wsrep_cert_index_size      | 11                                    |

| wsrep_causal_reads         | 0                                     |

| wsrep_incoming_addresses   | 192.168.1.20:19300,192.168.1.20:19301 |

| wsrep_cluster_conf_id      | 2                                     |

| wsrep_cluster_size         | 2                                     |

Then I execute the following on the first node:

MariaDB [test]> create table t4 (pk int primary key, i int) engine=InnoDB partition by hash(pk) partitions 2;

Query OK, 0 rows affected (0.41 sec)

MariaDB [test]> insert into t4 values (1,100), (2,200);

Query OK, 2 rows affected (0.11 sec)

Records: 2  Duplicates: 0  Warnings: 0

MariaDB [test]> delete from t4;

Query OK, 2 rows affected (0.04 sec)

MariaDB [test]> select * from t4;

Empty set (0.00 sec)

But on the 2nd node DELETE did not work:

MariaDB [test]> select * from t4;

+----+------+

| pk | i    |

+----+------+

|  2 |  200 |

|  1 |  100 |

+----+------+

2 rows in set (0.01 sec)

The status still shows that replication is up:

| wsrep_local_state          | 4                                     |

| wsrep_local_state_comment  | Synced                                |

| wsrep_cert_index_size      | 14                                    |

| wsrep_causal_reads         | 0                                     |

| wsrep_incoming_addresses   | 192.168.1.20:19300,192.168.1.20:19301 |

| wsrep_cluster_conf_id      | 2                                     |

| wsrep_cluster_size         | 2                                     |

But further INSERTs don't work either.

revision-id: seppo.jaakola@codership.com-20130823092100-tumt1qvo3hbybhg3

revno: 3415

branch-nick: maria-5.5-galera

Server version: 5.5.32-MariaDB-debug-log Source distribution, wsrep_23.7.5.r3415

Galera library 23.2.6

[MDEV-4953] Galera: DELETE from a partitioned table is not replicated Created: 2013-08-27 Updated: 2013-08-28 Resolved: 2013-08-28
Status:	Closed
Project:	MariaDB Server
Component/s:	None
Affects Version/s:	None
Fix Version/s:	5.5.32-galera

[MDEV-4953] Galera: DELETE from a partitioned table is not replicated Created: 2013-08-27 Updated: 2013-08-28 Resolved: 2013-08-28