bool open_trans_system_tables_for_read(THD*, TABLE_LIST*): Assertion `!"HA_ATTACHABLE_TRX_COMPATIBLE is not set"' failed.

[Roel Van de Paar]

2015-11-27T02:39:44.837305Z 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)
mysqld: /git/PS-5.7-Beta_dbg/sql/sql_base.cc:10553: bool open_trans_system_tables_for_read(THD*, TABLE_LIST*): Assertion `!"HA_ATTACHABLE_TRX_COMPATIBLE is not set"' failed.
02:39:51 UTC - mysqld got signal 6 ;

+bt
#0 0x00007f93d1964771 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 0x00007f93d05685d7 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
#5 0x00007f93d0569cc8 in __GI_abort () at abort.c:90
#6 0x00007f93d0561546 in __assert_fail_base (fmt=0x7f93d06b1128 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x1ec9aa0 "!\"HA_ATTACHABLE_TRX_COMPATIBLE is not set\"", file=file@entry=0x1ec77a8 "/git/PS-5.7-Beta_dbg/sql/sql_base.cc", line=line@entry=10553, function=function@entry=0x1ecbe80 <open_trans_system_tables_for_read(THD*, TABLE_LIST*)::__PRETTY_FUNCTION__> "bool open_trans_system_tables_for_read(THD*, TABLE_LIST*)") at assert.c:92
#7 0x00007f93d05615f2 in __GI___assert_fail (assertion=0x1ec9aa0 "!\"HA_ATTACHABLE_TRX_COMPATIBLE is not set\"", file=0x1ec77a8 "/git/PS-5.7-Beta_dbg/sql/sql_base.cc", line=10553, function=0x1ecbe80 <open_trans_system_tables_for_read(THD*, TABLE_LIST*)::__PRETTY_FUNCTION__> "bool open_trans_system_tables_for_read(THD*, TABLE_LIST*)") at assert.c:101
#8 0x00000000014360e2 in open_trans_system_tables_for_read (thd=0x7f9305819000, table_list=0x7f93d1f5ac60) at /git/PS-5.7-Beta_dbg/sql/sql_base.cc:10553
#9 0x00000000016a7113 in mysqld_help (thd=0x7f9305819000, mask=0x7f930582b988 "%possible_f%") at /git/PS-5.7-Beta_dbg/sql/sql_help.cc:695
#10 0x00000000014b0593 in mysql_execute_command (thd=0x7f9305819000, first_level=true) at /git/PS-5.7-Beta_dbg/sql/sql_parse.cc:2757
#11 0x00000000014b8284 in mysql_parse (thd=0x7f9305819000, parser_state=0x7f93d1f5d610) at /git/PS-5.7-Beta_dbg/sql/sql_parse.cc:5665
#12 0x00000000014ad12c in dispatch_command (thd=0x7f9305819000, com_data=0x7f93d1f5ddb0, command=COM_QUERY) at /git/PS-5.7-Beta_dbg/sql/sql_parse.cc:1304
#13 0x00000000014ac048 in do_command (thd=0x7f9305819000) at /git/PS-5.7-Beta_dbg/sql/sql_parse.cc:867
#14 0x00000000015e2a1b in handle_connection (arg=0x7f931fbbe1f0) at /git/PS-5.7-Beta_dbg/sql/conn_handler/connection_handler_per_thread.cc:298
#15 0x00000000017e8208 in pfs_spawn_thread (arg=0x7f931faa9820) at /git/PS-5.7-Beta_dbg/storage/perfschema/pfs.cc:2192
#16 0x00007f93d195fdf5 in start_thread (arg=0x7f93d1f5e700) at pthread_create.c:308
#17 0x00007f93d06291ad in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113

# mysqld options required for replay: --maximum-transaction_alloc_block_size=1M --maximum-transaction_prealloc_size=1M --log-output=none --sql_mode=ONLY_FULL_GROUP_BY --enforce-storage-engine=BLACKHOLE
DROP DATABASE test;CREATE DATABASE test;USE test;
alter table mysql.help_keyword engine=TokuDB;
help '%possible_f%';

Note that this is one of the earlier PS 5.7.9 releases (no TokuDB).

[Laurynas Biveinis (laurynas-biveinis)]

This testcase has the effect of alter table mysql.help_keyword engine=blackhole, and that is again bug 1488055. After that is fixed, it will have the effect of alter table mysql.help_keyword engine=tokudb. which may or may not crash but in case is unsupported.

[Roel Van de Paar (roel11)]

Note that PS 5.6.25 (inc TokuDB) does not crash

mysql> alter table mysql.help_keyword engine=TokuDB;
ERROR 1726 (HY000): Storage engine 'BLACKHOLE' does not support system tables. [mysql.help_keyword]
mysql> help '%possible_f%';