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

SIGSEGV in get_param_default_value | store_schema_params

    XMLWordPrintable

Details

    • Q4/2025 Server Maintenance

    Description

      --DELIMITER //
      CREATE PROCEDURE p0 (x INT DEFAULT func()) 
      BEGIN 
        SELECT x;
      END;
      //
      --DELIMITER ;
      SET SESSION max_session_mem_used=8192;
      --ERROR ER_OPTION_PREVENTS_STATEMENT
      CALL p0();
      SET @@max_session_mem_used=DEFAULT;
      --ERROR ER_SP_DOES_NOT_EXIST
      CALL p0();
      SELECT * FROM information_schema.PARAMETERS;
      

      Leads to

      MDEV-37054 CS 12.2.0 5f880b3d4a8561defb2c7177773b37e1ebf7312e (Debug, Clang) Build 18/08/2025

      Core was generated by `/test/mtest/MDEV-27305/MD180825-mariadb-12.2.0-linux-x86_64-dbg/bin/mariadbd --'.
      Program terminated with signal SIGSEGV, Segmentation fault.
      #0  0x000056ce58c9674a in get_param_default_value (item=0x789e900250c0, default_value=0x78bd78323650)at /test/mtest/MDEV-27305/12.2_dbg/sql/sql_show.cc:1938
       
      [Current thread is 1 (LWP 2515402)]
      (gdb) bt
      #0  0x000056ce58c9674a in get_param_default_value (item=0x789e900250c0, default_value=0x78bd78323650)at /test/mtest/MDEV-27305/12.2_dbg/sql/sql_show.cc:1938
      #1  0x000056ce58c95dcf in store_schema_params (thd=0x789e90000d58, table=0x789e90057ac0, proc_table=0x789e900356d8, lookup=0x78bd783246d8, full_access=true, sp_user=0x78bd78325b50 "root@localhost")at /test/mtest/MDEV-27305/12.2_dbg/sql/sql_show.cc:7115
      #2  0x000056ce58c97c13 in fill_schema_proc (thd=0x789e90000d58, tables=0x789e9001a5c8, cond=0x0)at /test/mtest/MDEV-27305/12.2_dbg/sql/sql_show.cc:7371
      #3  0x000056ce58c9ccfa in get_schema_tables_result (join=0x789e9001bf10, executed_place=PROCESSED_BY_JOIN_EXEC)at /test/mtest/MDEV-27305/12.2_dbg/sql/sql_show.cc:9780
      #4  0x000056ce58c360b8 in JOIN::exec_inner (this=0x789e9001bf10)at /test/mtest/MDEV-27305/12.2_dbg/sql/sql_select.cc:5047
      #5  0x000056ce58c3556e in JOIN::exec (this=0x789e9001bf10)at /test/mtest/MDEV-27305/12.2_dbg/sql/sql_select.cc:4874
      #6  0x000056ce58c100dd in mysql_select (thd=0x789e90000d58, tables=0x789e9001a5c8, fields=@0x789e9001a1f0: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x789e9001a538, last = 0x789e9001df80, elements = 17}, <No data fields>}, conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2701396736, result=0x789e9001bee8, unit=0x789e90005158, select_lex=0x789e90019f38)at /test/mtest/MDEV-27305/12.2_dbg/sql/sql_select.cc:5402
      #7  0x000056ce58c0fb65 in handle_select (thd=0x789e90000d58, lex=0x789e90005078, result=0x789e9001bee8, setup_tables_done_option=0)at /test/mtest/MDEV-27305/12.2_dbg/sql/sql_select.cc:634
      #8  0x000056ce58bb76a1 in execute_sqlcom_select (thd=0x789e90000d58, all_tables=0x789e9001a5c8)at /test/mtest/MDEV-27305/12.2_dbg/sql/sql_parse.cc:6167
      #9  0x000056ce58bac42e in mysql_execute_command (thd=0x789e90000d58, is_called_from_prepared_stmt=false)at /test/mtest/MDEV-27305/12.2_dbg/sql/sql_parse.cc:3950
      #10 0x000056ce58ba46f4 in mysql_parse (thd=0x789e90000d58, rawbuf=0x789e90019e80 "SELECT * FROM information_schema.PARAMETERS", length=43, parser_state=0x78bd78328a10)at /test/mtest/MDEV-27305/12.2_dbg/sql/sql_parse.cc:7883
      #11 0x000056ce58ba1ac8 in dispatch_command (command=COM_QUERY, thd=0x789e90000d58, packet=0x789e9000b1f9 "SELECT * FROM information_schema.PARAMETERS", packet_length=43, blocking=true)at /test/mtest/MDEV-27305/12.2_dbg/sql/sql_parse.cc:1878
      #12 0x000056ce58ba52a3 in do_command (thd=0x789e90000d58, blocking=true)at /test/mtest/MDEV-27305/12.2_dbg/sql/sql_parse.cc:1417
      #13 0x000056ce58d92869 in do_handle_one_connection (connect=0x56ce80a49498, put_in_cache=true)at /test/mtest/MDEV-27305/12.2_dbg/sql/sql_connect.cc:1414
      #14 0x000056ce58d9260e in handle_one_connection (arg=0x56ce80a5a548)at /test/mtest/MDEV-27305/12.2_dbg/sql/sql_connect.cc:1326
      #15 0x000078bd7b49caa4 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
      #16 0x000078bd7b529c3c in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
      

      Attachments

        Issue Links

          Activity

            People

              shulga Dmitry Shulga
              ramesh Ramesh Sivaraman
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.