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

Crash in get_best_combination when executing multi-table UPDATE with nested views

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 5.5.40, 5.5(EOL), 10.0(EOL)
    • 5.5.42, 10.0.17
    • Views
    • None

    Description

      Thread pointer: 0x0x7fd13305b200
      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 = 0x11ec47e98 thread_stack 0x48000
      0   mysqld                              0x000000010255b5e9 my_print_stacktrace + 60
      0   mysqld                              0x0000000102117677 handle_fatal_signal + 602
      0   libsystem_platform.dylib            0x00007fff886f4f1a _sigtramp + 26
      0   mysqld                              0x000000010254f44c cleanup_dirname + 591
      0   mysqld                              0x00000001022a113c _Z20get_best_combinationP4JOIN + 97
      0   mysqld                              0x000000010228c3ec _ZN4JOIN8optimizeEv + 10688
      0   mysqld                              0x0000000102243a01 _Z22mysql_derived_optimizeP3THDP3LEXP10TABLE_LIST + 215
      0   mysqld                              0x0000000102244505 _Z27mysql_handle_single_derivedP3LEXP10TABLE_LISTj + 185
      0   mysqld                              0x00000001022f398b _ZN10TABLE_LIST14handle_derivedEP3LEXj + 105
      0   mysqld                              0x0000000102257c7c _ZN13st_select_lex14handle_derivedEP3LEXj + 56
      0   mysqld                              0x0000000102289ad5 _ZN4JOIN8optimizeEv + 169
      0   mysqld                              0x00000001022881ba _Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex + 484
      0   mysqld                              0x00000001022e2d35 _Z18mysql_multi_updateP3THDP10TABLE_LISTP4ListI4ItemES6_PS4_y15enum_duplicatesbP18st_select_lex_unitP13st_select_lexPP12multi_update + 412
      0   mysqld                              0x00000001022667ff _Z21mysql_execute_commandP3THD + 16909
      0   mysqld                              0x0000000102261e4c _Z11mysql_parseP3THDPcjP12Parser_state + 358
      0   mysqld                              0x000000010225f95e _Z16dispatch_command19enum_server_commandP3THDPcj + 957
      0   mysqld                              0x0000000102261ab6 _Z10do_commandP3THD + 226
      0   mysqld                              0x000000010231a25b _Z24do_handle_one_connectionP3THD + 350
      0   mysqld                              0x000000010231a0f0 handle_one_connection + 69
      0   libsystem_pthread.dylib             0x00007fff9344e2fc _pthread_body + 131
      0   libsystem_pthread.dylib             0x00007fff9344e279 _pthread_body + 0
      0   libsystem_pthread.dylib             0x00007fff9344c4b1 thread_start + 13
       
      Trying to get some variables.
      Some pointers may be invalid and cause the dump to abort.
      Query (0x7fd133063c18): is an invalid pointer
      Connection ID (thread ID): 2
      Status: NOT_KILLED
       
      Optimizer switch: index_merge=off,index_merge_union=off,index_merge_sort_union=off,index_merge_intersection=off,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=off,derived_merge=off,derived_with_keys=off,firstmatch=off,loosescan=off,materialization=off,in_to_exists=off,semijoin=off,partial_match_rowid_merge=off,partial_match_table_scan=off,subquery_cache=off,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=off,semijoin_with_cache=off,join_cache_incremental=off,join_cache_hashed=off,join_cache_bka=off,optimize_join_buffer_size=off,table_elimination=off,extended_keys=off

      Test case to follow...

      Attachments

        Activity

          People

            sanja Oleksandr Byelkin
            kolbe Kolbe Kegel (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            5 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.