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

If server is started with innodb-sync-debug it could crash with `show status like'';`

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: 5.7.x
    • Fix Version/s: 5.7.25-28
    • Component/s: None

      Description

      sql:

      # mysqld options required for replay:  --innodb-sync-debug=1
      show status like'';
      

      gdb:

      gdb) bt
      +bt
      #0  0x00007f1257299a01 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
      #1  0x000000000189e77f in my_write_core (sig=6) at /home/hrvoje/worktable/PS-5.7.23-24_dbg/mysys/stacktrace.c:249
      #2  0x0000000001618601 in handle_fatal_signal (sig=6) at /home/hrvoje/worktable/PS-5.7.23-24_dbg/sql/signal_handler.cc:223
      #3  <signal handler called>
      #4  0x00007f125539d277 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
      #5  0x00007f125539e968 in __GI_abort () at abort.c:90
      #6  0x0000000001c2e24e in ut_dbg_assertion_failed (expr=0x22da8ef "m_id != LATCH_ID_NONE", file=0x22da850 "/home/hrvoje/worktable/PS-5.7.23-24_dbg/storage/innobase/include/sync0types.h", line=1051) at /home/hrvoje/worktable/PS-5.7.23-24_dbg/storage/innobase/ut/ut0dbg.cc:67
      #7  0x0000000001bd590c in latch_t::get_level (this=0x7f125788ddb0) at /home/hrvoje/worktable/PS-5.7.23-24_dbg/storage/innobase/include/sync0types.h:1051
      #8  0x0000000001bdd7d7 in sync_check_lock_validate (latch=0x7f125788ddb0) at /home/hrvoje/worktable/PS-5.7.23-24_dbg/storage/innobase/sync/sync0debug.cc:1145
      #9  0x00000000019ff396 in MutexDebug<TTASEventMutex<GenericPolicy> >::enter (this=0x2e12138 <scrub_stat_mutex+120>, mutex=0x2e120c0 <scrub_stat_mutex>, name=0x2300dd0 "/home/hrvoje/worktable/PS-5.7.23-24_dbg/storage/innobase/btr/btr0scrub.cc", line=898) at /home/hrvoje/worktable/PS-5.7.23-24_dbg/storage/innobase/include/sync0policy.ic:71
      #10 0x00000000019fc9c8 in GenericPolicy<TTASEventMutex<GenericPolicy> >::enter (this=0x2e12138 <scrub_stat_mutex+120>, mutex=..., filename=0x2300dd0 "/home/hrvoje/worktable/PS-5.7.23-24_dbg/storage/innobase/btr/btr0scrub.cc", line=898) at /home/hrvoje/worktable/PS-5.7.23-24_dbg/storage/innobase/include/sync0policy.h:347
      #11 0x00000000019fa1d4 in PolicyMutex<TTASEventMutex<GenericPolicy> >::enter (this=0x2e120c0 <scrub_stat_mutex>, n_spins=30, n_delay=6, name=0x2300dd0 "/home/hrvoje/worktable/PS-5.7.23-24_dbg/storage/innobase/btr/btr0scrub.cc", line=898) at /home/hrvoje/worktable/PS-5.7.23-24_dbg/storage/innobase/include/ib0mutex.h:973
      #12 0x0000000001c87fdd in btr_scrub_total_stat (stat=0x7f125788df00) at /home/hrvoje/worktable/PS-5.7.23-24_dbg/storage/innobase/btr/btr0scrub.cc:898
      #13 0x0000000001bbe8ea in srv_export_innodb_status () at /home/hrvoje/worktable/PS-5.7.23-24_dbg/storage/innobase/srv/srv0srv.cc:1613
      #14 0x00000000019ebad8 in innodb_export_status () at /home/hrvoje/worktable/PS-5.7.23-24_dbg/storage/innobase/handler/ha_innodb.cc:17384
      #15 0x00000000019f0d60 in show_innodb_vars (thd=0x7f1214419000, var=0x7f125788e920, buff=0x7f125788e0b0 "\004") at /home/hrvoje/worktable/PS-5.7.23-24_dbg/storage/innobase/handler/ha_innodb.cc:20663
      #16 0x00000000018f7857 in PFS_status_variable_cache::manifest (this=0x7f12144a0028, thd=0x7f1214419000, show_var_array=0x7f12144d9020, status_vars=0x7f125788f850, prefix=0x222bd37 "", nested_array=false, strict=false) at /home/hrvoje/worktable/PS-5.7.23-24_dbg/storage/perfschema/pfs_variable.cc:1175
      #17 0x00000000018f720d in PFS_status_variable_cache::do_materialize_all (this=0x7f12144a0028, unsafe_thd=0x7f1214419000) at /home/hrvoje/worktable/PS-5.7.23-24_dbg/storage/perfschema/pfs_variable.cc:1000
      #18 0x000000000192667e in PFS_variable_cache<Status_variable>::materialize_all (this=0x7f12144a0028, unsafe_thd=0x7f1214419000) at /home/hrvoje/worktable/PS-5.7.23-24_dbg/storage/perfschema/pfs_variable.h:530
      #19 0x00000000019260ae in table_session_status::rnd_init (this=0x7f12144a0000, scan=true) at /home/hrvoje/worktable/PS-5.7.23-24_dbg/storage/perfschema/table_session_status.cc:93
      #20 0x00000000018bf7d8 in ha_perfschema::rnd_init (this=0x7f1214432630, scan=true) at /home/hrvoje/worktable/PS-5.7.23-24_dbg/storage/perfschema/ha_perfschema.cc:324
      #21 0x0000000000eb60ff in handler::ha_rnd_init (this=0x7f1214432630, scan=true) at /home/hrvoje/worktable/PS-5.7.23-24_dbg/sql/handler.cc:3096
      #22 0x00000000013e47e3 in init_read_record (info=0x7f1214492f08, thd=0x7f1214419000, table=0x7f1214457220, qep_tab=0x7f1214492eb8, use_record_cache=1, print_error=true, disable_rr_cache=false) at /home/hrvoje/worktable/PS-5.7.23-24_dbg/sql/records.cc:315
      #23 0x0000000001482a66 in join_init_read_record (tab=0x7f1214492eb8) at /home/hrvoje/worktable/PS-5.7.23-24_dbg/sql/sql_executor.cc:2483
      #24 0x000000000147fc59 in sub_select (join=0x7f1214492800, qep_tab=0x7f1214492eb8, end_of_records=false) at /home/hrvoje/worktable/PS-5.7.23-24_dbg/sql/sql_executor.cc:1277
      #25 0x000000000147f5ec in do_select (join=0x7f1214492800) at /home/hrvoje/worktable/PS-5.7.23-24_dbg/sql/sql_executor.cc:950
      #26 0x000000000147d553 in JOIN::exec (this=0x7f1214492800) at /home/hrvoje/worktable/PS-5.7.23-24_dbg/sql/sql_executor.cc:199
      #27 0x00000000014789d4 in TABLE_LIST::materialize_derived (this=0x7f121447d4c0, thd=0x7f1214419000) at /home/hrvoje/worktable/PS-5.7.23-24_dbg/sql/sql_derived.cc:326
      #28 0x0000000001482b1c in join_materialize_derived (tab=0x7f1214493608) at /home/hrvoje/worktable/PS-5.7.23-24_dbg/sql/sql_executor.cc:2505
      #29 0x000000000147fe4b in QEP_TAB::prepare_scan (this=0x7f1214493608) at /home/hrvoje/worktable/PS-5.7.23-24_dbg/sql/sql_executor.cc:1331
      #30 0x000000000147facd in sub_select (join=0x7f1214492430, qep_tab=0x7f1214493608, end_of_records=false) at /home/hrvoje/worktable/PS-5.7.23-24_dbg/sql/sql_executor.cc:1231
      #31 0x000000000147f5ec in do_select (join=0x7f1214492430) at /home/hrvoje/worktable/PS-5.7.23-24_dbg/sql/sql_executor.cc:950
      #32 0x000000000147d553 in JOIN::exec (this=0x7f1214492430) at /home/hrvoje/worktable/PS-5.7.23-24_dbg/sql/sql_executor.cc:199
      #33 0x000000000151969f in handle_query (thd=0x7f1214419000, lex=0x7f121441b638, result=0x7f121447dcd0, added_options=0, removed_options=0) at /home/hrvoje/worktable/PS-5.7.23-24_dbg/sql/sql_select.cc:185
      #34 0x00000000014cca3b in execute_sqlcom_select (thd=0x7f1214419000, all_tables=0x7f121447d4c0) at /home/hrvoje/worktable/PS-5.7.23-24_dbg/sql/sql_parse.cc:5417
      #35 0x00000000014c5cd5 in mysql_execute_command (thd=0x7f1214419000, first_level=true) at /home/hrvoje/worktable/PS-5.7.23-24_dbg/sql/sql_parse.cc:2914
      #36 0x00000000014cdaad in mysql_parse (thd=0x7f1214419000, parser_state=0x7f1257890470) at /home/hrvoje/worktable/PS-5.7.23-24_dbg/sql/sql_parse.cc:5873
      #37 0x00000000014c2921 in dispatch_command (thd=0x7f1214419000, com_data=0x7f1257890c50, command=COM_QUERY) at /home/hrvoje/worktable/PS-5.7.23-24_dbg/sql/sql_parse.cc:1516
      #38 0x00000000014c17a9 in do_command (thd=0x7f1214419000) at /home/hrvoje/worktable/PS-5.7.23-24_dbg/sql/sql_parse.cc:1047
      #39 0x00000000015f5468 in handle_connection (arg=0x7f123aeff400) at /home/hrvoje/worktable/PS-5.7.23-24_dbg/sql/conn_handler/connection_handler_per_thread.cc:312
      #40 0x00000000018c2220 in pfs_spawn_thread (arg=0x7f1253418e20) at /home/hrvoje/worktable/PS-5.7.23-24_dbg/storage/perfschema/pfs.cc:2190
      #41 0x00007f1257294e25 in start_thread (arg=0x7f1257891700) at pthread_create.c:308
      #42 0x00007f1255465bad in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113
      

      Reproduced on debug build of: RM-390 (57a9574def950d8dfc8ae5ba6f1367a7bad39622)

      Can't reproduce this on the upstream 5.7.24 debug build.

        Smart Checklist

          Attachments

            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 - 1 hour
                  1h