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

Query that should result in only four rows never completes.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: In Progress (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.0.25, 5.5, 10.0, 10.1, 10.2
    • Fix Version/s: 10.2
    • Component/s: Optimizer
    • Labels:
      None
    • Environment:
      GNU/Linux Lubuntu 16.10, x86_64.

      Description

      Upon executing a series of SQL statements (see attached file) via JDBC, the server stops responding. The final statement should return just four rows, but does not terminate for at least 20 hours. After the last query all other operations on the server become impossible, and the server consumes 100% of CPU time on one logical processor, even after the query connection is terminated. The only remedy is to kill the server process query.

      Executing the same statements directly in the CLI yields the same result.

      The exact same sequence of SQL statements complete in a matter of seconds on a stock standard 5.7.16-0ubuntu0.16.10.1 MySQL server running on the same computer. Similar queries also complete in seconds on PostgreSQL, SQLite, HSQLDB, MonetDB, H2, Derby, and Firebird database engines running on the same computer.

      The installed version is 10.0.25-MariaDB-1 Ubuntu 16.10, installed via the OS package manager and not configured further except to create a 'test' schema.

        Attachments

        1. in_sql.sql
          52 kB
        2. queries.txt
          64 kB

          Issue Links

            Activity

              People

              Assignee:
              psergei Sergei Petrunia
              Reporter:
              erikjber Erik Berglund
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:

                  Git Integration