Uploaded image for project: 'RHEL'
  1. RHEL
  2. RHEL-134709

[RFE] db2nkill to be part of db2_demote operation

Linking RHIVOS CVEs to...Migration: Automation ...SWIFT: POC ConversionSync from "Extern...XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Undefined Undefined
    • None
    • rhel-8.10, rhel-9.7.z
    • resource-agents
    • None
    • None
    • Low
    • rhel-ha
    • 8
    • False
    • False
    • Hide

      None

      Show
      None
    • None
    • None
    • None
    • None
    • Unspecified
    • Unspecified
    • Unspecified
    • None

      What were you trying to do that didn't work?

      db2 resource agent use flow for incident
       

      Incident (Failover/Migration)

      • Trigger: Monitor failure on Primary.
      • Sequence of Timeouts:

                   Demote (): Pacemaker tries db2 deactivate db.

                   Escalation to Stop (): Once the timeout expires, Pacemaker kills the demote action and issues a stop.

                   Fencing: If the stop fails after stop-timeout it will run db2nkill then (or completes), the node is fenced or the resource moves.

      IBM opinion on the topic :

      "db2stop force" - which does a deactivate which in turn drives log truncation and can cause the log streams to diverge - so in any automation driven event it would actually always be safer just to kill  e.g. through pkill or db2gcf -k.

      What is the impact of this issue to you?

      divergence in the log will cause inconsistency and customer will have to rebuild DB

      Please provide the package NVR for which the bug is seen:

      How reproducible is this bug?:

      Steps to reproduce

      1.  
      2.  
      3.  

      Expected results

      Actual results

              rhn-engineering-oalbrigt Oyvind Albrigtsen
              rh-ee-dmule Dhananjay Mule
              Oyvind Albrigtsen Oyvind Albrigtsen
              Cluster QE Cluster QE
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

                Created:
                Updated: