vacuum analyze corrupts db with larger tuples (< 8k) - Mailing list pgsql-bugs

From Dirk Lutzebaeck
Subject vacuum analyze corrupts db with larger tuples (< 8k)
Date
Msg-id 14449.58495.638146.353607@ampato.aeccom.com
Whole thread Raw
Responses Re: [BUGS] vacuum analyze corrupts db with larger tuples (< 8k)  (Dirk Lutzebaeck <lutzeb@aeccom.com>)
Re: [BUGS] vacuum analyze corrupts db with larger tuples (< 8k)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
ok, here is what I have found out on 6.5.3, Linux 2.2.10:


DROP TABLE buf;
CREATE TABLE buf (s varchar(5000)); -- type TEXT is the same prob
COPY buf FROM stdin;
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\
[... almost 5k ...]
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\
[... almost 5k ...]
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\

[ 10 times ]
\.

# vacuumdb --analyze test
ERROR:  Tuple is too big: size 9604
vacuumdb: database vacuum failed on test.

- this is repeatable
- in in this test the db isn't corrupted but in our production db :(
- Tom, you made a remark that you found a bug in access/hio.c.
  Does the bug also hit here?


Dirk

pgsql-bugs by date:

Previous
From: wrobell
Date:
Subject: A bug
Next
From: Dirk Lutzebaeck
Date:
Subject: Re: [BUGS] vacuum analyze corrupts db with larger tuples (< 8k)