Uploaded image for project: 'Ranger'
  1. Ranger
  2. RANGER-1173

Improve Ranger database schema import logic and make it more robust

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 0.5.0, 0.6.0, 0.7.0, 0.6.1
    • Fix Version/s: 0.7.0, 0.6.2
    • Component/s: Ranger
    • Labels:
      None

      Description

      Problem Statement: Ranger installation process should handle concurrent import of DB schema as concurrent execution of db schema files can lead to an inconsistent state of data and application.

      Proposed Solution : Before importing db schema file; installation process will insert status in x_db_version_h table with active='N' value. If schema will get created/imported successfully then status of the schema creation flag will be set to 'Y' else status row from x_db_version_h will be deleted. If the Ranger DB schema is being imported then the active column will have the value 'N' and no other process will be allowed to import that file.

        Attachments

        1. RANGER-1173-2.patch
          118 kB
          Pradeep Agrawal

          Issue Links

            Activity

              People

              • Assignee:
                pradeep Pradeep Agrawal
                Reporter:
                pradeep Pradeep Agrawal
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: