Search

SQL2012 Could not locate Statistics on secondary replica by AgentJeff

Active

1
0
Sign in
to vote
Type: Bug
ID: 780062
Opened: 2/26/2013 2:51:00 PM
Access Restriction: Public
0
Workaround(s)
0
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)

Product Language

English

Version

SQL Server 2012 - Enterprise Edition

Category

SQL Engine

Operating System

Windows Server 2008 R2 Enterprise

Operating System Language

US English

Steps to Reproduce

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

Actual Results

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.

Expected Results

rows

Platform

X64

Virtualization

 
File Attachments
0 attachments
Sign in to post a comment.
Sign in to post a workaround.