[MDEV-19306] Assertion `marked_for_read()' failed in Field_blob::val_str with virtual columns and views Created: 2019-04-22  Updated: 2021-06-25  Resolved: 2021-06-25

Status: Closed
Project: MariaDB Server
Component/s: Data types, Views, Virtual Columns
Affects Version/s: 10.4, 10.5, 10.6
Fix Version/s: 10.2.40, 10.3.31, 10.4.21, 10.5.12, 10.6.3

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Nikita Malyavin
Resolution: Duplicate Votes: 0
Labels: bitmaps

Issue Links:
Duplicate
duplicates MDEV-18166 ASSERT_COLUMN_MARKED_FOR_READ failed ... Closed
Relates
relates to MDEV-17356 Assertion `!table || !table->read_set... Closed
relates to MDEV-19361 Assertion `marked_for_read()' failed ... Closed
relates to MDEV-19674 Assertion `marked_for_read()' failed ... Confirmed
relates to MDEV-23597 Assertion `marked_for_read()' failed ... Closed

 Description   

Note: Assertion failure is the same as in recently fixed MDEV-19224, but everything else is different, so I'm filing it separately.

CREATE TABLE t1 (a BLOB, b TEXT AS (a) VIRTUAL);
CREATE VIEW v1 AS SELECT * FROM t1;
INSERT INTO t1 (a) VALUES ('foo'),('bar');
DELETE FROM v1 ORDER BY b LIMIT 2;
 
# Cleanup
DROP VIEW v1;
DROP TABLE t1;

10.4 a65d3b2c

mysqld: /data/src/10.4/sql/field.cc:8380: virtual String* Field_blob::val_str(String*, String*): Assertion `marked_for_read()' failed.
190423  2:34:49 [ERROR] mysqld got signal 6 ;
 
#7  0x00007fcfef332ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
#8  0x000056071a663934 in Field_blob::val_str (this=0x7fcfd8136458, val_buffer=0x7fcfd8136678, val_ptr=0x7fcfd8136678) at /data/src/10.4/sql/field.cc:8380
#9  0x000056071a233cef in Field::val_str (this=0x7fcfd8136458, str=0x7fcfd8136678) at /data/src/10.4/sql/field.h:838
#10 0x000056071a672b57 in Field_blob::store_field (this=0x7fcfd8136588, from=0x7fcfd8136458) at /data/src/10.4/sql/field.h:3886
#11 0x000056071a677dee in field_conv_incompatible (to=0x7fcfd8136588, from=0x7fcfd8136458) at /data/src/10.4/sql/field_conv.cc:851
#12 0x000056071a677e4a in field_conv (to=0x7fcfd8136588, from=0x7fcfd8136458) at /data/src/10.4/sql/field_conv.cc:864
#13 0x000056071a6afdc0 in save_field_in_field (from=0x7fcfd8136458, null_value=0x7fcfd813ce0e, to=0x7fcfd8136588, no_conversions=false) at /data/src/10.4/sql/item.cc:6338
#14 0x000056071a6b0002 in Item_field::save_in_field (this=0x7fcfd813cd98, to=0x7fcfd8136588, no_conversions=false) at /data/src/10.4/sql/item.cc:6389
#15 0x000056071a47ac7c in TABLE::update_virtual_fields (this=0x7fcfd813b790, h=0x7fcfd813c5f8, update_mode=VCOL_UPDATE_FOR_READ) at /data/src/10.4/sql/table.cc:8198
#16 0x000056071a68a8db in handler::ha_rnd_pos (this=0x7fcfd813c5f8, buf=0x7fcfd8136410 "\374\003", pos=0x7fcfd8084150 "") at /data/src/10.4/sql/handler.cc:3024
#17 0x000056071a81dff8 in rr_from_pointers (info=0x7fcfe94aae10) at /data/src/10.4/sql/records.cc:547
#18 0x000056071a2a380b in READ_RECORD::read_record (this=0x7fcfe94aae10) at /data/src/10.4/sql/records.h:73
#19 0x000056071a83c359 in mysql_delete (thd=0x7fcfd8000b00, table_list=0x7fcfd80156d8, conds=0x0, order_list=0x7fcfd80054a0, limit=2, options=0, result=0x0) at /data/src/10.4/sql/sql_delete.cc:804
#20 0x000056071a351cc6 in mysql_execute_command (thd=0x7fcfd8000b00) at /data/src/10.4/sql/sql_parse.cc:4985
#21 0x000056071a35ca13 in mysql_parse (thd=0x7fcfd8000b00, rawbuf=0x7fcfd80155e8 "DELETE FROM v1 ORDER BY b LIMIT 2", length=33, parser_state=0x7fcfe94ac180, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:8154
#22 0x000056071a34846a in dispatch_command (command=COM_QUERY, thd=0x7fcfd8000b00, packet=0x7fcfd800a8a1 "DELETE FROM v1 ORDER BY b LIMIT 2", packet_length=33, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1832
#23 0x000056071a346c50 in do_command (thd=0x7fcfd8000b00) at /data/src/10.4/sql/sql_parse.cc:1365
#24 0x000056071a4bf033 in do_handle_one_connection (connect=0x56071cec85b0) at /data/src/10.4/sql/sql_connect.cc:1398
#25 0x000056071a4beda4 in handle_one_connection (arg=0x56071cec85b0) at /data/src/10.4/sql/sql_connect.cc:1301
#26 0x000056071a8e32f5 in pfs_spawn_thread (arg=0x56071cfba980) at /data/src/10.4/storage/perfschema/pfs.cc:1862
#27 0x00007fcff1427494 in start_thread (arg=0x7fcfe94ad700) at pthread_create.c:333
#28 0x00007fcfef3ef93f in clone () from /lib/x86_64-linux-gnu/libc.so.6



 Comments   
