deadlock explained funny way....

  • Wanna know what Deadlock is?


    From To Message

    Boss Secretary For a week we will go abroad, so make arrangement.

    Secretary Husband For a week my boss and I will be going abroad, you look after yourself.

    Husband Secret lover My wife is going abroad for a week, so let’s spend the week together.

    Secret lover Small boy (whom she is giving private tuition) I have work for a week, so you need not come for class.

    Small boy Grand-father Grandpa, for a week I don't have class 'coz my teacher is busy. Let’s spend the week together.

    Grandpa ( T he B oss πŸ™‚ ) Secretary This week I am spending my time with my grandson. We cannot attend that meeting.

    Secretary Husband This week my boss has some work, we cancelled our trip.

    Husband Secret lover We cannot spend this week together; my wife has cancelled her trip.

    Secret lover Small boy This week we will have class as usual.

    Small boy Grandfather Grandpa, my teacher said this week I have to attend class. Sorry I can't give you company.

    Grandfather Secretary Don't worry this week we will attend that meeting, so make arrangement.

    So one process waiting for another πŸ™‚

    Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.

  • suresh kumar Sulakh (7/11/2010)

    So one process waiting for another πŸ™‚

    No, that's blocking. Deadlock is two processes waiting for each other in such a way that neither will ever complete if left alone. If you want an anecdote, go look up the hungry philosopher problem.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • I actually searched it once Gila mentioned it and went through it πŸ™‚

    A long reading nicely put.

    Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.

  • Deadlock is situation .when one user process conflict with another user process to consume the objects

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

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