Re: How to handle deadlocks ?
Posted in 1996
Patrick A. O'Donnell — — source: Informix-list mailing list archive (1991-1998)
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