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

Circular References Cause MariaDB 10.x to Lock Up

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.0.3
    • Fix Version/s: 10.0.4
    • Component/s: None
    • Labels:
    • Environment:
      Linux EL6

      Description

      If two tables exist with each referring to the other, executing an update on either of the tables causes MariaDB to get stuck indefinitely, using 100% of CPU.

      This seems to be affecting all 10.x releases so far, but this is the first time I have had a test case this small and compact to reproduce it. The same issue does not arise on MySQL 5.1, so this is a regression (and quite a nasty one).

      Attached is a data set with which the problem is reproducible, just two tables with three records between them.

      cat the attached file into an empty database, and execute the following query on it:

      update user set is_doctor=1 where qualifications != '' and qualifications != '.';

      The query will go away forever with the mysqld thread executing it consuming 100% CPU until killed (can only be killed with kill -9).

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              gordan Gordan Bobic
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: