ANALYZE TABLE crashes debug build on --innodb-read-only instance

[Laurynas Biveinis]

--source include/have_innodb.inc

CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=InnoDB;
INSERT INTO t1 VALUES (1);

--source include/restart_readonly_mysqld.inc

ANALYZE TABLE t1;

--source include/restart_mysqld.inc

DROP TABLE t1;

results in

2016-12-01 11:15:32 7000030b6000 InnoDB: Assertion failure in thread 123145353388032 in file dict0stats_bg.cc line 159
InnoDB: Failing assertion: !srv_read_only_mode
...
0 mysqld-debug 0x000000010121e34e my_print_stacktrace + 222
1 mysqld-debug 0x0000000100c86036 handle_fatal_signal + 1558
2 libsystem_platform.dylib 0x00007fff9bc69bba _sigtramp + 26
3 ??? 0x0000000000000006 0x0 + 6
4 libsystem_c.dylib 0x00007fff9baf0420 abort + 129
5 mysqld-debug 0x000000010136ebb1 _Z26dict_stats_recalc_pool_delPK12dict_table_t + 593
6 mysqld-debug 0x000000010140b0aa _ZN11ha_innobase8info_lowEjb + 714
7 mysqld-debug 0x000000010140cd1d _ZN11ha_innobase7analyzeEP3THDP15st_ha_check_opt + 125
8 mysqld-debug 0x0000000100cf9ffd _ZL17mysql_admin_tableP3THDP10TABLE_LISTP15st_ha_check_optPKc13thr_lock_typebbjPFiS0_S2_S4_EM7handlerFiS0_S4_EPFiS0_S2_E + 15149
9 mysqld-debug 0x0000000100cfb5cc _ZN21Sql_cmd_analyze_table7executeEP3THD + 492
10 mysqld-debug 0x0000000100e4d1f7 _Z21mysql_execute_commandP3THD + 5063
11 mysqld-debug 0x0000000100e48f48 _Z11mysql_parseP3THDPcjP12Parser_state + 3176
12 mysqld-debug 0x0000000100e430da _Z16dispatch_command19enum_server_commandP3THDPcj + 2250
13 mysqld-debug 0x0000000100e4771d _Z10do_commandP3THD + 1117
14 mysqld-debug 0x0000000100d83f2a _Z24do_handle_one_connectionP3THD + 986
15 mysqld-debug 0x0000000100d83a9d handle_one_connection + 61
16 mysqld-debug 0x000000010173eb6e pfs_spawn_thread + 462
17 libsystem_pthread.dylib 0x00007fff9bc73aab _pthread_body + 180
18 libsystem_pthread.dylib 0x00007fff9bc739f7 _pthread_body + 0
19 libsystem_pthread.dylib 0x00007fff9bc73221 thread_start + 13

This is a regression introduced by bug 1626441 fix.

[Laurynas Biveinis (laurynas-biveinis)]

    https://github.com/percona/percona-server/pull/1221
    https://github.com/percona/percona-server/pull/1222

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-1034