Assertion `state < buf_page_t::UNFIXED || page_id_t(page_get_space_id(block->page.frame), page_get_page_no(block->page.frame)) == block->page.id()' failed in mtr_t::page_lock

--source include/have_innodb.inc

--source include/have_sequence.inc

CREATE TEMPORARY TABLE t (c POINT NOT NULL, SPATIAL(c)) ENGINE=InnoDB;

INSERT INTO t SELECT PointFromText('POINT(0 0)') FROM seq_1_to_366;

mariadbd: /data/src/10.6/storage/innobase/mtr/mtr0mtr.cc:1207: void mtr_t::page_lock(buf_block_t*, ulint): Assertion `state < buf_page_t::UNFIXED || page_id_t(page_get_space_id(block->page.frame), page_get_page_no(block->page.frame)) == block->page.id()' failed.

220103 21:27:48 [ERROR] mysqld got signal 6 ;

#6  0x00007fa78a6ef40f in __assert_fail_base (fmt=0x7fa78a858128 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x565478d2abf8 "state < buf_page_t::UNFIXED || page_id_t(page_get_space_id(block->page.frame), page_get_page_no(block->page.frame)) == block->page.id()", file=0x565478d29c08 "/data/src/10.6/storage/innobase/mtr/mtr0mtr.cc", line=1207, function=<optimized out>) at assert.c:92

#7  0x00007fa78a6fe662 in __GI___assert_fail (assertion=0x565478d2abf8 "state < buf_page_t::UNFIXED || page_id_t(page_get_space_id(block->page.frame), page_get_page_no(block->page.frame)) == block->page.id()", file=0x565478d29c08 "/data/src/10.6/storage/innobase/mtr/mtr0mtr.cc", line=1207, function=0x565478d2ab58 "void mtr_t::page_lock(buf_block_t*, ulint)") at assert.c:101

#8  0x000056547853abc7 in mtr_t::page_lock (this=0x7fa7842932c0, block=0x7fa77f80f8a0, rw_latch=2) at /data/src/10.6/storage/innobase/mtr/mtr0mtr.cc:1207

#9  0x000056547871d29b in buf_page_get_low (page_id=..., zip_size=0, rw_latch=2, guess=0x0, mode=16, mtr=0x7fa7842932c0, err=0x0, allow_ibuf_merge=false) at /data/src/10.6/storage/innobase/buf/buf0buf.cc:2926

#10 0x000056547871d652 in buf_page_get_gen (page_id=..., zip_size=0, rw_latch=2, guess=0x0, mode=16, mtr=0x7fa7842932c0, err=0x0, allow_ibuf_merge=false) at /data/src/10.6/storage/innobase/buf/buf0buf.cc:2991

#11 0x00005654784cbbaa in ibuf_bitmap_get_map_page (page_id=..., zip_size=0, mtr=0x7fa7842932c0) at /data/src/10.6/storage/innobase/ibuf/ibuf0ibuf.cc:669

#12 0x00005654784cbcbc in ibuf_set_free_bits_low (block=0x7fa77f80f700, val=3, mtr=0x7fa7842932c0) at /data/src/10.6/storage/innobase/ibuf/ibuf0ibuf.cc:699

#13 0x00005654784cc35f in ibuf_update_free_bits_for_two_pages_low (block1=0x7fa77f80f700, block2=0x7fa77f80f7d0, mtr=0x7fa7842932c0) at /data/src/10.6/storage/innobase/ibuf/ibuf0ibuf.cc:884

#14 0x0000565478807123 in rtr_page_split_and_insert (flags=2, cursor=0x7fa784292fc0, offsets=0x7fa784292f68, heap=0x7fa784292f40, tuple=0x7fa72c043790, n_ext=0, mtr=0x7fa7842932c0) at /data/src/10.6/storage/innobase/gis/gis0rtree.cc:1176

#15 0x00005654786bfc85 in btr_root_raise_and_insert (flags=2, cursor=0x7fa784292fc0, offsets=0x7fa784292f68, heap=0x7fa784292f40, tuple=0x7fa72c043790, n_ext=0, mtr=0x7fa7842932c0) at /data/src/10.6/storage/innobase/btr/btr0btr.cc:1963

#16 0x00005654786eca1d in btr_cur_pessimistic_insert (flags=2, cursor=0x7fa784292fc0, offsets=0x7fa784292f68, heap=0x7fa784292f40, entry=0x7fa72c043790, rec=0x7fa784292f70, big_rec=0x7fa784292f78, n_ext=0, thr=0x7fa72c21cba8, mtr=0x7fa7842932c0) at /data/src/10.6/storage/innobase/btr/btr0cur.cc:3759

#17 0x00005654785d3a1b in row_ins_sec_index_entry_low (flags=2, mode=33, index=0x7fa72c1ad218, offsets_heap=0x7fa72c058738, heap=0x7fa72c058bd8, entry=0x7fa72c043790, trx_id=0, thr=0x7fa72c21cba8) at /data/src/10.6/storage/innobase/row/row0ins.cc:3131

#18 0x00005654785d41b1 in row_ins_sec_index_entry (index=0x7fa72c1ad218, entry=0x7fa72c043790, thr=0x7fa72c21cba8, check_foreign=true) at /data/src/10.6/storage/innobase/row/row0ins.cc:3324

