Re: [ADMIN] VACUUM (vc_rpfheap): BlowawayRelationBuffers returned -2
От | Vadim Mikheev |
---|---|
Тема | Re: [ADMIN] VACUUM (vc_rpfheap): BlowawayRelationBuffers returned -2 |
Дата | |
Msg-id | 35AC67A3.11832CA5@krs.ru обсуждение исходный текст |
Ответ на | VACUUM (vc_rpfheap): BlowawayRelationBuffers returned -2 ("Rob den Boer" <rdboer@hrs-rotterdam.nl>) |
Ответы |
RE: [ADMIN] VACUUM (vc_rpfheap): BlowawayRelationBuffers returned -2
|
Список | pgsql-admin |
Rob den Boer wrote: > > Hi all, > > I noticed that vacuum didnot run correctly, I got following message: > > VACUUM > NOTICE: BlowawayRelationBuffers(invoices, 26): block 27 is referenced > (private 0, last 0, global 1) > FATAL 1: VACUUM (vc_rpfheap): BlowawayRelationBuffers returned -2 This means that 27 block of invoices was referenced by some other backend (but shouldn't!) Unfortunately, I can't reproduce this error... :( BTW, how many connections were present when vacuum was running? > > Next time I start vacuum, I see this: > ERROR: can't create lock file -- another vacuum cleaner running? rm pg_vlock file... Also, I don't know is this in FAQ or not: after getting FATAL you should restart postmaster. > > Should I get worried and keep my backup close at hand? Nothing should be broken by this error... Vadim
В списке pgsql-admin по дате отправления: