Re: could not open relation - why?

Поиск
Список
Период
Сортировка
От Harald Armin Massa
Тема Re: could not open relation - why?
Дата
Msg-id 7be3f35d0608070641n261fd5dev49154580602ad88b@mail.gmail.com
обсуждение исходный текст
Ответ на Re: could not open relation - why?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: could not open relation - why?
Список pgsql-general
> 2006-08-07 13:20:27 LOG:  autovacuum: processing database "template1"
> 2006-08-07 13:20:47 ERROR:  could not open relation with OID 311438
> 2006-08-07 13:21:52 LOG:  autovacuum: processing database "postgres"

The easiest explanation is that someone dropped a table just as
autovacuum was trying to open it.  

I am not quite sure that "autovacuum" was trying to open, as some user reported the same error on his system ( and he is definitely not mr. Autovacuum :)

>The above trace suggests that
you're actively changing template1, which is probably not good
practice ...
Not even in my wildest dreams would I dare to actively change template1. Amd the database users in question do not have permissions on template1; so I am quite confident no wrongrunning software does it.

What indeed happens alot in this database is the creation and the dropping of temp tables (the later automagically at the end of a connection, I assume)

Is there a way to learn to which dropped table OIDs belong, or is all gone after dropping and autovacuum ?

Harald


--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
-
Let's set so double the killer delete select all.

В списке pgsql-general по дате отправления:

Предыдущее
От: "kevin.huang"
Дата:
Сообщение: does pgsql downloading mirror sites work?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: could not open relation - why?