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

Bug #1520403 reported by Roel Van de Paar
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Status tracked in 5.7
5.7
Triaged
High
Laurynas Biveinis

Bug Description

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).

Tags: qa qa57
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :

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.

Revision history for this message
Roel Van de Paar (roel11) wrote :

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%';

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.