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

Server crashes in fix_semijoin_strategies_for_picked_join_order

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 10.2.23
    • Fix Version/s: N/A
    • Component/s: N/A
    • Labels:
      None

      Description

      This crash happened simultaneously on 3 nodes of a galera cluster.
      Seems related to MDEV-18467 which has been fixed in 10.3 but no mention of 10.2.
      Tried the use case from that ticket but did not crash the server.

      stack_bottom = 0x7f9d38485cf8 thread_stack 0x49000
      *** buffer overflow detected ***: /usr/sbin/mysqld terminated
      ======= Backtrace: =========
      /lib/x86_64-linux-gnu/libc.so.6(+0x70bfb)[0x7fa704e5fbfb]
      /lib/x86_64-linux-gnu/libc.so.6(__fortify_fail+0x37)[0x7fa704ee8437]
      /lib/x86_64-linux-gnu/libc.so.6(+0xf7570)[0x7fa704ee6570]
      /lib/x86_64-linux-gnu/libc.so.6(+0xf93aa)[0x7fa704ee83aa]
      /usr/sbin/mysqld(my_addr_resolve+0xe2)[0x55877900a922]
      /usr/sbin/mysqld(my_print_stacktrace+0x1bb)[0x558778ff11eb]
      /usr/sbin/mysqld(handle_fatal_signal+0x41d)[0x558778a9001d]
      /lib/x86_64-linux-gnu/libpthread.so.0(+0x110e0)[0x7fa7067820e0]
      /usr/sbin/mysqld(_Z45fix_semijoin_strategies_for_picked_join_orderP4JOIN+0x8f)[0x5587789fabcf]
      /usr/sbin/mysqld(_ZN4JOIN20get_best_combinationEv+0xc1)[0x558778922531]
      /usr/sbin/mysqld(+0x50d472)[0x55877893c472]
      /usr/sbin/mysqld(_ZN4JOIN14optimize_innerEv+0x9ab)[0x558778941f4b]
      /usr/sbin/mysqld(_ZN4JOIN8optimizeEv+0x42)[0x5587789443d2]
      /usr/sbin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x87d)[0x55877894634d]
      /usr/sbin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x135)[0x5587789464f5]
      /usr/sbin/mysqld(+0x4022bf)[0x5587788312bf]
      /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x3469)[0x5587788f13e9]
      /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x28a)[0x5587788f6e4a]
      /usr/sbin/mysqld(+0x4c864f)[0x5587788f764f]
      /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x1a7c)[0x5587788f97fc]
      /usr/sbin/mysqld(_Z10do_commandP3THD+0x176)[0x5587788fa8a6]
      /usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x25a)[0x5587789c4c0a]
      /usr/sbin/mysqld(handle_one_connection+0x3d)[0x5587789c4d7d]
      /lib/x86_64-linux-gnu/libpthread.so.0(+0x74a4)[0x7fa7067784a4]
      /lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7fa704ed7d0f]
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              rpizzi Rick Pizzi
              Votes:
              1 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: