Post reply

Time-out occurred while waiting for buffer latch type 2

  • July 2, 2004 at 6:55 am

    #88155

    Hello,

     

    I saw some strange errors last night in few of our overnight jobs. These jobs have been running fine for long time. There were no changes made to the server. Yesterday 2 jobs that run against same database failed with this error in job history.

    Time-out occurred while waiting for buffer latch type 2 for page (1:8088), database ID 11. [SQLSTATE 42000] (Error 845).

    I am looking at MS website and it seems like this is something that would happen on a system with AWE opetion turned on. It's off for us. ( congif_Value =0 in sp_configure)

    I tried to run that job manually at different time and same thing.

    Anyone has any idea what this is?

    Thanks.

     

  • July 2, 2004 at 7:37 am

    #513155

    Did your log grow last night? The latches are a precursor to locks and when the log grows, everything pauses. This could result in some timeout type problems.

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com

  • July 2, 2004 at 8:41 am

    #513180

    Thanks, Steve.

    I think I found an answer to this. Both of this jobs were pulling data from remote server. On Remote server Bunch of processes were getting blocked becuase of the Netbackup (Vertias) that couldn't finish and this started a sequence of failing and blocking process on that server.

    Thanks.

    -Hiren

     

     

Viewing 3 posts - 1 through 2 (of 2 total)

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