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

Assertion `templ->mysql_col_len == len' failed in row_sel_field_store_in_mysql_format_func

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11
    • 10.5, 10.6, 10.11
    • None

    Description

      --source include/have_innodb.inc
       
       CREATE TABLE t1 ( 
      	id int, 
      	dt1 date, 
      	i1 int,
      	v_i1 int GENERATED ALWAYS AS (i1), 
      	PRIMARY KEY (id,i1),
      	KEY i1 (i1),
      	KEY v_i1 (v_i1)
      ) ENGINE=InnoDB;
       
      INSERT INTO t1(dt1, i1, id) VALUES  
      ('1994-04-27',3,1),('1939-03-07',8,2),('2035-04-15',195,3),('1936-02-07',8,4),('1912-08-14',9,5);
       
      SELECT dt1 FROM t1 WHERE i1 IN (1,2,3) AND (i1 NOT IN (0)) AND (v_i1 <= 0);
      

      10.5 e0d61cb41c809169b58843765ba1

      Version: '10.5.10-MariaDB-debug-log' 
      mariadbd: /10.5/storage/innobase/row/row0sel.cc:2846: void row_sel_field_store_in_mysql_format_func(byte*, const mysql_row_templ_t*, const dict_index_t*, ulint, const byte*, ulint): Assertion `templ->mysql_col_len == len' failed.
      210505 12:57:05 [ERROR] mysqld got signal 6 ;
       
      linux/raise.c:51(__GI_raise)[0x7f7ea79f87bb]
      stdlib/abort.c:81(__GI_abort)[0x7f7ea79e3535]
      intl/loadmsgcat.c:1177(_nl_load_domain)[0x7f7ea79e340f]
      ??:0(__assert_fail)[0x7f7ea79f1102]
      row/row0sel.cc:2848(row_sel_field_store_in_mysql_format_func(unsigned char*, mysql_row_templ_t const*, dict_index_t const*, unsigned long, unsigned char const*, unsigned long))[0x5654c1ab8538]
      row/row0sel.cc:3001(row_sel_store_mysql_field(unsigned char*, row_prebuilt_t*, unsigned char const*, dict_index_t const*, unsigned short const*, unsigned long, mysql_row_templ_t const*))[0x5654c1ab98a8]
      row/row0sel.cc:3965(row_search_idx_cond_check(unsigned char*, row_prebuilt_t*, unsigned char const*, unsigned short const*))[0x5654c1abf0be]
      row/row0sel.cc:5281(row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long))[0x5654c1ac8678]
      handler/ha_innodb.cc:8854(ha_innobase::index_read(unsigned char*, unsigned char const*, unsigned int, ha_rkey_function))[0x5654c16a12fe]
      sql/handler.h:3809(handler::index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function))[0x5654c0bd6001]
      sql/handler.cc:3123(handler::ha_index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function))[0x5654c0ba6bf5]
      sql/handler.cc:6200(handler::read_range_first(st_key_range const*, st_key_range const*, bool, bool))[0x5654c0bc1454]
      sql/multi_range_read.cc:516(handler::multi_range_read_next(void**))[0x5654c08a9484]
      sql/multi_range_read.cc:553(Mrr_simple_index_reader::get_next(void**))[0x5654c08a9858]
      sql/multi_range_read.cc:1653(DsMrr_impl::dsmrr_next(void**))[0x5654c08b3237]
      handler/ha_innodb.cc:20409(ha_innobase::multi_range_read_next(void**))[0x5654c16d370c]
      sql/opt_range.cc:12647(QUICK_RANGE_SELECT::get_next())[0x5654c0fb3f8d]
      sql/records.cc:403(rr_quick(READ_RECORD*))[0x5654c0fe8107]
      sql/records.h:80(READ_RECORD::read_record())[0x5654c01fbf5a]
      sql/sql_select.cc:21766(join_init_read_record(st_join_table*))[0x5654c04ff80f]
      sql/sql_select.cc:20818(sub_select(JOIN*, st_join_table*, bool))[0x5654c04f8af7]
      sql/sql_select.cc:20355(do_select(JOIN*, Procedure*))[0x5654c04f6e52]
      sql/sql_select.cc:4503(JOIN::exec_inner())[0x5654c04843ae]
      sql/sql_select.cc:4284(JOIN::exec())[0x5654c04819fc]
      sql/sql_select.cc:4761(mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x5654c0485c9d]
      sql/sql_select.cc:443(handle_select(THD*, LEX*, select_result*, unsigned long))[0x5654c0457ae3]
      sql/sql_parse.cc:6313(execute_sqlcom_select(THD*, TABLE_LIST*))[0x5654c03c45d6]
      sql/sql_parse.cc:4009(mysql_execute_command(THD*))[0x5654c03b3585]
      sql/sql_parse.cc:8099(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x5654c03cf460]
      sql/sql_parse.cc:1894(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5654c03a58d9]
      sql/sql_parse.cc:1370(do_command(THD*))[0x5654c03a21e5]
      sql/sql_connect.cc:1410(do_handle_one_connection(CONNECT*, bool))[0x5654c07d4b66]
      sql/sql_connect.cc:1314(handle_one_connection)[0x5654c07d44c3]
      perfschema/pfs.cc:2203(pfs_spawn_thread)[0x5654c14a2e46]
      nptl/pthread_create.c:487(start_thread)[0x7f7ea7eb1fa3]
      x86_64/clone.S:97(clone)[0x7f7ea7aba4cf]
       
      Query (0x62b0000a12a8): SELECT dt1 FROM t1 WHERE i1 IN (1,2,3) AND (i1 NOT IN (0)) AND (v_i1 <= 0)
      

      no visible effect on non-debug build

      Attachments

        Issue Links

          Activity

            Another one of the same category. Since they all are clearly related and none gets fixed, I don't see much point in getting a test case and filing another report, I'll just leave it here for future reference.

            10.8 0e0a3580

            mariadbd: /data/src/10.8/storage/innobase/row/row0sel.cc:3016: ulint row_sel_store_mysql_field(byte*, row_prebuilt_t*, const rec_t*, const dict_index_t*, const rec_offs*, ulint, const mysql_row_templ_t*): Assertion `templ->mysql_null_bit_mask' failed.
            220529  1:19:17 [ERROR] mysqld got signal 6 ;
             
            #7  0x00007f8a78fbb662 in __GI___assert_fail (assertion=0x559beb5cdc6b "templ->mysql_null_bit_mask", file=0x559beb5cc788 "/data/src/10.8/storage/innobase/row/row0sel.cc", line=3016, function=0x559beb5cdaa0 "ulint row_sel_store_mysql_field(byte*, row_prebuilt_t*, const rec_t*, const dict_index_t*, const rec_offs*, ulint, const mysql_row_templ_t*)") at assert.c:101
            #8  0x0000559beae7162f in row_sel_store_mysql_field (mysql_rec=0x7f8a482374e0 "\217\217\200", prebuilt=0x7f8a48044f08, rec=0x7f8a6e84407e "\216\346\265\a", index=0x7f8a480faec8, offsets=0x7f8a6c5567f0, field_no=1, templ=0x7f8a48ba2b28) at /data/src/10.8/storage/innobase/row/row0sel.cc:3016
            #9  0x0000559beae73fe2 in row_search_idx_cond_check (mysql_rec=0x7f8a482374e0 "\217\217\200", prebuilt=0x7f8a48044f08, rec=0x7f8a6e84407e "\216\346\265\a", offsets=0x7f8a6c5567f0) at /data/src/10.8/storage/innobase/row/row0sel.cc:4030
            #10 0x0000559beae782b6 in row_search_mvcc (buf=0x7f8a482374e0 "\217\217\200", mode=PAGE_CUR_GE, prebuilt=0x7f8a48044f08, match_mode=1, direction=0) at /data/src/10.8/storage/innobase/row/row0sel.cc:5414
            #11 0x0000559beac7ccf8 in ha_innobase::index_read (this=0x7f8a48114c00, buf=0x7f8a482374e0 "\217\217\200", key_ptr=0x7f8a48019098 "\001", key_len=67, find_flag=HA_READ_KEY_EXACT) at /data/src/10.8/storage/innobase/handler/ha_innodb.cc:8990
            #12 0x0000559bea7c0108 in handler::index_read_map (this=0x7f8a48114c00, buf=0x7f8a482374e0 "\217\217\200", key=0x7f8a48019098 "\001", keypart_map=1, find_flag=HA_READ_KEY_EXACT) at /data/src/10.8/sql/handler.h:3855
            #13 0x0000559bea899acd in handler::ha_index_read_map (this=0x7f8a48114c00, buf=0x7f8a482374e0 "\217\217\200", key=0x7f8a48019098 "\001", keypart_map=1, find_flag=HA_READ_KEY_EXACT) at /data/src/10.8/sql/handler.cc:3471
            #14 0x0000559bea57b5a5 in join_read_always_key (tab=0x7f8a48230778) at /data/src/10.8/sql/sql_select.cc:21943
            #15 0x0000559bea57984d in sub_select (join=0x7f8a48017108, join_tab=0x7f8a48230778, end_of_records=false) at /data/src/10.8/sql/sql_select.cc:21160
            #16 0x0000559bea578d5f in do_select (join=0x7f8a48017108, procedure=0x0) at /data/src/10.8/sql/sql_select.cc:20708
            #17 0x0000559bea54c24e in JOIN::exec_inner (this=0x7f8a48017108) at /data/src/10.8/sql/sql_select.cc:4759
            #18 0x0000559bea54b2c3 in JOIN::exec (this=0x7f8a48017108) at /data/src/10.8/sql/sql_select.cc:4537
            #19 0x0000559bea54cbf4 in mysql_select (thd=0x7f8a48000db8, tables=0x7f8a48015ad0, fields=..., conds=0x7f8a48016708, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f8a480170e0, unit=0x7f8a480051c8, select_lex=0x7f8a480154f8) at /data/src/10.8/sql/sql_select.cc:5017
            #20 0x0000559bea53befd in handle_select (thd=0x7f8a48000db8, lex=0x7f8a480050f0, result=0x7f8a480170e0, setup_tables_done_option=0) at /data/src/10.8/sql/sql_select.cc:551
            #21 0x0000559bea4e4d9b in execute_sqlcom_select (thd=0x7f8a48000db8, all_tables=0x7f8a48015ad0) at /data/src/10.8/sql/sql_parse.cc:6252
            #22 0x0000559bea4dc0c0 in mysql_execute_command (thd=0x7f8a48000db8, is_called_from_prepared_stmt=false) at /data/src/10.8/sql/sql_parse.cc:3943
            #23 0x0000559bea4e9b0d in mysql_parse (thd=0x7f8a48000db8, rawbuf=0x7f8a48015410 "SELECT * FROM t5 WHERE id BETWEEN 8 AND 366 AND vcol_varchar IS NULL", length=68, parser_state=0x7f8a6c558500) at /data/src/10.8/sql/sql_parse.cc:8027
            #24 0x0000559bea4d6196 in dispatch_command (command=COM_QUERY, thd=0x7f8a48000db8, packet=0x7f8a48b137a9 "", packet_length=68, blocking=true) at /data/src/10.8/sql/sql_parse.cc:1894
            #25 0x0000559bea4d4b91 in do_command (thd=0x7f8a48000db8, blocking=true) at /data/src/10.8/sql/sql_parse.cc:1407
            #26 0x0000559bea6a821a in do_handle_one_connection (connect=0x559beed1a148, put_in_cache=true) at /data/src/10.8/sql/sql_connect.cc:1418
            #27 0x0000559bea6a7eb9 in handle_one_connection (arg=0x559beed2fa18) at /data/src/10.8/sql/sql_connect.cc:1312
            #28 0x0000559beab9eb26 in pfs_spawn_thread (arg=0x559beed19cb8) at /data/src/10.8/storage/perfschema/pfs.cc:2201
            #29 0x00007f8a79485ea7 in start_thread (arg=<optimized out>) at pthread_create.c:477
            #30 0x00007f8a79084def in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
            

            elenst Elena Stepanova added a comment - Another one of the same category. Since they all are clearly related and none gets fixed, I don't see much point in getting a test case and filing another report, I'll just leave it here for future reference. 10.8 0e0a3580 mariadbd: /data/src/10.8/storage/innobase/row/row0sel.cc:3016: ulint row_sel_store_mysql_field(byte*, row_prebuilt_t*, const rec_t*, const dict_index_t*, const rec_offs*, ulint, const mysql_row_templ_t*): Assertion `templ->mysql_null_bit_mask' failed. 220529 1:19:17 [ERROR] mysqld got signal 6 ;   #7 0x00007f8a78fbb662 in __GI___assert_fail (assertion=0x559beb5cdc6b "templ->mysql_null_bit_mask", file=0x559beb5cc788 "/data/src/10.8/storage/innobase/row/row0sel.cc", line=3016, function=0x559beb5cdaa0 "ulint row_sel_store_mysql_field(byte*, row_prebuilt_t*, const rec_t*, const dict_index_t*, const rec_offs*, ulint, const mysql_row_templ_t*)") at assert.c:101 #8 0x0000559beae7162f in row_sel_store_mysql_field (mysql_rec=0x7f8a482374e0 "\217\217\200", prebuilt=0x7f8a48044f08, rec=0x7f8a6e84407e "\216\346\265\a", index=0x7f8a480faec8, offsets=0x7f8a6c5567f0, field_no=1, templ=0x7f8a48ba2b28) at /data/src/10.8/storage/innobase/row/row0sel.cc:3016 #9 0x0000559beae73fe2 in row_search_idx_cond_check (mysql_rec=0x7f8a482374e0 "\217\217\200", prebuilt=0x7f8a48044f08, rec=0x7f8a6e84407e "\216\346\265\a", offsets=0x7f8a6c5567f0) at /data/src/10.8/storage/innobase/row/row0sel.cc:4030 #10 0x0000559beae782b6 in row_search_mvcc (buf=0x7f8a482374e0 "\217\217\200", mode=PAGE_CUR_GE, prebuilt=0x7f8a48044f08, match_mode=1, direction=0) at /data/src/10.8/storage/innobase/row/row0sel.cc:5414 #11 0x0000559beac7ccf8 in ha_innobase::index_read (this=0x7f8a48114c00, buf=0x7f8a482374e0 "\217\217\200", key_ptr=0x7f8a48019098 "\001", key_len=67, find_flag=HA_READ_KEY_EXACT) at /data/src/10.8/storage/innobase/handler/ha_innodb.cc:8990 #12 0x0000559bea7c0108 in handler::index_read_map (this=0x7f8a48114c00, buf=0x7f8a482374e0 "\217\217\200", key=0x7f8a48019098 "\001", keypart_map=1, find_flag=HA_READ_KEY_EXACT) at /data/src/10.8/sql/handler.h:3855 #13 0x0000559bea899acd in handler::ha_index_read_map (this=0x7f8a48114c00, buf=0x7f8a482374e0 "\217\217\200", key=0x7f8a48019098 "\001", keypart_map=1, find_flag=HA_READ_KEY_EXACT) at /data/src/10.8/sql/handler.cc:3471 #14 0x0000559bea57b5a5 in join_read_always_key (tab=0x7f8a48230778) at /data/src/10.8/sql/sql_select.cc:21943 #15 0x0000559bea57984d in sub_select (join=0x7f8a48017108, join_tab=0x7f8a48230778, end_of_records=false) at /data/src/10.8/sql/sql_select.cc:21160 #16 0x0000559bea578d5f in do_select (join=0x7f8a48017108, procedure=0x0) at /data/src/10.8/sql/sql_select.cc:20708 #17 0x0000559bea54c24e in JOIN::exec_inner (this=0x7f8a48017108) at /data/src/10.8/sql/sql_select.cc:4759 #18 0x0000559bea54b2c3 in JOIN::exec (this=0x7f8a48017108) at /data/src/10.8/sql/sql_select.cc:4537 #19 0x0000559bea54cbf4 in mysql_select (thd=0x7f8a48000db8, tables=0x7f8a48015ad0, fields=..., conds=0x7f8a48016708, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f8a480170e0, unit=0x7f8a480051c8, select_lex=0x7f8a480154f8) at /data/src/10.8/sql/sql_select.cc:5017 #20 0x0000559bea53befd in handle_select (thd=0x7f8a48000db8, lex=0x7f8a480050f0, result=0x7f8a480170e0, setup_tables_done_option=0) at /data/src/10.8/sql/sql_select.cc:551 #21 0x0000559bea4e4d9b in execute_sqlcom_select (thd=0x7f8a48000db8, all_tables=0x7f8a48015ad0) at /data/src/10.8/sql/sql_parse.cc:6252 #22 0x0000559bea4dc0c0 in mysql_execute_command (thd=0x7f8a48000db8, is_called_from_prepared_stmt=false) at /data/src/10.8/sql/sql_parse.cc:3943 #23 0x0000559bea4e9b0d in mysql_parse (thd=0x7f8a48000db8, rawbuf=0x7f8a48015410 "SELECT * FROM t5 WHERE id BETWEEN 8 AND 366 AND vcol_varchar IS NULL", length=68, parser_state=0x7f8a6c558500) at /data/src/10.8/sql/sql_parse.cc:8027 #24 0x0000559bea4d6196 in dispatch_command (command=COM_QUERY, thd=0x7f8a48000db8, packet=0x7f8a48b137a9 "", packet_length=68, blocking=true) at /data/src/10.8/sql/sql_parse.cc:1894 #25 0x0000559bea4d4b91 in do_command (thd=0x7f8a48000db8, blocking=true) at /data/src/10.8/sql/sql_parse.cc:1407 #26 0x0000559bea6a821a in do_handle_one_connection (connect=0x559beed1a148, put_in_cache=true) at /data/src/10.8/sql/sql_connect.cc:1418 #27 0x0000559bea6a7eb9 in handle_one_connection (arg=0x559beed2fa18) at /data/src/10.8/sql/sql_connect.cc:1312 #28 0x0000559beab9eb26 in pfs_spawn_thread (arg=0x559beed19cb8) at /data/src/10.8/storage/perfschema/pfs.cc:2201 #29 0x00007f8a79485ea7 in start_thread (arg=<optimized out>) at pthread_create.c:477 #30 0x00007f8a79084def in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
            alice Alice Sherepa added a comment -

            repeatable on 10.5-10.11

            mariadbd: /10.11/src/storage/innobase/row/row0sel.cc:2943: void row_sel_field_store_in_mysql_format_func(byte*, const mysql_row_templ_t*, const dict_index_t*, ulint, const byte*, ulint): Assertion `templ->mysql_col_len == len' failed.
            240306 18:08:43 [ERROR] mysqld got signal 6 ;
             
            Server version: 10.11.8-MariaDB-debug-log source revision: 7246054cbbe71f960c3da5f70b1c038216ed38e8
             
            /lib/x86_64-linux-gnu/libc.so.6(+0x33fd6)[0x7fe9da337fd6]
            row/row0sel.cc:2945(row_sel_field_store_in_mysql_format_func(unsigned char*, mysql_row_templ_t const*, dict_index_t const*, unsigned long, unsigned char const*, unsigned long))[0x55a77ff108fd]
            row/row0sel.cc:3098(row_sel_store_mysql_field(unsigned char*, row_prebuilt_t*, unsigned char const*, dict_index_t const*, unsigned short const*, unsigned long, mysql_row_templ_t const*))[0x55a77ff11d10]
            row/row0sel.cc:4059(row_search_idx_cond_check(unsigned char*, row_prebuilt_t*, unsigned char const*, unsigned short const*))[0x55a77ff17b15]
            row/row0sel.cc:5464(row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long))[0x55a77ff21164]
            handler/ha_innodb.cc:8980(ha_innobase::index_read(unsigned char*, unsigned char const*, unsigned int, ha_rkey_function))[0x55a77fac6feb]
            sql/handler.h:3858(handler::index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function))[0x55a77ef32ebd]
            sql/handler.cc:3533(handler::ha_index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function))[0x55a77f0ec91e]
            sql/handler.cc:6677(handler::read_range_first(st_key_range const*, st_key_range const*, bool, bool))[0x55a77f108b44]
            sql/multi_range_read.cc:518(handler::multi_range_read_next(void**))[0x55a77ed6e859]
            sql/multi_range_read.cc:555(Mrr_simple_index_reader::get_next(void**))[0x55a77ed6ecaa]
            sql/multi_range_read.cc:1655(DsMrr_impl::dsmrr_next(void**))[0x55a77ed78911]
            handler/ha_innodb.cc:19971(ha_innobase::multi_range_read_next(void**))[0x55a77faff6b8]
            sql/opt_range.cc:12890(QUICK_RANGE_SELECT::get_next())[0x55a77e47f553]
            sql/records.cc:403(rr_quick(READ_RECORD*))[0x55a77e4db4b8]
            sql/records.h:81(READ_RECORD::read_record())[0x55a77e4a70ec]
            sql/sql_select.cc:23378(join_init_read_record(st_join_table*))[0x55a77e970bcd]
            sql/sql_select.cc:22342(sub_select(JOIN*, st_join_table*, bool))[0x55a77e9699d0]
            sql/sql_select.cc:21868(do_select(JOIN*, Procedure*))[0x55a77e9678f2]
            sql/sql_select.cc:4912(JOIN::exec_inner())[0x55a77e8ec898]
            sql/sql_select.cc:4691(JOIN::exec())[0x55a77e8e9d98]
            sql/sql_select.cc:5172(mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x55a77e8ee307]
            sql/sql_select.cc:586(handle_select(THD*, LEX*, select_result*, unsigned long long))[0x55a77e8bd3b9]
            sql/sql_parse.cc:6381(execute_sqlcom_select(THD*, TABLE_LIST*))[0x55a77e7de453]
            sql/sql_parse.cc:3980(mysql_execute_command(THD*, bool))[0x55a77e7cc6b1]
            sql/sql_parse.cc:8123(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x55a77e7e936f]
            sql/sql_parse.cc:1896(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x55a77e7bea0c]
            sql/sql_parse.cc:1407(do_command(THD*, bool))[0x55a77e7bb746]
            sql/sql_connect.cc:1415(do_handle_one_connection(CONNECT*, bool))[0x55a77ec8aa70]
            sql/sql_connect.cc:1319(handle_one_connection)[0x55a77ec8a3cd]
            perfschema/pfs.cc:2203(pfs_spawn_thread)[0x55a77f8be9aa]
            nptl/pthread_create.c:478(start_thread)[0x7fe9da852609]
             
            Query (0x6290001092a8): SELECT dt1 FROM t1 WHERE i1 IN (1,2,3) AND (i1 NOT IN (0)) AND (v_i1 <= 0)
            
            

            alice Alice Sherepa added a comment - repeatable on 10.5-10.11 mariadbd: /10.11/src/storage/innobase/row/row0sel.cc:2943: void row_sel_field_store_in_mysql_format_func(byte*, const mysql_row_templ_t*, const dict_index_t*, ulint, const byte*, ulint): Assertion `templ->mysql_col_len == len' failed. 240306 18:08:43 [ERROR] mysqld got signal 6 ;   Server version: 10.11.8-MariaDB-debug-log source revision: 7246054cbbe71f960c3da5f70b1c038216ed38e8   /lib/x86_64-linux-gnu/libc.so.6(+0x33fd6)[0x7fe9da337fd6] row/row0sel.cc:2945(row_sel_field_store_in_mysql_format_func(unsigned char*, mysql_row_templ_t const*, dict_index_t const*, unsigned long, unsigned char const*, unsigned long))[0x55a77ff108fd] row/row0sel.cc:3098(row_sel_store_mysql_field(unsigned char*, row_prebuilt_t*, unsigned char const*, dict_index_t const*, unsigned short const*, unsigned long, mysql_row_templ_t const*))[0x55a77ff11d10] row/row0sel.cc:4059(row_search_idx_cond_check(unsigned char*, row_prebuilt_t*, unsigned char const*, unsigned short const*))[0x55a77ff17b15] row/row0sel.cc:5464(row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long))[0x55a77ff21164] handler/ha_innodb.cc:8980(ha_innobase::index_read(unsigned char*, unsigned char const*, unsigned int, ha_rkey_function))[0x55a77fac6feb] sql/handler.h:3858(handler::index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function))[0x55a77ef32ebd] sql/handler.cc:3533(handler::ha_index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function))[0x55a77f0ec91e] sql/handler.cc:6677(handler::read_range_first(st_key_range const*, st_key_range const*, bool, bool))[0x55a77f108b44] sql/multi_range_read.cc:518(handler::multi_range_read_next(void**))[0x55a77ed6e859] sql/multi_range_read.cc:555(Mrr_simple_index_reader::get_next(void**))[0x55a77ed6ecaa] sql/multi_range_read.cc:1655(DsMrr_impl::dsmrr_next(void**))[0x55a77ed78911] handler/ha_innodb.cc:19971(ha_innobase::multi_range_read_next(void**))[0x55a77faff6b8] sql/opt_range.cc:12890(QUICK_RANGE_SELECT::get_next())[0x55a77e47f553] sql/records.cc:403(rr_quick(READ_RECORD*))[0x55a77e4db4b8] sql/records.h:81(READ_RECORD::read_record())[0x55a77e4a70ec] sql/sql_select.cc:23378(join_init_read_record(st_join_table*))[0x55a77e970bcd] sql/sql_select.cc:22342(sub_select(JOIN*, st_join_table*, bool))[0x55a77e9699d0] sql/sql_select.cc:21868(do_select(JOIN*, Procedure*))[0x55a77e9678f2] sql/sql_select.cc:4912(JOIN::exec_inner())[0x55a77e8ec898] sql/sql_select.cc:4691(JOIN::exec())[0x55a77e8e9d98] sql/sql_select.cc:5172(mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x55a77e8ee307] sql/sql_select.cc:586(handle_select(THD*, LEX*, select_result*, unsigned long long))[0x55a77e8bd3b9] sql/sql_parse.cc:6381(execute_sqlcom_select(THD*, TABLE_LIST*))[0x55a77e7de453] sql/sql_parse.cc:3980(mysql_execute_command(THD*, bool))[0x55a77e7cc6b1] sql/sql_parse.cc:8123(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x55a77e7e936f] sql/sql_parse.cc:1896(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x55a77e7bea0c] sql/sql_parse.cc:1407(do_command(THD*, bool))[0x55a77e7bb746] sql/sql_connect.cc:1415(do_handle_one_connection(CONNECT*, bool))[0x55a77ec8aa70] sql/sql_connect.cc:1319(handle_one_connection)[0x55a77ec8a3cd] perfschema/pfs.cc:2203(pfs_spawn_thread)[0x55a77f8be9aa] nptl/pthread_create.c:478(start_thread)[0x7fe9da852609]   Query (0x6290001092a8): SELECT dt1 FROM t1 WHERE i1 IN (1,2,3) AND (i1 NOT IN (0)) AND (v_i1 <= 0)

            People

              nikitamalyavin Nikita Malyavin
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.