mysql server crash after empty set sql query
Description
Environment
Smart Checklist
Activity
George Lorch January 20, 2020 at 6:47 PM
This seems fixed by upstream somewhere within 5.7.26-5.7.28:
Oleg Chizhov May 3, 2019 at 2:24 PM
kernel 3.10.0-693.21.1.el7.x86_64
CentOS Linux release 7.6.1810 (Core)
Percona-Server-server-57-5.7.25-28.1.el7.x86_64.rpm from Percona repoLD_PRELOAD=/usr/lib64/libjemalloc.so.1jemalloc-3.6.0-1.el7.x86_64
Lalit Choudhary May 3, 2019 at 8:49 AM
Could you please provide info about OS and MySQL build (the type of installation in your environment binary/package/complied from source )
Lalit Choudhary May 3, 2019 at 8:47 AM
Issue reproducible with upstream mysql 5.6 and 5.7 (tested with binary)
https://bugs.mysql.com/bug.php?id=95236
For percona server issue reproducible with PS docker image and debug-log-valgrind-asan build.
tested with Server version: 5.7.25-28-debug-log-valgrind-asan
In my test issue not reproducible Percona server binary setup and we get warning instead of the crash as follows,
Laurynas Biveinis May 3, 2019 at 6:31 AM
upstream?
Since it is a segfault, reproduction could be viable outside of docker under Valgrind or with ASan instrumentation
Details
Details
Assignee
Reporter
Oleg ChizhovUpstream Bug URL
Fix versions
Affects versions
Priority
MediumSmart Checklist
Open Smart Checklist
Smart Checklist
mysql percona server 5.7.20-5.7.27
mysql> create table test (`id` bigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY);
Query OK, 0 rows affected (0.00 sec)
mysql> select id from test where id = '46e80000000000000000000000000000';
ERROR 2006 (HY000): MySQL server has gone away
Segfault during query.