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

Memory management problem in statistics state for queries that have a large field IN (values) part

Details

    Description

      A query with a large IN () section will be stuck in statistics and use up all RAM. Multiple such queries will crash the server regardless of memory limitations specified in my.cnf

      I noticed this in 10.2.35. Downgrading to 10.2.34 fixes the problem

      An example is the WordPress "select post_id,meta_value from wp_postmeta where meta_id in (1,2,3 etc ...)" query.

      Attachments

        Issue Links

          Activity

            glucz Geza Lucz created issue -
            alice Alice Sherepa made changes -
            Field Original Value New Value
            xPaw Pavel made changes -
            Attachment mariadbbug.sql [ 54707 ]
            serg Sergei Golubchik made changes -
            Labels regression
            alice Alice Sherepa made changes -
            Affects Version/s 10.2 [ 14601 ]
            Affects Version/s 10.3 [ 22126 ]
            Affects Version/s 10.4 [ 22408 ]
            Affects Version/s 10.5 [ 23123 ]
            alice Alice Sherepa made changes -
            Fix Version/s 10.2 [ 14601 ]
            Fix Version/s 10.3 [ 22126 ]
            Fix Version/s 10.4 [ 22408 ]
            Fix Version/s 10.5 [ 23123 ]
            alice Alice Sherepa made changes -
            Assignee Sergei Petrunia [ psergey ]
            alice Alice Sherepa made changes -
            alice Alice Sherepa made changes -
            alice Alice Sherepa made changes -
            alice Alice Sherepa made changes -
            Status Open [ 1 ] Confirmed [ 10101 ]
            alice Alice Sherepa made changes -
            Attachment 1_my.test [ 54723 ]
            psergei Sergei Petrunia made changes -
            Status Confirmed [ 10101 ] In Progress [ 3 ]
            serg Sergei Golubchik made changes -
            Priority Major [ 3 ] Blocker [ 1 ]
            danblack Daniel Black made changes -
            psergei Sergei Petrunia made changes -
            Component/s Optimizer [ 10200 ]
            Component/s Server [ 13907 ]
            Fix Version/s 10.2.36 [ 25026 ]
            Fix Version/s 10.3.27 [ 25025 ]
            Fix Version/s 10.4.17 [ 25024 ]
            Fix Version/s 10.5.8 [ 25023 ]
            Fix Version/s 10.2 [ 14601 ]
            Fix Version/s 10.3 [ 22126 ]
            Fix Version/s 10.4 [ 22408 ]
            Fix Version/s 10.5 [ 23123 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            alice Alice Sherepa made changes -
            rob.schwyzer@mariadb.com Rob Schwyzer (Inactive) made changes -
            Labels regression ServiceNow regression
            rob.schwyzer@mariadb.com Rob Schwyzer (Inactive) made changes -
            Labels ServiceNow regression 76qDvLB8Gju6Hs7nk3VY3EX42G795W5z regression
            serg Sergei Golubchik made changes -
            Labels 76qDvLB8Gju6Hs7nk3VY3EX42G795W5z regression regression
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 115399 ] MariaDB v4 [ 158542 ]
            thilanka@orangehrm.us.com Thilanka made changes -
            mariadb-jira-automation Jira Automation (IT) made changes -
            Zendesk Related Tickets 201658
            Zendesk active tickets 201658

            People

              psergei Sergei Petrunia
              glucz Geza Lucz
              Votes:
              11 Vote for this issue
              Watchers:
              18 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.