FIX: Access violation when you run a query that uses clustered columnstore index with trace flag 2389, 2390, or 4139

Symptoms
Assume that you have a table that uses clustered columnstore index in an instance of Microsoft SQL Server 2014, and you either have trace flag 2389 and 2390 or trace flag 4139 enabled. When you run a query that uses this table, an access violation may occur.

Resolution
The issue was first fixed in the following cumulative update of SQL Server: Recommendation: Install the latest cumulative update 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. We recommend that you download and install the latest cumulative updates for SQL Server:
Workaround
To work around this issue, disable trace flag 2389 and 2390, or disable trace flag 4139.
References
Learn about the terminology that Microsoft uses to describe software updates.
Properties

Article ID: 3189645 - Last Review: 10/18/2016 03:14:00 - Revision: 1.0

Microsoft SQL Server 2014 Service Pack 1, Microsoft SQL Server 2014 Developer, Microsoft SQL Server 2014 Enterprise, Microsoft SQL Server 2014 Enterprise Core, Microsoft SQL Server 2014 Standard

  • kbsurveynew kbfix kbqfe kbexpertiseadvanced KB3189645
Feedback