RE: vacuumdb failed

> -----Original Message-----
> From: Tom Lane
>
> >     Now, I'm not sure if this is related, but while trying to
> do vacuumdb
> > <dbname>, I got...
>
> > NOTICE:  FlushRelationBuffers(all_flows, 500237): block 171439 is
> > referenced (private 0, global 1)
> > FATAL 1:  VACUUM (vc_repair_frag): FlushRelationBuffers returned -2
>
> Probably not related.  We've seen sporadic reports of this error in 7.0,
> but it's been tough to get enough info to figure out the cause.  If you
> can find a reproducible way to create the block-is-referenced condition
> we'd sure like to know about it!
>

The following is an example which doesn't release the reference count.
Neither CommitTransaction() nor AbortTransaction() is called after '\q'

begin;
declare myc cursor for select * from ..;
fetch in myc;
\q

Regards.

Hiroshi Inoue
Inoue@tpf.co.jp