Re: How to handle deadlocks ?

Okay guys let's think here. I have it exclusive you want it to READ and you do not HAVE a wait TIME SET. So what do you get "SORRY READER" your request can not happen because it's being used exclusivly ("LOCKED"). Check into Isolation Mode and the SET LOCK MODE command! ------------------------------------------------------------------------- Cheryl Kendricks Internet:cherylk@prod1.jcdc.doleta.gov OR cherylk@gwysmtp.jcdc.doleta.gov DTSI, Inc. Database Administrator - DOL Job Corps San Marcos, Texas ------------------------------------------------------------------------ On 19 Jun 1996, Patrick A. O'Donnell wrote: } In article <4q4tap$hum@dfw-ixnews7.ix.netcom.com> enelson3@ix.netcom.com(Eric D Nelson) writes: } Date: 18 Jun 1996 00:30:17 GMT } From: enelson3@ix.netcom.com(Eric D Nelson) } } I have also encountered deadlocks while doing a select. I didn't think } this would be possible. } } I, too, though deadlocks from a select shouldn't happen. Once I saw } it, however, I realized that it was easy: the select acquires shared } locks, which could be acquired in a different order from an updater's } exclusive locks --- deadlock. It is still true that readers should } never deadlock against each other. } } - Pat }