Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-2153

dont allow system to start up if DBROOT 1 is not assigned to ACTIVE PARENT PM

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 1.2.2
    • 1.2.6, 1.4.4
    • None
    • None
    • 2um 2pm external memory
    • 2020-3, 2020-4, 2020-5, 2020-6, 2020-7

    Description

      Customer had an issue where PM1 failed and DBROOT 1 got assigned to PM2. PM2 had DBROOT 1 and 2 assigned to it and PM2 was the ACTIVE PARENT PM.. When PM1 was fixed, customer moved DBROOT 1 back to PM1, which was the incorrect process to do. DBROOT 2 should have been moved to PM1. The ACTIVE PARENT should always have DBROOT 1 assigned since it contains the DBRM files.
      A startsystem was performed which lead to the deletion of the DBRM files because of the incorrect assignment.

      The startsystem needs to check that DBROOT 1 is correctly assigned before allow a startsystem to run.

      Attachments

        Activity

          I cannot manually move dbroot1 if you can find a way to do this and reproduce let me know. Otherwise I think we can close this.

          ben.thompson Ben Thompson (Inactive) added a comment - I cannot manually move dbroot1 if you can find a way to do this and reproduce let me know. Otherwise I think we can close this.

          The state where a failed restoral leaving a PM without a dbroot assigned should no longer be reachable with failover fixes from another issue. mcsadmin also block manually moving dbroot1.

          ben.thompson Ben Thompson (Inactive) added a comment - The state where a failed restoral leaving a PM without a dbroot assigned should no longer be reachable with failover fixes from another issue. mcsadmin also block manually moving dbroot1.

          This is how they moved dbroot 1, they used the unassign and assign. That is why I opened this issue

          https://jira.mariadb.org/browse/MCOL-2164

          hill David Hill (Inactive) added a comment - This is how they moved dbroot 1, they used the unassign and assign. That is why I opened this issue https://jira.mariadb.org/browse/MCOL-2164

          People

            ben.thompson Ben Thompson (Inactive)
            hill David Hill (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.