I also have an almost identical instance in the same migration scenario from SQL Server 2017 to 2019 that is NOT experiencing these errors. While I appreciate the process being automatically recovered, I'm concerned why the error is even showing up in the error log. I'm not in the situation where my instance is being restarted, but it seems this fix is similar to what I am experiencing. Then, the database will go in a suspect state.YouĬan get the database back online by using Emergency Mode. Turophile at 0:24 Turophile Sorry, the error message is in the Subject: Msg 1222, Level 16, State 43, Line 122 Lock request time out period exceeded. This setting can get overridden at the driver level in the datasource properties. Lock request time out period exceeded.Įrror: 9016, Severity: 21, State: 7. 307 2 4 13 'it broke' - The actual error message would be useful, since it sounds like some resource is being exhausted. Microsoft SQL Server has a setting to define the amount of time to wait for a lock before timing out: LOCKTIMEOUT is set per transaction and its default value is -1, which means the attempt to acquire a lock never times out. Resembles the following: Starting up database. Instance of SQL Server, you may receive a lock time-out error that It is impossible to list columns in tables, show code of views and procedures, etc. I found FIX: TDE encrypted Databases go in suspect state during the recovery phase when you restart SQL Server, where it discusses a fix that has been back-ported to previous versions of SQL Server.Īssume that you have a Transparent Data Encryption (TDE) encryptedĭatabase on an instance of Microsoft SQL Server. 1 Whenever I try to navigate through the objects in sql server management studio object explorer I get the error message Lock request time out period exceeded. These messages are always preceded by Error: 1222, Severity: 16, State: 55.Īnd Lock request time out period exceeded. I was browsing the Error Log and noticed intermittent messages about An error occurred while processing log encryption. To solve this error (text message: Lock request time out period exceeded. I recently migrated a SQL Server 2017 TDE database to SQL Server 2019 CU4.
0 Comments
Leave a Reply. |