Skip to:

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

Assertion failure: sync0types.h:981:m_id != LATCH_ID_NONE

Description

Testcase

rm -Rf /dev/shm/1547617966 mkdir -p /dev/shm/1547617966/tmp /qa/ps8/PS150119-percona-server-8.0.13-4-linux-x86_64-debug/bin/mysqld --no-defaults --initialize-insecure --basedir=/qa/ps8/PS150119-percona-server-8.0.13-4-linux-x86_64-debug --datadir=/dev/shm/1547617966/data /qa/ps8/PS150119-percona-server-8.0.13-4-linux-x86_64-debug/bin/mysqld --no-defaults --basedir=/qa/ps8/PS150119-percona-server-8.0.13-4-linux-x86_64-debug --datadir=/dev/shm/1547617966/data --tmpdir=/dev/shm/1547617966/tmp --port=37934 --pid-file=/dev/shm/1547617966/pid.pid --core-file --socket=/dev/shm/1547617966/socket.sock --early-plugin-load=keyring_file.so --keyring_file_data=keyring --innodb_temp_tablespace_encrypt=ON --innodb-sync-debug=1 --log-error=/dev/shm/1547617966/error.log.out &

GDB info

#0 __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62 #1 0x00000000045bf9d3 in my_write_core (sig=6) at /qa/ps8/PS-8.0-release_dbg/mysys/stacktrace.cc:278 #2 0x000000000344ec2c in handle_fatal_signal (sig=6) at /qa/ps8/PS-8.0-release_dbg/sql/signal_handler.cc:254 #3 <signal handler called> #4 0x00007fd6de798428 in __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:54 #5 0x00007fd6de79a02a in __GI_abort () at abort.c:89 #6 0x0000000004b0ad6d in ut_dbg_assertion_failed (expr=0x5dccf57 "m_id != LATCH_ID_NONE", file=0x5dccec0 "/qa/ps8/PS-8.0-release_dbg/storage/innobase/include/sync0types.h", line=981) at /qa/ps8/PS-8.0-release_dbg/storage/innobase/ut/ut0dbg.cc:90 #7 0x0000000004a9fbf2 in latch_t::get_level (this=0x7fd6c7ff6160) at /qa/ps8/PS-8.0-release_dbg/storage/innobase/include/sync0types.h:981 #8 0x0000000004aa64ea in sync_check_lock_validate (latch=0x7fd6c7ff6160) at /qa/ps8/PS-8.0-release_dbg/storage/innobase/sync/sync0debug.cc:1030 #9 0x00000000048548a9 in MutexDebug<TTASEventMutex<GenericPolicy> >::enter (this=0x6eb2858 <master_key_id_mutex+120>, mutex=0x6eb27e0 <master_key_id_mutex>, name=0x5d72448 "/qa/ps8/PS-8.0-release_dbg/storage/innobase/os/os0file.cc", line=8621) at /qa/ps8/PS-8.0-release_dbg/storage/innobase/include/sync0policy.ic:70 #10 0x000000000484f72c in GenericPolicy<TTASEventMutex<GenericPolicy> >::enter (this=0x6eb2858 <master_key_id_mutex+120>, mutex=..., filename=0x5d72448 "/qa/ps8/PS-8.0-release_dbg/storage/innobase/os/os0file.cc", line=8621) at /qa/ps8/PS-8.0-release_dbg/storage/innobase/include/sync0policy.h:290 #11 0x000000000484adaa in PolicyMutex<TTASEventMutex<GenericPolicy> >::enter (this=0x6eb27e0 <master_key_id_mutex>, n_spins=30, n_delay=6, name=0x5d72448 "/qa/ps8/PS-8.0-release_dbg/storage/innobase/os/os0file.cc", line=8621) at /qa/ps8/PS-8.0-release_dbg/storage/innobase/include/ib0mutex.h:767 #12 0x0000000004979944 in Encryption::get_master_key (master_key_id=0x7fd6c7ff6510, master_key=0x7fd6c7ff6508) at /qa/ps8/PS-8.0-release_dbg/storage/innobase/os/os0file.cc:8621 #13 0x0000000004979d92 in Encryption::fill_encryption_info (key=0x7fd6c5beca58 "(\225\310\311\\\335\307R\207\245U\267\247<\247\351\274!\200\033\234\237!I\202\216\225\003\246\250\177\001 ", iv=0x7fd6c5beca80 "B\027\003\037\347\240O\356\231\003\337}]\017\340\234s\317\300\202\031_\213\364\252Ӭ\231\320A\257\036", encrypt_info=0x7fd6c7ff65f0 "\bj\377\307\326\177", is_boot=false) at /qa/ps8/PS-8.0-release_dbg/storage/innobase/os/os0file.cc:8736 #14 0x0000000004cb44cd in fsp_header_init (space_id=4294967293, size=768, mtr=0x7fd6c7ff69d0, is_boot=false) at /qa/ps8/PS-8.0-release_dbg/storage/innobase/fsp/fsp0fsp.cc:1075 #15 0x0000000004a89478 in srv_open_tmp_tablespace (create_new_db=false, tmp_space=0x6efdaa0 <srv_tmp_space>) at /qa/ps8/PS-8.0-release_dbg/storage/innobase/srv/srv0start.cc:1408 #16 0x0000000004a8c9c3 in srv_start (create_new_db=false, scan_directories="./;./;./") at /qa/ps8/PS-8.0-release_dbg/storage/innobase/srv/srv0start.cc:2553 #17 0x0000000004811ba8 in innobase_init_files (dict_init_mode=DICT_INIT_CHECK_FILES, tablespaces=0x7fd6c7ffe800) at /qa/ps8/PS-8.0-release_dbg/storage/innobase/handler/ha_innodb.cc:5037 #18 0x0000000004823185 in innobase_ddse_dict_init (dict_init_mode=DICT_INIT_CHECK_FILES, version=80013, tables=0x7fd6c7ffe7e0, tablespaces=0x7fd6c7ffe800) at /qa/ps8/PS-8.0-release_dbg/storage/innobase/handler/ha_innodb.cc:12105 #19 0x00000000042b5b69 in dd::bootstrap::DDSE_dict_init (thd=0x7fd6cfffb000, dict_init_mode=DICT_INIT_CHECK_FILES, version=80013) at /qa/ps8/PS-8.0-release_dbg/sql/dd/impl/bootstrapper.cc:2251 #20 0x00000000044f679b in dd::upgrade_57::do_pre_checks_and_initialize_dd (thd=0x7fd6cfffb000) at /qa/ps8/PS-8.0-release_dbg/sql/dd/upgrade/upgrade.cc:1081 #21 0x0000000003561216 in bootstrap::handle_bootstrap (arg=0x7fd6cfffb000) at /qa/ps8/PS-8.0-release_dbg/sql/bootstrap.cc:347 #22 0x00000000046b6a30 in pfs_spawn_thread (arg=0x7fd6d33fa320) at /qa/ps8/PS-8.0-release_dbg/storage/perfschema/pfs.cc:2836 #23 0x00007fd6e04b66ba in start_thread (arg=0x7fd6c7fff700) at pthread_create.c:333 #24 0x00007fd6de86a41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Environment

