[MDEV-31413] Node has been dropped from the cluster on Startup / Shutdown with async replica Created: 2023-06-06  Updated: 2023-12-07  Resolved: 2023-11-13

Status: Closed
Project: MariaDB Server
Component/s: Galera
Affects Version/s: 10.4
Fix Version/s: 10.4.32, 10.10.7, 10.5.24, 10.6.17, 10.11.7, 11.0.5, 11.1.4, 11.2.3, 11.3.2, 11.4.1

Type: Bug Priority: Critical
Reporter: Jan Lindström Assignee: Julius Goryavsky
Resolution: Fixed Votes: 0
Labels: None
Environment:

CentOS


Issue Links:
Duplicate
Problem/Incident
causes MDEV-32780 galera_as_slave_replay: assertion in ... In Testing
Relates
relates to MDEV-32740 wsrep_gtid_domain_id is disregarded o... Closed

 Description   

 
2023-06-02 12:40:14 14 [Note] Slave I/O thread: Start asynchronous replication to master 'root@127.0.0.1:1600
0' in log 'mysqld-bin.000002' at position 4
2023-06-02 12:40:14 15 [Note] Slave SQL thread initialized, starting replication in log 'mysqld-bin.000002' a
t position 4, relay log './mysqld-relay-bin.000001' position: 4; GTID position ''
2023-06-02 12:40:14 0 [Note] /home/jan/work/mariadb/10.5e/sql/mysqld: ready for connections.
Version: '10.4.29-20-MariaDB-debug-log'  socket: '/home/jan/work/mariadb/10.5e/mysql-test/var/tmp/mysqld.4.so
ck'  port: 16003  Source distribution
2023-06-02 12:40:14 14 [Note] Slave I/O thread: connected to master 'root@127.0.0.1:16000',replication starts
 at GTID position ''
2023-06-02 12:40:14 15 [ERROR] Slave SQL: Error 'WSREP has not yet prepared node for application use' on quer
y. Default database: 'test'. Query: 'CREATE TABLE t1 (id bigint primary key, msg varchar(100)) engine=innodb'
, Gtid 1-1-1, Internal MariaDB error code: 1047
2023-06-02 12:40:14 15 [ERROR] Slave SQL: Node has dropped from cluster, Gtid 1-1-1, Internal MariaDB error c
ode: 1047



 Comments   
Comment by Jan Lindström [ 2023-07-10 ]

https://github.com/MariaDB/server/pull/2691

Comment by Julius Goryavsky [ 2023-08-08 ]

Fix merged with head revision: https://github.com/MariaDB/server/commit/277968aa4cfa46a290af1c44e9d756381005939a

Comment by Sergei Golubchik [ 2023-11-10 ]

10.5+ need a different fix. And the test case has to be run in buildbot

Comment by Julius Goryavsky [ 2023-11-13 ]

Added additional fix for 10.5+ https://github.com/MariaDB/server/commit/c3fdfbdbd82c43f867ed82232e3b3077c485c5e1

Generated at Thu Feb 08 10:23:41 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.