Re: [HACKERS] select * from ..;vacuum crashes - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject Re: [HACKERS] select * from ..;vacuum crashes
Date
Msg-id 199810060414.NAA04445@srapc451.sra.co.jp
Whole thread Raw
In response to Re: [HACKERS] select * from ..;vacuum crashes  (Bruce Momjian <maillist@candle.pha.pa.us>)
Responses Re: [HACKERS] select * from ..;vacuum crashes  (Bruce Momjian <maillist@candle.pha.pa.us>)
Re: [HACKERS] select * from ..;vacuum crashes  (Bruce Momjian <maillist@candle.pha.pa.us>)
Re: [HACKERS] select * from ..;vacuum crashes  (Bruce Momjian <maillist@candle.pha.pa.us>)
Re: [HACKERS] select * from ..;vacuum crashes  (Bruce Momjian <maillist@candle.pha.pa.us>)
Re: [HACKERS] select * from ..;vacuum crashes  (Bruce Momjian <maillist@candle.pha.pa.us>)
Re: [HACKERS] select * from ..;vacuum crashes  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-hackers
>You must enable Assert to see the crash.

I saw the crash without assertion enabled? This is FreeBSD 2.2.6.

>The cause may be because you are doing a vacuum INSIDE a transaction.  I
>think that also explains the psql -e thing, because that does both
>commands in the same transaction.
>
>Perhaps we need to disable vacuum inside transactions.  Vadim?

FYI, it is reported that 6.3.2 does not have the crash.
--
Tatsuo Ishii
t-ishii@sra.co.jp

pgsql-hackers by date:

Previous
From: "Taral"
Date:
Subject: RE: [HACKERS] select * from ..;vacuum crashes
Next
From: Nick Bastin
Date:
Subject: Re: [HACKERS] select * from ..;vacuum crashes