Skip site navigation (1) Skip section navigation (2)

Re: BUG #4113: server closed the connection unexpectedly

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Javier Hernandez <dba(at)loopone(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4113: server closed the connection unexpectedly
Date: 2008-04-21 15:53:53
Message-ID: 20080421155353.GQ6520@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-bugs
Javier Hernandez wrote:

> select * from numeric_col_table where num_col in (select int_col from
> int_col_table);

#0  0x0000000000752368 in pg_detoast_datum (datum=0x1)
    at /pgsql/source/00head/src/backend/utils/fmgr/fmgr.c:2101
#1  0x00000000006bf8bc in hash_numeric (fcinfo=0x7fffc5140550)
    at /pgsql/source/00head/src/backend/utils/adt/numeric.c:1163
#2  0x000000000075081f in FunctionCall1 (flinfo=0xc65688, arg1=1)
    at /pgsql/source/00head/src/backend/utils/fmgr/fmgr.c:1250
#3  0x00000000005898c1 in TupleHashTableHash (key=0x7fffc51409f0, keysize=8)
    at /pgsql/source/00head/src/backend/executor/execGrouping.c:513
#4  0x00000000007550ee in hash_search (hashp=0xc6aec8, keyPtr=0x7fffc51409f0, action=HASH_ENTER, 
    foundPtr=0x7fffc51409ef "") at /pgsql/source/00head/src/backend/utils/hash/dynahash.c:791
#5  0x0000000000589635 in LookupTupleHashEntry (hashtable=0xc68eb8, slot=0xc63078, 
    isnew=0x7fffc5140a6f "") at /pgsql/source/00head/src/backend/executor/execGrouping.c:368
#6  0x000000000059e2e3 in lookup_hash_entry (aggstate=0xc64490, inputslot=0xc63138)
    at /pgsql/source/00head/src/backend/executor/nodeAgg.c:777
#7  0x000000000059e701 in agg_fill_hash_table (aggstate=0xc64490)
    at /pgsql/source/00head/src/backend/executor/nodeAgg.c:1028
#8  0x000000000059e35e in ExecAgg (node=0xc64490)
    at /pgsql/source/00head/src/backend/executor/nodeAgg.c:812


So what's happening here is that it's writing the hash table using the
wrong datatype ...

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2008-04-21 17:09:39
Subject: Re: BUG #4113: server closed the connection unexpectedly
Previous:From: Bruce MomjianDate: 2008-04-21 15:42:37
Subject: Re: BUG #4113: server closed the connection unexpectedly

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group