ERROR: cache lookup failed for relation
От | Michael Guerin |
---|---|
Тема | ERROR: cache lookup failed for relation |
Дата | |
Msg-id | 419BD423.2030600@rentec.com обсуждение исходный текст |
Список | pgsql-novice |
Hi, Our database restarted sometime this morning and now the log is reporting this error "ERROR: cache lookup failed for relation 2029055522". I was able to isolate the sql statement that causes this error, however, I was only able to re-produce the error once and then crashed the postmaster when trying to debug the process :( Also, I should note that when I reproduced the error, one psql sesssion caused this error, while another psql session executing the same statement worked fine.. Both were fresh ssessions. This is the statement that gets executed. LOG: statement: select * into temp table t from fnGetCompositeIds2(5825634844); It seems to only happen with a routine that deals with temporary tables, the function uses temp tables too. Vacuum completes without errors, I've re-indexed all system tables and user tables and postgresql was restarted. Sorry about the lack of info, just checking to see if anyone has any comments about how to track down this problem... pg version is "PostgreSQL 8.0.0beta3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.2" thanks michael
В списке pgsql-novice по дате отправления: