Failed Assertion on SQL Server

Question

Hi Experts,

our SQL AOG changed to 'Resolving' status, after review SQL Log found System assertion check failed with Failed Assertion= 'pLogRec->GetOpCode()!=LOP_NULL..

what does it mean from this statement line??

our Server specs is Windows Server 2022 (21H2) and SQL Server 2019 (RTM)..

I really know MS Support recommend to update CU & Hotfix

after read Error Code reference from Microsoft for User Action, there is point like this:

1. In some cases, you can search for the specific assert condition in Failed Assertion part of the 17066 error. For example, in the above message search for lck_sufficient (lckMode, LCK_M_IX). This expression will help you with a more accurate search for a matching issue. This expression is the condition that triggers the assert in the first place and it's quite specific**.**<--

What should I do with this User Action related to my error "Failed Assertion=pLogRec->GetOpCode()!=LOP_NULL. ??

Great thanks and high appreciation for all advice & asnwers

warm regards,

Urbel

Answer 1

Hi @UrBel,Typically, an assertion failure is caused by a software bug or data corruption.

You may update the latest Cumulative Update to fix the issue.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.