Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

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

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.

Environment

None

Smart Checklist

Activity

Show:
Done

Details

Assignee

Reporter

Labels

Time tracking

1h logged

Fix versions

Affects versions

Priority

Smart Checklist

Created November 1, 2018 at 7:05 AM
Updated March 6, 2024 at 12:43 PM
Resolved December 21, 2018 at 1:57 PM
Configure