An error occurred while processing log encryption

  • lcaradon

    SSC Veteran

    Points: 279

    We periodically get this message below in the SQL Server log on SQL 2012 Enterprise edition. The database is encrypted using TDE. The encrypted databases on the server were migrated from SQL 2005 and are still set to 2005 compatibility level, we are going to change it to 2012, but have not yet on production.

    The errors appear usually after a log backup has been saved on one particular database.

    SQL Log Message:

    An error occurred while processing log encryption. The process was recovered automatically. No user action is required.

    Sometimes along with this message is a lock request timeout message but not always.

    Lock request time out period exceeded.

    Error: 1222, Severity: 16, State: 55.

    I understand that it says no action is required, but just curious what is causing this error and is there cause for concern?

  • ChrisM@Work

    SSC Guru

    Points: 186087

    lcaradon (5/10/2016)


    We periodically get this message below in the SQL Server log on SQL 2012 Enterprise edition. The database is encrypted using TDE. The encrypted databases on the server were migrated from SQL 2005 and are still set to 2005 compatibility level, we are going to change it to 2012, but have not yet on production.

    The errors appear usually after a log backup has been saved on one particular database.

    SQL Log Message:

    An error occurred while processing log encryption. The process was recovered automatically. No user action is required.

    Sometimes along with this message is a lock request timeout message but not always.

    Lock request time out period exceeded.

    Error: 1222, Severity: 16, State: 55.

    I understand that it says no action is required, but just curious what is causing this error and is there cause for concern?

    Were you able to resolve this?

    [font="Arial"]“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw[/font]


    For fast, accurate and documented assistance in answering your questions, please read this article[/url].
    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]
    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
    [url

  • anshu_a87

    SSC Journeyman

    Points: 97

    I am having the exact same issue but for me it is more severe as it is happening at one of the client installations of our application and application execution fails when trying to insert some records randomly with this error.

    Were either of you able to resolve this issue by upgrading the database compatibility level to 2012? I want to be sure about it before suggesting this as a solution to the client as I suspect the problem could be related to different encryption algorithms used by SQL 2005 vs SQL 2012.

  • abfoltz

    SSC Enthusiast

    Points: 107

    Did either of you come up with a resolution for this?  We are having the same problem.  We are running on SQL 2012 Enterprise Edition and our databases are in 2012 compatibility mode and have TDE on.  We have been setup this way since Aug 2014 and are just noticing this problem now because the lock request time out errors are causing some of our PeopleSoft processes to fail.  Note:  We did install SP3 in June 2016 and security update KB3194721 in Nov 2016, no other sql updates.

  • jeffrey yao

    SSCarpal Tunnel

    Points: 4352

    We have the exactly the same issue as the original poster, i.e. we are sql server 2016 EE and TDE encrypted, we are also on a 2-node HAG, and this issue only occurred on 2nd node (i.e. not the primary node)

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply