Return-Path: owner-postman Received: from localhost (localhost [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.3/8.6.3) with SMTP id JAA11266 for postgres-dist; Wed, 10 Nov 1993 09:55:32 -0800 Resent-From: POSTGRES mailing list Resent-Message-Id: <199311101755.JAA11266@nobozo.CS.Berkeley.EDU> Sender: owner-postman@postgres.Berkeley.EDU X-Return-Path: owner-postman Received: from localhost (localhost [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.3/8.6.3) with SMTP id JAA11257; Wed, 10 Nov 1993 09:55:31 -0800 Message-Id: <199311101755.JAA11257@nobozo.CS.Berkeley.EDU> X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost didn't use HELO protocol From: aoki@postgres.Berkeley.EDU (Paul M. Aoki) To: Joergen Haegg Cc: postgres@postgres.Berkeley.EDU Subject: Re: locking in postgres 4.1 In-reply-to: Your message of Tue, 09 Nov 1993 13:13:04 MET Date: Wed, 10 Nov 93 09:55:31 -0800 X-Sender: aoki@postgres.Berkeley.EDU Resent-To: postgres-dist@postgres.Berkeley.EDU X-Mts: smtp Resent-Date: Wed, 10 Nov 93 09:55:31 -0800 Resent-XMts: smtp Joergen Haegg writes: > Process A: > spog > begin > Process B: > spog > begin > Process A: > spog > retrieve (testa2.all) > spog > replace testa2(nn=3D11111) where testa2.u =3D "323" > REPLACE successful > Process B: > spog > retrieve (testa2.all) > 323 11111 > spog > retrieve (testa2.all) > NOTICE:Nov 9 13:08:35:Timeout -- possible deadlock > WARN:Nov 9 13:08:35:WaitOnLock: error on wakeup - Aborting this transacti= if the A replace happens before the B retrieves, the B retrieves should hang until A commits. if the A replace happens after the B retrieves, A should hang until B commits. try it again and see if this is not the case. if not, send mail to bug-postgres. -- Paul M. Aoki | CS Div., Dept. of EECS, UCB | aoki@postgres.Berkeley.EDU | Berkeley, CA 94720 | ...!uunet!ucbvax!aoki