Re: 7.3 backend crash

is it fixed in cvs? if so, i'll compile it to verify.

also, here is a slightly better stack:

Program received signal SIGSEGV, Segmentation fault.
_mdfd_getrelnfd (reln=0x0) at md.c:854
854 fd = RelationGetFile(reln);
(gdb) bt
#0 _mdfd_getrelnfd (reln=0x0) at md.c:854
#1 0x081172b5 in _mdfd_getseg (reln=0x0, blkno=270) at md.c:878
#2 0x08116ce4 in mdwrite (reln=0x0, blocknum=270, buffer=0x82f3850 "")
at md.c:461
#3 0x08117719 in smgrwrite (which=0, reln=0x0, blocknum=270,
buffer=0x82f3850 "") at smgr.c:328
#4 0x0810f42b in LocalBufferAlloc (reln=0x403624a0, blockNum=0,
foundPtr=0xbffff67b "") at localbuf.c:100
#5 0x0810db88 in ReadBufferInternal (reln=0x403624a0,
blockNum=4294967295,
bufferLockHeld=0) at bufmgr.c:144
#6 0x0810db03 in ReadBuffer (reln=0x403624a0, blockNum=4294967295)
at bufmgr.c:112
#7 0x08078852 in RelationGetBufferForTuple (relation=0x403624a0,
len=44,
otherBuffer=0) at hio.c:250
#8 0x080762d6 in heap_insert (relation=0x403624a0, tup=0x404a98f0,
cid=0)
at heapam.c:1162
#9 0x080cd7e0 in ExecSelect (slot=0x828c0c8, destfunc=0x81e6df8,
estate=0x828c000) at execMain.c:1165
#10 0x080cd751 in ExecutePlan (estate=0x828c000, plan=0x828ba68,
operation=CMD_SELECT, numberTuples=0,
direction=ForwardScanDirection,
destfunc=0x81e6df8) at execMain.c:1092
#11 0x080ccc2a in ExecutorRun (queryDesc=0x828bfd8, estate=0x828c000,
direction=ForwardScanDirection, count=0) at execMain.c:195
---Type <return> to continue, or q <return> to quit---
#12 0x0811a1a3 in ProcessQuery (parsetree=0x82772a0, plan=0x828ba68,
dest=Debug, completionTag=0xbffff900 "") at pquery.c:242
#13 0x08118824 in pg_exec_query_string (query_string=0x82760c0,
dest=Debug,
parse_context=0x823fc58) at postgres.c:838
#14 0x081198b1 in PostgresMain (argc=4, argv=0x8226bc8,
username=0x8228428 "postgres") at postgres.c:2016
#15 0x080deb41 in main (argc=4, argv=0xbffffa54) at main.c:235
#16 0x400f71c4 in __libc_start_main () from /lib/libc.so.6
(gdb)

On Mon, 2002-12-16 at 14:46, Tom Lane wrote:
> Brian Hirt <bhirt(at)mobygames(dot)com> writes:
> > Anyway, each query executes by itself, but if i execute both queries in
> > the same session (order doesn't matter), the back end crashes. Maybe it
> > has to do with temp tables?
>
> I'm betting this is the same bug previously recognized in
> LocalBufferAlloc:
>
> http://fts.postgresql.org/db/mw/msg.html?mid=1361296
>
> regards, tom lane
--
Brian Hirt <bhirt(at)mobygames(dot)com>