FIX: Error 5283 when you run DBCC CHECKDB on a database that contains non-clustered columnstore index in SQL Server 2016

Symptoms

When you run DBCC CHECKDB on a database that contains non-clustered columnstore index, you may receive error messages that resemble the following:
Msg 5283, Level 16, State 1
The Cross Rowset check on columnstore index object ID <object id>, index ID <index id>, partition ID <partition id>. Drop and recreate the columnstore index.
DBCC results for <index name>.
There are m rows in n pages for object <index name>.
CHECKDB found 0 allocation errors and n consistency errors in table <index name> (object ID <object id>).
DBCC results for <table name>.There are m rows in pages for object <table name>.


Resolution

The issue was first fixed in the following cumulative update of SQL Server:
Recommendation: Install the latest cumulative update for SQL Server

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References

Learn about the terminology that Microsoft uses to describe software updates.
內容

文章識別碼:3174088 - 最後檢閱時間:2016年7月25日 - 修訂: 1

意見反應