Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Incomplete
-
10.1.10, 10.0.23-galera
-
ubuntu 14.04.3 LTS "Trusty"
ubuntu 15.10 "Wiley"
installed/updated from apt-get
Description
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
create database
Create table
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)
Restart service
attempt to update/insert
crash
PRODUCTION OCCURENCE (original issue which lead to try reproducing):
Call procedure
UPDATE statement in procedure crashed server.
copy update statement, relaunch server, login run statement
crash