trx0trx.cc:1313: void trx_start_low(trx_t*, bool): Assertion `!srv_read_only_mode' failed

CURRENT_TEST: innodb.alter_copy

mysqltest: At line 78: query 'SELECT * FROM t1 WHERE MATCH(b) AGAINST ('first')' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:

< snip >

t.frm

t.ibd

t1.frm

t1.ibd

SHOW CREATE TABLE t;

Table	Create Table

t	CREATE TABLE `t` (

  `a` bigint(20) unsigned NOT NULL AUTO_INCREMENT,

  `b` int(11) DEFAULT NULL,

  `c` int(11) DEFAULT NULL,

  `d` int(11) DEFAULT NULL,

  UNIQUE KEY `a` (`a`)

) ENGINE=InnoDB AUTO_INCREMENT=1000 DEFAULT CHARSET=latin1

SELECT COUNT(*) FROM t;

COUNT(*)

999

CHECK TABLE t;

Table	Op	Msg_type	Msg_text

test.t	check	status	OK

SELECT * FROM t1 WHERE MATCH(b) AGAINST ('first');

Version: '10.2.14-MariaDB-debug-log'  socket: '/home/alice/git/10.2/mysql-test/var/tmp/1/mysqld.1.sock'  port: 16000  Source distribution

mysqld: /home/alice/git/10.2/storage/innobase/trx/trx0trx.cc:1313: void trx_start_low(trx_t*, bool): Assertion `!srv_read_only_mode' failed.

180215 13:07:29 [ERROR] mysqld got signal 6 ;

Server version: 10.2.14-MariaDB-debug-log

key_buffer_size=1048576

read_buffer_size=131072

max_used_connections=1

max_threads=153

thread_count=2

It is possible that mysqld could use up to 

key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 63125 K  bytes of memory

Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x7f3f80000b00

Attempting backtrace. You can use the following information to find out

where mysqld died. If you see no messages after this, something went

terribly wrong...

stack_bottom = 0x7f3fa03d0e70 thread_stack 0x49000

mysys/stacktrace.c:267(my_print_stacktrace)[0x557794efc584]

sql/signal_handler.cc:168(handle_fatal_signal)[0x55779478eebb]

/lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7f3fa8bb5390]

linux/raise.c:54(__GI_raise)[0x7f3fa7f6e428]

stdlib/abort.c:91(__GI_abort)[0x7f3fa7f7002a]

assert/assert.c:92(__assert_fail_base)[0x7f3fa7f66bd7]

/lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7f3fa7f66c82]

trx/trx0trx.cc:1315(trx_start_low(trx_t*, bool))[0x557794be4306]

trx/trx0trx.cc:2996(trx_start_internal_low(trx_t*))[0x557794be8bbb]

fts/fts0fts.cc:2704(fts_cmp_set_sync_doc_id(dict_table_t const*, unsigned long, unsigned long, unsigned long*))[0x557794d20273]

fts/fts0fts.cc:7626(fts_init_index(dict_table_t*, unsigned long))[0x557794d2b2c1]

handler/ha_innodb.cc:10398(ha_innobase::ft_init_ext(unsigned int, unsigned int, String*))[0x5577949e98d7]

sql/item_func.cc:6132(Item_func_match::init_search(THD*, bool))[0x55779481b642]

sql/sql_base.cc:8416(init_ftfuncs(THD*, st_select_lex*, bool))[0x5577944bb08b]

sql/sql_select.cc:2007(JOIN::optimize_inner())[0x557794562d36]

sql/sql_select.cc:1113(JOIN::optimize())[0x55779455fab3]

sql/sql_select.cc:3747(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x557794568b60]

sql/sql_select.cc:376(handle_select(THD*, LEX*, select_result*, unsigned long))[0x55779455d2c1]

sql/sql_parse.cc:6456(execute_sqlcom_select(THD*, TABLE_LIST*))[0x557794529096]

sql/sql_parse.cc:3467(mysql_execute_command(THD*))[0x55779451ee16]

sql/sql_parse.cc:7902(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55779452ca82]

sql/sql_parse.cc:1808(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55779451a6b3]

sql/sql_parse.cc:1360(do_command(THD*))[0x55779451900f]

sql/sql_connect.cc:1335(do_handle_one_connection(CONNECT*))[0x55779466736f]

sql/sql_connect.cc:1242(handle_one_connection)[0x5577946670ef]

perfschema/pfs.cc:1864(pfs_spawn_thread)[0x5577949c4938]

/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f3fa8bab6ba]

x86_64/clone.S:111(clone)[0x7f3fa804041d]

Trying to get some variables.

Some pointers may be invalid and cause the dump to abort.

Query (0x7f3f80012598): SELECT * FROM t1 WHERE MATCH(b) AGAINST ('first')

Connection ID (thread ID): 3

Status: NOT_KILLED

Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on

The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains

information that should help you find out what is causing the crash.

Writing a core file at /home/alice/git/10.2/mysql-test/var/1/mysqld.1/data/

----------SERVER LOG END-------------

Thread 1 (Thread 0x7f3fa03d1700 (LWP 25629)):

#0  __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62

#1  0x0000557794efc676 in my_write_core (sig=6) at /home/alice/git/10.2/mysys/stacktrace.c:477

#2  0x000055779478f2e3 in handle_fatal_signal (sig=6) at /home/alice/git/10.2/sql/signal_handler.cc:305

