InnoDB: Failing assertion: !memcmp(page, temp_page, PAGE_HEADER)

--source include/have_innodb.inc

--source include/have_sequence.inc

CREATE TABLE t1 (c5 GEOMETRY NOT NULL, SPATIAL KEY(c5)) ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1;

INSERT INTO t1 SELECT POINT(seq,seq) FROM seq_1_to_30;

SET GLOBAL innodb_compression_level=0;

INSERT INTO t1 SELECT POINT(seq,seq) FROM seq_1_to_30;

InnoDB: Failing assertion: !memcmp(page, temp_page, PAGE_HEADER)

Core was generated by `/test/EMD100826-mariadb-10.6.28-24-linux-x86_64-dbg/bin/mariadbd --defaults-gro'.

Program terminated with signal SIGABRT, Aborted.

#0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44

[Current thread is 1 (LWP 2170421)]

(gdb) bt

#0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44

#1  __pthread_kill_internal (signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:78

#2  __GI___pthread_kill (threadid=<optimized out>, signo=signo@entry=6)at ./nptl/pthread_kill.c:89

#3  0x00007b4cf6a4527e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26

#4  0x00007b4cf6a288ff in __GI_abort () at ./stdlib/abort.c:79

#5  0x00005727379ceded in ut_dbg_assertion_failed (expr=0x572737e0476d "!memcmp(page, temp_page, PAGE_HEADER)", file=0x572737e03729 "/test/10.6-es_dbg/storage/innobase/page/page0zip.cc", line=4460) at /test/10.6-es_dbg/storage/innobase/ut/ut0dbg.cc:60

#6  0x00005727378912dd in page_zip_reorganize (block=0x734cd000f8a0, index=0x734c040683a0, z_level=0, mtr=0x7b4cf533bc90, restore=true)at /test/10.6-es_dbg/storage/innobase/page/page0zip.cc:4460

#7  0x000057273786a966 in page_cur_insert_rec_zip (cursor=0x7b4cf533bbd8, rec=0x734c04072536 "", offsets=0x734c04072150, mtr=0x7b4cf533bc90)at /test/10.6-es_dbg/storage/innobase/page/page0cur.cc:1869

#8  0x0000572737b28b38 in page_cur_tuple_insert (cursor=0x7b4cf533bbd8, tuple=0x734c0421ea78, offsets=0x7b4cf533b968, heap=0x7b4cf533bc68, n_ext=0, mtr=0x7b4cf533bc90) at include/page0cur.inl:183

#9  0x0000572737b27095 in rtr_page_split_and_insert (flags=0, cursor=0x7b4cf533bbd8, offsets=0x7b4cf533b968, heap=0x7b4cf533bc68, tuple=0x734c0421ea78, n_ext=0, mtr=0x7b4cf533bc90, err=0x7b4cf533b65c)at /test/10.6-es_dbg/storage/innobase/gis/gis0rtree.cc:1132

#10 0x00005727379dca09 in btr_page_split_and_insert (flags=0, cursor=0x7b4cf533bbd8, offsets=0x7b4cf533b968, heap=0x7b4cf533bc68, tuple=0x734c0421ea78, n_ext=0, mtr=0x7b4cf533bc90, err=0x7b4cf533b65c)at /test/10.6-es_dbg/storage/innobase/btr/btr0btr.cc:3055

#11 0x00005727379dc0fc in btr_root_raise_and_insert (flags=0, cursor=0x7b4cf533bbd8, offsets=0x7b4cf533b968, heap=0x7b4cf533bc68, tuple=0x734c0421ea78, n_ext=0, mtr=0x7b4cf533bc90, err=0x7b4cf533b65c)at /test/10.6-es_dbg/storage/innobase/btr/btr0btr.cc:2164

#12 0x0000572737a06a29 in btr_cur_pessimistic_insert (flags=0, cursor=0x7b4cf533bbd8, offsets=0x7b4cf533b968, heap=0x7b4cf533bc68, entry=0x734c0421ea78, rec=0x7b4cf533b820, big_rec=0x7b4cf533b818, n_ext=0, thr=0x734c04065490, mtr=0x7b4cf533bc90)at /test/10.6-es_dbg/storage/innobase/btr/btr0cur.cc:2805

#13 0x00005727378e43d0 in row_ins_sec_index_entry_low (flags=0, mode=BTR_INSERT_TREE, index=0x734c040683a0, offsets_heap=0x734c0406e2a0, heap=0x734c04070bb0, entry=0x734c0421ea78, trx_id=0, thr=0x734c04065490)at /test/10.6-es_dbg/storage/innobase/row/row0ins.cc:3184

#14 0x00005727378e5cc4 in row_ins_sec_index_entry (index=0x734c040683a0, entry=0x734c0421ea78, thr=0x734c04065490, check_foreign=true)at /test/10.6-es_dbg/storage/innobase/row/row0ins.cc:3375

#15 0x00005727378ed114 in row_ins_index_entry (index=0x734c040683a0, entry=0x734c0421ea78, thr=0x734c04065490)at /test/10.6-es_dbg/storage/innobase/row/row0ins.cc:3409

#16 0x00005727378ec4dd in row_ins_index_entry_step (node=0x734c04065270, thr=0x734c04065490)at /test/10.6-es_dbg/storage/innobase/row/row0ins.cc:3573

#17 0x00005727378e6547 in row_ins (node=0x734c04065270, thr=0x734c04065490)at /test/10.6-es_dbg/storage/innobase/row/row0ins.cc:3698

#18 0x00005727378e626a in row_ins_step (thr=0x734c04065490)at /test/10.6-es_dbg/storage/innobase/row/row0ins.cc:3827

#19 0x0000572737909496 in row_insert_for_mysql (mysql_rec=0x734c040b19b8 "\031", prebuilt=0x734c04064dd0, ins_mode=ROW_INS_NORMAL)at /test/10.6-es_dbg/storage/innobase/row/row0mysql.cc:1296

#20 0x000057273773a615 in ha_innobase::write_row (this=0x734c040b11b8, record=0x734c040b19b8 "\031")at /test/10.6-es_dbg/storage/innobase/handler/ha_innodb.cc:7772

#21 0x00005727373a09c6 in handler::ha_write_row (this=0x734c040b11b8, buf=0x734c040b19b8 "\031") at /test/10.6-es_dbg/sql/handler.cc:7797

#22 0x0000572736fb1fe3 in write_record (thd=0x734c04000d58, table=0x734c040c0fb8, info=0x734c040166b0, sink=0x0)at /test/10.6-es_dbg/sql/sql_insert.cc:2310

#23 0x0000572736fb6c97 in select_insert::send_data (this=0x734c04016660, values=@0x734c040150a0: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x734c040155d8, last = 0x734c040155d8, elements = 1}, <No data fields>})at /test/10.6-es_dbg/sql/sql_insert.cc:4300

#24 0x00005727370b26ff in select_result_sink::send_data_with_check (this=0x734c04016660, items=@0x734c040150a0: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x734c040155d8, last = 0x734c040155d8, elements = 1}, <No data fields>}, u=0x734c04004f40, sent=8) at /test/10.6-es_dbg/sql/sql_class.h:5984

#25 0x0000572737077989 in end_send (join=0x734c04016720, join_tab=0x734c04017e50, end_of_records=false)at /test/10.6-es_dbg/sql/sql_select.cc:23766

#26 0x000057273709cb8c in evaluate_join_record (join=0x734c04016720, join_tab=0x734c04017a90, error=0)at /test/10.6-es_dbg/sql/sql_select.cc:22721

#27 0x000057273705b74e in sub_select (join=0x734c04016720, join_tab=0x734c04017a90, end_of_records=false)at /test/10.6-es_dbg/sql/sql_select.cc:22530

#28 0x000057273707dad8 in do_select (join=0x734c04016720, procedure=0x0)at /test/10.6-es_dbg/sql/sql_select.cc:22014

#29 0x000057273707cf5d in JOIN::exec_inner (this=0x734c04016720)at /test/10.6-es_dbg/sql/sql_select.cc:4969

#30 0x000057273707c049 in JOIN::exec (this=0x734c04016720)at /test/10.6-es_dbg/sql/sql_select.cc:4747

#31 0x000057273705be09 in mysql_select (thd=0x734c04000d58, tables=0x734c04015668, fields=@0x734c040150a0: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x734c040155d8, last = 0x734c040155d8, elements = 1}, <No data fields>}, conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2202244745984, result=0x734c04016660, unit=0x734c04004f40, select_lex=0x734c04014dc8) at /test/10.6-es_dbg/sql/sql_select.cc:5283

#32 0x000057273705b91d in handle_select (thd=0x734c04000d58, lex=0x734c04004e78, result=0x734c04016660, setup_tables_done_option=1073741824)at /test/10.6-es_dbg/sql/sql_select.cc:575

#33 0x00005727370056ef in mysql_execute_command (thd=0x734c04000d58, is_called_from_prepared_stmt=false)at /test/10.6-es_dbg/sql/sql_parse.cc:4841

#34 0x0000572736ffa948 in mysql_parse (thd=0x734c04000d58, rawbuf=0x734c040145a0 "INSERT INTO t1 SELECT POINT(seq,seq) FROM seq_1_to_30", length=53, parser_state=0x7b4cf533ea28)at /test/10.6-es_dbg/sql/sql_parse.cc:8228

#35 0x0000572736ff8141 in dispatch_command (command=COM_QUERY, thd=0x734c04000d58, packet=0x734c041c5969 "INSERT INTO t1 SELECT POINT(seq,seq) FROM seq_1_to_30", packet_length=53, blocking=true) at /test/10.6-es_dbg/sql/sql_parse.cc:1918

#36 0x0000572736ffb3ef in do_command (thd=0x734c04000d58, blocking=true)at /test/10.6-es_dbg/sql/sql_parse.cc:1428

#37 0x00005727371a96be in do_handle_one_connection (connect=0x5727721df958, put_in_cache=true) at /test/10.6-es_dbg/sql/sql_connect.cc:1393

#38 0x00005727371a94a5 in handle_one_connection (arg=0x5727721cc238)at /test/10.6-es_dbg/sql/sql_connect.cc:1305

#39 0x00007b4cf6a9cb84 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447

#40 0x00007b4cf6b29d6c in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78

    Rel    o/d  Build   Commit                                    UniqueID observed             

CS  10.6   dbg  100826  0931994096b84ecc9ffc8eb3517c7e09e6e8631e  !memcmp(page, temp_page, PAGE_HEADER)|SIGABRT|ut_dbg_assertion_failed|page_zip_reorganize|page_cur_insert_rec_zip|page_cur_tuple_insert

CS  10.6   opt  100826  0931994096b84ecc9ffc8eb3517c7e09e6e8631e  No bug found                  

CS  10.11  dbg  100826  aba2caa893cdfa880dbb9a4f2d8e6dfaa7ed8ebe  !memcmp(page, temp_page, PAGE_HEADER)|SIGABRT|ut_dbg_assertion_failed|page_zip_reorganize|page_cur_insert_rec_zip|page_cur_tuple_insert

CS  10.11  opt  100826  aba2caa893cdfa880dbb9a4f2d8e6dfaa7ed8ebe  No bug found                  

CS  11.4   dbg  100826  f6418ff7b2a0ecbc158f53331735994446bed0ac  !memcmp(page, temp_page, PAGE_HEADER)|SIGABRT|ut_dbg_assertion_failed|page_zip_reorganize|page_cur_insert_rec_zip|page_cur_tuple_insert

CS  11.4   opt  100826  f6418ff7b2a0ecbc158f53331735994446bed0ac  No bug found                  

CS  11.8   dbg  100826  da0beac410cc761be4ee52b90fded6c7fa2f8947  !memcmp(page, temp_page, PAGE_HEADER)|SIGABRT|ut_dbg_assertion_failed|page_zip_reorganize|page_cur_insert_rec_zip|page_cur_tuple_insert

CS  11.8   opt  100826  da0beac410cc761be4ee52b90fded6c7fa2f8947  No bug found                  

CS  12.3   dbg  100826  6b174bfb25be06f7efdab149183665e1a36b3dd5  !memcmp(page, temp_page, PAGE_HEADER)|SIGABRT|ut_dbg_assertion_failed|page_zip_reorganize|page_cur_insert_rec_zip|page_cur_tuple_insert

CS  12.3   opt  100826  6b174bfb25be06f7efdab149183665e1a36b3dd5  No bug found                  

CS  13.0   dbg  100826  1a4bb1bbfde5fa17ba148cb62678902f11c66a1a  !memcmp(page, temp_page, PAGE_HEADER)|SIGABRT|ut_dbg_assertion_failed|page_zip_reorganize|page_cur_insert_rec_zip|page_cur_tuple_insert

CS  13.0   opt  100826  1a4bb1bbfde5fa17ba148cb62678902f11c66a1a  No bug found                  

CS  13.1   dbg  100826  a217e1000f37a429a9c1d1c308952a959276b77e  !memcmp(page, temp_page, PAGE_HEADER)|SIGABRT|ut_dbg_assertion_failed|page_zip_reorganize|page_cur_insert_rec_zip|page_cur_tuple_insert

CS  13.1   opt  100826  a217e1000f37a429a9c1d1c308952a959276b77e  No bug found                  

ES  10.6   dbg  100826  fcecb2620f25965723d640decede7c018bcb1dcc  !memcmp(page, temp_page, PAGE_HEADER)|SIGABRT|ut_dbg_assertion_failed|page_zip_reorganize|page_cur_insert_rec_zip|page_cur_tuple_insert

ES  10.6   opt  100826  fcecb2620f25965723d640decede7c018bcb1dcc  No bug found                  

ES  11.4   dbg  100826  3b34189bfe675c18c4ced3ef531d016ea74c76f4  !memcmp(page, temp_page, PAGE_HEADER)|SIGABRT|ut_dbg_assertion_failed|page_zip_reorganize|page_cur_insert_rec_zip|page_cur_tuple_insert

ES  11.4   opt  100826  3b34189bfe675c18c4ced3ef531d016ea74c76f4  No bug found                  

ES  11.8   dbg  100826  4694e931d10fecf733c34f83ea2146d31b708eb3  !memcmp(page, temp_page, PAGE_HEADER)|SIGABRT|ut_dbg_assertion_failed|page_zip_reorganize|page_cur_insert_rec_zip|page_cur_tuple_insert

ES  11.8   opt  100826  4694e931d10fecf733c34f83ea2146d31b708eb3  No bug found                  

ES  12.3   dbg  100826  ad4d36b69e4813957c35d5e148b93a51a61c91c6  !memcmp(page, temp_page, PAGE_HEADER)|SIGABRT|ut_dbg_assertion_failed|page_zip_reorganize|page_cur_insert_rec_zip|page_cur_tuple_insert

ES  12.3   opt  100826  ad4d36b69e4813957c35d5e148b93a51a61c91c6  No bug found