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

Re: BUG #6407: Crash on queries to gin index with multiply values

From: eshkinkot <eshkinkot(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: don(at)rosfirm(dot)ru, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6407: Crash on queries to gin index with multiply values
Date: 2012-02-02 12:44:12
Message-ID: CAJ2ymdgTy=DvQXeUGHRKzE5+Hi2YdS=W_w48vPoamE2ktAjvWQ@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Ah, sorry, looks like it already fixed in
REL9_1_STABLE 5d7d12de56be2c746bfc30214d3300644e8dc0f3

Author: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Date:   Tue Dec 20 19:57:40 2011 -0500

    Fix gincostestimate to handle ScalarArrayOpExpr reasonably.



On Thu, Feb 2, 2012 at 4:35 AM, Sergey Burladyan <eshkinkot(at)gmail(dot)com>wrote:

> Sergey Burladyan <eshkinkot(at)gmail(dot)com> writes:
>
> > #1  0x00007fe1efbbc2b2 in get_leftop (clause=0x7fe1f1d85230) at
> /home/martin/debian/psql/9.1/build-area/postgresql-9.1-9.1.2/build/../src/backend/optimizer/util/clauses.c:189
>
> I set breakpoint at src/backend/optimizer/util/clauses.c:188 and do some
> trace,
> may be this can help:
> Breakpoint 1, get_leftop (clause=0x7fe1f1d5af30)
> (gdb) print *expr
> $1 = {xpr = {type = T_OpExpr}, opno = 96, opfuncid = 65, opresulttype =
> 16, opretset = 0 '\000', opcollid = 0,
>  inputcollid = 0, args = 0x7fe1f1d5cb98, location = 0}
> Breakpoint 1, get_leftop (clause=0x7fe1f1d5c4b0)
> (gdb) print *expr
> $2 = {xpr = {type = T_OpExpr}, opno = 96, opfuncid = 65, opresulttype =
> 16, opretset = 0 '\000', opcollid = 0,
>  inputcollid = 0, args = 0x7fe1f1d5cc40, location = 0}
> Breakpoint 1, get_leftop (clause=0x7fe1f1d5c0b8)
> (gdb) print *expr
> $3 = {xpr = {type = T_ScalarArrayOpExpr}, opno = 96, opfuncid = 65,
> opresulttype = 1, opretset = 0 '\000', opcollid = 0,
>  inputcollid = 4057317752, args = 0x1b, location = -237649736}
>
> --
> Sergey Burladyan
>

In response to

Responses

pgsql-bugs by date

Next:From: sephaliiiDate: 2012-02-02 14:03:29
Subject: BUG #6429: i cannot complete installation due to a forgotten password
Previous:From: Duncan RanceDate: 2012-02-02 10:05:20
Subject: Re: BUG #6200: standby bad memory allocations on SELECT

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