replication-manager icon indicating copy to clipboard operation
replication-manager copied to clipboard

Add new states for MariaDB Jira Blocker and Critical issues

Open caffeinated92 opened this issue 1 year ago • 5 comments

Caution! This will make the alert and prevent failover/switchover for JIRA blockers:

  1. https://jira.mariadb.org/browse/MDEV-28310

For better state checking, state from server will always have serverURL, and it will be added to list for same state. (previously it was ignored)

serverURL can be multiple : A:3306,B:3306,C:3306

caffeinated92 avatar Jul 09 '24 09:07 caffeinated92

image

caffeinated92 avatar Jul 15 '24 05:07 caffeinated92

The MariaDB version has bug in service for this version, source: https://jira.mariadb.org/browse/MDEV-31779 channel=StdOut cluster=fr code=MD031779 status=OPENED type=state

caffeinated92 avatar Jul 15 '24 05:07 caffeinated92

One can see that https://jira.mariadb.org/browse/MDEV-31779 is about having sequences in schema and the other critical one is having on duplicate key update

So my proposal was to have mdev-stopper.json where we {issue:"MDEV-31779", tags "sequences"} blabla blocker should block failover only if both version and tags match
In our case we would never block until we are able to detect workload cluster tags sequences , onduplicatekey

svaroqui avatar Jul 16 '24 17:07 svaroqui

Yes, currently MDEV list is only giving alert, only MDEV-28310 is blocker.

blockers := []string{
		"MDEV-28310",
	}

	for _, mdev := range blockers {
		if sl.MDevIssues.HasMdevBug(mdev) {
			return false
		}
	}

	return true

Need to check and adding configurator tags based on situation

caffeinated92 avatar Jul 17 '24 05:07 caffeinated92

On hold while focusing for finishing backups

caffeinated92 avatar Jul 17 '24 06:07 caffeinated92