Cumulative Update #12 for SQL Server 2016 SP2

[HristinaSQL]

Cumulative Update #12 for SQL Server 2016 SP2

The 12th cumulative update release for SQL Server 2016 SP2 is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates.
To learn more about the release or servicing model, please visit:

• CU12 KB Article: https://support.microsoft.com/en-us/help/4536648
• Microsoft® SQL Server® 2016 SP2 Latest Cumulative Update: https://www.microsoft.com/download/details.aspx?id=56975
• Update Center for Microsoft SQL Server: http://technet.microsoft.com/en-US/sqlserver/ff803383.aspx

[abrown69]

Hello, does CU12 for SQL 2016 contain previous security updates, such as KB4535706 ?

[HristinaSQL]

Yes, the update is cumulative and contains previous fixes including the security one for SQL Server 2016 SP2 CU11.

[CherryDz]

Anyone came across any issues with deploying this CU yet? 

[abrown69]

We're deploying this week for dev/qas systems.  Prod in a couple of weeks. 

If we notice anything, we'll post back.

[CherryDz]

@abrown69 great, you are 2 weeks ahead of me for dev. Any issues impacting single points of failure would be most helpful. Good luck ;) 

[Mar71ns]

Hello,

Please be aware! We are experiencing memory mini-dumps after upgrade to CU12. I suggest to install into test environment first and do all regression tests before installing into production (no surprise here).

We are still investigating what exactly causes SQL Server to crash. After uninstalling CU12 everything works fine.

Here are the mini-dump details:

Error: 17066, Severity: 16, State: 1.
SQL Server Assertion: File: <tmpilb.cpp>, line=3412 Failed Assertion = 'fNoReaderWriterConflict'. This error may be timing-related. If the error persists after rerunning the statement, use DBCC CHECKDB to check the database for structural integrity, or restart the server to ensure in-memory data structures are not corrupted.
Error: 3624, Severity: 20, State: 1.
A system assertion check has failed. Check the SQL Server error log for details. Typically, an assertion failure is caused by a software bug or data corruption. To check for database corruption, consider running DBCC CHECKDB. If you agreed to send dumps to Microsoft during setup, a mini dump will be sent to Microsoft. An update might be available from Microsoft in the latest Service Pack or in a Hotfix from Technical Support.
**Dump thread - spid = 0, EC = 0x0000029CA33B3AA0
***Stack Dump being sent to D:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\LOG\SQLDump0032.txt
* *******************************************************************************
* BEGIN STACK DUMP:
* 03/19/20 22:56:46 spid 72

* Location: tmpilb.cpp:3462
* Expression: fNoReaderWriterConflict
* SPID: 72
* Process ID: 5412

