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:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 5h
                  5h

                  Git Integration

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