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

MariaDB hangs on query with many logical condition

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

        Activity

          Transition Time In Source Status Execution Times
          Elena Stepanova made transition -
          Open Confirmed
          		3d 8h 57m 1
          Oleksandr Byelkin made transition -
          Confirmed In Progress
          		37d 12h 30m 1
          Oleksandr Byelkin made transition -
          In Progress In Review
          		5h 55m 1
          Sergei Petrunia made transition -
          In Review Stalled
          		3d 16h 27m 1
          Oleksandr Byelkin made transition -
          Stalled Closed
          		30m 24s 1

          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.