Details
-
Bug
-
Status: Stalled (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.4(EOL), 10.5, 10.6, 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL), 11.1(EOL), 11.2(EOL), 11.3(EOL)
-
None
Description
SET GLOBAL gtid_slave_pos= '1-2-3,2-4-6'; |
Leads to
|
10.6.16 7a6684b0b0ad32efb003ef21902ad3255c93db64 (Optimized) |
Core was generated by `/test/codership/GAL_MD150923-mariadb-10.6.16-linux-x86_64-opt/bin/mysqld --defa'.
|
Program terminated with signal SIGSEGV, Segmentation fault.
|
#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=11)
|
at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
|
[Current thread is 1 (Thread 0x15410154b700 (LWP 1687170))]
|
(gdb) bt
|
#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
|
#1 0x000055cd578fb29f in my_write_core (sig=sig@entry=11) at /test/codership/10.6_opt/mysys/stacktrace.c:424
|
#2 0x000055cd57430110 in handle_fatal_signal (sig=11) at /test/codership/10.6_opt/sql/signal_handler.cc:360
|
#3 <signal handler called>
|
#4 galera::TrxHandle::state (this=<optimized out>) at /test/codership/galera_4x/galera/src/trx_handle.hpp:196
|
#5 galera::ReplicatorSMM::replay_trx (this=0x55cd58ccd640, trx=Python Exception <class 'gdb.error'> No type named std::__detail::_Hash_node<class galera::TrxHandle::Transition, true>.:
|
@0x1540a40177c0: {<galera::TrxHandle> = {_vptr.TrxHandle = 0x1541372e59e8 <vtable for galera::TrxHandleMaster+16>, static TRXHANDLE_FLAGS_MASK = 33791, static EXPLICIT_ROLLBACK_FLAGS = 10, static FLAGS_MATCH_API_FLAGS = true, static num_states_ = 12, state_ = {delete_ = false, trans_map_ = 0x1541372eb620 <galera::TrxHandleMaster::trans_map_>, state_ = {
|
first = galera::TrxHandle::S_EXECUTING,
|
second = 0
|
}, state_hist_ = std::vector of length 0, capacity 0}, source_id_ = {data = "%\035S\250U\365\021\356\230(SU\267\230\024\230", alignment = 17154762203875974437}, conn_id_ = 18446744073709551615, trx_id_ = 20, timestamp_ = 1695022202956141567, version_ = 5, write_set_flags_ = 64, local_ = true, master_ = true}, static Defaults = {working_dir_ = ".", version_ = -1, key_format_ = galera::KeySet::FLAT16A, record_set_ver_ = gu::RecordSet::VER2, max_write_set_size_ = 0}, mutex_ = {value_ = {sys_mutex = pthread_mutex_t = {
|
Type = Normal,
|
Status = Acquired, possibly with no waiters,
|
Owner ID = 1687170,
|
Robust = No,
|
Shared = No,
|
Protocol = None
|
}, opaque = 0x0, opaque2 = 0x0, ts_mutex = 0x0}}, mem_pool_ = @0x55cd58cce318, static trans_map_ = {impl_ = std::unordered_set with 22 elements}, params_ = {working_dir_ = "/test/codership/GAL_MD150923-mariadb-10.6.16-linux-x86_64-opt/node1/", version_ = 5, key_format_ = galera::KeySet::FLAT8, record_set_ver_ = gu::RecordSet::VER2, max_write_set_size_ = 2147483647}, ts_ = {px = 0x0, pn = {pi_ = 0x0}}, wso_buf_size_ = 7912, gcs_handle_ = -1, wso_ = true, last_ts_seqno_ = -1, deferred_abort_ = false}, lock=@0x154101549b10: {trx_ = @0x1540a40177c0, locked_ = true}, trx_ctx=0x154101549d50) at /test/codership/galera_4x/galera/src/replicator_smm.cpp:1053
|
#6 0x0000154137095b9c in galera_replay_trx (gh=<optimized out>, trx_handle=<optimized out>, recv_ctx=0x154101549d50) at /test/codership/galera_4x/galera/src/wsrep_provider.cpp:339
|
#7 0x000055cd57a8d3fd in wsrep::wsrep_provider_v26::replay (this=<optimized out>, ws_handle=<optimized out>, reply_service=<optimized out>) at /test/codership/10.6_opt/wsrep-lib/src/wsrep_provider_v26.cpp:209
|
#8 0x000055cd57698aa0 in Wsrep_client_service::replay (this=0x1540a4006f80) at /test/codership/10.6_opt/wsrep-lib/include/wsrep/transaction.hpp:225
|
#9 0x000055cd57a8aa6a in wsrep::transaction::replay (this=0x1540a4007000, lock=@0x15410154a270: {_M_device = 0x1540a4006f60, _M_owns = false}) at /test/codership/10.6_opt/wsrep-lib/src/transaction.cpp:2047
|
#10 0x000055cd57a8afbd in wsrep::transaction::after_statement (this=this@entry=0x1540a4007000, lock=@0x15410154a270: {_M_device = 0x1540a4006f60, _M_owns = false}) at /test/codership/10.6_opt/wsrep-lib/src/transaction.cpp:882
|
#11 0x000055cd57a7106e in wsrep::client_state::after_statement (this=this@entry=0x1540a4006f98) at /test/codership/10.6_opt/wsrep-lib/src/client_state.cpp:265
|
#12 0x000055cd571f0874 in wsrep_after_statement (thd=0x1540a4000c58) at /test/codership/10.6_opt/sql/sql_class.h:5490
|
#13 wsrep_mysql_parse (thd=0x1540a4000c58, rawbuf=0x1540a4010700 "SET GLOBAL gtid_slave_pos= '1-2-3,2-4-6'", length=40, parser_state=0x15410154a3d0) at /test/codership/10.6_opt/sql/sql_parse.cc:7892
|
#14 0x000055cd571fe065 in dispatch_command (command=COM_QUERY, thd=0x1540a4000c58, packet=<optimized out>, packet_length=<optimized out>, blocking=<optimized out>) at /test/codership/10.6_opt/sql/sql_parse.cc:1981
|
#15 0x000055cd571fed3e in do_command (thd=0x1540a4000c58, blocking=blocking@entry=true) at /test/codership/10.6_opt/sql/sql_parse.cc:1409
|
#16 0x000055cd57308c17 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55cd58f509f8, put_in_cache=put_in_cache@entry=true) at /test/codership/10.6_opt/sql/sql_connect.cc:1416
|
#17 0x000055cd57308efd in handle_one_connection (arg=0x55cd58f509f8) at /test/codership/10.6_opt/sql/sql_connect.cc:1318
|
#18 0x0000154137b56609 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
#19 0x0000154137742133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
|
10.4.32 b3d287288c9d7e4d3c5dd1e9ae35de62ff57e8f9 (Debug) |
mysqld: /test/codership/10.4_dbg/wsrep-lib/src/transaction.cpp:449: int wsrep::transaction::before_commit(): Assertion `state() == s_executing || state() == s_prepared || state() == s_committing || state() == s_must_abort || state() == s_replaying' failed.
|
|
10.4.32 b3d287288c9d7e4d3c5dd1e9ae35de62ff57e8f9 (Debug) |
Core was generated by `/test/codership/GAL_MD180923-mariadb-10.4.32-linux-x86_64-dbg/bin/mysqld --defa'.
|
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 0x148d6c34e700 (LWP 2123548))]
|
(gdb) bt
|
#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
|
#1 0x000055ca4846ae5c in my_write_core (sig=sig@entry=6) at /test/codership/10.4_dbg/mysys/stacktrace.c:386
|
#2 0x000055ca47c789fa in handle_fatal_signal (sig=6) at /test/codership/10.4_dbg/sql/signal_handler.cc:372
|
#3 <signal handler called>
|
#4 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
|
#5 0x0000148da7f06859 in __GI_abort () at abort.c:79
|
#6 0x0000148da7f06729 in __assert_fail_base (fmt=0x148da809c588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x55ca48b16740 "state() == s_executing || state() == s_prepared || state() == s_committing || state() == s_must_abort || state() == s_replaying", file=0x55ca48b15328 "/test/codership/10.4_dbg/wsrep-lib/src/transaction.cpp", line=449, function=<optimized out>) at assert.c:92
|
#7 0x0000148da7f17fd6 in __GI___assert_fail (assertion=assertion@entry=0x55ca48b16740 "state() == s_executing || state() == s_prepared || state() == s_committing || state() == s_must_abort || state() == s_replaying", file=file@entry=0x55ca48b15328 "/test/codership/10.4_dbg/wsrep-lib/src/transaction.cpp", line=line@entry=449, function=function@entry=0x55ca48b166e0 "int wsrep::transaction::before_commit()") at assert.c:101
|
#8 0x000055ca485bfa9f in wsrep::transaction::before_commit (this=this@entry=0x148d24006e20) at /test/codership/10.4_dbg/wsrep-lib/src/transaction.cpp:535
|
#9 0x000055ca485a1614 in wsrep::client_state::before_commit (this=this@entry=0x148d24006db8) at /test/codership/10.4_dbg/wsrep-lib/src/client_state.cpp:389
|
#10 0x000055ca47c7dfff in wsrep_before_commit (all=false, thd=0x148d24000d28) at /test/codership/10.4_dbg/sql/sql_class.h:5041
|
#11 ha_commit_trans (thd=thd@entry=0x148d24000d28, all=all@entry=false) at /test/codership/10.4_dbg/sql/handler.cc:1614
|
#12 0x000055ca47b86acc in rpl_slave_state::record_gtid (this=this@entry=0x55ca4b098310, thd=thd@entry=0x148d24000d28, gtid=gtid@entry=0x148d6c34b8a0, sub_id=sub_id@entry=2, in_transaction=in_transaction@entry=false, in_statement=in_statement@entry=true, out_hton=0x148d6c34b898) at /test/codership/10.4_dbg/sql/rpl_gtid.cc:749
|
#13 0x000055ca47b8837b in rpl_slave_state::load (this=0x55ca4b098310, thd=thd@entry=0x148d24000d28, state_from_master=<optimized out>, len=<optimized out>, reset=reset@entry=true, in_statement=in_statement@entry=true) at /test/codership/10.4_dbg/sql/rpl_gtid.cc:1407
|
#14 0x000055ca47a286f4 in rpl_gtid_pos_update (thd=thd@entry=0x148d24000d28, str=<optimized out>, len=<optimized out>) at /test/codership/10.4_dbg/sql/sql_repl.cc:4728
|
#15 0x000055ca47b3b080 in Sys_var_gtid_slave_pos::global_update (this=<optimized out>, thd=0x148d24000d28, var=0x148d24012670) at /test/codership/10.4_dbg/sql/sys_vars.cc:1858
|
#16 0x000055ca4792d588 in sys_var::update (this=0x55ca48e97040 <Sys_gtid_slave_pos>, thd=0x148d24000d28, var=0x148d24012670) at /test/codership/10.4_dbg/sql/set_var.cc:208
|
#17 0x000055ca4792dacf in set_var::update (this=<optimized out>, thd=<optimized out>) at /test/codership/10.4_dbg/sql/set_var.cc:837
|
#18 0x000055ca4792ed4d in sql_set_variables (thd=thd@entry=0x148d24000d28, var_list=var_list@entry=0x148d24005a60, free=free@entry=true) at /test/codership/10.4_dbg/sql/set_var.cc:740
|
#19 0x000055ca479fe411 in mysql_execute_command (thd=thd@entry=0x148d24000d28) at /test/codership/10.4_dbg/sql/sql_parse.cc:5045
|
#20 0x000055ca47a04408 in mysql_parse (thd=thd@entry=0x148d24000d28, rawbuf=rawbuf@entry=0x148d240124c0 "SET GLOBAL gtid_slave_pos= '1-2-3,2-4-6'", length=length@entry=40, parser_state=parser_state@entry=0x148d6c34d3b0, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/codership/10.4_dbg/sql/sql_parse.cc:8010
|
#21 0x000055ca47a050eb in wsrep_mysql_parse (thd=thd@entry=0x148d24000d28, rawbuf=0x148d240124c0 "SET GLOBAL gtid_slave_pos= '1-2-3,2-4-6'", length=40, parser_state=parser_state@entry=0x148d6c34d3b0, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/codership/10.4_dbg/sql/sql_parse.cc:7812
|
#22 0x000055ca47a06fa8 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x148d24000d28, packet=packet@entry=0x148d24019599 "SET GLOBAL gtid_slave_pos= '1-2-3,2-4-6'", packet_length=packet_length@entry=40, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/codership/10.4_dbg/sql/sql_class.h:1231
|
#23 0x000055ca47a09819 in do_command (thd=0x148d24000d28) at /test/codership/10.4_dbg/sql/sql_parse.cc:1378
|
#24 0x000055ca47b281a2 in do_handle_one_connection (connect=<optimized out>) at /test/codership/10.4_dbg/sql/sql_connect.cc:1420
|
#25 0x000055ca47b2825e in handle_one_connection (arg=<optimized out>) at /test/codership/10.4_dbg/sql/sql_connect.cc:1324
|
#26 0x0000148da8417609 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
#27 0x0000148da8003133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
Attachments
Issue Links
- is caused by
-
-
- Confirmed
-
- relates to
-
-
- Closed
-
Activity
janlindstrom Debug build now crashes with different assertion when we enable wsrep_gtid_mode and log_bin
# mysqld options required for replay: --log_bin |
SET GLOBAL wsrep_gtid_mode=ON; |
SET GLOBAL gtid_slave_pos='1-1-1,2-2-2'; |
Leads to
|
10.5.27 d1dc70675c000fc5c6b38ce4456fd2faf56abaf0 (Debug) |
mysqld: /test/10.5_dbg/wsrep-lib/src/transaction.cpp:282: int wsrep::transaction::before_prepare(wsrep::unique_lock<wsrep::mutex>&): Assertion `state() == s_executing || state() == s_must_abort || state() == s_replaying' failed.
|
|
10.5.27 d1dc70675c000fc5c6b38ce4456fd2faf56abaf0 (Debug) |
Core was generated by `/test/GAL_MD040924-mariadb-10.5.27-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 0x148b241f9700 (LWP 3010959))]
|
(gdb) bt
|
#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
|
#1 0x0000559340d0df5f in my_write_core (sig=sig@entry=6) at /test/10.5_dbg/mysys/stacktrace.c:424
|
#2 0x0000559340554019 in handle_fatal_signal (sig=6) at /test/10.5_dbg/sql/signal_handler.cc:365
|
#3 <signal handler called>
|
#4 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
|
#5 0x0000148b75cc1859 in __GI_abort () at abort.c:79
|
#6 0x0000148b75cc1729 in __assert_fail_base (fmt=0x148b75e57588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x5593414472b0 "state() == s_executing || state() == s_must_abort || state() == s_replaying", file=0x5593414460e8 "/test/10.5_dbg/wsrep-lib/src/transaction.cpp", line=282, function=<optimized out>) at assert.c:92
|
#7 0x0000148b75cd2fd6 in __GI___assert_fail (assertion=assertion@entry=0x5593414472b0 "state() == s_executing || state() == s_must_abort || state() == s_replaying", file=file@entry=0x5593414460e8 "/test/10.5_dbg/wsrep-lib/src/transaction.cpp", line=line@entry=282, function=function@entry=0x559341447260 "int wsrep::transaction::before_prepare(wsrep::unique_lock<wsrep::mutex>&)") at assert.c:101
|
#8 0x0000559340ecf829 in wsrep::transaction::before_prepare (this=this@entry=0x148b040070c8, lock=@0x148b241f6930: {_M_device = 0x148b04007028, _M_owns = true}) at /test/10.5_dbg/wsrep-lib/src/transaction.cpp:389
|
#9 0x0000559340eb20f7 in wsrep::client_state::before_prepare (this=this@entry=0x148b04007060) at /test/10.5_dbg/wsrep-lib/src/client_state.cpp:373
|
#10 0x0000559340556c09 in wsrep_before_prepare (all=false, thd=0x148b04000d48) at /test/10.5_dbg/sql/sql_class.h:5325
|
#11 prepare_or_error (ht=ht@entry=0x559343d3bc18, thd=thd@entry=0x148b04000d48, all=all@entry=false) at /test/10.5_dbg/sql/handler.cc:1380
|
#12 0x000055934055a4d9 in ha_commit_trans (thd=thd@entry=0x148b04000d48, all=all@entry=false) at /test/10.5_dbg/sql/handler.cc:1831
|
#13 0x000055934045d658 in rpl_slave_state::record_gtid (this=this@entry=0x559343c902b0, thd=thd@entry=0x148b04000d48, gtid=gtid@entry=0x148b241f7ba0, sub_id=sub_id@entry=2, in_transaction=in_transaction@entry=false, in_statement=in_statement@entry=true, out_hton=0x148b241f7b98) at /test/10.5_dbg/sql/rpl_gtid.cc:756
|
#14 0x000055934045efed in rpl_slave_state::load (this=0x559343c902b0, thd=thd@entry=0x148b04000d48, state_from_master=<optimized out>, len=<optimized out>, reset=reset@entry=true, in_statement=in_statement@entry=true) at /test/10.5_dbg/sql/rpl_gtid.cc:1418
|
#15 0x00005593402cd967 in rpl_gtid_pos_update (thd=thd@entry=0x148b04000d48, str=<optimized out>, len=<optimized out>) at /test/10.5_dbg/sql/sql_repl.cc:4762
|
#16 0x00005593403fc7a0 in Sys_var_gtid_slave_pos::global_update (this=<optimized out>, thd=0x148b04000d48, var=0x148b04013020) at /test/10.5_dbg/sql/sys_vars.cc:1959
|
#17 0x00005593401c520a in sys_var::update (this=0x5593418018a0 <Sys_gtid_slave_pos>, thd=0x148b04000d48, var=0x148b04013020) at /test/10.5_dbg/sql/set_var.cc:207
|
#18 0x00005593401c5751 in set_var::update (this=<optimized out>, thd=<optimized out>) at /test/10.5_dbg/sql/set_var.cc:859
|
#19 0x00005593401c6a6f in sql_set_variables (thd=thd@entry=0x148b04000d48, var_list=var_list@entry=0x148b04005ca0, free=free@entry=true) at /test/10.5_dbg/sql/set_var.cc:746
|
#20 0x00005593402a9e74 in mysql_execute_command (thd=thd@entry=0x148b04000d48) at /test/10.5_dbg/sql/sql_parse.cc:5173
|
#21 0x0000559340293f5b in mysql_parse (thd=thd@entry=0x148b04000d48, rawbuf=rawbuf@entry=0x148b04012e70 "SET GLOBAL gtid_slave_pos='1-1-1,2-2-2'", length=length@entry=39, parser_state=parser_state@entry=0x148b241f8310, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.5_dbg/sql/sql_parse.cc:8236
|
#22 0x0000559340293842 in wsrep_mysql_parse (thd=thd@entry=0x148b04000d48, rawbuf=0x148b04012e70 "SET GLOBAL gtid_slave_pos='1-1-1,2-2-2'", length=39, parser_state=parser_state@entry=0x148b241f8310, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.5_dbg/sql/sql_parse.cc:8036
|
#23 0x00005593402a23f6 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x148b04000d48, packet=packet@entry=0x148b0400aac9 "SET GLOBAL gtid_slave_pos='1-1-1,2-2-2'", packet_length=packet_length@entry=39, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.5_dbg/sql/sql_class.h:1329
|
#24 0x00005593402a4d61 in do_command (thd=0x148b04000d48) at /test/10.5_dbg/sql/sql_parse.cc:1376
|
#25 0x00005593403e6be9 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x559344502d18, put_in_cache=put_in_cache@entry=true) at /test/10.5_dbg/sql/sql_connect.cc:1417
|
#26 0x00005593403e70ba in handle_one_connection (arg=0x559344502d18) at /test/10.5_dbg/sql/sql_connect.cc:1319
|
#27 0x0000148b761d2609 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
#28 0x0000148b75dbe133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
If you set gtid_strict_mode=1 you get error:
MariaDB [test]> SET GLOBAL gtid_slave_pos= '1-2-3,2-4-6';--------------SET GLOBAL gtid_slave_pos= '1-2-3,2-4-6'--------------ERROR 1948 (HY000): Specified value for @@gtid_slave_pos contains no value for replication domain 0. This conflicts with the binary log which contains GTID 0-15-42. If MASTER_GTID_POS=CURRENT_POS is used, the binlog position will override the new value of @@gtid_slave_pos