FIX: Access violation when a missing task for a background clear operation tries to delete a missing index entry

Microsoft distributes Microsoft SQL Server 2008 Service Pack 2 (SP2) fixes as one downloadable file. Because the fixes are cumulative, each new release contains all the hotfixes and all the security updates that were included with the previous SQL Server 2008 SP2 update release.
Symptoms
Consider the following scenario:
  • You enable the AUTO_CLOSE option of a database in an instance of SQL Server 2008, SQL Server 2012, or SQL Server 2014.
  • One or more missing index entries for an object of the database are in the missing index dynamic management view.
  • All the connections that are made to this database are closed.

    Note When all connections are closed, the database is expected to close automatically.
  • At the same time, a task for a background clear operation tries to delete the missing index entry. The thread that runs the task is not the same thread that closes the database.
In this scenario, access violation occurs. Additionally, you have to restart the instance of SQL Server to resolve this issue.

Cause
This issue occurs because multiple calls are made to a free method when the missing task for the background clear operation tries to delete the missing index entry.

Resolution
The issue was first fixed in the following cumulative update of SQL Server.

Cumulative Update 1 for SQL Server 2014 SP1

Cumulative Update 8 for SQL Server 2014

Cumulative Update 6 for SQL Server 2012 SP2

Cumulative Update 7 for SQL Server 2008 SP2

About cumulative updates for SQL Server

Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server:
Status
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Workaround
To work around this issue, disable the AUTO_CLOSE option of the database.
Properties

Article ID: 2619077 - Last Review: 06/22/2015 14:38:00 - Revision: 5.0

Microsoft SQL Server 2008 Developer, Microsoft SQL Server 2008 Enterprise, Microsoft SQL Server 2008 Standard, Microsoft SQL Server 2008 Web, Microsoft SQL Server 2008 Workgroup, Microsoft SQL Server 2012 Service Pack 2, Microsoft SQL Server 2014 Developer, Microsoft SQL Server 2014 Enterprise, Microsoft SQL Server 2014 Standard, Microsoft SQL Server 2014 Service Pack 1

  • kbfix kbexpertiseadvanced kbsurveynew kbqfe KB2619077
Feedback