| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Hitesh Bhambhani <hiteshb(at)asg(dot)com> |
| Cc: | pgsql-bugs <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Re: BUG #5599: Vacuum fails due to index corruption issues |
| Date: | 2010-08-05 03:29:31 |
| Message-ID: | 1280978913-sup-5475@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers |
Excerpts from Hitesh Bhambhani's message of mié ago 04 17:47:12 -0400 2010:
> Based on some logs in the Webapp I can see that there were some errors in
> truncating relations. Once those errors disappear the index corruption
> errors start. I'm not sure if there is a connection here.
There probably is. What kind of relation are the ones unable to
truncate? Please see in pg_class where relfilenode = '41274' in this
case:
> bad SQL grammar []; nested exception is org.postgresql.util.PSQLException:
> ERROR: could not truncate relation 1663/16403/41274 to 30 blocks: Permission
> denied
--
Álvaro Herrera <alvherre(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2010-08-05 03:31:17 | Re: BUG #5595: Documentation is not installs from VPATH build. |
| Previous Message | Alvaro Herrera | 2010-08-05 03:20:36 | Re: BUG #5595: Documentation is not installs from VPATH build. |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2010-08-05 03:46:07 | Re: Two different methods of sneaking non-immutable data into an index |
| Previous Message | Andrew Dunstan | 2010-08-05 03:03:59 | Re: documentation for committing with git |