Bug in vacuum on 7.2.4?
От | Ryan Bradetich |
---|---|
Тема | Bug in vacuum on 7.2.4? |
Дата | |
Msg-id | 1046402565.26261.74.camel@beavis.ybsoft.com обсуждение исходный текст |
Список | 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@uswest.net>
В списке pgsql-hackers по дате отправления: