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

mysqld got exception 0xc0000005 in mark_select_range_as_dependent()

    XMLWordPrintable

Details

    • Can result in hang or crash

    Description

      11.4.10-MariaDB installed over 11.4.2-MariaDB home and service is crashing since right after startup. Installation went smoothly without any error.
      I started to investigate. ERR log was non-informative. I commented several my.ini lines, so finally I got service started. Then I found that it deals with events, because with

      event_scheduler=1

      commented it starts the service OK.
      I have a number of events from previous (11.4.2) development.
      So I altered all events to disable and uncommented event_scheduler switch. And then the service started OK. If I reenable events, it falls again. Then I started to enable events one by one. Then I found the one that crashes the service. It calls my procedure. I executed the procedure call manually and the service crashed. The procedure and event were working fine in 11.4.2. Then with events disabled I recreated the procedure using Heidisql. It was recreated fine without any error. Then I called the procedure again and the service crashed again immediate.
      I'll attach dumps, err log quotes and procedure source.

      Attachments

        1. mysqld.dmp3.zip
          15 kB
        2. mysqld.dmp2.zip
          15 kB
        3. mysqld.dmp.zip
          16 kB
        4. my.ini
          0.6 kB
        5. err_quote3.log
          7 kB
        6. err_quote2.log
          7 kB
        7. err_quote.log
          25 kB
        8. eksp bga tables.sql
          7 kB
        9. backup bga_execute_.sql
          62 kB

        Issue Links

          Activity

            People

              alice Alice Sherepa
              balta Tadas Balaišis
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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