Cumulative Update requires a restart after SP1 install

Cumulative Update requires a restart after SP1 install by aaronbertrand

Closed

as Won't Fix Help for as Won't Fix

Type:	Bug
ID:	774111
Opened:	12/12/2012 4:51:32 AM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

I have complained in the past about SP1 setup showing confusing things about services and applications that might cause a restart to be required:

https://connect.microsoft.com/SQLServer/feedback/details/418470/setup-utter-confusion-about-services-avoiding-reboot

And other users have complained about this reboot in general:

https://connect.microsoft.com/SQLServer/feedback/details/417908/upgrade-of-sql-2008-to-sp1-requires-reboot

It seems that both of these problems have been "fixed" by hiding the services and applications that are found in the "Check Files In Use" step of SP1 setup. Does this really fix the problem?

After installing SP1, I went to install SP1 CU1 (since I still have to do this in two steps if the instance already exists), and the Rule "Restart computer" failed. So, it seems that after SP1 is installed, even though "Check Files In Use" indicated that no reboot-causing files were actually in use, I still have to restart the computer before installing CU1.

It isn't quite clear during SP1 setup if or why a reboot will be required after installing SP1; in this case, the engine seems to be patched correctly. But I found this in Detail.txt for SP1:

(07) 2012-12-12 06:46:38 Slp: Rule 'RebootRequiredCheck' results: IsRebootNotRequired=True

And then for CU1, run only a few minutes after SP1 was complete, I see:

(07) 2012-12-12 06:53:38 Slp: Windows Update requires a reboot
(07) 2012-12-12 06:53:38 Slp: Rule 'RebootRequiredCheck' results: IsRebootNotRequired=False

So something happened during the SP1 install that set a flag with Windows Update that a restart would be required before performing any more installations.

In addition I've blogged about these issues:

http://www.sqlperformance.com/2012/12/system-configuration/sql-2012-slipstream

Details (expand)

English

SQL Server 2012 - Enterprise Edition

Setup

Not Applicable

US English

Install a minimal instance of SQL Server 2012 (core database engine + management tools)
Install SP1
Attempt to install SP1 CU1

CU1 requires a restart

CU1 does not require a restart

Or, at the very least, SP1 installer makes it very clear that a restart will be required. The Check Files In Use dialog currently gives us a false sense that no restart will be required.

Added bonus: allow us to slipstream SP1 & CU1
https://connect.microsoft.com/SQLServer/feedback/details/774109/allow-updatesource-for-service-pack-installers

X64

0 attachments

For the specific reboot issue that Aaron has reported, I have worked with Aaron and found out that it was Microsoft Update which downloaded and installed various updates and set the pending reboot flag in Aaron's machine. About at the same time that Windows Update was running, Aaron was installing SQL Server 2012 SP1 and CU1 patches. That was the reason CU1 captured the reboot required flag and reported in the rule check.

For customers who are installing new instance of SQL, you can use Product Update feature of /UpdateSource and point the install to the single installation folder of SP1 and CU1. For customers who are on existing SQL instance, I see that this feature was being considered for the next major release based on feedback in this connect request https://connect.microsoft.com/SQLServer/feedback/details/774109/allow-updatesource-for-service-pack-installers.