Post reply

"...The semaphore timeout period has expired" Error on SQL Server 2005

  • December 21, 2010 at 9:31 am

    #146727

    Hi,

    We have a long running SQL script which has many delete statements that joins tables with millions of records. After executing for several hours, it throws the below error:

    Msg 121, Level 20, State 0, Line 0

    A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.)

    We executed the same script on a different server and did not find the same issue; so we know for sure that there is no problem with the script. I did some research online but did not find any resolution for this issue.

    Does anybody know the exact cause of this error???

    Any help would be appreciated.

    Thank You.

  • December 21, 2010 at 10:00 am

    #1265168

    It's a network/socket error.

    Here is how to troubleshoot it:

    kb325487

    Do you get the error when running the script from the server?

    Alex S

  • December 21, 2010 at 10:08 am

    #1265172

    Thanks for you reply. Yes, the script was being run on the server, which does not leave room for network connectivity issues.

  • December 21, 2010 at 10:11 am

    #1265173

    I only see this error when the server is restarted or someone / something killed my connection.

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

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