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

[ERROR] mysqld got signal 11 on SELECT

    XMLWordPrintable

    Details

      Description

      The server crashes both on query and (sometimes) when trying to execute «EXPLAIN».
      In 10.1.19-MariaDB is also reproduced.

      It is noteworthy that a pretty formatted query like
      "SELECT rbResult.`id`,
      CONCAT_WS(' | ', code, name,
      (SELECT rbEventTypePurpose.`name`
      FROM rbEventTypePurpose
      WHERE id=rbResult.`eventPurpose_id`) )
      FROM rbResult
      ORDER BY CONCAT_WS(' | ', code, name,
      (SELECT rbEventTypePurpose.`name`
      FROM rbEventTypePurpose
      WHERE id=rbResult.`eventPurpose_id`) );
      "
      is processed normally. But when query formatted in single line
      "SELECT rbResult.`id`, CONCAT_WS(' | ', code, name, (SELECT rbEventTypePurpose.`name` FROM rbEventTypePurpose WHERE id=rbResult.`eventPurpose_id`)) FROM rbResult ORDER BY CONCAT_WS(' | ', code, name, (SELECT rbEventTypePurpose.`name` FROM rbEventTypePurpose WHERE id=rbResult.`eventPurpose_id`));" server crashes.

      Attachments:
      serv.samson.err: log of 5.5.52-MariaDB,
      test-dump.sql: test database dump

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            VadimZelenin Vadim Zelenin
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration