Skip site navigation (1) Skip section navigation (2)

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

From: "tamanna madaan" <tamanna(dot)madan(at)globallogic(dot)com>
To: <pgsql-odbc(at)postgresql(dot)org>
Cc: "Gaurav Katiyar" <gaurav(dot)katiyar(at)globallogic(dot)com>
Subject: "No response from the backend" error while connecting to postgres db
Date: 2009-09-16 08:44:19
Message-ID: 68666423656E1444A011106C4E085F4D9DB05C@ex3-del1.synapse.com (view raw or flat)
Thread:
Lists: pgsql-odbc
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=1310723) failed: Invalid argument

GMT FATAL:  semop(id=1310723) 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

Responses

pgsql-odbc by date

Next:From: the6campbellsDate: 2009-09-17 12:07:52
Subject: bug in sqlDescribeCol for the result set returned by a stored procedure
Previous:From: Rohan JamadagniDate: 2009-09-16 05:18:50
Subject: Not able to connect from Informatica

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group