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

Assertion `m_psi_batch_mode == PSI_BATCH_MODE_NONE' failed

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • None
    • N/A
    • Optimizer
    • None
    • Can result in hang or crash
    • Q2/2026 Server Development

    Description

      Server Crash seen while testing MDEV-39014

      Issue:

      ---------
      mariadbd: /home/ppandith/wl-39014/sql/handler.cc:3851: void handler::start_psi_batch_mode(): Assertion `m_psi_batch_mode == PSI_BATCH_MODE_NONE' failed.

      Version:

      ----------------
      Branch : 13.2-mdev-39014-full-join-p2
      commit : 7c8a25a2bba8bc559db34eb3068a8d53be75ca95
      Version : 13.0.1

      How to Repro:

      ---------------

      create table t1 (pk int not null,primary key(pk));
      create table t2 (pk int);
      insert into t1 values (8);
       
      SELECT t1.pk AS field2 FROM t1 FULL JOIN t2 ON (1) GROUP BY field2 HAVING field2 = 8 ;
      

      Stack trace:

      #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  my_write_core (sig=6) at /home/ppandith/wl-39014/mysys/stacktrace.c:424
      #4  handle_fatal_signal (sig=6) at /home/ppandith/wl-39014/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  __GI_raise (sig=sig@entry=6) at ../sysdeps/posix/raise.c:26
      #10 __GI_abort () at ./stdlib/abort.c:79
      #11 __assert_fail_base (fmt="%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", 
          assertion=assertion@entry="m_psi_batch_mode == PSI_BATCH_MODE_NONE", file=file@entry="/home/ppandith/wl-39014/sql/handler.cc", 
          line=line@entry=3851, function=function@entry="void handler::start_psi_batch_mode()") at ./assert/assert.c:96
      #12 __assert_fail (assertion="m_psi_batch_mode == PSI_BATCH_MODE_NONE", file="/home/ppandith/wl-39014/sql/handler.cc", line=3851, 
          function="void handler::start_psi_batch_mode()") at ./assert/assert.c:105
      #13 handler::start_psi_batch_mode (this=) at /home/ppandith/wl-39014/sql/handler.cc:3851
      #14 sub_select (join=, join_tab=, end_of_records=false) at /home/ppandith/wl-39014/sql/sql_select.cc:26044
      #15 run_fj_null_complement_pass (join=, join_tab=) at /home/ppandith/wl-39014/sql/sql_select.cc:25873
      #16 run_fj_null_complement_passes (join=, join_tab=) at /home/ppandith/wl-39014/sql/sql_select.cc:25942
      #17 sub_select (join=, join_tab=, end_of_records=false) at /home/ppandith/wl-39014/sql/sql_select.cc:26112
      #18 do_select (join=, procedure=) at /home/ppandith/wl-39014/sql/sql_select.cc:25440
      #19 JOIN::exec_inner (this=) at /home/ppandith/wl-39014/sql/sql_select.cc:5257
      #20 JOIN::exec (this=) at /home/ppandith/wl-39014/sql/sql_select.cc:5045
      #21 mysql_select (thd=, tables=, fields=..., conds=, og_num=1, order=, group=, having=, proc_param=, select_options=2164525824, 
          result=, unit=, select_lex=) at /home/ppandith/wl-39014/sql/sql_select.cc:5571
      #22 handle_select (thd=, lex=, result=, setup_tables_done_option=0) at /home/ppandith/wl-39014/sql/sql_select.cc:765
      #23 execute_sqlcom_select (thd=, all_tables=) at /home/ppandith/wl-39014/sql/sql_parse.cc:6214
      #24 mysql_execute_command (thd=, is_called_from_prepared_stmt=false) at /home/ppandith/wl-39014/sql/sql_parse.cc:3988
      #25 mysql_parse (thd=, rawbuf="SELECT t1.pk AS field2 FROM t1 FULL JOIN t2 ON (1) GROUP BY field2 HAVING field2 = 8", length=84, 
          parser_state=) at /home/ppandith/wl-39014/sql/sql_parse.cc:7942
      #26 dispatch_command (command=COM_QUERY, thd=, packet="", packet_length=84, blocking=true)
          at /home/ppandith/wl-39014/sql/sql_parse.cc:1898
      #27 do_command (thd=, blocking=true) at /home/ppandith/wl-39014/sql/sql_parse.cc:1432
      #28 do_handle_one_connection (connect=, put_in_cache=true) at /home/ppandith/wl-39014/sql/sql_connect.cc:1503
      #29 handle_one_connection (arg=) at /home/ppandith/wl-39014/sql/sql_connect.cc:1415
      #30 pfs_spawn_thread (arg=) at /home/ppandith/wl-39014/storage/perfschema/pfs.cc:2198
      #31 start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:447
      #32 clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
      

      Attachments

        Issue Links

          Activity

            People

              Gosselin Dave Gosselin
              mariadb-pavithrapandith Pavithra Pandith
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 3.25h
                  3.25h

                  Git Integration

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