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

Instance crash on second insert with trigger

    XMLWordPrintable

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

          Activity

            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.