Skip site navigation (1) Skip section navigation (2)

PD_ALL_VISIBLE flag was incorrectly set happend during repeatable vacuum

From: Maxim Boguk <maxim(dot)boguk(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: PD_ALL_VISIBLE flag was incorrectly set happend during repeatable vacuum
Date: 2010-12-25 05:09:32
Message-ID: AANLkTino+Gc2vvOVdzCPRRXW-N7R5=ikYMnNKT5W=mk1@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-hackers
Hi there,

While I trying create reproducible test case for BUG #5798 I
encountered very strange effect on two of my servers (both servers
have same hardware platform/OS (freebsd 7.2) and PostgreSQL 8.4.4).

Very simple test table created as:
CREATE TABLE test (id integer);
INSERT INTO test select generate_series(0,10000);

And I trying repeateble vacuum of that table with script:
 perl -e "foreach (1..100000) {system \"psql -d test -h -c 'vacuum test'\";}"

And once per like an minute (really random intervals can be 5 minutes
without problems can be 3 vacuum in row show same error)  I getting
next errors:
WARNING:  PD_ALL_VISIBLE flag was incorrectly set in relation "test" page 1
...
WARNING:  PD_ALL_VISIBLE flag was incorrectly set in relation "test"
page 30 for all pages of the relation.

After that errors script continue vacuums and after some time (0-1000
vacuum loops) I getting the same errors again and so on.
During test run no one touched the test table except my script.

That happened on both of production servers (slony master and slony
slave). However, I can not reproduce this error on other databases
under my support. Complete server restart doesn't make problem
dissapear.

Any ideas what happens there?

-- 
Maxim Boguk
Senior Postgresql DBA.

Skype: maxim.boguk
Jabber: maxim(dot)boguk(at)gmail(dot)com

LinkedIn profile: http://nz.linkedin.com/in/maximboguk
МойКруг: http://mboguk.moikrug.ru/

Сила солому ломит, но не все в нашей жизни - солома, да и сила далеко не все.

Responses

pgsql-hackers by date

Next:From: Николай ИжиковDate: 2010-12-25 17:55:58
Subject: Archlinux, ossp-uuid
Previous:From: Robert HaasDate: 2010-12-25 04:36:51
Subject: unlogged tables v5

pgsql-admin by date

Next:From: Jasen BettsDate: 2010-12-25 07:41:52
Subject: Re: restore database files
Previous:From: Daniel J. SummersDate: 2010-12-24 02:41:15
Subject: Re: "root" execution not permitted. and busybox

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group