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

Remove unnecessary variable and RPM requirements for read-scale clusters

    • ansible-collection-microsoft-sql-2.2.0-1.el9
    • sst_system_roles
    • None
    • QE ack, Dev ack
    • False
    • Hide

      None

      Show
      None
    • Yes
    • None
    • Bug Fix
    • Hide
      .Running read-scale clusters and installing `mssql-server-ha` no longer requires certain variables

      Previously, if you used the `mssql` RHEL System Role to configure a read-scale cluster without certain variables (`mssql_ha_virtual_ip`, `mssql_ha_login`, `mssql_ha_login_password`, and `mssql_ha_cluster_run_role`), the role failed with an error message “Variable not defined”. However, these variables are not necessary to run a read-scale cluster. The role also tried to install the `mssql-server-ha`, which is not required for a read-scale cluster.
      With this fix, the requirement for these variables was removed. As a result, running a read-scale cluster proceeds successfully without the error message.
      Show
      .Running read-scale clusters and installing `mssql-server-ha` no longer requires certain variables Previously, if you used the `mssql` RHEL System Role to configure a read-scale cluster without certain variables (`mssql_ha_virtual_ip`, `mssql_ha_login`, `mssql_ha_login_password`, and `mssql_ha_cluster_run_role`), the role failed with an error message “Variable not defined”. However, these variables are not necessary to run a read-scale cluster. The role also tried to install the `mssql-server-ha`, which is not required for a read-scale cluster. With this fix, the requirement for these variables was removed. As a result, running a read-scale cluster proceeds successfully without the error message.
    • Done
    • None

      Enhancement: Remove unnecessary variable requirements for read-scale clusters

      Reason: Read-scale clusters do not require creating users for Pacemaker and installing the `mssql-server-ha` package.

      Result: This remove a requirement for unnecessary variables when running a read-scale cluster and requirement to install the `mssql-server-ha`, which depends on packages from HA repository.

      Please provide the package NVR for which bug is seen:

      ansible-collection-microsoft-sql-2.0.1-1.el8

      How reproducible: Always

      Steps to reproduce

      • hosts: all
        vars:
        mssql_accept_microsoft_odbc_driver_17_for_sql_server_eula: true
        mssql_accept_microsoft_cli_utilities_for_sql_server_eula: true
        mssql_accept_microsoft_sql_server_standard_eula: true
        mssql_version: 2022
        mssql_password: "LS1setup!"
        mssql_edition: Developer
        mssql_manage_firewall: true
        mssql_ha_configure: true
        mssql_ha_ag_cluster_type: external
        mssql_ha_endpoint_port: 5022
        mssql_ha_cert_name: ExampleCert
        mssql_ha_master_key_password: "p@55w0rD1"
        mssql_ha_private_key_password: "p@55w0rD1"
        mssql_ha_reset_cert: false
        mssql_ha_endpoint_name: Mirroring_Endpoint
        mssql_ha_ag_name: AG1
        roles:
          - microsoft.sql.server

      Expected results

      The role finishes without trying to install mssql-server-ha

      Actual results

      TASK [microsoft.sql.server : Ensure the package mssql-server-ha] *********************************************************************************************************************************************

      skipping: [rhel2test]

      skipping: [rhelqs]

      fatal: [rhel1test]: FAILED! => {"changed": false, "failures": [], "msg": "Depsolve Error occured: \n Problem: cannot install the best candidate for the job\n  - nothing provides resource-agents needed by mssql-server-ha-16.0.4065.3-4.x86_64", "rc": 1, "results": []}

            spetros@redhat.com Sergei Petrosian
            spetros@redhat.com Sergei Petrosian
            Sergei Petrosian Sergei Petrosian
            Daniel Yeisley Daniel Yeisley
            Gabriela Fialova Gabriela Fialova
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

              Created:
              Updated:
              Resolved: