VACUUM on database with open transaction returns error?

Поиск
Список
Период
Сортировка
От Allan Engelhardt
Тема VACUUM on database with open transaction returns error?
Дата
Msg-id 3B7831EA.4F3C8309@cybaea.com
обсуждение исходный текст
Ответы Re: VACUUM on database with open transaction returns error?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
In one window connect with psql to the database 'test' and execute


     test=# begin transaction;

In another window as the postgrs user do


     bash-2.04$ vacuumdb -z -a
     Vacuuming www
     VACUUM
     Vacuuming template1
     NOTICE:  RegisterSharedInvalid: SI buffer overflow
     NOTICE:  InvalidateSharedInvalid: cache state reset
     VACUUM
     Vacuuming test
     VACUUM
     Vacuuming photo
     VACUUM

     bash-2.04$ vacuumdb -z -a
     Vacuuming www
     NOTICE:  RegisterSharedInvalid: SI buffer overflow
     NOTICE:  InvalidateSharedInvalid: cache state reset
     VACUUM
     Vacuuming template1
     VACUUM
     Vacuuming test
     VACUUM
     Vacuuming photo
     NOTICE:  RegisterSharedInvalid: SI buffer overflow
     NOTICE:  InvalidateSharedInvalid: cache state reset
     VACUUM

     bash-2.04$ vacuumdb -z -a
     Vacuuming www
     VACUUM
     Vacuuming template1
     VACUUM
     Vacuuming test
     VACUUM
     Vacuuming photo
     NOTICE:  RegisterSharedInvalid: SI buffer overflow
     NOTICE:  InvalidateSharedInvalid: cache state reset
     VACUUM

     bash-2.04$

Back in the first window do:


     test=# COMMIT ;
     NOTICE:  InvalidateSharedInvalid: cache state reset
     COMMIT

OK, what gives?

1. Should I worry about these messages at all?

2. Is it supported to VACUUM a database with open transactions?
    If not: what am I suppoed to do?

3. Why does the NOTICE move around like this?

4. Are there any problems with my transaction in the first window?


Now I'm worried.....


    --- Allan.


PostgreSQL 7.1.2-4PGDG on Linux 2.4.7 i686 SMP (glibc 2.2.2-10)



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

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: Some questions on using arrays.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: VACUUM on database with open transaction returns error?