Details
-
Bug
-
Status: Done
-
High
-
Resolution: Fixed
-
8.0.16-7
-
None
Description
While testing default_table_encryption, concurrency testing was performed. Following crash is encountered which may not be reproducible in single thread, hence an MTR testcase is hard to be written.
Stack:
2019-08-07T11:18:10.494941Z 33 [ERROR] [MY-013183] [InnoDB] Assertion failure: fsp0fsp.cc:914:space_id == page_get_space_id(buf_block_get_frame(block)) thread 139669585528576
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
11:18:10 UTC - mysqld got signal 6 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
Thread pointer: 0x7f068813a8c0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 7f075c07fd18 thread_stack 0x46000
/home/mohit.joshi/PS070819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld(my_print_stacktrace(unsigned char*, unsigned long)+0x55) [0x48088b8]
/home/mohit.joshi/PS070819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld(handle_fatal_signal+0x2c6) [0x363a1a1]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x11390) [0x7f07750de390]
/lib/x86_64-linux-gnu/libc.so.6(gsignal+0x38) [0x7f07733b6428]
/lib/x86_64-linux-gnu/libc.so.6(abort+0x16a) [0x7f07733b802a]
/home/mohit.joshi/PS070819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld(ut_dbg_assertion_failed(char const*, char const*, unsigned long)+0x1aa) [0x4db560b]
/home/mohit.joshi/PS070819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld(fsp_header_write_encryption(unsigned int, unsigned long, unsigned char*, bool, bool, mtr_t*)+0xf7) [0x4fb5d71]
/home/mohit.joshi/PS070819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld(fsp_header_rotate_encryption(fil_space_t*, unsigned char*, mtr_t*)+0xf5) [0x4fb601d]
/home/mohit.joshi/PS070819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld() [0x4f77e30]
/home/mohit.joshi/PS070819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld(Fil_system::encryption_rotate_in_a_shard(Fil_shard*)+0x236) [0x4f781d0]
/home/mohit.joshi/PS070819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld(Fil_system::encryption_rotate_all()+0x80) [0x4f782e4]
/home/mohit.joshi/PS070819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld(fil_encryption_rotate()+0x13) [0x4f78335]
/home/mohit.joshi/PS070819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld(innobase_encryption_key_rotation()+0x136) [0x4a5b42a]
/home/mohit.joshi/PS070819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld(Rotate_innodb_master_key::execute()+0x228) [0x335ba0e]
/home/mohit.joshi/PS070819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld(Sql_cmd_alter_instance::execute(THD*)+0x172) [0x3350ac6]
/home/mohit.joshi/PS070819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld(mysql_execute_command(THD*, bool)+0x61fe) [0x34483a8]
/home/mohit.joshi/PS070819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld(mysql_parse(THD*, Parser_state*, bool)+0x6cd) [0x344ae79]
/home/mohit.joshi/PS070819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x1571) [0x343f3a2]
/home/mohit.joshi/PS070819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld(do_command(THD*)+0x50b) [0x343d7bb]
/home/mohit.joshi/PS070819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld() [0x36239bf]
/home/mohit.joshi/PS070819-percona-server-8.0.16-6-linux-x86_64-debug/bin/mysqld() [0x4902764]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba) [0x7f07750d46ba]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x6d) [0x7f077348841d]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (7f06881f6308): ALTER INSTANCE ROTATE INNODB MASTER KEY
Connection ID (thread ID): 33
Status: NOT_KILLED