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

Re: Postgresql Server Restart continuously

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 (view raw or flat)
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

In response to

pgsql-admin by date

Next:From: kris palDate: 2004-08-30 15:41:58
Subject: Re: pg_attribute - Index
Previous:From: Tom LaneDate: 2004-08-28 16:27:58
Subject: Re: Compatibility between different versions of psql client and postgresql server

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