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

Signal 11 on SELECT query

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • 10.3.12
    • N/A
    • Server
    • Ubuntu 16.04

    Description

      MariaDB 10.3.12 crashed on a SELECT query. Below is the log:

      Mar 3 00:00:42 masha2 mysqld[5776]: 190303 0:00:42 [ERROR] mysqld got signal 11 ;
      Mar 3 00:00:42 masha2 mysqld[5776]: This could be because you hit a bug. It is also possible that this binary
      Mar 3 00:00:42 masha2 mysqld[5776]: or one of the libraries it was linked against is corrupt, improperly built,
      Mar 3 00:00:42 masha2 mysqld[5776]: or misconfigured. This error can also be caused by malfunctioning hardware.
      Mar 3 00:00:42 masha2 mysqld[5776]: To report this bug, see https://mariadb.com/kb/en/reporting-bugs
      Mar 3 00:00:42 masha2 mysqld[5776]: We will try our best to scrape up some info that will hopefully help
      Mar 3 00:00:42 masha2 mysqld[5776]: diagnose the problem, but since we have already crashed,
      Mar 3 00:00:42 masha2 mysqld[5776]: something is definitely wrong and this may fail.
      Mar 3 00:00:42 masha2 mysqld[5776]: Server version: 10.3.12-MariaDB-1:10.3.12+maria~xenial-log
      Mar 3 00:00:42 masha2 mysqld[5776]: key_buffer_size=134217728
      Mar 3 00:00:42 masha2 mysqld[5776]: read_buffer_size=2097152
      Mar 3 00:00:42 masha2 mysqld[5776]: max_used_connections=188
      Mar 3 00:00:42 masha2 mysqld[5776]: max_threads=202
      Mar 3 00:00:42 masha2 mysqld[5776]: thread_count=121
      Mar 3 00:00:42 masha2 mysqld[5776]: It is possible that mysqld could use up to
      Mar 3 00:00:42 masha2 mysqld[5776]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 1376641 K bytes of memory
      Mar 3 00:00:42 masha2 mysqld[5776]: Hope that's ok; if not, decrease some variables in the equation.
      Mar 3 00:00:42 masha2 mysqld[5776]: Thread pointer: 0x7f841c020228
      Mar 3 00:00:42 masha2 mysqld[5776]: Attempting backtrace. You can use the following information to find out
      Mar 3 00:00:42 masha2 mysqld[5776]: where mysqld died. If you see no messages after this, something went
      Mar 3 00:00:42 masha2 mysqld[5776]: terribly wrong...
      Mar 3 00:00:42 masha2 mysqld[5776]: stack_bottom = 0x7f8420234cf8 thread_stack 0x49000
      Mar 3 00:00:42 masha2 mysqld[5776]: /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x55f71bc25e0e]
      Mar 3 00:00:42 masha2 mysqld[5776]: /usr/sbin/mysqld(handle_fatal_signal+0x347)[0x55f71b6d4ee7]
      Mar 3 00:00:42 masha2 mysqld[5776]: /lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7f8c38a91390]
      Mar 3 00:00:42 masha2 mysqld[5776]: /usr/sbin/mysqld(+0xa354e1)[0x55f71b9b94e1]
      Mar 3 00:00:42 masha2 mysqld[5776]: /usr/sbin/mysqld(+0xb18b63)[0x55f71ba9cb63]
      Mar 3 00:00:42 masha2 mysqld[5776]: /usr/sbin/mysqld(+0xb19cee)[0x55f71ba9dcee]
      Mar 3 00:00:43 masha2 mysqld[5776]: /usr/sbin/mysqld(+0xb0f3ef)[0x55f71ba933ef]
      Mar 3 00:00:43 masha2 mysqld[5776]: /usr/sbin/mysqld(+0xa7ee26)[0x55f71ba02e26]
      Mar 3 00:00:43 masha2 mysqld[5776]: /usr/sbin/mysqld(+0x9a3f6a)[0x55f71b927f6a]
      Mar 3 00:00:43 masha2 mysqld[5776]: /usr/sbin/mysqld(_ZN7handler17ha_index_read_mapEPhPKhm16ha_rkey_function+0x138)[0x55f71b6da2a8]
      Mar 3 00:00:43 masha2 mysqld[5776]: /usr/sbin/mysqld(+0x5b6948)[0x55f71b53a948]
      Mar 3 00:00:43 masha2 mysqld[5776]: /usr/sbin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x164)[0x55f71b52ce34]
      Mar 3 00:00:44 masha2 mysqld[5776]: /usr/sbin/mysqld(+0x59e5de)[0x55f71b5225de]
      Mar 3 00:00:44 masha2 mysqld[5776]: /usr/sbin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x179)[0x55f71b52ce49]
      Mar 3 00:00:44 masha2 mysqld[5776]: /usr/sbin/mysqld(+0x59e5de)[0x55f71b5225de]
      Mar 3 00:00:44 masha2 mysqld[5776]: /usr/sbin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x1e0)[0x55f71b52ceb0]
      Mar 3 00:00:44 masha2 mysqld[5776]: /usr/sbin/mysqld(_ZN4JOIN10exec_innerEv+0xb72)[0x55f71b54cbe2]
      Mar 3 00:00:44 masha2 mysqld[5776]: /usr/sbin/mysqld(_ZN4JOIN4execEv+0x33)[0x55f71b54ce03]
      Mar 3 00:00:44 masha2 mysqld[5776]: /usr/sbin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0xef)[0x55f71b54
      cf4f]
      Mar 3 00:00:45 masha2 mysqld[5776]: /usr/sbin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0xf8)[0x55f71b54d848]
      Mar 3 00:00:45 masha2 mysqld[5776]: /usr/sbin/mysqld(+0x48ba9c)[0x55f71b40fa9c]
      Mar 3 00:00:45 masha2 mysqld[5776]: /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x6868)[0x55f71b4fa438]
      Mar 3 00:00:45 masha2 mysqld[5776]: /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x21a)[0x55f71b4fc6ba]
      Mar 3 00:00:45 masha2 mysqld[5776]: /usr/sbin/mysqld(+0x578f66)[0x55f71b4fcf66]
      Mar 3 00:00:45 masha2 mysqld[5776]: /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0xe25)[0x55f71b4fe245]
      Mar 3 00:00:46 masha2 mysqld[5776]: /usr/sbin/mysqld(_Z10do_commandP3THD+0x13c)[0x55f71b4ffbbc]
      Mar 3 00:00:46 masha2 mysqld[5776]: /usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x252)[0x55f71b5d1902]
      Mar 3 00:00:46 masha2 mysqld[5776]: /usr/sbin/mysqld(handle_one_connection+0x3d)[0x55f71b5d1a7d]
      Mar 3 00:00:46 masha2 mysqld[5776]: /lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f8c38a876ba]
      Mar 3 00:00:46 masha2 mysqld[5776]: /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7f8c3813241d]
      Mar 3 00:00:46 masha2 mysqld[5776]: Trying to get some variables.
      Mar 3 00:00:46 masha2 mysqld[5776]: Some pointers may be invalid and cause the dump to abort.
      Mar 3 00:00:46 masha2 mysqld[5776]: Query (0x7f841c14f560): SELECT Scheduling.JobNo, MIN(OrderRouting.EstimStartDate) AS EstStartDate, MAX(OrderRouting.EstimEndDate) AS EstEndDate, MIN(OrderRouting.ActualStartDate) AS ActStartDate, MAX(OrderRouting.ActualEndDate) AS ActEndDate FROM Scheduling INNER JOIN OrderRouting ON Scheduling.JobNo = OrderRouting.JobNo INNER JOIN Orders ON OrderRouting.OrderNo = Orders.OrderNo WHERE 1=1 AND Orders.Status != 'C' AND (Scheduling.Hours - Scheduling.QTime) > 0 AND (Scheduling.JobNo IS NOT NULL AND Scheduling.JobNo <> '') AND (Scheduling.Status = 'Current' OR Scheduling.Status = 'Pending' OR Scheduling.Status = 'Future' OR Scheduling.JobNo LIKE 'WHATIF%') AND (Shift = 1) GROUP BY Scheduling.JobNo ORDER BY Scheduling.JobNo
      Mar 3 00:00:46 masha2 kernel: [1737591.393009] show_signal_msg: 9 callbacks suppressed
      Mar 3 00:00:46 masha2 kernel: [1737591.393026] mysqld[14785]: segfault at fffffffffffffffd ip 000055f71b9b94e1 sp 00007f842022f980 error 5 in mysqld[55f71af84000+125f000]
      Mar 3 00:00:46 masha2 mysqld[5776]: Connection ID (thread ID): 853940
      Mar 3 00:00:46 masha2 mysqld[5776]: Status: NOT_KILLED
      Mar 3 00:00:46 masha2 mysqld[5776]: Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on
      Mar 3 00:00:46 masha2 mysqld[5776]: The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
      Mar 3 00:00:46 masha2 mysqld[5776]: information that should help you find out what is causing the crash.
      Mar 3 00:00:48 masha2 systemd[1]: mariadb.service: Main process exited, code=dumped, status=11/SEGV
      Mar 3 00:00:48 masha2 systemd[1]: mariadb.service: Unit entered failed state.
      Mar 3 00:00:48 masha2 systemd[1]: mariadb.service: Failed with result 'core-dump'.
      Mar 3 00:00:53 masha2 systemd[1]: mariadb.service: Service hold-off time over, scheduling restart.
      Mar 3 00:00:53 masha2 systemd[1]: Stopped MariaDB 10.3.12 database server.

      Attachments

        Activity

          People

            Unassigned Unassigned
            kvasserman Konstantin Vasserman
            Votes:
            1 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.