Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-9323

Triggers cause server crash

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Incomplete
    • 10.1.10, 10.0.23-galera
    • N/A
    • OTHER
    • 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

      Attachments

        Activity

          People

            Unassigned Unassigned
            colebusby Cole Busby
            Votes:
            1 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.