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

Instance crash on second insert with trigger

Details

    Description

      I got service unloaded after trying to execute insert script. Err file attached. Version: 10.2.14 on winx64.
      The insert script attached. It breaks on second statement. I assume it caused by insert trigger action, trigger code attached.
      The error is reproducible after service startup.
      I noticed that I get no error if I go step-by-step, executing every statement manualy (F10 on HeidiSQL). And then I can get error on third statement. This makes my think that there is some pause duration (several seconds) required for service to recover and accept subsequent statement. And it crashes, if this pause is too short.

      Attachments

        1. 2-14.err
          30 kB
          Tadas Balaišis
        2. enum_data_trg.sql
          5 kB
          Tadas Balaišis
        3. enum_trg.sql
          5 kB
          Tadas Balaišis
        4. insert_script.sql
          1 kB
          Tadas Balaišis

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MDEV-13170 Database service (MySQL) stops after update with trigger

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            balta Tadas Balaišis added a comment -

            Maybe I was wrong about specific duration. Maybe committing after each statement helps.

            balta Tadas Balaišis added a comment - Maybe I was wrong about specific duration. Maybe committing after each statement helps.
            balta Tadas Balaišis added a comment -

            No, commit is not a good workaround. I got crash after commit either. I didn't get the rule. Yes, it is possible to insert in several attempts, but nevertheless I would like this bug fixed.

            balta Tadas Balaišis added a comment - No, commit is not a good workaround. I got crash after commit either. I didn't get the rule. Yes, it is possible to insert in several attempts, but nevertheless I would like this bug fixed.
            balta Tadas Balaišis added a comment -

            Affected Version 10.3.4 10.3.6

            balta Tadas Balaišis added a comment - Affected Version 10.3.4 10.3.6
            alice Alice Sherepa added a comment -

            It looks like it is the same problem as MDEV-13170. If the crash will still appear after fix of MDEV-13170, feel free to comment here and the case will be reopen

            alice Alice Sherepa added a comment - It looks like it is the same problem as MDEV-13170 . If the crash will still appear after fix of MDEV-13170 , feel free to comment here and the case will be reopen

            People

              alice Alice Sherepa
              balta Tadas Balaišis
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.