Assume that you have a database that contains a partitioned table in Microsoft SQL Server 2014. The table has a columnstore index, and the partitions of the table are mapped to different filegroups. When you run the DBCC CHECKFILEGROUP
statement, you receive the following false inconsistency error messages:
Msg 8965, Level 16, State 1
Table error: Object ID <object id>, index ID <index id>, partition ID <partition id>, alloc unit ID <alloc unit id> (type LOB data). The off-row data node at page (<page id>), slot <slot id>, text ID <text id> is referenced by page (<page id>), slot <slot id>, but was not seen in the scan.CHECKFILEGROUP found 0 allocation errors and N consistency errors in table 'PageArchive' (object ID <object id>).
However, when you run the DBCC CHECKDB
statement, you don't receive any consistency error messages. Additionally, running the DBCC CHECKDB
statement with the REPAIR_ALLOW_DATA_LOSS
option doesn't fix the consistency errors. That's because the consistency error that's reported by DBCC CHECKFILEGROUP is a false positive and a reporting bug that can be ignored.