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

The execution of SHOW ENGINE INNODB STATUS to show locked mutexes with simultaneous access to a compressed table could cause a server exit.

Details

    • Bug
    • Status: Done
    • High
    • Resolution: Fixed
    • 8.0.17-8, 5.7.28-31
    • 5.7.29-32, 8.0.19-10
    • None

    Description

      PXB was executing the query
      'SHOW ENGINE INNODB STATUS'
      when server crashed.

      rogram terminated with signal SIGABRT, Aborted.
      #0  __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
      57	../sysdeps/unix/sysv/linux/pthread_kill.c: No such file or directory.
      [Current thread is 1 (Thread 0x7ff0b0768700 (LWP 7116))]
      (gdb) bt
      #0  __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
      #1  0x0000563dd43183b6 in my_write_core (sig=6) at /home/rahul.malik/MySQL/src_p8/mysys/stacktrace.cc:305
      #2  0x0000563dd31e5d55 in handle_fatal_signal (sig=6) at /home/rahul.malik/MySQL/src_p8/sql/signal_handler.cc:171
      #3  <signal handler called>
      #4  __GI_raise ([email protected]=6) at ../sysdeps/unix/sysv/linux/raise.c:51
      #5  0x00007ff1122cc801 in __GI_abort () at abort.c:79
      #6  0x0000563dd4782a5e in ut_dbg_assertion_failed (expr=0x563dd61678bf "0", file=0x563dd617abb8 "/home/rahul.malik/MySQL/src_p8/storage/innobase/include/sync0policy.ic", line=56)
          at /home/rahul.malik/MySQL/src_p8/storage/innobase/ut/ut0dbg.cc:102
      #7  0x0000563dd447ae16 in AggregateMutexStatsPolicy<TTASEventMutex<AggregateMutexStatsPolicy> >::to_string[abi:cxx11]() const (this=0x7ff0f833a3d8)
          at /home/rahul.malik/MySQL/src_p8/storage/innobase/include/sync0policy.ic:56
      #8  0x0000563dd470a1ca in sync_array_cell_print (file=0x7ff0f82eac00, cell=0x7ff0ffb0f4e8) at /home/rahul.malik/MySQL/src_p8/storage/innobase/sync/sync0arr.cc:508
      #9  0x0000563dd470b67e in sync_array_print_info_low (file=0x7ff0f82eac00, arr=0x7ff0f800b1f8) at /home/rahul.malik/MySQL/src_p8/storage/innobase/sync/sync0arr.cc:1126
      #10 0x0000563dd470b6dd in sync_array_print_info (file=0x7ff0f82eac00, arr=0x7ff0f800b1f8) at /home/rahul.malik/MySQL/src_p8/storage/innobase/sync/sync0arr.cc:1137
      #11 0x0000563dd470b9a8 in sync_array_print (file=0x7ff0f82eac00) at /home/rahul.malik/MySQL/src_p8/storage/innobase/sync/sync0arr.cc:1176
      #12 0x0000563dd4726f1d in sync_print (file=0x7ff0f82eac00) at /home/rahul.malik/MySQL/src_p8/storage/innobase/sync/sync0sync.cc:223
      #13 0x0000563dd46da285 in srv_printf_innodb_monitor (file=0x7ff0f82eac00, nowait=0, trx_start_pos=0x7ff0b0765638, trx_end=0x7ff0b0765640)
          at /home/rahul.malik/MySQL/src_p8/storage/innobase/srv/srv0srv.cc:1414
      #14 0x0000563dd444035c in innodb_show_status (hton=0x563dd8572d60, thd=0x7feff4014580, stat_print=
          0x563dd2bdc7c1 <stat_print(THD*, char const*, size_t, char const*, size_t, char const*, size_t)>) at /home/rahul.malik/MySQL/src_p8/storage/innobase/handler/ha_innodb.cc:19371
      #15 0x0000563dd44412c6 in innobase_show_status (hton=0x563dd8572d60, thd=0x7feff4014580,
          stat_print=0x563dd2bdc7c1 <stat_print(THD*, char const*, size_t, char const*, size_t, char const*, size_t)>, stat_type=HA_ENGINE_STATUS)
          at /home/rahul.malik/MySQL/src_p8/storage/innobase/handler/ha_innodb.cc:19762
      #16 0x0000563dd2bdcb4a in ha_show_status (thd=0x7feff4014580, db_type=0x563dd8572d60, stat=HA_ENGINE_STATUS) at /home/rahul.malik/MySQL/src_p8/sql/handler.cc:7845
      #17 0x0000563dd2fe618d in mysql_execute_command (thd=0x7feff4014580, first_level=true) at /home/rahul.malik/MySQL/src_p8/sql/sql_parse.cc:3302
      #18 0x0000563dd2fed310 in mysql_parse (thd=0x7feff4014580, parser_state=0x7ff0b0766b90, update_userstat=false) at /home/rahul.malik/MySQL/src_p8/sql/sql_parse.cc:5445
      #19 0x0000563dd2fe186e in dispatch_command (thd=0x7feff4014580, com_data=0x7ff0b0767c40, command=COM_QUERY) at /home/rahul.malik/MySQL/src_p8/sql/sql_parse.cc:1805
      #20 0x0000563dd2fdfc80 in do_command (thd=0x7feff4014580) at /home/rahul.malik/MySQL/src_p8/sql/sql_parse.cc:1299
      #21 0x0000563dd31cea84 in handle_connection (arg=0x563dd8582d70) at /home/rahul.malik/MySQL/src_p8/sql/conn_handler/connection_handler_per_thread.cc:308
      #22 0x0000563dd4ad1f17 in pfs_spawn_thread (arg=0x563dd87e62d0) at /home/rahul.malik/MySQL/src_p8/storage/perfschema/pfs.cc:2855
      #23 0x00007ff113f466db in start_thread (arg=0x7ff0b0768700) at pthread_create.c:463
      #24 0x00007ff1123ad88f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      
      

      Attachments

        Activity

          People

            kamil.holubicki Kamil Holubicki
            rahul.malik Rahul Malik
            Votes:
            1 Vote for this issue
            Watchers:
            5 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 - 1 week, 20 minutes
                1w 20m

                Smart Checklist