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

Assertion `!orig_thd->mdl_context.has_transactional_locks()' failed in Wsrep_replayer_service::Wsrep_replayer_service(THD*, THD*)

    XMLWordPrintable

Details

    • Bug
    • Status: Stalled (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.6
    • 10.11
    • Galera
    • None
    • Can result in hang or crash
    • Q4/2025 Galera Development, Q1/2026 Galera Maintenance

    Description

      The crash is from galera multi-thread pquery run.

      1ae31cb79c94c3d94d79a00a2a2e9916fb3ba177 (Debug)

      mariadbd: /test/10.6-es_dbg/sql/wsrep_high_priority_service.cc:919: Wsrep_replayer_service::Wsrep_replayer_service(THD*, THD*): Assertion `!orig_thd->mdl_context.has_transactional_locks()' failed.
      

      1ae31cb79c94c3d94d79a00a2a2e9916fb3ba177 (Debug)

      Core was generated by `/test/GAL_EMD291025-mariadb-10.6.24-19-linux-x86_64-dbg/bin/mariadbd --defaults'.
      Program terminated with signal SIGABRT, Aborted.
      #0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
       
      [Current thread is 1 (LWP 1334473)]
      (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=6)at ./nptl/pthread_kill.c:89
      #3  0x000064d24f7034ca in my_write_core (sig=6)at /test/10.6-es_dbg/mysys/stacktrace.c:424
      #4  0x000064d24edb9a05 in handle_fatal_signal (sig=6)at /test/10.6-es_dbg/sql/signal_handler.cc:298
      #5  <signal handler called>
      #6  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
      #7  __pthread_kill_internal (signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:78
      #8  __GI___pthread_kill (threadid=<optimized out>, signo=signo@entry=6)at ./nptl/pthread_kill.c:89
      #9  0x00007f5c1f24527e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
      #10 0x00007f5c1f2288ff in __GI_abort () at ./stdlib/abort.c:79
      #11 0x00007f5c1f22881b in __assert_fail_base (fmt=0x7f5c1f3d01e8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x64d24fc3f098 "!orig_thd->mdl_context.has_transactional_locks()", file=file@entry=0x64d24fc3e6f8 "/test/10.6-es_dbg/sql/wsrep_high_priority_service.cc", line=line@entry=919, function=function@entry=0x64d24fc3f038 "Wsrep_replayer_service::Wsrep_replayer_service(THD*, THD*)") at ./assert/assert.c:96
      #12 0x00007f5c1f23b517 in __assert_fail (assertion=0x64d24fc3f098 "!orig_thd->mdl_context.has_transactional_locks()", file=0x64d24fc3e6f8 "/test/10.6-es_dbg/sql/wsrep_high_priority_service.cc", line=919, function=0x64d24fc3f038 "Wsrep_replayer_service::Wsrep_replayer_service(THD*, THD*)") at ./assert/assert.c:105
      #13 0x000064d24f12f17a in Wsrep_replayer_service::Wsrep_replayer_service (this=0x7f5835a25410, replayer_thd=0x7f2d7809a608, orig_thd=0x7f2d78000d58)at /test/10.6-es_dbg/sql/wsrep_high_priority_service.cc:919
      #14 0x000064d24f1295b4 in Wsrep_client_service::replay (this=0x7f2d78007480)at /test/10.6-es_dbg/sql/wsrep_client_service.cc:342
      #15 0x000064d24f94ff7e in wsrep::transaction::replay (this=0x7f2d78007520, lock=@0x7f5835a26000: {_M_device = 0x7f2d78007460, _M_owns = false})at /test/10.6-es_dbg/wsrep-lib/src/transaction.cpp:2069
      #16 0x000064d24f94b1a8 in wsrep::transaction::after_statement (this=0x7f2d78007520, lock=@0x7f5835a26000: {_M_device = 0x7f2d78007460, _M_owns = false})at /test/10.6-es_dbg/wsrep-lib/src/transaction.cpp:893
      #17 0x000064d24f923d84 in wsrep::client_state::after_statement (this=0x7f2d78007498)at /test/10.6-es_dbg/wsrep-lib/src/client_state.cpp:264
      #18 0x000064d24f13f199 in wsrep_after_statement (thd=0x7f2d78000d58)at /test/10.6-es_dbg/sql/wsrep_trans_observer.h:573
      #19 0x000064d24f14e134 in wsrep_commit_empty (thd=0x7f2d78000d58, all=true)at /test/10.6-es_dbg/sql/wsrep_mysqld.cc:4430
      #20 0x000064d24edbec1c in ha_commit_trans (thd=0x7f2d78000d58, all=true)at /test/10.6-es_dbg/sql/handler.cc:1802
      #21 0x000064d24ebd196e in trans_commit_implicit (thd=0x7f2d78000d58)at /test/10.6-es_dbg/sql/transaction.cc:342
      #22 0x000064d24e9ea0e6 in mysql_execute_command (thd=0x7f2d78000d58, is_called_from_prepared_stmt=false)at /test/10.6-es_dbg/sql/sql_parse.cc:6281
      #23 0x000064d24e9efa6b in mysql_parse (thd=0x7f2d78000d58, rawbuf=0x7f2d78013530 "CREATE OR REPLACE TABLE t1 select CAST(\"2001-12-29\" AS DATE) as d, CAST(\"20:45:11\" AS TIME) as t, CAST(\"2001-12-29 20:45:11\" AS DATETIME) as dt", length=143, parser_state=0x7f5835a272d0)at /test/10.6-es_dbg/sql/sql_parse.cc:8229
      #24 0x000064d24e9eefdb in wsrep_mysql_parse (thd=0x7f2d78000d58, rawbuf=0x7f2d78013530 "CREATE OR REPLACE TABLE t1 select CAST(\"2001-12-29\" AS DATE) as d, CAST(\"20:45:11\" AS TIME) as t, CAST(\"2001-12-29 20:45:11\" AS DATETIME) as dt", length=143, parser_state=0x7f5835a272d0)at /test/10.6-es_dbg/sql/sql_parse.cc:8040
      #25 0x000064d24e9db3c9 in dispatch_command (command=COM_QUERY, thd=0x7f2d78000d58, packet=0x7f2d7800afb9 "CREATE OR REPLACE TABLE t1 select CAST(\"2001-12-29\" AS DATE) as d, CAST(\"20:45:11\" AS TIME) as t, CAST(\"2001-12-29 20:45:11\" AS DATETIME) as dt;", packet_length=144, blocking=true)at /test/10.6-es_dbg/sql/sql_parse.cc:1902
      #26 0x000064d24e9da032 in do_command (thd=0x7f2d78000d58, blocking=true)at /test/10.6-es_dbg/sql/sql_parse.cc:1428
      #27 0x000064d24ebb53a4 in do_handle_one_connection (connect=0x64d28bf02a88, put_in_cache=true) at /test/10.6-es_dbg/sql/sql_connect.cc:1386
      #28 0x000064d24ebb514f in handle_one_connection (arg=0x64d28bf02a88)at /test/10.6-es_dbg/sql/sql_connect.cc:1298
      #29 0x00007f5c1f29caa4 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
      #30 0x00007f5c1f329c3c in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
      

      Attachments

        Activity

          People

            denis.protivensky Denis Protivensky
            ramesh Ramesh Sivaraman
            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.