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
|