When a table has the following, the galera cluster crashes.
BEFORE INSERT trigger
BEFORE UPDATE trigger
An Update statement within an event can cause the fail condition.
An event which calls a procedure can cause the fail condition.
Our reproduction steps were:
apt-get upgrade from mariadb-server-10.1.9 to mariadb-server-10.1.10
add SMALLINT flag field
create BEFORE INSERT trigger set flag=1;
create BEFORE UPDATE trigger set flag=1;
insert row (completed)
insert row (fail, primary server crashes)
attempt to update/insert
PRODUCTION OCCURENCE (original issue which lead to try reproducing):
UPDATE statement in procedure crashed server.
copy update statement, relaunch server, login run statement
ubuntu 14.04.3 LTS "Trusty"
ubuntu 15.10 "Wiley"
installed/updated from apt-get