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

setting log_slow_verbosity can lead to a crash

    Details

      Description

      gdb:

      Core was generated by `/sdc/PS300719-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld --no-defaul'.
      Program terminated with signal SIGSEGV, Segmentation fault.
      #0  0x00007f62f38b09d1 in __pthread_kill (threadid=<optimized out>, signo=11) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:59
      59        val = INTERNAL_SYSCALL (tgkill, err, 3, THREAD_GETMEM (THREAD_SELF, pid),
      [Current thread is 1 (LWP 9013)]
      (gdb) bt
      +bt
      #0  0x00007f62f38b09d1 in __pthread_kill (threadid=<optimized out>, signo=11) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:59
      #1  0x000000000458b7f3 in my_write_core (sig=11) at /sdc/ps-8.0.16_dbg/mysys/stacktrace.cc:284
      #2  0x00000000034ee50b in handle_fatal_signal (sig=11) at /sdc/ps-8.0.16_dbg/sql/signal_handler.cc:171
      #3  <signal handler called>
      #4  0x0000000002f9295a in Bitmap<64u>::is_set (this=0x20500000000020, n=9) at /sdc/ps-8.0.16_dbg/sql/sql_bitmap.h:168
      #5  0x000000000314f0c6 in Opt_hints_map::is_specified (this=0x20500000000018, type_arg=DERIVED_MERGE_HINT_ENUM) at /sdc/ps-8.0.16_dbg/sql/opt_hints.h:110
      #6  0x000000000314f230 in Opt_hints::is_specified (this=0x20500000000000, type_arg=DERIVED_MERGE_HINT_ENUM) at /sdc/ps-8.0.16_dbg/sql/opt_hints.h:192
      #7  0x000000000314ebf3 in get_hint_state (hint=0x20500000000000, parent_hint=0x8, type_arg=DERIVED_MERGE_HINT_ENUM, ret_val=0x7f62f0352ebf) at /sdc/ps-8.0.16_dbg/sql/opt_hints.cc:715
      #8  0x000000000314edf0 in hint_table_state (thd=0x7f6297c21000, table_list=0x7f6297db2910, type_arg=DERIVED_MERGE_HINT_ENUM, optimizer_switch=262144) at /sdc/ps-8.0.16_dbg/sql/opt_hints.cc:760
      #9  0x00000000033702ae in SELECT_LEX::merge_derived (this=0x7f6297db0068, thd=0x7f6297c21000, derived_table=0x7f6297db2910) at /sdc/ps-8.0.16_dbg/sql/sql_resolver.cc:2768
      #10 0x000000000336bad3 in SELECT_LEX::resolve_placeholder_tables (this=0x7f6297db0068, thd=0x7f6297c21000, apply_semijoin=true) at /sdc/ps-8.0.16_dbg/sql/sql_resolver.cc:1054
      #11 0x0000000003369232 in SELECT_LEX::prepare (this=0x7f6297db0068, thd=0x7f6297c21000) at /sdc/ps-8.0.16_dbg/sql/sql_resolver.cc:205
      #12 0x000000000337c099 in handle_query (thd=0x7f6297c21000, lex=0x7f6297c27800, result=0x7f6297dda4a0, added_options=0, removed_options=0) at /sdc/ps-8.0.16_dbg/sql/sql_select.cc:171
      #13 0x000000000331b640 in execute_show (thd=0x7f6297c21000, all_tables=0x7f6297db2910) at /sdc/ps-8.0.16_dbg/sql/sql_parse.cc:5105
      #14 0x0000000003314d2b in mysql_execute_command (thd=0x7f6297c21000, first_level=true) at /sdc/ps-8.0.16_dbg/sql/sql_parse.cc:3132
      #15 0x000000000331c426 in mysql_parse (thd=0x7f6297c21000, parser_state=0x7f62f0354a10, update_userstat=false) at /sdc/ps-8.0.16_dbg/sql/sql_parse.cc:5427
      #16 0x0000000003310fec in dispatch_command (thd=0x7f6297c21000, com_data=0x7f62f0355b80, command=COM_QUERY) at /sdc/ps-8.0.16_dbg/sql/sql_parse.cc:1796
      #17 0x000000000330f48d in do_command (thd=0x7f6297c21000) at /sdc/ps-8.0.16_dbg/sql/sql_parse.cc:1293
      #18 0x00000000034d8d97 in handle_connection (arg=0x7f62dcbb1f00) at /sdc/ps-8.0.16_dbg/sql/conn_handler/connection_handler_per_thread.cc:308
      #19 0x0000000004677700 in pfs_spawn_thread (arg=0x7f62db21a720) at /sdc/ps-8.0.16_dbg/storage/perfschema/pfs.cc:2836
      #20 0x00007f62f38abdd5 in start_thread (arg=0x7f62f0356700) at pthread_create.c:307
      #21 0x00007f62f1a7b02d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
      (gdb) quit
      

      sql:

      CREATE DATABASE test;
      USE test;
      SET @@character_set_client=geostd8;
      SET GLOBAL slow_query_log=on;
      set log_slow_verbosity=innodb;
      select straight_join * FROM t1 x,t1 y where y.a=x.d and y.b=2;
      set names default,@dummy=0;
      SHOW DATABASES LIKE 'd%';
      

      I'm able to reproduce this with current 8.0.16 head builds (both debug and opt). Upstream and our 8.0.15 aren't affected.

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  zsolt.parragi Zsolt Parragi
                  Reporter:
                  hrvoje.matijakovic Hrvoje Matijakovic
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  1 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Time Tracking

                    Estimated:
                    Original Estimate - Not Specified
                    Not Specified
                    Remaining:
                    Remaining Estimate - Not Specified
                    Not Specified
                    Logged:
                    Time Spent - 4 days, 35 minutes
                    4d 35m