Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-15323

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

    XMLWordPrintable

    Details

      Description

      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
      
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                marko Marko Mäkelä
                Reporter:
                alice Alice Sherepa
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: