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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-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

Browse pgsql-admin by date

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

Browse pgsql-hackers by date

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