Return-Path: owner-postman Received: from localhost (localhost [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id BAA12594 for postgres-dist; Fri, 12 Nov 1993 01:15:47 -0800 Resent-From: POSTGRES mailing list Resent-Message-Id: <199311120915.BAA12594@nobozo.CS.Berkeley.EDU> Sender: owner-postman@postgres.Berkeley.EDU X-Return-Path: owner-postman Received: from faerie.CS.Berkeley.EDU (faerie.CS.Berkeley.EDU [128.32.149.14]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with ESMTP id BAA12585 for ; Fri, 12 Nov 1993 01:15:47 -0800 Received: from localhost (localhost [127.0.0.1]) by faerie.CS.Berkeley.EDU (8.6.3/8.1B) with SMTP id BAA03976; Fri, 12 Nov 1993 01:15:20 -0800 Message-Id: <199311120915.BAA03976@faerie.CS.Berkeley.EDU> X-Authentication-Warning: faerie.CS.Berkeley.EDU: Host localhost didn't use HELO protocol From: aoki@postgres.Berkeley.EDU (Paul M. Aoki) To: gvkravet@king.mcs.drexel.edu (Victor Kravets) Cc: postgres@postgres.Berkeley.EDU Subject: Re: no response for a query In-reply-to: Your message of Fri, 12 Nov 93 01:15:47 EST <9311120615.AA02519@mcs.drexel.edu> Date: Fri, 12 Nov 93 01:15:20 -0800 X-Sender: aoki@postgres.Berkeley.EDU Resent-To: postgres-dist@postgres.Berkeley.EDU X-Mts: smtp Resent-Date: Fri, 12 Nov 93 01:15:47 -0800 Resent-XMts: smtp gvkravet@king.mcs.drexel.edu (Victor Kravets) writes: > * \g > Query sent to backend is " > And then no response at all.However, ps indicates th that there is > a postgres process running for each query I made long time ago and still > waitining for a result: to fix the immediate problem, become the "postgres" user and use the unix kill command. if you can't become "postgres" (or root), ask your sysadmin to do it. i haven't seen this recently. if you are not running 4.1 (and your previous message indicates that you were using the pre-4.1 environment variable POSTGRESHOME), upgrade. if you *are* running postgres 4.1, do % kill -ILL 26651 (or whatever the process id is) and send us a dbx stack trace from the core (which will be dumped in .../data/base/foo). also specify what your environment is. -- Paul M. Aoki | CS Div., Dept. of EECS, UCB | aoki@postgres.Berkeley.EDU | Berkeley, CA 94720 | ...!uunet!ucbvax!aoki