[MDEV-12405] [ERROR] mysqld got signal 11 on SELECT Created: 2017-03-30  Updated: 2017-04-04  Resolved: 2017-04-04

Status: Closed
Project: MariaDB Server
Component/s: Data Manipulation - Subquery, Optimizer
Affects Version/s: 5.5.52
Fix Version/s: 5.5.54

Type: Bug Priority: Major
Reporter: Vadim Zelenin Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: None
Environment:

CentOS Linux release 7.3.1611


Attachments: File serv.samson.err     File test-dump.sql    

 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



 Comments   
Comment by Elena Stepanova [ 2017-04-04 ]

Thanks for the bug report.
This bug was fixed in 5.5.54 in the scope of MDEV-10776. Please try to upgrade. If the problem persists, please comment and the report will be re-opened.

Generated at Thu Feb 08 07:57:27 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.