Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-28944

XA assertions failing in binlog_rollback and binlog_commit

    XMLWordPrintable

    Details

      Description

      CREATE TABLE t (a INT) ENGINE=MyISAM;
      INSERT INTO t VALUES (1);
       
      --connect (con1,localhost,root,,test)
      XA START 'xid';
      SELECT * FROM t;
       
      --connection default
      --error ER_LOCK_WAIT_TIMEOUT
      ALTER TABLE t NOWAIT ADD KEY (a);
       
      --connection con1
      UPDATE t SET a = 2;
      XA END 'xid';
      XA ROLLBACK 'xid';
       
      # Cleanup
      DROP TABLE t;
      --disconnect con1
      

      bb-10.10-MDEV-16329 cb1f08bd1c

      mariadbd: /data/src/preview-10.10-online-alter-gcov/sql/log.cc:2383: int binlog_rollback(handlerton*, THD*, bool): Assertion `thd->lex->sql_command != SQLCOM_XA_ROLLBACK' failed.
      220625  1:32:43 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007f9af47c0662 in __GI___assert_fail (assertion=0x56064fb841a8 "thd->lex->sql_command != SQLCOM_XA_ROLLBACK", file=0x56064fb82e28 "/data/src/preview-10.10-online-alter-gcov/sql/log.cc", line=2383, function=0x56064fb84128 "int binlog_rollback(handlerton*, THD*, bool)") at assert.c:101
      No locals.
      #8  0x000056064ea565a1 in binlog_rollback (hton=0x560652519688, thd=0x7f9ad8000db8, all=true) at /data/src/preview-10.10-online-alter-gcov/sql/log.cc:2383
              _db_stack_frame_ = {func = 0x56064fb4ef02 "ha_rollback_trans", file = 0x56064fb4e080 "/data/src/preview-10.10-online-alter-gcov/sql/handler.cc", level = 2147483655, line = -1, prev = 0x7f9af00bdb10}
              is_ending_trans = true
              rollback_online = true
              error = 0
              cache_mngr = 0x0
              __PRETTY_FUNCTION__ = "int binlog_rollback(handlerton*, THD*, bool)"
      #9  0x000056064e7e6851 in ha_rollback_trans (thd=0x7f9ad8000db8, all=true) at /data/src/preview-10.10-online-alter-gcov/sql/handler.cc:2180
              err = -2116343448
              ht = 0x560652519688
              error = 0
              trans = 0x7f9ad8004770
              ha_info = 0x7f9ad80037e8
              ha_info_next = 0x56064fa05f60
              is_real_trans = true
              _db_stack_frame_ = {func = 0x56064fa06408 "trans_xa_rollback", file = 0x56064fa06018 "/data/src/preview-10.10-online-alter-gcov/sql/xa.cc", level = 2147483654, line = -1, prev = 0x7f9af00bdba0}
              __PRETTY_FUNCTION__ = "int ha_rollback_trans(THD*, bool)"
      #10 0x000056064e656a85 in xa_trans_force_rollback (thd=0x7f9ad8000db8) at /data/src/preview-10.10-online-alter-gcov/sql/xa.cc:393
              rc = false
      #11 0x000056064e659c50 in trans_xa_rollback (thd=0x7f9ad8000db8) at /data/src/preview-10.10-online-alter-gcov/sql/xa.cc:821
              xid_state = @0x7f9ad80047a8: {xid_cache_element = 0x7f9ad8021a18}
              _db_stack_frame_ = {func = 0x56064f95c038 "mysql_execute_command", file = 0x56064f95b2e0 "/data/src/preview-10.10-online-alter-gcov/sql/sql_parse.cc", level = 2147483653, line = 821, prev = 0x7f9af00bdf30}
              __PRETTY_FUNCTION__ = "bool trans_xa_rollback(THD*)"
              mdl_request = {type = 13, duration = MDL_STATEMENT, next_in_list = 0x21, prev_in_list = 0x7f9af3e11c40, ticket = 0x7f9ad8008430, key = {m_length = 3, m_db_name_length = 0, m_hash_value = 65537, m_ptr = "\000\000\000O\006V\000\000 \334\v\360\232\177\000\000\024\002\000\000\000\000\000\000!\000\000\000\000\000\000\000\370\027\215R\006V\000\000\b\000\000\000\366\005\000\000\246jwO\006V\000\000@\334\v\360\232\177\000\000\305lwO\006V\000\000@\334\v\360\232\177\000\000\ba\000\330\232\177\000\000\240\335\v\360\232\177\000\000\231\316\rN\006V\000\000\000Q\000\330\232\177\000\000\270\r\000\330\232\177\000\000\220\334\v\360\232\177\000\000`\v\000\330\232\177\000\000\220\334\v\360\232\177\000\000\334\fxO\006V\000\000h{\v\364\232\177\000\000\300\251=R\000\000\000\000#\220\226O\006V\000\000\000\000\000\000\000\000\000\000\300\334\v\360\232\177\000\000\305lwO\000\000\001\000"...}, m_src_file = 0x56064fa06018 "/data/src/preview-10.10-online-alter-gcov/sql/xa.cc", m_src_line = 807}
      #12 0x000056064e0f1065 in mysql_execute_command (thd=0x7f9ad8000db8, is_called_from_prepared_stmt=false) at /data/src/preview-10.10-online-alter-gcov/sql/sql_parse.cc:5879
              rollback_failed = 32
              res = 0
              up_result = 0
              lex = 0x7f9ad8005100
              select_lex = 0x7f9ad80059d8
              first_table = 0x0
              all_tables = 0x0
              unit = 0x7f9ad80051d8
              have_table_map_for_update = false
              rpl_filter = 0x5606502b3250 <vtable for Internal_error_handler+16>
              _db_stack_frame_ = {func = 0x56064f95d3cf "mysql_parse", file = 0x56064f95b2e0 "/data/src/preview-10.10-online-alter-gcov/sql/sql_parse.cc", level = 2147483652, line = -1, prev = 0x7f9af00be380}
              __PRETTY_FUNCTION__ = "int mysql_execute_command(THD*, bool)"
              ots = {ctx = 0x7f9ad8004d98, traceable = false}
              orig_binlog_format = BINLOG_FORMAT_MIXED
              orig_current_stmt_binlog_format = BINLOG_FORMAT_STMT
      #13 0x000056064e0fdc10 in mysql_parse (thd=0x7f9ad8000db8, rawbuf=0x7f9ad8013fe0 "XA ROLLBACK 'xid'", length=17, parser_state=0x7f9af00be500) at /data/src/preview-10.10-online-alter-gcov/sql/sql_parse.cc:8036
              found_semicolon = 0x0
              error = 32666
              lex = 0x7f9ad8005100
              err = false
              _db_stack_frame_ = {func = 0x56064f95b879 "dispatch_command", file = 0x56064f95b2e0 "/data/src/preview-10.10-online-alter-gcov/sql/sql_parse.cc", level = 2147483651, line = -1, prev = 0x7f9af00be4e0}
              __PRETTY_FUNCTION__ = "void mysql_parse(THD*, char*, uint, Parser_state*)"
      #14 0x000056064e0d4f11 in dispatch_command (command=COM_QUERY, thd=0x7f9ad8000db8, packet=0x7f9ad800b9e9 "XA ROLLBACK 'xid'", packet_length=17, blocking=true) at /data/src/preview-10.10-online-alter-gcov/sql/sql_parse.cc:1894
              packet_end = 0x7f9ad8013ff1 ""
              parser_state = {m_lip = {lookahead_token = -1, lookahead_yylval = 0x0, m_thd = 0x7f9ad8000db8, m_ptr = 0x7f9ad8013ff2 "\004", m_tok_start = 0x7f9ad8013ff2 "\004", m_tok_end = 0x7f9ad8013ff2 "\004", m_end_of_query = 0x7f9ad8013ff1 "", m_tok_start_prev = 0x7f9ad8013ff1 "", m_buf = 0x7f9ad8013fe0 "XA ROLLBACK 'xid'", m_buf_length = 17, m_echo = true, m_echo_saved = false, m_cpp_buf = 0x7f9ad8014048 "XA ROLLBACK 'xid'", m_cpp_ptr = 0x7f9ad8014059 "", m_cpp_tok_start = 0x7f9ad8014059 "", m_cpp_tok_start_prev = 0x7f9ad8014059 "", m_cpp_tok_end = 0x7f9ad8014059 "", 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 = (DISCARD_COMMENT | unknown: 0x7f98), m_cpp_text_start = 0x7f9ad8014055 "xid'", m_cpp_text_end = 0x7f9ad8014058 "'", m_underscore_cs = 0x0}, m_yacc = {yacc_yyss = 0x0, yacc_yyvs = 0x0, m_set_signal_info = {m_item = {0x0 <repeats 13 times>}}, m_lock_type = TL_READ_DEFAULT, m_mdl_type = MDL_SHARED_READ}, m_digest_psi = 0x7f9ad8004b28}
              net = 0x7f9ad80010f0
              error = false
              do_end_of_statement = true
              _db_stack_frame_ = {func = 0x56064f95b4fd "do_command", file = 0x56064f95b2e0 "/data/src/preview-10.10-online-alter-gcov/sql/sql_parse.cc", level = 2147483650, line = -1, prev = 0x7f9af00bedc0}
              drop_more_results = false
              __PRETTY_FUNCTION__ = "dispatch_command_return dispatch_command(enum_server_command, THD*, char*, uint, bool)"
              __FUNCTION__ = "dispatch_command"
              res = <optimized out>
      #15 0x000056064e0d20ea in do_command (thd=0x7f9ad8000db8, blocking=true) at /data/src/preview-10.10-online-alter-gcov/sql/sql_parse.cc:1407
              return_value = DISPATCH_COMMAND_SUCCESS
              packet = 0x7f9ad800b9e8 "\003XA ROLLBACK 'xid'"
              packet_length = 18
              net = 0x7f9ad80010f0
              command = COM_QUERY
              _db_stack_frame_ = {func = 0x56064fdd350b "?func", file = 0x56064fdd3511 "?file", level = 2147483649, line = -1, prev = 0x0}
              __PRETTY_FUNCTION__ = "dispatch_command_return do_command(THD*, bool)"
              __FUNCTION__ = "do_command"
      #16 0x000056064e43dffd in do_handle_one_connection (connect=0x5606529c0168, put_in_cache=true) at /data/src/preview-10.10-online-alter-gcov/sql/sql_connect.cc:1418
              create_user = true
              thr_create_utime = 2532075869394
              thd = 0x7f9ad8000db8
              __PRETTY_FUNCTION__ = "void do_handle_one_connection(CONNECT*, bool)"
      #17 0x000056064e43d804 in handle_one_connection (arg=0x5606529c0168) at /data/src/preview-10.10-online-alter-gcov/sql/sql_connect.cc:1312
              connect = 0x5606529c0168
      #18 0x000056064ed4bb95 in pfs_spawn_thread (arg=0x5606529c0248) at /data/src/preview-10.10-online-alter-gcov/storage/perfschema/pfs.cc:2201
              typed_arg = 0x5606529c0248
              user_arg = 0x5606529c0168
              user_start_routine = 0x56064e43d74f <handle_one_connection(void*)>
              pfs = 0x7f9af40b7240
              klass = 0x5606523f8580
      #19 0x00007f9af4c8aea7 in start_thread (arg=<optimized out>) at pthread_create.c:477
              ret = <optimized out>
              pd = <optimized out>
              unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140303429007104, -1768826005343688189, 140720454370494, 140720454370495, 140303429005184, 311296, 1749153715660794371, 1749146596737427971}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}}
              not_first_call = 0
      #20 0x00007f9af4889def in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      Or, with XA COMMIT 'xid' ONE PHASE; instead of ROLLBACK, otherwise identical test case:

      CREATE TABLE t (a INT) ENGINE=MyISAM;
      INSERT INTO t VALUES (1);
       
      --connect (con1,localhost,root,,test)
      XA START 'xid';
      SELECT * FROM t;
       
      --connection default
      --error ER_LOCK_WAIT_TIMEOUT
      ALTER TABLE t NOWAIT ADD KEY (a);
       
      --connection con1
      UPDATE t SET a = 2;
      XA END 'xid';
      XA COMMIT 'xid' ONE PHASE;
       
      # Cleanup
      DROP TABLE t;
      --disconnect con1
      

      mariadbd: /data/src/preview-10.10-online-alter-gcov/sql/log.cc:2281: int binlog_commit(THD*, bool, bool): Assertion `(thd && (WSREP_PROVIDER_EXISTS_ && thd->variables.wsrep_on)) || (thd->lex->sql_command != SQLCOM_XA_PREPARE && !(thd->lex->sql_command == SQLCOM_XA_COMMIT && thd->lex->xa_opt == XA_ONE_PHASE))' failed.
      220625  1:50:45 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007fa3f9d60662 in __GI___assert_fail (assertion=0x555c8b68dfb8 "(thd && (WSREP_PROVIDER_EXISTS_ && thd->variables.wsrep_on)) || (thd->lex->sql_command != SQLCOM_XA_PREPARE && !(thd->lex->sql_command == SQLCOM_XA_COMMIT && thd->lex->xa_opt == XA_ONE_PHASE))", file=0x555c8b68ce28 "/data/src/preview-10.10-online-alter-gcov/sql/log.cc", line=2281, function=0x555c8b68df90 "int binlog_commit(THD*, bool, bool)") at assert.c:101
      No locals.
      #8  0x0000555c8a55f9b7 in binlog_commit (thd=0x7fa3d8000db8, all=true, ro_1pc=true) at /data/src/preview-10.10-online-alter-gcov/sql/log.cc:2281
              error = 0
              org_stage = {m_key = 0, m_name = 0x7fa3d8000db8 "\b\353\333\213\\U", m_flags = -194256640}
              _db_stack_frame_ = {func = 0x555c8b658eef "commit_one_phase_2", file = 0x555c8b658080 "/data/src/preview-10.10-online-alter-gcov/sql/handler.cc", level = 2147483657, line = -1, prev = 0x7fa3f46be160}
              is_ending_transaction = true
              cache_mngr = 0x0
              __PRETTY_FUNCTION__ = "int binlog_commit(THD*, bool, bool)"
      #9  0x0000555c8a2efc4d in commit_one_phase_2 (thd=0x7fa3d8000db8, all=true, trans=0x7fa3d8004770, is_real_trans=true) at /data/src/preview-10.10-online-alter-gcov/sql/handler.cc:2059
              err = 21852
              error = 0
              count = 0
              ha_info = 0x7fa3d80037e8
              ha_info_next = 0x7fa3d800ae78
              _db_stack_frame_ = {func = 0x555c8b658edb "ha_commit_one_phase", file = 0x555c8b658080 "/data/src/preview-10.10-online-alter-gcov/sql/handler.cc", level = 2147483656, line = -1, prev = 0x7fa3f46be1c0}
      #10 0x0000555c8a2ef856 in ha_commit_one_phase (thd=0x7fa3d8000db8, all=true) at /data/src/preview-10.10-online-alter-gcov/sql/handler.cc:2021
              trans = 0x7fa3d8004770
              is_real_trans = true
              res = 0
              _db_stack_frame_ = {func = 0x555c8b6587bb "ha_commit_trans", file = 0x555c8b658080 "/data/src/preview-10.10-online-alter-gcov/sql/handler.cc", level = 2147483655, line = -1, prev = 0x7fa3f46be270}
      #11 0x0000555c8a2ed6a9 in ha_commit_trans (thd=0x7fa3d8000db8, all=true) at /data/src/preview-10.10-online-alter-gcov/sql/handler.cc:1815
              error = 0
              cookie = 32675
              trans = 0x7fa3d8004770
              is_real_trans = true
              ha_info = 0x7fa3d80037e8
              need_prepare_ordered = false
              need_commit_ordered = false
              xid = 140341680278968
              run_wsrep_hooks = false
              _db_stack_frame_ = {func = 0x555c8b51032d "trans_xa_commit", file = 0x555c8b510018 "/data/src/preview-10.10-online-alter-gcov/sql/xa.cc", level = 2147483654, line = -1, prev = 0x7fa3f46beba0}
              __PRETTY_FUNCTION__ = "int ha_commit_trans(THD*, bool)"
              rw_ha_count = 0
              rw_trans = false
              mdl_backup = {type = MDL_NOT_INITIALIZED, duration = MDL_STATEMENT, next_in_list = 0x7f00d80037e8, prev_in_list = 0x7fa3d8000db8, ticket = 0x0, key = {m_length = 0, m_db_name_length = 0, m_hash_value = 0, m_ptr = "\320\067\000\330\000\000\000\000#0G\213\\U\000\000\000\000\000\000\000\000\000\000\360\342k\364\243\177\000\000\305\f(\213\000\000\001\000\020\343k\364\243\177\000\000\246\n(\213\\U\000\000\020\343k\364\243\177\000\000\305\f(\213\\U\000\000\340\f\000\330\243\177\000\000`\v\000\330\243\177\000\000\060\343k\364\243\177\000\000Zc,\213\\U\000\000\340\f\000\330\243\177\000\000\270\f\000\330\243\177\000\000`\343k\364\243\177\000\000\313\244,\213\\U\000\000C<G\213\\U\000\000\340\f\000\330&\006\000\000p\343k\364\243\177\000\000\000\236;0\212m>j\320\343k\364\243\177\000\000\313\256\310\211\\U\000\000\220\343k\364\243\177\000\000\030\000\000\000\000\000\000\000"...}, m_src_file = 0x7fa3d80037d0 "", m_src_line = 2334958086}
      #12 0x0000555c8a162831 in trans_xa_commit (thd=0x7fa3d8000db8) at /data/src/preview-10.10-online-alter-gcov/sql/xa.cc:657
              r = 1
              res = true
              xid_state = @0x7fa3d80047a8: {xid_cache_element = 0x7fa3d8021a18}
              _db_stack_frame_ = {func = 0x555c8b466038 "mysql_execute_command", file = 0x555c8b4652e0 "/data/src/preview-10.10-online-alter-gcov/sql/sql_parse.cc", level = 2147483653, line = -1, prev = 0x7fa3f46bef30}
              __PRETTY_FUNCTION__ = "bool trans_xa_commit(THD*)"
      #13 0x0000555c89bfaeed in mysql_execute_command (thd=0x7fa3d8000db8, is_called_from_prepared_stmt=false) at /data/src/preview-10.10-online-alter-gcov/sql/sql_parse.cc:5862
              commit_failed = 32
              res = 0
              up_result = 0
              lex = 0x7fa3d8005100
              select_lex = 0x7fa3d80059d8
              first_table = 0x0
              all_tables = 0x0
              unit = 0x7fa3d80051d8
              have_table_map_for_update = false
              rpl_filter = 0x555c8bdbd250 <vtable for Internal_error_handler+16>
              _db_stack_frame_ = {func = 0x555c8b4673cf "mysql_parse", file = 0x555c8b4652e0 "/data/src/preview-10.10-online-alter-gcov/sql/sql_parse.cc", level = 2147483652, line = -1, prev = 0x7fa3f46bf380}
              __PRETTY_FUNCTION__ = "int mysql_execute_command(THD*, bool)"
              ots = {ctx = 0x7fa3d8004d98, traceable = false}
              orig_binlog_format = BINLOG_FORMAT_MIXED
              orig_current_stmt_binlog_format = BINLOG_FORMAT_STMT
      #14 0x0000555c89c07c10 in mysql_parse (thd=0x7fa3d8000db8, rawbuf=0x7fa3d8013fe0 "XA COMMIT 'xid' ONE PHASE", length=25, parser_state=0x7fa3f46bf500) at /data/src/preview-10.10-online-alter-gcov/sql/sql_parse.cc:8036
              found_semicolon = 0x0
              error = 32675
              lex = 0x7fa3d8005100
              err = false
              _db_stack_frame_ = {func = 0x555c8b465879 "dispatch_command", file = 0x555c8b4652e0 "/data/src/preview-10.10-online-alter-gcov/sql/sql_parse.cc", level = 2147483651, line = -1, prev = 0x7fa3f46bf4e0}
              __PRETTY_FUNCTION__ = "void mysql_parse(THD*, char*, uint, Parser_state*)"
      #15 0x0000555c89bdef11 in dispatch_command (command=COM_QUERY, thd=0x7fa3d8000db8, packet=0x7fa3d800b9e9 "XA COMMIT 'xid' ONE PHASE", packet_length=25, blocking=true) at /data/src/preview-10.10-online-alter-gcov/sql/sql_parse.cc:1894
              packet_end = 0x7fa3d8013ff9 ""
              parser_state = {m_lip = {lookahead_token = -1, lookahead_yylval = 0x0, m_thd = 0x7fa3d8000db8, m_ptr = 0x7fa3d8013ffa "\004", m_tok_start = 0x7fa3d8013ffa "\004", m_tok_end = 0x7fa3d8013ffa "\004", m_end_of_query = 0x7fa3d8013ff9 "", m_tok_start_prev = 0x7fa3d8013ff9 "", m_buf = 0x7fa3d8013fe0 "XA COMMIT 'xid' ONE PHASE", m_buf_length = 25, m_echo = true, m_echo_saved = false, m_cpp_buf = 0x7fa3d8014050 "XA COMMIT 'xid' ONE PHASE", m_cpp_ptr = 0x7fa3d8014069 "", m_cpp_tok_start = 0x7fa3d8014069 "", m_cpp_tok_start_prev = 0x7fa3d8014069 "", m_cpp_tok_end = 0x7fa3d8014069 "", 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 = (PRESERVE_COMMENT | DISCARD_COMMENT | unknown: 0x7fa0), m_cpp_text_start = 0x7fa3d801405b "xid' ONE PHASE", m_cpp_text_end = 0x7fa3d801405e "' ONE PHASE", m_underscore_cs = 0x0}, m_yacc = {yacc_yyss = 0x0, yacc_yyvs = 0x0, m_set_signal_info = {m_item = {0x0 <repeats 13 times>}}, m_lock_type = TL_READ_DEFAULT, m_mdl_type = MDL_SHARED_READ}, m_digest_psi = 0x7fa3d8004b28}
              net = 0x7fa3d80010f0
              error = false
              do_end_of_statement = true
              _db_stack_frame_ = {func = 0x555c8b4654fd "do_command", file = 0x555c8b4652e0 "/data/src/preview-10.10-online-alter-gcov/sql/sql_parse.cc", level = 2147483650, line = -1, prev = 0x7fa3f46bfdc0}
              drop_more_results = false
              __PRETTY_FUNCTION__ = "dispatch_command_return dispatch_command(enum_server_command, THD*, char*, uint, bool)"
              __FUNCTION__ = "dispatch_command"
              res = <optimized out>
      #16 0x0000555c89bdc0ea in do_command (thd=0x7fa3d8000db8, blocking=true) at /data/src/preview-10.10-online-alter-gcov/sql/sql_parse.cc:1407
              return_value = DISPATCH_COMMAND_SUCCESS
              packet = 0x7fa3d800b9e8 "\003XA COMMIT 'xid' ONE PHASE"
              packet_length = 26
              net = 0x7fa3d80010f0
              command = COM_QUERY
              _db_stack_frame_ = {func = 0x555c8b8dd50b "?func", file = 0x555c8b8dd511 "?file", level = 2147483649, line = -1, prev = 0x0}
              __PRETTY_FUNCTION__ = "dispatch_command_return do_command(THD*, bool)"
              __FUNCTION__ = "do_command"
      #17 0x0000555c89f47ffd in do_handle_one_connection (connect=0x555c8e5af168, put_in_cache=true) at /data/src/preview-10.10-online-alter-gcov/sql/sql_connect.cc:1418
              create_user = true
              thr_create_utime = 2533157813198
              thd = 0x7fa3d8000db8
              __PRETTY_FUNCTION__ = "void do_handle_one_connection(CONNECT*, bool)"
      #18 0x0000555c89f47804 in handle_one_connection (arg=0x555c8e5af168) at /data/src/preview-10.10-online-alter-gcov/sql/sql_connect.cc:1312
              connect = 0x555c8e5af168
      #19 0x0000555c8a855b95 in pfs_spawn_thread (arg=0x555c8e5af248) at /data/src/preview-10.10-online-alter-gcov/storage/perfschema/pfs.cc:2201
              typed_arg = 0x555c8e5af248
              user_arg = 0x555c8e5af168
              user_start_routine = 0x555c89f4774f <handle_one_connection(void*)>
              pfs = 0x7fa3f9657240
              klass = 0x555c8dfe7580
      #20 0x00007fa3fa22aea7 in start_thread (arg=<optimized out>) at pthread_create.c:477
              ret = <optimized out>
              pd = <optimized out>
              unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140342157117184, 9015443577906266516, 140737166056062, 140737166056063, 140342157115264, 311296, -9053744893697064556, -9053714719924026988}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}}
              not_first_call = 0
      #21 0x00007fa3f9e29def in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      Doesn't fail with e.g. LOCK=SHARED in the ALTER.
      NOWAIT is just to speed things up, it also fails upon a normal lock wait timeout.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              serg Sergei Golubchik
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:

                  Git Integration

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