question

cqian avatar image
cqian asked

snapshot isolation transaction fail in database when tried to select from secondary database

Hi, In my MSSQL Server 2012 AlwaysOn environment, I got some complain about user getting the following error: Snapshot isolation transaction failed in database because the object accessed by the statement has been modified by a DDL statement in another concurrent transaction since the start of this transaction. It is disallowed because the metadata is not versioned. A concurrent update to metadata can lead to inconsistency if mixed with snapshot isolation. I have checked the primary node and their was no relevant DDL change at the time the error occurred. Is there anything else I should check? Thanks, Chun
dba
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

This query was against a readable secondary, yes? Was there any synchronisation going on at the time of your query?
0 Likes 0 ·

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.