continue Continuing. [New Thread 0x7f433c13b700 (LWP 110613)] Thread 13 "mariadbd" received signal SIGSEGV, Segmentation fault. [Switching to Thread 0x7f433c13b700 (LWP 110613)] add_key_field (join=join@entry=0x7f42ec082cc8, key_fields=key_fields@entry=0x7f433c137c48, and_level=and_level@entry=0, cond=cond@entry=0x7f42ec087110, field=field@entry=0x7f42ec01fb80, eq_func=eq_func@entry=false, value=0x7f42ec087198, num_values=1, usable_tables=18446744073709551615, sargables=0x7f433c137d78, row_col_no=0) at /home/mariadb/sql/sql_select.cc:6559 6559 stat[0].keys.merge(possible_keys); // Add possible keys bt #0 add_key_field (join=join@entry=0x7f42ec082cc8, key_fields=key_fields@entry=0x7f433c137c48, and_level=and_level@entry=0, cond=cond@entry=0x7f42ec087110, field=field@entry=0x7f42ec01fb80, eq_func=eq_func@entry=false, value=0x7f42ec087198, num_values=1, usable_tables=18446744073709551615, sargables=0x7f433c137d78, row_col_no=0) at /home/mariadb/sql/sql_select.cc:6559 #1 0x000055bc79a98df5 in add_key_equal_fields (join=join@entry=0x7f42ec082cc8, key_fields=key_fields@entry=0x7f433c137c48, and_level=0, cond=cond@entry=0x7f42ec087110, field_item=0x7f42ec084708, eq_func=eq_func@entry=false, val=0x7f42ec087198, num_values=1, usable_tables=18446744073709551615, sargables=0x7f433c137d78, row_col_no=0) at /home/mariadb/sql/sql_select.cc:6680 #2 0x000055bc79abb980 in Item_func_ne::add_key_fields (this=0x7f42ec087110, join=0x7f42ec082cc8, key_fields=0x7f433c137c48, and_level=0x7f433c137c44, usable_tables=18446744073709551615, sargables=0x7f433c137d78) at /home/mariadb/sql/sql_select.cc:6915 #3 0x000055bc79ab92ca in Item_cond_and::add_key_fields (this=, join=0x7f42ec082cc8, key_fields=0x7f433c137c48, and_level=0x7f433c137c44, usable_tables=, sargables=) at /home/mariadb/sql/sql_select.cc:6755 #4 0x000055bc79abd42c in update_ref_and_keys (thd=thd@entry=0x7f42ec000c58, keyuse=keyuse@entry=0x7f42ec083020, join_tab=0x7f42ec087438, tables=1, cond=0x7f42ec087338, normal_tables=normal_tables@entry=18446744073709551615, sargables=, select_lex=, select_lex=) at /home/mariadb/sql/sql_select.cc:7452 #5 0x000055bc79b8764e in make_join_statistics (keyuse_array=0x7f42ec083020, tables_list=..., join=0x7f42ec082cc8) at /home/mariadb/sql/sql_select.cc:5676 #6 JOIN::optimize_inner (this=0x7f42ec082cc8) at /home/mariadb/sql/sql_select.cc:2626 #7 0x000055bc79b901fa in JOIN::optimize (this=this@entry=0x7f42ec082cc8) at /home/mariadb/sql/sql_select.cc:1944 #8 0x000055bc798e7ea0 in mysql_derived_optimize (thd=0x7f42ec000c58, lex=0x7f42ec062f00, derived=0x7f42ec0667e8) at /home/mariadb/sql/sql_derived.cc:1037 #9 0x000055bc798e6244 in mysql_handle_single_derived (lex=0x7f42ec062f00, derived=derived@entry=0x7f42ec0667e8, phases=phases@entry=4) at /home/mariadb/sql/sql_derived.cc:200 #10 0x000055bc79b839f3 in JOIN::optimize_inner (this=0x7f42ec083e88) at /home/mariadb/sql/sql_select.cc:2442 #11 0x000055bc79b901fa in JOIN::optimize (this=this@entry=0x7f42ec083e88) at /home/mariadb/sql/sql_select.cc:1944 #12 0x000055bc79b90570 in mysql_select (thd=0x7f42ec000c58, tables=0x7f42ec0667e8, fields=..., conds=0x7f42ec082a48, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=, result=0x7f42ec083dc8, unit=0x7f42ec062fe0, select_lex=0x7f42ec066220) at /home/mariadb/sql/sql_select.cc:5235 #13 0x000055bc79b91800 in handle_select (thd=thd@entry=0x7f42ec000c58, lex=lex@entry=0x7f42ec062f00, result=result@entry=0x7f42ec083dc8, setup_tables_done_option=setup_tables_done_option@entry=35184372088832) at /home/mariadb/sql/sql_select.cc:628 #14 0x000055bc799e7eb7 in mysql_execute_command (thd=0x7f42ec000c58, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /home/mariadb/sql/sql_parse.cc:4579 #15 0x000055bc79f83d53 in sp_instr_stmt::exec_core (this=0x7f42ec06ee80, thd=, nextp=0x7f433c139174) at /home/mariadb/sql/sp_instr.cc:956 #16 0x000055bc79f88d47 in sp_lex_keeper::reset_lex_and_exec_core (this=0x7f42ec06eeb8, thd=0x7f42ec000c58, nextp=, open_tables=, instr=0x7f42ec06ee80, rerun_the_same_instr=) at /home/mariadb/sql/sp_instr.cc:296 #17 0x000055bc79f8ac6b in sp_lex_keeper::validate_lex_and_exec_core (this=this@entry=0x7f42ec06eeb8, thd=thd@entry=0x7f42ec000c58, nextp=nextp@entry=0x7f433c139174, open_tables=open_tables@entry=false, instr=instr@entry=0x7f42ec06ee80) at /home/mariadb/sql/sp_instr.cc:475 #18 0x000055bc79f8c648 in sp_instr_stmt::execute (this=0x7f42ec06ee80, thd=0x7f42ec000c58, nextp=0x7f433c139174) at /home/mariadb/sql/sp_instr.cc:862 #19 0x000055bc797a5077 in sp_head::execute (this=0x7f42ec060ee0, thd=0x7f42ec000c58, merge_da_on_success=) at /home/mariadb/sql/sp_head.cc:1284 #20 0x000055bc797a80ca in sp_head::execute_trigger (this=0x7f42ec060ee0, thd=thd@entry=0x7f42ec000c58, db_name=, table_name=, grant_info=grant_info@entry=0x7f42ec023230) at /home/mariadb/sql/sp_head.cc:1794 #21 0x000055bc79c8ce03 in Table_triggers_list::process_triggers (this=0x7f42ec024ac0, thd=thd@entry=0x7f42ec000c58, event=event@entry=TRG_EVENT_INSERT, time_type=time_type@entry=TRG_ACTION_BEFORE, old_row_is_record1=old_row_is_record1@entry=true) at /home/mariadb/sql/sql_trigger.cc:2524 #22 0x000055bc79871126 in fill_record_n_invoke_before_triggers (thd=thd@entry=0x7f42ec000c58, table=table@entry=0x7f42ec026258, fields=..., values=..., ignore_errors=ignore_errors@entry=false, event=event@entry=TRG_EVENT_INSERT) at /home/mariadb/sql/sql_base.cc:9224 #23 0x000055bc7991d867 in mysql_insert (thd=thd@entry=0x7f42ec000c58, table_list=, fields=..., values_list=..., update_fields=..., update_values=..., duplic=, ignore=, result=) at /home/mariadb/sql/sql_insert.cc:1053 #24 0x000055bc799db62a in mysql_execute_command (thd=0x7f42ec000c58, is_called_from_prepared_stmt=) at /home/mariadb/sql/sql_parse.cc:4429 #25 0x000055bc799a8cce in mysql_parse (thd=0x7f42ec000c58, rawbuf=, length=, parser_state=) at /home/mariadb/sql/sql_parse.cc:7748 #26 0x000055bc799ca755 in dispatch_command (command=COM_QUERY, thd=0x7f42ec000c58, packet=, packet_length=, blocking=) at /home/mariadb/sql/sql_class.h:1551 #27 0x000055bc799d21ad in do_command (thd=0x7f42ec000c58, blocking=blocking@entry=true) at /home/mariadb/sql/sql_parse.cc:1406 #28 0x000055bc79dd2732 in do_handle_one_connection (connect=, put_in_cache=true) at /home/mariadb/sql/sql_connect.cc:1418 #29 0x000055bc79dd343d in handle_one_connection (arg=arg@entry=0x55bc7dd5f8b8) at /home/mariadb/sql/sql_connect.cc:1320 #30 0x000055bc7a997c88 in pfs_spawn_thread (arg=0x55bc7df63088) at /home/mariadb/storage/perfschema/pfs.cc:2201 #31 0x00007f433fe4f609 in start_thread (arg=) at pthread_create.c:477 #32 0x00007f433fa20353 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95