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 WAA11433 for postgres-dist; Thu, 11 Nov 1993 22:19:02 -0800 Resent-From: POSTGRES mailing list Resent-Message-Id: <199311120619.WAA11433@nobozo.CS.Berkeley.EDU> X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost didn't use HELO protocol Sender: owner-postman@postgres.Berkeley.EDU X-Return-Path: owner-postman Received: from mcs.drexel.edu (king.mcs.drexel.edu [129.25.7.10]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id WAA11424 for ; Thu, 11 Nov 1993 22:19:01 -0800 Received: by mcs.drexel.edu (4.1/SMI-4.0) id AA02519; Fri, 12 Nov 93 01:15:47 EST Date: Fri, 12 Nov 93 01:15:47 EST From: gvkravet@king.mcs.drexel.edu (Victor Kravets) Message-Id: <9311120615.AA02519@mcs.drexel.edu> To: postgres@postgres.Berkeley.EDU Subject: no response for a query Resent-To: postgres-dist@postgres.Berkeley.EDU Resent-Date: Thu, 11 Nov 93 22:19:02 -0800 Resent-XMts: smtp Dear Sir/Madam, I have just ran into a problem which does not let me recieve any result for a query I make. Here is the typical situation: king% monitor foo Welcome to the C POSTGRES terminal monitor Go * \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: ps -guxa | head USER PID %CPU %MEM SZ RSS TT STAT START TIME COMMAND gvkravet 2452 30.8 1.8 240 552 p4 R 00:57 0:00 ps -guxa postgres 2433 4.7 3.7 1368 1152 ? R N 00:52 0:28 /usr2/postgres/bin/postg postgres 26725 4.7 0.1 1368 32 ? R N 19:38 29:42 /usr2/postgres/bin/postg postgres 27751 4.3 0.1 1368 32 ? R N 20:24 24:11 /usr2/postgres/bin/postg postgres 26697 4.3 0.1 1368 32 ? R N 19:36 30:22 /usr2/postgres/bin/postg postgres 27033 4.3 0.1 1368 32 ? R N 19:53 27:15 /usr2/postgres/bin/postg postgres 26996 4.3 0.1 1368 32 ? R N 19:52 27:16 /usr2/postgres/bin/postg postgres 26957 3.5 0.1 1368 32 ? R N 19:48 27:51 /usr2/postgres/bin/postg postgres 26651 3.1 0.1 1368 32 ? R N 19:34 31:20 /usr2/postgres/bin/postg king% I can't recall what caused this behavior. It might have started after I have typed '^C' while in monitor. I also remember warning about cache. I guess my question is, if there is a way to remove this processes without being a superuser? And is there anything can be done to prevent this in future? Thank you very much for your time. Sincerely, Victor Kravets