Assertion failures in btr0cur.cc upon INSERT or in row0sel.cc afterwards

mysqld: /data/src/10.2/storage/innobase/btr/btr0cur.cc:6862: dberr_t btr_store_big_rec_extern_fields(btr_pcur_t*, rec_offs*, const big_rec_t*, mtr_t*, blob_op): Assertion `rec_offs_any_extern(offsets)' failed.

220416  3:14:12 [ERROR] mysqld got signal 6 ;

#7  0x00007f8912ed3662 in __GI___assert_fail (assertion=0x55cf255fef8c "rec_offs_any_extern(offsets)", file=0x55cf255fbae0 "/data/src/10.2/storage/innobase/btr/btr0cur.cc", line=6862, function=0x55cf255ff2f0 "dberr_t btr_store_big_rec_extern_fields(btr_pcur_t*, rec_offs*, const big_rec_t*, mtr_t*, blob_op)") at assert.c:101

#8  0x000055cf25078590 in btr_store_big_rec_extern_fields (pcur=0x7f890d3372d0, offsets=0x7f890d337a80, big_rec_vec=0x7f88b83e01c0, btr_mtr=0x7f890d3373d0, op=BTR_STORE_INSERT) at /data/src/10.2/storage/innobase/btr/btr0cur.cc:6862

#9  0x000055cf24f59c1c in row_ins_index_entry_big_rec (entry=0x7f88b80ab8b0, big_rec=0x7f88b83e01c0, offsets=0x7f890d337a80, heap=0x7f890d337918, index=0x7f88b803a2b0, thd=0x7f88b8000d90) at /data/src/10.2/storage/innobase/row/row0ins.cc:2505

#10 0x000055cf24f5a6c6 in row_ins_clust_index_entry_low (flags=0, mode=2, index=0x7f88b803a2b0, n_uniq=2, entry=0x7f88b80ab8b0, n_ext=0, thr=0x7f88b809ef88) at /data/src/10.2/storage/innobase/row/row0ins.cc:2727

#11 0x000055cf24f5b96c in row_ins_clust_index_entry (index=0x7f88b803a2b0, entry=0x7f88b80ab8b0, thr=0x7f88b809ef88, n_ext=0) at /data/src/10.2/storage/innobase/row/row0ins.cc:3140

#12 0x000055cf24f5bd7e in row_ins_index_entry (index=0x7f88b803a2b0, entry=0x7f88b80ab8b0, thr=0x7f88b809ef88) at /data/src/10.2/storage/innobase/row/row0ins.cc:3259

#13 0x000055cf24f5c2a0 in row_ins_index_entry_step (node=0x7f88b8066930, thr=0x7f88b809ef88) at /data/src/10.2/storage/innobase/row/row0ins.cc:3410

#14 0x000055cf24f5c672 in row_ins (node=0x7f88b8066930, thr=0x7f88b809ef88) at /data/src/10.2/storage/innobase/row/row0ins.cc:3547

#15 0x000055cf24f5ca3b in row_ins_step (thr=0x7f88b809ef88) at /data/src/10.2/storage/innobase/row/row0ins.cc:3671

#16 0x000055cf24f7a78c in row_insert_for_mysql (mysql_rec=0x7f88b8035228 "\320R\003", prebuilt=0x7f88b80662d0) at /data/src/10.2/storage/innobase/row/row0mysql.cc:1408

#17 0x000055cf24e3f9d1 in ha_innobase::write_row (this=0x7f88b8034a98, record=0x7f88b8035228 "\320R\003") at /data/src/10.2/storage/innobase/handler/ha_innodb.cc:8285

#18 0x000055cf24c4cae3 in handler::ha_write_row (this=0x7f88b8034a98, buf=0x7f88b8035228 "\320R\003") at /data/src/10.2/sql/handler.cc:6113

#19 0x000055cf2499ec8c in write_record (thd=0x7f88b8000d90, table=0x7f88b80acdc0, info=0x7f890d338930) at /data/src/10.2/sql/sql_insert.cc:1951

#20 0x000055cf2499c6f3 in mysql_insert (thd=0x7f88b8000d90, table_list=0x7f88b8012750, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=true) at /data/src/10.2/sql/sql_insert.cc:1066

#21 0x000055cf249c33a0 in mysql_execute_command (thd=0x7f88b8000d90) at /data/src/10.2/sql/sql_parse.cc:4217

#22 0x000055cf249ce7e2 in mysql_parse (thd=0x7f88b8000d90, rawbuf=0x7f88b8241398 "INSERT IGNORE INTO t VALUES\n(NULL,'tsls','ce License窶? is a trademark of MariaDB Corporation Ab.\\n\\nParameters\\n\\nLicensor:", ' ' <repeats 13 times>, "MariaDB Corporation Ab\\nLicensed Work:        MariaDB MaxScale"..., length=709363, parser_state=0x7f890d3395e0, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7793

#23 0x000055cf249bcb85 in dispatch_command (command=COM_QUERY, thd=0x7f88b8000d90, packet=0x7f88b81932f1 "INSERT IGNORE INTO t VALUES\n(NULL,'tsls','ce License窶? is a trademark of MariaDB Corporation Ab.\\n\\nParameters\\n\\nLicensor:", ' ' <repeats 13 times>, "MariaDB Corporation Ab\\nLicensed Work:        MariaDB MaxScale"..., packet_length=709363, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1827

#24 0x000055cf249bb69e in do_command (thd=0x7f88b8000d90) at /data/src/10.2/sql/sql_parse.cc:1381

#25 0x000055cf24b134be in do_handle_one_connection (connect=0x55cf28a3bde0) at /data/src/10.2/sql/sql_connect.cc:1336

#26 0x000055cf24b13232 in handle_one_connection (arg=0x55cf28a3bde0) at /data/src/10.2/sql/sql_connect.cc:1241

#27 0x000055cf2531b75b in pfs_spawn_thread (arg=0x55cf28a25ee0) at /data/src/10.2/storage/perfschema/pfs.cc:1869

#28 0x00007f8913397ea7 in start_thread (arg=<optimized out>) at pthread_create.c:477

#29 0x00007f8912f9cdef in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

2022-04-16 03:27:20 0x7feb98777700  InnoDB: Assertion failure in file /data/src/10.2/storage/innobase/btr/btr0cur.cc line 6477

InnoDB: Failing assertion: rec_offs_nth_extern(offsets, n)

#6  0x000055cdaa28da11 in ut_dbg_assertion_failed (expr=expr@entry=0x55cdaabd0038 "rec_offs_nth_extern(offsets, n)", file=file@entry=0x55cdaabd0008 "/data/src/10.2/storage/innobase/btr/btr0cur.cc", line=line@entry=6477) at /data/src/10.2/storage/innobase/ut/ut0dbg.cc:60

#7  0x000055cdaa2904bc in btr_rec_get_field_ref_offs (offsets=<optimized out>, n=<optimized out>) at /data/src/10.2/storage/innobase/btr/btr0cur.cc:6477

#8  btr_rec_get_field_ref_offs (offsets=<optimized out>, n=<optimized out>) at /data/src/10.2/storage/innobase/btr/btr0cur.cc:6469

#9  0x000055cdaa80dd39 in btr_store_big_rec_extern_fields (pcur=pcur@entry=0x7feb987738e0, offsets=offsets@entry=0x7feb98773680, big_rec_vec=big_rec_vec@entry=0x7feb44377868, btr_mtr=btr_mtr@entry=0x7feb98774160, op=op@entry=BTR_STORE_INSERT) at /data/src/10.2/storage/innobase/btr/btr0cur.cc:6934

#10 0x000055cdaa764723 in row_ins_index_entry_big_rec (thd=<optimized out>, index=0x7feb4402f708, heap=0x7feb98773558, offsets=0x7feb98773680, big_rec=<optimized out>, entry=<optimized out>) at /data/src/10.2/storage/innobase/row/row0ins.cc:2505

#11 row_ins_clust_index_entry_low (flags=<optimized out>, mode=<optimized out>, index=0x7feb4402f708, n_uniq=<optimized out>, entry=<optimized out>, n_ext=<optimized out>, thr=<optimized out>) at /data/src/10.2/storage/innobase/row/row0ins.cc:2727

#12 0x000055cdaa765ac1 in row_ins_clust_index_entry (index=index@entry=0x7feb4402f708, entry=entry@entry=0x7feb440ae8b8, thr=thr@entry=0x7feb4402c010, n_ext=n_ext@entry=0) at /data/src/10.2/storage/innobase/row/row0ins.cc:3140

#13 0x000055cdaa765e38 in row_ins_index_entry (thr=0x7feb4402c010, entry=<optimized out>, index=<optimized out>) at /data/src/10.2/storage/innobase/row/row0ins.cc:3259

#14 row_ins_index_entry_step (thr=0x7feb4402c010, node=<optimized out>) at /data/src/10.2/storage/innobase/row/row0ins.cc:3410

#15 row_ins (thr=<optimized out>, node=<optimized out>) at /data/src/10.2/storage/innobase/row/row0ins.cc:3547

#16 row_ins_step (thr=thr@entry=0x7feb4402c010) at /data/src/10.2/storage/innobase/row/row0ins.cc:3671

#17 0x000055cdaa77631e in row_insert_for_mysql (mysql_rec=<optimized out>, prebuilt=0x7feb4409f668) at /data/src/10.2/storage/innobase/row/row0mysql.cc:1408

#18 0x000055cdaa6c7dbc in ha_innobase::write_row (this=0x7feb440a1ad0, record=0x7feb44175380 "\320R\003") at /data/src/10.2/storage/innobase/handler/ha_innodb.cc:8285

#19 0x000055cdaa527b62 in handler::ha_write_row (this=0x7feb440a1ad0, buf=0x7feb44175380 "\320R\003") at /data/src/10.2/sql/handler.cc:6113

#20 0x000055cdaa34d8c5 in write_record (thd=thd@entry=0x7feb44000c48, table=table@entry=0x7feb440ada68, info=info@entry=0x7feb98774c90) at /data/src/10.2/sql/sql_insert.cc:1951

#21 0x000055cdaa357460 in mysql_insert (thd=thd@entry=0x7feb44000c48, table_list=<optimized out>, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=<optimized out>) at /data/src/10.2/sql/sql_insert.cc:1066

#22 0x000055cdaa36d141 in mysql_execute_command (thd=<optimized out>) at /data/src/10.2/sql/sql_parse.cc:4217

#23 0x000055cdaa373a0b in mysql_parse (thd=thd@entry=0x7feb44000c48, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7feb987765a0, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.2/sql/sql_parse.cc:7793

#24 0x000055cdaa376bed in dispatch_command (command=COM_QUERY, thd=0x7feb44000c48, packet=<optimized out>, packet_length=<optimized out>, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /data/src/10.2/sql/sql_class.h:182

#25 0x000055cdaa377eb9 in do_command (thd=0x7feb44000c48) at /data/src/10.2/sql/sql_parse.cc:1381

#26 0x000055cdaa451a86 in do_handle_one_connection (connect=connect@entry=0x55cdacf3e1c8) at /data/src/10.2/sql/sql_connect.cc:1336

#27 0x000055cdaa451bfb in handle_one_connection (arg=arg@entry=0x55cdacf3e1c8) at /data/src/10.2/sql/sql_connect.cc:1241

#28 0x000055cdaa9de372 in pfs_spawn_thread (arg=0x55cdad241288) at /data/src/10.2/storage/perfschema/pfs.cc:1869

#29 0x00007feb9e7a5ea7 in start_thread (arg=<optimized out>) at pthread_create.c:477

#30 0x00007feb9e3c2def in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

2022-04-16 03:09:33 0x7f1c34542700  InnoDB: Assertion failure in file /data/src/10.2/storage/innobase/btr/btr0cur.cc line 6911

InnoDB: Failing assertion: op == BTR_STORE_UPDATE || (field_ref[BTR_EXTERN_LEN] & BTR_EXTERN_INHERITED_FLAG) || !memcmp(field_ref, field_ref_zero, BTR_EXTERN_FIELD_REF_SIZE)

#6  0x00005626e5e4a0c7 in ut_dbg_assertion_failed (expr=0x5626e6408540 "op == BTR_STORE_UPDATE || (field_ref[BTR_EXTERN_LEN] & BTR_EXTERN_INHERITED_FLAG) || !memcmp(field_ref, field_ref_zero, BTR_EXTERN_FIELD_REF_SIZE)", file=0x5626e6404ae0 "/data/src/10.2/storage/innobase/btr/btr0cur.cc", line=6911) at /data/src/10.2/storage/innobase/ut/ut0dbg.cc:60

#7  0x00005626e5e81a33 in btr_store_big_rec_extern_fields (pcur=0x7f1c3453f2d0, offsets=0x7f1c3453fa80, big_rec_vec=0x7f1bdc3e0300, btr_mtr=0x7f1c3453f3d0, op=BTR_STORE_INSERT) at /data/src/10.2/storage/innobase/btr/btr0cur.cc:6911

#8  0x00005626e5d62c1c in row_ins_index_entry_big_rec (entry=0x7f1bdc177110, big_rec=0x7f1bdc3e0300, offsets=0x7f1c3453fa80, heap=0x7f1c3453f918, index=0x7f1bdc0aa220, thd=0x7f1bdc000d90) at /data/src/10.2/storage/innobase/row/row0ins.cc:2505

#9  0x00005626e5d636c6 in row_ins_clust_index_entry_low (flags=0, mode=2, index=0x7f1bdc0aa220, n_uniq=2, entry=0x7f1bdc177110, n_ext=0, thr=0x7f1bdc09f408) at /data/src/10.2/storage/innobase/row/row0ins.cc:2727

#10 0x00005626e5d6496c in row_ins_clust_index_entry (index=0x7f1bdc0aa220, entry=0x7f1bdc177110, thr=0x7f1bdc09f408, n_ext=0) at /data/src/10.2/storage/innobase/row/row0ins.cc:3140

#11 0x00005626e5d64d7e in row_ins_index_entry (index=0x7f1bdc0aa220, entry=0x7f1bdc177110, thr=0x7f1bdc09f408) at /data/src/10.2/storage/innobase/row/row0ins.cc:3259

#12 0x00005626e5d652a0 in row_ins_index_entry_step (node=0x7f1bdc0388a0, thr=0x7f1bdc09f408) at /data/src/10.2/storage/innobase/row/row0ins.cc:3410

#13 0x00005626e5d65672 in row_ins (node=0x7f1bdc0388a0, thr=0x7f1bdc09f408) at /data/src/10.2/storage/innobase/row/row0ins.cc:3547

#14 0x00005626e5d65a3b in row_ins_step (thr=0x7f1bdc09f408) at /data/src/10.2/storage/innobase/row/row0ins.cc:3671

#15 0x00005626e5d8378c in row_insert_for_mysql (mysql_rec=0x7f1bdc034a98 "\320R\003", prebuilt=0x7f1bdc038240) at /data/src/10.2/storage/innobase/row/row0mysql.cc:1408

#16 0x00005626e5c489d1 in ha_innobase::write_row (this=0x7f1bdc08db38, record=0x7f1bdc034a98 "\320R\003") at /data/src/10.2/storage/innobase/handler/ha_innodb.cc:8285

#17 0x00005626e5a55ae3 in handler::ha_write_row (this=0x7f1bdc08db38, buf=0x7f1bdc034a98 "\320R\003") at /data/src/10.2/sql/handler.cc:6113

#18 0x00005626e57a7c8c in write_record (thd=0x7f1bdc000d90, table=0x7f1bdc1753a0, info=0x7f1c34540930) at /data/src/10.2/sql/sql_insert.cc:1951

#19 0x00005626e57a56f3 in mysql_insert (thd=0x7f1bdc000d90, table_list=0x7f1bdc012750, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=true) at /data/src/10.2/sql/sql_insert.cc:1066

#20 0x00005626e57cc3a0 in mysql_execute_command (thd=0x7f1bdc000d90) at /data/src/10.2/sql/sql_parse.cc:4217

#21 0x00005626e57d77e2 in mysql_parse (thd=0x7f1bdc000d90, rawbuf=0x7f1bdc2414d8 "INSERT IGNORE INTO t VALUES\n(NULL,'tsls','ce License窶? is a trademark of MariaDB Corporation Ab.\\n\\nParameters\\n\\nLicensor:", ' ' <repeats 13 times>, "MariaDB Corporation Ab\\nLicensed Work:        MariaDB MaxScale"..., length=709363, parser_state=0x7f1c345415e0, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7793

#22 0x00005626e57c5b85 in dispatch_command (command=COM_QUERY, thd=0x7f1bdc000d90, packet=0x7f1bdc193431 "INSERT IGNORE INTO t VALUES\n(NULL,'tsls','ce License窶? is a trademark of MariaDB Corporation Ab.\\n\\nParameters\\n\\nLicensor:", ' ' <repeats 13 times>, "MariaDB Corporation Ab\\nLicensed Work:        MariaDB MaxScale"..., packet_length=709363, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1827

#23 0x00005626e57c469e in do_command (thd=0x7f1bdc000d90) at /data/src/10.2/sql/sql_parse.cc:1381

#24 0x00005626e591c4be in do_handle_one_connection (connect=0x5626e9958d40) at /data/src/10.2/sql/sql_connect.cc:1336

#25 0x00005626e591c232 in handle_one_connection (arg=0x5626e9958d40) at /data/src/10.2/sql/sql_connect.cc:1241

#26 0x00005626e612475b in pfs_spawn_thread (arg=0x5626e9942e40) at /data/src/10.2/storage/perfschema/pfs.cc:1869

#27 0x00007f1c3a6b7ea7 in start_thread (arg=<optimized out>) at pthread_create.c:477

#28 0x00007f1c3a2bcdef in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

2022-04-16 03:16:52 0x7f3146428700  InnoDB: Assertion failure in file /data/src/10.2/storage/innobase/row/row0sel.cc line 3115

InnoDB: Failing assertion: prebuilt->trx->isolation_level == TRX_ISO_READ_UNCOMMITTED

#6  0x00005569e537aa11 in ut_dbg_assertion_failed (expr=expr@entry=0x5569e5cb0550 "prebuilt->trx->isolation_level == TRX_ISO_READ_UNCOMMITTED", file=file@entry=0x5569e5cb04b0 "/data/src/10.2/storage/innobase/row/row0sel.cc", line=line@entry=3115) at /data/src/10.2/storage/innobase/ut/ut0dbg.cc:60

#7  0x00005569e536ae44 in row_sel_store_mysql_field_func (templ=<optimized out>, field_no=<optimized out>, offsets=0x7ff289baec80, rec=0x7ff28a0cd8de "", prebuilt=0x7ff240176028, mysql_rec=0x7ff2400abca0 "\300R\003") at /data/src/10.2/storage/innobase/row/row0sel.cc:3115

#8  row_sel_store_mysql_rec (mysql_rec=0x7ff2400abca0 "\300R\003", prebuilt=0x7ff240176028, rec=<optimized out>, vrow=<optimized out>, rec_clust=<optimized out>, index=<optimized out>, offsets=<optimized out>) at /data/src/10.2/storage/innobase/row/row0sel.cc:3296

#9  0x00005569e587da58 in row_search_mvcc (buf=buf@entry=0x7ff2400abca0 "\300R\003", mode=<optimized out>, mode@entry=PAGE_CUR_UNSUPP, prebuilt=0x7ff240176028, match_mode=match_mode@entry=0, direction=direction@entry=1) at /data/src/10.2/storage/innobase/row/row0sel.cc:5672

#10 0x00005569e57ad25e in ha_innobase::general_fetch (this=0x7ff2400bf570, buf=0x7ff2400abca0 "\300R\003", direction=1, match_mode=0) at /data/src/10.2/storage/innobase/handler/ha_innodb.cc:9748

#11 0x00005569e560e441 in handler::ha_rnd_next (this=0x7ff2400bf570, buf=0x7ff2400abca0 "\300R\003") at /data/src/10.2/sql/handler.cc:2664

#12 0x00005569e5735d88 in rr_sequential (info=0x7ff240011898) at /data/src/10.2/sql/records.cc:492

#13 0x00005569e5491e50 in sub_select (end_of_records=false, join_tab=0x7ff2400117d0, join=0x7ff24000fc40) at /data/src/10.2/sql/sql_select.cc:18928

#14 sub_select (join=0x7ff24000fc40, join_tab=0x7ff2400117d0, end_of_records=<optimized out>) at /data/src/10.2/sql/sql_select.cc:18844

#15 0x00005569e54ba657 in do_select (procedure=<optimized out>, join=0x7ff24000fc40) at /data/src/10.2/sql/sql_select.cc:18452

#16 JOIN::exec_inner (this=0x7ff24000fc40) at /data/src/10.2/sql/sql_select.cc:3651

#17 0x00005569e54ba8f3 in JOIN::exec (this=this@entry=0x7ff24000fc40) at /data/src/10.2/sql/sql_select.cc:3446

#18 0x00005569e54baa36 in mysql_select (thd=0x7ff240000c48, tables=0x7ff24000f530, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=<optimized out>, result=0x7ff24000fc20, unit=0x7ff240004680, select_lex=0x7ff240004dd0) at /data/src/10.2/sql/sql_select.cc:3849

#19 0x00005569e54bb3bf in handle_select (thd=thd@entry=0x7ff240000c48, lex=lex@entry=0x7ff2400045c0, result=result@entry=0x7ff24000fc20, setup_tables_done_option=setup_tables_done_option@entry=0) at /data/src/10.2/sql/sql_select.cc:361

#20 0x00005569e54507d1 in execute_sqlcom_select (thd=0x7ff240000c48, all_tables=0x7ff24000f530) at /data/src/10.2/sql/sql_parse.cc:6271

#21 0x00005569e545dc12 in mysql_execute_command (thd=<optimized out>) at /data/src/10.2/sql/sql_parse.cc:3582

#22 0x00005569e5460a0b in mysql_parse (thd=thd@entry=0x7ff240000c48, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7ff289bb15a0, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.2/sql/sql_parse.cc:7793

#23 0x00005569e5463bed in dispatch_command (command=COM_QUERY, thd=0x7ff240000c48, packet=<optimized out>, packet_length=<optimized out>, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /data/src/10.2/sql/sql_class.h:182

#24 0x00005569e5464eb9 in do_command (thd=0x7ff240000c48) at /data/src/10.2/sql/sql_parse.cc:1381

#25 0x00005569e553ea86 in do_handle_one_connection (connect=connect@entry=0x5569e7220408) at /data/src/10.2/sql/sql_connect.cc:1336

#26 0x00005569e553ebfb in handle_one_connection (arg=arg@entry=0x5569e7220408) at /data/src/10.2/sql/sql_connect.cc:1241

#27 0x00005569e5acb372 in pfs_spawn_thread (arg=0x5569e7520588) at /data/src/10.2/storage/perfschema/pfs.cc:1869

#28 0x00007ff28fc68ea7 in start_thread (arg=<optimized out>) at pthread_create.c:477

#29 0x00007ff28f885def in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95