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

open SYS_REFCURSOR crash, if too many cursors

    XMLWordPrintable

Details

    • Can result in hang or crash
    • Q3/2026 Server Maintenance

    Description

      delimiter $;
      BEGIN NOT ATOMIC
        DECLARE c0 SYS_REFCURSOR;
        DECLARE c1 SYS_REFCURSOR;
        DECLARE c2 SYS_REFCURSOR;
        DECLARE c3 SYS_REFCURSOR;
        DECLARE c4 SYS_REFCURSOR;
        DECLARE c5 SYS_REFCURSOR;
        DECLARE c6 SYS_REFCURSOR;
        DECLARE c7 SYS_REFCURSOR;
        DECLARE c8 SYS_REFCURSOR;
        DECLARE c9 SYS_REFCURSOR;
        DECLARE c10 SYS_REFCURSOR;
        DECLARE c11 SYS_REFCURSOR;
        DECLARE c12 SYS_REFCURSOR;
        DECLARE c13 SYS_REFCURSOR;
        DECLARE c14 SYS_REFCURSOR;
        DECLARE c15 SYS_REFCURSOR;
        DECLARE c16 SYS_REFCURSOR;
        DECLARE c17 SYS_REFCURSOR;
        DECLARE c18 SYS_REFCURSOR;
        DECLARE c19 SYS_REFCURSOR;
        DECLARE c20 SYS_REFCURSOR;
        DECLARE c21 SYS_REFCURSOR;
        DECLARE c22 SYS_REFCURSOR;
        DECLARE c23 SYS_REFCURSOR;
        DECLARE c24 SYS_REFCURSOR;
        DECLARE c25 SYS_REFCURSOR;
        DECLARE c26 SYS_REFCURSOR;
        DECLARE c27 SYS_REFCURSOR;
        DECLARE c28 SYS_REFCURSOR;
        DECLARE c29 SYS_REFCURSOR;
        DECLARE c30 SYS_REFCURSOR;
        DECLARE c31 SYS_REFCURSOR;
        DECLARE c32 SYS_REFCURSOR;
        DECLARE a INT;
        SET @@max_open_cursors = 200;
        OPEN c0 FOR SELECT 1;
        OPEN c1 FOR SELECT 1;
        OPEN c2 FOR SELECT 1;
        OPEN c3 FOR SELECT 1;
        OPEN c4 FOR SELECT 1;
        OPEN c5 FOR SELECT 1;
        OPEN c6 FOR SELECT 1;
        OPEN c7 FOR SELECT 1;
        OPEN c8 FOR SELECT 1;
        OPEN c9 FOR SELECT 1;
        OPEN c10 FOR SELECT 1;
        OPEN c11 FOR SELECT 1;
        OPEN c12 FOR SELECT 1;
        OPEN c13 FOR SELECT 1;
        OPEN c14 FOR SELECT 1;
        OPEN c15 FOR SELECT 1;
        OPEN c16 FOR SELECT 1;
        OPEN c17 FOR SELECT 1;
        OPEN c18 FOR SELECT 1;
        OPEN c19 FOR SELECT 1;
        OPEN c20 FOR SELECT 1;
        OPEN c21 FOR SELECT 1;
        OPEN c22 FOR SELECT 1;
        OPEN c23 FOR SELECT 1;
        OPEN c24 FOR SELECT 1;
        OPEN c25 FOR SELECT 1;
        OPEN c26 FOR SELECT 1;
        OPEN c27 FOR SELECT 1;
        OPEN c28 FOR SELECT 1;
        OPEN c29 FOR SELECT 1;
        OPEN c30 FOR SELECT 1;
        OPEN c31 FOR SELECT 1;
        OPEN c32 FOR SELECT 1;
        FETCH c16 INTO a;
      END$
      delimiter ;$
      

      Reported by Rick de Jager from v12 security

      Attachments

        Issue Links

          Activity

            People

              bar Alexander Barkov
              serg Sergei Golubchik
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 1.5h Original Estimate - 1.5h
                  1.5h
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 1d 0.5h
                  1d 0.5h

                  Git Integration

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