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

MariaDB hangs on query with many logical condition

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 5.3.12, 10.0.21, 5.5, 10.0, 10.1
    • Fix Version/s: 5.5.46, 10.0.22, 10.1.8
    • Component/s: Optimizer
    • Labels:
      None
    • Environment:
      10.0.21-MariaDB, Centos6
    • Sprint:
      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

            People

            Assignee:
            sanja Oleksandr Byelkin
            Reporter:
            adminiv Vytautas Bertašius
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: