Re: [HACKERS] vacuum crash
От | Oleg Bartunov |
---|---|
Тема | Re: [HACKERS] vacuum crash |
Дата | |
Msg-id | Pine.GSO.3.96.SK.981008114347.22375F-100000@ra обсуждение исходный текст |
Ответ на | Re: [HACKERS] vacuum crash ("Thomas G. Lockhart" <lockhart@alumni.caltech.edu>) |
Список | 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@alumni.caltech.edu> > To: Oleg Bartunov <oleg@sai.msu.su> > Cc: Bruce Momjian <maillist@candle.pha.pa.us>, > PostgreSQL-development <hackers@postgreSQL.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@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83
В списке pgsql-hackers по дате отправления: