agora inbox for postgres@postgres.berkeley.edu
help / color / mirror / Atom feedFrom: I. Ahmad <ima@juno.cs.wayne.edu>
To: postgres@postgres.Berkeley.EDU
Subject: Why I am getting 'no response from backend message'?
Date: Sat, 29 Oct 1994 00:25:29 -0400 (EDT)
Message-ID: <Pine.3.89.9410290023.A4123-0100000@aphrodite.cs.wayne.edu> (raw)
Hi everyone:
I am using postgres version 4.2 on Sun Sparc running SUN OS 4.1.3. So far I
was having no problem in using postgres. Somehow couple of days back the
server running the posmaster got crashed. The system administrator restarted
the machine and I (as postgres) restarted the postmaster after doing
ipcclean etc. and since then I am getting strange behaviour from postgres.
If I try to retrieve tuples from a given class into some temporary class from
the monitor, I am getting the following message:
Go
* retrieve into cap_temp (agents.all) \g
Query sent to backend is "retrieve into cap_temp (agents.all) "
FATAL: no response from backend: detected in PQexec
I can clearly see the postmaster process in existance through the ps command.
and seems to be working fine since if I issue the following query, the
system produces the correct output.
* retrieve (agents.all) \g
I am getting similar message even if I try to create a new class or delete
some existing class.
Any idea what is wrong. All the environment variables are as they were before
when system was working O.K. I am gettin similar response even if I start
monitor on the machine running the postmaster.
I will appreciate any response.
-------------------------------------------------------------------------------
, ,
/( )`
\ \___ / |
/- _ `-/ '
(/\/ \ \ /\ Imran Ahmad
/ / | ` \ Dept. of Computer Science
O O ) / | 431 State Hall
`-^--'`< ' Wayne State University
\\///// (_.) _ ) / Detroit, MI 48201
\\\////// `.___/` / Phone: (313)577-6771
\ ^ ^ / `-----' /
( @ @ ) <----. __ / __ \
o <----|====O)))==) \) /==== email: ima@cs.wayne.edu
^ <----' `--' `.__,' \
.--\_/--. (> | |
' ' // \ /
' '' ______( (_ / \______
'----------' ,' ,-----' | \
`--{__________) \/
-------------------------------------------------------------------------------
==============================================================================
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.
==============================================================================
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: postgres@postgres.berkeley.edu
Cc: ima@juno.cs.wayne.edu
Subject: Re: Why I am getting 'no response from backend message'?
In-Reply-To: <Pine.3.89.9410290023.A4123-0100000@aphrodite.cs.wayne.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox