From: Frank van Vugt <ftm.van.vugt@foxi.nl>
To: Jie Liang <jie@stbernard.com>
Cc: pgsql-bugs@postgresql.org
Subject: Re: server terminated by a query in 7.3
Date: Fri, 13 Dec 2002 18:47:39 +0100
Message-ID: <200212131847.39397.ftm.van.vugt@foxi.nl> (raw)
In-Reply-To: <E7E213858379814A9AE48CA6754F5ECB1E1943@mail01.stbernard.com>
References: <E7E213858379814A9AE48CA6754F5ECB1E1943@mail01.stbernard.com>
> after I upgrade my postgresql from 7.2 to 7.3, one query always makes server
> terminated
This is caused by the vacuum of a temp table.
Tom fixed it already about a week ago and provided the patch here:
inline patch 1: src/backend/storage/buffer/localbuf.c Thu Dec 5 17:48:10 2002 (+0/-0 lines) download inline-1.patch*** src/backend/storage/buffer/localbuf.c.orig Wed Sep 4 16:31:25 2002
--- src/backend/storage/buffer/localbuf.c Thu Dec 5 17:48:10 2002
***************
*** 90,108 ****
{
Relation bufrel =
RelationNodeCacheGetRelation(bufHdr->tag.rnode);
- /*
- * The relcache is not supposed to throw away temp rels, so
this
- * should always succeed.
- */
- Assert(bufrel != NULL);
-
/* flush this page */
! smgrwrite(DEFAULT_SMGR, bufrel, bufHdr->tag.blockNum,
! (char *) MAKE_PTR(bufHdr->data));
! LocalBufferFlushCount++;
! /* drop refcount incremented by RelationNodeCacheGetRelation
*/
! RelationDecrementReferenceCount(bufrel);
}
/*
--- 90,113 ----
{
Relation bufrel =
RelationNodeCacheGetRelation(bufHdr->tag.rnode);
/* flush this page */
! if (bufrel == (Relation) NULL)
! {
! smgrblindwrt(DEFAULT_SMGR,
! bufHdr->tag.rnode,
! bufHdr->tag.blockNum,
! (char *)
MAKE_PTR(bufHdr->data));
! }
! else
! {
! smgrwrite(DEFAULT_SMGR, bufrel,
! bufHdr->tag.blockNum,
! (char *) MAKE_PTR(bufHdr->data));
! /* drop refcount incremented by
RelationNodeCacheGetRelation */
! RelationDecrementReferenceCount(bufrel);
! }
! LocalBufferFlushCount++;
}
/*
Regards,
Frank.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ftm.van.vugt@foxi.nl, jie@stbernard.com, pgsql-bugs@postgresql.org
Subject: Re: server terminated by a query in 7.3
In-Reply-To: <200212131847.39397.ftm.van.vugt@foxi.nl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox