Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.5.9
-
None
Description
InnoDB fails to set the tablespace associated with mtr during reset of change buffer bitmap.
#3 <signal handler called>
|
#4 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
|
#5 0x00007f33095e5859 in __GI_abort () at abort.c:79
|
#6 0x00007f33095e5729 in __assert_fail_base (fmt=0x7f330977b588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n",
|
assertion=0x558066c10280 "mtr->is_named_space(page_id.space())",
|
file=0x558066c09dc0 "/Server/bb-10.5-thiru/storage/innobase/ibuf/ibuf0ibuf.cc", line=624, function=<optimized out>) at assert.c:92
|
#7 0x00007f33095f6f36 in __GI___assert_fail (assertion=0x558066c10280 "mtr->is_named_space(page_id.space())",
|
file=0x558066c09dc0 "/Server/bb-10.5-thiru/storage/innobase/ibuf/ibuf0ibuf.cc", line=624,
|
function=0x558066c10540 "void ibuf_bitmap_page_set_bits(buf_block_t*, page_id_t, ulint, ulint, mtr_t*) [with long unsigned int bit = 2; ulint = long unsigned int]") at assert.c:101
|
#8 0x0000558065372444 in ibuf_bitmap_page_set_bits<2> (block=0x7f32f3ff38d8, page_id=..., physical_size=2048, val=0, mtr=0x7f32f10cddb0)
|
at /Server/bb-10.5-thiru/storage/innobase/ibuf/ibuf0ibuf.cc:624
|
#9 0x000055806536d743 in ibuf_reset_bitmap (b=0x7f32f3fdc430, page_id=..., zip_size=2048, mtr=0x7f32f10cddb0)
|
at /Server/bb-10.5-thiru/storage/innobase/ibuf/ibuf0ibuf.cc:4181
|
#10 0x000055806536debb in ibuf_merge_or_delete_for_page (block=0x7f32f3fdc430, page_id=..., zip_size=2048)
|
at /Server/bb-10.5-thiru/storage/innobase/ibuf/ibuf0ibuf.cc:4254
|
#11 0x000055806582df6a in buf_page_get_low (page_id=..., zip_size=2048, rw_latch=2, guess=0x0, mode=16,
|
file=0x558066c09dc0 "/Server/bb-10.5-thiru/storage/innobase/ibuf/ibuf0ibuf.cc", line=2326, mtr=0x7f32f10cea00, err=0x7f32f10ce830,
|
allow_ibuf_merge=true) at /Server/bb-10.5-thiru/storage/innobase/buf/buf0buf.cc:3398
|
#12 0x000055806582e6bc in buf_page_get_gen (page_id=..., zip_size=2048, rw_latch=2, guess=0x0, mode=16,
|
file=0x558066c09dc0 "/Server/bb-10.5-thiru/storage/innobase/ibuf/ibuf0ibuf.cc", line=2326, mtr=0x7f32f10cea00, err=0x7f32f10ce830,
|
allow_ibuf_merge=true) at /Server/bb-10.5-thiru/storage/innobase/buf/buf0buf.cc:3479
|
#13 0x000055806536249d in ibuf_read_merge_pages (space_ids=0x7f32f10cf2b0, page_nos=0x7f32f10cf2f0, n_stored=1)
|
at /Server/bb-10.5-thiru/storage/innobase/ibuf/ibuf0ibuf.cc:2323
|
#14 0x0000558065367f37 in ibuf_insert_low (mode=36, op=IBUF_OP_INSERT, no_counter=0, entry=0x61b000184990, entry_size=20, index=0x6170005872a0,
|
page_id=..., zip_size=2048, thr=0x6210004887f8) at /Server/bb-10.5-thiru/storage/innobase/ibuf/ibuf0ibuf.cc:3478
|
#15 0x0000558065368859 in ibuf_insert (op=IBUF_OP_INSERT, entry=0x61b000184990, index=0x6170005872a0, page_id=..., zip_size=2048,
|
thr=0x6210004887f8) at /Server/bb-10.5-thiru/storage/innobase/ibuf/ibuf0ibuf.cc:3601
|
#16 0x00005580657bdaa6 in btr_cur_search_to_nth_level_func (index=0x6170005872a0, level=0, tuple=0x61b000184990, mode=PAGE_CUR_LE, latch_mode=2,
|
cursor=0x7f32f10d12a0, ahi_latch=0x0, file=0x558066cfc8a0 "/Server/bb-10.5-thiru/storage/innobase/row/row0ins.cc", line=2969,
|
mtr=0x7f32f10d1660, autoinc=0) at /Server/bb-10.5-thiru/storage/innobase/btr/btr0cur.cc:1648
|
#17 0x00005580655424a9 in row_ins_sec_index_entry_low (flags=0, mode=2, index=0x6170005872a0, offsets_heap=0x61a0000e4098, heap=0x61a000bdb498,
|
entry=0x61b000184990, trx_id=0, thr=0x6210004887f8) at /Server/bb-10.5-thiru/storage/innobase/row/row0ins.cc:2966
|
--Type <RET> for more, q to quit, c to continue without paging--
|
#18 0x0000558065544185 in row_ins_sec_index_entry (index=0x6170005872a0, entry=0x61b000184990, thr=0x6210004887f8, check_foreign=true)
|
at /Server/bb-10.5-thiru/storage/innobase/row/row0ins.cc:3288
|
#19 0x00005580655444f7 in row_ins_index_entry (index=0x6170005872a0, entry=0x61b000184990, thr=0x6210004887f8)
|
at /Server/bb-10.5-thiru/storage/innobase/row/row0ins.cc:3335
|
#20 0x000055806554564d in row_ins_index_entry_step (node=0x621000488530, thr=0x6210004887f8)
|
at /Server/bb-10.5-thiru/storage/innobase/row/row0ins.cc:3502
|
#21 0x0000558065546126 in row_ins (node=0x621000488530, thr=0x6210004887f8) at /Server/bb-10.5-thiru/storage/innobase/row/row0ins.cc:3661
|
#22 0x0000558065547341 in row_ins_step (thr=0x6210004887f8) at /Server/bb-10.5-thiru/storage/innobase/row/row0ins.cc:3807
|
#23 0x0000558065590e45 in row_insert_for_mysql (mysql_rec=0x61a000ecd6b8 "ؚ\003", prebuilt=0x621004ce3da0, ins_mode=ROW_INS_NORMAL)
|
at /Server/bb-10.5-thiru/storage/innobase/row/row0mysql.cc:1421
|
#24 0x00005580651edd82 in ha_innobase::write_row (this=0x61d0006f22b8, record=0x61a000ecd6b8 "ؚ\003")
|
at /Server/bb-10.5-thiru/storage/innobase/handler/ha_innodb.cc:7560
|
#25 0x00005580646e6891 in handler::ha_write_row (this=0x61d0006f22b8, buf=0x61a000ecd6b8 "ؚ\003") at /Server/bb-10.5-thiru/sql/handler.cc:7153
|
#26 0x0000558063df16ea in write_record (thd=0x62b000046218, table=0x6190003caf98, info=0x7f32f10d3820, sink=0x0)
|
at /Server/bb-10.5-thiru/sql/sql_insert.cc:2106
|
#27 0x0000558063de919d in mysql_insert (thd=0x62b000046218, table_list=0x62b0000544c8, fields=..., values_list=..., update_fields=...,
|
update_values=..., duplic=DUP_ERROR, ignore=false, result=0x0) at /Server/bb-10.5-thiru/sql/sql_insert.cc:1099
|
#28 0x0000558063eb1964 in mysql_execute_command (thd=0x62b000046218) at /Server/bb-10.5-thiru/sql/sql_parse.cc:4597
|
#29 0x0000558063ec9e72 in mysql_parse (thd=0x62b000046218,
|
rawbuf=0x62b000054238 "INSERT INTO t2 (col1,col2, col_int, col_string, col_text) VALUES ( 922, 922, 922 - 1, REPEAT(SUBSTR(CAST( 922 AS CHAR),1,1), 10), REPEAT(SUBSTR(CAST( 922 AS CHAR),1,1), @fill_amount) ) /* E_R Thread2 "..., length=223, parser_state=0x7f32f10d47c0,
|
is_com_multi=false, is_next_command=false) at /Server/bb-10.5-thiru/sql/sql_parse.cc:8063
|
#30 0x0000558063ea006b in dispatch_command (command=COM_QUERY, thd=0x62b000046218,
|
packet=0x62900171b219 " INSERT INTO t2 (col1,col2, col_int, col_string, col_text) VALUES ( 922, 922, 922 - 1, REPEAT(SUBSTR(CAST( 922 AS CHAR),1,1), 10), REPEAT(SUBSTR(CAST( 922 AS CHAR),1,1), @fill_amount) ) /* E_R Thread2"..., packet_length=225, is_com_multi=false,
|
is_next_command=false) at /Server/bb-10.5-thiru/sql/sql_parse.cc:1889
|
#31 0x0000558063e9c994 in do_command (thd=0x62b000046218) at /Server/bb-10.5-thiru/sql/sql_parse.cc:1370
|
#32 0x00005580642df22b in do_handle_one_connection (connect=0x608000024bb8, put_in_cache=true) at /Server/bb-10.5-thiru/sql/sql_connect.cc:1410
|
#33 0x00005580642deb94 in handle_one_connection (arg=0x608000023538) at /Server/bb-10.5-thiru/sql/sql_connect.cc:1312
|
#34 0x0000558064fed9b5 in pfs_spawn_thread (arg=0x61500000cb18) at /Server/bb-10.5-thiru/storage/perfschema/pfs.cc:2201
|
#35 0x00007f3309b0e609 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
#36 0x00007f33096e2293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
This is caused by MDEV-24569
Attachments
Issue Links
- is caused by
-
MDEV-24569 Assertion `mach_read_from_4(frame + 4U) == block.page.id().page_no()' failed in log_phys_t::apply
- Closed