Server crashes in mysql_admin_table upon killing ANALYZE

--source include/have_innodb.inc

SET GLOBAL innodb_stats_persistent= ON; 

SET GLOBAL use_stat_tables= PREFERABLY;

--connect (con1,localhost,root,,)

SET NAMES utf8;

CREATE TABLE t1 (

`id` int(10) unsigned NOT NULL auto_increment,

`k` int(10) unsigned NOT NULL default '0',

`c` char(120) NOT NULL default '',

`pad` char(60) NOT NULL default '',

KEY `k` (`k`),

PRIMARY KEY (`id`)) ENGINE=InnoDB;

BEGIN;

INSERT INTO t1 VALUES (NULL,1,'foo','foo'),(NULL,2,'bar','bar');

INSERT INTO t1 SELECT NULL, k, c, pad FROM t1;

INSERT INTO t1 SELECT NULL, k, c, pad FROM t1;

INSERT INTO t1 SELECT NULL, k, c, pad FROM t1;

INSERT INTO t1 SELECT NULL, k, c, pad FROM t1;

INSERT INTO t1 SELECT NULL, k, c, pad FROM t1;

INSERT INTO t1 SELECT NULL, k, c, pad FROM t1;

INSERT INTO t1 SELECT NULL, k, c, pad FROM t1;

INSERT INTO t1 SELECT NULL, k, c, pad FROM t1;

INSERT INTO t1 SELECT NULL, k, c, pad FROM t1;

COMMIT;

CREATE TABLE t2 LIKE t1;

INSERT INTO t2 SELECT * FROM t1;

CREATE TABLE t3 LIKE t1;

INSERT INTO t3 SELECT * FROM t1;

CREATE TABLE t4 LIKE t1;

INSERT INTO t4 SELECT * FROM t1;

CREATE TABLE t5 LIKE t1;

INSERT INTO t5 SELECT * FROM t1;

CREATE TABLE t6 LIKE t1;

INSERT INTO t6 SELECT * FROM t1;

CREATE TABLE t7 LIKE t1;

INSERT INTO t7 SELECT * FROM t1;

CREATE TABLE t8 LIKE t1;

INSERT INTO t8 SELECT * FROM t1;

CREATE TABLE t9 LIKE t1;

INSERT INTO t9 SELECT * FROM t1;

CREATE TABLE t10 LIKE t1;

INSERT INTO t10 SELECT * FROM t1;

CREATE TABLE t11 LIKE t1;

INSERT INTO t11 SELECT * FROM t1;

CREATE TABLE t12 LIKE t1;

INSERT INTO t12 SELECT * FROM t1;

CREATE TABLE t13 LIKE t1;

INSERT INTO t13 SELECT * FROM t1;

CREATE TABLE t14 LIKE t1;

INSERT INTO t14 SELECT * FROM t1;

CREATE TABLE t15 LIKE t1;

INSERT INTO t15 SELECT * FROM t1;

CREATE TABLE t16 LIKE t1;

INSERT INTO t16 SELECT * FROM t1;

CREATE TABLE t17 LIKE t1;

INSERT INTO t17 SELECT * FROM t1;

CREATE TABLE t18 LIKE t1;

INSERT INTO t18 SELECT * FROM t1;

CREATE TABLE t19 LIKE t1;

INSERT INTO t19 SELECT * FROM t1;

CREATE TABLE t20 LIKE t1;

INSERT INTO t20 SELECT * FROM t1;

--disconnect con1

--connect (con1,localhost,root,,)

#SET max_statement_time= 1;

--let $con_id= `SELECT CONNECTION_ID()`

send ANALYZE TABLE t1, t2, t3, t4, t5, t6, t7, t8, t9, t10, t11, t12, t13, t14, t15, t16, t17, t18, t19, t20;

--connection default

sleep 0.5;

eval KILL QUERY $con_id;

--connection con1

--reap

#3  <signal handler called>

#4  0x00007fb00c0b984a in mysql_admin_table(THD *, TABLE_LIST *, HA_CHECK_OPT *, const char *, thr_lock_type, bool, bool, uint, int (*)(THD *, TABLE_LIST *, HA_CHECK_OPT *), struct {...}, int (*)(THD *, TABLE_LIST *, HA_CHECK_OPT *)) (thd=0x7fafe3816070, tables=0x7fafe3864200, check_opt=0x7fafe381aa08, operator_name=0x7fb00ca1ab57 "analyze", lock_type=TL_READ_NO_INSERT, open_for_modify=true, repair_table_use_frm=false, extra_open_options=0, prepare_func=0x0, operator_func=(int (handler::*)(handler * const, THD *, HA_CHECK_OPT *)) 0x7fb00c1d68b8 <handler::ha_analyze(THD*, st_ha_check_opt*)>, view_operator_func=0x0) at /data/src/10.2/sql/sql_admin.cc:811

#5  0x00007fb00c0bb611 in Sql_cmd_analyze_table::execute (this=0x7fafe397ff80, thd=0x7fafe3816070) at /data/src/10.2/sql/sql_admin.cc:1284

#6  0x00007fb00bf6e7a4 in mysql_execute_command (thd=0x7fafe3816070) at /data/src/10.2/sql/sql_parse.cc:6165

#7  0x00007fb00bf73080 in mysql_parse (thd=0x7fafe3816070, rawbuf=0x7fafe3864088 "ANALYZE TABLE t1, t2, t3, t4, t5, t6, t7, t8, t9, t10, t11, t12, t13, t14, t15, t16, t17, t18, t19, t20", length=103, parser_state=0x7fb00d032dd0, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7839

#8  0x00007fb00bf60c46 in dispatch_command (command=COM_QUERY, thd=0x7fafe3816070, packet=0x7fafe3858071 "", packet_length=103, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1799

#9  0x00007fb00bf5f620 in do_command (thd=0x7fafe3816070) at /data/src/10.2/sql/sql_parse.cc:1359

#10 0x00007fb00c0a73d2 in do_handle_one_connection (connect=0x7fb008c72130) at /data/src/10.2/sql/sql_connect.cc:1354

#11 0x00007fb00c0a715f in handle_one_connection (arg=0x7fb008c72130) at /data/src/10.2/sql/sql_connect.cc:1260

#12 0x00007fb00c3e5d64 in pfs_spawn_thread (arg=0x7faff63edef0) at /data/src/10.2/storage/perfschema/pfs.cc:1862

#13 0x00007fb00b5930a4 in start_thread (arg=0x7fb00d034300) at pthread_create.c:309

#14 0x00007fb00954087d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111

commit 86975e0492c03535271aea67e0b5e7e8fd0b1b78

Author: Oleksandr Byelkin <sanja@mariadb.com>

Date:   Mon Aug 1 19:24:55 2016 +0200

    MDEV-7901: re-implement analyze table for low impact

    Table before collecting engine independent statistics now is reopened in read mode,

    InnoDB allow write operations in this case.