Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. 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

    XMLWordPrintable

Details

    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

          Activity

            People

              thiru Thirunarayanan Balathandayuthapani
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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