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

MariaDB hangs on query with many logical condition

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 5.3.12, 10.0.21, 5.5(EOL), 10.0(EOL), 10.1(EOL)
    • 5.5.46, 10.0.22, 10.1.8
    • Optimizer
    • None
    • 10.0.21-MariaDB, Centos6
    • 10.1.8-3

    Description

      MariaDB process hangs with 100% CPU usage, while executing simple query with many logical conditions. Same query on MySQL 5.6.23 tooks only fraction of second to complete.

      To reproduce problem restore table from "testtable.sql" file and execute test.sql query.

      Attachments

        1. test.sql
          9 kB
          Vytautas Bertašius
        2. testtable.sql
          6 kB
          Vytautas Bertašius

        Activity

          People

            sanja Oleksandr Byelkin
            adminiv Vytautas Bertašius
            Votes:
            0 Vote for this issue
            Watchers:
            5 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.