Details
Description
SET GLOBAL read_only=1; |
SET SESSION wsrep_trx_fragment_size = 64; |
set default_storage_engine=SEQUENCE; |
SET AUTOCOMMIT = OFF; |
CREATE TABLE t1(c1 NUMERIC NOT NULL); |
CREATE TABLE t1 (id INT PRIMARY KEY) engine=innodb; |
SET SESSION SQL_MODE='HIGH_NOT_PRECEDENCE'; |
INSERT INTO t1 VALUES (1),(2),(3); |
SET GLOBAL SQL_MODE='NO_ENGINE_SUBSTITUTION'; |
DROP TABLE dummy; |
INSERT INTO t1 VALUES('a'); |
SET @@global.wsrep_cluster_address='gcomm://'; |
SET SESSION SQL_MODE='TRADITIONAL '; |
Leads to
10.11.3 8460eb25d1f897d403136e75b75ef595470d641c (Debug) |
mysqld: /test/10.11_dbg/wsrep-lib/src/transaction.cpp:195: void wsrep::transaction::adopt(const wsrep::transaction&): Assertion `transaction.is_streaming()' failed.
|
10.11.3 8460eb25d1f897d403136e75b75ef595470d641c (Debug) |
Core was generated by `/test/GAL_MD010323-mariadb-10.11.3-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 0x150c11b31700 (LWP 2973365))]
|
#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
|
#1 0x00005561db865790 in my_write_core (sig=sig@entry=6) at /test/10.11_dbg/mysys/stacktrace.c:424
|
#2 0x00005561db13fffb in handle_fatal_signal (sig=6) at /test/10.11_dbg/sql/signal_handler.cc:357
|
#3 <signal handler called>
|
#4 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
|
#5 0x0000150c133c2859 in __GI_abort () at abort.c:79
|
#6 0x0000150c133c2729 in __assert_fail_base (fmt=0x150c13558588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x5561dbff76fc "transaction.is_streaming()",
|
file=0x5561dbff7f98 "/test/10.11_dbg/wsrep-lib/src/transaction.cpp", line=195, function=<optimized out>) at assert.c:92
|
#7 0x0000150c133d3fd6 in __GI___assert_fail (assertion=assertion@entry=0x5561dbff76fc "transaction.is_streaming()", file=file@entry=0x5561dbff7f98 "/test/10.11_dbg/wsrep-lib/src/transaction.cpp",
|
line=line@entry=195, function=function@entry=0x5561dbff82b8 "void wsrep::transaction::adopt(const wsrep::transaction&)") at assert.c:101
|
#8 0x00005561db9ddde0 in wsrep::transaction::adopt (this=0x150bfc007760, transaction=...) at /test/10.11_dbg/wsrep-lib/src/transaction.cpp:200
|
#9 0x00005561db3f4087 in wsrep::client_state::adopt_transaction (transaction=..., this=<optimized out>) at /test/10.11_dbg/wsrep-lib/include/wsrep/client_state.hpp:692
|
#10 Wsrep_high_priority_service::adopt_transaction (this=this@entry=0x150c11b30c00, transaction=...) at /test/10.11_dbg/sql/wsrep_high_priority_service.cc:240
|
#11 0x00005561db9d4ec1 in wsrep::server_state::close_orphaned_sr_transactions (this=this@entry=0x5561de7b5960, lock=..., high_priority_service=...) at /test/10.11_dbg/wsrep-lib/src/server_state.cpp:1527
|
#12 0x00005561db9d5e65 in wsrep::server_state::on_primary_view (this=this@entry=0x5561de7b5960, view=..., high_priority_service=high_priority_service@entry=0x150c11b30c00)
|
at /test/10.11_dbg/wsrep-lib/src/server_state.cpp:983
|
#13 0x00005561db9d8f66 in wsrep::server_state::on_view (this=this@entry=0x5561de7b5960, view=..., high_priority_service=high_priority_service@entry=0x150c11b30c00)
|
at /test/10.11_dbg/wsrep-lib/src/server_state.cpp:1040
|
#14 0x00005561db9ee77c in (anonymous namespace)::view_cb (app_ctx=0x5561de7b5960, recv_ctx=0x150c11b30c00, view_info=<optimized out>) at /test/10.11_dbg/wsrep-lib/src/wsrep_provider_v26.cpp:404
|
#15 0x0000150c12e3270d in galera::ReplicatorSMM::submit_view_info (this=<optimized out>, recv_ctx=<optimized out>, view_info=<optimized out>) at /test/galera_4x_dbg/galera/src/replicator_smm.cpp:2437
|
#16 0x0000150c12e3274d in galera::ReplicatorSMM::submit_ordered_view_info (this=0x5561de7cc310, recv_ctx=<optimized out>, view_info=<optimized out>) at /test/galera_4x_dbg/galera/src/replicator_smm.cpp:2827
|
#17 0x0000150c12e42f99 in galera::ReplicatorSMM::process_prim_conf_change (this=0x5561de7cc310, recv_ctx=0x150c11b30c00, conf=..., my_index=<optimized out>, cc_buf=<optimized out>)
|
at /test/galera_4x_dbg/galera/src/replicator_smm.cpp:3018
|
#18 0x0000150c12e4321d in galera::ReplicatorSMM::process_conf_change (this=0x5561de7cc310, recv_ctx=0x150c11b30c00, conf=..., cc=...) at /test/galera_4x_dbg/galera/src/replicator_smm.cpp:2466
|
#19 0x0000150c12e73e5b in galera::GcsActionSource::dispatch (this=0x5561de7c4e70, recv_ctx=0x150c11b30c00, act=..., exit_loop=<optimized out>) at /test/galera_4x_dbg/galera/src/gcs_action_source.cpp:127
|
#20 0x0000150c12e74322 in galera::GcsActionSource::process (this=0x5561de7c4e70, recv_ctx=0x150c11b30c00, exit_loop=@0x150c11b3082f: false) at /test/galera_4x_dbg/galera/src/gcs_action_source.cpp:186
|
#21 0x0000150c12e3ed50 in galera::ReplicatorSMM::async_recv (this=0x5561de7cc310, recv_ctx=0x150c11b30c00) at /test/galera_4x_dbg/galera/src/replicator_smm.cpp:402
|
#22 0x0000150c12e13641 in galera_recv (gh=<optimized out>, recv_ctx=<optimized out>) at /test/galera_4x_dbg/galera/src/wsrep_provider.cpp:264
|
#23 0x00005561db9ed682 in wsrep::wsrep_provider_v26::run_applier (this=<optimized out>, applier_ctx=<optimized out>) at /test/10.11_dbg/wsrep-lib/src/wsrep_provider_v26.cpp:858
|
#24 0x00005561db411d99 in wsrep_replication_process (thd=0x150bfc001008, arg=<optimized out>) at /test/10.11_dbg/sql/wsrep_server_state.h:51
|
#25 0x00005561db3fec70 in start_wsrep_THD (arg=0x150b9c07fee0) at /test/10.11_dbg/sql/wsrep_mysqld.h:541
|
#26 0x0000150c138d3609 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
#27 0x0000150c134bf133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
Bug confirmed present in:
MariaDB: 10.4.29 (dbg), 10.5.20 (dbg), 10.6.13 (dbg),10.7.8 (dbg), 10.8.8 (dbg), 10.9.6 (dbg), 10.10.4 (dbg), 10.11.3 (dbg)
Bug (or feature/syntax) confirmed not present in:
MariaDB: 10.4.29 (opt), 10.5.20 (opt), 10.6.12 (opt), 10.7.8 (opt), 10.8.8 (opt), 10.9.6 (opt), 10.10.4 (opt), 10.11.3 (opt)