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. backup bga_execute_.sql
          62 kB
          Tadas Balaišis
        2. err_quote.log
          25 kB
          Tadas Balaišis
        3. err_quote2.log
          7 kB
          Tadas Balaišis
        4. err_quote3.log
          7 kB
          Tadas Balaišis
        5. my.ini
          0.6 kB
          Tadas Balaišis
        6. eksp bga tables.sql
          7 kB
          Tadas Balaišis

        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.