SQL2012 Could not locate Statistics on secondary replica by AgentJeff

Active

Type:	Bug
ID:	780062
Opened:	2/26/2013 2:51:00 PM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

When querying a table thru a linked server, got the following error message.

Msg 2767, Level 16, State 1, Procedure sp_table_statistics2_rowset, Line 105
Could not locate statistics '_WA_Sys_00000007_47DBAE45' in the system catalogs.

The database was a secondary replica, primary replica was fine. Ran dbcc show statistics on secondary replica, that failed to find statistics distribution. There was an entry in sys.stats on both. Drop statistics on primary, to resolve.

Details (expand)

English

SQL Server 2012 - Enterprise Edition

SQL Engine

Windows Server 2008 R2 Enterprise

US English

Uncertain of the chain of events that lead up to causing the scenerio. I know a user process did perform a rollback transaction on the primary replica.

was query select * from [instance].db.schema.table where column=123

error message:
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 2767, Level 16, State 1, Procedure sp_table_statistics2_rowset, Line 105
Could not locate statistics '_WA_Sys_00000007_47DBAE45' in the system catalogs.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

rows

X64

0 attachments

Microsoft