[MDEV-28806] Server crash in row_log_online_op or Assertion `flag == 1' failure in row_build_index_entry_low upon concurrent ALTER and UPDATE - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL)
Fix Version/s: 10.6.9, 10.7.5, 10.8.4, 10.9.2
Component/s: Storage Engine - InnoDB, Virtual Columns
Labels:
None

Description

Note: The test case is non-deterministic, run with --repeat=N. It usually fails for me within several attempts (on 10.6 debug), but it can vary for different machines, builds and versions.

--source include/have_innodb.inc

CREATE TABLE t (a CHAR(8), b INT, c INT AS (b), KEY(a)) ENGINE=InnoDB;

INSERT INTO t (b) VALUES (1),(2);

--connect (con1,localhost,root,,test)

--send

  ALTER TABLE t ADD KEY ind (c);

--connection default

SELECT 1;

UPDATE t SET a = 'foo';

# Cleanup

--connection con1

--reap

DROP TABLE t;

--disconnect con1

Can't figure why SELECT 1 (or any SELECT, or some other DML I think) is important there, but I can't get rid of it. Replacing it with --sleep of various duration didn't work either.

10.6 51ca5d51
mariadbd: /data/src/10.6/storage/innobase/row/row0row.cc:274: dtuple_t* row_build_index_entry_low(const dtuple_t, const row_ext_t, const dict_index_t, mem_heap_t, ulint): Assertion `flag == 1' failed.
220611 14:56:26 [ERROR] mysqld got signal 6 ;

