MySQL Bugs: #87191: "SDI Root page number for copy number 0 mismatches"on innodb.table_encrypt

Bug #87191	"SDI Root page number for copy number 0 mismatches"on innodb.table_encrypt_debug
Submitted:	26 Jul 2017 3:35	Modified:	27 Jul 2017 5:04
Reporter:	Laurynas Biveinis (OCA)	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: InnoDB storage engine	Severity:	S3 (Non-critical)
Version:	8.0.2	OS:	Any
Assigned to:	Assigned Account	CPU Architecture:	Any

Description:
innodb.table_encrypt_debug crashes very regularly with

innodb.table_encrypt_debug               w4 [ fail ]
        Test ended at 2017-07-24 13:44:49

CURRENT_TEST: innodb.table_encrypt_debug
mysqltest: At line 112: query 'FLUSH TABLE tde_db.t1 FOR EXPORT' failed: 2013: Lost connection to MySQL server during query
...
2017-07-26T03:29:22.449572Z 6 [ERROR] InnoDB: SDI Root page number for copy number 0 mismatches. From page 1: 0 From page 2: 3
2017-07-26T03:29:22.449602Z 6 [ERROR] InnoDB: Assertion failure: fsp0fsp.cc:4195:0
...
#6  0x000000000381b8a1 in ut_dbg_assertion_failed (expr=0x46c52ec "0", file=0x46c6078 "/mnt/workspace/mysql-5.7-param/BUILD_TYPE/debug/Host/ubuntu-trusty-64bit/storage/innobase/fsp/fsp0fsp.cc", line=4195) at /mnt/workspace/mysql-5.7-param/BUILD_TYPE/debug/Host/ubuntu-trusty-64bit/storage/innobase/ut/ut0dbg.cc:60
#7  0x0000000003966e04 in fsp_sdi_get_root_page_num (space=2, copy_num=0, page_size=..., mtr=0x7f651dc6bb70) at /mnt/workspace/mysql-5.7-param/BUILD_TYPE/debug/Host/ubuntu-trusty-64bit/storage/innobase/fsp/fsp0fsp.cc:4195
#8  0x00000000038cd4f0 in dict_sdi_create_idx_in_mem (space=2, copy_num=0, space_discarded=false, in_flags=0) at /mnt/workspace/mysql-5.7-param/BUILD_TYPE/debug/Host/ubuntu-trusty-64bit/storage/innobase/dict/dict0crea.cc:2698
#9  0x00000000038f1476 in dd_table_open_on_id (table_id=18446744069414584322, thd=0x0, mdl=0x0, dict_locked=true) at /mnt/workspace/mysql-5.7-param/BUILD_TYPE/debug/Host/ubuntu-trusty-64bit/storage/innobase/dict/dict0dd.cc:568
#10 0x00000000038e794f in dict_sdi_get_index (tablespace_id=2, copy_num=0) at /mnt/workspace/mysql-5.7-param/BUILD_TYPE/debug/Host/ubuntu-trusty-64bit/storage/innobase/dict/dict0dict.cc:7848
#11 0x0000000003794517 in row_quiesce_write_indexes (table=0x7f6490088d58, file=0x7f6490027db0, thd=0x7f6490000be0) at /mnt/workspace/mysql-5.7-param/BUILD_TYPE/debug/Host/ubuntu-trusty-64bit/storage/innobase/row/row0quiesce.cc:232
#12 0x0000000003795196 in row_quiesce_write_cfg (table=0x7f6490088d58, thd=0x7f6490000be0) at /mnt/workspace/mysql-5.7-param/BUILD_TYPE/debug/Host/ubuntu-trusty-64bit/storage/innobase/row/row0quiesce.cc:509
#13 0x0000000003795fc0 in row_quiesce_table_start (table=0x7f6490088d58, trx=0x7f651f68a8c0) at /mnt/workspace/mysql-5.7-param/BUILD_TYPE/debug/Host/ubuntu-trusty-64bit/storage/innobase/row/row0quiesce.cc:824
#14 0x00000000035c9ae0 in ha_innobase::external_lock (this=0x7f649007a520, thd=0x7f6490000be0, lock_type=0) at /mnt/workspace/mysql-5.7-param/BUILD_TYPE/debug/Host/ubuntu-trusty-64bit/storage/innobase/handler/ha_innodb.cc:17963
#15 0x00000000027a5d6f in handler::ha_external_lock (this=0x7f649007a520, thd=0x7f6490000be0, lock_type=0) at /mnt/workspace/mysql-5.7-param/BUILD_TYPE/debug/Host/ubuntu-trusty-64bit/sql/handler.cc:8270
#16 0x000000000291f54c in lock_external (thd=0x7f6490000be0, tables=0x7f649004dea8, count=1) at /mnt/workspace/mysql-5.7-param/BUILD_TYPE/debug/Host/ubuntu-trusty-64bit/sql/lock.cc:415
#17 0x000000000291f25c in mysql_lock_tables (thd=0x7f6490000be0, tables=0x7f6490009e68, count=1, flags=4096) at /mnt/workspace/mysql-5.7-param/BUILD_TYPE/debug/Host/ubuntu-trusty-64bit/sql/lock.cc:352
#18 0x000000000224a062 in lock_tables (thd=0x7f6490000be0, tables=0x7f64900098e8, count=1, flags=4096) at /mnt/workspace/mysql-5.7-param/BUILD_TYPE/debug/Host/ubuntu-trusty-64bit/sql/sql_base.cc:6830
#19 0x0000000002249afe in open_and_lock_tables (thd=0x7f6490000be0, tables=0x7f64900098e8, flags=4096, prelocking_strategy=0x7f651dc6fad0) at /mnt/workspace/mysql-5.7-param/BUILD_TYPE/debug/Host/ubuntu-trusty-64bit/sql/sql_base.cc:6650
#20 0x000000000232db44 in flush_tables_for_export (thd=0x7f6490000be0, all_tables=0x7f64900098e8) at /mnt/workspace/mysql-5.7-param/BUILD_TYPE/debug/Host/ubuntu-trusty-64bit/sql/sql_reload.cc:568
#21 0x00000000022e84d0 in mysql_execute_command (thd=0x7f6490000be0, first_level=true) at /mnt/workspace/mysql-5.7-param/BUILD_TYPE/debug/Host/ubuntu-trusty-64bit/sql/sql_parse.cc:3889
#22 0x00000000022ec0ea in mysql_parse (thd=0x7f6490000be0, parser_state=0x7f651dc71050) at /mnt/workspace/mysql-5.7-param/BUILD_TYPE/debug/Host/ubuntu-trusty-64bit/sql/sql_parse.cc:5262
#23 0x00000000022e20a7 in dispatch_command (thd=0x7f6490000be0, com_data=0x7f651dc71cb0, command=COM_QUERY) at /mnt/workspace/mysql-5.7-param/BUILD_TYPE/debug/Host/ubuntu-trusty-64bit/sql/sql_parse.cc:1604
#24 0x00000000022e0b53 in do_command (thd=0x7f6490000be0) at /mnt/workspace/mysql-5.7-param/BUILD_TYPE/debug/Host/ubuntu-trusty-64bit/sql/sql_parse.cc:1189
#25 0x000000000263fd9c in handle_connection (arg=0x881de00) at /mnt/workspace/mysql-5.7-param/BUILD_TYPE/debug/Host/ubuntu-trusty-64bit/sql/conn_handler/connection_handler_per_thread.cc:324
#26 0x000000000347d1e1 in pfs_spawn_thread (arg=0x88bc540) at /mnt/workspace/mysql-5.7-param/BUILD_TYPE/debug/Host/ubuntu-trusty-64bit/storage/perfschema/pfs.cc:2405
#27 0x00007f652905f184 in start_thread (arg=0x7f651dc72700) at pthread_create.c:312
#28 0x00007f65272b6ffd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111

How to repeat:
Debug build (with ASan too in my case), MTR --repeat, side load

duplicate of BUG#86158, Fixed in 8.0.3