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

Assertion `ha_count_rw_2pc(thd_arg, thd_arg->in_multi_stmt_transaction_mode())' failed

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.11, 11.4, 11.8, 12.2, 12.3
    • 10.11, 11.4, 11.8, 12.3
    • None
    • Can result in hang or crash

    Description

      -------------------- BUG REPORT --------------------

      # mysqld options required for replay: --log_bin
      set sql_mode='';
      SET autocommit=0;
      CREATE TABLE t (a INT);
      BINLOG 'AMqaOw8BAAAAdAAAAHgAAAAAAAQANS42LjM0LTc5LjEtZGVidWctbG9nAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAEzgNAAgAEgAEBAQEEgAAXAAEGggAAAAICAgCAAAACgoKGRkAAYVx w2w=';
      LOCK TABLES t WRITE;
      INSERT INTO t VALUES (GEOMFROMTEXT ('POINT()'));
      BINLOG '1iZAZwIBAAAAjQAAAHJ4AAAAACQAAAAAAAAABAAALQAAAAAAAQEAACBUAAAAAAYDc3RkBAgACAAACYEpAgAAAAAAAIIEnQAAAAAAAAB0ZXN0AGFsdGVyICB0YWJsZSB0NiBhZGQgY29sdW1uIGMgaW50LCBmb3JjZSwgYWxnb3JpdGhtPWNvcHlIBde4';
      

      Leads to:

      CS 10.11.17 67fceadfa45b3f14921114544734455ecbdd480e (Debug, Clang 18.1.3-11) Build 11/02/2026

      mariadbd: /test/10.11_dbg/sql/log_event_server.cc:3673: Gtid_log_event::Gtid_log_event(THD *, uint64, uint32, bool, uint16, bool, uint64, bool, bool): Assertion `ha_count_rw_2pc(thd_arg, thd_arg->in_multi_stmt_transaction_mode())' failed.
      

      CS 10.11.17 67fceadfa45b3f14921114544734455ecbdd480e (Debug, Clang 18.1.3-11) Build 11/02/2026

      Core was generated by `/test/MD110226-mariadb-10.11.17-linux-x86_64-dbg/bin/mariadbd --no-defaults --m'.
      Program terminated with signal SIGABRT, Aborted.
      Download failed: Invalid argument.  Continuing without source file ./nptl/./nptl/pthread_kill.c.
      #0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
       
      [Current thread is 1 (LWP 2690382)]
      (gdb) bt
      #0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
      #1  __pthread_kill_internal (signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:78
      #2  __GI___pthread_kill (threadid=<optimized out>, signo=signo@entry=6)at ./nptl/pthread_kill.c:89
      #3  0x000075f41644527e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
      #4  0x000075f4164288ff in __GI_abort () at ./stdlib/abort.c:79
      #5  0x000075f41642881b in __assert_fail_base (fmt=0x75f4165d01e8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x61cb0a443a64 "ha_count_rw_2pc(thd_arg, thd_arg->in_multi_stmt_transaction_mode())", file=file@entry=0x61cb0a44287e "/test/10.11_dbg/sql/log_event_server.cc", line=line@entry=3673, function=function@entry=0x61cb0a443a06 "Gtid_log_event::Gtid_log_event(THD *, uint64, uint32, bool, uint16, bool, uint64, bool, bool)")at ./assert/assert.c:96
      #6  0x000075f41643b517 in __assert_fail (assertion=0x61cb0a443a64 "ha_count_rw_2pc(thd_arg, thd_arg->in_multi_stmt_transaction_mode())", file=0x61cb0a44287e "/test/10.11_dbg/sql/log_event_server.cc", line=3673, function=0x61cb0a443a06 "Gtid_log_event::Gtid_log_event(THD *, uint64, uint32, bool, uint16, bool, uint64, bool, bool)") at ./assert/assert.c:105
      #7  0x000061cb09961cc5 in Gtid_log_event::Gtid_log_event (this=0x75f3f05ad640, thd_arg=0x75f330000d58, seq_no_arg=2, domain_id_arg=0, standalone=false, flags_arg=8, is_transactional=true, commit_id_arg=0, has_xid=true, ro_1pc=false) at /test/10.11_dbg/sql/log_event_server.cc:3672
      #8  0x000061cb0992fffd in MYSQL_BIN_LOG::write_gtid_event (this=0x61cb0af2d580 <mysql_bin_log>, thd=0x75f330000d58, standalone=false, is_transactional=true, commit_id=0, has_xid=true, is_ro_1pc=false)at /test/10.11_dbg/sql/log.cc:6755
      #9  0x000061cb09938606 in MYSQL_BIN_LOG::write_transaction_or_stmt (this=0x61cb0af2d580 <mysql_bin_log>, entry=0x75f3f05adde0, commit_id=0)at /test/10.11_dbg/sql/log.cc:9069
      #10 0x000061cb09936861 in MYSQL_BIN_LOG::trx_group_commit_leader (this=0x61cb0af2d580 <mysql_bin_log>, leader=0x75f3f05adde0)at /test/10.11_dbg/sql/log.cc:8771
      #11 0x000061cb09934db0 in MYSQL_BIN_LOG::write_transaction_to_binlog_events (this=0x61cb0af2d580 <mysql_bin_log>, entry=0x75f3f05adde0)at /test/10.11_dbg/sql/log.cc:8563
      #12 0x000061cb099349c6 in MYSQL_BIN_LOG::write_transaction_to_binlog (this=0x61cb0af2d580 <mysql_bin_log>, thd=0x75f330000d58, cache_mngr=0x75f330022488, end_ev=0x75f3f05adfb0, all=true, using_stmt_cache=true, using_trx_cache=true, is_ro_1pc=false)at /test/10.11_dbg/sql/log.cc:8159
      #13 0x000061cb099405d9 in binlog_flush_cache (thd=0x75f330000d58, cache_mngr=0x75f330022488, end_ev=0x75f3f05adfb0, all=true, using_stmt=true, using_trx=true, is_ro_1pc=false)at /test/10.11_dbg/sql/log.cc:2015
      #14 0x000061cb0993c35e in binlog_commit_flush_xid_caches (thd=0x75f330000d58, cache_mngr=0x75f330022488, all=true, xid=6)at /test/10.11_dbg/sql/log.cc:2165
      #15 0x000061cb0993c169 in MYSQL_BIN_LOG::log_and_order (this=0x61cb0af2d580 <mysql_bin_log>, thd=0x75f330000d58, xid=6, all=true, need_prepare_ordered=false, need_commit_ordered=true)at /test/10.11_dbg/sql/log.cc:10771
      #16 0x000061cb097a1abd in ha_commit_trans (thd=0x75f330000d58, all=true)at /test/10.11_dbg/sql/handler.cc:1992
      #17 0x000061cb095b2b19 in trans_commit_implicit (thd=0x75f330000d58)at /test/10.11_dbg/sql/transaction.cc:342
      #18 0x000061cb093bfa8c in mysql_execute_command (thd=0x75f330000d58, is_called_from_prepared_stmt=false)at /test/10.11_dbg/sql/sql_parse.cc:3844
      #19 0x000061cb093b84c4 in mysql_parse (thd=0x75f330000d58, rawbuf=0x75f33003f2b3 "alter  table t6 add column c int, force, algorithm=copy", length=55, parser_state=0x75f3f05affe0)at /test/10.11_dbg/sql/sql_parse.cc:8223
      #20 0x000061cb0995b8bb in Query_log_event::do_apply_event (this=0x75f33008e338, rgi=0x75f33008d920, query_arg=0x75f33003f2b3 "alter  table t6 add column c int, force, algorithm=copy", q_len_arg=55) at /test/10.11_dbg/sql/log_event_server.cc:2206
      #21 0x000061cb0995a7aa in Query_log_event::do_apply_event (this=0x75f33008e338, rgi=0x75f33008d920)at /test/10.11_dbg/sql/log_event_server.cc:1633
      #22 0x000061cb09953002 in Log_event::apply_event (this=0x75f33008e338, rgi=0x75f33008d920) at /test/10.11_dbg/sql/log_event.cc:4255
      #23 0x000061cb09564a2b in save_restore_context_apply_event (ev=0x75f33008e338, rgi=0x75f33008d920) at /test/10.11_dbg/sql/sql_binlog.cc:212
      #24 0x000061cb09565163 in mysql_client_binlog_statement (thd=0x75f330000d58)at /test/10.11_dbg/sql/sql_binlog.cc:428
      #25 0x000061cb093ca120 in mysql_execute_command (thd=0x75f330000d58, is_called_from_prepared_stmt=false)at /test/10.11_dbg/sql/sql_parse.cc:6111
      #26 0x000061cb093b84c4 in mysql_parse (thd=0x75f330000d58, rawbuf=0x75f330013500 "BINLOG '1iZAZwIBAAAAjQAAAHJ4AAAAACQAAAAAAAAABAAALQAAAAAAAQEAACBUAAAAAAYDc3RkBAgACAAACYEpAgAAAAAAAIIEnQAAAAAAAAB0ZXN0AGFsdGVyICB0YWJsZSB0NiBhZGQgY29sdW1uIGMgaW50LCBmb3JjZSwgYWxnb3JpdGhtPWNvcHlIBde4'", length=197, parser_state=0x75f3f05b1a20) at /test/10.11_dbg/sql/sql_parse.cc:8223
      #27 0x000061cb093b5969 in dispatch_command (command=COM_QUERY, thd=0x75f330000d58, packet=0x75f33000af89 "BINLOG '1iZAZwIBAAAAjQAAAHJ4AAAAACQAAAAAAAAABAAALQAAAAAAAQEAACBUAAAAAAYDc3RkBAgACAAACYEpAgAAAAAAAIIEnQAAAAAAAAB0ZXN0AGFsdGVyICB0YWJsZSB0NiBhZGQgY29sdW1uIGMgaW50LCBmb3JjZSwgYWxnb3JpdGhtPWNvcHlIBde4'", packet_length=197, blocking=true) at /test/10.11_dbg/sql/sql_parse.cc:1924
      #28 0x000061cb093b9073 in do_command (thd=0x75f330000d58, blocking=true)at /test/10.11_dbg/sql/sql_parse.cc:1434
      #29 0x000061cb09596689 in do_handle_one_connection (connect=0x61cb1ca34218, put_in_cache=true) at /test/10.11_dbg/sql/sql_connect.cc:1475
      #30 0x000061cb09596422 in handle_one_connection (arg=0x61cb1cb1c068)at /test/10.11_dbg/sql/sql_connect.cc:1387
      #31 0x000075f41649caa4 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
      #32 0x000075f416529c6c in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
      

      Bug Detection Matrix

          Rel    o/d  Build   Commit                                    UniqueID observed             
      CS  10.6   dbg  110226  1758b2578a8cc7e193bb35de0d8dc9a5e517c89c  No bug found                  
      CS  10.6   opt  110226  1758b2578a8cc7e193bb35de0d8dc9a5e517c89c  No bug found                  
      CS  10.11  dbg  110226  67fceadfa45b3f14921114544734455ecbdd480e  ha_count_rw_2pc(thd_arg, thd_arg->in_multi_stmt_transaction_mode())|SIGABRT|Gtid_log_event::Gtid_log_event|MYSQL_BIN_LOG::write_gtid_event|MYSQL_BIN_LOG::write_transaction_or_stmt|MYSQL_BIN_LOG::trx_group_commit_leader
      CS  10.11  opt  110226  67fceadfa45b3f14921114544734455ecbdd480e  MARIADB_ERROR_CODE|MariaDB error code: 1100
      CS  11.4   dbg  110226  78201a41b5e88b94c27f5ecc16c9e5486e2e50c3  ha_count_rw_2pc(thd_arg, thd_arg->in_multi_stmt_transaction_mode())|SIGABRT|Gtid_log_event::Gtid_log_event|MYSQL_BIN_LOG::write_gtid_event|MYSQL_BIN_LOG::write_transaction_or_stmt|MYSQL_BIN_LOG::trx_group_commit_leader
      CS  11.4   opt  110226  78201a41b5e88b94c27f5ecc16c9e5486e2e50c3  MARIADB_ERROR_CODE|MariaDB error code: 1100
      CS  11.8   dbg  110226  65ee9a7b4694d1b6f366b5a7a3d1b0549e5a3671  ha_count_rw_2pc(thd_arg, thd_arg->in_multi_stmt_transaction_mode())|SIGABRT|Gtid_log_event::Gtid_log_event|MYSQL_BIN_LOG::write_gtid_event|MYSQL_BIN_LOG::write_transaction_or_stmt|MYSQL_BIN_LOG::trx_group_commit_with_engines
      CS  11.8   opt  110226  65ee9a7b4694d1b6f366b5a7a3d1b0549e5a3671  MARIADB_ERROR_CODE|MariaDB error code: 1100
      CS  12.2   dbg  110226  d26a6f44c1f2119377e79a9540886c6d8c01472f  ha_count_rw_2pc(thd_arg, thd_arg->in_multi_stmt_transaction_mode())|SIGABRT|Gtid_log_event::Gtid_log_event|MYSQL_BIN_LOG::write_gtid_event|MYSQL_BIN_LOG::write_transaction_or_stmt|MYSQL_BIN_LOG::trx_group_commit_with_engines
      CS  12.2   opt  110226  d26a6f44c1f2119377e79a9540886c6d8c01472f  GOT_ERROR|Got error: 98: Address already in use
      CS  12.3   dbg  110226  21a0714a118614982d20bfa504763d7247800091  ha_count_rw_2pc(thd_arg, thd_arg->in_multi_stmt_transaction_mode())|SIGABRT|Gtid_log_event::Gtid_log_event|MYSQL_BIN_LOG::write_gtid_event|MYSQL_BIN_LOG::write_transaction_or_stmt|MYSQL_BIN_LOG::trx_group_commit_with_engines
      CS  12.3   opt  110226  21a0714a118614982d20bfa504763d7247800091  MARIADB_ERROR_CODE|MariaDB error code: 1100
      ES  10.6   dbg  110226  22e626b9c17e9969925c54f14d30e39e25320b22  No bug found                  
      ES  10.6   opt  110226  22e626b9c17e9969925c54f14d30e39e25320b22  No bug found                  
      ES  11.4   dbg  110226  34f616d5fd2c649d0c79acb4e2423c90b8f10436  ha_count_rw_2pc(thd_arg, thd_arg->in_multi_stmt_transaction_mode())|SIGABRT|Gtid_log_event::Gtid_log_event|MYSQL_BIN_LOG::write_gtid_event|MYSQL_BIN_LOG::write_transaction_or_stmt|MYSQL_BIN_LOG::trx_group_commit_leader
      ES  11.4   opt  110226  34f616d5fd2c649d0c79acb4e2423c90b8f10436  MARIADB_ERROR_CODE|MariaDB error code: 1100
      ES  11.8   dbg  110226  405ee76b60c4ab82155f339136ed20d3b7363717  ha_count_rw_2pc(thd_arg, thd_arg->in_multi_stmt_transaction_mode())|SIGABRT|Gtid_log_event::Gtid_log_event|MYSQL_BIN_LOG::write_gtid_event|MYSQL_BIN_LOG::write_transaction_or_stmt|MYSQL_BIN_LOG::trx_group_commit_with_engines
      ES  11.8   opt  110226  405ee76b60c4ab82155f339136ed20d3b7363717  MARIADB_ERROR_CODE|MariaDB error code: 1100
      

      Attachments

        Activity

          People

            Elkin Andrei Elkin
            saahil Saahil Alam
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.