Uploaded image for project: 'Modules'
  1. Modules
  2. MODULES-6022

puppetlabs/sqlserver : upgrade to 2.0.1 reinstalls existing sql server instances

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: sqlserver
    • Labels:
      None
    • Template:
      MODULES Bug Template
    • Team:
      Windows
    • Sprint:
      Windows Kanban
    • Method Found:
      Customer Feedback
    • CS Priority:
      Critical
    • CS Frequency:
      3 - 25-50% of Customers
    • CS Severity:
      5 - Critical
    • CS Business Value:
      5 - $$$$$$
    • CS Impact:
      The SQL Server module is one of the premier PE-only modules. This bug can take down a production system(not just impact your puppet infrastructure) so we've rated it a critical priority.
    • QA Risk Assessment:
      Needs Assessment

      Description

      Basic Info
      Module Version:
      2.0.1
      Puppet Version:

      2017.2.3
      OS Name/Version:

      RHEL7.2 master / server 2016 agent
      Describe your issue in as much detail as possible...

      Following an upgrade to 2.0.1 from 2.0.0 all existing sql servers are reinstalled on next puppet run

      Looks like the instance facts are failing and running puppet facts confirmed it…there was no instance being identified.

      Desired Behavior:
      existing instances should be detected and installation should not happen

      Actual Behavior:

      instances where not reported as existing

      Please take a moment and attach any relevant log output and/or manifests. This will help us immensely when troubleshooting the issue.

      [code]
      Debug: Prefetching mssql resources for sqlserver_instance

      Debug: Puppet::Type::Sqlserver_instance::ProviderMssql: Parsing result {"SQL_2012"=>{}, "SQL_2014"=>{}, "SQL_2016"=>{}}

      Debug: Installation source detected as version SQL_2012

      Debug: Executing: 'C:\Windows\system32\WindowsPowershell\v1.0\powershell.exe $Result = Dism /online /Get-featureinfo /fe

      aturename:NetFx3

      If($Result -contains "State : Enabled")

      { Write-Host ".Net Framework 3.5 is already installed." }

      Else

      {

      Write-Host "Installing .Net Framework 3.5, do not close this prompt..."

      $InstallResult = DISM /Online /Enable-Feature /FeatureName:NetFx3 /All /NoRestart /Quiet /LimitAccess

      $Result = Dism /online /Get-featureinfo /featurename:NetFx3

      If($Result -contains "State : Enabled")

      { Write-Host "Install .Net Framework 3.5 successfully." }

      Else

      { Write-Host "Failed to install Install .Net Framework 3.5." Write-Host "DISM Install Result" Write-Host "-----------" Write-Host ($InstallResult -join "`n") #exit 1 }

      }

      '

      Debug: Sqlserver_instance[MSSQLSERVER](provider=mssql): Installing features 'SQLEngine'

      Debug: Executing: 'C:/BaseSQL/setup.exe /ACTION=install /Q /IACCEPTSQLSERVERLICENSETERMS /INSTANCENAME=MSSQLSERVER /FEATURES=SQLEngine /AGTSVCACCOUNT="" /AGTSVCPASSWORD="" /SQLSVCACCOUNT="" /SQLSVCPASSWORD="/" /SQLSYSADMINACCOUNTS= "BUILTIN\Administrators" /ConfigurationFile="C:/Users/TEMP/AppData/Local/Temp/sqlconfig20171115-2548-t8byq1.ini"'

      [code]

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              william.hurt William Hurt
              Reporter:
              martin.ewings Marty Ewings
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Zendesk Support