Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Incomplete
-
10.1.34
Description
*mysqld got signal 11 on Slave with Multi Source Replication. *
200423 15:18:49 [ERROR] mysqld got signal 11 ;
|
This could be because you hit a bug. It is also possible that this binary
|
or one of the libraries it was linked against is corrupt, improperly built,
|
or misconfigured. This error can also be caused by malfunctioning hardware.
|
|
To report this bug, see https://mariadb.com/kb/en/reporting-bugs
|
|
We will try our best to scrape up some info that will hopefully help
|
diagnose the problem, but since we have already crashed,
|
something is definitely wrong and this may fail.
|
|
Server version: 10.1.34-MariaDB
|
key_buffer_size=33554432
|
read_buffer_size=262144
|
max_used_connections=249
|
max_threads=2002
|
thread_count=160
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 1611965 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
|
Thread pointer: 0x7ef2d32b7008
|
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 = 0x7f16025c7110 thread_stack 0x48400
|
/data/mysql/bin/mysqld(my_print_stacktrace+0x2b)[0x7f16368fe00b]
|
/data/mysql/bin/mysqld(handle_fatal_signal+0x4d5)[0x7f1636459e85]
|
/lib64/libpthread.so.0(+0x3fca00f710)[0x7f1635a53710]
|
/lib64/libpthread.so.0(pthread_mutex_lock+0x0)[0x7f1635a4d3a0]
|
/data/mysql/lib/libjemalloc.so.1(+0xe4cd)[0x7f16351ff4cd]
|
/data/mysql/lib/plugin/ha_tokudb.so(_ZN12TOKUDB_SHARE7releaseEv+0x2a5)[0x7f15ff88dd25]
|
/data/mysql/lib/plugin/ha_tokudb.so(_ZN9ha_tokudb7__closeEv+0x10f)[0x7f15ff88e25f]
|
/data/mysql/lib/plugin/ha_tokudb.so(_ZN9ha_tokudb5closeEv+0x2d)[0x7f15ff88e38d]
|
/data/mysql/bin/mysqld(_Z8closefrmP5TABLEb+0x38)[0x7f1636381108]
|
/data/mysql/bin/mysqld(_Z18intern_close_tableP5TABLE+0x36)[0x7f1636299df6]
|
/data/mysql/bin/mysqld(_Z12tc_add_tableP3THDP5TABLE+0x1eb)[0x7f163640c56b]
|
/data/mysql/bin/mysqld(_Z10open_tableP3THDP10TABLE_LISTP18Open_table_context+0x9a2)[0x7f163629c782]
|
/data/mysql/bin/mysqld(_Z11open_tablesP3THDRK14DDL_options_stPP10TABLE_LISTPjjP19Prelocking_strategy+0xf12)[0x7f16362a05a2]
|
/data/mysql/bin/mysqld(_Z30open_normal_and_derived_tablesP3THDP10TABLE_LISTjj+0x59)[0x7f16362a0879]
|
/data/mysql/bin/mysqld(+0x4b9e3c)[0x7f163633ce3c]
|
/data/mysql/bin/mysqld(_Z14get_all_tablesP3THDP10TABLE_LISTP4Item+0x81b)[0x7f1636351acb]
|
/data/mysql/bin/mysqld(_Z24get_schema_tables_resultP4JOIN23enum_schema_table_state+0x28e)[0x7f163634f25e]
|
/data/mysql/bin/mysqld(_ZN4JOIN10exec_innerEv+0x6b5)[0x7f1636336cc5]
|
/data/mysql/bin/mysqld(_ZN4JOIN4execEv+0x5e)[0x7f16363390fe]
|
/data/mysql/bin/mysqld(_Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x12a)[0x7f1636335a8a]
|
/data/mysql/bin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x265)[0x7f16363393e5]
|
/data/mysql/bin/mysqld(+0x455322)[0x7f16362d8322]
|
/data/mysql/bin/mysqld(_Z21mysql_execute_commandP3THD+0x6c8f)[0x7f16362e5b4f]
|
/data/mysql/bin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x285)[0x7f16362e7f45]
|
/data/mysql/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x225e)[0x7f16362eaa4e]
|
/data/mysql/bin/mysqld(_Z10do_commandP3THD+0x177)[0x7f16362eaff7]
|
/data/mysql/bin/mysqld(_Z24do_handle_one_connectionP3THD+0x17f)[0x7f16363ac2af]
|
/data/mysql/bin/mysqld(handle_one_connection+0x47)[0x7f16363ac3e7]
|
/data/mysql/bin/mysqld(+0x748ecd)[0x7f16365cbecd]
|
/lib64/libpthread.so.0(+0x3fca0079d1)[0x7f1635a4b9d1]
|
/lib64/libc.so.6(clone+0x6d)[0x7f1633f348fd]
|
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x7ee35c594020): SELECT k.TABLE_SCHEMA, k.TABLE_NAME, k.COLUMN_NAME, k.CONSTRAINT_NAME, c.CONSTRAINT_TYPE, k.REFERENCED_TABLE_SCHEMA, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME, r.UPDATE_RULE, r.DELETE_RULE, s.INDEX_TYPE, s.INDEX_COMMENT, s.SUB_PART , s.COLLATION FROM information_schema.TABLE_CONSTRAINTS c LEFT JOIN (SELECT * FROM information_schema.REFERENTIAL_CONSTRAINTS SUBR WHERE SUBR.TABLE_NAME = '_wk_RevenueSellSide' ) r ON (c.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND c.CONSTRAINT_NAME = r.CONSTRAINT_NAME) INNER JOIN (SELECT * FROM information_schema.KEY_COLUMN_USAGE SUBK WHERE SUBK.TABLE_SCHEMA = 'tempdb' AND SUBK.TABLE_NAME = '_wk_RevenueSellSide' ) k ON (k.CONSTRAINT_SCHEMA = c.CONSTRAINT_SCHEMA AND k.CONSTRAINT_NAME = c.CONSTRAINT_NAME AND k.TABLE_SCHEMA = c.TABLE_SCHEMA AND k.TABLE_NAME = c.TABLE_NAME) LEFT JOIN (SELECT * FROM information_schema.STATISTICS STAT WHERE STAT.TABLE_SCHEMA = 'tempdb' AND STAT.TABLE_NAME = '_wk_RevenueSellSide' ) s ON (s.INDEX_SCHEMA = k.CONSTRAINT_SCHEMA AND k.CONSTRAINT_NAME = s.INDEX_NAME AND s.COLUMN_NAME = k.COLUMN_NAME AND s.TABLE_SCHEMA = k.TABLE_SCHEMA AND s.TABLE_NAME = k.TABLE_NAME) WHERE c.TABLE_SCHEMA = 'tempdb' AND c.TABLE_NAME = '_wk_RevenueSellSide' ORDER BY k.ORDINAL_POSITION
|
Connection ID (thread ID): 579056
|
Status: NOT_KILLED
|
|
Query is :
|
SELECT
|
k.TABLE_SCHEMA,
|
k.TABLE_NAME,
|
k.COLUMN_NAME,
|
k.CONSTRAINT_NAME,
|
c.CONSTRAINT_TYPE,
|
k.REFERENCED_TABLE_SCHEMA,
|
k.REFERENCED_TABLE_NAME,
|
k.REFERENCED_COLUMN_NAME,
|
r.UPDATE_RULE,
|
r.DELETE_RULE,
|
s.INDEX_TYPE,
|
s.INDEX_COMMENT,
|
s.SUB_PART,
|
s.COLLATION
|
FROM
|
information_schema.TABLE_CONSTRAINTS c
|
LEFT JOIN (
|
SELECT
|
*
|
FROM
|
information_schema.REFERENTIAL_CONSTRAINTS SUBR
|
WHERE
|
SUBR.TABLE_NAME = '_wk_RevenueSellSide'
|
) r ON (
|
c.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA
|
AND c.CONSTRAINT_NAME = r.CONSTRAINT_NAME
|
)
|
INNER JOIN (
|
SELECT
|
*
|
FROM
|
information_schema.KEY_COLUMN_USAGE SUBK
|
WHERE
|
SUBK.TABLE_SCHEMA = 'tempdb'
|
AND SUBK.TABLE_NAME = '_wk_RevenueSellSide'
|
) k ON (
|
k.CONSTRAINT_SCHEMA = c.CONSTRAINT_SCHEMA
|
AND k.CONSTRAINT_NAME = c.CONSTRAINT_NAME
|
AND k.TABLE_SCHEMA = c.TABLE_SCHEMA
|
AND k.TABLE_NAME = c.TABLE_NAME
|
)
|
LEFT JOIN (
|
SELECT
|
*
|
FROM
|
information_schema.STATISTICS STAT
|
WHERE
|
STAT.TABLE_SCHEMA = 'tempdb'
|
AND STAT.TABLE_NAME = '_wk_RevenueSellSide'
|
) s ON (
|
s.INDEX_SCHEMA = k.CONSTRAINT_SCHEMA
|
AND k.CONSTRAINT_NAME = s.INDEX_NAME
|
AND s.COLUMN_NAME = k.COLUMN_NAME
|
AND s.TABLE_SCHEMA = k.TABLE_SCHEMA
|
AND s.TABLE_NAME = k.TABLE_NAME
|
)
|
WHERE
|
c.TABLE_SCHEMA = 'tempdb'
|
AND c.TABLE_NAME = '_wk_RevenueSellSide'
|
ORDER BY
|
k.ORDINAL_POSITION
|