Re: [Maria-discuss] MariaDB 10.1.14 failure to initiate SST after RSU schema upgrade

2016-07-21 Thread Mark Wadham
On 21 Jul 2016, at 9:39, Mark Wadham wrote: Confirmed this Oh wait, it seems that if we do: SET wsrep_OSU_method='RSU'; (with GLOBAL omitted) then it sort of works. The node doesn't desync immediately but as soon as we execute some DDL it does desync, and then immediately re-syncs as soon

Re: [Maria-discuss] MariaDB 10.1.14 failure to initiate SST after RSU schema upgrade

2016-07-21 Thread Mark Wadham
On 21 Jul 2016, at 9:05, Mark Wadham wrote: I don't think this was the case during our testing, but I'll test it again anyway. If I understand RSU mode correctly all it does is ensure that DDL statements aren't replicated to the other nodes. AFAIK it won't stop the write events from the other

Re: [Maria-discuss] MariaDB 10.1.14 failure to initiate SST after RSU schema upgrade

2016-07-21 Thread Mark Wadham
Hi Nirbhay, As discussed on IRC #mariadb, you do not really need to take the node off cluster (3). Just set wsrep_osu_method's session value to RSU and perform the schema change. With RSU mode enabled, the node automatically desyncs itself from the cluster before executing any DDL,and thus ot

Re: [Maria-discuss] MariaDB 10.1.14 failure to initiate SST after RSU schema upgrade

2016-07-20 Thread Nirbhay Choubey
Hi Mark, On Wed, Jul 20, 2016 at 10:38 AM, Mark Wadham wrote: > Hi, > > We have a repeatable failure to initiate IST with MariaDB 10.1.14 after > performing a schema upgrade on a single node in RSU mode. The error > condition is when there is a delete query in the format: > > delete from where

Re: [Maria-discuss] MariaDB 10.1.14 failure to initiate SST after RSU schema upgrade

2016-07-20 Thread Mark Wadham
On 20 Jul 2016, at 16:34, Mark Wadham wrote: 3. Testing whether regular IST is affected, ie IST that should occur normally without switching to RSU mode or dropping a node out of the cluster. Will reply again when we've tested this. Haven't tested this yet, but we just tested the process wit

Re: [Maria-discuss] MariaDB 10.1.14 failure to initiate SST after RSU schema upgrade

2016-07-20 Thread Mark Wadham
1. Switching node 0 back to TOI mode before rejoining the cluster, although I can't really see how this would make a difference. Made no difference. 2. Upgrading to MariaDB 10.1.16 which was released a couple of days ago. Also made no difference, the issue is still reproducable. 3. Testing

[Maria-discuss] MariaDB 10.1.14 failure to initiate SST after RSU schema upgrade

2016-07-20 Thread Mark Wadham
Hi, We have a repeatable failure to initiate IST with MariaDB 10.1.14 after performing a schema upgrade on a single node in RSU mode. The error condition is when there is a delete query in the format: delete from where id >= on the non-RSU cluster nodes while the node is disconnected from