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

        1. serv.samson.err
          6 kB
          Vadim Zelenin
        2. test-dump.sql
          18 kB
          Vadim Zelenin

        Activity

          People

            Unassigned Unassigned
            VadimZelenin Vadim Zelenin
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.