[MDEV-22730] MariaDB 10.4.12 Galera 4 version : Replication fails on Primary Nodes Created: 2020-05-27  Updated: 2023-05-22  Resolved: 2023-05-22

Status: Closed
Project: MariaDB Server
Component/s: Galera
Affects Version/s: 10.4
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Tarun Assignee: Jan Lindström
Resolution: Incomplete Votes: 0
Labels: None
Environment:

MariaDB 10.4.12 Galera 4 version



 Description   

MariaDB 10.4.12 using Galera 4.0 DR Replication environment.

Our Primary Advanved Node went down while Replicated nodes are UP . Below is the error found in MariaDB logs

[ERROR] WSREP: Process completed with error: wsrep_sst_rsync --role 'joiner' --address '10.16.128.45' --datadir '/opt/db/data/mysql/' --parent '11624' --mysqld-args --wsrep_start_position=be545277-9a89-11ea-9dcc-4255f8e635e4:31439572: 3 (No such process)
2020-05-27 2:17:47 0 [ERROR] WSREP: Failed to read uuid:seqno and wsrep_gtid_domain_id from joiner script.

2020-05-27 2:17:47 2 [ERROR] WSREP: Application received wrong state:
Received: 00000000-0000-0000-0000-000000000000
Required: be545277-9a89-11ea-9dcc-4255f8e635e4

2020-05-27 2:17:47 2 [ERROR] WSREP: Application state transfer failed. This is unrecoverable condition, restart required.

2020-05-27 2:17:47 0 [Note] WSREP: Joiner monitor thread ended with total time 2149 sec

2020-05-27 2:17:47 2 [Note] WSREP: /usr/sbin/mysqld: Terminated.



 Comments   
Comment by Tarun [ 2020-05-27 ]

I have tried to Bootstrap Primary node but this didn't work .

I have tried to reload daemon and enable MariaDB Service and tried to start MariaDB Service using

systemctl start mariadb command .

MariaDB Service fails with error and aborts on 1st Primary Node

MariaDB Service is running on 2nd and 3rd Replicated & Donor nodes

Comment by Jan Lindström [ 2023-04-20 ]

tarun I suggest to use more recent version of MariaDB and Galera library. If this problem reproduces I would need full error log and node configuration.

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