There is even no need to alter engine to myisam.
Simply:
CREATESEQUENCE Seq1_1 START WITH 1 INCREMENT BY 1;
selectNEXT VALUE FOR Seq1_1;
altertable Seq1_1 engine=innodb;
selectNEXT VALUE FOR Seq1_1;
ERROR 2013 (HY000): Lost connectionto MySQL server during query
Shahriyar Rzayev (Inactive)
added a comment - There is even no need to alter engine to myisam.
Simply:
CREATE SEQUENCE Seq1_1 START WITH 1 INCREMENT BY 1;
select NEXT VALUE FOR Seq1_1;
alter table Seq1_1 engine=innodb;
select NEXT VALUE FOR Seq1_1;
ERROR 2013 (HY000): Lost connection to MySQL server during query
#7 0x00007f93b1ab3f12 in __GI___assert_fail (assertion=0x5631c9fc1450 "client_state.transaction().active()", file=0x5631c9fc12a8 "/data/src/10.4/sql/service_wsrep.cc", line=274, function=0x5631c9fc15c0 <wsrep_thd_append_key::__PRETTY_FUNCTION__> "int wsrep_thd_append_key(THD*, const wsrep_key*, int, Wsrep_service_key_type)") at assert.c:101
#8 0x00005631c94c6e3b in wsrep_thd_append_key (thd=0x7f9334000af0, key=0x7f938b7ad3c0, n_keys=1, key_type=WSREP_SERVICE_KEY_EXCLUSIVE) at /data/src/10.4/sql/service_wsrep.cc:274
#9 0x00005631c97f42bf in wsrep_append_key (thd=0x7f9334000af0, trx=0x7f93a8270390, table_share=0x7f9334169308, key=0x7f938b7aeac0 "\275G\337>\246\244T\223\bz\325n\344\364\203\333 \357\306\312\061V", key_len=16, key_type=WSREP_SERVICE_KEY_EXCLUSIVE) at /data/src/10.4/storage/innobase/handler/ha_innodb.cc:10378
#10 0x00005631c97f4f1d in ha_innobase::wsrep_append_keys (this=0x7f933417b9d8, thd=0x7f9334000af0, key_type=WSREP_SERVICE_KEY_EXCLUSIVE, record0=0x7f9334174720 "\375\001", record1=0x0) at /data/src/10.4/storage/innobase/handler/ha_innodb.cc:10579
#11 0x00005631c97ee8b7 in ha_innobase::write_row (this=0x7f933417b9d8, record=0x7f9334174720 "\375\001") at /data/src/10.4/storage/innobase/handler/ha_innodb.cc:8196
#12 0x00005631c95b0160 in handler::ha_write_row (this=0x7f933417b9d8, buf=0x7f9334174720 "\375\001") at /data/src/10.4/sql/handler.cc:6677
#13 0x00005631c91f3dbb in write_record (thd=0x7f9334000af0, table=0x7f933402b190, info=0x7f9334014e50) at /data/src/10.4/sql/sql_insert.cc:1732
#14 0x00005631c91fa9a3 in select_insert::send_data (this=0x7f9334014e08, values=...) at /data/src/10.4/sql/sql_insert.cc:3967
#15 0x00005631c92918b5 in JOIN::exec_inner (this=0x7f9334014eb8) at /data/src/10.4/sql/sql_select.cc:4323
#16 0x00005631c9291160 in JOIN::exec (this=0x7f9334014eb8) at /data/src/10.4/sql/sql_select.cc:4237
#17 0x00005631c9292875 in mysql_select (thd=0x7f9334000af0, tables=0x7f9334013de0, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=3489925888, result=0x7f9334014e08, unit=0x7f9334004a18, select_lex=0x7f9334013748) at /data/src/10.4/sql/sql_select.cc:4669
#18 0x00005631c928240c in handle_select (thd=0x7f9334000af0, lex=0x7f9334004958, result=0x7f9334014e08, setup_tables_done_option=1073741824) at /data/src/10.4/sql/sql_select.cc:422
#19 0x00005631c9240dcc in mysql_execute_command (thd=0x7f9334000af0) at /data/src/10.4/sql/sql_parse.cc:4642
#20 0x00005631c924cbf1 in mysql_parse (thd=0x7f9334000af0, rawbuf=0x7f9334012f88 "REPLACE INTO t1 SELECT COUNT(*) FROM s", length=38, parser_state=0x7f938b7b11b0, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:7900
#21 0x00005631c924c1ed in wsrep_mysql_parse (thd=0x7f9334000af0, rawbuf=0x7f9334012f88 "REPLACE INTO t1 SELECT COUNT(*) FROM s", length=38, parser_state=0x7f938b7b11b0, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:7704
#22 0x00005631c9237c80 in dispatch_command (command=COM_QUERY, thd=0x7f9334000af0, packet=0x7f933401fa21 "REPLACE INTO t1 SELECT COUNT(*) FROM s", packet_length=38, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1827
#23 0x00005631c923644d in do_command (thd=0x7f9334000af0) at /data/src/10.4/sql/sql_parse.cc:1360
#24 0x00005631c93bf9db in do_handle_one_connection (connect=0x5631cd372e40) at /data/src/10.4/sql/sql_connect.cc:1412
#25 0x00005631c93bf72a in handle_one_connection (arg=0x5631cd372e40) at /data/src/10.4/sql/sql_connect.cc:1316
#26 0x00007f93b3a3c4a4 in start_thread (arg=0x7f938b7b2700) at pthread_create.c:456
#27 0x00007f93b1b70d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
#8 0x0000560c6db04a27 in wsrep_thd_append_key (thd=0x7f9980000b18, key=0x7f9a0c0c6ab0, n_keys=1, key_type=WSREP_SERVICE_KEY_EXCLUSIVE) at /data/src/10.5/sql/service_wsrep.cc:273
#9 0x0000560c6db35b48 in wsrep_append_key (thd=0x7f9980000b18, trx=0x7f99e7c013c0, table_share=0x7f99801127f0, key=0x7f9a0c0c7990 "\275G\337>\246\244T\223\bz\325n\344\364\203\333\003", key_len=16, key_type=WSREP_SERVICE_KEY_EXCLUSIVE) at /data/src/10.5/storage/innobase/handler/ha_innodb.cc:10083
#10 0x0000560c6db36630 in ha_innobase::wsrep_append_keys (this=0x7f9980125720, thd=0x7f9980000b18, key_type=WSREP_SERVICE_KEY_EXCLUSIVE, record0=0x7f99800cf588 "\375\001", record1=0x0) at /data/src/10.5/storage/innobase/handler/ha_innodb.cc:10285
#11 0x0000560c6db304ea in ha_innobase::write_row (this=0x7f9980125720, record=0x7f99800cf588 "\375\001") at /data/src/10.5/storage/innobase/handler/ha_innodb.cc:7914
#12 0x0000560c6d6e6b1f in handler::ha_write_row (this=0x7f9980125720, buf=0x7f99800cf588 "\375\001") at /data/src/10.5/sql/handler.cc:6857
#13 0x0000560c6d33431e in write_record (thd=0x7f9980000b18, table=0x7f9980088f38, info=0x7f99800155f0, sink=0x0) at /data/src/10.5/sql/sql_insert.cc:1737
#14 0x0000560c6d33b38d in select_insert::send_data (this=0x7f99800155a0, values=...) at /data/src/10.5/sql/sql_insert.cc:4064
#15 0x0000560c6d41ec45 in select_result_sink::send_data_with_check (this=0x7f99800155a0, items=..., u=0x7f9980004b20, sent=0) at /data/src/10.5/sql/sql_class.h:5233
#16 0x0000560c6d3d581d in JOIN::exec_inner (this=0x7f9980015658) at /data/src/10.5/sql/sql_select.cc:4327
#17 0x0000560c6d3d50b7 in JOIN::exec (this=0x7f9980015658) at /data/src/10.5/sql/sql_select.cc:4240
#18 0x0000560c6d3d67e8 in mysql_select (thd=0x7f9980000b18, tables=0x7f9980014560, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2202244745984, result=0x7f99800155a0, unit=0x7f9980004b20, select_lex=0x7f9980013eb0) at /data/src/10.5/sql/sql_select.cc:4664
#19 0x0000560c6d3c6358 in handle_select (thd=0x7f9980000b18, lex=0x7f9980004a58, result=0x7f99800155a0, setup_tables_done_option=1073741824) at /data/src/10.5/sql/sql_select.cc:429
#20 0x0000560c6d384e48 in mysql_execute_command (thd=0x7f9980000b18) at /data/src/10.5/sql/sql_parse.cc:4661
#21 0x0000560c6d3904be in mysql_parse (thd=0x7f9980000b18, rawbuf=0x7f99800136e0 "REPLACE INTO t1 SELECT COUNT(*) FROM s", length=38, parser_state=0x7f9a0c0c9520, is_com_multi=false, is_next_command=false) at /data/src/10.5/sql/sql_parse.cc:7953
#22 0x0000560c6d38fbcf in wsrep_mysql_parse (thd=0x7f9980000b18, rawbuf=0x7f99800136e0 "REPLACE INTO t1 SELECT COUNT(*) FROM s", length=38, parser_state=0x7f9a0c0c9520, is_com_multi=false, is_next_command=false) at /data/src/10.5/sql/sql_parse.cc:7756
#23 0x0000560c6d37bc13 in dispatch_command (command=COM_QUERY, thd=0x7f9980000b18, packet=0x7f9980008689 "REPLACE INTO t1 SELECT COUNT(*) FROM s", packet_length=38, is_com_multi=false, is_next_command=false) at /data/src/10.5/sql/sql_parse.cc:1825
#24 0x0000560c6d37a445 in do_command (thd=0x7f9980000b18) at /data/src/10.5/sql/sql_parse.cc:1359
#25 0x0000560c6d51ca33 in do_handle_one_connection (connect=0x560c7194a3f8, put_in_cache=true) at /data/src/10.5/sql/sql_connect.cc:1422
#26 0x0000560c6d51c762 in handle_one_connection (arg=0x560c7194a3f8) at /data/src/10.5/sql/sql_connect.cc:1319
#27 0x0000560c6da4fdcc in pfs_spawn_thread (arg=0x560c7182ec48) at /data/src/10.5/storage/perfschema/pfs.cc:2201
#28 0x00007f9a0f7904a4 in start_thread (arg=0x7f9a0c0ca700) at pthread_create.c:456
#29 0x00007f9a0d8c4d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
Reproducible on 10.4, 10.5.
No obvious problem on a non-debug build.
Elena Stepanova
added a comment - - edited Same assertion failure, somewhat different test case and stack trace:
--source include/galera_cluster.inc
--source include/have_innodb.inc
CREATE SEQUENCE s;
CREATE TABLE t1 (a INT ) ENGINE=InnoDB;
--connect (con1,localhost,root,,test)
BACKUP STAGE START;
BACKUP STAGE BLOCK_COMMIT;
--connection default
REPLACE INTO t1 SELECT COUNT (*) FROM s;
10.4 1c8de231
mysqld: /data/src/10.4/sql/service_wsrep.cc:274: int wsrep_thd_append_key(THD*, const wsrep_key*, int, Wsrep_service_key_type): Assertion `client_state.transaction().active()' failed.
200326 23:50:02 [ERROR] mysqld got signal 6 ;
#7 0x00007f93b1ab3f12 in __GI___assert_fail (assertion=0x5631c9fc1450 "client_state.transaction().active()", file=0x5631c9fc12a8 "/data/src/10.4/sql/service_wsrep.cc", line=274, function=0x5631c9fc15c0 <wsrep_thd_append_key::__PRETTY_FUNCTION__> "int wsrep_thd_append_key(THD*, const wsrep_key*, int, Wsrep_service_key_type)") at assert.c:101
#8 0x00005631c94c6e3b in wsrep_thd_append_key (thd=0x7f9334000af0, key=0x7f938b7ad3c0, n_keys=1, key_type=WSREP_SERVICE_KEY_EXCLUSIVE) at /data/src/10.4/sql/service_wsrep.cc:274
#9 0x00005631c97f42bf in wsrep_append_key (thd=0x7f9334000af0, trx=0x7f93a8270390, table_share=0x7f9334169308, key=0x7f938b7aeac0 "\275G\337>\246\244T\223\bz\325n\344\364\203\333 \357\306\312\061V", key_len=16, key_type=WSREP_SERVICE_KEY_EXCLUSIVE) at /data/src/10.4/storage/innobase/handler/ha_innodb.cc:10378
#10 0x00005631c97f4f1d in ha_innobase::wsrep_append_keys (this=0x7f933417b9d8, thd=0x7f9334000af0, key_type=WSREP_SERVICE_KEY_EXCLUSIVE, record0=0x7f9334174720 "\375\001", record1=0x0) at /data/src/10.4/storage/innobase/handler/ha_innodb.cc:10579
#11 0x00005631c97ee8b7 in ha_innobase::write_row (this=0x7f933417b9d8, record=0x7f9334174720 "\375\001") at /data/src/10.4/storage/innobase/handler/ha_innodb.cc:8196
#12 0x00005631c95b0160 in handler::ha_write_row (this=0x7f933417b9d8, buf=0x7f9334174720 "\375\001") at /data/src/10.4/sql/handler.cc:6677
#13 0x00005631c91f3dbb in write_record (thd=0x7f9334000af0, table=0x7f933402b190, info=0x7f9334014e50) at /data/src/10.4/sql/sql_insert.cc:1732
#14 0x00005631c91fa9a3 in select_insert::send_data (this=0x7f9334014e08, values=...) at /data/src/10.4/sql/sql_insert.cc:3967
#15 0x00005631c92918b5 in JOIN::exec_inner (this=0x7f9334014eb8) at /data/src/10.4/sql/sql_select.cc:4323
#16 0x00005631c9291160 in JOIN::exec (this=0x7f9334014eb8) at /data/src/10.4/sql/sql_select.cc:4237
#17 0x00005631c9292875 in mysql_select (thd=0x7f9334000af0, tables=0x7f9334013de0, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=3489925888, result=0x7f9334014e08, unit=0x7f9334004a18, select_lex=0x7f9334013748) at /data/src/10.4/sql/sql_select.cc:4669
#18 0x00005631c928240c in handle_select (thd=0x7f9334000af0, lex=0x7f9334004958, result=0x7f9334014e08, setup_tables_done_option=1073741824) at /data/src/10.4/sql/sql_select.cc:422
#19 0x00005631c9240dcc in mysql_execute_command (thd=0x7f9334000af0) at /data/src/10.4/sql/sql_parse.cc:4642
#20 0x00005631c924cbf1 in mysql_parse (thd=0x7f9334000af0, rawbuf=0x7f9334012f88 "REPLACE INTO t1 SELECT COUNT(*) FROM s", length=38, parser_state=0x7f938b7b11b0, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:7900
#21 0x00005631c924c1ed in wsrep_mysql_parse (thd=0x7f9334000af0, rawbuf=0x7f9334012f88 "REPLACE INTO t1 SELECT COUNT(*) FROM s", length=38, parser_state=0x7f938b7b11b0, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:7704
#22 0x00005631c9237c80 in dispatch_command (command=COM_QUERY, thd=0x7f9334000af0, packet=0x7f933401fa21 "REPLACE INTO t1 SELECT COUNT(*) FROM s", packet_length=38, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1827
#23 0x00005631c923644d in do_command (thd=0x7f9334000af0) at /data/src/10.4/sql/sql_parse.cc:1360
#24 0x00005631c93bf9db in do_handle_one_connection (connect=0x5631cd372e40) at /data/src/10.4/sql/sql_connect.cc:1412
#25 0x00005631c93bf72a in handle_one_connection (arg=0x5631cd372e40) at /data/src/10.4/sql/sql_connect.cc:1316
#26 0x00007f93b3a3c4a4 in start_thread (arg=0x7f938b7b2700) at pthread_create.c:456
#27 0x00007f93b1b70d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
10.5 b8e75791
mysqld: /data/src/10.5/sql/service_wsrep.cc:273: int wsrep_thd_append_key(THD*, const wsrep_key*, int, Wsrep_service_key_type): Assertion `client_state.transaction().active()' failed.
file=0x560c6e421e48 "/data/src/10.5/sql/service_wsrep.cc", line=273, function=0x560c6e422160 <wsrep_thd_append_key::__PRETTY_FUNCTION__> "int wsrep_thd_append_key(THD*, const wsrep_key*, int, Wsrep_service_key_type)") at assert.c:101
#8 0x0000560c6db04a27 in wsrep_thd_append_key (thd=0x7f9980000b18, key=0x7f9a0c0c6ab0, n_keys=1, key_type=WSREP_SERVICE_KEY_EXCLUSIVE) at /data/src/10.5/sql/service_wsrep.cc:273
#9 0x0000560c6db35b48 in wsrep_append_key (thd=0x7f9980000b18, trx=0x7f99e7c013c0, table_share=0x7f99801127f0, key=0x7f9a0c0c7990 "\275G\337>\246\244T\223\bz\325n\344\364\203\333\003", key_len=16, key_type=WSREP_SERVICE_KEY_EXCLUSIVE) at /data/src/10.5/storage/innobase/handler/ha_innodb.cc:10083
#10 0x0000560c6db36630 in ha_innobase::wsrep_append_keys (this=0x7f9980125720, thd=0x7f9980000b18, key_type=WSREP_SERVICE_KEY_EXCLUSIVE, record0=0x7f99800cf588 "\375\001", record1=0x0) at /data/src/10.5/storage/innobase/handler/ha_innodb.cc:10285
#11 0x0000560c6db304ea in ha_innobase::write_row (this=0x7f9980125720, record=0x7f99800cf588 "\375\001") at /data/src/10.5/storage/innobase/handler/ha_innodb.cc:7914
#12 0x0000560c6d6e6b1f in handler::ha_write_row (this=0x7f9980125720, buf=0x7f99800cf588 "\375\001") at /data/src/10.5/sql/handler.cc:6857
#13 0x0000560c6d33431e in write_record (thd=0x7f9980000b18, table=0x7f9980088f38, info=0x7f99800155f0, sink=0x0) at /data/src/10.5/sql/sql_insert.cc:1737
#14 0x0000560c6d33b38d in select_insert::send_data (this=0x7f99800155a0, values=...) at /data/src/10.5/sql/sql_insert.cc:4064
#15 0x0000560c6d41ec45 in select_result_sink::send_data_with_check (this=0x7f99800155a0, items=..., u=0x7f9980004b20, sent=0) at /data/src/10.5/sql/sql_class.h:5233
#16 0x0000560c6d3d581d in JOIN::exec_inner (this=0x7f9980015658) at /data/src/10.5/sql/sql_select.cc:4327
#17 0x0000560c6d3d50b7 in JOIN::exec (this=0x7f9980015658) at /data/src/10.5/sql/sql_select.cc:4240
#18 0x0000560c6d3d67e8 in mysql_select (thd=0x7f9980000b18, tables=0x7f9980014560, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2202244745984, result=0x7f99800155a0, unit=0x7f9980004b20, select_lex=0x7f9980013eb0) at /data/src/10.5/sql/sql_select.cc:4664
#19 0x0000560c6d3c6358 in handle_select (thd=0x7f9980000b18, lex=0x7f9980004a58, result=0x7f99800155a0, setup_tables_done_option=1073741824) at /data/src/10.5/sql/sql_select.cc:429
#20 0x0000560c6d384e48 in mysql_execute_command (thd=0x7f9980000b18) at /data/src/10.5/sql/sql_parse.cc:4661
#21 0x0000560c6d3904be in mysql_parse (thd=0x7f9980000b18, rawbuf=0x7f99800136e0 "REPLACE INTO t1 SELECT COUNT(*) FROM s", length=38, parser_state=0x7f9a0c0c9520, is_com_multi=false, is_next_command=false) at /data/src/10.5/sql/sql_parse.cc:7953
#22 0x0000560c6d38fbcf in wsrep_mysql_parse (thd=0x7f9980000b18, rawbuf=0x7f99800136e0 "REPLACE INTO t1 SELECT COUNT(*) FROM s", length=38, parser_state=0x7f9a0c0c9520, is_com_multi=false, is_next_command=false) at /data/src/10.5/sql/sql_parse.cc:7756
#23 0x0000560c6d37bc13 in dispatch_command (command=COM_QUERY, thd=0x7f9980000b18, packet=0x7f9980008689 "REPLACE INTO t1 SELECT COUNT(*) FROM s", packet_length=38, is_com_multi=false, is_next_command=false) at /data/src/10.5/sql/sql_parse.cc:1825
#24 0x0000560c6d37a445 in do_command (thd=0x7f9980000b18) at /data/src/10.5/sql/sql_parse.cc:1359
#25 0x0000560c6d51ca33 in do_handle_one_connection (connect=0x560c7194a3f8, put_in_cache=true) at /data/src/10.5/sql/sql_connect.cc:1422
#26 0x0000560c6d51c762 in handle_one_connection (arg=0x560c7194a3f8) at /data/src/10.5/sql/sql_connect.cc:1319
#27 0x0000560c6da4fdcc in pfs_spawn_thread (arg=0x560c7182ec48) at /data/src/10.5/storage/perfschema/pfs.cc:2201
#28 0x00007f9a0f7904a4 in start_thread (arg=0x7f9a0c0ca700) at pthread_create.c:456
#29 0x00007f9a0d8c4d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
Reproducible on 10.4, 10.5.
No obvious problem on a non-debug build.
[Current thread is 1 (Thread 0x14b3d8506700 (LWP 341826))]
(gdb) bt
#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
#1 0x00005635a440c2cd in my_write_core (sig=sig@entry=6) at /test/10.6_dbg/mysys/stacktrace.c:424
#2 0x00005635a3bad124 in handle_fatal_signal (sig=6) at /test/10.6_dbg/sql/signal_handler.cc:331
#3 <signal handler called>
#4 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
#5 0x000014b40cce7859 in __GI_abort () at abort.c:79
#6 0x000014b40cce7729 in __assert_fail_base (fmt=0x14b40ce7d588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x5635a47b42c0 "client_state.transaction().active()", file=0x5635a47b3f60 "/test/10.6_dbg/sql/service_wsrep.cc", line=301, function=<optimized out>) at assert.c:92
#7 0x000014b40ccf8f36 in __GI___assert_fail (assertion=assertion@entry=0x5635a47b42c0 "client_state.transaction().active()", file=file@entry=0x5635a47b3f60 "/test/10.6_dbg/sql/service_wsrep.cc", line=line@entry=301, function=function@entry=0x5635a47b42e8 "int wsrep_thd_append_key(THD*, const wsrep_key*, int, Wsrep_service_key_type)") at assert.c:101
#8 0x00005635a3f7ef3b in wsrep_thd_append_key (thd=thd@entry=0x14b3a0000db8, key=key@entry=0x14b3d8502b50, n_keys=n_keys@entry=1, key_type=key_type@entry=WSREP_SERVICE_KEY_UPDATE) at /test/10.6_dbg/wsrep-lib/include/wsrep/transaction_id.hpp:52
#9 0x00005635a3f93b05 in wsrep_append_key (thd=thd@entry=0x14b3a0000db8, trx=trx@entry=0x14b3d97552a0, table_share=0x14b3a0049ed0, key=key@entry=0x14b3d8503a00 "\225IØ»\372\003s\223\216\067\377\375\063[\001\244h\001\003\240\263\024", key_len=key_len@entry=16, key_type=key_type@entry=WSREP_SERVICE_KEY_UPDATE) at /test/10.6_dbg/storage/innobase/handler/ha_innodb.cc:9625
#10 0x00005635a3fa012e in ha_innobase::wsrep_append_keys (this=this@entry=0x14b3a004f090, thd=0x14b3a0000db8, key_type=WSREP_SERVICE_KEY_UPDATE, record0=record0@entry=0x14b3a004ec68 "\377\001", record1=record1@entry=0x14b3a004ec28 "\377\001") at /test/10.6_dbg/storage/innobase/handler/ha_innodb.cc:9827
#11 0x00005635a3fafff6 in ha_innobase::update_row (this=0x14b3a004f090, old_row=0x14b3a004ec68 "\377\001", new_row=0x14b3a004ec28 "\377\001") at /test/10.6_dbg/storage/innobase/handler/ha_innodb.cc:8214
#12 0x00005635a3bb5730 in handler::update_first_row (this=0x14b3a004f090, new_data=0x14b3a004ec28 "\377\001") at /test/10.6_dbg/sql/handler.cc:7246
#13 0x00005635a3f5717d in ha_sequence::write_row (this=0x14b3a004f8f0, buf=0x14b3a004ec28 "\377\001") at /test/10.6_dbg/sql/ha_sequence.cc:268
#14 0x00005635a3bc0f70 in handler::ha_write_row (this=0x14b3a004f8f0, buf=0x14b3a004ec28 "\377\001") at /test/10.6_dbg/sql/handler.cc:7155
#15 0x00005635a389bc7f in write_record (thd=0x14b3a0000db8, table=0x14b3a004c2d8, info=info@entry=0x14b3a0015a08, sink=0x0) at /test/10.6_dbg/sql/sql_insert.cc:2106
#16 0x00005635a389c0d5 in select_insert::send_data (this=0x14b3a00159b8, values=<optimized out>) at /test/10.6_dbg/sql/sql_insert.cc:4060
#17 0x00005635a394fe73 in select_result_sink::send_data_with_check (sent=<optimized out>, u=<optimized out>, items=@0x14b3a00144a8: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x14b3a0014920, last = 0x14b3a0016b50, elements = 8}, <No data fields>}, this=<optimized out>) at /test/10.6_dbg/sql/sql_class.h:5554
#18 end_send (join=join@entry=0x14b3a0015a70, join_tab=join_tab@entry=0x0, end_of_records=end_of_records@entry=false) at /test/10.6_dbg/sql/sql_select.cc:21952
#19 0x00005635a396d96c in do_select (procedure=0x0, join=0x14b3a0015a70) at /test/10.6_dbg/sql/sql_select.cc:20238
#20 JOIN::exec_inner (this=this@entry=0x14b3a0015a70) at /test/10.6_dbg/sql/sql_select.cc:4477
#21 0x00005635a396e0fb in JOIN::exec (this=this@entry=0x14b3a0015a70) at /test/10.6_dbg/sql/sql_select.cc:4257
#22 0x00005635a396c1ce in mysql_select (thd=thd@entry=0x14b3a0000db8, tables=0x14b3a0014968, fields=@0x14b3a00144a8: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x14b3a0014920, last = 0x14b3a0016b50, elements = 8}, <No data fields>}, conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2202244745984, result=0x14b3a00159b8, unit=0x14b3a0004f90, select_lex=0x14b3a0014358) at /test/10.6_dbg/sql/sql_select.cc:4733
#23 0x00005635a396c495 in handle_select (thd=thd@entry=0x14b3a0000db8, lex=lex@entry=0x14b3a0004ec8, result=result@entry=0x14b3a00159b8, setup_tables_done_option=setup_tables_done_option@entry=1073741824) at /test/10.6_dbg/sql/sql_select.cc:417
#24 0x00005635a38ee6c9 in mysql_execute_command (thd=thd@entry=0x14b3a0000db8) at /test/10.6_dbg/sql/sql_parse.cc:4691
#25 0x00005635a38d8b82 in mysql_parse (thd=thd@entry=0x14b3a0000db8, rawbuf=rawbuf@entry=0x14b3a0013ba0 "INSERT INTO s1 SELECT * FROM s2", length=length@entry=31, parser_state=parser_state@entry=0x14b3d8505410) at /test/10.6_dbg/sql/sql_parse.cc:7998
#26 0x00005635a38d851b in wsrep_mysql_parse (thd=thd@entry=0x14b3a0000db8, rawbuf=0x14b3a0013ba0 "INSERT INTO s1 SELECT * FROM s2", length=31, parser_state=parser_state@entry=0x14b3d8505410) at /test/10.6_dbg/sql/sql_parse.cc:7812
#27 0x00005635a38e75ec in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x14b3a0000db8, packet=packet@entry=0x14b3a000b359 "INSERT INTO s1 SELECT * FROM s2", packet_length=packet_length@entry=31, blocking=blocking@entry=true) at /test/10.6_dbg/sql/sql_class.h:1318
#28 0x00005635a38ea9b0 in do_command (thd=0x14b3a0000db8, blocking=blocking@entry=true) at /test/10.6_dbg/sql/sql_parse.cc:1397
#29 0x00005635a3a44af1 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x5635a5fb4b68, put_in_cache=put_in_cache@entry=true) at /test/10.6_dbg/sql/sql_connect.cc:1410
#30 0x00005635a3a450f9 in handle_one_connection (arg=arg@entry=0x5635a5fb4b68) at /test/10.6_dbg/sql/sql_connect.cc:1312
#31 0x00005635a3ef1c01 in pfs_spawn_thread (arg=0x5635a602c9f8) at /test/10.6_dbg/storage/perfschema/pfs.cc:2201
#32 0x000014b40d1f5609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#33 0x000014b40cde4293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
Added sample MTR tests as well.