We have been building and testing our application against SQL Server 2016. Recently, we wanted to upgrade our build/test environment to SQL 2019, so that we can recommend an upgrade to our customers.
Since we had many databases, i stopped sql server service, copied over the data files to new disks, and attached the database on a new virtual machine running SQL 2019 Developer edition (RTM). There were no errors attaching the database and everything looked good. But then we started seeing random SQL assertion failures when running our unit tests. The failures are not consistent, but when it happens, it always happens in a select few unit tests.
This is the info in the event log:
Index : 56160
EntryType : Error
InstanceId : 3221242538
Message : SQL Server Assertion: File: <"sql\\ntdbms\\storeng\\logrec\\pagelog.cpp">, line=180 Failed Assertion = 'IS_OFF(LSN_SLOT_MASK, log_prevPageLsn.m_slotId)'. This error may be timing-related. If the error persists after rerunning the
statement, use DBCC CHECKDB to check the database for structural integrity, or restart the server to ensure in-memory data structures are not corrupted.
Category : Server
CategoryNumber : 2
ReplacementStrings : {"sql\\ntdbms\\storeng\\logrec\\pagelog.cpp", 180, IS_OFF(LSN_SLOT_MASK, log_prevPageLsn.m_slotId)}
Source : MSSQLSERVER
TimeGenerated : 5/6/2021 7:15:38 PM
TimeWritten : 5/6/2021 7:15:38 PM
UserName :
I see the same error when trying to shrink the database as well. I had to rollback the environment as i could not figure out what was wrong or how to fix it. Would appreciate any help or advise.