Details
-
Bug
-
Status: Done
-
Critical
-
Resolution: Fixed
-
None
-
None
-
None
Description
gdb:
(gdb) bt +bt #0 0x00007f382a0d0a01 in __pthread_kill (threadid=<optimized out>, signo=11) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61 #1 0x000000000187fa59 in my_write_core (sig=11) at /home/hrvoje/worktable/PS-5.7.23_dbg/mysys/stacktrace.c:249 #2 0x0000000000e9e3bb in handle_fatal_signal (sig=11) at /home/hrvoje/worktable/PS-5.7.23_dbg/sql/signal_handler.cc:223 #3 <signal handler called> #4 __strlen_sse2_pminub () at ../sysdeps/x86_64/multiarch/strlen-sse2-pminub.S:38 #5 0x0000000001624f17 in Sys_var_version::global_value_ptr (this=0x2d06f00 <Sys_version>, thd=0x7f37e9419000, base=0x7f382a6c5430) at /home/hrvoje/worktable/PS-5.7.23_dbg/sql/sys_vars.h:876 #6 0x0000000001476727 in sys_var::value_ptr (this=0x2d06f00 <Sys_version>, running_thd=0x7f37e9419000, target_thd=0x7f37e9419000, type=OPT_GLOBAL, base=0x7f382a6c5430) at /home/hrvoje/worktable/PS-5.7.23_dbg/sql/set_var.cc:273 #7 0x00000000015a9190 in get_one_variable_ext (running_thd=0x7f37e9419000, target_thd=0x7f37e9419000, variable=0x7f37e94da710, value_type=OPT_GLOBAL, show_type=SHOW_CHAR_PTR, status_var=0x0, charset=0x7f382a6c5968, buff=0x7f382a6c5550 "O FF", length=0x7f382a6c5958) at /home/hrvoje/worktable/PS-5.7.23_dbg/sql/sql_show.cc:2911 #8 0x00000000018d76f6 in System_variable::init (this=0x7f382a6c5540, target_thd=0x7f37e9419000, show_var=0x7f37e94da710, query_scope=OPT_GLOBAL) at /home/hrvoje/worktable/PS-5.7.23_dbg/storage/perfschema/pfs_variable.cc:537 #9 0x00000000018d755a in System_variable::System_variable (this=0x7f382a6c5540, target_thd=0x7f37e9419000, show_var=0x7f37e94da710, query_scope=OPT_GLOBAL) at /home/hrvoje/worktable/PS-5.7.23_dbg/storage/perfschema/pfs_variable.cc:503 #10 0x00000000018d66cc in PFS_system_variable_cache::do_materialize_global (this=0x7f37e94a0028) at /home/hrvoje/worktable/PS-5.7.23_dbg/storage/perfschema/pfs_variable.cc:162 #11 0x0000000001909624 in PFS_variable_cache<System_variable>::materialize_global (this=0x7f37e94a0028) at /home/hrvoje/worktable/PS-5.7.23_dbg/storage/perfschema/pfs_variable.h:515 #12 0x0000000001909090 in table_global_variables::rnd_init (this=0x7f37e94a0000, scan=true) at /home/hrvoje/worktable/PS-5.7.23_dbg/storage/perfschema/table_global_variables.cc:98 #13 0x00000000018a09a2 in ha_perfschema::rnd_init (this=0x7f37e9432630, scan=true) at /home/hrvoje/worktable/PS-5.7.23_dbg/storage/perfschema/ha_perfschema.cc:324 #14 0x0000000000f2f657 in handler::ha_rnd_init (this=0x7f37e9432630, scan=true) at /home/hrvoje/worktable/PS-5.7.23_dbg/sql/handler.cc:3096 #15 0x000000000145e937 in init_read_record (info=0x7f37e94910f0, thd=0x7f37e9419000, table=0x7f37e9457220, qep_tab=0x7f37e94910a0, use_record_cache=1, print_error=true, disable_rr_cache=false) at /home/hrvoje/worktable/PS-5.7.23_dbg/sql/r ecords.cc:315 #16 0x00000000014fbd02 in join_init_read_record (tab=0x7f37e94910a0) at /home/hrvoje/worktable/PS-5.7.23_dbg/sql/sql_executor.cc:2483 #17 0x00000000014f8ef5 in sub_select (join=0x7f37e94909c0, qep_tab=0x7f37e94910a0, end_of_records=false) at /home/hrvoje/worktable/PS-5.7.23_dbg/sql/sql_executor.cc:1277 #18 0x00000000014f8888 in do_select (join=0x7f37e94909c0) at /home/hrvoje/worktable/PS-5.7.23_dbg/sql/sql_executor.cc:950 #19 0x00000000014f67ef in JOIN::exec (this=0x7f37e94909c0) at /home/hrvoje/worktable/PS-5.7.23_dbg/sql/sql_executor.cc:199 #20 0x00000000014f1cb4 in TABLE_LIST::materialize_derived (this=0x7f37e947d590, thd=0x7f37e9419000) at /home/hrvoje/worktable/PS-5.7.23_dbg/sql/sql_derived.cc:326 #21 0x00000000014fbdb8 in join_materialize_derived (tab=0x7f37e94917f0) at /home/hrvoje/worktable/PS-5.7.23_dbg/sql/sql_executor.cc:2505 #22 0x00000000014f90e7 in QEP_TAB::prepare_scan (this=0x7f37e94917f0) at /home/hrvoje/worktable/PS-5.7.23_dbg/sql/sql_executor.cc:1331 #23 0x00000000014f8d69 in sub_select (join=0x7f37e94905e0, qep_tab=0x7f37e94917f0, end_of_records=false) at /home/hrvoje/worktable/PS-5.7.23_dbg/sql/sql_executor.cc:1231 #24 0x00000000014f8888 in do_select (join=0x7f37e94905e0) at /home/hrvoje/worktable/PS-5.7.23_dbg/sql/sql_executor.cc:950 #25 0x00000000014f67ef in JOIN::exec (this=0x7f37e94905e0) at /home/hrvoje/worktable/PS-5.7.23_dbg/sql/sql_executor.cc:199 #26 0x00000000015929e9 in handle_query (thd=0x7f37e9419000, lex=0x7f37e941b638, result=0x7f37e947ddd8, added_options=0, removed_options=0) at /home/hrvoje/worktable/PS-5.7.23_dbg/sql/sql_select.cc:185 #27 0x0000000001546293 in execute_sqlcom_select (thd=0x7f37e9419000, all_tables=0x7f37e947d590) at /home/hrvoje/worktable/PS-5.7.23_dbg/sql/sql_parse.cc:5417 #28 0x000000000153f66d in mysql_execute_command (thd=0x7f37e9419000, first_level=true) at /home/hrvoje/worktable/PS-5.7.23_dbg/sql/sql_parse.cc:2961 #29 0x0000000001547305 in mysql_parse (thd=0x7f37e9419000, parser_state=0x7f382a6c7470) at /home/hrvoje/worktable/PS-5.7.23_dbg/sql/sql_parse.cc:5873 #30 0x000000000153c179 in dispatch_command (thd=0x7f37e9419000, com_data=0x7f382a6c7c50, command=COM_QUERY) at /home/hrvoje/worktable/PS-5.7.23_dbg/sql/sql_parse.cc:1516 #31 0x000000000153b001 in do_command (thd=0x7f37e9419000) at /home/hrvoje/worktable/PS-5.7.23_dbg/sql/sql_parse.cc:1047 #32 0x000000000167b6ca in handle_connection (arg=0x7f380db015b0) at /home/hrvoje/worktable/PS-5.7.23_dbg/sql/conn_handler/connection_handler_per_thread.cc:312 #33 0x00000000018a3644 in pfs_spawn_thread (arg=0x7f3826018d20) at /home/hrvoje/worktable/PS-5.7.23_dbg/storage/perfschema/pfs.cc:2190 #34 0x00007f382a0cbe25 in start_thread (arg=0x7f382a6c8700) at pthread_create.c:308 #35 0x00007f382829cbad in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113
sql:
SET GLOBAL version_suffix=@saved_version_suffix;
show global variables like "InnoDB_max_file_classes";
Reproduced with: https://github.com/percona/percona-server/tree/release-5.7.23-23
This is seen frequently.
I'm also able to reproduce this in a release build:
root@stretch:~# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 248 Server version: 5.7.23-23 Percona Server (GPL), Release '23', Revision '6e39b92' Copyright (c) 2009-2018 Percona LLC and/or its affiliates Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> SET GLOBAL version_suffix=@saved_version_suffix; Query OK, 0 rows affected (0.00 sec) mysql> show global variables like "InnoDB_max_file_classes"; ERROR 2013 (HY000): Lost connection to MySQL server during query