|
Other observed stack traces, apparently the same problem:
mysqld: /home/travis/src/sql/field.cc:6914: virtual bool Field_datetimef::get_TIME(MYSQL_TIME*, const uchar*, date_mode_t) const: Assertion `marked_for_read()' failed.
|
190421 23:18:04 [ERROR] mysqld got signal 6 ;
|
|
#7 0x00007f415accdc82 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
|
#8 0x000055ff5f0eac28 in Field_datetimef::get_TIME (this=0x7f40f419eba0, ltime=0x7f41580f5a80, pos=0x7f40f419c96e "\231\255\060Eu", fuzzydate=...) at /home/travis/src/sql/field.cc:6914
|
#9 0x000055ff5f0fe1a6 in Field_datetimef::get_date (this=0x7f40f419eba0, ltime=0x7f41580f5a80, fuzzydate=...) at /home/travis/src/sql/field.h:3459
|
#10 0x000055ff5f0fce48 in Field_temporal::save_in_field (this=0x7f40f419eba0, to=0x7f40f419fd98) at /home/travis/src/sql/field.h:2713
|
#11 0x000055ff5f0f9c2c in Field::store_field (this=0x7f40f419fd98, from=0x7f40f419eba0) at /home/travis/src/sql/field.h:774
|
#12 0x000055ff5f103acd in field_conv_incompatible (to=0x7f40f419fd98, from=0x7f40f419eba0) at /home/travis/src/sql/field_conv.cc:851
|
#13 0x000055ff5f103b29 in field_conv (to=0x7f40f419fd98, from=0x7f40f419eba0) at /home/travis/src/sql/field_conv.cc:864
|
#14 0x000055ff5f13bb7b in save_field_in_field (from=0x7f40f419eba0, null_value=0x7f40f41a4bfe, to=0x7f40f419fd98, no_conversions=false) at /home/travis/src/sql/item.cc:6338
|
#15 0x000055ff5f13bdbc in Item_field::save_in_field (this=0x7f40f41a4b88, to=0x7f40f419fd98, no_conversions=false) at /home/travis/src/sql/item.cc:6389
|
#16 0x000055ff5ef05375 in TABLE::update_virtual_fields (this=0x7f40f419b640, h=0x7f40f4024368, update_mode=VCOL_UPDATE_FOR_DELETE) at /home/travis/src/sql/table.cc:8198
|
#17 0x000055ff5f2c5547 in record_should_be_deleted (thd=0x7f40f401c930, table=0x7f40f419b640, sel=0x0, explain=0x7f40f4247200, truncate_history=false) at /home/travis/src/sql/sql_delete.cc:239
|
#18 0x000055ff5f2c7762 in mysql_delete (thd=0x7f40f401c930, table_list=0x7f40f402d408, conds=0x0, order_list=0x7f40f40212d0, limit=1, options=0, result=0x0) at /home/travis/src/sql/sql_delete.cc:809
|
#19 0x000055ff5eddc3f3 in mysql_execute_command (thd=0x7f40f401c930) at /home/travis/src/sql/sql_parse.cc:4982
|
#20 0x000055ff5ede74ba in mysql_parse (thd=0x7f40f401c930, rawbuf=0x7f40f402d0e8 "DELETE LOW_PRIORITY FROM `view_t5` ORDER BY `col_bit`,`col_blob`,`col_char`,`col_dec`,`col_enum`,`col_int`,`col_timestamp`,`col_varchar`,`col_year`,`pk`,`vcol_bit`,`vcol_blob`,`vcol_datetime`,`vcol_de"..., length=301, parser_state=0x7f41580f71d0, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:8154
|
#21 0x000055ff5edd2b5a in dispatch_command (command=COM_QUERY, thd=0x7f40f401c930, packet=0x7f40f4fe7e51 "DELETE LOW_PRIORITY FROM `view_t5` ORDER BY `col_bit`,`col_blob`,`col_char`,`col_dec`,`col_enum`,`col_int`,`col_timestamp`,`col_varchar`,`col_year`,`pk`,`vcol_bit`,`vcol_blob`,`vcol_datetime`,`vcol_de"..., packet_length=302, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:1832
|
#22 0x000055ff5edd12ee in do_command (thd=0x7f40f401c930) at /home/travis/src/sql/sql_parse.cc:1365
|
#23 0x000055ff5ef498ff in do_handle_one_connection (connect=0x55ff628eefb0) at /home/travis/src/sql/sql_connect.cc:1398
|
#24 0x000055ff5ef4963d in handle_one_connection (arg=0x55ff628eefb0) at /home/travis/src/sql/sql_connect.cc:1301
|
#25 0x00007f415bb166ba in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
|
#26 0x00007f415ada741d in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
#7 0x00007f669d46bc82 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
|
#8 0x000055d8043f5ad5 in Field_enum::val_int (this=0x7f6658124cc0) at /home/travis/src/sql/field.cc:9206
|
#9 0x000055d8043f5b76 in Field_enum::val_str (this=0x7f6658124cc0, val_buffer=0x7f6685cebcd0, val_ptr=0x7f6685cebcd0) at /home/travis/src/sql/field.cc:9233
|
#10 0x000055d803fc1e6d in Field::val_str (this=0x7f6658124cc0, str=0x7f6685cebcd0) at /home/travis/src/sql/field.h:838
|
#11 0x000055d8043fd9b6 in Field::save_in_field_str (this=0x7f6658124cc0, to=0x7f6658099cf8) at /home/travis/src/sql/field.h:608
|
#12 0x000055d804403196 in Field_enum::save_in_field (this=0x7f6658124cc0, to=0x7f6658099cf8) at /home/travis/src/sql/field.h:4212
|
#13 0x000055d8044032c6 in Field_set::store_field (this=0x7f6658099cf8, from=0x7f6658124cc0) at /home/travis/src/sql/field.h:4281
|
#14 0x000055d804407acd in field_conv_incompatible (to=0x7f6658099cf8, from=0x7f6658124cc0) at /home/travis/src/sql/field_conv.cc:851
|
#15 0x000055d804407b29 in field_conv (to=0x7f6658099cf8, from=0x7f6658124cc0) at /home/travis/src/sql/field_conv.cc:864
|
#16 0x000055d80443fb7b in save_field_in_field (from=0x7f6658124cc0, null_value=0x7f665810ddf6, to=0x7f6658099cf8, no_conversions=false) at /home/travis/src/sql/item.cc:6338
|
#17 0x000055d80443fdbc in Item_field::save_in_field (this=0x7f665810dd80, to=0x7f6658099cf8, no_conversions=false) at /home/travis/src/sql/item.cc:6389
|
#18 0x000055d804209375 in TABLE::update_virtual_fields (this=0x7f6658132320, h=0x7f66581296b8, update_mode=VCOL_UPDATE_FOR_WRITE) at /home/travis/src/sql/table.cc:8198
|
#19 0x000055d80404cd06 in fill_record (thd=0x7f6634001320, table_arg=0x7f6658132320, fields=..., values=..., ignore_errors=false, update=false) at /home/travis/src/sql/sql_base.cc:8469
|
#20 0x000055d80404d182 in fill_record_n_invoke_before_triggers (thd=0x7f6634001320, table=0x7f6658132320, fields=..., values=..., ignore_errors=false, event=TRG_EVENT_INSERT) at /home/travis/src/sql/sql_base.cc:8597
|
#21 0x000055d804093f85 in mysql_insert (thd=0x7f6634001320, table_list=0x7f6634014b88, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=true) at /home/travis/src/sql/sql_insert.cc:964
|
#22 0x000055d8040df5e8 in mysql_execute_command (thd=0x7f6634001320) at /home/travis/src/sql/sql_parse.cc:4790
|
#23 0x000055d8040eb4ba in mysql_parse (thd=0x7f6634001320, rawbuf=0x7f66340149f8 "INSERT IGNORE INTO `view_t9` ( `col_bit`, `col_varchar` ) VALUES ( NULL, 'x' ) /* QNO 1575 CON_ID 15 */", length=103, parser_state=0x7f6685ced1d0, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:8154
|
#24 0x000055d8040d6b5a in dispatch_command (command=COM_QUERY, thd=0x7f6634001320, packet=0x7f663400afc1 "INSERT IGNORE INTO `view_t9` ( `col_bit`, `col_varchar` ) VALUES ( NULL, 'x' ) /* QNO 1575 CON_ID 15 */ ", packet_length=104, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:1832
|
#25 0x000055d8040d52ee in do_command (thd=0x7f6634001320) at /home/travis/src/sql/sql_parse.cc:1365
|
#26 0x000055d80424d8ff in do_handle_one_connection (connect=0x55d8076f5740) at /home/travis/src/sql/sql_connect.cc:1398
|
#27 0x000055d80424d63d in handle_one_connection (arg=0x55d8076f5740) at /home/travis/src/sql/sql_connect.cc:1301
|
#28 0x00007f669e2b46ba in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
|
#29 0x00007f669d54541d in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
#7 0x00007f2b07488c82 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
|
#8 0x00005618dbe6594e in Field_blob_compressed::val_str (this=0x7f2abc095890, val_buffer=0x7f2abc058358, val_ptr=0x7f2abc058358) at /home/travis/src/sql/field.cc:8806
|
#9 0x00005618dba32e6d in Field::val_str (this=0x7f2abc095890, str=0x7f2abc058358) at /home/travis/src/sql/field.h:838
|
#10 0x00005618dbe737ff in Field_blob::store_field (this=0x7f2abc058268, from=0x7f2abc095890) at /home/travis/src/sql/field.h:3886
|
#11 0x00005618dbe78acd in field_conv_incompatible (to=0x7f2abc058268, from=0x7f2abc095890) at /home/travis/src/sql/field_conv.cc:851
|
#12 0x00005618dbe78b29 in field_conv (to=0x7f2abc058268, from=0x7f2abc095890) at /home/travis/src/sql/field_conv.cc:864
|
#13 0x00005618dbeb0b7b in save_field_in_field (from=0x7f2abc095890, null_value=0x7f2abc06dd76, to=0x7f2abc058268, no_conversions=false) at /home/travis/src/sql/item.cc:6338
|
#14 0x00005618dbeb0dbc in Item_field::save_in_field (this=0x7f2abc06dd00, to=0x7f2abc058268, no_conversions=false) at /home/travis/src/sql/item.cc:6389
|
#15 0x00005618dbc7a375 in TABLE::update_virtual_fields (this=0x7f2abc06c370, h=0x7f2abc094fe8, update_mode=VCOL_UPDATE_FOR_READ) at /home/travis/src/sql/table.cc:8198
|
#16 0x00005618dbe8b60b in handler::ha_rnd_pos (this=0x7f2abc094fe8, buf=0x7f2abc05bd58 "@\001\372.T\241\f", pos=0x7f2abc094080 "\026") at /home/travis/src/sql/handler.cc:3024
|
#17 0x00005618dc01e80e in rr_from_pointers (info=0x7f2af1c46e60) at /home/travis/src/sql/records.cc:547
|
#18 0x00005618dbaa2c65 in READ_RECORD::read_record (this=0x7f2af1c46e60) at /home/travis/src/sql/records.h:73
|
#19 0x00005618dc03c6b8 in mysql_delete (thd=0x7f2abc00bbb0, table_list=0x7f2abc021178, conds=0x7f2abc021ce8, order_list=0x7f2abc010550, limit=2, options=4194304, result=0x0) at /home/travis/src/sql/sql_delete.cc:804
|
#20 0x00005618dbb513f3 in mysql_execute_command (thd=0x7f2abc00bbb0) at /home/travis/src/sql/sql_parse.cc:4982
|
#21 0x00005618dbb5c4ba in mysql_parse (thd=0x7f2abc00bbb0, rawbuf=0x7f2abc020dd8 "DELETE LOW_PRIORITY QUICK IGNORE FROM `view_t4` WHERE `vcol_bit` IN ( 183, 2, 226, 2395078656, 3966763008 ) ORDER BY `col_bit`,`col_date`,`col_datetime`,`col_dec`,`col_enum`,`col_int`,`col_time`,`col_"..., length=366, parser_state=0x7f2af1c481d0, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:8154
|
#22 0x00005618dbb47b5a in dispatch_command (command=COM_QUERY, thd=0x7f2abc00bbb0, packet=0x7f2abc0180a1 "DELETE LOW_PRIORITY QUICK IGNORE FROM `view_t4` WHERE `vcol_bit` IN ( 183, 2, 226, 2395078656, 3966763008 ) ORDER BY `col_bit`,`col_date`,`col_datetime`,`col_dec`,`col_enum`,`col_int`,`col_time`,`col_"..., packet_length=367, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:1832
|
#23 0x00005618dbb462ee in do_command (thd=0x7f2abc00bbb0) at /home/travis/src/sql/sql_parse.cc:1365
|
#24 0x00005618dbcbe8ff in do_handle_one_connection (connect=0x5618dfdfa020) at /home/travis/src/sql/sql_connect.cc:1398
|
#25 0x00005618dbcbe63d in handle_one_connection (arg=0x5618dfdfa020) at /home/travis/src/sql/sql_connect.cc:1301
|
#26 0x00007f2b082d16ba in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
|
#27 0x00007f2b0756241d in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
|
|
mysqld: /10.4/sql/field.cc:9830: virtual longlong Field_bit::val_int(): Assertion `marked_for_read()' failed.
|
|
linux/raise.c:54(__GI_raise)[0x7fc93fe6502a]
|
stdlib/abort.c:91(__GI_abort)[0x7fc93fe5bbd7]
|
assert/assert.c:92(__assert_fail_base)[0x7fc93fe5bc82]
|
sql/field.cc:9831(Field_bit::val_int())[0x5562aa7e4f4c]
|
sql/field.h:4343(Field_bit::save_in_field(Field*))[0x5562aa7d962f]
|
sql/field.h:774(Field::store_field(Field*))[0x5562aa7f0dee]
|
sql/field_conv.cc:852(field_conv_incompatible(Field*, Field*))[0x5562aa7f0e8b]
|
sql/field_conv.cc:865(field_conv(Field*, Field*))[0x5562aa8783db]
|
sql/item.cc:6338(save_field_in_field(Field*, bool*, Field*, bool))[0x5562aa878a37]
|
sql/item.cc:6390(Item_field::save_in_field(Field*, bool))[0x5562aa3a1339]
|
sql/table.cc:8198(TABLE::update_virtual_fields(handler*, enum_vcol_update_mode))[0x5562aa81a4a2]
|
sql/handler.cc:2999(handler::ha_rnd_next(unsigned char*))[0x5562aabce7ef]
|
sql/records.cc:481(rr_sequential(READ_RECORD*))[0x5562a9f50e20]
|
sql/records.h:73(READ_RECORD::read_record())[0x5562aa1ef5ee]
|
sql/sql_select.cc:20985(join_init_read_record(st_join_table*))[0x5562aa1edc37]
|
sql/sql_select.cc:20040(sub_select(JOIN*, st_join_table*, bool))[0x5562aa189692]
|
sql/sql_select.cc:19581(do_select(JOIN*, Procedure*))[0x5562aa187010]
|
sql/sql_select.cc:4388(JOIN::exec_inner())[0x5562aa18aa4a]
|
sql/sql_select.cc:4171(JOIN::exec())[0x5562aa16190c]
|
sql/sql_select.cc:4604(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*))[0x5562aa0e6e41]
|
sql/sql_select.cc:424(handle_select(THD*, LEX*, select_result*, unsigned long))[0x5562aa0d405e]
|
sql/sql_parse.cc:6602(execute_sqlcom_select(THD*, TABLE_LIST*))[0x5562aa0ef102]
|
sql/sql_parse.cc:3891(mysql_execute_command(THD*))[0x5562aa0c7db2]
|
sql/sql_parse.cc:8154(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x5562aa0c4cf1]
|
sql/sql_parse.cc:1834(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5562aa4387ab]
|
sql/sql_parse.cc:1365(do_command(THD*))[0x5562aa438175]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7fc940ca46ba]
|
x86_64/clone.S:111(clone)[0x7fc93ff3541d]
|
|
|
I add the testcase from MDEV-18249, just to be checked that the patch also fixes it:
create table t1 (c varchar(3), v varchar(4) as (c) virtual) engine=myisam;
|
insert into t1 (c) values ('a'),('b');
|
analyze table t1 persistent for columns (v) indexes ();
|
drop table t1;
|
10.4-10.5, fails with myisam/aria
|
10.5 aa4f76bed715ec1016
|
mariadbd: /10.5/sql/field.cc:7826: virtual String* Field_varstring::val_str(String*, String*): Assertion `marked_for_read()' failed.
|
210305 11:06:00 [ERROR] mysqld got signal 6 ;
|
|
Server version: 10.5.10-MariaDB-debug-log
|
|
:0(__GI___assert_fail)[0x7ff80371ef36]
|
sql/field.cc:7827(Field_varstring::val_str(String*, String*))[0x55850458ec68]
|
sql/field.h:1026(Field::val_str(String*))[0x558503c26df0]
|
sql/field.h:746(Field::save_in_field_str(Field*))[0x5585041d4802]
|
sql/field.h:2092(Field_str::save_in_field(Field*))[0x5585041d7e3f]
|
sql/field.h:907(Field::store_field(Field*))[0x5585041d4e7b]
|
sql/field_conv.cc:851(field_conv_incompatible(Field*, Field*))[0x5585045c5bc2]
|
sql/field_conv.cc:864(field_conv(Field*, Field*))[0x5585045c5c63]
|
sql/item.cc:6511(save_field_in_field(Field*, bool*, Field*, bool))[0x558504672481]
|
sql/item.cc:6563(Item_field::save_in_field(Field*, bool))[0x558504672c51]
|
sql/table.cc:8619(TABLE::update_virtual_fields(handler*, enum_vcol_update_mode))[0x55850415cb96]
|
sql/handler.cc:3084(handler::ha_rnd_next(unsigned char*))[0x5585045fd6cd]
|
sql/sql_statistics.cc:2666(collect_statistics_for_table(THD*, TABLE*))[0x55850402e982]
|
sql/sql_admin.cc:956(mysql_admin_table(THD*, TABLE_LIST*, st_ha_check_opt*, char const*, thr_lock_type, bool, bool, unsigned int, int (*)(THD*, TABLE_LIST*, st_ha_check_opt*), int (handler::*)(THD*, st_ha_check_opt*), int (*)(THD*, TABLE_LIST*, st_ha_check_opt*)))[0x5585042562a1]
|
sql/sql_admin.cc:1389(Sql_cmd_analyze_table::execute(THD*))[0x558504259a63]
|
sql/sql_parse.cc:6024(mysql_execute_command(THD*))[0x558503df8875]
|
sql/sql_parse.cc:8063(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x558503e0631e]
|
sql/sql_parse.cc:1892(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x558503ddc517]
|
sql/sql_parse.cc:1370(do_command(THD*))[0x558503dd8e40]
|
sql/sql_connect.cc:1410(do_handle_one_connection(CONNECT*, bool))[0x55850421b6dc]
|
sql/sql_connect.cc:1314(handle_one_connection)[0x55850421b040]
|
perfschema/pfs.cc:2203(pfs_spawn_thread)[0x558504f273d5]
|
nptl/pthread_create.c:478(start_thread)[0x7ff803c36609]
|
x86_64/clone.S:97(__GI___clone)[0x7ff80380a293]
|
|
Query (0x62b0000a12a8): analyze table t1 persistent for columns (v) indexes ()
|
|