Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-4785

Setting version_suffix to NULL leads to handle_fatal_signal (sig=11) in Sys_var_version::global_value_ptr

Details

    • Bug
    • Status: Done
    • Critical
    • Resolution: Fixed
    • None
    • 5.7.23-23, 8.0.12-2rc1, 5.6.42-84.2
    • 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
      

      Attachments

        Activity

          People

            przemyslaw.skibinski Przemyslaw Skibinski
            hrvoje.matijakovic Hrvoje Matijakovic
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 4 hours
                4h

                Smart Checklist