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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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