[MDEV-16016] [draft] Created: 2018-04-25  Updated: 2019-10-09  Resolved: 2019-10-09

Status: Closed
Project: MariaDB Server
Component/s: N/A
Affects Version/s: 10.3.7
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Alice Sherepa Assignee: Alice Sherepa
Resolution: Cannot Reproduce Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-3966 [recreate?] Assorted server crashes o... Closed
relates to MDEV-14194 main.distinct failed in buildbot with... Closed

 Description   

180424 19:16:28 [ERROR] mysqld got signal 6 ;
 
Server version: 10.3.7-MariaDB-debug-log
key_buffer_size=134217728
read_buffer_size=131072
max_used_connections=27
max_threads=153
thread_count=35
It is possible that mysqld could use up to 
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467545 K  bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
 
Thread pointer: 0x7fda20000a98
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 = 0x7fda9f7b3ec0 thread_stack 0x49000
/home/alice/git/10.3/sql/mysqld(my_print_stacktrace+0x40)[0x5599243c3829]
/home/alice/git/10.3/sql/mysqld(handle_fatal_signal+0x3e1)[0x559923bb1a6e]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7fdaed8a6390]
linux/raise.c:54(__GI_raise)[0x7fdaecc5f428]
stdlib/abort.c:91(__GI_abort)[0x7fdaecc6102a]
posix/libc_fatal.c:175(__fsetlocking)[0x7fdaecca17ea]
malloc/malloc.c:5006(malloc_printerr)[0x7fdaeccae698]
sql/mdl.h:583(MDL_ticket::~MDL_ticket())[0x559923a33644]
sql/mdl.cc:966(MDL_ticket::destroy(MDL_ticket*))[0x559923a2e5e6]
sql/mdl.cc:2635(MDL_context::release_lock(enum_mdl_duration, MDL_ticket*))[0x559923a3143a]
sql/mdl.cc:2677(MDL_context::release_locks_stored_before(enum_mdl_duration, MDL_ticket*))[0x559923a315dd]
sql/mdl.cc:2850(MDL_context::release_transactional_locks())[0x559923a31a88]
sql/sql_parse.cc:6414(mysql_execute_command(THD*))[0x5599238cca34]
sql/sp_head.cc:3600(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x5599237f0df6]
sql/sp_head.cc:3316(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x5599237f020c]
sql/sp_head.cc:3503(sp_instr_stmt::execute(THD*, unsigned int*))[0x5599237f09ad]
sql/sp_head.cc:1354(sp_head::execute(THD*, bool))[0x5599237ea76b]
sql/sp_head.cc:2292(sp_head::execute_procedure(THD*, List<Item>*))[0x5599237ed10c]
sql/sql_parse.cc:2944(do_execute_sp(THD*, sp_head*))[0x5599238c126b]
sql/sql_parse.cc:3186(Sql_cmd_call::execute(THD*))[0x5599238c1e34]
sql/sql_parse.cc:6282(mysql_execute_command(THD*))[0x5599238cc1e8]
sql/sql_parse.cc:8001(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x5599238d0f25]
sql/sql_parse.cc:1848(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5599238be2fd]
sql/sql_parse.cc:1391(do_command(THD*))[0x5599238bcd35]
sql/sql_connect.cc:1402(do_handle_one_connection(CONNECT*))[0x559923a24d4d]
sql/sql_connect.cc:1309(handle_one_connection)[0x559923a24acd]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7fdaed89c6ba]
x86_64/clone.S:111(clone)[0x7fdaecd3141d]
 
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0x7fda2008b4f0): SELECT CONCAT( table2.`col_varchar_nokey`, table1.`col_varchar_nokey` ) AS field1 FROM ( CC AS table1 STRAIGHT_JOIN ( ( BB AS table2 INNER JOIN C AS table3 ON (table3.`pk` <> table2.`pk` ) ) ) ON (( table3.`pk` >= table2.`col_int_nokey` ) AND (table3.`pk` < table2.`pk` ) ) ) ORDER BY field1, field1 DESC, field1, field1  /* QNO 185 CON_ID 36 */  /* QNO 252 CON_ID 36 */
Connection ID (thread ID): 36
Status: NOT_KILLED


Generated at Thu Feb 08 08:25:44 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.