This would tell me that you have two programs running: Session 1 locks Record A Session 2 locks Record B Session 1 WANTS to lock Record B, and holds, awaiting the lock release Session 2 NOW Wants to lock Record A - if this happens, DEADLOCKS occurs - neither program will ever be able to progress.
The system detects this, and kills Session 2 'for the good of all' - used to be 'in the old days' you'd just have two sessions sitting there forever Your best way to prevent Deadlocks is to ensure programs ALL lock files in the same order. In this example, Session 1's program locked A then B, while Session 2's propgram locked B, then A. That's a deadlock waiting to happen. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of kafsat taiyus Sent: Monday, March 29, 2004 12:26 AM To: 'U2 Users Discussion List' Subject: SB error Hi, In a Unidata 5.2 SB+ plus environment running on Tru64 UNIX we are occasionally receiving following error. Fatal: deadlock will occur if this request of lock wait in the queue. File name: /file/NAME, inum: 57907, dev: -251488945, key: 136445950 Do anyone know why is this happening and how to fix it? Regards, Kafsat Taiyus This email and any attachments are confidential and intended solely for the use of the person or entity to whom they are addressed. If you are not the intended recipient, please do not disclose, store, copy or take any action in reliance on it or them. If you have received this message in error, please tell us by reply email (or telephone + 61 (0) 3 9274 9100) and delete all copies on your system. Any opinion, advice or information in this email is not necessarily that of the owners or officers of this company. Please advise us immediately if you or your employer do not consent to email for messages of this type. Retail Decisions has taken reasonable precautions to ensure that any attachment to this email has been swept for viruses. However, we cannot accept any liability for any damage sustained as a result of software viruses, and would advise that you carry out your own virus checks before opening any attachment. Please note that communications sent by or to any person through our computer system may be viewed by other Retail Decisions employees or officers strictly in accordance with law. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users