Transaction terminated running SELECT on secondary AG group
1
Using SQL Server 2016, Always-On Running a simple SELECT on a table within a secondary Availability Group. select distinct some_column from some_table oo (nolock) inner join some_other_ ss (nolock) on ss.some_column= oo.some_other_column SSMS eventually sends back this error: Msg 3948, Level 16, State 2, Line 14061 The transaction was terminated because of the availability replica config/state change or because ghost records are being deleted on the primary and the secondary availability replica that might be needed by queries running under snapshot isolation. Retry the transaction. The same SELECT with (NOLOCK) works fine on the primary AG. With or without the NOLOCK it fails most of the time 9/10 and sometimes executes correctly but that's rare. No changes were made to the ...
