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

Re: [HACKERS] vacuum crash

From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu>
Cc: hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] vacuum crash
Date: 1998-10-08 08:45:34
Message-ID: Pine.GSO.3.96.SK.981008114347.22375F-100000@ra (view raw or flat)
Thread:
Lists: pgsql-hackers
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


In response to

pgsql-hackers by date

Next:From: Horak DanielDate: 1998-10-08 09:26:15
Subject: RE: [HACKERS] NT port of PGSQL - success
Previous:From: Thomas G. LockhartDate: 1998-10-08 07:26:18
Subject: Re: [HACKERS] Dumping of views -- done!

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