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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | the6campbells | 2009-09-17 12:07:52 | bug in sqlDescribeCol for the result set returned by a stored procedure |
Previous Message | Rohan Jamadagni | 2009-09-16 05:18:50 | Not able to connect from Informatica |