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

Signal 11 with EXCEPT clause

    XMLWordPrintable

Details

    Description

      Crash in 10.2.14 when using an EXCEPT CLAUSE:

      reproduced with employees sample database.
      Load database.

      CREATE TABLE salaries_tmp SELECT * FROM salaries LIMIT 1000000;
      SELECT * FROM salaries EXCEPT (SELECT * FROM salaries_tmp);
      

      Crash:

      Mar 05 11:20:50 localhost.localdomain mysqld[4985]: 200305 11:20:50 [ERROR] mysqld got signal 11 ;
      Mar 05 11:20:50 localhost.localdomain mysqld[4985]: This could be because you hit a bug. It is also possible that this binary
      Mar 05 11:20:50 localhost.localdomain mysqld[4985]: or one of the libraries it was linked against is corrupt, improperly built,
      Mar 05 11:20:50 localhost.localdomain mysqld[4985]: or misconfigured. This error can also be caused by malfunctioning hardware.
      Mar 05 11:20:50 localhost.localdomain mysqld[4985]: To report this bug, see https://mariadb.com/kb/en/reporting-bugs
      Mar 05 11:20:50 localhost.localdomain mysqld[4985]: We will try our best to scrape up some info that will hopefully help
      Mar 05 11:20:50 localhost.localdomain mysqld[4985]: diagnose the problem, but since we have already crashed,
      Mar 05 11:20:50 localhost.localdomain mysqld[4985]: something is definitely wrong and this may fail.
      Mar 05 11:20:50 localhost.localdomain mysqld[4985]: Server version: 10.2.14-MariaDB
      Mar 05 11:20:50 localhost.localdomain mysqld[4985]: key_buffer_size=134217728
      Mar 05 11:20:50 localhost.localdomain mysqld[4985]: read_buffer_size=131072
      Mar 05 11:20:50 localhost.localdomain mysqld[4985]: max_used_connections=1
      Mar 05 11:20:50 localhost.localdomain mysqld[4985]: max_threads=153
      Mar 05 11:20:50 localhost.localdomain mysqld[4985]: thread_count=7
      Mar 05 11:20:50 localhost.localdomain mysqld[4985]: It is possible that mysqld could use up to
      Mar 05 11:20:50 localhost.localdomain mysqld[4985]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467310 K  
      Mar 05 11:20:50 localhost.localdomain mysqld[4985]: Hope that's ok; if not, decrease some variables in the equation.
      Mar 05 11:20:50 localhost.localdomain mysqld[4985]: Thread pointer: 0x564add3daf08
      Mar 05 11:20:50 localhost.localdomain mysqld[4985]: Attempting backtrace. You can use the following information to find out
      Mar 05 11:20:50 localhost.localdomain mysqld[4985]: where mysqld died. If you see no messages after this, something went
      Mar 05 11:20:50 localhost.localdomain mysqld[4985]: terribly wrong...
      Mar 05 11:20:50 localhost.localdomain mysqld[4985]: stack_bottom = 0x7f63a7123d30 thread_stack 0x49000
      Mar 05 11:20:50 localhost.localdomain mysqld[4985]: mysys/stacktrace.c:268(my_print_stacktrace)[0x564adabd958e]
      Mar 05 11:20:50 localhost.localdomain mysqld[4985]: sql/signal_handler.cc:168(handle_fatal_signal)[0x564ada66dcc5]
      Mar 05 11:20:50 localhost.localdomain mysqld[4985]: sigaction.c:0(__restore_rt)[0x7f63b42845f0]
      Mar 05 11:20:50 localhost.localdomain mysqld[4985]: maria/ma_unique.c:114(_ma_unique_hash)[0x564adaacf920]
      Mar 05 11:20:50 localhost.localdomain mysqld[4985]: maria/ha_maria.cc:3960(ha_maria::find_unique_row(unsigned char*, unsigned int))[
      Mar 05 11:20:50 localhost.localdomain mysqld[4985]: sql/sql_union.cc:187(select_unit::send_data(List<Item>&))[0x564ada540c33]
      Mar 05 11:20:50 localhost.localdomain mysqld[4985]: sql/sql_select.cc:20234(end_send(JOIN*, st_join_table*, bool))[0x564ada4f3a4f]
      Mar 05 11:20:50 localhost.localdomain mysqld[4985]: sql/sql_class.h:3663(THD::get_stmt_da())[0x564ada4db1c3]
      Mar 05 11:20:50 localhost.localdomain mysqld[4985]: sql/sql_select.cc:19074(sub_select(JOIN*, st_join_table*, bool))[0x564ada4e3bbe]
      Mar 05 11:20:50 localhost.localdomain mysqld[4985]: sql/sql_select.cc:18611(do_select)[0x564ada5035af]
      Mar 05 11:20:50 localhost.localdomain mysqld[4985]: sql/sql_select.cc:3425(JOIN::exec())[0x564ada5037c3]
      Mar 05 11:20:50 localhost.localdomain mysqld[4985]: sql/sql_union.cc:1437(st_select_lex_unit::exec())[0x564ada5425eb]
      Mar 05 11:20:50 localhost.localdomain mysqld[4985]: sql/sql_union.cc:41(mysql_union(THD*, LEX*, select_result*, st_select_lex_unit*,
      Mar 05 11:20:50 localhost.localdomain mysqld[4985]: sql/sql_class.h:3653(handle_select(THD*, LEX*, select_result*, unsigned long))[0
      Mar 05 11:20:50 localhost.localdomain mysqld[4985]: sql/sql_parse.cc:6515(execute_sqlcom_select(THD*, TABLE_LIST*))[0x564ada3ca5c1]
      Mar 05 11:20:50 localhost.localdomain mysqld[4985]: sql/sql_parse.cc:3739(mysql_execute_command(THD*))[0x564ada4b16a0]
      Mar 05 11:20:50 localhost.localdomain mysqld[4985]: sql/sql_parse.cc:7982(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool
      Mar 05 11:20:50 localhost.localdomain mysqld[4985]: sql/sql_parse.cc:1838(dispatch_command(enum_server_command, THD*, char*, unsigne
      Mar 05 11:20:50 localhost.localdomain mysqld[4985]: sql/sql_parse.cc:1388(do_command(THD*))[0x564ada4b8e29]
      Mar 05 11:20:50 localhost.localdomain mysqld[4985]: sql/sql_connect.cc:1335(do_handle_one_connection(CONNECT*))[0x564ada57fcca]
      Mar 05 11:20:50 localhost.localdomain mysqld[4985]: sql/sql_connect.cc:1243(handle_one_connection)[0x564ada57fded]
      Mar 05 11:20:50 localhost.localdomain mysqld[4985]: pthread_create.c:0(start_thread)[0x7f63b427ce65]
      Mar 05 11:20:50 localhost.localdomain mysqld[4985]: /lib64/libc.so.6(clone+0x6d)[0x7f63b261d88d]
      Mar 05 11:20:50 localhost.localdomain mysqld[4985]: Trying to get some variables.
      Mar 05 11:20:50 localhost.localdomain mysqld[4985]: Some pointers may be invalid and cause the dump to abort.
      Mar 05 11:20:50 localhost.localdomain mysqld[4985]: Query (0x564add3e8690): select * from salaries except (select * from salaries_tm
      Mar 05 11:20:50 localhost.localdomain mysqld[4985]: Connection ID (thread ID): 10
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              kjoiner Kyle Joiner (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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