| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | alvaro(at)audifarma(dot)com(dot)co |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Postgresql Server Restart continuously |
| Date: | 2004-08-28 16:54:15 |
| Message-ID: | 20319.1093712055@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | kris pal | 2004-08-30 15:41:58 | Re: pg_attribute - Index |
| Previous Message | Tom Lane | 2004-08-28 16:27:58 | Re: Compatibility between different versions of psql client and postgresql server |