Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 44F249FA2CC for ; Tue, 12 Dec 2006 13:39:30 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 81868-04 for ; Tue, 12 Dec 2006 13:39:08 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.178]) by postgresql.org (Postfix) with ESMTP id D90619F9357 for ; Tue, 12 Dec 2006 13:39:07 -0400 (AST) Received: by py-out-1112.google.com with SMTP id a73so616483pye for ; Tue, 12 Dec 2006 09:39:04 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=Q1rv/AmJDOKvFY0EDKYqZVkNYST8U24Wk8BU5bITof+3ysF4VXmKxf9Tbp9naw5L2h5f2vZnWmS4obIFF5nvDSh/jsN0iRuCuGWiFaPmKsdUmgCQA91QruBfJUdZR8WwLEdA5WoVD4YnttMft8uJoZh0a/P39T9VKKb6xd2d+EI= Received: by 10.35.57.5 with SMTP id j5mr15522640pyk.1165945144429; Tue, 12 Dec 2006 09:39:04 -0800 (PST) Received: by 10.35.80.10 with HTTP; Tue, 12 Dec 2006 09:39:04 -0800 (PST) Message-ID: Date: Tue, 12 Dec 2006 23:09:04 +0530 From: "Rajesh Kumar Mallah" To: "Lista Postgres" Subject: query crashes 8.2.0 but not 8.1.5 MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/162 X-Sequence-Number: 23954 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
, 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)