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