Details
-
Bug
-
Status: Done
-
High
-
Resolution: Fixed
-
8.0.13-galera3-internal
-
None
Description
This issue is similar to PS-4995 but could not reproduce this issue with PS-8.0.15 debug build.
Testcase
./pxc80/bin/mysqld --no-defaults --initialize-insecure --datadir=/dev/shm/qa/node1 ./pxc80/bin/mysqld --no-defaults --initialize-insecure --datadir=/dev/shm/qa/node2 ./pxc80/bin/mysqld --defaults-file=/dev/shm/qa/n1.cnf --wsrep-new-cluster & ./pxc80/bin/mysqld --defaults-file=/dev/shm/qa/n2.cnf & Login to node1 CREATE TABLESPACE `ts1` ADD DATAFILE 'ts1.ibd' ENCRYPTION = 'Y' Engine=InnoDB; CREATE TABLE t1 (c1 INT) ENCRYPTION = 'Y'; alter table t1 tablespace ts1; ALTER TABLESPACE ts1 ENCRYPTION = 'N';
Attached config files
GDB info
#0 __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62 62 ../sysdeps/unix/sysv/linux/pthread_kill.c: No such file or directory. [Current thread is 1 (Thread 0x7f8fe0134700 (LWP 5618))] (gdb) bt +bt #0 __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62 #1 0x000000000475d0a3 in my_write_core (sig=6) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/mysys/stacktrace.cc:278 #2 0x000000000359acc4 in handle_fatal_signal (sig=6) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/signal_handler.cc:264 #3 <signal handler called> #4 0x00007f9026ca3428 in __GI_raise ([email protected]=6) at ../sysdeps/unix/sysv/linux/raise.c:54 #5 0x00007f9026ca502a in __GI_abort () at abort.c:89 #6 0x0000000004d0e00a in ut_dbg_assertion_failed (expr=0x6173c40 "((space->flags & ((~(~0U << 1)) << (((((((0 + 1) + 4) + 1) + 4) + 1) + 1) + 1))) >> (((((((0 + 1) + 4) + 1) + 4) + 1) + 1) + 1))", file=0x61715f8 "/mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/storage/innobase/fsp/fsp0fsp.cc", line=4210) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/storage/innobase/ut/ut0dbg.cc:92 #7 0x0000000004ef72f1 in fsp_alter_encrypt_tablespace (thd=0x7f8f3400bf70, space_id=2, from_page=1, to_encrypt=false, in_recovery=false, dd_space_in=0x7f8f342bd828) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/storage/innobase/fsp/fsp0fsp.cc:4210 #8 0x00000000049d997a in innobase_alter_encrypt_tablespace (hton=0x7ce5d20, thd=0x7f8f3400bf70, alter_info=0x7f8fe012d700, old_dd_space=0x7f8f342bd588, new_dd_space=0x7f8f342bd828) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/storage/innobase/handler/ha_innodb.cc:16592 #9 0x00000000049d9ddc in innodb_alter_tablespace (hton=0x7ce5d20, thd=0x7f8f3400bf70, alter_info=0x7f8fe012d700, old_dd_space=0x7f8f342bd588, new_dd_space=0x7f8f342bd828) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/storage/innobase/handler/ha_innodb.cc:16647 #10 0x00000000049dbbdd in innobase_alter_tablespace (hton=0x7ce5d20, thd=0x7f8f3400bf70, alter_info=0x7f8fe012d700, old_ts_def=0x7f8f342bd588, new_ts_def=0x7f8f342bd828) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/storage/innobase/handler/ha_innodb.cc:17124 #11 0x00000000034a1570 in Sql_cmd_alter_tablespace::execute (this=0x7f8f34d57520, thd=0x7f8f3400bf70) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_tablespace.cc:737 #12 0x00000000033b9571 in mysql_execute_command (thd=0x7f8f3400bf70, first_level=true) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_parse.cc:5242 #13 0x00000000033bc297 in mysql_parse (thd=0x7f8f3400bf70, parser_state=0x7f8fe0130cc0, update_userstat=false, force_primary_storage_engine=false) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_parse.cc:6076 #14 0x00000000033bfd0d in wsrep_mysql_parse (thd=0x7f8f3400bf70, rawbuf=0x7f8f34d54c88 "ALTER TABLESPACE ts1 ENCRYPTION = 'N'", length=37, parser_state=0x7f8fe0130cc0, update_userstat=false, force_primary_storage_engine=false) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_parse.cc:7263 #15 0x00000000033ae3c9 in dispatch_command (thd=0x7f8f3400bf70, com_data=0x7f8fe0132c90, command=COM_QUERY) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_parse.cc:2050 #16 0x00000000033abb85 in do_command (thd=0x7f8f3400bf70) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_parse.cc:1419 #17 0x000000000358428f in handle_connection (arg=0x7e2e110) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/conn_handler/connection_handler_per_thread.cc:311 #18 0x0000000004853dc6 in pfs_spawn_thread (arg=0x7d819b0) at /mnt/workspace/qa.pxc80.build/BUILD_TYPE/debug/Host/min-xenial-x64/storage/perfschema/pfs.cc:2836 #19 0x00007f90289cd6ba in start_thread (arg=0x7f8fe0134700) at pthread_create.c:333 #20 0x00007f9026d7541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
