XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Critical
    • Resolution: Duplicate
    • Affects Version/s: 10.0.35, 10.0.35-galera
    • Fix Version/s: N/A
    • Component/s: Optimizer
    • Labels:
    • Environment:
      Debian GNU/Linux 8.11 (jessie)

      Description

      Freshly installed server with imported databases (dump & restore ~ 90GB) restarts several times a day.

      Jun 26 08:36:32 mariadb4 mysqld: 180626  8:36:32 [ERROR] mysqld got
      signal 11 ;
      Jun 26 08:36:32 mariadb4 mysqld: This could be because you hit a bug.
      It is also possible that this binary
      Jun 26 08:36:32 mariadb4 mysqld: or one of the libraries it was linked
      against is corrupt, improperly built,
      Jun 26 08:36:32 mariadb4 mysqld: or misconfigured. This error can also
      be caused by malfunctioning hardware.
      Jun 26 08:36:32 mariadb4 mysqld:
      Jun 26 08:36:32 mariadb4 mysqld: To report this bug, see
      https://mariadb.com/kb/en/reporting-bugs
      Jun 26 08:36:32 mariadb4 mysqld:
      Jun 26 08:36:32 mariadb4 mysqld: We will try our best to scrape up
      some info that will hopefully help
      Jun 26 08:36:32 mariadb4 mysqld: diagnose the problem, but since we
      have already crashed,
      Jun 26 08:36:32 mariadb4 mysqld: something is definitely wrong and
      this may fail.
      Jun 26 08:36:32 mariadb4 mysqld:
      Jun 26 08:36:32 mariadb4 mysqld: Server version: 10.0.35-MariaDB-1~jessie
      Jun 26 08:36:32 mariadb4 mysqld: key_buffer_size=2147483648
      Jun 26 08:36:32 mariadb4 mysqld: read_buffer_size=2097152
      Jun 26 08:36:32 mariadb4 mysqld: max_used_connections=73
      Jun 26 08:36:32 mariadb4 mysqld: max_threads=802
      Jun 26 08:36:32 mariadb4 mysqld: thread_count=17
      Jun 26 08:36:32 mariadb4 mysqld: It is possible that mysqld could use
      up to
      Jun 26 08:36:32 mariadb4 mysqld: key_buffer_size + (read_buffer_size +
      sort_buffer_size)*max_threads = 7040547 K  bytes of memory
      Jun 26 08:36:32 mariadb4 mysqld: Hope that's ok; if not, decrease some
      variables in the equation.
      Jun 26 08:36:32 mariadb4 mysqld:
      Jun 26 08:36:32 mariadb4 mysqld: Thread pointer: 0x7feb4b5ce008
      Jun 26 08:36:32 mariadb4 mysqld: Attempting backtrace. You can use the
      following information to find out
      Jun 26 08:36:32 mariadb4 mysqld: where mysqld died. If you see no
      messages after this, something went
      Jun 26 08:36:32 mariadb4 mysqld: terribly wrong...
      Jun 26 08:36:32 mariadb4 mysqld: stack_bottom = 0x7fec2e53ae88
      thread_stack 0x30000
      Jun 26 08:36:32 mariadb4 mysqld:
      /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0xbc9e1e]
      Jun 26 08:36:32 mariadb4 mysqld:
      /usr/sbin/mysqld(handle_fatal_signal+0x3af)[0x73b1ef]
      Jun 26 08:36:33 mariadb4 mysqld:
      /lib/x86_64-linux-gnu/libpthread.so.0(+0xf890)[0x7fee2534b890]
      Jun 26 08:36:33 mariadb4 mysqld:
      /usr/sbin/mysqld(my_strtod+0x8a)[0xc01a8a]
      Jun 26 08:36:33 mariadb4 mysqld:
      /usr/sbin/mysqld(_ZN10Field_blob8val_realEv+0x60)[0x7203a0]
      Jun 26 08:36:33 mariadb4 mysqld:
      /usr/sbin/mysqld(_ZN14Arg_comparator12compare_realEv+0x1b)[0x76782b]
      Jun 26 08:36:33 mariadb4 mysqld:
      /usr/sbin/mysqld(_ZN12Item_func_ne7val_intEv+0x33)[0x76c0b3]
      Jun 26 08:36:33 mariadb4 mysqld:
      /usr/sbin/mysqld(_ZN4Item8val_boolEv+0xa4)[0x74bf24]
      Jun 26 08:36:33 mariadb4 mysqld:
      /usr/sbin/mysqld(_ZN12Item_cond_or7val_intEv+0x3a)[0x768f9a]
      Jun 26 08:36:33 mariadb4 mysqld:
      /usr/sbin/mysqld(_ZN4Item8val_boolEv+0xa4)[0x74bf24]
      Jun 26 08:36:33 mariadb4 mysqld:
      /usr/sbin/mysqld(_ZN13Item_cond_and7val_intEv+0x3a)[0x768f1a]
      Jun 26 08:36:33 mariadb4 mysqld:
      /usr/sbin/mysqld(_ZN4JOIN10exec_innerEv+0x219)[0x61ca79]
      Jun 26 08:36:33 mariadb4 mysqld:
      /usr/sbin/mysqld(_ZN4JOIN4execEv+0x11)[0x61f031]
      Jun 26 08:36:33 mariadb4 mysqld:
      /usr/sbin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x214)[0x61f314]
      Jun 26 08:36:33 mariadb4 mysqld: /usr/sbin/mysqld[0x5bbe1b]
      Jun 26 08:36:33 mariadb4 mysqld:
      /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x4fc7)[0x5c7d77]
      Jun 26 08:36:33 mariadb4 mysqld:
      /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x1ca)[0x5c9a2a]
      Jun 26 08:36:33 mariadb4 mysqld:
      /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x1547)[0x5cb507]
      Jun 26 08:36:33 mariadb4 mysqld:
      /usr/sbin/mysqld(_Z24do_handle_one_connectionP3THD+0x25b)[0x69badb]
      Jun 26 08:36:33 mariadb4 mysqld:
      /usr/sbin/mysqld(handle_one_connection+0x39)[0x69bb29]
      Jun 26 08:36:33 mariadb4 mysqld:
      /lib/x86_64-linux-gnu/libpthread.so.0(+0x8064)[0x7fee25344064]
      Jun 26 08:36:34 mariadb4 mysqld:
      /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7fee23bb762d]
      Jun 26 08:36:34 mariadb4 mysqld:
      Jun 26 08:36:34 mariadb4 mysqld: Trying to get some variables.
      Jun 26 08:36:34 mariadb4 mysqld: Some pointers may be invalid and
      cause the dump to abort.
      Jun 26 08:36:34 mariadb4 mysqld: Query (0x7feb21b79020): is an invalid
      pointer
      Jun 26 08:36:34 mariadb4 mysqld: Connection ID (thread ID): 251200
      Jun 26 08:36:34 mariadb4 mysqld: Status: NOT_KILLED
      Jun 26 08:36:34 mariadb4 mysqld:
      Jun 26 08:36:34 mariadb4 mysqld: 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
      Jun 26 08:36:34 mariadb4 mysqld:
      Jun 26 08:36:34 mariadb4 mysqld: The manual page at
      http://dev.mysql.com/doc/mysql/en/crashing.html contains
      Jun 26 08:36:34 mariadb4 mysqld: information that should help you find
      out what is causing the crash.
      Jun 26 08:36:34 mariadb4 mysqld:
      Jun 26 08:36:34 mariadb4 mysqld: We think the query pointer is
      invalid, but we will try to print it anyway.
      Jun 26 08:36:34 mariadb4 mysqld: Query: SELECT 
      text.id,texts0.texts_text AS title,texts1.texts_text AS
      description,text.link,text.parent,text.config,text.subid AS
      subid,text.url AS urlid,texts2.texts_text AS
      url,text.date,text.datevis,text.row_order AS row_order,
      relation_role.page2_id AS role, texts_role_title.texts_text AS
      role_title, relation_team.page2_id AS team, var_type.value AS type,
      texts_surname.texts_text AS surname, var_disablelink.value AS
      disablelink,texts3.texts_text AS content FROM (text  LEFT OUTER JOIN
      relation relation_role ON relation_role.page1_id=text.id AND
      relation_role.name='role' LEFT OUTER JOIN text text_role ON
      text_role.id = relation_role.page2_id LEFT OUTER JOIN texts
      texts_role_title ON texts_role_title.text_id = text_role.title AND
      texts_role_title.lang_id = 36 LEFT OUTER JOIN relation relation_team
      ON relation_team.page1_id=text.id AND relation_team.name='team' LEFT
      OUTER JOIN var var_type ON var_type.page_id=text.id AND
      var_type.name='type' LEFT OUTER JOIN var var_surname ON
      var_surname.page_id=text.id AND
      Jun 26 08:36:34 mariadb4 mysqld:  var_surname.name='surname' LEFT
      OUTER JOIN texts texts_surname ON texts_surname.text_id =
      var_surname.value AND texts_surname.lang_id = 36 LEFT OUTER JOIN var
      var_disablelink ON var_disablelink.page_id=text.id AND
      var_disablelink.name='disablelink') LEFT OUTER JOIN texts texts0 ON
      (texts0.text_id = text.title AND texts0.lang_id = 36) LEFT OUTER JOIN
      texts texts1 ON (texts1.text_id = text.description AND texts1.lang_id
      = 36) LEFT OUTER JOIN texts texts2 ON (texts2.text_id = text.url AND
      texts2.lang_id = 36) LEFT OUTER JOIN texts texts3 ON (texts3.text_id =
      text.content AND texts3.lang_id = 36) WHERE (text.parent=1730 AND
      (var_disablelink.value IS NULL OR var_disablelink.value<>1) AND
      text.visibility=1) HAVING @type<>1 AND (type NOT IN(1,3) AND
      texts_surname.texts_text < @surname)  ORDER BY
      IF(var_type.value=1,text_role.row_order,1) DESC, surname DESC, id DESC
      Jun 26 08:36:34 mariadb4 mysqld:
      Jun 26 08:36:35 mariadb4 mysqld_safe: Number of processes running now: 0
      Jun 26 08:36:35 mariadb4 mysqld_safe: mysqld restarted
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              lukasz Lukasz Gorski
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration