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

Re: BUG #4948: getting error while vacuuming the database

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "fous" <honza801(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4948: getting error while vacuuming the database
Date: 2009-07-28 14:01:37
Message-ID: 16570.1248789697@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"fous" <honza801(at)gmail(dot)com> writes:
> i'm getting this error while vacuuming the database.

> proxylog=# VACUUM ;
> ERROR:  failed to re-find parent key in index "user_day" for deletion
> target
> page 1441795

> does anoyne know, where the problem is?

Nope.

If you just want to fix it, reindexing that index should do the trick.

If you want us to look into what caused it and whether there's a fixable
bug there, we'll need a whole lot more information than the error
message.

			regards, tom lane

In response to

Responses

pgsql-bugs by date

Next:From: Pavel StehuleDate: 2009-07-28 14:59:43
Subject: Re: issue:pgsql trigger with script file
Previous:From: Tom LaneDate: 2009-07-28 13:47:47
Subject: Re: BUG #4949: NOT IN is prohibitive slower than the rewrite for medium to large sets

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