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
        2. enum_data_trg.sql
          5 kB
        3. enum_trg.sql
          5 kB
        4. insert_script.sql
          1 kB

          Issue Links

            Activity

              People

              • Assignee:
                alice Alice Sherepa
                Reporter:
                balta Tadas Balaišis
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: