[Bug 1896223] Re: no-quorum-policy=demote and on-fail=demote features for MSSQL servers
This bug was fixed in the package pacemaker - 2.0.3-3ubuntu4.3 --- pacemaker (2.0.3-3ubuntu4.3) focal; urgency=medium [ Rafael David Tinoco ] * Post 2.0.3 features: on-fail=demote & no-quorum-policy=demote (LP: #1896223). Added debian/patches/ubuntu-2.0.3-demote/*: - lp1896223-01-f1f71b3-Refactor-scheduler-functionize-comparing-on-fail.patch - lp1896223-02-ef246ff-Fix-scheduler-disallow-on-fail-stop-for-stop.patch - lp1896223-03-8dceba7-Refactor-scheduler-use-more-appropriate-types.patch - lp1896223-04-a4d6a20-Low-libpacemaker-don-t-force-stop-when-skipping.patch - lp1896223-05-98c3b64-Log-libpacemaker-check-for-re-promotes-specifically.patch - lp1896223-06-2f1e2df-Feature-xml-add-on-fail-demote-option-to-resources.patch - lp1896223-07-874f75e-Feature-scheduler-new-on-fail-demote-recovery-policy.patch - lp1896223-08-7eec572-Build-libcrmcommon-bump-CRM-feature-set.patch - lp1896223-09-204961e-Doc-Pacemaker-Explained-document-new-on-fail.patch - lp1896223-10-015b5c0-Doc-Pacemaker-Explained-document-no-quorum.patch - lp1896223-11-0b68344-Refactor-scheduler-functionize-checking-quorum.patch - lp1896223-12-b1ae359-Feature-scheduler-support-demote-choice-for.patch - lp1896223-13-d4b9117-Doc-Pacemaker-Explained-correct-on-fail-default.patch -- Lucas Kanashiro Wed, 09 Dec 2020 10:27:00 -0300 ** Changed in: pacemaker (Ubuntu Focal) Status: Fix Committed => Fix Released -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1896223 Title: no-quorum-policy=demote and on-fail=demote features for MSSQL servers To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/pacemaker/+bug/1896223/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1896223] Re: no-quorum-policy=demote and on-fail=demote features for MSSQL servers
Tejas successfully verified 2.0.3-3ubuntu4.3. Attached is a trimmed pacemaker log which shows SQL in action on how it uses the demote feature successfully avoiding fencing while promoting a new node. ** Attachment added: "trimmedpacemaker.log" https://bugs.launchpad.net/ubuntu/+source/pacemaker/+bug/1896223/+attachment/5509129/+files/trimmedpacemaker.log ** Tags removed: verification-needed verification-needed-focal ** Tags added: verification-done verification-done-focal -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1896223 Title: no-quorum-policy=demote and on-fail=demote features for MSSQL servers To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/pacemaker/+bug/1896223/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1896223] Re: no-quorum-policy=demote and on-fail=demote features for MSSQL servers
Hello Rafael, or anyone else affected, Accepted pacemaker into focal-proposed. The package will build now and be available at https://launchpad.net/ubuntu/+source/pacemaker/2.0.3-3ubuntu4.3 in a few hours, and then in the -proposed repository. Please help us by testing this new package. See https://wiki.ubuntu.com/Testing/EnableProposed for documentation on how to enable and use -proposed. Your feedback will aid us getting this update out to other Ubuntu users. If this package fixes the bug for you, please add a comment to this bug, mentioning the version of the package you tested, what testing has been performed on the package and change the tag from verification-needed- focal to verification-done-focal. If it does not fix the bug for you, please add a comment stating that, and change the tag to verification- failed-focal. In either case, without details of your testing we will not be able to proceed. Further information regarding the verification process can be found at https://wiki.ubuntu.com/QATeam/PerformingSRUVerification . Thank you in advance for helping! N.B. The updated package will be released to -updates after the bug(s) fixed by this package have been verified and the package has been in -proposed for a minimum of 7 days. ** Changed in: pacemaker (Ubuntu Focal) Status: In Progress => Fix Committed ** Tags added: verification-needed verification-needed-focal -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1896223 Title: no-quorum-policy=demote and on-fail=demote features for MSSQL servers To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/pacemaker/+bug/1896223/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1896223] Re: no-quorum-policy=demote and on-fail=demote features for MSSQL servers
Thank you for working on this. This new pacemaker feature does sound like a worthwhile addition. However, I think there's a policy question of whether it is acceptable to add this in a stable Ubuntu release. I don't think we've done something like this before for this category of package. I appreciate that it'd be a new opt-in feature that shouldn't change behaviour for existing users. However, there's still a regression risk and users who don't want the feature will nevertheless have no choice but to receive the update. We need to decide whether this fits user expectations about our LTS releases. I believe this would be a policy decision that's already delegated by the technical board to the SRU team. I'll consult with other SRU team members to make this decision. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1896223 Title: no-quorum-policy=demote and on-fail=demote features for MSSQL servers To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/pacemaker/+bug/1896223/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1896223] Re: no-quorum-policy=demote and on-fail=demote features for MSSQL servers
** Description changed: [Impact] - This feature allows the use of other mechanisms to deal with failures. + This feature allows the use of other mechanisms to deal with failures instead of fencing nodes (usually reboot a machine), and let for instance MS SQL server handle some failures by itself. We can consider this SRU as part of a "hardware enablement" for MS SQL Server. [Test Plan] Set up a Corosync/Pacemaker cluster and configure a resource to manage MS SQL server and use the new policies. Check if the cluster loose the minimum quorum or if the node where the failure happens are not fenced but just demoted. [Where problems could occur] This SRU will be introducing some new actions when a node fails or if the minimum quorum of the cluster is not reached, those are new features. So no regression is expected. But if it occurs it would be related to the schedule of actions when a failure happens and the quorum is not reached. [Original description] Ubuntu Release Team: This is a FFe for this feature. Despite the size of patches, the core changes are not so big. Most of the commits are documentation OR tests for this new feature. Nevertheless, I preferred to be conservative and I have fully run all "CTS" (cluster test suite) with this new proposed package and it seems that everything is fine (no known regressions were caused, functional tests were good). With that in mind, I ask you to please approve this FFe. The management burden will be on Ubuntu Server team. In bug: https://bugs.launchpad.net/ubuntu/+source/pacemaker/+bug/1895883 I did the stabilization patches for pacemaker 2.0.4.. and I did not merge this feature so it could have its own FFe (this bug). The following patch-set: * this is the no-quorum-policy feature microsoft needs for mssqlserver |\ | * c4429d86e - Log: scheduler: downgrade "active on" messages to trace (3 mont | * 7eec572db - Build: libcrmcommon: bump CRM feature set (3 months ago) https://bugs.launchpad.net/bugs/1896223 Title: no-quorum-policy=demote and on-fail=demote features for MSSQL servers To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/pacemaker/+bug/1896223/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1896223] Re: no-quorum-policy=demote and on-fail=demote features for MSSQL servers
** Description changed: + [Impact] + + This feature allows the use of other mechanisms to deal with failures. + instead of fencing nodes (usually reboot a machine), and let for + instance MS SQL server handle some failures by itself. We can consider + this SRU as part of a "hardware enablement" for MS SQL Server. + + [Test Plan] + + Set up a Corosync/Pacemaker cluster and configure a resource to manage + MS SQL server and use the new policies. Check if the cluster loose the + minimum quorum or if the node where the failure happens are not fenced + but just demoted. + + [Where problems could occur] + + This SRU will be introducing some new actions when a node fails or if + the minimum quorum of the cluster is not reached, those are new + features. So no regression is expected. But if it occurs it would be + related to the schedule of actions when a failure happens and the quorum + is not reached. + + [Original description] + Ubuntu Release Team: This is a FFe for this feature. Despite the size of patches, the core changes are not so big. Most of the commits are documentation OR tests for this new feature. Nevertheless, I preferred to be conservative and I have fully run all "CTS" (cluster test suite) with this new proposed package and it seems that everything is fine (no known regressions were caused, functional tests were good). With that in mind, I ask you to please approve this FFe. The management burden will be on Ubuntu Server team. In bug: https://bugs.launchpad.net/ubuntu/+source/pacemaker/+bug/1895883 I did the stabilization patches for pacemaker 2.0.4.. and I did not merge this feature so it could have its own FFe (this bug). The following patch-set: * this is the no-quorum-policy feature microsoft needs for mssqlserver |\ | * c4429d86e - Log: scheduler: downgrade "active on" messages to trace (3 mont | * 7eec572db - Build: libcrmcommon: bump CRM feature set (3 months ago) https://bugs.launchpad.net/bugs/1896223 Title: no-quorum-policy=demote and on-fail=demote features for MSSQL servers To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/pacemaker/+bug/1896223/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1896223] Re: no-quorum-policy=demote and on-fail=demote features for MSSQL servers
FWIW here you can find the proposed package targeting Focal for testing: https://launchpad.net/~lucaskanashiro/+archive/ubuntu/pacemaker-sql- server -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1896223 Title: no-quorum-policy=demote and on-fail=demote features for MSSQL servers To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/pacemaker/+bug/1896223/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1896223] Re: no-quorum-policy=demote and on-fail=demote features for MSSQL servers
** Merge proposal unlinked: https://code.launchpad.net/~lucaskanashiro/ubuntu/+source/pacemaker/+git/pacemaker/+merge/396607 -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1896223 Title: no-quorum-policy=demote and on-fail=demote features for MSSQL servers To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/pacemaker/+bug/1896223/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1896223] Re: no-quorum-policy=demote and on-fail=demote features for MSSQL servers
** Merge proposal linked: https://code.launchpad.net/~lucaskanashiro/ubuntu/+source/pacemaker/+git/pacemaker/+merge/396607 -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1896223 Title: no-quorum-policy=demote and on-fail=demote features for MSSQL servers To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/pacemaker/+bug/1896223/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1896223] Re: no-quorum-policy=demote and on-fail=demote features for MSSQL servers
** Merge proposal linked: https://code.launchpad.net/~lucaskanashiro/ubuntu/+source/pacemaker/+git/pacemaker/+merge/395032 -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1896223 Title: no-quorum-policy=demote and on-fail=demote features for MSSQL servers To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/pacemaker/+bug/1896223/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1896223] Re: no-quorum-policy=demote and on-fail=demote features for MSSQL servers
** Merge proposal linked: https://code.launchpad.net/~rafaeldtinoco/ubuntu/+source/pacemaker/+git/pacemaker/+merge/392511 -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1896223 Title: no-quorum-policy=demote and on-fail=demote features for MSSQL servers To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/pacemaker/+bug/1896223/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1896223] Re: no-quorum-policy=demote and on-fail=demote features for MSSQL servers
** Merge proposal linked: https://code.launchpad.net/~rafaeldtinoco/ubuntu/+source/pacemaker/+git/pacemaker/+merge/392509 ** Merge proposal linked: https://code.launchpad.net/~rafaeldtinoco/ubuntu/+source/pacemaker/+git/pacemaker/+merge/392510 -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1896223 Title: no-quorum-policy=demote and on-fail=demote features for MSSQL servers To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/pacemaker/+bug/1896223/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1896223] Re: no-quorum-policy=demote and on-fail=demote features for MSSQL servers
** Merge proposal linked: https://code.launchpad.net/~rafaeldtinoco/ubuntu/+source/pacemaker/+git/pacemaker/+merge/392508 -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1896223 Title: no-quorum-policy=demote and on-fail=demote features for MSSQL servers To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/pacemaker/+bug/1896223/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1896223] Re: no-quorum-policy=demote and on-fail=demote features for MSSQL servers
** Merge proposal linked: https://code.launchpad.net/~rafaeldtinoco/ubuntu/+source/pacemaker/+git/pacemaker/+merge/391859 -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1896223 Title: no-quorum-policy=demote and on-fail=demote features for MSSQL servers To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/pacemaker/+bug/1896223/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1896223] Re: no-quorum-policy=demote and on-fail=demote features for MSSQL servers
I had to do a new MP for LP: #1881762 (a more minimal approach) and, with that, I'll need to rebase this one (and probably re-think it based on conversations for that SRU). Doing that... -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1896223 Title: no-quorum-policy=demote and on-fail=demote features for MSSQL servers To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/pacemaker/+bug/1896223/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1896223] Re: no-quorum-policy=demote and on-fail=demote features for MSSQL servers
I have just proposed a merge at: https://code.launchpad.net/~rafaeldtinoco/ubuntu/+source/pacemaker/+git/pacemaker/+merge/391596 but first I need the SRU on: https://bugs.launchpad.net/ubuntu/+source/pacemaker/+bug/1881762 to be accepted, so I can move with this feature merge. Will run functional/regression tests against this merge request and inform there. ** Changed in: pacemaker (Ubuntu Focal) Importance: Wishlist => Undecided ** Changed in: pacemaker (Ubuntu Focal) Status: New => In Progress -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1896223 Title: no-quorum-policy=demote and on-fail=demote features for MSSQL servers To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/pacemaker/+bug/1896223/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1896223] Re: no-quorum-policy=demote and on-fail=demote features for MSSQL servers
** Merge proposal linked: https://code.launchpad.net/~rafaeldtinoco/ubuntu/+source/pacemaker/+git/pacemaker/+merge/391596 -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1896223 Title: no-quorum-policy=demote and on-fail=demote features for MSSQL servers To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/pacemaker/+bug/1896223/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1896223] Re: no-quorum-policy=demote and on-fail=demote features for MSSQL servers
This bug was fixed in the package pacemaker - 2.0.4-2ubuntu3 --- pacemaker (2.0.4-2ubuntu3) groovy; urgency=medium * Post 2.0.4 features: on-fail=demote & no-quorum-policy=demote (LP: #1896223). Added debian/patches/ubuntu/lp1896223-*: - [c4429d86e] Log: scheduler: downgrade "active on" messages to trace - [01c5ec67e] Low: scheduler: match initial no-quorum-policy struct value - [015b5c012] Doc: Pacemaker Explained: document no-quorum-policy=demote - [5d809e136] Test: scheduler: add regression test - [b1ae35938] Feature: scheduler: support "demote" choice - [0b6834453] Refactor: scheduler: functionize checking quorum policy - [d4b9117e7] Doc: Pacemaker Explained: correct on-fail default - [204961e95] Doc: Pacemaker Explained: document new on-fail="demote" - [d29433ea5] Test: scheduler: add regression tests for on-fail="demote" - [874f75e0f] Feature: scheduler: new on-fail="demote" recovery policy - [2f1e2df1f] Feature: xml: add on-fail="demote" option to resources - [fd55a6660] Doc: libpacemaker: improve comments for resource state - [98c3b649f] Log: libpacemaker: check for re-promotes specifically - [ff6aebecf] Doc: libpacemaker: improve comments when logging actions - [f2d244bc4] Test: scheduler: test forcing a restart instead of reload - [a4d6a20a9] Low: libpacemaker: don't force stop when skipping reload - [8dceba792] Refactor: scheduler: use more appropriate types in a couple - [ef246ff05] Fix: scheduler: disallow on-fail=stop for stop operations - [f1f71b3f3] Refactor: scheduler: functionize comparing on-fail values -- Rafael David Tinoco Tue, 22 Sep 2020 17:51:03 + ** Changed in: pacemaker (Ubuntu) Status: Fix Committed => Fix Released -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1896223 Title: no-quorum-policy=demote and on-fail=demote features for MSSQL servers To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/pacemaker/+bug/1896223/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1896223] Re: no-quorum-policy=demote and on-fail=demote features for MSSQL servers
** Changed in: pacemaker (Ubuntu) Status: Triaged => Fix Committed ** Changed in: pacemaker (Ubuntu) Importance: High => Undecided -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1896223 Title: no-quorum-policy=demote and on-fail=demote features for MSSQL servers To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/pacemaker/+bug/1896223/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1896223] Re: no-quorum-policy=demote and on-fail=demote features for MSSQL servers
FFe approved. ** Changed in: pacemaker (Ubuntu) Status: New => Triaged -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1896223 Title: no-quorum-policy=demote and on-fail=demote features for MSSQL servers To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/pacemaker/+bug/1896223/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1896223] Re: no-quorum-policy=demote and on-fail=demote features for MSSQL servers
** Summary changed: - [FFe] no-quorum-policy=demote and on-fail=demote features for MSSQL servers + no-quorum-policy=demote and on-fail=demote features for MSSQL servers -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1896223 Title: no-quorum-policy=demote and on-fail=demote features for MSSQL servers To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/pacemaker/+bug/1896223/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs