[MDEV-27839]  Assertion `thd_killed(thd) || !m_active_tranxs || !m_active_tranxs->is_tranx_end_pos(trx_wait_binlog_name, trx_wait_binlog_pos)' failed in Repl_semi_sync_master::commit_trx Created: 2022-02-14  Updated: 2023-03-03

Status: Open
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.5, 10.6, 10.7
Fix Version/s: 10.5, 10.6

Type: Bug Priority: Major
Reporter: Alice Sherepa Assignee: Andrei Elkin
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-24118 rpl.rpl_semi_sync failed in bb, Asser... Open
relates to MDEV-24120 Assertion `thd_killed(current_thd) ||... Confirmed

 Description   

 
--source include/have_innodb.inc
--source include/master-slave.inc
 
--connection master
RESET MASTER;
SET @@GLOBAL.rpl_semi_sync_master_enabled = 1;
 
--connection slave
source include/stop_slave.inc;
SET @@GLOBAL.rpl_semi_sync_slave_enabled = 1;
source include/start_slave.inc;
 
connection master;
 
CREATE TABLE t1 (a INT, b INT);
CREATE TABLE t2 LIKE t1;
CREATE TABLE t3 LIKE t1;
DROP TABLE t1,t2,t3;
sync_slave_with_master;
 
STOP SLAVE;
--source include/wait_for_slave_to_stop.inc
START SLAVE;
--source include/wait_for_slave_to_start.inc
 
--source include/rpl_reset.inc
 
connection master;
 
CREATE TABLE t1 (a INT);
INSERT INTO t1 VALUES (1),(2),(3);
CREATE TABLE t2 SELECT * FROM t1;

10.5 52b32c60c26b512ccf9b

mariadbd: 10.5/src/sql/semisync_master.cc:929: int Repl_semi_sync_master::commit_trx(const char*, my_off_t): Assertion `thd_killed(thd) || !m_active_tranxs || !m_active_tranxs->is_tranx_end_pos(trx_wait_binlog_name, trx_wait_binlog_pos)' failed.
220214 17:58:36 [ERROR] mysqld got signal 6 ;
 
Server version: 10.5.16-MariaDB-debug-log
 
sql/signal_handler.cc:225(handle_fatal_signal)[0x55bf05fa8f83]
sigaction.c:0(__restore_rt)[0x7f873862f3c0]
??:0(gsignal)[0x7f873811a18b]
??:0(abort)[0x7f87380f9859]
/lib/x86_64-linux-gnu/libc.so.6(+0x25729)[0x7f87380f9729]
??:0(__assert_fail)[0x7f873810af36]
sql/semisync_master.cc:807(Repl_semi_sync_master::commit_trx(char const*, unsigned long long))[0x55bf05d35554]
sql/semisync_master.cc:699(Repl_semi_sync_master::wait_after_commit(THD*, bool))[0x55bf05d343db]
sql/handler.cc:1834(ha_commit_trans(THD*, bool))[0x55bf05fb8076]
sql/transaction.cc:472(trans_commit_stmt(THD*))[0x55bf05c15db1]
sql/sql_parse.cc:6117(mysql_execute_command(THD*))[0x55bf057a71aa]
sql/sql_parse.cc:8100(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55bf057b41c0]
sql/sql_parse.cc:1894(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55bf0578a07b]
sql/sql_parse.cc:1370(do_command(THD*))[0x55bf057869ba]
sql/sql_connect.cc:1418(do_handle_one_connection(CONNECT*, bool))[0x55bf05bd2a8f]
sql/sql_connect.cc:1314(handle_one_connection)[0x55bf05bd22a8]
perfschema/pfs.cc:2203(pfs_spawn_thread)[0x55bf068f573e]
nptl/pthread_create.c:478(start_thread)[0x7f8738623609]
??:0(clone)[0x7f87381f6293]
 
Query (0x62b0000f52a8): INSERT INTO t1 VALUES (1),(2),(3)


Generated at Thu Feb 08 09:55:58 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.