Re: vacuums failing

Tom Lane wrote:
>
> Joseph Shraibman <jks@selectacast.net> writes:
> > Could someone please tell me what is going wrong?
> > query: VACUUM  ANALYZE
> > NOTICE:  FlushRelationBuffers(message, 15): block 0 is referenced
> > (private 0, global 2)
> > FATAL 1:  VACUUM (vc_repair_frag): FlushRelationBuffers returned -2
>
> This is probably an artifact of the known bug that 7.0.* forgets to
> run AbortTransaction() if a client disconnects in the middle of a
> BEGIN block.

Ah, I was torture testing my application to see how it handled
application crashes, simulated by making the program exit before it was
done.

  There's no harm to your data, but buffer reference counts
> in shared memory aren't decremented before the backend exits.  So,
> VACUUM gets unhappy because it fears some other backend is touching
> the table it's vacuuming.
>
> Restarting the postmaster should make the symptom go away.  The bug
> itself is fixed for 7.0.3.
>

When is 7.0.3 coming out?


--
Joseph Shraibman
jks@selectacast.net
Increase signal to noise ratio.  http://www.targabot.com