Return-Path: owner-postman
Received: from localhost.Berkeley.EDU (localhost.Berkeley.EDU [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.9/8.6.3) with SMTP id AAA21771 for postgres-redist; Wed, 19 Oct 1994 00:20:41 -0700
Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199410190720.AAA21771@nobozo.CS.Berkeley.EDU>
X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost.Berkeley.EDU didn't use HELO protocol
Sender: owner-postman@postgres.Berkeley.EDU
X-Return-Path: owner-postman
Received: from ss1.digex.net (ss1.digex.net [164.109.20.3]) by nobozo.CS.Berkeley.EDU (8.6.9/8.6.3) with SMTP id AAA21761 for <postgres@nobozo.CS.Berkeley.EDU>; Wed, 19 Oct 1994 00:20:40 -0700
Received: by ss1.digex.net id AA26023
  (5.67b8/IDA-1.5 for postgres@nobozo.CS.Berkeley.EDU); Wed, 19 Oct 1994 03:20:37 -0400
Date: Wed, 19 Oct 1994 03:20:37 -0400
From: Mike Doughney <mike@ss1.digex.net>
Message-Id: <199410190720.AA26023@ss1.digex.net>
To: postgres@postgres.Berkeley.EDU
Cc: mcguire@ss1.digex.net, mike@ss1.digex.net
Subject: Timeout on deadlock
Resent-To: postgres-redist@postgres.Berkeley.EDU
Resent-Date: Wed, 19 Oct 94 00:20:41 -0700
Resent-XMts: smtp


I've been having considerable difficulty with postgres locking up when
two programs are attempting to access the same database at the same
time.  I've written two programs, one is a batch process which is
retrieving and appending records, the other an interactive program
that performs only retrievals.  When I attempt to do interactive
retrievals at the same time the batch is running I frequently receive
these types of messages from one or the other process (and
occasionally both):

: NOTICE:Oct 19 03:06:33:Timeout -- possible deadlock
: WARN:Oct 19 03:06:33:WaitOnLock: error on wakeup - Aborting this transaction

On one occasion the batch process simply quit entirely with this
message, which I gather is from PQexec:

: Error: No response from the backend, exiting...

On one other occasion the batch process repeatedly timed out until my
program quit trying (after 5 tries) and exited; the retries continued
after the interactive program was finished.

The batch process is using a begin/end block for every input record;
each input record generates anywhere from 5 to 50 appends and a number
of retrievals.

Postgres version is 4.1 running under SunOS 4.1.3 with Kerberos
authentication.  I'm using pgperl.

Any suggestions, fixes, patches, etc. much appreciated.


==============================================================================
   To add/remove yourself to/from the POSTGRES mailing list: send mail with 
   the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU"

   If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
   a human will deal with it.  DO NOT post to the "postgres" mailing list.
==============================================================================