Re: Query crashes/hangs server
Tatsuo Ishii <t-ishii@sra.co.jp>
From: Tatsuo Ishii <t-ishii@sra.co.jp>
To: tgl@sss.pgh.pa.us
Cc: pgman@candle.pha.pa.us, pgsql-hackers@postgresql.org
Date: 2005-03-18T07:55:42Z
Lists: pgsql-hackers
> Bruce Momjian <pgman@candle.pha.pa.us> writes: > > I recieved this report of a failing set of queries: > > Fixed. ShutdownPostgres needs to be sure we've released buffer pins > before it tries to drop newly-created files. This has actually been > wrong all along, but it is masked pre-8.0 because DropRelFileNodeBuffers > was willing to arbitrarily throw away a pin on a victim buffer. > I thought that was a bad idea and took it out, expecting that we'd find > any bad consequences a bit quicker than this ... It seems your patches do not fix the case when the table is a temporary table... -- Tatsuo Ishii