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

sqlserver : Server restart should account for running Server Agent service

    XMLWordPrintable

    Details

    • Template:
      MODULES Bug Template
    • Team:
      Windows
    • Story Points:
      1
    • CS Priority:
      Normal
    • CS Frequency:
      2 - 5-25% of Customers
    • CS Severity:
      3 - Serious
    • CS Business Value:
      5 - $$$$$$
    • CS Impact:
      Hide
      The SQLServer module is one of our premier windows modules. As stated in the ticket it has dependencies between the services and this module should correctly respect those dependencies.

      The workaround of using an exec are not ideal as idempotency can be harder to establish, the module should handle this.
      Show
      The SQLServer module is one of our premier windows modules. As stated in the ticket it has dependencies between the services and this module should correctly respect those dependencies. The workaround of using an exec are not ideal as idempotency can be harder to establish, the module should handle this.
    • QA Risk Assessment:
      Needs Assessment

      Description

      puppetlabs/sqlserver 2.1.0
      PE 2017.3.2
      Server 2016
      SQL Server 2016 Developer edition

      When restarting SQL server the SQL Server Agent service should be stopped first: - Stop an Instance of SQL Server (net Commands)

      When using the restart attribute the server will not be restarted if the agent service is running:

      -> sqlserver::sp_configure { 'MSSQLSERVER-max memory':
      config_name => 'max server memory (MB)',
      instance => 'MSSQLSERVER',
      reconfigure => true,
      restart => true,
      value => 2048

      Error: /Stage[main]/xxxxxxx::Config/Sqlserver::Sp_configure[MSSQLSERVER-max memory]/Service[MSSQLSERVER]: Failed to call refresh:
      Cannot stop MSSQLSERVER, error was: Execution of 'C:/Windows/system32/net.exe stop MSSQLSERVER' returned 4294967295: The following services are dep
      endent on the SQL Server (MSSQLSERVER) service.
      Stopping the SQL Server (MSSQLSERVER) service will also stop these services.

      SQL Server Agent (MSSQLSERVER)

      Do you want to continue this operation? (Y/N) [N]:
      No valid response was provided.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              william.hurt William Hurt
              Reporter:
              neil.binney Neil Binney
              Votes:
              1 Vote for this issue
              Watchers:
              7 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Zendesk Support