Project

General

Profile

Actions
Copy link

tickets #123816

closed

ipx-galera1.i.o.o: mysql didn't survive reboot after zypper patch

Added by cboltz about 1 year ago. Updated about 1 year ago.

Status:
Resolved
Priority:
Normal
Assignee:
crameleon
Category:
-
Target version:
-
Start date:
2023-01-31
Due date:
% Done:

100%

Estimated time:

Description

mysql on ipx-galera1.i.o.o didn't survive reboot after zypper patch. It tries to start, but aborts with the following lines in /v/l/mysql/mysqld.log:

2023-01-30 20:28:15 0 [Note] WSREP: Service thread queue flushed.
2023-01-30 20:28:15 0 [Note] WSREP: ####### Assign initial position for certification: 9c23f078-1a8e-11ed-845f-139ad8ee3548:32509586, protocol version: -1
2023-01-30 20:28:15 0 [Note] WSREP: Start replication
2023-01-30 20:28:15 0 [Note] WSREP: Connecting with bootstrap option: 1
2023-01-30 20:28:15 0 [Note] WSREP: Setting GCS initial position to 9c23f078-1a8e-11ed-845f-139ad8ee3548:32509586
2023-01-30 20:28:15 0 [ERROR] WSREP: It may not be safe to bootstrap the cluster from this node. It was not the last one to leave the cluster and may not contain all the updates. To force cluster bootstrap with this node, edit the grastate.dat file manually and set safe_to_bootstrap to 1 .
2023-01-30 20:28:15 0 [ERROR] WSREP: wsrep::connect(gcomm://) failed: 7
2023-01-30 20:28:15 0 [ERROR] Aborting

I'm a bit confused to see "bootstrap" - I'd expect that it joins the existing ipx-galera{2,3} cluster after the reboot.

(ipx-galera2 and 3 still need their kernel update - but only after this issue is fixed.)

Actions
Copy link
 #1

Updated by cboltz about 1 year ago

  • Private changed from Yes to No
Actions
Copy link
 #2

Updated by crameleon about 1 year ago

  • Status changed from New to In Progress
Actions
Copy link
 #3

Updated by crameleon about 1 year ago

  • Status changed from In Progress to Resolved
  • % Done changed from 0 to 100

/etc/my.cnf.d/50-galera.conf had this:

#wsrep_cluster_address='gcomm://ipx-galera3.infra.opensuse.org,ipx-galera2.infra.opensuse.org,ipx-galera1.infra.opensuse.org'
wsrep_cluster_address='gcomm://'
wsrep-new-cluster

changed to:

wsrep_cluster_address='gcomm://ipx-galera3.infra.opensuse.org,ipx-galera2.infra.opensuse.org,ipx-galera1.infra.opensuse.org'
#wsrep_cluster_address='gcomm://'
#wsrep-new-cluster

this should have been done after the first cluster bootstrap, I guess someone forgot.

Actions
Copy link
 #4

Updated by cboltz about 1 year ago

Thanks!

The other ipx-galera*.i.o.o now also got their kernel update :-)

Actions
Copy link

Also available in: Atom PDF