[MDEV-25603] Assertion `templ->mysql_col_len == len' failed in row_sel_field_store_in_mysql_format_func - Jira

Details

Type: Bug
Status: Confirmed (View Workflow)
Priority: Major
Resolution: Unresolved
Affects Version/s: 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11
Fix Version/s: 10.5, 10.6, 10.11
Component/s: None
Labels:
- not-11.0+

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

relates to

MDEV-18911 Assertion `(templ->is_virtual && !field) || (field && field->prefix_len ? field->prefix_len == len : templ->mysql_col_len == len)' failed row_sel_field_store_in_mysql_format_func

Closed

MDEV-20940 Data corruption after partition maintenance for table using legacy DATETIME storage.

Confirmed

Activity

Ascending order - Click to sort in descending order

Alice Sherepa created issue - 2021-05-05 13:09

Alice Sherepa made changes - 2021-05-05 13:11

Field	Original Value	New Value
Link		This issue relates to ~~MDEV-18911~~ [ ~~MDEV-18911~~ ]

Alice Sherepa made changes - 2021-05-05 13:12

Assignee

Nikita Malyavin [ nikitamalyavin ]

Alice Sherepa made changes - 2021-05-05 13:13

Link

This issue relates to MDEV-20940 [ MDEV-20940 ]

Alice Sherepa made changes - 2021-07-29 08:52

Affects Version/s

10.6 [ 24028 ]

Alice Sherepa made changes - 2021-07-29 08:53

Fix Version/s

10.6 [ 24028 ]

Alice Sherepa made changes - 2021-07-29 08:53

Status

Open [ 1 ]

Confirmed [ 10101 ]

Sergei Golubchik made changes - 2021-12-06 21:36

Workflow

MariaDB v3 [ 121630 ]

MariaDB v4 [ 144359 ]

Alice Sherepa made changes - 2022-01-24 12:35

Affects Version/s

10.7 [ 24805 ]

Alice Sherepa made changes - 2022-01-24 12:36

Fix Version/s

10.7 [ 24805 ]

Elena Stepanova added a comment - 2022-05-28 22:21

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

Elena Stepanova added a comment - 2022-05-28 22:21 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 Sherepa made changes - 2022-10-21 15:39

Affects Version/s		10.8 [ 26121 ]
Affects Version/s		10.9 [ 26905 ]
Affects Version/s		10.10 [ 27530 ]

Alice Sherepa made changes - 2022-10-21 15:39

Fix Version/s		10.8 [ 26121 ]
Fix Version/s		10.9 [ 26905 ]

Julien Fritsch made changes - 2023-03-03 17:31

Fix Version/s

10.7 [ 24805 ]

Julien Fritsch made changes - 2023-04-27 14:51

Fix Version/s

10.8 [ 26121 ]

Julien Fritsch made changes - 2023-11-28 10:39

Fix Version/s

10.9 [ 26905 ]

Alice Sherepa made changes - 2024-03-06 17:10

Fix Version/s

10.11 [ 27614 ]

Alice Sherepa made changes - 2024-03-06 17:10

Affects Version/s

10.11 [ 27614 ]

Alice Sherepa made changes - 2024-03-06 17:10

Labels

not-11.0+

Alice Sherepa made changes - 2024-03-06 17:10

Comment

[ Currently works as expected on 10.4 (113bef50e33a838c5cb63) -10.11,11.0. But repeatable on bb-11.0-oalter e599b8b45867cd24720a, so probably fixed recently (I was not searching the exact commit) ]

Alice Sherepa added a comment - 2024-03-06 17:12

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 Sherepa added a comment - 2024-03-06 17:12 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

Assignee:: Nikita Malyavin

Reporter:: Alice Sherepa

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2021-05-05 13:09

Updated:: 2024-03-06 17:12

Git Integration

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

MariaDB Server

Details

Description

Attachments

Issue Links

Activity

People

Dates

Git Integration