None

Smart Checklist

Activity

Show:

Julia Vural March 4, 2025 at 9:08 PM

It appears that this issue is no longer being worked on, so we are closing it for housekeeping purposes. If you believe the issue still exists, please open a new ticket after confirming it's present in the latest release.

Ramesh Sivaraman January 16, 2019 at 8:59 AM

Could not reproduce with 5.7 

mysql> select @@version; +-----------------+ | @@version | +-----------------+ | 5.7.24-26-debug | +-----------------+ 1 row in set (0.00 sec) mysql> show variables like 'innodb_temp_tablespace_encrypt'; +--------------------------------+-------+ | Variable_name | Value | +--------------------------------+-------+ | innodb_temp_tablespace_encrypt | ON | +--------------------------------+-------+ 1 row in set (0.01 sec) mysql>

Laurynas Biveinis January 16, 2019 at 8:53 AM

Ugh, right, sorry, I confused the feature with general tablespace encryption. What is 5.7 status?

Ramesh Sivaraman January 16, 2019 at 8:29 AM
Edited

Could not reproduce this issue with upstream 8.0.13 version. Startup option --innodb_temp_tablespace_encrypt=ON is not supported in upstream.

Laurynas Biveinis January 16, 2019 at 8:13 AM

Please check against upstream

Won't Do

Details

Assignee

Reporter

Labels

Time tracking

13m logged

Affects versions

Priority

Smart Checklist

Created January 16, 2019 at 6:16 AM
Updated March 4, 2025 at 9:08 PM
Resolved March 4, 2025 at 9:08 PM
Configure