Re: [HACKERS] vacuum crash

On Thu, 8 Oct 1998, Thomas G. Lockhart wrote:

> Date: Thu, 08 Oct 1998 06:33:50 +0000
> From: "Thomas G. Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu>
> To: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
> Cc: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>,
> PostgreSQL-development <hackers(at)postgreSQL(dot)org>
> Subject: Re: [HACKERS] vacuum crash
>
> > Here is a modified version of the vacuum crash I am studying.
> > Interesting is that if I do a 'vacuum getting' instead of 'select *
> > from getting;vacuum;', I see a different error message. Rather than a
> > crash due to an Assert(), psql shows:
> > NOTICE: AbortTransaction and not in in-progress state
> > NOTICE: AbortTransaction and not in in-progress state
> > and the postmaster log file shows:
> > ERROR: cannot write block -1 of [] blind
> > AbortCurrentTransaction
> > NOTICE: AbortTransaction and not in in-progress state
> > This can be debugged by commenting out the psql command at the end,
> > running the script, and then running a backend from gdb and doing
> > 'vacuum getting'.
>
> Well Oleg, you are not alone now. Others are seeing your problem, so it
> is much more likely to be fixed than when it was just one person
> reporting the symptom. If you are familiar with backend code then
> perhaps you could help track down the problem. If you aren't familiar
> with it, you may be interested in volunteering to test patches from
> Bruce. This would be especially helpful since you have a real talent for
> demonstrating this problem :)
>
> - Tom
>

Unfortunately I'm not familiar with backend code but would happy
to test everything as soon as patches will be available.

Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83