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

Article ID: 2619077 - View products that this article applies to.
Expand all | Collapse all

On This Page

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.
Back to the top | Give Feedback

SYMPTOMS

Consider the following scenario:
  • You enable the AUTO_CLOSE option of a database in an instance of SQL Server 2008.
  • 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.

Back to the top | Give Feedback

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.

Back to the top | Give Feedback

RESOLUTION

Cumulative update information

The fix for this issue was first released in cumulative update package 7 for SQL Server 2008 Service Pack 2. For more information about how to obtain this cumulative update package for SQL Server 2008 Service Pack 2, click the following article number to view the article in the Microsoft Knowledge Base:
2617148
(http://support.microsoft.com/kb/2617148/ )
Cumulative update package 7 for SQL Server 2008 Service Pack 2
Note Because the builds are cumulative, each new update release contains all the hotfixes and all the security updates that were included with the previous SQL Server 2008 Service Pack 2 update release. We recommend that you consider applying the most recent update release that contains this hotfix. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
2402659
(http://support.microsoft.com/kb/2402659/ )
The SQL Server 2008 builds that were released after SQL Server 2008 Service Pack 2 was released
Back to the top | Give Feedback

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Back to the top | Give Feedback

WORKAROUND

To work around this issue, disable the AUTO_CLOSE option of the database.
Back to the top | Give Feedback

Properties

Article ID: 2619077 - Last Review: November 24, 2011 - Revision: 3.0
APPLIES TO
  • 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
Keywords: 
kbfix kbexpertiseadvanced kbsurveynew kbqfe KB2619077
Back to the top | Give Feedback

Give Feedback

 
Back to the topBack to the top