Return-Path: owner-postman Received: from localhost.Berkeley.EDU (localhost.Berkeley.EDU [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.10/8.6.3) with SMTP id LAA13382 for postgres-redist; Wed, 8 Mar 1995 11:43:50 -0800 Resent-From: POSTGRES mailing list Resent-Message-Id: <199503081943.LAA13382@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 homer17.u.washington.edu (homer17.u.washington.edu [140.142.76.1]) by nobozo.CS.Berkeley.EDU (8.6.10/8.6.3) with SMTP id LAA13372 for ; Wed, 8 Mar 1995 11:43:49 -0800 Received: by homer17.u.washington.edu (5.65+UW95.02/UW-NDC Revision: 2.32 ) id AA92887; Wed, 8 Mar 95 11:43:44 -0800 X-Sender: wei@homer17.u.washington.edu Date: Wed, 8 Mar 1995 11:43:44 -0800 (PST) From: Xinguo Wei To: postgres Subject: Dead backend.... Message-Id: Mime-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Resent-To: postgres-redist@postgres.Berkeley.EDU Resent-Date: Wed, 08 Mar 95 11:43:50 -0800 Resent-XMts: smtp Hi, this is a follow-up on the problem I posted two days ago regrading a user-defined function does not return sometimes. In order to see what is going on, I turned on the debugging switch on the postmaster. Here is what I got, If the function can be executed suceefully, i will see the message from postmaster as follows, postmaster: ServerLoop: 1 sockets pending postmaster: ServerLoop: connect on 4 .... .... InitPostgres().. postmaster: reaping dead processes... postmaster: CleanupProc: pid 11288 exited with status 0 At meantime, backend also spits out a lot messages about the query processing and the last two messages are, ProcessQuery() at Wed Mar 8 11:20:44 1995 CommitTransactionCommand() at Wed Mar 8 11:20:44 1995 If the function can't not be executed, the postmaster will hangup right after the message "InitPostgres()..". And the previous backend server will not be killed. I made a rather small function for this test, and it will die at about the 13th (or higher) run. What should I approach from here? Thank you very much. Xinguo ============================================================================== 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. ============================================================================== URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/