[MODULES-6904] sqlserver : Server restart should account for running Server Agent service - Puppet Jira Server

XML

Word

Printable

Details

Type: Bug
Status: Closed
Priority: Normal
Resolution: Fixed
Affects Version/s: SQL Server 2.1.0
Fix Version/s: None
Component/s: sqlserver, windows
Labels:
- Support
- windows_engineer_triaged

Epic Link:
IAC - Customer Escalations
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

relates to

MODULES-9230 puppetlabs-service : Windows task cannot restart services with dependencies

Resolved

mentioned in: Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...

(40 mentioned in)

Activity

People

Assignee:: William Hurt

Reporter:: Neil Binney

Votes:: 1 Vote for this issue

Watchers:: 7 Start watching this issue

Dates

Created:: 2018/03/22 4:12 AM

Updated:: 2019/06/27 11:09 AM

Resolved:: 2019/06/27 11:09 AM