#7 0x00007f440a1f0662 in __GI___assert_fail (assertion=0x55e60b999439 "flag == 1", file=0x55e60b9991f8 "/data/src/10.6/storage/innobase/row/row0row.cc", line=274, function=0x55e60b999308 "dtuple_t* row_build_index_entry_low(const dtuple_t, const row_ext_t, const dict_index_t, mem_heap_t, ulint)") at assert.c:101
No locals.
#8 0x000055e60b245e28 in row_build_index_entry_low (row=0x7f43a4b7ba50, ext=0x0, index=0x7f43a8050c88, heap=0x7f43a42347b8, flag=0) at /data/src/10.6/storage/innobase/row/row0row.cc:274
v_col = 0x7f43a40586d8
f = @0x7f43a80ab2a8: {col = 0x7f43a40586d8, name = {m_name = 0x7f43a4058770 "c"}, prefix_len = 0, fixed_len = 4}
dfield = 0x7f43a4b7bb78
dfield2 = 0x7f43a4b7bb00
len = 139928558439960
entry = 0x7f43a4b7bb40
entry_len = 2
i = 0
num_v = 0
__PRETTY_FUNCTION__ = "dtuple_t* row_build_index_entry_low(const dtuple_t, const row_ext_t, const dict_index_t, mem_heap_t, ulint)"
#9 0x000055e60b239fff in UndorecApplier::log_update (this=0x7f43ff566580, tuple=@0x7f43a420a438: {info_bits = 0, n_fields = 1, n_fields_cmp = 1, fields = 0x7f43a420a470, n_v_fields = 0, v_fields = 0x0, magic_n = 65478679}, clust_index=0x7f43a40592a8) at /data/src/10.6/storage/innobase/row/row0log.cc:4064
old_entry = 0x7f43a420a3a0
new_entry = 0x100
offsets_ = {300, 5, 184, 65492, 32579, 0, 37544, 41989, 32579, 0, 32774, 6, 12, 19, 27, 31, 256, 0, 0, 0, 25241, 2596, 166, 0, 104, 0, 0, 0, 23488, 65366, 165, 0, 18344, 42019, 32579, 0, 17344, 3756, 21990, 0, 34368, 2234, 32580, 0, 46248, 2234, 32580, 0, 29184, 2480, 32580, 0, 0, 0, 0, 0, 13, 0, 35, 0, 24164, 65366, 32579, 0, 23520, 65366, 32579, 0, 60134, 2828, 166, 0, 23568, 65366, 32579, 0, 44885, 2824, 21990, 0, 18336, 42019, 32579, 0, 51717, 2838, 35, 0, 256, 0, 0, 0, 24164, 65366, 32579, 0, 0, 0, 0, 0, 24096, 65366, 166, 0, 24096, 65366, 32579, 0, 32077, 2824, 21990, 0, 47328, 42167, 32579, 0, 47280, 42167, 32512, 0, 23552, 65366, 35, 0, 0, 0, 0, 0, 232, 0, 0, 0, 24164, 65366, 32579, 0, 23744, 65366, 32579, 0, 256, 0, 0, 0, 13, 0, 0, 0, 18336, 42019, 32579, 0, 23744, 65366, 32579, 0, 23736, 65366, 32579, 0, 23760, 65366, 32579, 0, 56376, 2837, 21990, 0, 38656, 65366, 32579, 0, 8, 0, 0, 0, 18360, 42019, 32579, 0, 41912, 42016, 32579, 0, 23760, 65366, 32579, 0, 53905, 2837, 21990, 0, 128, 0, 0, 0, 41912, 42016, 32579, 0...}
offsets2_ = {300, 2858, 21990, 0, 42184, 42016, 32579, 0, 24576, 65366, 32579, 0, 53846, 2858, 21990, 0, 26032, 65366, 32579, 0, 18360, 42019, 32579, 0, 24808, 42009, 32512, 0, 272, 327, 0, 154, 60, 0, 0, 0, 12, 0, 0, 0, 37544, 41989, 32579, 0, 18521, 42019, 32579, 0, 0, 0, 0, 0, 0, 0, 256, 1, 65535, 65535, 0, 0, 3, 0, 21990, 0, 1, 0, 0, 0, 1, 0 <repeats 15 times>, 47280, 42167, 0, 0, 42120, 42016, 32579, 0, 42168, 42016, 32579, 0, 42320, 42016, 32579, 0, 0, 0, 0, 0, 24208, 65366, 32579, 0, 41912, 42016, 32579, 0, 18360, 42019, 32579, 0, 18376, 42019, 32579, 0, 24240, 65366, 32579, 0, 18416, 42019, 32579, 0, 41968, 42016, 32579, 0, 49664, 17038, 11922, 63957, 24304, 65366, 32579, 0, 58005, 2837, 21990, 0, 80, 0, 0, 0, 41912, 42016, 32579, 0, 24304, 65366, 32579, 0, 14952, 2858, 21990, 0, 65535, 65535, 0, 0, 42096, 42016, 32579, 0, 24384, 65366, 32579, 0, 17860, 2858, 21990, 0, 0, 0, 0, 0, 1, 0, 0, 0, 80, 0, 0, 0, 42040, 42016, 32579, 0, 1, 0, 0, 0, 42096, 42016, 32579, 0, 1, 0, 0, 0, 42040...}
offsets = 0x7f43ff565b40
prev_offsets = 0x7f43ff565da0
table = 0x7f43a4b75b28
table_rebuild = false
rec = 0x7f43ffd400b8 ""
prev_version = 0x0
is_update = true
match_rec = 0x7f43ffd400b8 ""
row = 0x7f43a4b7b988
new_ext = 0x0
old_ext = 0x0
old_row = 0x7f43a4b7ba50
success = true
index = 0x7f43a8050c88
#10 0x000055e60b2cec91 in UndorecApplier::apply_undo_rec (this=0x7f43ff566580) at /data/src/10.6/storage/innobase/trx/trx0undo.cc:352
trx_id = 60
roll_ptr = 43347146434871568
info_bits = 0 '\000'
updated_extern = false
undo_no = 0
table_id = 20
table = 0x7f43a4b75b28
__PRETTY_FUNCTION__ = "void UndorecApplier::apply_undo_rec()"
index = 0x7f43a40592a8
undo_tuple = 0x7f43a420a438
#11 0x000055e60b2cee99 in trx_t::apply_log (this=0x7f4404831b80) at /data/src/10.6/storage/innobase/trx/trx0undo.cc:387
rec = 0x7f43ffd60110 "\001J\f"
next = 0
undo = 0x7f43a4236338
page_id = {m_id = 330}
next_page_id = {m_id = 330}
mtr = {m_start = true, m_commit = true, m_freeing_tree = false, m_last = 0x0, m_last_offset = 0, m_log_mode = 0, m_modifications = 0, m_made_dirty = 0, m_inside_ibuf = 0, m_trim_pages = 0, m_user_space_id = 0, m_memo = {m_heap = 0x0, m_list = {<ilist<mtr_buf_t::block_t, void>> = {sentinel_ = {next = 0x7f43ff566100, prev = 0x7f43ff566100}}, size_ = 1}, m_size = 0, m_first_block = {<ilist_node<void>> = {next = 0x7f43ff5660e0, prev = 0x7f43ff5660e0}, m_buf_end = 0, m_magic_n = 375767, m_data = "\000\000\000\000\000\000\000\000\001", '\000' <repeats 39 times>, "\001\001\000\034", '\000' <repeats 12 times>, "\030\000\004\000\a", '\000' <repeats 11 times>, "\220aV\377C\177\000\000\320dV\377C\177\000\000\001\000\000\000\000\000\000\000\320dV\377C\177\000\000\320aV\377C\177\000\000,\001\000\000\000\000\000\000\340aV\377C\177\000\000\232\v\v\346U\000\000\000bV\377C\177\000\000\320dV\377C\177\000\000\000r\260\tD\177\000\000\001\000\000\000\000\000\000\000PbV\377C\177\000\000\300\251\267\244\006\000\000\000`bV\377C\177\000\000"..., m_used = 0}}, m_log = {m_heap = 0x0, m_list = {<ilist<mtr_buf_t::block_t, void>> = {sentinel_ = {next = 0x7f43ff566340, prev = 0x7f43ff566340}}, size_ = 1}, m_size = 0, m_first_block = {<ilist_node<void>> = {next = 0x7f43ff566320, prev = 0x7f43ff566320}, m_buf_end = 0, m_magic_n = 375767, m_data = "\240cV\377C\177\000\000\232\v\v\346U\000\000\001\000\000\000\000\000\000\000\320dV\377C\177\000\000\300cV\377C\177\000\000\001\000\000\000\000\000\000\000\020\000\000\000\000\000\000\000\006\000\000\000\006\000\000\000 dV\377C\177\000\000\341,\034\v\346U\000\000\377\377\377\377\377\377\377\377\320dV\377C\177\000\000\000\000\000\000\000\000\000\000\320dV\377C\177\000\000\330\000\000\000\000\000\000\000,\001\000\000\000\000\000\000 dV\377C\177\000\000*\232\v\v\346U\000\000\377\377\377\377\377\377\377\377\320dV\377C\177\000\000\005\000\000\000\000\000\000\000\001\000\000\000\000\000\000\000\000\200\000\000\000\000\000\000\006\000\000\000\006\000\000\000@dV\377C\177\000\000"..., m_used = 0}}, m_user_space = 0x0, m_commit_lsn = 0, m_freed_space = 0x0, m_freed_pages = 0x0}
block = 0x7f43ff8111d0
log_applier = {page_id = {m_id = 330}, undo_rec = 0x7f43a4234859 "", offset = 272, trx_id = 68, type = 12, cmpl_info = 0, update = 0x7f43a420a488, heap = 0x7f43a42347b8, mtr = {m_start = true, m_commit = true, m_freeing_tree = false, m_last = 0x0, m_last_offset = 0, m_log_mode = 0, m_modifications = 0, m_made_dirty = 0, m_inside_ibuf = 0, m_trim_pages = 0, m_user_space_id = 0, m_memo = {m_heap = 0x0, m_list = {<ilist<mtr_buf_t::block_t, void>> = {sentinel_ = {next = 0x7f43ff566600, prev = 0x7f43ff566600}}, size_ = 1}, m_size = 0, m_first_block = {<ilist_node<void>> = {next = 0x7f43ff5665e0, prev = 0x7f43ff5665e0}, m_buf_end = 0, m_magic_n = 375767, m_data = "\000\000\000\000\000\000\000\000 \000\000\000\346U\000\000\000\000\000\000\000\000\000\000\001", '\000' <repeats 15 times>, "\002\000\000\000D\177\000\000@\"\277\tD\177\000\000\000\000\000\000\000\000\000\000\200fV\377C\177\000\000N\032\372\n\346U\000\000\320fV\377C\177\000\000\000r\260\tD\177\000\000\240fV\377C\177\000\000`\336\371\n\346U\000\000\330{\260\tD\177\000\000\360]\021\nD\177\000\000\320fV\377C\177\000\000\242\337\371\n\346U\000\000\330{\260\tD\177\000\000\330{\260\tD\177\000\000 \001\000\000\000\000\000\000\000\067\211\tq\036\000\000\060gV\377C\177\000\000\002~\370\n\346U\000\000\300\213\065\006\000\000\000\000"..., m_used = 0}}, m_log = {m_heap = 0x0, m_list = {<ilist<mtr_buf_t::block_t, void>> = {sentinel_ = {next = 0x7f43ff566840, prev = 0x7f43ff566840}}, size_ = 1}, m_size = 0, m_first_block = {<ilist_node<void>> = {next = 0x7f43ff566820, prev = 0x7f43ff566820}, m_buf_end = 0, m_magic_n = 375767, m_data = "\250\222\005\244C\177\000\000p\000\324\377C\177\000\000\003\000\000\000\a\000\000\000\005\203\372\n\000U\000\000\300\213\065\006D\177\000\000\000\000\000\000\000\000\000\000\001\000\000\000\000\000\000\000\270\260\326\016\346U\000\000\220\033\252\016\346U\000\000\300\213\065\006D\177\000\000\340hV\377C\177\000\000\322\357\370\n\346U\000\000\340hV\377C\177\000\000\300\213\065\006D\177\000\000\000iV\377C\177\000\000\300\213\065\006\006\000\000\000\020iV\377C\177\000\000\310D\246\f\346U\000\000\000\000\000\000\002\000\000\000\300\213\065\006\001\000\000\000\001\000\000\000\003\000\000\000\314D\246\f\346U\000\000\060iV\377C\177\000\000\312,\022\v\346U\000\000\000\000\000\000\001\000\000\200"..., m_used = 0}}, m_user_space = 0x0, m_commit_lsn = 0, m_freed_space = 0x0, m_freed_pages = 0x0}}
#12 0x000055e60b2c29ed in trx_t::commit_low (this=0x7f4404831b80, mtr=0x7f43ff566cf0) at /data/src/10.6/storage/innobase/trx/trx0trx.cc:1433
__PRETTY_FUNCTION__ = "void trx_t::commit_low(mtr_t*)"
aborted = false
debug_sync = true
#13 0x000055e60b2c3b57 in trx_t::commit_persist (this=0x7f4404831b80) at /data/src/10.6/storage/innobase/trx/trx0trx.cc:1472
mtr = 0x7f43ff566cf0
local_mtr = {m_start = true, m_commit = false, m_freeing_tree = false, m_last = 0x0, m_last_offset = 0, m_log_mode = 0, m_modifications = 0, m_made_dirty = 0, m_inside_ibuf = 0, m_trim_pages = 0, m_user_space_id = 0, m_memo = {m_heap = 0x0, m_list = {<ilist<mtr_buf_t::block_t, void>> = {sentinel_ = {next = 0x7f43ff566d30, prev = 0x7f43ff566d30}}, size_ = 1}, m_size = 0, m_first_block = {<ilist_node<void>> = {next = 0x7f43ff566d10, prev = 0x7f43ff566d10}, m_buf_end = 0, m_magic_n = 375767, m_data = "pmV\377", '\000' <repeats 12 times>, "PnV\377C\177\000\000\026", '\000' <repeats 47 times>, "\250\222\005\244C\177\000\000\001\000\000\000\000\000\000\000\350\252\267\244C\177\000\000\b\251\267\244C\177\000\000\200\033\203\004D\177\000\000\060\256\267\244C\177\000\000\250\222\005\244C\177\000\000\360mV\377C\177\000\000P\372\a\v\346U\000\000\002\000\000\000\000\000\000\000HqV\377C\177\000\000\020nV\377C\177\000\000\312\371\a\v\346U\000\000\060nV\377C\177\000\000HqV\377C\177\000\000\000\001\222\v\346U\000\000"..., m_used = 0}}, m_log = {m_heap = 0x0, m_list = {<ilist<mtr_buf_t::block_t, void>> = {sentinel_ = {next = 0x7f43ff566f70, prev = 0x7f43ff566f70}}, size_ = 1}, m_size = 0, m_first_block = {<ilist_node<void>> = {next = 0x7f43ff566f50, prev = 0x7f43ff566f50}, m_buf_end = 0, m_magic_n = 375767, m_data = "\000\000\000\000\004\000\000\000\340qV\377\000\000\000\000\266\326\221\v\346U\000\000\000\000\000\000\000\000\000\000\320oV\377C\177\000\000\236\300O\v\000\000\001\000\360oV\377C\177\000\000\037\276R\v\346U\000\000\360oV\377C\177\000\000\340\f\000\244C\177\000\000\340\f\000\244C\177\000\000\270\f\000\244\001\000\000\000\060rV\377C\177\000\000\221\260R\v\346U\000\000\070c9\nD\177\000\000PrV\377C\177\000\000\n\000\000\000\000\000\000\000\340\f\000\244C\177\000\000\233\372a\v\346U\000\000\000\000\000\000\000\000\000\000PpV\377C\177\000\000\236\300O\v\000\000\001\000ppV\377C\177\000\000\037\276R\v\346U\000\000ppV\377C\177\000\000"..., m_used = 0}}, m_user_space = 0x0, m_commit_lsn = 0, m_freed_space = 0x0, m_freed_pages = 0x0}
#14 0x000055e60b2c3c48 in trx_t::commit (this=0x7f4404831b80) at /data/src/10.6/storage/innobase/trx/trx0trx.cc:1481
__PRETTY_FUNCTION__ = "void trx_t::commit()"
#15 0x000055e60b2c40af in trx_commit_for_mysql (trx=0x7f4404831b80) at /data/src/10.6/storage/innobase/trx/trx0trx.cc:1598
No locals.
#16 0x000055e60b056879 in innobase_commit_low (trx=0x7f4404831b80) at /data/src/10.6/storage/innobase/handler/ha_innodb.cc:4415
tmp = 0x0
is_wsrep = false
#17 0x000055e60b056bab in innobase_commit_ordered_2 (trx=0x7f4404831b80, thd=0x7f43a4000db8) at /data/src/10.6/storage/innobase/handler/ha_innodb.cc:4521
_db_stack_frame_ = {func = 0x55e60b91e315 "innobase_commit", file = 0x55e60b91b2c8 "/data/src/10.6/storage/innobase/handler/ha_innodb.cc", level = 2147483658, line = -1, prev = 0x7f43ff5672f0}
read_only = false
#18 0x000055e60b057101 in innobase_commit (hton=0x55e60ec78e98, thd=0x7f43a4000db8, commit_trx=false) at /data/src/10.6/storage/innobase/handler/ha_innodb.cc:4625
_db_stack_frame_ = {func = 0x55e60b7faff7 "commit_one_phase_2", file = 0x55e60b7fa15c "/data/src/10.6/sql/handler.cc", level = 2147483657, line = -1, prev = 0x7f43ff567380}
__PRETTY_FUNCTION__ = "int innobase_commit(handlerton, THD, bool)"
trx = 0x7f4404831b80
read_only = false
#19 0x000055e60ac4ac32 in commit_one_phase_2 (thd=0x7f43a4000db8, all=false, trans=0x7f43a4004720, is_real_trans=true) at /data/src/10.6/sql/handler.cc:2070
ht = 0x55e60ec78e98
err = 21990
error = 0
count = 0
ha_info = 0x7f43a4003868
ha_info_next = 0x7f43a400ad08
_db_stack_frame_ = {func = 0x55e60b7fafe3 "ha_commit_one_phase", file = 0x55e60b7fa15c "/data/src/10.6/sql/handler.cc", level = 2147483656, line = -1, prev = 0x7f43ff5673e0}
#20 0x000055e60ac4a9ef in ha_commit_one_phase (thd=0x7f43a4000db8, all=false) at /data/src/10.6/sql/handler.cc:2023
trans = 0x7f43a4004720
is_real_trans = true
res = 0
_db_stack_frame_ = {func = 0x55e60b7fa8d3 "ha_commit_trans", file = 0x55e60b7fa15c "/data/src/10.6/sql/handler.cc", level = 2147483655, line = -1, prev = 0x7f43ff567490}
#21 0x000055e60ac49b37 in ha_commit_trans (thd=0x7f43a4000db8, all=false) at /data/src/10.6/sql/handler.cc:1817
error = 0
cookie = 21990
trans = 0x7f43a4004720
is_real_trans = true
ha_info = 0x7f43a4003868
need_prepare_ordered = false
need_commit_ordered = false
xid = 139930203412944
run_wsrep_hooks = false
_db_stack_frame_ = {func = 0x55e60b66c17b "trans_commit_stmt", file = 0x55e60b66bb20 "/data/src/10.6/sql/transaction.cc", level = 2147483654, line = -1, prev = 0x7f43ff567db0}
__PRETTY_FUNCTION__ = "int ha_commit_trans(THD*, bool)"
rw_ha_count = 1
rw_trans = true
mdl_backup = {type = 13, duration = MDL_EXPLICIT, next_in_list = 0xa4000cb8, prev_in_list = 0x55e60ba61cdc, ticket = 0x7f43a4162c00, key = {m_length = 3, m_db_name_length = 0, m_hash_value = 65537, m_ptr = "\000\000\000\v\000\000\001\000\020uV\377C\177\000\000\037\276R\v\346U\000\000\020uV\377C\177\000\000\340\f\000\244C\177\000\000\340\f\000\244C\177\000\000\270\f\000\244\001\000\000\000PwV\377C\177\000\000\221\260R\v\346U\000\000@uV\377C\177\000\000\240wV\377C\177\000\000\006\000\000\000C\177\000\000\340\f\000\244C\177\000\000`uV\377C\177\000\000\340\f\000\244C\177\000\000\340\f\000\244C\177\000\000\270\f\000\244\366\377\377\377\271{V\377C\177", '\000' <repeats 26 times>, "\266\326\221\v\346U\000\000\000\000\000\000\000\000\000\000\260uV\377C\177\000\000\236\300O\v\000\000\000\000"...}, m_src_file = 0x55e60b7fa15c "/data/src/10.6/sql/handler.cc", m_src_line = 1728}
#22 0x000055e60aa84e60 in trans_commit_stmt (thd=0x7f43a4000db8) at /data/src/10.6/sql/transaction.cc:472
_db_stack_frame_ = {func = 0x55e60b617cd0 "mysql_execute_command", file = 0x55e60b616fa8 "/data/src/10.6/sql/sql_parse.cc", level = 2147483653, line = -1, prev = 0x7f43ff567f70}
res = 0
__PRETTY_FUNCTION__ = "bool trans_commit_stmt(THD*)"
#23 0x000055e60a8be0e3 in mysql_execute_command (thd=0x7f43a4000db8, is_called_from_prepared_stmt=false) at /data/src/10.6/sql/sql_parse.cc:6056
res = 0
up_result = 0
lex = 0x7f43a4005058
select_lex = 0x7f43a4005918
first_table = 0x7f43a4015690
all_tables = 0x7f43a4015690
unit = 0x7f43a4005120
have_table_map_for_update = false
rpl_filter = 0x55e60b8421f2
_db_stack_frame_ = {func = 0x55e60b619037 "mysql_parse", file = 0x55e60b616fa8 "/data/src/10.6/sql/sql_parse.cc", level = 2147483652, line = -1, prev = 0x7f43ff568380}
__PRETTY_FUNCTION__ = "int mysql_execute_command(THD*, bool)"
ots = {ctx = 0x7f43a4004d20, traceable = false}
orig_binlog_format = BINLOG_FORMAT_MIXED
orig_current_stmt_binlog_format = BINLOG_FORMAT_STMT
#24 0x000055e60a8c3ab0 in mysql_parse (thd=0x7f43a4000db8, rawbuf=0x7f43a40155c0 "UPDATE t SET a = 'foo'", length=22, parser_state=0x7f43ff568500) at /data/src/10.6/sql/sql_parse.cc:8029
found_semicolon = 0x0
error = 32579
lex = 0x7f43a4005058
err = false
_db_stack_frame_ = {func = 0x55e60b617521 "dispatch_command", file = 0x55e60b616fa8 "/data/src/10.6/sql/sql_parse.cc", level = 2147483651, line = -1, prev = 0x7f43ff5684e0}
__PRETTY_FUNCTION__ = "void mysql_parse(THD, char, uint, Parser_state*)"
#25 0x000055e60a8b0113 in dispatch_command (command=COM_QUERY, thd=0x7f43a4000db8, packet=0x7f43a400b879 "UPDATE t SET a = 'foo'", packet_length=22, blocking=true) at /data/src/10.6/sql/sql_parse.cc:1896
packet_end = 0x7f43a40155d6 ""
parser_state = {m_lip = {lookahead_token = -1, lookahead_yylval = 0x0, m_thd = 0x7f43a4000db8, m_ptr = 0x7f43a40155d7 "\004", m_tok_start = 0x7f43a40155d7 "\004", m_tok_end = 0x7f43a40155d7 "\004", m_end_of_query = 0x7f43a40155d6 "", m_tok_start_prev = 0x7f43a40155d6 "", m_buf = 0x7f43a40155c0 "UPDATE t SET a = 'foo'", m_buf_length = 22, m_echo = true, m_echo_saved = false, m_cpp_buf = 0x7f43a4015630 "UPDATE t SET a = 'foo'", m_cpp_ptr = 0x7f43a4015646 "", m_cpp_tok_start = 0x7f43a4015646 "", m_cpp_tok_start_prev = 0x7f43a4015646 "", m_cpp_tok_end = 0x7f43a4015646 "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0x1a4000cb8 <error: Cannot access memory at address 0x1a4000cb8>, m_cpp_utf8_processed_ptr = 0x0, next_state = MY_LEX_END, found_semicolon = 0x0, ignore_space = false, stmt_prepare_mode = false, multi_statements = true, yylineno = 1, m_digest = 0x0, in_comment = NO_COMMENT, in_comment_saved = (unknown: 0x10000), m_cpp_text_start = 0x7f43a4015642 "foo'", m_cpp_text_end = 0x7f43a4015645 "'", m_underscore_cs = 0x0}, m_yacc = {yacc_yyss = 0x0, yacc_yyvs = 0x0, m_set_signal_info = {m_item = {0x0 <repeats 12 times>}}, m_lock_type = TL_READ_DEFAULT, m_mdl_type = MDL_SHARED_READ}, m_digest_psi = 0x7f43a4004ab0}
net = 0x7f43a40010f0
error = false
do_end_of_statement = true
_db_stack_frame_ = {func = 0x55e60b6171a5 "do_command", file = 0x55e60b616fa8 "/data/src/10.6/sql/sql_parse.cc", level = 2147483650, line = -1, prev = 0x7f43ff568dc0}
drop_more_results = false
__PRETTY_FUNCTION__ = "dispatch_command_return dispatch_command(enum_server_command, THD, char, uint, bool)"
__FUNCTION__ = "dispatch_command"
res = <optimized out>
#26 0x000055e60a8aeb0e in do_command (thd=0x7f43a4000db8, blocking=true) at /data/src/10.6/sql/sql_parse.cc:1409
return_value = DISPATCH_COMMAND_SUCCESS
packet = 0x7f43a400b878 "\003UPDATE t SET a = 'foo'"
packet_length = 23
net = 0x7f43a40010f0
command = COM_QUERY
_db_stack_frame_ = {func = 0x55e60ba6a220 "?func", file = 0x55e60ba6a226 "?file", level = 2147483649, line = -1, prev = 0x0}
__PRETTY_FUNCTION__ = "dispatch_command_return do_command(THD*, bool)"
__FUNCTION__ = "do_command"
#27 0x000055e60aa68c68 in do_handle_one_connection (connect=0x55e60f1499b8, put_in_cache=true) at /data/src/10.6/sql/sql_connect.cc:1418
create_user = true
thr_create_utime = 1370698081971
thd = 0x7f43a4000db8
__PRETTY_FUNCTION__ = "void do_handle_one_connection(CONNECT*, bool)"
#28 0x000055e60aa68907 in handle_one_connection (arg=0x55e60f147938) at /data/src/10.6/sql/sql_connect.cc:1312
connect = 0x55e60f147938
#29 0x000055e60af8412c in pfs_spawn_thread (arg=0x55e60f148b58) at /data/src/10.6/storage/perfschema/pfs.cc:2201
typed_arg = 0x55e60f148b58
user_arg = 0x55e60f147938
user_start_routine = 0x55e60aa688ac <handle_one_connection(void*)>
pfs = 0x7f4409af7d40
klass = 0x55e60ea9f900
#30 0x00007f440a6bcea7 in start_thread (arg=<optimized out>) at pthread_create.c:477
ret = <optimized out>
pd = <optimized out>
unwind_buf = {cancel_jmp_buf = {{jmp_buf = {139930023401216, -7256842421782948413, 140729311178398, 140729311178399, 139930023399296, 311296, 7335654509590631875, 7332582106867848643}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}}
not_first_call = 0
#31 0x00007f440a2b9def in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

10.6 non-debug 51ca5d51
#2 0x000056466bd62ce0 in handle_fatal_signal (sig=11) at /data/src/10.6/sql/signal_handler.cc:345
curr_time = 1654948777
tm = {tm_sec = 37, tm_min = 59, tm_hour = 14, tm_mday = 11, tm_mon = 5, tm_year = 122, tm_wday = 6, tm_yday = 161, tm_isdst = 1, tm_gmtoff = 10800, tm_zone = 0x56466e5597f0 "EEST"}
thd = 0x7f2790000c58
print_invalid_query_pointer = false
#3 <signal handler called>
No locals.
#4 row_log_online_op (index=index@entry=0x7f278401cb00, tuple=0x0, trx_id=trx_id@entry=0) at /data/src/10.6/storage/innobase/row/row0log.cc:286
start_log = <optimized out>
b = <optimized out>
extra_size = 1
size = <optimized out>
mrec_size = <optimized out>
avail_size = <optimized out>
log = <optimized out>
success = true
#5 0x000056466c138800 in UndorecApplier::log_update (this=this@entry=0x7f27f4056b30, tuple=<optimized out>, clust_index=clust_index@entry=0x7f279011a400) at /data/src/10.6/storage/innobase/row/row0log.cc:4067
old_entry = <optimized out>
new_entry = <optimized out>
offsets_ = {300, 5, 32774, 6, 12, 19, 27, 31, 0, 0, 0, 0, 0, 0, 0, 0, 32, 0, 0, 0, 32, 36864, 33299, 61247, 0, 0, 0, 0, 47048, 28306, 22086, 0, 7752, 36867, 32551, 0, 20602, 63747, 32551, 0, 11520, 27842, 22086, 0 <repeats 13 times>, 16, 0, 8, 0, 0, 0, 0, 0, 300, 0, 0, 0, 78, 0, 0, 0, 1056, 0, 0, 0, 16, 0, 0, 0, 25136, 62469, 32551, 0, 49321, 27557, 22086, 0, 0, 0, 0, 0, 93, 0, 119, 0, 2, 0, 0, 0, 63475, 27644, 22086, 0, 0, 0, 0, 0, 13456, 27850, 22086, 0, 25064, 62469, 32551, 0, 0, 0, 32551, 0, 13456, 27850, 22086, 0, 25088, 62469, 32551, 0, 0, 0, 0, 0, 984, 0, 0, 0, 13456, 27850, 22086, 0, 25120, 62469, 32551, 0, 0, 0, 32551, 0, 13456, 27850, 22086, 0, 25144, 62469, 32551, 0, 0, 0, 0, 0, 13456, 27850, 22086, 0, 25168, 62469, 32551, 0, 0, 0, 197, 0, 13456, 27850, 22086, 0, 300, 62469, 32551, 0, 0, 0, 22086, 0, 13456, 27850, 22086, 0, 25216, 62469, 32551, 0, 0, 0, 0, 0, 13456, 27850, 22086, 0, 25240, 62469, 32551...}
offsets2_ = {300, 0, 0, 0, 32, 36864, 32551, 0, 520, 0, 0, 0, 12672, 36890, 32551, 0, 0, 0, 0, 0, 520, 0, 0, 0, 544, 0, 0, 0, 7832, 36867, 32551, 0, 26016, 62469, 32551, 0, 42440, 27661, 22086, 0, 29048, 62469, 32551, 0, 30465, 27670, 22086, 0, 27392, 62469, 32551, 0, 27488, 62469, 32551, 0, 48, 0, 0, 0, 0, 0, 0, 0, 36032, 60992, 32551, 256, 7832, 36867, 32551, 0, 25644, 62469, 32551, 0, 1, 0, 0, 0, 25656, 62469, 32551, 0, 12872, 36890, 32551, 0, 0, 0, 0, 0, 25, 256, 65535, 65535, 0, 0, 3, 0, 0, 0, 0, 0, 41984, 0, 0, 0, 7808, 36867, 32551, 0, 0, 0, 0, 0, 208, 0, 0, 0, 232, 0, 0, 0, 0, 0, 0, 0, 26208, 62469, 32551, 0, 42440, 27661, 22086, 0, 0, 0, 0, 0, 1, 0, 0, 0, 32, 0, 0, 0, 256, 0, 1, 0, 32, 0, 0, 0, 12800, 36890, 32551, 0, 36192, 60992, 32551, 0, 24, 4, 0, 0, 0, 0, 0, 0, 25832, 62469, 32551, 0, 25832, 62469, 32551, 0, 1, 0, 0, 0, 0, 0, 0, 0, 25800, 62469, 32551, 0, 25800, 62469, 32551, 0, 0, 0, 0, 0...}
offsets = 0x7f27f4056110
prev_offsets = 0x7f27f4056370
table = <optimized out>
table_rebuild = <optimized out>
rec = 0x7f27ee8cc0b8 ""
prev_version = 0x0
is_update = true
match_rec = <optimized out>
row = 0x7f27901a3430
new_ext = 0x0
old_ext = 0x0
old_row = 0x7f27901a34f0
success = true
index = 0x7f278401cb00
#6 0x000056466c17eaa4 in UndorecApplier::apply_undo_rec (this=0x7f27f4056b30) at /data/src/10.6/storage/innobase/trx/trx0undo.cc:352
trx_id = 22
roll_ptr = 37154696946123389
info_bits = 0 '\000'
updated_extern = false
undo_no = 0
table_id = 18
table = <optimized out>
index = 0x7f279011a400
undo_tuple = 0x7f27901a3200
#7 0x000056466b9eebe5 in trx_t::apply_log (this=this@entry=0x7f27ef3feb80) at /data/src/10.6/storage/innobase/trx/trx0undo.cc:387
rec = <optimized out>
next = <optimized out>
undo = 0x7f27901967d8
page_id = {m_id = 314}
next_page_id = {m_id = 314}
mtr = {m_last = 0x0, m_last_offset = 0, m_log_mode = 0, m_modifications = 0, m_made_dirty = 0, m_inside_ibuf = 0, m_trim_pages = 0, m_memo = {m_heap = 0x0, m_list = {<ilist<mtr_buf_t::block_t, void>> = {sentinel_ = {next = 0x7f27f40566d8, prev = 0x7f27f40566d8}}, size_ = 1}, m_size = 0, m_first_block = {<ilist_node<void>> = {next = 0x7f27f40566b8, prev = 0x7f27f40566b8}, m_data = "\000\000\000\000\000\000\000\000\001\000\000\000\000\000\000\000\030g\005\364'\177\000\000\030g\005\364'\177\000\000\001\000\000\000\000\000\000\000\020\000\000\000\000\000\000\000\370f\005\364'\177\000\000\370f\005\364'\177\000\000)\005\004\006\063\b\000\r\000\001\000oo \000\000\000\000\002\000\000m\005\364'\177\000\000\270\232\021lFV\000\000\200g\005\364'\177\000\000\237\000\000\000\000\000\000\000\300g\005\364'\177\000\000\270\343\002lFV\000\000\200\353?\357'\177\000\000n\256\000\220'\177\000\000\340g\005\364'\177\000\000n\256\000\220'\177\000\000\020\037\032\220'\177\000\000\340t\005\364'\177\000\000\360\337\024\220'\177\000\000\001\000\000\000\000\000\000\000"..., m_used = 0}}, m_log = {m_heap = 0x0, m_list = {<ilist<mtr_buf_t::block_t, void>> = {sentinel_ = {next = 0x7f27f4056908, prev = 0x7f27f4056908}}, size_ = 1}, m_size = 0, m_first_block = {<ilist_node<void>> = {next = 0x7f27f40568e8, prev = 0x7f27f40568e8}, m_data = "D\370\374k\000\000\000\000\350*\003\220'\177\000\000$\277", '\000' <repeats 30 times>, "}Z\020lFV\000\000\000\000\000\000\000\000\000\000h\001\000\000\000\000\000\000\200\001", '\000' <repeats 14 times>, "`k\005\364'\177\000\000\310\245\rlFV\000\000\000\000\000\000\000\000\000\000\001", '\000' <repeats 11 times>, "\377\377\377\377@O\003\371'\177", '\000' <repeats 18 times>, "-\000\000\000\000\000\000\000\233\300\214\356'\177\000\000\360\002\000\000\000\000\000\000\b\000\000\000\000\000\000\000p\300\214\356'\177\000\000\335\300\214\356'\177\000\000"..., m_used = 0}}, m_user_space = 0x0, m_commit_lsn = 0, m_freed_space = 0x0, m_freed_pages = 0x0}
block = <optimized out>
log_applier = {page_id = {m_id = 314}, undo_rec = 0x7f2790031f21 "", offset = 272, trx_id = 30, type = 12, cmpl_info = 0, update = 0x7f27901a3248, heap = 0x7f2790031e98, mtr = {m_last = 0x0, m_last_offset = 0, m_log_mode = 0, m_modifications = 0, m_made_dirty = 0, m_inside_ibuf = 0, m_trim_pages = 0, m_memo = {m_heap = 0x0, m_list = {<ilist<mtr_buf_t::block_t, void>> = {sentinel_ = {next = 0x7f27f4056ba8, prev = 0x7f27f4056ba8}}, size_ = 1}, m_size = 0, m_first_block = {<ilist_node<void>> = {next = 0x7f27f4056b88, prev = 0x7f27f4056b88}, m_data = "\000\000\000\000\000\000\000\000 ", '\000' <repeats 15 times>, "\001\000\000\000'\177\000\000\000\000\000\000\000\000\000\000\002\000\000\000'\177\000\000\320\027\375kFV\000\000H/\032\220\317\000\000\000(m\374kFV\000\000h\004\000\000\000\000\000\000\200RRmFV\000\000@l\005\364'\177\000\000\214RRmFV\000\000\001\000\000\000\000\000\000\000\320\027\375kFV\000\000\240l\005\364\305\000\000\000(m\374kFV\000\000\200\354?\357'\177\000\000\200RRmFV\000\000\200l\005\364'\177\000\000\214RRmFV\000\000\001\000\000\000\000\000\000\000\000\371\301lFV\000\000\340l\005\364'\177\000\000u\305\025lFV\000\000"..., m_used = 0}}, m_log = {m_heap = 0x0, m_list = {<ilist<mtr_buf_t::block_t, void>> = {sentinel_ = {next = 0x7f27f4056dd8, prev = 0x7f27f4056dd8}}, size_ = 1}, m_size = 0, m_first_block = {<ilist_node<void>> = {next = 0x7f27f4056db8, prev = 0x7f27f4056db8}, m_data = "\001\000\000\220'\177\000\000\030$\032\220'\177\000\000\001", '\000' <repeats 15 times>, "\340t\005\364'\177\000\000B\000\000\000\000\000!\000\360 \032\220'\177\000\000\001", '\000' <repeats 15 times>, "\350\005\032\220'\177\000\000\200\353?\357'\177\000\000\000\000\000\000\000\000\000\001\335\005\000\000w", '\000' <repeats 11 times>, "D\370\374kFV", '\000' <repeats 18 times>, "\240n\005\364'\177\000\000 \000\000\220'\177", '\000' <repeats 34 times>, ",\001\001\000\005\200\b\000\000\000\000\000\000\000\000\000"..., m_used = 0}}, m_user_space = 0x0, m_commit_lsn = 0, m_freed_space = 0x0, m_freed_pages = 0x0}}
#8 0x000056466b9ee2aa in trx_t::commit_low (this=0x7f27ef3feb80, mtr=0x7f27f40570a0) at /data/src/10.6/storage/innobase/trx/trx0trx.cc:1433
No locals.
#9 0x000056466c17a925 in trx_t::commit_persist (this=0x7f27ef3feb80) at /data/src/10.6/storage/innobase/trx/trx0trx.cc:1472
mtr = <optimized out>
local_mtr = {m_last = 0x0, m_last_offset = 0, m_log_mode = 0, m_modifications = 0, m_made_dirty = 0, m_inside_ibuf = 0, m_trim_pages = 0, m_memo = {m_heap = 0x0, m_list = {<ilist<mtr_buf_t::block_t, void>> = {sentinel_ = {next = 0x7f27f40570d8, prev = 0x7f27f40570d8}}, size_ = 1}, m_size = 0, m_first_block = {<ilist_node<void>> = {next = 0x7f27f40570b8, prev = 0x7f27f40570b8}, m_data = "\230\061\032\220'\177\000\000\230\061\032\220'\177\000\000 \257\016\220'\177\000\000\000\000\000\000\000\000\000\000\260\020\025lFV\000\000pq\005\364'\177\000\000]\000\000\000w", '\000' <repeats 11 times>, "\212\000\215\356'\177\000\000\000\062\032\220'\177\000\000\200\353?\357'\177\000\000\320'\032\220'\177\000\000\270$\032\220'\177\000\000\250\004\032\220'\177\000\000\230\061\032\220'\177\000\000\020\020\000\000\000\000\000\000\330\003\000\000\000\000\000\000 \257\016\220'\177", '\000' <repeats 50 times>, "\320'\032\220'\177\000\000"..., m_used = 0}}, m_log = {m_heap = 0x0, m_list = {<ilist<mtr_buf_t::block_t, void>> = {sentinel_ = {next = 0x7f27f4057308, prev = 0x7f27f4057308}}, size_ = 1}, m_size = 0, m_first_block = {<ilist_node<void>> = {next = 0x7f27f40572e8, prev = 0x7f27f40572e8}, m_data = "\000\371\301lFV\000\000\000\000\000\000\000\000\000\000Ps\005\364'\177\000\000\000\000\000\000\000\000\000\000\060)\000\220'\177\000\000\240s\005\364'\177\000\000C\333\240kFV\000\000\a\000\000\000'\177\000\000\300\350\025\365'\177\000\000@F\215\370'\177\000\000\354k\240\034\231\210\021\000\340>\377kFV\000\000-\372\375kFV", '\000' <repeats 18 times>, "\001", '\000' <repeats 15 times>, "\310\001", '\000' <repeats 14 times>, "\060t\005\364'\177\000\000\000\353\233\366'\177\000\000\360s\005\364'\177\000\000X\004PmFV\000\000\060t\005\364'\177\000\000\270\343\002lFV\000\000"..., m_used = 0}}, m_user_space = 0x0, m_commit_lsn = 0, m_freed_space = 0x0, m_freed_pages = 0x0}
#10 0x000056466c17ab12 in trx_t::commit (this=0x7f27ef3feb80) at /data/src/10.6/storage/innobase/trx/trx0trx.cc:1481
No locals.
#11 trx_commit_for_mysql (trx=trx@entry=0x7f27ef3feb80) at /data/src/10.6/storage/innobase/trx/trx0trx.cc:1598
No locals.
#12 0x000056466c06f620 in innobase_commit_low (trx=<optimized out>) at /data/src/10.6/storage/innobase/handler/ha_innodb.cc:4415
tmp = 0x0
is_wsrep = <optimized out>
tmp = <optimized out>
is_wsrep = <optimized out>
#13 innobase_commit_ordered_2 (thd=0x7f2790000c58, trx=0x7f27ef3feb80) at /data/src/10.6/storage/innobase/handler/ha_innodb.cc:4521
read_only = <optimized out>
read_only = <optimized out>
#14 innobase_commit (hton=<optimized out>, thd=0x7f2790000c58, commit_trx=<optimized out>) at /data/src/10.6/storage/innobase/handler/ha_innodb.cc:4625
trx = 0x7f27ef3feb80
read_only = <optimized out>
#15 0x000056466bd66499 in commit_one_phase_2 (thd=thd@entry=0x7f2790000c58, all=<optimized out>, trans=0x7f2790004410, is_real_trans=<optimized out>) at /data/src/10.6/sql/handler.cc:2070
ht = 0x56466e737268
err = <optimized out>
error = 0
count = 0
ha_info = 0x7f2790003558
ha_info_next = <optimized out>
#16 0x000056466bd666e4 in ha_commit_one_phase (thd=thd@entry=0x7f2790000c58, all=all@entry=false) at /data/src/10.6/sql/handler.cc:2023
trans = <optimized out>
is_real_trans = <optimized out>
res = <optimized out>
#17 0x000056466bd734ae in ha_commit_trans (thd=thd@entry=0x7f2790000c58, all=all@entry=false) at /data/src/10.6/sql/handler.cc:1817
error = <optimized out>
cookie = <optimized out>
trans = <optimized out>
is_real_trans = true
ha_info = <optimized out>
need_prepare_ordered = <optimized out>
need_commit_ordered = <optimized out>
xid = <optimized out>
run_wsrep_hooks = <optimized out>
rw_ha_count = 1
rw_trans = <optimized out>
mdl_backup = {type = 13, duration = MDL_EXPLICIT, next_in_list = 0x91e0000000000, prev_in_list = 0x6f6f664a013a0100, ticket = 0x7f279000af30, key = {m_length = 3, m_db_name_length = 0, m_hash_value = 65537, m_ptr = "\000\000\000kFV\000\000\001", '\000' <repeats 15 times>, "$", '\000' <repeats 15 times>, "\b\001\000\000\000\000\000\000\000\245\016\220'\177\000\000\000\000\000\000\000\000\000\000$\000\000\000\000\000\000\000\004\000\000\000\000\000\000\000\354x\005\364'\177\000\000\320x\005\364'\177\000\000f\302\032lFV\000\000\260y\005\364'\177\000\000\001\000\000\000\000\000\000\000\b\001", '\000' <repeats 14 times>, "{\000\000\000\000\000\000\000\200\353?\357", '\000' <repeats 12 times>, "Hw\005\364'\177\000\000Hw\005\364'\177\000\000\001", '\000' <repeats 15 times>, "(w\005\364'\177\000\000"...}, m_src_file = 0x56466c59c464 "/data/src/10.6/sql/handler.cc", m_src_line = 1728}
#18 0x000056466bc57953 in trans_commit_stmt (thd=thd@entry=0x7f2790000c58) at /data/src/10.6/sql/transaction.cc:472
res = 0
#19 0x000056466bb33829 in mysql_execute_command (thd=0x7f2790000c58, is_called_from_prepared_stmt=<optimized out>) at /data/src/10.6/sql/sql_parse.cc:6056
multi_delete_error = <optimized out>
wsrep_error_label = <optimized out>
error = <optimized out>
res = 0
up_result = <optimized out>
lex = 0x7f2790004d38
select_lex = <optimized out>
first_table = <optimized out>
all_tables = 0x7f2790010a10
unit = 0x7f2790004e00
have_table_map_for_update = <optimized out>
rpl_filter = <optimized out>
ots = {ctx = 0x7f2790004a08, traceable = false}
orig_binlog_format = <optimized out>
orig_current_stmt_binlog_format = <optimized out>
#20 0x000056466bb386e7 in mysql_parse (thd=0x7f2790000c58, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>) at /data/src/10.6/sql/sql_parse.cc:8029
found_semicolon = <optimized out>
error = <optimized out>
lex = 0x7f2790004d38
err = <optimized out>
#21 0x000056466bb3afad in dispatch_command (command=COM_QUERY, thd=0x7f2790000c58, packet=<optimized out>, packet_length=<optimized out>, blocking=<optimized out>) at /data/src/10.6/sql/sql_class.h:234
packet_end = 0x7f2790010956 ""
parser_state = {m_lip = {lookahead_token = -1, lookahead_yylval = 0x0, m_thd = 0x7f2790000c58, m_ptr = 0x7f2790010957 "\004", m_tok_start = 0x7f2790010957 "\004", m_tok_end = 0x7f2790010957 "\004", m_end_of_query = 0x7f2790010956 "", m_tok_start_prev = 0x7f2790010956 "", m_buf = 0x7f2790010940 "UPDATE t SET a = 'foo'", m_buf_length = 22, m_echo = true, m_echo_saved = false, m_cpp_buf = 0x7f27900109b0 "UPDATE t SET a = 'foo'", m_cpp_ptr = 0x7f27900109c6 "", m_cpp_tok_start = 0x7f27900109c6 "", m_cpp_tok_start_prev = 0x7f27900109c6 "", m_cpp_tok_end = 0x7f27900109c6 "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0x0, m_cpp_utf8_processed_ptr = 0x0, next_state = MY_LEX_END, found_semicolon = 0x0, ignore_space = false, stmt_prepare_mode = false, multi_statements = true, yylineno = 1, m_digest = 0x0, in_comment = NO_COMMENT, in_comment_saved = NO_COMMENT, m_cpp_text_start = 0x7f27900109c2 "foo'", m_cpp_text_end = 0x7f27900109c5 "'", m_underscore_cs = 0x0}, m_yacc = {yacc_yyss = 0x0, yacc_yyvs = 0x0, m_set_signal_info = {m_item = {0x0 <repeats 12 times>}}, m_lock_type = TL_READ_DEFAULT, m_mdl_type = MDL_SHARED_READ}, m_digest_psi = 0x7f2790004798}
net = 0x7f2790000f08
error = false
do_end_of_statement = true
drop_more_results = false
__FUNCTION__ = "dispatch_command"
res = <optimized out>
#22 0x000056466bb3cc62 in do_command (thd=0x7f2790000c58, blocking=blocking@entry=true) at /data/src/10.6/sql/sql_parse.cc:1409
return_value = <optimized out>
packet = 0x7f27900f8e18 "\003UPDATE t SET a = 'foo'"
packet_length = <optimized out>
net = 0x7f2790000f08
command = COM_QUERY
__FUNCTION__ = "do_command"
#23 0x000056466bc47a9f in do_handle_one_connection (connect=<optimized out>, put_in_cache=true) at /data/src/10.6/sql/sql_connect.cc:1418
create_user = true
thr_create_utime = <optimized out>
thd = 0x7f2790000c58
#24 0x000056466bc47ded in handle_one_connection (arg=arg@entry=0x56466ec19d08) at /data/src/10.6/sql/sql_connect.cc:1312
connect = 0x56466ec19d08
#25 0x000056466bfc9132 in pfs_spawn_thread (arg=0x56466ebcf6b8) at /data/src/10.6/storage/perfschema/pfs.cc:2201
typed_arg = 0x56466ebcf6b8
user_arg = 0x56466ec19d08
user_start_routine = 0x56466bc47d90 <handle_one_connection(void*)>
pfs = <optimized out>
klass = <optimized out>
#26 0x00007f27f9492ea7 in start_thread (arg=<optimized out>) at pthread_create.c:477
ret = <optimized out>
pd = <optimized out>
unwind_buf = {cancel_jmp_buf = {{jmp_buf = {139809574459136, 1323487900843466144, 140726421606894, 140726421606895, 139809574457216, 311296, -1436066429835321952, -1436072508303909472}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}}
not_first_call = 0
#27 0x00007f27f90a9def in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Reproducible on 10.6-10.10. Couldn't reproduce on 10.5.
It seems that the failure started happening after this commit in 10.6:

commit 4b80c11f52a3da189bafd7a772bcbf3519ceb41e

Author: Thirunarayanan Balathandayuthapani

Date:   Mon Apr 25 13:36:56 2022 +0530

    MDEV-15250  UPSERT during ALTER TABLE results in 'Duplicate entry' error for alter

    - InnoDB DDL results in `Duplicate entry' if concurrent DML throws

but since the test case is non-deterministic, it's not 100% guarantee.

Attachments

Issue Links

is caused by

MDEV-15250 UPSERT during ALTER-TABLE results in 'Duplicate entry' error for alter

Closed

Activity

People

Assignee:: Thirunarayanan Balathandayuthapani

Reporter:: Elena Stepanova

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2022-06-11 12:02

Updated:: 2022-07-05 09:48

Resolved:: 2022-06-30 12:54

Git Integration

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