[MDEV-8216] Galera cluster frequently crashes with exception Created: 2015-05-23  Updated: 2016-11-02  Resolved: 2016-11-02

Status: Closed
Project: MariaDB Server
Component/s: Galera
Affects Version/s: 5.5.41-galera
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Mark Winterbottom Assignee: Nirbhay Choubey (Inactive)
Resolution: Incomplete Votes: 0
Labels: None


 Description   

Hello,

I am running two MariaDB servers, clustered using Galera. After upgrading to `5.5.41-MariaDB-1~wheezy-wsrep-log` I am having the following issue:

  • The database nodes will become unreachable with the error `WSREP has not yet prepared node for application use`.
  • This will occur approximately every 3 - 4 hours despite very low load on the servers.
  • Sometimes they come back online after 10 - 15 minutes, sometimes they crash until I reboot both nodes in the cluster.

In the syslog at the exact time the server becomes unavailable, I see this error:

May 22 22:54:56 dbserver-uk mysqld:  }150522 22:54:56 [ERROR] WSREP: exception from gcomm, backend must be restarted: f0af4e14-0053-11e5-9aec-2a044cd57fd7Install message self state does not match, message state: prim=0,un=0,last_seq=2,last_prim=view_id(PRIM,f0af4e14-0053-11e5-9aec-2a044cd57fd7,94),to_seq=375297,weight=1,segment=0, local state: prim=0,un=1,last_seq=2,last_prim=view_id(PRIM,f0af4e14-0053-11e5-9aec-2a044cd57fd7,94),to_seq=375297,weight=1,segment=0 (FATAL)

I am running both nodes on Debian 7 with the latest packages. Please let me know if there is any more information I can apply.



 Comments   
Comment by Nirbhay Choubey (Inactive) [ 2015-05-23 ]

5.5.41-galera uses a relatively older galera library version (3.6). The later versions have 3.9. Can you try upgrading MariaDB and see if you still experience this issue?

Generated at Thu Feb 08 07:25:30 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.