InnoDB: Failing assertion: purge_sys->state == PURGE_STATE_RUN in file ha_innodb.cc line 18605

[Roel Van de Paar]

2015-11-24T05:04:01.881145Z 0 [Note] Plugin 'FEDERATED' is disabled.
2015-11-24T05:04:01.881797Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`plugin` in the cache. Attempting to load the tablespace with space id 2
2015-11-24T05:04:01.894178Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`gtid_executed` in the cache. Attempting to load the tablespace with space id 18
2015-11-24T05:04:01.905093Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2015-11-24T05:04:01.905123Z 0 [Note] Server hostname (bind-address): '*'; port: 19303
2015-11-24T05:04:01.905180Z 0 [Note] IPv6 is available.
2015-11-24T05:04:01.905194Z 0 [Note] - '::' resolves to '::';
2015-11-24T05:04:01.905208Z 0 [Note] Server socket created on IP: '::'.
2015-11-24T05:04:01.918629Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`server_cost` in the cache. Attempting to load the tablespace with space id 19
2015-11-24T05:04:01.929280Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`engine_cost` in the cache. Attempting to load the tablespace with space id 20
2015-11-24T05:04:01.942826Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`time_zone_leap_second` in the cache. Attempting to load the tablespace with space id 12
2015-11-24T05:04:01.952824Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`time_zone_name` in the cache. Attempting to load the tablespace with space id 8
2015-11-24T05:04:01.960652Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`time_zone` in the cache. Attempting to load the tablespace with space id 9
2015-11-24T05:04:01.968083Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`time_zone_transition_type` in the cache. Attempting to load the tablespace with space id 11
2015-11-24T05:04:01.977639Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`time_zone_transition` in the cache. Attempting to load the tablespace with space id 10
2015-11-24T05:04:01.990965Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`servers` in the cache. Attempting to load the tablespace with space id 3
2015-11-24T05:04:02.015448Z 0 [Note] Event Scheduler: Loaded 0 events
2015-11-24T05:04:02.015613Z 0 [Note] /sda/PS-mysql-5.7.9-90.0-linux-x86_64-debug/bin/mysqld: ready for connections.
Version: '5.7.9-90.0-debug' socket: '/sda/PS-mysql-5.7.9-90.0-linux-x86_64-debug/socket.sock' port: 19303 MySQL Community Server (GPL)
2015-11-24 16:04:06 0x7fe4fee96700 InnoDB: Assertion failure in thread 140621505980160 in file ha_innodb.cc line 18605
InnoDB: Failing assertion: purge_sys->state == PURGE_STATE_RUN

+bt
#0 0x00007fe4fe89c771 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
#1 0x00000000017b8e24 in my_write_core (sig=6) at /git/PS-5.7-Beta_dbg/mysys/stacktrace.c:247
#2 0x0000000000e2663f in handle_fatal_signal (sig=6) at /git/PS-5.7-Beta_dbg/sql/signal_handler.cc:223
#3 <signal handler called>
#4 0x00007fe4fd4a05d7 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
#5 0x00007fe4fd4a1cc8 in __GI_abort () at abort.c:90
#6 0x0000000001b230ef in ut_dbg_assertion_failed (expr=0x2163da0 "purge_sys->state == PURGE_STATE_RUN", file=0x215cc98 "/git/PS-5.7-Beta_dbg/storage/innobase/handler/ha_innodb.cc", line=18605) at /git/PS-5.7-Beta_dbg/storage/innobase/ut/ut0dbg.cc:67
#7 0x00000000019060d5 in innodb_sched_priority_purge_update (thd=0x7fe445c19000, var=0x2b88380 <mysql_sysvar_sched_priority_purge>, var_ptr=0x2b90678 <srv_sched_priority_purge>, save=0x7fe445c2bbd8) at /git/PS-5.7-Beta_dbg/storage/innobase/handler/ha_innodb.cc:18605
#8 0x00000000014e3e27 in sys_var_pluginvar::global_update (this=0x7fe4f3baea80, thd=0x7fe445c19000, var=0x7fe445c2bbb8) at /git/PS-5.7-Beta_dbg/sql/sql_plugin.cc:3466
#9 0x00000000013f65b6 in sys_var::update (this=0x7fe4f3baea80, thd=0x7fe445c19000, var=0x7fe445c2bbb8) at /git/PS-5.7-Beta_dbg/sql/set_var.cc:183
#10 0x00000000013f7cc6 in set_var::update (this=0x7fe445c2bbb8, thd=0x7fe445c19000) at /git/PS-5.7-Beta_dbg/sql/set_var.cc:812
#11 0x00000000013f758e in sql_set_variables (thd=0x7fe445c19000, var_list=0x7fe445c1b9b0) at /git/PS-5.7-Beta_dbg/sql/set_var.cc:669
#12 0x00000000014b2c27 in mysql_execute_command (thd=0x7fe445c19000, first_level=true) at /git/PS-5.7-Beta_dbg/sql/sql_parse.cc:3666
#13 0x00000000014b8284 in mysql_parse (thd=0x7fe445c19000, parser_state=0x7fe4fee95610) at /git/PS-5.7-Beta_dbg/sql/sql_parse.cc:5665
#14 0x00000000014ad12c in dispatch_command (thd=0x7fe445c19000, com_data=0x7fe4fee95db0, command=COM_QUERY) at /git/PS-5.7-Beta_dbg/sql/sql_parse.cc:1304
#15 0x00000000014ac048 in do_command (thd=0x7fe445c19000) at /git/PS-5.7-Beta_dbg/sql/sql_parse.cc:867
#16 0x00000000015e2a1b in handle_connection (arg=0x7fe4e43ff970) at /git/PS-5.7-Beta_dbg/sql/conn_handler/connection_handler_per_thread.cc:298
#17 0x00000000017e8208 in pfs_spawn_thread (arg=0x7fe44caa9620) at /git/PS-5.7-Beta_dbg/storage/perfschema/pfs.cc:2192
#18 0x00007fe4fe897df5 in start_thread (arg=0x7fe4fee96700) at pthread_create.c:308
#19 0x00007fe4fd5611ad in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113

TESTCASE:
# mysqld options required for replay: --innodb-force-recovery=2047
SET GLOBAL innodb_sched_priority_purge=5;

Does not crash MS 5.7.9 as there is no such innodb_sched_priority_purge option available there.

[Roel Van de Paar (roel11)]

Ref bug 1368552