FIX: Error 7105 when you execute UPDATE on sparse column set while ONLINE INDEX REBUILD is running on the same table in SQL Server

Applies to: SQL Server 2012 DeveloperSQL Server 2012 EnterpriseSQL Server 2012 Standard More

Symptoms


Consider the following scenario:
  • You use Microsoft SQL Server 2012 or SQL Server 2014.
  • You execute ONLINE INDEX REBUILD on a clustered index that has a sparse column set.
  • You execute UPDATE on the column set on the same table while ONLINE INDEX REBUILD is running.
In this scenario, you receive the following error messages:
<Timestamp> <spid> Error: 7105, Severity: 22, State: 6.
<Timestamp> <spid> The Database ID xx, Page (fileid:pageid), slot xx for LOB data type node does not exist. This is usually caused by transactions that can read uncommitted data on a data page. Run DBCC CHECKTABLE.

Note
CHECKTABLE does not report any consistency issues.

Resolution


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

Cumulative Update 3 for SQL Server 2012 SP2

Cumulative Update 4 for SQL Server 2014

Cumulative Update 12 for SQL Server 2012 SP1

Workaround


To work around this issue, schedule ONLINE INDEX REBUILD activity at a different timeframe when such updates are not being executed.

Status


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