#3  <signal handler called>

#4  0x00007f3fa7f6e428 in __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:54

#5  0x00007f3fa7f7002a in __GI_abort () at abort.c:89

#6  0x00007f3fa7f66bd7 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x55779519aaa9 "!srv_read_only_mode", file=file@entry=0x557795199e58 "/home/alice/git/10.2/storage/innobase/trx/trx0trx.cc", line=line@entry=1313, function=function@entry=0x55779519cec0 <trx_start_low(trx_t*, bool)::__PRETTY_FUNCTION__> "void trx_start_low(trx_t*, bool)") at assert.c:92

#7  0x00007f3fa7f66c82 in __GI___assert_fail (assertion=0x55779519aaa9 "!srv_read_only_mode", file=0x557795199e58 "/home/alice/git/10.2/storage/innobase/trx/trx0trx.cc", line=1313, function=0x55779519cec0 <trx_start_low(trx_t*, bool)::__PRETTY_FUNCTION__> "void trx_start_low(trx_t*, bool)") at assert.c:101

#8  0x0000557794be4306 in trx_start_low (trx=0x7f3fa1ed5878, read_write=true) at /home/alice/git/10.2/storage/innobase/trx/trx0trx.cc:1313

#9  0x0000557794be8bbb in trx_start_internal_low (trx=0x7f3fa1ed5878) at /home/alice/git/10.2/storage/innobase/trx/trx0trx.cc:2995

#10 0x0000557794d20273 in fts_cmp_set_sync_doc_id (table=0x7f3f80025688, doc_id_cmp=0, read_only=1, doc_id=0x7f3fa03ccc68) at /home/alice/git/10.2/storage/innobase/fts/fts0fts.cc:2702

#11 0x0000557794d2b2c1 in fts_init_index (table=0x7f3f80025688, has_cache_lock=0) at /home/alice/git/10.2/storage/innobase/fts/fts0fts.cc:7625

#12 0x00005577949e98d7 in ha_innobase::ft_init_ext (this=0x7f3f80024728, flags=2, keynr=0, key=0x7f3f80012f38) at /home/alice/git/10.2/storage/innobase/handler/ha_innodb.cc:10396

#13 0x000055779481b642 in Item_func_match::init_search (this=0x7f3f80012fb0, thd=0x7f3f80000b00, no_order=false) at /home/alice/git/10.2/sql/item_func.cc:6132

#14 0x00005577944bb08b in init_ftfuncs (thd=0x7f3f80000b00, select_lex=0x7f3f80004de0, no_order=false) at /home/alice/git/10.2/sql/sql_base.cc:8424

#15 0x0000557794562d36 in JOIN::optimize_inner (this=0x7f3f800131d8) at /home/alice/git/10.2/sql/sql_select.cc:1993

#16 0x000055779455fab3 in JOIN::optimize (this=0x7f3f800131d8) at /home/alice/git/10.2/sql/sql_select.cc:1113

#17 0x0000557794568b60 in mysql_select (thd=0x7f3f80000b00, tables=0x7f3f800127b0, wild_num=1, fields=..., conds=0x7f3f80012fb0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f3f800131b8, unit=0x7f3f800046a8, select_lex=0x7f3f80004de0) at /home/alice/git/10.2/sql/sql_select.cc:3747

#18 0x000055779455d2c1 in handle_select (thd=0x7f3f80000b00, lex=0x7f3f800045e0, result=0x7f3f800131b8, setup_tables_done_option=0) at /home/alice/git/10.2/sql/sql_select.cc:376

#19 0x0000557794529096 in execute_sqlcom_select (thd=0x7f3f80000b00, all_tables=0x7f3f800127b0) at /home/alice/git/10.2/sql/sql_parse.cc:6456

#20 0x000055779451ee16 in mysql_execute_command (thd=0x7f3f80000b00) at /home/alice/git/10.2/sql/sql_parse.cc:3467

#21 0x000055779452ca82 in mysql_parse (thd=0x7f3f80000b00, rawbuf=0x7f3f80012598 "SELECT * FROM t1 WHERE MATCH(b) AGAINST ('first')", length=49, parser_state=0x7f3fa03d0200, is_com_multi=false, is_next_command=false) at /home/alice/git/10.2/sql/sql_parse.cc:7902

#22 0x000055779451a6b3 in dispatch_command (command=COM_QUERY, thd=0x7f3f80000b00, packet=0x7f3f80008951 "SELECT * FROM t1 WHERE MATCH(b) AGAINST ('first')", packet_length=49, is_com_multi=false, is_next_command=false) at /home/alice/git/10.2/sql/sql_parse.cc:1806

#23 0x000055779451900f in do_command (thd=0x7f3f80000b00) at /home/alice/git/10.2/sql/sql_parse.cc:1360

#24 0x000055779466736f in do_handle_one_connection (connect=0x5577974311c0) at /home/alice/git/10.2/sql/sql_connect.cc:1335

#25 0x00005577946670ef in handle_one_connection (arg=0x5577974311c0) at /home/alice/git/10.2/sql/sql_connect.cc:1241

#26 0x00005577949c4938 in pfs_spawn_thread (arg=0x557797394880) at /home/alice/git/10.2/storage/perfschema/pfs.cc:1862

#27 0x00007f3fa8bab6ba in start_thread (arg=0x7f3fa03d1700) at pthread_create.c:333

#28 0x00007f3fa804041d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109