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, whole thread or download thread mbox)
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 Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg(at)sai(dot)msu(dot)su,
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-2018 The PostgreSQL Global Development Group