Main Menu

How to simulate deadlock for test purpose PDF Print E-mail

 

Simulating Deadlock for test purpose is simple, can be achieved by updating 2 tables with a delay in one query window & the reverse update in the second query window as shown below.

Query

Create table TableA(id int,name varchar(50))
Create table TableB(id int,name varchar(50))                       

Insert into TableA values(1,'krishna')
Insert into TableB values(2,'krish')


--Enter in first query window
begin tran
update TableA set name = 'krish' where id = 1
waitfor delay '00:00:30'
update TableB set name = 'krishna' where id = 2
commit

--Enter in secondquery window
begin tran
update TableB set name = 'krishna' where id = 2
waitfor delay '00:00:30'
update TableA set name = 'krish' where id = 1
commit

You can see the deadlock issue happened in the second query windows as shown below.


(1 row(s) affected)

Server: Msg 1205, Level 13, State 50, Line 1
Transaction (Process ID 52) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.


 

Comments (43)
  • |218.234.17.xxx |2011-07-18 05:59:48 replicas Rolex Yachtmaster  - replicas Rolex Yachtmaster
    I'm so glad you like the blog. Faded Elegance is so beautiful...you are right. This blog has been so much fun to write. I just love it!

    -replicas Rolex Yachtmaster
    ReplyQuote
  • |204.152.211.xxx |2011-07-27 07:43:05 Jordan Retro 8  - air jordan 1 shoes
    world Jordan Retro 9famous Jordan shoes or boots created from modern australia raw supplies Jordan Retro 10obtainable in black, chestnut, grey, chocolate, rose, pink.simply butJordan Retro 11 that fashionable.Recently, my friend bought a pair of modern australia merino sheepskin Jordan Retro 12 from specialty shop, genuinely fantastic feeling, she couldn¡¯t wait any much more to wait me,Jordan Retro 13and recommend me to obtain one as well, needless to say I know much more aboutJordan Retro 14, I¡¯m Jordan shoes or boots fans, the income I get from Jordan Retro 15 countless,just pursuing checklist several principal income of Jordan Retro 16. help for Jordan shoes or boots selling with several years, in condition you however odd aboutAir Jordan 16.5, you need to regret no to own recognized Jordan shoes or boots before!Wearing snow boots action just abating and comfortable, Team Jordan Retro 17in accession alluring and pretty, suggestions regarding how to gather Jordan Retro 18 Auc...
    ReplyQuote
  • |211.3.7.xxx |2011-08-03 08:43:17 2011 MBT  - 2011 MBT
    2011 MBT
    2011 MBT
    MBT Calzature
    MBT Outlet
    MBT Italia
    MBT scarpe roma
    gossip girls study from the University of Alabama found that emotional eaters—those who admitted eating in response to emotional stress—were 13 times more likely to be overweight or obese. If you feel the urge to eat in response to stress, try chewing a piece of gum, chugging a glass of water, or taking a walk around the block. Create an automatic response that doesn't involve food and you'll prevent yourself from overloading on calories.



    ReplyQuote
  • |204.152.211.xxx |2011-08-05 02:56:10 Retro Jordan Shoes outlet  - Retro Jordan Shoes outlet
    Nike Air Jordan 1 is the most retroed sneaker ever in the world, and it has a special link with Michael Jordan's career and personality.
    Authentic Louis VuittonIn 1984, a lean shooting lookout from the Dean Smith-led UNC Tar Heels was special third general by the Jordans for sale Chicago Bulls in the NBA Draft. The daring red and jet black was in unity with his surly Air Jordans 1 Retro
    bearing and mild arrogance, but it was a beguiling, boyish smirk that required the league's collective protect down,
    cheapest/cheap louis vuitton handbags departure it vulnerable to damage from any vantage intention. It was too recent by the time the league figured out who Michael Jordan genuinely was, and it rewarded greatly; six
    Air Jordans 18 Retro
    NBA Championships,Authentic LV Hats ten stretch scoring titles in stuffed seasons, five MVP trophies,louis vuitton jeans mens and shelves satiated of other trophies were conceded to one man who bent an unreasonable ordinary for NBA players both duri...
    ReplyQuote
  • |205.209.140.xxx |2011-08-17 08:09:50 uggs sale  - uggs sale
    By all means, they look dangerously comfy,uggs sale, that I wouldn’t be surprised if you caught me accidentally walking down to belstaff jacket. Even so, I am feeling stress-fully torn between my belstaff jackets for comfort and their link to my Grandmother’s ugg canada. Surely, if I pop these on it doesn’t mean I’ve crossed the line between stylish and uggs sale? As long as Countryfile isn’t on that ugg canada.Perhaps it’s just my own irrational fear of picturing these slippers with ugg classic tall? If, however, these luxurious bailey button ugg were teamed with your favourite check pyjama trousers and an oversized t-shirt ugg bailey button, and accessorized with some bailey button uggs then I reckon we’d have an indoor-shoe winner.clw817
    ReplyQuote
  • |205.209.143.xxx |2011-08-24 06:24:18 ugg boots sale  - ugg boots sale
    Located in Canada,we provide you with best quality luxurious ugg boots sale. belstaff jackets are selling all around the globe. Choose from our belstaff jacket,and Lace Up boots as well as our enormously popular uggs canada. Kids and baby boots are also available, as well as slippers and scuffs and our uggs canada range and Desert boots. To complement our ugg boots canada we also offer top quality Pashmina shawls. Don't forget to visit our specials page and grab yourself a ugg classic tall boots!At ugg bailey button you will not only receive the best quality products, but highly competitive prices and excellent customer service. If you can't find what you are looking for or have questions on any of our bailey button uggs, please visit uggs bailey button or contact us for more information.clw824
    ReplyQuote
  • |205.164.14.xxx |2011-09-14 08:58:30 Dell studio 1535 Akku  - http://www.dellakku.de/Dell-Akku-vostro-3700-6600m
    die in den USA, die ihrerseits als ein Leuchtturm Dell Vostro 1000 Akku der Innovation und unternehmerische Initiative, Innovation Dell Inspiron 630M Akku zwischen Dire Straits und Toten.
    ReplyQuote
  • |66.197.219.xxx |2011-10-25 03:06:57 Anonymous
    The Nike All-American sandwiches were distributed Nationwide at Retail Supermarkets. The sandwich subject to the recall is: Landshire Nike All-American. This is a pre-packaged, individually wrapped white package sandwich. Sandwich weight is 7.25 ounces (206grams).
    2011 fall and winter fashion available.
    cheap nike free
    nike air force 1
    nike free
    cheap nike air force 1
    Please come with me here to see In this beautiful world !
    ReplyQuote
  • |66.197.219.xxx |2011-11-05 02:47:07 Anonymous
    Visitors to Nike Portland, which opened this morning at the corner of Southwest Fifth Avenue and Morrison Street, may notice the architectural details of the interior before they start checking out the merchandise.
    2011 fall and winter fashion available.
    cheap nike free
    nike air force 1
    cheap nike air force 1
    nike free
    Please come with me here to see In this beautiful world !
    ReplyQuote
  • |125.140.198.xxx |2011-11-27 03:00:13 jewellery iaustralia
    Tiffany Era inspired jewelry series Tiffany

    Donald Claflin (Donald Claflin)tiffang australia
    tiffang australia
     in the 1970s designed a ring that he had between Tiffany 1837

    1966 to 1977 as a designer at Tiffany. Claflin to create a large numbe r Tiffany and co

    of very interesting because of the known works of jewelry.

    ReplyQuote
  • |125.140.198.xxx |2011-11-27 03:10:49 Tiffany
    Tiffany Era inspired jewelry series rings online

    Donald Claflin (Donald Claflin)jewellery in austrilia
    tiffang australia
     in the 1970s designed a ring that he had between Tiffany rings

    1966 to 1977 as a designer at Tiffany. Claflin to create a large numbe r jewellery shop

    of very interesting because of the known works of jewelry.
    ReplyQuote
  • |204.152.213.xxx |2011-12-06 01:10:10 anthentic air jodran
    hael Jordan not only kicked off the greatest legacy in basketball history, but also putting out the greatest legacy in sneakers the real air jordans online in 1985. Even before playing in the NBA Michael Buy NHL JerseysJordan had credentials no player had ever establish. Jordan cheap jordan shoes Air Max Jordan 25 astonished critics in college basketball and assisted the 1984 Team USA to a gold medal in the Olympic Games. Finishing third in scoring with a 28.2 point per game scoring average Michael Jordan soared his rookie year.air jordan force 1 mid shoes Wearing the Air Jordan 1 Michael earned a spot on the All-Star team Air Jordan ,jordan size 15 retro brought back the Chicago Bulls back to the playoffs, and to top it became the NBA Rookie of the Year. Nike then having difficulties getting their brand into the basketball market immediately saw the potential in Michael Jordan and signed him.Discount Air Max Sneaker No matter what happens to the signature Air Air Max Jordan Jordan ...
    ReplyQuote
  • |66.197.219.xxx |2011-12-10 06:11:27 Anonymous
    New Orleans general NFL Jerseys promises owners savings of perhaps a quarter billion dollars a year but largely leaves intact the soft discount shoes wholesale salary cap system that the players fought hard to maintain.Stern and Deputy Commissioner Adam Silver announced the deal during a press conference, putting an end to nearly two years of difficult negotiations that resulted in the second shortened season in NBA history. Owners also agreed to an cheap nba jerseys expanded cheap nike air max revenue sharing plan, and Stern called both agreements "a watershed moment" for the league. The plan, nike free which will begin in 2013-14, more than quadruples the revenue currently shared by teams, with soccer shoes Stern saying they could now receive in excess of 20 million and at least six teams could pay 50 million into the plan.A outdoor shoes person familiar wholesale nike shoes with the negotiations says the framework of a three-team trade is in place to send New Orleans Horn...
    ReplyQuote
Write comment
Your Contact Details:
Comment:
[b] [i] [u] [url] [quote] [code] [img]   
:D:angry::angry-red::evil::idea::love::x:no-comments::ooo::pirate::?::(
:sleep::););)):0
Security
Please input the anti-spam code that you can read in the image.
< Prev   Next >
 
Copyright 2009 SQL Server.in, Powered by Joomla!; Joomla templates by SG web hosting