Skip site navigation (1) Skip section navigation (2)

Re: BUG #5599: Vacuum fails due to index corruption issues

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 (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-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

In response to

Responses

pgsql-hackers by date

Next:From: Merlin MoncureDate: 2010-08-05 03:46:07
Subject: Re: Two different methods of sneaking non-immutable data into an index
Previous:From: Andrew DunstanDate: 2010-08-05 03:03:59
Subject: Re: documentation for committing with git

pgsql-bugs by date

Next:From: Tom LaneDate: 2010-08-05 03:31:17
Subject: Re: BUG #5595: Documentation is not installs from VPATH build.
Previous:From: Alvaro HerreraDate: 2010-08-05 03:20:36
Subject: Re: BUG #5595: Documentation is not installs from VPATH build.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group