* Short Stack Dump
00007FFB16824C48 Module(KERNELBASE+0000000000034C48)
00007FFAE820D19E Module(sqllang+000000000103D19E)
00007FFAE8210F19 Module(sqllang+0000000001040F19)
00007FFAE824B839 Module(sqllang+000000000107B839)
00007FFB027EC9D4 Module(sqldk+000000000005C9D4)
00007FFB03EED013 Module(sqlmin+00000000009FD013)
00007FFB03EEB66D Module(sqlmin+00000000009FB66D)
00007FFB03EEC159 Module(sqlmin+00000000009FC159)
00007FFB0B5E6920 Module(MSVCR120+0000000000066920)
00007FFB0B5DEA3A Module(MSVCR120+000000000005EA3A)
00007FFB0B5DF1E1 Module(MSVCR120+000000000005F1E1)
00007FFB0B5DEC6D Module(MSVCR120+000000000005EC6D)
00007FFB0B5DF5C7 Module(MSVCR120+000000000005F5C7)
00007FFB1A14A60D Module(ntdll+00000000000AA60D)
00007FFB1A0E06BA Module(ntdll+00000000000406BA)
00007FFB0B5DF535 Module(MSVCR120+000000000005F535)
00007FFB0B5DD648 Module(MSVCR120+000000000005D648)
00007FFB0B5DD9B7 Module(MSVCR120+000000000005D9B7)
00007FFB0B5DED54 Module(MSVCR120+000000000005ED54)
00007FFB0B5DF5C7 Module(MSVCR120+000000000005F5C7)
00007FFAE74BA2B2 Module(sqllang+00000000002EA2B2)
00007FFB1A14A58D Module(ntdll+00000000000AA58D)
00007FFB1A0DFD23 Module(ntdll+000000000003FD23)
00007FFB1A0E1A39 Module(ntdll+0000000000041A39)
00007FFB16824C48 Module(KERNELBASE+0000000000034C48)
00007FFB0B5DEF53 Module(MSVCR120+000000000005EF53)
00007FFB027B2F69 Module(sqldk+0000000000022F69)
00007FFB027B2DE4 Module(sqldk+0000000000022DE4)
00007FFB027B2A8A Module(sqldk+0000000000022A8A)
00007FFAE824BCAE Module(sqllang+000000000107BCAE)
00007FFB027EC9D4 Module(sqldk+000000000005C9D4)
00007FFB03EECF14 Module(sqlmin+00000000009FCF14)
00007FFB03EEC71B Module(sqlmin+00000000009FC71B)
00007FFB03EEA580 Module(sqlmin+00000000009FA580)
00007FFB03EEA649 Module(sqlmin+00000000009FA649)
00007FFB02CB437F Module(sqlTsEs+000000000005437F)
00007FFAE75D2D98 Module(sqllang+0000000000402D98)
00007FFAE71E3A49 Module(sqllang+0000000000013A49)
00007FFAE71E2F21 Module(sqllang+0000000000012F21)
00007FFAE7EB046E Module(sqllang+0000000000CE046E)
00007FFAE7EBD20C Module(sqllang+0000000000CED20C)
00007FFAE7EBC89C Module(sqllang+0000000000CEC89C)
00007FFAE75DBB80 Module(sqllang+000000000040BB80)
00007FFAE7EFA272 Module(sqllang+0000000000D2A272)
00007FFAE7EF9C11 Module(sqllang+0000000000D29C11)
00007FFAE7EF6968 Module(sqllang+0000000000D26968)
00007FFAE71E158A Module(sqllang+000000000001158A)
00007FFAE71E3963 Module(sqllang+0000000000013963)
00007FFAE71E2F21 Module(sqllang+0000000000012F21)
00007FFAE7EFA272 Module(sqllang+0000000000D2A272)
00007FFAE7EF9C11 Module(sqllang+0000000000D29C11)
00007FFAE7EF6968 Module(sqllang+0000000000D26968)
00007FFAE71E158A Module(sqllang+000000000001158A)
00007FFAE71E3963 Module(sqllang+0000000000013963)
00007FFAE71E2F21 Module(sqllang+0000000000012F21)
00007FFAE7EB046E Module(sqllang+0000000000CE046E)
00007FFAE7EBD20C Module(sqllang+0000000000CED20C)
00007FFAE7EBC89C Module(sqllang+0000000000CEC89C)
00007FFAE75DBB80 Module(sqllang+000000000040BB80)
00007FFAE7EFA272 Module(sqllang+0000000000D2A272)
00007FFAE7EF9C11 Module(sqllang+0000000000D29C11)
00007FFAE7EF6968 Module(sqllang+0000000000D26968)
00007FFAE71E158A Module(sqllang+000000000001158A)
00007FFAE71E3963 Module(sqllang+0000000000013963)
00007FFAE71E2F21 Module(sqllang+0000000000012F21)
00007FFAE7EFA272 Module(sqllang+0000000000D2A272)
00007FFAE7EF9C11 Module(sqllang+0000000000D29C11)
00007FFAE7EF6968 Module(sqllang+0000000000D26968)
00007FFAE71E158A Module(sqllang+000000000001158A)
00007FFAE71E3963 Module(sqllang+0000000000013963)
00007FFAE71E2F21 Module(sqllang+0000000000012F21)
00007FFAE7EFA272 Module(sqllang+0000000000D2A272)
00007FFAE7EF9C11 Module(sqllang+0000000000D29C11)
00007FFAE7EF6968 Module(sqllang+0000000000D26968)
00007FFAE71E158A Module(sqllang+000000000001158A)
00007FFAE71E3963 Module(sqllang+0000000000013963)
00007FFAE71E2F21 Module(sqllang+0000000000012F21)
00007FFAE71EA0C5 Module(sqllang+000000000001A0C5)
00007FFAE71FBAF2 Module(sqllang+000000000002BAF2)
00007FFAE71FBC03 Module(sqllang+000000000002BC03)
00007FFB0279561D Module(sqldk+000000000000561D)
00007FFB02795B15 Module(sqldk+0000000000005B15)
00007FFB0279576D Module(sqldk+000000000000576D)
00007FFB027B5DF8 Module(sqldk+0000000000025DF8)
00007FFB027B5C60 Module(sqldk+0000000000025C60)
00007FFB027B57E7 Module(sqldk+00000000000257E7)
00007FFB027B6028 Module(sqldk+0000000000026028)
00007FFB184C84D4 Module(KERNEL32+00000000000084D4)
00007FFB1A10E851 Module(ntdll+000000000006E851)
Stack Signature for the dump is 0x00000000C0517095
External dump process return code 0x20000001. External dump process returned no errors.
Error: 17066, Severity: 16, State: 1.
SQL Server Assertion: File: <tmpilb.cpp>, line=3462 Failed Assertion = 'fNoReaderWriterConflict'. This error may be timing-related. If the error persists after rerunning the statement, use DBCC CHECKDB to check the database for structural integrity, or restart the server to ensure in-memory data structures are not corrupted.
SQL Server is terminating because of a system shutdown. This is an informational message only. No user action is required.
Service Broker manager has shut down.
Error: 17054, Severity: 16, State: 1.
The current event was not reported to the Windows Events log. Operating system error = (null). You may need to clear the Windows Events log if it is full.
.NET Framework runtime has been stopped.
SQL Server shutdown has been initiated