Un deadlock es una situación que se produce cuando dos transacciones luchan por el mismo recurso, el resultado es tan feo como esto...
Transaction (Process ID 61) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Lo primero que hay que averiguar son las tablas en las que se están produciendo bloqueos, y los comandos que lanzan las transacciones.
Una vez más el infalible I.A. (y lo digo en el sentido más amplio de la palabra) me enseño como habilitar las trazas de SQL para que sea un poco más "verboso" de lo habitual.
dbcc traceon(1204,3506)
para comprobar el status
dbcc tracestatus
Una vez activada la traza, y reproducido el error, el resultado que deja en el LOG es el siguiente:
Deadlock encountered .... Printing deadlock informationWait-for graph
Node:1
TAB: 2:2009058193 [] CleanCnt:1 Mode: X Flags: 0x0
Grant List::
Owner:0x1c3b5260 Mode: X Flg:0x0 Ref:1 Life:02000000 SPID:52 ECID:0
SPID: 52 ECID: 0 Statement Type: SELECT Line #: 1
Input Buf: Language Event: select * from a (tablockx)Requested By:
ResType:LockOwner Stype:'OR' Mode: X SPID:51 ECID:0 Ec:(0x1c657890) Value:0x1c3b51c0 Cost:(0/0)Node:2
TAB: 2:1993058136 [] CleanCnt:1 Mode: X Flags: 0x0
Grant List::
Owner:0x1c3b52e0 Mode: X Flg:0x0 Ref:1 Life:02000000 SPID:51 ECID:0
SPID: 51 ECID: 0 Statement Type: SELECT Line #: 1
Input Buf: Language Event: select * from b (tablockx)Requested By:
ResType:LockOwner Stype:'OR' Mode: X SPID:52 ECID:0 Ec:(0x1c593890) Value:0x1c3b5380 Cost:(0/0)
Victim Resource Owner:
ResType:LockOwner Stype:'OR' Mode: X SPID:52 ECID:0 Ec:(0x1c593890) Value:0x1c3b5380 Cost:(0/0)
ok
Posted by: Valium Side Effects on Mayo 24, 2004 01:39 PMVitam impendere vero - To risk one's life for the truth
Praetio prudentia praestat - Prudence supplies a reward
Non sum qualis eram - I am not what / of what sort I was (I'm not what I used to be.)
Variatio delectat - There's nothing like change! (Cicero)
Credo nos in fluctu eodem esse - I think we're on the same wavelength
Impossibilium nulla obligatio est - Nobody has any obligation to the impossible. (Corpus Iuris Civilis)
Quod erat faciendum - Which was to be done
Gloria virtutis umbra - Glory (is) the shadow of virtue
Credo ut intelligam - I believe in order that I may understand. (St. Augustine)
Exitus acta probat - The outcome proves the deeds (the end justifies the means) (Ovid)
Felix qui potuit rerum cognoscere causas - Happy is he who has been able to learn the causes of things. (Vergil)
Quid rides? Mutato nomine de te fabula narratur - Why do you laugh? Just change the name and the tale is told of you. (Horace)
Quod erat faciendum - Which was to be done
Nemo liber est qui corpori servit - No one is free who is a slave to his body
Esto Perpetua - Let it be forever
Et tu, Brute - You too, Brutus (Caesar's last words)
Amor animi arbitrio sumitur, non ponitur - We choose to love, we do not choose to cease loving. (Syrus)
Free clip bbw porn young fat teen plump mature ass, black bbw sex young fat teen. Lesbian fucking pussy with big boob movie fat hardcore sex big natural tit, fat teen pic free big tit fuck. Lip plumper sale fat sexy woman pic hot fat moms mature bbw, hot fat ass gorgeous big boobies. Mature fat women big tit teen, free bbw sex pic fat ass pussy fat porn. Huge cum soaked tits big boob, fat porn mature plump sex big tit round ass. Big tit brunette fuck amateur fat teen, large teen tit fat granny hardcore anal chick fat. Hot fat moms chubby teen dog fat free hot, fat teen porn. Lanas big boob huge boobs cowgirl fat woman photos bbw movie, teen boob bbw sex video fat teen porn. Groovy busty blonde fat pussy large black tit, big tit asian fuck extra large tit hot fat girl. Big fat sexy woman bbw pic post hot fat ass chubby teen, free fat porn video. Porn pic gallery bbw sexy fat ass fat anal sex fat woman photos, fat girl. Fat bottom girl free fat mature porn lip plumper sale, fat sexy man. Plumper tit plump mature gallery plumper pic big natural tit fuck, small boob. Anal chick fat fat sexy chick, fat granny hardcore. Fat girl free fat mature porn woman with large tit big tit fuck, mature pic plump. Mature plump tgp bbw porn star, fat pussy bbw sex pic free big tit pic. Fat porn hot fat babes black boob, fat sexy man free pic of large tit. Fat teen pussy fat sexy old woman teen boob free large tit, bbw porn free fat black porn. Large asian tit large black tit bbw porn, big boob bbw chat.
Posted by: fat black sexy woman on Octubre 20, 2004 12:00 AM7402 http://www.slots-big.com slots
online casinos
poker online.
internet poker
online poker
online poker
7338 http://texas-holdem.ownsthis.com texas holdem
Posted by: texas holdem on Octubre 26, 2004 06:44 AM3082 http://www.online-casino-one.com
online casino
craps
5449 http://www.blackjack-1000.com
PlLAY the best blackjack-1000.com
debt consolidation only.
382 jobs online part time jobs work online work online from home work at home work from home online jobs work at home jobs work at home business jobs
Full time jobs dental plan dental
insurance
dental insurance
plan
discount dental
plans
cheap dental
plans
individual dental
plans
1970 .Way to poker online.
6832 http://www.i--cialis.net
Offering Cialis with overnight delivery. Also, If your looking for generic cialis this is a good site to visit. Hurt yourself Tramadol or trying to shrink your fat ass use Adipex Need Wood? try Generic Viagra too
6521 Offering online casino with overnight delivery. Also, If your looking for casino online this is a good site to visit.
Posted by: online casino on Octubre 28, 2004 10:16 PM4527 http://www.777-blackjack.com
online blackjack
blackjack
1964
this is a great plae to play texas holdem online. feel free to try out the http://texas-holdem-a.fateback.com for big bonuses! texas holdem poker
3426 phenterminedebt consolidation
Posted by: debt consolidation on Octubre 30, 2004 02:33 PM3904 http://video-poker.ownsthis.com
this is a site for video poker. kick back, relax and online video poker.
Posted by: video poker on Octubre 31, 2004 09:14 AM5096 http://www.e-slots.info slots click here to play
online slots
302 http://www.online-casinos-w.com
online casinos
2784 http://texas-hold-em-w.fateback.com
texas hold em
online texas hold em
4890 http://texas-hold-em-w.fateback.com
texas hold em
online texas hold em
3011 Ttry playing online pokeronline.
Posted by: poker on Noviembre 2, 2004 10:41 PM6183 Kona Coffee Starbucks Coffee Jamaica Blue Mountain
Coffee
coffee maker gourmet coffee green mountain coffee kenya coffee organic coffee specialty coffee folgers coffee coffee brewers costa rica coffee Tullys Coffee Millstone Coffee coffee grinder http://www.coffee-delivered.com