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

--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;

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

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

CREATE SEQUENCE s1 nocache;

FLUSH TABLES;

CREATE SEQUENCE s2;

INSERT INTO s1 SELECT * FROM s2;

mysqld: /test/10.6_dbg/sql/service_wsrep.cc:301: int wsrep_thd_append_key(THD*, const wsrep_key*, int, Wsrep_service_key_type): Assertion `client_state.transaction().active()' failed.

Core was generated by `/test/GAL_MD150321-mariadb-10.6.0-linux-x86_64-dbg/bin/mysqld --defaults-file=/'.

Program terminated with signal SIGABRT, Aborted.

#0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6)

    at ../sysdeps/unix/sysv/linux/pthread_kill.c:56

[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