Comment by Elena Stepanova [ 2019-04-22 ]

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

Comment by Alice Sherepa [ 2019-04-24 ]

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]

Comment by Alice Sherepa [ 2021-03-05 ]

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

Comment by Alice Sherepa [ 2021-03-17 ]

some variation:

10.5 031b3dfc22c3d37769d49

 /git/10.5/sql/field.cc:4405: virtual longlong Field_long::val_int(): Assertion `marked_for_read()' failed.
210317 11:36:55 [ERROR] mysqld got signal 6 ;
 
Server version: 10.5.10-MariaDB-debug-log
 
sigaction.c:0(__restore_rt)[0x7fe7849193c0]
linux/raise.c:51(__GI_raise)[0x7fe78440518b]
stdlib/abort.c:81(__GI_abort)[0x7fe7843e4859]
intl/loadmsgcat.c:509(get_sysdep_segment_value)[0x7fe7843e4729]
:0(__GI___assert_fail)[0x7fe7843f5f36]
sql/field.cc:4408(Field_long::val_int())[0x55a0ec9b1c9c]
sql/item.cc:3263(Item_field::val_int())[0x55a0eca9f4fe]
sql/item_func.cc:1357(Item_func_mul::int_op())[0x55a0ecb8f372]
sql/item_func.h:859(Item_func_hybrid_field_type::val_int_from_int_op())[0x55a0ec818cc4]
sql/sql_type.cc:5322(Type_handler_int_result::Item_func_hybrid_field_type_val_int(Item_func_hybrid_field_type*) const)[0x55a0ec7e9be8]
sql/item_func.h:915(Item_func_hybrid_field_type::val_int())[0x55a0ec1f377d]
sql/item.cc:6655(Item::save_int_in_field(Field*, bool))[0x55a0ecabb339]
sql/sql_type.cc:4268(Type_handler_int_result::Item_save_in_field(Item*, Field*, bool) const)[0x55a0ec7e4526]
sql/item.cc:6665(Item::save_in_field(Field*, bool))[0x55a0ecabb51f]
sql/table.cc:8619(TABLE::update_virtual_fields(handler*, enum_vcol_update_mode))[0x55a0ec5a471a]
sql/handler.cc:3084(handler::ha_rnd_next(unsigned char*))[0x55a0eca45549]
sql/records.cc:519(rr_sequential(READ_RECORD*))[0x55a0ecea2356]
sql/records.h:80(READ_RECORD::read_record())[0x55a0ec07086c]
sql/sql_update.cc:996(mysql_update(THD*, TABLE_LIST*, List<Item>&, List<Item>&, Item*, unsigned int, st_order*, unsigned long long, bool, unsigned long long*, unsigned long long*))[0x55a0ec535e79]
sql/sql_parse.cc:4466(mysql_execute_command(THD*))[0x55a0ec23423e]
sql/sql_parse.cc:8089(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55a0ec24d4d8]
sql/sql_parse.cc:1892(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55a0ec22376b]
sql/sql_parse.cc:1370(do_command(THD*))[0x55a0ec220094]
sql/sql_connect.cc:1410(do_handle_one_connection(CONNECT*, bool))[0x55a0ec663260]
sql/sql_connect.cc:1314(handle_one_connection)[0x55a0ec662bc4]
perfschema/pfs.cc:2203(pfs_spawn_thread)[0x55a0ed36fb4d]
nptl/pthread_create.c:478(start_thread)[0x7fe78490d609]
x86_64/clone.S:97(__GI___clone)[0x7fe7844e1293]

Comment by Nikita Malyavin [ 2021-06-25 ]

the latter test case from MDEV-18249 is not a duplicate

Generated at Thu Feb 08 08:50:39 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.