From: | Ryan Bradetich <rbradetich(at)uswest(dot)net> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Bug in vacuum on 7.2.4? |
Date: | 2003-02-28 03:22:46 |
Message-ID: | 1046402565.26261.74.camel@beavis.ybsoft.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Is there a known bug/race condition in vacuum on 7.2.4?
I find this error in my log files about once a week, but
it is not reproducable manually.
NOTICE: Index pg_statistic_relid_att_index: Pages 5; Tuples 410:
Deleted 449.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
ERROR: MemoryContextAlloc: invalid request size 0
NOTICE: Index pg_statistic_relid_att_index: Pages 5; Tuples 551:
Deleted 71.
CPU 0.00s/0.01u sec elapsed 0.00 sec.
ERROR: MemoryContextAlloc: invalid request size 0
Running the vacuum again after the error occurs appears to work fine:
NOTICE: Index pg_statistic_relid_att_index: Pages 5; Tuples 403:
Deleted 167.
CPU 0.00s/0.01u sec elapsed 0.00 sec.
The vacuum command is run (nightly) as follows:
/opt/pgsql/bin/vacuumdb -a -v -z -f -e
Thanks,
- Ryan
P.S.
I just removed the -z and -e options, will run with that and see if I
can reproduce it again. (I'll run the analyze with the non-full
vacuums).
--
Ryan Bradetich <rbradetich(at)uswest(dot)net>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-02-28 03:39:14 | Re: Brain dump: btree collapsing |
Previous Message | Christopher Kings-Lynne | 2003-02-28 02:49:05 | new format for psql \d |