How to force a deadlock
Eric
Date: 11/24/04
- Next message: Eric: "Re: How to force a deadlock"
- Previous message: David Cross [MS]: "Re: What to do with certificates when profile is deleted/recreated?"
- Next in thread: Eric: "Re: How to force a deadlock"
- Reply: Eric: "Re: How to force a deadlock"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 24 Nov 2004 08:35:33 -0600
Greetings,
We periodically get reports of record deadlocks, so we added Try...Catch
error handling in our ASP.NET application to fail gracefully. However, we
cannot test the error handling because we do not know how to force a
deadlock.
We have already tried this:
ASP.NET Application:
1. Go to screen with desired record
Query Analyzer:
2. Begin transaction
3. Update a record
ASP.NET Application:
4. Try to update that same record
Query Analyzer:
5. Commit transaction
When we do this, though, we just get a timeout expiration on step four.
Does anyone know how to do this?
Many thanks!
Eric
- Next message: Eric: "Re: How to force a deadlock"
- Previous message: David Cross [MS]: "Re: What to do with certificates when profile is deleted/recreated?"
- Next in thread: Eric: "Re: How to force a deadlock"
- Reply: Eric: "Re: How to force a deadlock"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
