"No response from the backend" error while connecting to postgres db

This is a multi-part message in MIME format.

------_=_NextPart_001_01CA36A9.E216E6D1
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi All

I am getting error "No response from the backend" while connecting to my
postgres database.

pg_log file logs the below messages :

GMT FATAL: semop(id=3D1310723) failed: Invalid argument

GMT FATAL: semop(id=3D1310723) failed: Invalid argument

GMT FATAL: semctl(1310723, 7, SETVAL, 0) failed: Invalid argument

GMT FATAL: semctl(1310723, 12, SETVAL, 0) failed: Invalid argument

GMT LOG: server process (PID 10776) exited with exit code 1

GMT LOG: terminating any other active server processes

GMT WARNING: terminating connection because of crash of another server
process

GMT DETAIL: The postmaster has commanded this server process to roll
back the current transaction and exit, because another server proc

ess exited abnormally and possibly corrupted shared memory.

GMT HINT: In a moment you should be able to reconnect to the database
and repeat your command.

The above message is printed a number of times and after that it prints

GMT LOG: all server processes terminated; reinitializing

GMT LOG: semctl(1245185, 0, IPC_RMID, ...) failed: Invalid argument

GMT LOG: semctl(1277954, 0, IPC_RMID, ...) failed: Invalid argument

GMT LOG: semctl(1310723, 0, IPC_RMID, ...) failed: Invalid argument

GMT LOG: semctl(1343492, 0, IPC_RMID, ...) failed: Invalid argument

GMT LOG: shmctl(2097152, 0, 0) failed: Invalid argument

GMT LOG: database system was interrupted at 2009-09-15 07:28:40 GMT

GMT LOG: checkpoint record is at A/2311BA94

GMT LOG: redo record is at A/23106A14; undo record is at 0/0; shutdown
FALSE

GMT LOG: next transaction ID: 20175128; next OID: 58650

GMT LOG: next MultiXactId: 1; next MultiXactOffset: 0

GMT LOG: database system was not properly shut down; automatic recovery
in progress

GMT LOG: redo starts at A/23106A14

GMT LOG: record with zero length at A/2317BF50

GMT LOG: redo done at A/2317BF28

GMT FATAL: the database system is starting up

GMT LOG: database system is ready

The postgresql log file doesn't print anything about restarting
postgres. I couldn't get any information from other logs regarding which
process was killed, who killed it and why.

Please help.

Thanks...

Tamanna

------_=_NextPart_001_01CA36A9.E216E6D1
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<style>

</style>

</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

Hi All<o:p></o:p>

<o:p> </o:p>

I am getting error “No response from the =
backend”
while connecting to my postgres database.<o:p></o:p>

<o:p> </o:p>

pg_log file logs the below messages =
:<o:p></o:p>

<o:p> </o:p>

GMT FATAL: semop(id=3D1310723) failed: Invalid =
argument<o:p></o:p>

GMT FATAL: semop(id=3D1310723) failed: Invalid =
argument<o:p></o:p>

GMT FATAL: semctl(1310723, 7, SETVAL, 0) =
failed:
Invalid argument<o:p></o:p>

GMT FATAL: semctl(1310723, 12, SETVAL, 0) =
failed:
Invalid argument<o:p></o:p>

GMT LOG: server process (PID 10776) exited with =
exit
code 1<o:p></o:p>

GMT LOG: terminating any other active server =
processes<o:p></o:p>

GMT WARNING: terminating connection because of =
crash
of another server process<o:p></o:p>

GMT DETAIL: The postmaster has commanded this =
server
process to roll back the current transaction and exit, because another =
server
proc<o:p></o:p>

ess exited abnormally and possibly corrupted shared =
memory.<o:p></o:p>

GMT HINT: In a moment you should be able to =
reconnect
to the database and repeat your command.<o:p></o:p>

<o:p> </o:p>

The above message is printed a number of times and =
after
that it prints <o:p></o:p>

<o:p> </o:p>

GMT LOG: all server processes terminated;
reinitializing<o:p></o:p>

GMT LOG: semctl(1245185, 0, IPC_RMID, ...) =
failed:
Invalid argument<o:p></o:p>

GMT LOG: semctl(1277954, 0, IPC_RMID, ...) =
failed:
Invalid argument<o:p></o:p>

GMT LOG: semctl(1310723, 0, IPC_RMID, ...) =
failed:
Invalid argument<o:p></o:p>

GMT LOG: semctl(1343492, 0, IPC_RMID, ...) =
failed:
Invalid argument<o:p></o:p>

GMT LOG: shmctl(2097152, 0, 0) failed: Invalid
argument<o:p></o:p>

GMT LOG: database system was interrupted at =
2009-09-15
07:28:40 GMT<o:p></o:p>

GMT LOG: checkpoint record is at =
A/2311BA94<o:p></o:p>

GMT LOG: redo record is at A/23106A14; undo =
record is
at 0/0; shutdown FALSE<o:p></o:p>

GMT LOG: next transaction ID: 20175128; next =
OID:
58650<o:p></o:p>

GMT LOG: next MultiXactId: 1; next =
MultiXactOffset: 0<o:p></o:p>

GMT LOG: database system was not properly shut =
down;
automatic recovery in progress<o:p></o:p>

GMT LOG: redo starts at =
A/23106A14<o:p></o:p>

GMT LOG: record with zero length at =
A/2317BF50<o:p></o:p>

GMT LOG: redo done at =
A/2317BF28<o:p></o:p>

GMT FATAL: the database system is starting =
up<o:p></o:p>

GMT LOG: database system is ready =
<o:p></o:p>

<o:p> </o:p>

<o:p> </o:p>

The postgresql log file doesn’t print anything =
about restarting
postgres. I couldn’t get any information from other logs regarding =
which
process was killed, who killed it and why.<o:p></o:p>

<o:p> </o:p>

Please help.<o:p></o:p>

<o:p> </o:p>

Thanks…<o:p></o:p>

Tamanna<o:p></o:p>

</div>

</body>

</html>

------_=_NextPart_001_01CA36A9.E216E6D1--

"No response from the backend" error while connecting to postgres db

Re: "No response from the backend" error while connecting to postgres db