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

Assertion `thd->abort_on_warning == 0' failed in dispatch_command_return dispatch_command(enum enum_server_command, THD *, char *, uint, bool)

    XMLWordPrintable

Details

    • Can result in hang or crash

    Description

      --source include/have_innodb.inc
       
      CREATE TABLE t1 (id INT KEY,v VECTOR (8) NOT NULL,VECTOR INDEX (v)) ENGINE=INNODB;
      CREATE TABLE t2 (id INT KEY,t_id INT,INDEX par_ind (t_id),FOREIGN KEY(t_id) REFERENCES t1 (id) ON DELETE CASCADE) ENGINE=INNODB;
      --ERROR ER_ROW_IS_REFERENCED_2
      DROP TABLE t1;
      --ERROR ER_NO_SUCH_TABLE
      INSERT INTO t1 VALUES (0,'');
       
      # cleanup
      DROP TABLE t2,t1;
      
      

      Leads to:

      CS 12.3.0 5879c85f505d3a11d4b8f479f2437416d8a1d724 (Debug, Clang 18.1.3-11) Build 12/12/2025

      mariadbd: /test/12.3_dbg/sql/sql_parse.cc:2497: dispatch_command_return dispatch_command(enum enum_server_command, THD *, char *, uint, bool): Assertion `thd->abort_on_warning == 0' failed.
      

      CS 12.3.0 5879c85f505d3a11d4b8f479f2437416d8a1d724 (Debug, Clang 18.1.3-11) Build 12/12/2025

      Core was generated by `/test/MD121225-mariadb-12.3.0-linux-x86_64-dbg/bin/mariadbd --no-defaults --max'.
      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 1460850)]
      (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  0x000072e90ac4527e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
      #4  0x000072e90ac288ff in __GI_abort () at ./stdlib/abort.c:79
      #5  0x000072e90ac2881b in __assert_fail_base (fmt=0x72e90add01e8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x6342338592f6 "thd->abort_on_warning == 0", file=file@entry=0x634233858a83 "/test/12.3_dbg/sql/sql_parse.cc", line=line@entry=2497, function=function@entry=0x634233858ed8 "dispatch_command_return dispatch_command(enum enum_server_command, THD *, char *, uint, bool)")at ./assert/assert.c:96
      #6  0x000072e90ac3b517 in __assert_fail (assertion=0x6342338592f6 "thd->abort_on_warning == 0", file=0x634233858a83 "/test/12.3_dbg/sql/sql_parse.cc", line=2497, function=0x634233858ed8 "dispatch_command_return dispatch_command(enum enum_server_command, THD *, char *, uint, bool)") at ./assert/assert.c:105
      #7  0x0000634232780c7a in dispatch_command (command=COM_QUERY, thd=0x72e7e0000d58, packet=0x72e7e000b239 "", packet_length=27, blocking=true) at /test/12.3_dbg/sql/sql_parse.cc:2497
      #8  0x0000634232782203 in do_command (thd=0x72e7e0000d58, blocking=true)at /test/12.3_dbg/sql/sql_parse.cc:1417
      #9  0x0000634232970449 in do_handle_one_connection (connect=0x6342522219d8, put_in_cache=true) at /test/12.3_dbg/sql/sql_connect.cc:1503
      #10 0x00006342329701ee in handle_one_connection (arg=0x6342521ef3e8)at /test/12.3_dbg/sql/sql_connect.cc:1415
      #11 0x000072e90ac9caa4 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
      #12 0x000072e90ad29c6c in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
      

      Bug Detection Matrix

          Rel    o/d  Build   Commit                                    UniqueID observed             
      CS  10.11  dbg  121225  4ee491f1b2eb356e9dc40f388f79b62cfeb13609  No bug found                  
      CS  10.11  opt  121225  4ee491f1b2eb356e9dc40f388f79b62cfeb13609  No bug found                  
      CS  11.4   dbg  121225  4cff562f3f89d4df03e09233d835d0451bc37cc4  No bug found                  
      CS  11.4   opt  121225  4cff562f3f89d4df03e09233d835d0451bc37cc4  No bug found                  
      CS  11.8   dbg  121225  a7528a6190807281d3224e4e67a9b76083a202a6  thd->abort_on_warning == 0|SIGABRT|dispatch_command|do_command|do_handle_one_connection|handle_one_connection
      CS  11.8   opt  121225  a7528a6190807281d3224e4e67a9b76083a202a6  No bug found                  
      CS  12.1   dbg  121225  70117463f032d59f8e328335e19b59157d34cf07  thd->abort_on_warning == 0|SIGABRT|dispatch_command|do_command|do_handle_one_connection|handle_one_connection
      CS  12.1   opt  121225  70117463f032d59f8e328335e19b59157d34cf07  No bug found                  
      CS  12.2   dbg  121225  997d0c4dfc551ea54faa1e9b7d56f3a0ff2ca849  thd->abort_on_warning == 0|SIGABRT|dispatch_command|do_command|do_handle_one_connection|handle_one_connection
      CS  12.2   dbg  251125  5676ecfbb3716937129105d98e69355e90bfa3f8  thd->abort_on_warning == 0|SIGABRT|dispatch_command|do_command|do_handle_one_connection|handle_one_connection
      CS  12.2   opt  121225  997d0c4dfc551ea54faa1e9b7d56f3a0ff2ca849  No bug found                  
      CS  12.2   opt  251125  5676ecfbb3716937129105d98e69355e90bfa3f8  No bug found                  
      CS  12.3   dbg  121225  5879c85f505d3a11d4b8f479f2437416d8a1d724  thd->abort_on_warning == 0|SIGABRT|dispatch_command|do_command|do_handle_one_connection|handle_one_connection
      CS  12.3   opt  121225  5879c85f505d3a11d4b8f479f2437416d8a1d724  No bug found                  
      ES  10.6   dbg  151225  bc33b05c6a65de27dbe811a30bc37c207d60ee8e  No bug found
      ES  10.6   opt  151225  bc33b05c6a65de27dbe811a30bc37c207d60ee8e  No bug found
      ES  11.4   dbg  151225  714f2134597e00f4ff107886cf3a55eff48e4510  thd->abort_on_warning == 0|SIGABRT|dispatch_command|do_command|do_handle_one_connection|handle_one_connection
      ES  11.4   opt  151225  714f2134597e00f4ff107886cf3a55eff48e4510  No bug found                  
      ES  11.8   dbg  151225  4008de1a5b06105a64821db7b851328f1b27d99e  thd->abort_on_warning == 0|SIGABRT|dispatch_command|do_command|do_handle_one_connection|handle_one_connection
      ES  11.8   opt  151225  4008de1a5b06105a64821db7b851328f1b27d99e  No bug found                  
      

      No UB/ASAN issues observed

      Attachments

        Activity

          People

            serg Sergei Golubchik
            ramesh Ramesh Sivaraman
            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.