query crashes 8.2.0 but not 8.1.5

From: "Rajesh Kumar Mallah" <mallah(dot)rajesh(at)gmail(dot)com>
To: "Lista Postgres" <pgsql-admin(at)postgresql(dot)org>
Subject: query crashes 8.2.0 but not 8.1.5
Date: 2006-12-12 17:39:04
Message-ID: a97c77030612120939w32ce4192p9b06d49e0f265817@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

below query crashes 8.2.0

tradein_clients=> SELECT size from general.eyp_listing where size in
(select distinct size from general.eyp_listing ) order by size limit
1;
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Succeeded.
tradein_clients=> \q

Regds
mallah.

backtrace is below:

(gdb) bt
#0 0x40098d71 in kill () from /lib/i686/libc.so.6
#1 0x40098af5 in raise () from /lib/i686/libc.so.6
#2 0x4009a1e0 in abort () from /lib/i686/libc.so.6
#3 0x08259ce5 in ExceptionalCondition (conditionName=0x8303c00
"!(var->vartypmod == att_tup->atttypmod)", errorType=0x8282d14
"FailedAssertion",
fileName=0x6 <Address 0x6 out of bounds>, lineNumber=219) at assert.c:51
#4 0x0815d95f in tlist_matches_tupdesc (ps=0x8431f04,
tlist=0x4019c9a0, varno=2, tupdesc=0x842ec3c) at execScan.c:219
#5 0x0815d830 in ExecAssignScanProjectionInfo (node=0x8431f04) at
execScan.c:184
#6 0x0816c659 in ExecInitSubqueryScan (node=0x8423ed8,
estate=0x842ce1c, eflags=0) at nodeSubqueryscan.c:213
#7 0x08157a47 in ExecInitNode (node=0x8423ed8, estate=0x842ce1c,
eflags=0) at execProcnode.c:189
#8 0x08169b81 in ExecInitSort (node=0x8424188, estate=0x842ce1c,
eflags=0) at nodeSort.c:197
#9 0x081579be in ExecInitNode (node=0x8424188, estate=0x842ce1c,
eflags=8) at execProcnode.c:230
#10 0x08168280 in ExecInitMergeJoin (node=0x8424318, estate=0x842ce1c,
eflags=8) at nodeMergejoin.c:1539
#11 0x081579f7 in ExecInitNode (node=0x8424318, estate=0x842ce1c,
eflags=0) at execProcnode.c:212
#12 0x0816a710 in ExecInitLimit (node=0x84243a4, estate=0x842ce1c,
eflags=0) at nodeLimit.c:327
#13 0x08157958 in ExecInitNode (node=0x84243a4, estate=0x842ce1c,
eflags=0) at execProcnode.c:260
#14 0x0815557c in InitPlan (queryDesc=0x842ca40, eflags=0) at execMain.c:628
#15 0x08154dd9 in ExecutorStart (queryDesc=0x842ca40, eflags=0) at
execMain.c:171
#16 0x081e5632 in PortalStart (portal=0x841c4b4, params=0x0,
snapshot=0x0) at pquery.c:426
#17 0x081e1314 in exec_simple_query (
query_string=0x83e905c "SELECT size from general.eyp_listing
where size in (select distinct size from general.eyp_listing ) order
by size limit 1;") at postgres.c:902
#18 0x081e4932 in PostgresMain (argc=4, argv=0x8396f2c,
username=0x8396efc "tradein") at postgres.c:3419
#19 0x081bb396 in BackendRun (port=0x839e9a8) at postmaster.c:2926
#20 0x081babde in BackendStartup (port=0x839e9a8) at postmaster.c:2553
#21 0x081b8db7 in ServerLoop () at postmaster.c:1206
#22 0x081b822d in PostmasterMain (argc=1, argv=0x83937d8) at postmaster.c:958
#23 0x08177117 in main (argc=1, argv=0x1) at main.c:188
#24 0x40085c57 in __libc_start_main () from /lib/i686/libc.so.6
(gdb)

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2006-12-12 17:48:28 Re: query crashes 8.2.0 but not 8.1.5
Previous Message Abu Mushayeed 2006-12-12 17:17:17 Increase checkpoint segments ?