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

The mysqld service core occurs when the query statement executes the execution plan

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Critical
    • Resolution: Unresolved
    • 10.5.16, 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 11.0(EOL)
    • 10.5, 10.6, 11.4
    • Optimizer
    • centos 7.6

    Description

      Step 1: Create a table and insert data
      1. Create database sqltester
      create database sqltester
      2. Execute the attachment file to create a table and insert data
      source sqltester_ for_ parallel_ with_ index.2k_ dp_ 210col.index_ desc.sql
      3. Execute the attachment file to create a table and insert data
      source sqltester_ for_ parallel_ with_ index_ view_ part_ tab.sql
      Step 2: Execute the query plan
      source explain_ temp_ sql.sql

      Attachments

        1. image-2023-02-22-20-44-48-747.png
          image-2023-02-22-20-44-48-747.png
          69 kB
        2. mdev30711_initial.test
          2.90 MB
        3. mdev30711.test
          65 kB
        4. sql_file.rar
          93 kB

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-32607 Server crash on query

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-30081 Crash with splitting from constant mergeable derived table

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14999 [Draft] Server crashes in optimize_keyuse

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33139 Crash of INSERT SELECT when preparing structures for split optimization

          • Critical - Crashes, loss of data, severe memory leak.
          • Stalled

          Activity

            alice Alice Sherepa added a comment -

            Thanks!
            I repeated on 10.3-10.11,11.0 with the attached test mdev30711.test

            230227 17:57:56 [ERROR] mysqld got signal 11 ;
            		 
             
            		 
            Server version: 10.3.38-MariaDB-debug-log source revision: 2743a510a156456fe57429032bf41c0da0f11198
            		 
             
            		 
            sql/signal_handler.cc:233(handle_fatal_signal)[0x556ce507ac37]
            		 
            sigaction.c:0(__restore_rt)[0x7faa8ea0c420]
            		 
            sql/sql_select.cc:6648(optimize_keyuse(JOIN*, st_dynamic_array*))[0x556ce49dd97a]
            		 
            sql/opt_split.cc:777(JOIN::add_keyuses_for_splitting())[0x556ce4e66e27]
            		 
            sql/opt_split.cc:803(st_join_table::add_keyuses_for_splitting())[0x556ce4e672a6]
            		 
            sql/sql_select.cc:5090(make_join_statistics(JOIN*, List<TABLE_LIST>&, st_dynamic_array*))[0x556ce49cf384]
            		 
            sql/sql_select.cc:2000(JOIN::optimize_inner())[0x556ce49afbac]
            		 
            sql/sql_select.cc:1542(JOIN::optimize())[0x556ce49ab086]
            		 
            sql/sql_lex.cc:4107(st_select_lex::optimize_unflattened_subqueries(bool))[0x556ce489db72]
            		 
            sql/opt_subselect.cc:5445(JOIN::optimize_constant_subqueries())[0x556ce4db04c6]
            		 
            sql/sql_select.cc:1741(JOIN::optimize_inner())[0x556ce49acc6b]
            		 
            sql/sql_select.cc:1542(JOIN::optimize())[0x556ce49ab086]
            		 
            sql/sql_select.cc:4379(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x556ce49c883b]
            		 
            sql/sql_select.cc:372(handle_select(THD*, LEX*, select_result*, unsigned long))[0x556ce499ea1f]
            		 
            sql/sql_parse.cc:6340(execute_sqlcom_select(THD*, TABLE_LIST*))[0x556ce490f708]
            		 
            sql/sql_parse.cc:3871(mysql_execute_command(THD*))[0x556ce48fd72e]
            		 
            sql/sql_parse.cc:7855(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x556ce49193ea]
            		 
            sql/sql_parse.cc:1855(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x556ce48f03a7]
            		 
            sql/sql_parse.cc:1398(do_command(THD*))[0x556ce48ecec6]
            		 
            sql/sql_connect.cc:1404(do_handle_one_connection(CONNECT*))[0x556ce4cc362d]
            		 
            sql/sql_connect.cc:1310(handle_one_connection)[0x556ce4cc2ee7]
            		 
            perfschema/pfs.cc:1871(pfs_spawn_thread)[0x556ce62fa201]
            		 
            nptl/pthread_create.c:478(start_thread)[0x7faa8ea00609]
            		 
            /lib/x86_64-linux-gnu/libc.so.6(clone+0x43)[0x7faa8e925133]
            		 
             
            		 
            Query (0x62b000000290): SELECT 1
            		 
            FROM
            		 
            (SELECT 1
            		 
            FROM v6
            		 
            LEFT JOIN tt2 ON (v6.c_credit = tt2.c_chartwo)
            		 
            JOIN t0
            		 
            JOIN v7 ON 0 ON 0
            		 
            LEFT JOIN tt4 AS ref_7 ON (ref_7.date_col IS NOT NULL)
            		 
            JOIN t0 AS ref_8
            		 
            JOIN v5 ON 0 ON (v5.c_middle IS NOT NULL)) AS subq_0
            		 
            JOIN v8 ON 1
            		 
            WHERE (EXISTS
            		 
            (SELECT 1
            		 
            FROM v1
            		 
            LEFT JOIN v2
            		 
            JOIN v3 ON (v2.c3 = v3.c0)
            		 
            JOIN tt2 AS ref_31
            		 
            JOIN v4
            		 
            LEFT JOIN v3 AS ref_33
            		 
            JOIN tt7 ON 0 ON 1 ON (ref_33.c0 IS NULL) ON 1 ON (v1.c_credit_lim = ref_31.c_decimal)
            		 
            WHERE tt7.c_timestamp IS NULL))
            		 
            OR 1

            Please check mdev30711_initial.test after the fix.

            alice Alice Sherepa added a comment - Thanks! I repeated on 10.3-10.11,11.0 with the attached test mdev30711.test 230227 17:57:56 [ERROR] mysqld got signal 11 ;   Server version: 10.3.38-MariaDB-debug-log source revision: 2743a510a156456fe57429032bf41c0da0f11198   sql/signal_handler.cc:233(handle_fatal_signal)[0x556ce507ac37] sigaction.c:0(__restore_rt)[0x7faa8ea0c420] sql/sql_select.cc:6648(optimize_keyuse(JOIN*, st_dynamic_array*))[0x556ce49dd97a] sql/opt_split.cc:777(JOIN::add_keyuses_for_splitting())[0x556ce4e66e27] sql/opt_split.cc:803(st_join_table::add_keyuses_for_splitting())[0x556ce4e672a6] sql/sql_select.cc:5090(make_join_statistics(JOIN*, List<TABLE_LIST>&, st_dynamic_array*))[0x556ce49cf384] sql/sql_select.cc:2000(JOIN::optimize_inner())[0x556ce49afbac] sql/sql_select.cc:1542(JOIN::optimize())[0x556ce49ab086] sql/sql_lex.cc:4107(st_select_lex::optimize_unflattened_subqueries(bool))[0x556ce489db72] sql/opt_subselect.cc:5445(JOIN::optimize_constant_subqueries())[0x556ce4db04c6] sql/sql_select.cc:1741(JOIN::optimize_inner())[0x556ce49acc6b] sql/sql_select.cc:1542(JOIN::optimize())[0x556ce49ab086] sql/sql_select.cc:4379(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x556ce49c883b] sql/sql_select.cc:372(handle_select(THD*, LEX*, select_result*, unsigned long))[0x556ce499ea1f] sql/sql_parse.cc:6340(execute_sqlcom_select(THD*, TABLE_LIST*))[0x556ce490f708] sql/sql_parse.cc:3871(mysql_execute_command(THD*))[0x556ce48fd72e] sql/sql_parse.cc:7855(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x556ce49193ea] sql/sql_parse.cc:1855(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x556ce48f03a7] sql/sql_parse.cc:1398(do_command(THD*))[0x556ce48ecec6] sql/sql_connect.cc:1404(do_handle_one_connection(CONNECT*))[0x556ce4cc362d] sql/sql_connect.cc:1310(handle_one_connection)[0x556ce4cc2ee7] perfschema/pfs.cc:1871(pfs_spawn_thread)[0x556ce62fa201] nptl/pthread_create.c:478(start_thread)[0x7faa8ea00609] /lib/x86_64-linux-gnu/libc.so.6(clone+0x43)[0x7faa8e925133]   Query (0x62b000000290): SELECT 1 FROM (SELECT 1 FROM v6 LEFT JOIN tt2 ON (v6.c_credit = tt2.c_chartwo) JOIN t0 JOIN v7 ON 0 ON 0 LEFT JOIN tt4 AS ref_7 ON (ref_7.date_col IS NOT NULL) JOIN t0 AS ref_8 JOIN v5 ON 0 ON (v5.c_middle IS NOT NULL)) AS subq_0 JOIN v8 ON 1 WHERE (EXISTS (SELECT 1 FROM v1 LEFT JOIN v2 JOIN v3 ON (v2.c3 = v3.c0) JOIN tt2 AS ref_31 JOIN v4 LEFT JOIN v3 AS ref_33 JOIN tt7 ON 0 ON 1 ON (ref_33.c0 IS NULL) ON 1 ON (v1.c_credit_lim = ref_31.c_decimal) WHERE tt7.c_timestamp IS NULL)) OR 1 Please check mdev30711_initial.test after the fix.

            People

              igor Igor Babaev
              guozhentang guozhentang
              Votes:
              1 Vote for this issue
              Watchers:
              6 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.