#19 0x00005654785d433e in row_ins_index_entry (index=0x7fa72c1ad218, entry=0x7fa72c043790, thr=0x7fa72c21cba8) at /data/src/10.6/storage/innobase/row/row0ins.cc:3358

#20 0x00005654785d4bef in row_ins_index_entry_step (node=0x7fa72c21c988, thr=0x7fa72c21cba8) at /data/src/10.6/storage/innobase/row/row0ins.cc:3524

#21 0x00005654785d5108 in row_ins (node=0x7fa72c21c988, thr=0x7fa72c21cba8) at /data/src/10.6/storage/innobase/row/row0ins.cc:3670

#22 0x00005654785d5a08 in row_ins_step (thr=0x7fa72c21cba8) at /data/src/10.6/storage/innobase/row/row0ins.cc:3816

#23 0x00005654785f6e41 in row_insert_for_mysql (mysql_rec=0x7fa72c22e4e8 "\031", prebuilt=0x7fa72c21c498, ins_mode=ROW_INS_NORMAL) at /data/src/10.6/storage/innobase/row/row0mysql.cc:1318

#24 0x0000565478437eab in ha_innobase::write_row (this=0x7fa72c22e950, record=0x7fa72c22e4e8 "\031") at /data/src/10.6/storage/innobase/handler/ha_innodb.cc:7836

#25 0x000056547802b1a3 in handler::ha_write_row (this=0x7fa72c22e950, buf=0x7fa72c22e4e8 "\031") at /data/src/10.6/sql/handler.cc:7519

#26 0x0000565477c3a0ff in write_record (thd=0x7fa72c000db8, table=0x7fa72c22e058, info=0x7fa72c0185a8, sink=0x0) at /data/src/10.6/sql/sql_insert.cc:2146

#27 0x0000565477c3fc09 in select_insert::send_data (this=0x7fa72c018558, values=...) at /data/src/10.6/sql/sql_insert.cc:4102

#28 0x0000565477d2ab87 in select_result_sink::send_data_with_check (this=0x7fa72c018558, items=..., u=0x7fa72c005120, sent=365) at /data/src/10.6/sql/sql_class.h:5632

#29 0x0000565477d10552 in end_send (join=0x7fa72c018618, join_tab=0x7fa72c019c10, end_of_records=false) at /data/src/10.6/sql/sql_select.cc:22311

#30 0x0000565477d0da25 in evaluate_join_record (join=0x7fa72c018618, join_tab=0x7fa72c019860, error=0) at /data/src/10.6/sql/sql_select.cc:21304

#31 0x0000565477d0d41e in sub_select (join=0x7fa72c018618, join_tab=0x7fa72c019860, end_of_records=false) at /data/src/10.6/sql/sql_select.cc:21113

#32 0x0000565477d0c78c in do_select (join=0x7fa72c018618, procedure=0x0) at /data/src/10.6/sql/sql_select.cc:20621

#33 0x0000565477cdfe5c in JOIN::exec_inner (this=0x7fa72c018618) at /data/src/10.6/sql/sql_select.cc:4737

#34 0x0000565477cdeed1 in JOIN::exec (this=0x7fa72c018618) at /data/src/10.6/sql/sql_select.cc:4515

#35 0x0000565477ce07e9 in mysql_select (thd=0x7fa72c000db8, tables=0x7fa72c0164a8, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2202244745984, result=0x7fa72c018558, unit=0x7fa72c005120, select_lex=0x7fa72c015dd8) at /data/src/10.6/sql/sql_select.cc:4994

#36 0x0000565477ccfb67 in handle_select (thd=0x7fa72c000db8, lex=0x7fa72c005058, result=0x7fa72c018558, setup_tables_done_option=1073741824) at /data/src/10.6/sql/sql_select.cc:545

#37 0x0000565477c8b280 in mysql_execute_command (thd=0x7fa72c000db8, is_called_from_prepared_stmt=false) at /data/src/10.6/sql/sql_parse.cc:4710

#38 0x0000565477c961f8 in mysql_parse (thd=0x7fa72c000db8, rawbuf=0x7fa72c0155c0 "INSERT INTO t SELECT PointFromText('POINT(0 0)') FROM seq_1_to_366", length=66, parser_state=0x7fa784295500) at /data/src/10.6/sql/sql_parse.cc:8029

#39 0x0000565477c82833 in dispatch_command (command=COM_QUERY, thd=0x7fa72c000db8, packet=0x7fa72c00b879 "INSERT INTO t SELECT PointFromText('POINT(0 0)') FROM seq_1_to_366", packet_length=66, blocking=true) at /data/src/10.6/sql/sql_parse.cc:1896

#40 0x0000565477c811ed in do_command (thd=0x7fa72c000db8, blocking=true) at /data/src/10.6/sql/sql_parse.cc:1404

#41 0x0000565477e39fdc in do_handle_one_connection (connect=0x56547a80bc78, put_in_cache=true) at /data/src/10.6/sql/sql_connect.cc:1418

#42 0x0000565477e39c7b in handle_one_connection (arg=0x56547a8cfe88) at /data/src/10.6/sql/sql_connect.cc:1312

#43 0x00005654783508d8 in pfs_spawn_thread (arg=0x56547a809348) at /data/src/10.6/storage/perfschema/pfs.cc:2201

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

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