Hi,
Thanks a lot to all of you for your help, after long nigths looking at the
log files for a possible cause, we find out that this error condition
refered to some kind of problem with the SCSI array controller (hardware)
that was not reported by the watchdog program installed by the hardware
provider, -the control panel always indicated that everything was ok, we
run some special tests and nothing unusual was reported by that time...-,
and last week the server completly froze and we were able to see an error
message pointing to that specific device, our provider replace the
controller immediately, by now the error reported by the postgresql server
does not appear anymore.
Special Thanks to Mr. Tom Lane for your concern since we post a message
for first time.
Alvaro
alvaro ( at ) audifarma ( dot ) com ( dot ) co writes:
> I'm having some strange problem with a server postgresql 7.4.3, some times
> the server crashes and restarts inmediatly, heres is the error message
> catch from the log file
> ERROR: cache lookup failed for namespace 105183855
> LOG: server process (PID 3942) exited with exit code 1
I have a suspicion that this has something to do with trying to delete
temp tables during backend exit, but it's not going to be possible to
find it without a lot more detail. You might try turning on query
logging so you can see exactly what the failed process did before
crashing.
regards, tom lane
regards, tom lane