From: | Dirk Lutzebaeck <lutzeb(at)aeccom(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | vacuum analyze corrupts db with larger tuples (< 8k) |
Date: | 2000-01-04 12:15:59 |
Message-ID: | 14449.58495.638146.353607@ampato.aeccom.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Dirk Lutzebaeck | 2000-01-04 12:27:50 | Re: [BUGS] vacuum analyze corrupts db with larger tuples (< 8k) |
Previous Message | Thomas Lockhart | 2000-01-04 08:11:32 | Re: [BUGS] Date calc bug |