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

Server crash after query

    XMLWordPrintable

Details

    Description

      SELECT optimizer_switch ;
      SELECT 2231626 IN ( SELECT 10 INTERSECT ALL SELECT 1 ORDER BY AVG ( '2006-05-21' ) OVER ( ) ) = 2058 ;
      select @ SELECT optimizer_switch ;
      SELECT ; ;
      show SELECT optimizer_switch = "default" ;
      select @ @ session . optimizer_switch ;

      Thread pointer: 0x62b00016c218
      Attempting backtrace. You can use the following information to find out
      where mysqld died. If you see no messages after this, something went
      terribly wrong...
      stack_bottom = 0x7fad867e1880 thread_stack 0x5fc00
      /usr/local/mysql/bin/mariadbd(__interceptor_backtrace+0x5b)[0x781b5b]
      mysys/stacktrace.c:215(my_print_stacktrace)[0x228cfae]
      sql/signal_handler.cc:0(handle_fatal_signal)[0x12bd0d2]
      sigaction.c:0(__restore_rt)[0x7fada8942420]
      sql/sql_analyze_stmt.h:112(Exec_time_tracker::get_loops() const)[0x12abc71]
      sql/sql_select.cc:26909(create_sort_index(THD*, JOIN*, st_join_table*, Filesort*))[0xca6c82]
      /usr/local/mysql/bin/mariadbd(_ZN17Window_funcs_sort4execEP4JOINb+0xe6)[0x1113946]
      /usr/local/mysql/bin/mariadbd(_ZN24Window_funcs_computation4execEP4JOINb+0x4d)[0x1115bcd]
      sql/sql_select.cc:32382(AGGR_OP::end_send())[0xca0669]
      sql/sql_select.cc:23189(sub_select_postjoin_aggr(JOIN*, st_join_table*, bool))[0xc3c211]
      /usr/local/mysql/bin/mariadbd(_ZN4JOIN10exec_innerEv+0x28cc)[0xc4899c]
      sql/sql_select.cc:4721(JOIN::exec())[0xc45f19]
      sql/sql_select.cc:5251(mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0xbe89b8]
      /usr/local/mysql/bin/mariadbd(_ZN18st_select_lex_unit10exec_innerEv+0x183e)[0xdfa01e]
      sql/item_subselect.cc:4188(subselect_union_engine::exec())[0x15b5c25]
      sql/item_subselect.cc:817(Item_subselect::exec())[0x1591e4b]
      sql/item_subselect.cc:1991(Item_in_subselect::val_bool())[0x159b6f0]
      sql/item_cmpfunc.cc:1714(Item_in_optimizer::val_int())[0x13973d7]
      sql/item_cmpfunc.cc:994(Arg_comparator::compare_int_signed())[0x139060f]
      sql/item_cmpfunc.cc:1830(Item_func_eq::val_int())[0x13982b2]
      sql/sql_type.cc:7472(Type_handler::Item_send_long(Item*, Protocol*, st_value*) const)[0x10f4562]
      sql/protocol.cc:1334(Protocol::send_result_set_row(List<Item>*))[0x8a35e8]
      sql/sql_class.cc:3130(select_send::send_data(List<Item>&))[0xa1841d]
      sql/sql_select.cc:4809(JOIN::exec_inner())[0xc48ade]
      sql/sql_select.cc:4721(JOIN::exec())[0xc45f19]
      sql/sql_select.cc:5251(mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0xbe89b8]
      sql/sql_select.cc:628(handle_select(THD*, LEX*, select_result*, unsigned long long))[0xbe7e59]
      sql/sql_parse.cc:6041(execute_sqlcom_select(THD*, TABLE_LIST*))[0xb41bc6]
      /usr/local/mysql/bin/mariadbd(_Z21mysql_execute_commandP3THDb+0x18b7)[0xb319a7]
      sql/sql_class.h:2830(THD::enter_stage(PSI_stage_info_v1 const*, char const*, char const*, unsigned int))[0xb24c79]
      /usr/local/mysql/bin/mariadbd(_Z16dispatch_command19enum_server_commandP3THDPcjb+0x2cf8)[0xb1e648]
      sql/sql_parse.cc:1407(do_command(THD*, bool))[0xb25971]
      sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0xf0d066]
      sql/sql_connect.cc:1322(handle_one_connection)[0xf0caa9]
      perfschema/pfs.cc:2203(pfs_spawn_thread)[0x19d710b]
      nptl/pthread_create.c:478(start_thread)[0x7fada8936609]
      addr2line: DWARF error: section .debug_info is larger than its filesize! (0x93ef57 vs 0x530f28)
      /lib/x86_64-linux-gnu/libc.so.6(clone+0x43)[0x7fada864e133]

      Trying to get some variables.
      Some pointers may be invalid and cause the dump to abort.
      Query (0x629000087238): SELECT 2231626 IN ( SELECT 10 INTERSECT ALL SELECT 1 ORDER BY AVG ( '2006-05-21' ) OVER ( ) ) = 2058

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              csfuzz csfuzz
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.