query crashes 8.2.0 but not 8.1.5

Поиск
Список
Период
Сортировка
От Rajesh Kumar Mallah
Тема query crashes 8.2.0 but not 8.1.5
Дата
Msg-id a97c77030612120939w32ce4192p9b06d49e0f265817@mail.gmail.com
обсуждение исходный текст
Ответы Re: query crashes 8.2.0 but not 8.1.5  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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)

В списке pgsql-admin по дате отправления:

Предыдущее
От: Abu Mushayeed
Дата:
Сообщение: Increase checkpoint segments ?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: query crashes 8.2.0 but not 8.1.5