| From: | Michael Guerin <guerin(at)rentec(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: cache lookup failed for relation |
| Date: | 2004-09-28 12:38:33 |
| Message-ID: | 41595B49.5090200@rentec.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
The error jdbc is catching is:
Caused by: org.postgresql.util.PSQLException: ERROR: cache lookup failed for relation 357272221
when executing:
select * into temp table t from fnGetCompositeIds2(4130059995);
The unfortunate thing is that its not reproducible in psql, and only
shows up when a number of clients are going against the database. I'll
dig further for more information.
thanks
michael
Tom Lane wrote:
>Michael Guerin <guerin(at)rentec(dot)com> writes:
>
>
>>Last night our server crashed and now we're getting these cache lookup
>>errors.
>>
>>
>
>"These" being what exactly? Let's see verbose error output (psql
>\set VERBOSITY verbose), or even better a stack traceback from
>errfinish.
>
> regards, tom lane
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-09-28 14:04:26 | Re: Cannot start PostgreSQL |
| Previous Message | Reinhard Hnat | 2004-09-28 05:12:20 | Cannot start PostgreSQL |